People Movers LLC (HP/CGI)

People Movers LLC (HP/CGI)

May 2010 – August 2010

Crystal Reports / Data Analyst

  • Editing existing Crystal Reports for incompatibles with current Health Care System.
  • Modifing data sources to access correct data bases (SQL Server)
  • Modifing report formulas to use correct data fields and produce correct results
  • Modifing report formatting to current client standards
  • Working remote on rush project (9-10 hours daily, 6 days/week)
  • Skills and Procedures Used:
    • Crystal Reports XI R2
    • MS SQL Server Management Studio

TEKsystems

TEKsystems (Aurora Bank)

Nov 2009 to May 2010

• Converting SQL queries to reporting formats utilizing Crystal Reports 2008, Web Intelligence (WebI) 3.1, Desk Intelligence (DeskI) 3.1, Excel/Access 2007

• Scheduling converted reports in Business Objects Xi R3.1

• Rewriting/combining SQL queries for SQL Server 2005 in order to facilitate conversion process.

• Automating Excel 2008 with VBA for reports that could not be converted

• Skills and Procedures used:

o SQL Server 2005 Management Studio

o Business Objects Xi R3.1

o Business Objects Web Intelligence (WebI) 3.1, Desk Intelligence (DeskI) 3.1

o Microsoft Office 2007 (Excel, Word, Access), Excel VBA

LPS, Inc.

LPS, Inc. (Lender Processing Services) Oct 2007 to Feb 2009

• Designing and modifying reports for proprietary real estate tracking application utilizing Crystal Reports XiR2

• Assess needs, requirements and layout for Business Objects Xi R2 Universe

• Develop and maintain additional reports using MS-Access 2003 writing advanced queries and VBA code modules

• Backend databases consisted of MS-SQL Server 2005, MS-Access 2003

• Skills and Procedures used:

o Crystal Reports Xi R2

o MS-SQL-Server 2005 Management Studio

o MS-Access 2003

o Toad (Quest Software) to query SQL database to create queries, views, and procedures

Genesis Group

Genesis Group Jan 2007 to Sep 2007

• Creating Crystal Reports and Web Intelligence reports utilizing Business Objects XiR2 Universe and Oracle 9i

• Skills and Procedures used:

o Crystal Reports Xi R2 — Business Objects Xi R2

o Toad (Quest Software) to query Oracle database with PL/SQL to create queries, views, and procedures

o WebElements – an add-on from Business Objects that allows user interactivity with Crystal Reports XiR2 and BOXi R2

Vision Harvest Inc.

Vision Harvest Inc. July 2004 to Sept 2006

August 2001 to Sept. 2002

May 98 to Sept. 2000

• Meet with clients to discuss business methodology and result expectations. Created/modified report requirements documents based on discussion and feedback with users/developers.

• Training and consulting with Business Objects Crystal Reports v5, 6, 7, 8, 8.5, 9, 10, Xi, Crystal Enterprise. Editing/updating training manuals for Crystal Reports and Enterprise classes.

• Traveling to different cities to teach 2 day Crystal Reports/Designer 1, 2 day Crystal Reports/Designer 2, 2 day Crystal Reports/Designer 3 and 2 day Enterprise Administer classes for public and private custom classes.

• Consulting with various companies designing reports utilizing a variety of databases including: MS-Access, MS-SQL Server, Oracle and Sybase

• Skills and Procedures used:

o Crystal Reports v5 through Xi R2

o Toad (Quest Software) to query Oracle database with PL/SQL to create queries, views, and procedures

o SQL Server Enterprise Manager with T-SQL to create queries, views and procedures

o Crystal/Business Objects Enterprise v10, Xi

AlloSource

AlloSource Nov 2003 to June 2004

• Design and develop Crystal Reports from Oracle and Microsoft SQL Server databases for bone and tissue company.

• Write Oracle stored procedures for use in report creation for laboratory technicians. Procedures were optimized by DBA for speed (reports had maximum run time of 30sec).

• Add reports to proprietary application utilizing Active Server Pages and Microsoft Visual Studio.

• Skills and Procedures used:

o Toad (Quest Software) to query Oracle database

o PL/SQL for queries, views and stored procedures

o Microsoft Visual Studio ( to run reports with an ASP front end)

o Crystal Reports v8.5, 9, 10

Tiger Technologies

Tiger Technologies Sept 2002 to Nov 2003

• Design and develop Crystal Reports from Sybase and Microsoft SQL Server databases for electronic and Internet voting systems.

• Troubleshoot and consult with system engineers about stored procedures and database views.

• Consulting with sales staff and corporate training department about report requirements and custom reporting needs.

• Skills and Procedures used:

o Crystal Reports v8.5, 9

o SQL Enterprise to query database and test queries

Maxim Group

Maxim Group May 2001 to Aug 2001

• Design and develop Crystal Reports from MS-SQL Server database. Using SQL-Server Enterprise Manager to design data views when necessary.

• Skills and Procedures used:

o Crystal Reports v8, 8.5

o MS-Visual Studio – reports were added to existing application allowing users to select parameters from a ASP front end

Hall Kinion

Hall Kinion Jan 2001 to May 2001

• Design and develop Crystal Reports from MAS90 accounting system. Using Microsoft Access to pull data from MAS90 server as intermediary step.

• Created procedures for distribution of reports using Crystal Web Server or Active Server Pages or Seagate Info.

• Skills and Procedures used:

o Crystal Reports v8.5, 9 — MAS90 accounting software

o MS-Access to transfer data from MAS90 to Crystal Reports

Sapphire Technologies

Sapphire Technologies Oct. 2000 to Dec 2000

• Design reports based on client requirements. Using Seagate Crystal Reports, Seagate Info, ASP, and HTML.

• Required reports used Oracle views and Crystal queries to access data. Oracle system would receive up to 50,000 documents per day; views and queries summarized data to reduce number of records required for reports.

• Reports were generated based on daily, weekly, monthly, quarterly and year-to-date time frame, exported to HTML and Excel formats. Users displayed HTML pages utilizing ASP to select regional center, time frame and format for viewing.
• Skills and Procedures used:

o Crystal Reports v7, 8, 8.5
o Seagate Info (predecessor to Business Objects Xi R1) to store and schedule reports
o Toad to query Oracle database and create queries and views