Summary
Overview
Work History
Education
Skills
Timeline
Generic

Michael Harmon

Destin,FL

Summary

Highly skilled Senior Data Engineer with over 10 years of experience in designing, developing, and managing data infrastructure and pipelines. Proven expertise in big data technologies and cloud platforms, with a strong ability to transform business requirements into scalable data solutions. Strong collaborator with a passion for data architecture, performance optimization, and ensuring data integrity.

Overview

14
14
years of professional experience

Work History

Sr Data Integration Engineer/Analyst

Watco
Overland Park, KS
03.2021 - 08.2024
  • Developed ETL integrations to ingest and transform data from various sources into a centralized repository.
  • Provided architectural guidance across teams to advance the ETL tools used to develop a cohesive integration roadmap.
  • Assisted in the implementation of data governance policies and best practices to improve data quality.

Data Scientist

Rx Savings Solutions
Overland Park, KS
11.2018 - 12.2020
  • Led Business Intelligence and Analytics team in evaluation and implementation of new BI (Tableau) and Data Science (AWS data lake using Databricks) software solutions.
  • Developed advanced analytics reporting using combinations of Talend, R, Tableau, and SiSense to provide near real-time reporting on prescription claims processing and client savings.
  • Implemented an in-house analytics application to present clients with meaningful insight and trending into specific subjects of prescription spending, including High Cost Low Value, Fraud Waste and Abuse, Specialty Drug spending, Maintenance Medication, Adherence, and others.

ETL Consultant

AMC Entertainment
Overland Park, KS
07.2017 - 11.2018
  • Designed ETL applications to extract real-time data and perform aggregation of international performance statistical data to generate dashboard reports.
  • Created ETL applications and algorithm development, ingesting data in various formats, utilized in forecasting to predict market-specific new release revenue models.
  • Developed seat-heat mapping to map theatre reserved seating data, drillable to individual seat level.

ETL Application Developer

Blue Cross and Blue Shield of Kansas City
Kansas City, MO
01.2011 - 07.2017
  • Designed and developed ETL applications for data to State of KS, State of MO and Affordable Care Act, including a claim resubmission process generating over $50 million in revenue annually.
  • Analyze, develop, and maintain ETL extracts with IBM DataStage on DB2, MS SQL Server 2012, and MySQL database platforms, including 880 databases and over 1.4 Petabytes of storage, and 5,000 daily backups.
  • Troubleshoot and maintain claims data warehouse applications housing over 400 million claim records on 2,500 tables across 11 instances and 23 databases.

Education

Master of Science - Information Technology

University of Kansas
Lawrence, KS
05-2016

Bachelor of Science - Management Information Systems

Columbia College
Columbia
05-2013

Skills

  • Languages: SQL, Python, Java, R, PHP
  • Big Data Technologies: Databricks, Apache Spark, Azure Data Factory
  • Cloud Platforms: AWS S3, Azure
  • ETL Tools: SAP Business Objects, Microsoft SSIS, DataStage, Talend
  • Data Visualization: Tableau, Power BI, SiSense

Timeline

Sr Data Integration Engineer/Analyst

Watco
03.2021 - 08.2024

Data Scientist

Rx Savings Solutions
11.2018 - 12.2020

ETL Consultant

AMC Entertainment
07.2017 - 11.2018

ETL Application Developer

Blue Cross and Blue Shield of Kansas City
01.2011 - 07.2017

Master of Science - Information Technology

University of Kansas

Bachelor of Science - Management Information Systems

Columbia College

Similar Profiles

CREATE PROFILE
Michael Harmon