Advanced SQL Development.Data Architecture.Requirements definition.Backup and disaster recovery planning and assessment.Performance tuning.ETL development.Data flow automation.Data migrations.Training.

Create and maintain centralized data warehouse using data vault methodology.Develop, test, and implement reporting frameworks.Administer and backup over 45 SQL Servers (SQL 2005, SQL 2008, SQL 2012, and SQL 2014).Implemented supplemental processes to backup logins, server roles, and agent jobs for shorter disaster recovery downtimes.Create and maintain centralized SQL Server summary data collection and reporting process capturing significant events for all SQL Servers such as DDL changes, failed logins, database file growth events, SQL Agent job failures, and drive space changes.Automated standardized SQL Server installation and configuration using T-SQL and PowerShell.Administer SharePoint site access as well as editing and creating SSRS reports published to site.Create processes for automated provision of data to third party services for e-invoicing and check fraud prevention.Create data flows and algorithms for parsing X12 Advance Ship Notice Electronic Data Interchange files into relational database information.Draft knowledge base documentation of internal process, applications, procedures, and structures.Oversee and collaborate with web developer on custom built data driven web applications.Provide support and troubleshooting for third party applications’ backend databases.Supervise and direct database developer.Provide Help Desk support to end users for data issues and applications.

Develop and update data architecture to support project goals and deliverables.Design, implement, and maintain multiple enterprise level SQL processes.Draft and maintain detailed documentation to guide project efforts and facilitate transfer of responsibilities.Build SSIS packages to load data from a variety of sources.Create SSRS reports to provide visibility into data and perform quality control measures.Create OLAP cubes for secondary validation of summary results.Design and populate SQL Server databases to support .NET web applications and direct offshore resources regarding updates to web applications.Administer SQL Server (manage user access, database backups, and storage usage).Write T-SQL scripts to provide ad-hoc summaries at clients’ request.Manage 2-3 Data Analysts.Develop training materials for newly hired Data Analysts.Communicate status of projects and resources to senior management.

Produced longitudinal reports detailing performance of select pharmaceuticals relative to competitors by geographic area to evaluate efficacy of sales efforts.Automated several processes for downloading client data and created error notification systems, maximizing data availability and reducing staffing burden outside of business hours.Developed and maintained an internal Windows application allowing non-technical users to easily query and view information.Published a library of general use SAS and VBA routines and tools to improve overall office productivity.Taught SAS and VBA courses to colleagues in the Indianapolis office and at Milliman’s annual multi-office Health Consultant’s Forum.

Designed data collection forms, database structure, and quality control processes for National Institute of Health and National Institute on Aging funded studies.Developed an ASP.NET Intranet website that allowed sharing of important files and downloading of pre-defined data table definitions to minimize database development time and effort.Built an Excel-based data dictionary template that automatically generated SQL Server scripts to create the requisite database tables and data integrity constraints.

Drafted and edited reports to the Federal Energy Regulatory Commission evaluating operation and pricing activity.Monitored pricing and generation data for indicators of anti-competitive behavior by utility companies.