Robert Half Technology

Robert Half Technology (ID Watchdog; Colorado Coalition for the Homeless)

Jul 2009 to Nov 2009

Mar 2009 to May 2009

• Converting Access reports to Crystal Reports Xi.

• Publishing and scheduling reports in Crystal Server

• Analyzing data to determine current retention rates and pricing models for current and future products for an online ID monitoring company

• Designing and modifying reports for PostgreSQL database using Crystal Reports 2008.

• Using Toad to create needed queries and determine whether to create tables or copy the queries into Crystal Reports SQL commands.

• Working with DBA and programmers to find or build the most efficient method for report distribution.

• Skills and Procedures used:

o Crystal Reports 2008, XiR2

o Toad for Data Analysts connecting to a PostgreSQL and SQL Server databases

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

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