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

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

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

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