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

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