Prodigy Resources LLC (Reed Group)

Prodigy Resources LLC (Reed Group)

August 2010 – May 2011

Reporting Analyst/Data Analyst

  • Converting reports currently created using SAS to Crystal Report 2008
  • Converting Crystal Reports to MS SQL Server Reporting Services 2008 R2
  • Designing complex reports from user specifications utilizing SQL Server Management Studio, SQL Server Reporting Services, MS Reporting Server 2008 R2
  • Editing and running reports based on client changes and schedules.

Skills and Procedures used:
SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2 Management Studio
Microsoft Office 2007 (Excel, Word, Access), Excel VBA

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

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

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