Business Data Analyst, Database Administrator, Report Developer
Design Group Staffing Inc.
February 1997 – June 2011
Designed ETL packages using MS SQL Server Integration Services 2005, for a variety of applications:
Used SSIS to synchronize user data between Active Directory and other user databases (Payroll system, PAM, front office)
Used SSIS to import contractor timesheet data into PAM system
Used SSIS to integrate timesheet data between 2 different systems, for reporting purposes
Designed packages for a variety of database maintenance tasks
Collaborated with a colleague to introduce a Business Intelligence dashboard for both internal users and external customers. The dashboard was built using Intrexx Xtreme portal software, SSIS 2005, and reporting tool iReports.
Worked with Accounting staff to customize "out of the box" OLAP Analysis cubes using MS SQL Server Analysis Services 2005.
Designed custom objects using T-SQL, such as tables, views, stored procedures, functions, for the migration of data from legacy front-office solution to new software.
Key technical representative on project team for implementation of Great Plains & PAM software (accounting package and staffing agency add-in, respectively)
Designed DTS packages for moving data between Great Plains/PAM and legacy payroll system
Designed custom objects such as views, functions, stored procedures in SQL
Designed and deployed custom financial reports using a variety of reporting tools:
Crystal Reports 11.0 Developer
Great Plains Report Writer
Great Plains/ PAM SmartList Builder
Maintained close working relationship with Executive and Branch Managers
Provided support to operations and administrative groups
Created SQL databases for tracking critical operations information
Documented operational procedures and practices
Designed, developed and implemented KPI reports using Crystal Reports 11.0 Developer, Crystal Enterprise 9.0, Transact SQL, SQL Server 2000
Business needs analysis
Design report layouts
Develop database objects including views, tables, stored procedures, trig