Summary
Overview
Work History
Education
Skills
Timeline
Generic

John Forbes

Gillette

Summary

Accomplished Senior Data Engineer at Optum with 18 years of expertise in ETL development and advanced SQL. Successfully integrated healthcare data systems, enhancing data exchange efficiency. Proven mentor, fostering teamwork and problem-solving skills among junior staff. Committed to optimizing data pipelines and ensuring data integrity in complex environments.


Overview

18
18
years of professional experience

Work History

Senior Data Engineer

Optum
10.2007 - Current
  • Created ETL and SSIS packages to run in Active Batch for Datawarehouse support.
  • Created SQL Objects Queries, Stored Procedures, Functions
  • Extensive knowledge of Healthcare Claims and Authorizations data.
  • Created Reports and dashboards for review using CR, SSRS and BI.
  • Created a process in SQL to integrate Ezcap (Claims) and Acuity (Authorizations) to automatically exchange data.
  • Mentored junior team members in best practices for software development, code optimization, and troubleshooting techniques.
  • Worked at tuning ETL Processes to be more efficient.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Worked at analyzing data to see if there were problems with datatypes or invalid data.

Education

Information Technology Technical Degree - Information Technology

Clover Park Technical College
Lakewood, WA

Skills

  • Git version control
  • ETL development
  • Started Learning Python programming
  • Data warehousing
  • Advanced SQL
  • Data integration
  • SQL and databases
  • SQL programming
  • Advanced analytics
  • Teamwork
  • Problem-solving

Timeline

Senior Data Engineer

Optum
10.2007 - Current

Information Technology Technical Degree - Information Technology

Clover Park Technical College

Similar Profiles

CREATE PROFILE