Alpine Access – Sykes

Alpine Access – Sykes

June 2011 – Aug 2013

SQL Report Writer

  • Writing T-SQL Stored Procedures for reports using SQL Server Management Studio 2008
  • Designing report utilizing MS-SQL Server 2008 R2 Reporting Services
  • Designing complex reports from user specifications utilizing MS-SQL Server Management Studio, MS-SQL Server Reporting Services, MS Reporting Server 2008
  • SSRS Report Builder 3
  • Modifying stored procedures and reports based on new and current client needs.
  • Editing and running reports based on client changes and schedules.

Skills and Procedures used:
SQL Server 2008 R2 Reporting Services
SQL Server 2008 Management Studio
SSRS Report Builder 3
Microsoft Office 2007/2010 (Excel, Word, Access), Excel VBA

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

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

32-Solutions, Inc.

32-Solutions, Inc. May 2009 to Jul 2009

• Analyze data for ecommerce company to determine best methodology for presenting data.

• Designing and modifying reports for MySQL database using Jasper iReports and JasperServer

• Using DBVisualizer to create needed queries and copy queries into iReports.

• Create reports for Sales, Publishers, Affiliates, Customer Relation Phone System

• Skills and Procedures used:

o JasperServer 3.5 — iReports 3.5.2

o DBVisualizer 6.5

o MySQL database

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

Intecon USA

Intecon USA Sept 2006 to Jan 2007

• Converting Oracle Reports to Crystal Reports Xi

• Setting up and configuring Business Objects Xi Release 2

• Skills and Procedures used:

o Crystal Reports Xi — Business Objects Xi Release 2

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

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