Summary

A professional, proactive, and collaborative individual with strong management, analytic, and multi-tasking skills with extensive experience in ETL development, database administration, data warehousing, SQL optimization, and translating business requirements into solutions that provide business value. Experience in the Healthcare and Casino industries.

Experience

Cotiviti/HMS -- Principal Software Engineer 2017-Present

Complex SQL development, optimization, and process improvement. Dynamic SQL.

Creation of Error Handling and process tracking structures and procedures.

Process documentation with Visio. Turning workflows into database procedures.

Processing/Querying CMS/VA data, ad-hoc reports, letter generation

Creating and adjusting indexes, reading execution plans for optimizing SQL code.

Ad hoc querying and reporting.

Debugging, repairing, and modifying ETL code.

Creation of developer toolkit to assist developers performing routine tasks.

Pinnacle Entertainment – ETL/BI Architect 2008-2015

Modified existing ETLs to increase performance by 50 percent through index analysis and optimization.

Created and deployed new ETLs to streamline business processes and reporting.

Worked closely with business partners to troubleshoot existing issues and define new requirements to increase analytic business value.

Created and extended Data Warehouse relational and multi-dimensional data models.

Worked on ETL, BI, and database projects with a strong emphasis on the software development lifecycle methodology and industry best practices.

Trained users on new implementations through one-on-one interaction and classroom style instruction.

Validated Enterprise Data Warehouse data through all steps of ETL back to source data systems.

SQL Server stored procedure, view, function, and table creation along with index optimization.

Met or exceeded project timelines, often up to a week or more before project is due.

Salesforce administration.

Maintained Teradata and SQL database users, roles, and profiles.

Teradata creation of tables, index, and views, database optimization and capacity planning.

Created SSRS reports for the various casino properties in the areas of POS, Title 31, and Veridocs, for example tip reports, summaries by Server, and property daily gross amounts. Managed SSRS site security.

SQL Development includes use of common table expressions, analytical functions. Extensive T-SQL. Creation of audit and error logging databases. Use of both physical and functional temp tables. ETL creation using stored procedures, functions, views, and SQL Agent jobs. Creation of stored procedures for parameter driven SSRS reports.

Education

BA University of Maine, 1989

Certificates:

Skills

Data modeling (3+ years)

SQL Server (20+ years)

Query Optimization (10+ years)

Teradata (4+ years)

Salesforce (3+ years)

Office (10+ years)

SSRS (3+ years)

SAS Enterprise Guide (3 years)

Gathering and storing Metadata (2+ years)

Dataflux (2 year)

Gaming Experience (7+ years)

Hotel Experience (4+ years)

Healthcare Experience (5+ years)

Visio (5+ years)

ServiceNow (4+ years)

Jira (2+ years)

GIT (2+ years)

VBA (5+ years)

SSIS (1+ years)

SAFE (2+ years)

Contact this candidate