Lead developer on a data warehouse team mentoring junior developers.+ Developed and maintained new and several complex legacy databases, SSIS ETLs includingC# API calls, stored procedure based processes, and SSRS reports.+ Created and maintained database processes supporting predictive analytics based shipmentdata entry system, international commissions system, U.S. Government API sourced importand export data-based reporting, configurable data-based ad-hoc SQL reporting system.

Hired as a full-time employee after being a long term consultant.+ Developed, maintained and expanded data warehouse with data used in analysis in a widerange of analysis. ETL included sourcing data from IBM DB2 systems, MySQL and several SQL Serverdatabases and several inbound and outbound daily file feeds with partner businesses.+ Maintained and expanded a SQL Server Analysis Services cube including cube processing,dimensions, measures, data sources, data source views and reporting actions. Developed and maintained database integration packages using SSIS and SSRS reports.Managed SSRS with report subscriptions using report manager and custom PowerShellscripting.+ Created multiple data marts to provide end users with the ability to created reports andanalyze data quickly.

CLIENT: MULTI-NATIONAL RETAILERClient needed to temporarily back-fill a SQL Server database developer need. High quality and volume of work led to becoming a long term consultant.+ Developed, maintained and expanded data warehouse with data used in analysis in a widerange of analysis.+ ETL included sourcing data from IBM DB2 systems, MySQL and several SQL Server databases and several inbound and outbound daily file feeds with partner businesses.+ Maintained and expanded a SQL Server Analysis Services cube including cube processing,dimensions, measures, data sources, data source views and reporting actions.+ Developed and maintained database integration packages using SSIS and SSRS reports.Managed SSRS with report subscriptions using report manager and custom PowerShellscripting.+ Created multiple data marts to provide end users with the ability to created reports andanalyze data quickly.CLIENT: FINANCIAL SERVICES COMPANYClient wanted to create end-customer facing reports.+ Created report mock-ups, worked with management to refine requirements, and broughtthem to a production state.+ Developed end client facing SSRS reports including graphs and charts with custom colorschemes along with underlying stored procedures and functions.CLIENT: FINANCIAL SERVICES COMPANYClient needed assistance with reporting in a complex environment.+ Developed and maintained SSRS reports with stored procedures in a reportingenvironment that contained multiple databases for several interlinked systems.

Application Development SupervisorSupervised a team including staff that could each fill any role within the data services group:database development for projects, production support and quality assurance.+ Role included staff management, resource planning and allocation, training, andmentoring, while still performing development work.Senior Programmer AnalystReturned to the Univita Health data services group in 2010, focusing on reports and data feeds.+ Created a reusable data driven dynamic SSIS package that led to a dramatic increase inproductivity and increased supportability.Software Developer/Data ArchitectIn January 2008, recruited to join a data conversion group that was dedicated to converting amassive amount of client data into an in-house administrative system.+ Quickly learned in great technical detail a complex insurance claim administration system.+ Traveled to client sites meeting with technical staff to learn details of how source systemscreated, used, and stored data.+ Analyzed client data from three active and two archived systems, along with other sourcesin database, text file and spreadsheet formats.+ Architected and designed SQL Server databases and T-SQL and SSIS processes to import,interpret, transform, and load the converted data into an in-house system.+ Worked with all levels of staff in exception reporting, testing and debugging.+ Produced a large volume of documentation and data reporting.Senior Programmer AnalystStarted in a contract-to-hire position and was quickly hired as a permanent employee.+ Worked with end users, technical and non-technical business analysts, project managers,quality assurance analysts and developers in the entire life cycle of ETL processes andreports.

Extensive database and application development throughout the entire development life cycleincluding worked with users at all levels of the company to determine requirements, functionalityand to design interfaces, writing user manuals and provided user training.

Created and executed conversion scripts and routines from legacy database systems and nondatabasesystems into an in-house SQL Server based system.

Automated and streamlined procedures making the company more productive and data reportingmore accurate.

Developed legal case tracking database applications including evaluating existing applications and the needs of the departments involved to gather, store, track and report on information, and creating and upgrading applications to meet those needs.