JOHN FORBES
Solomon Page – Cigna/HCSC
Gillette
19
years of professional experience
Senior Data Engineer with almost 3 decades of experience in software development and data engineering, including almost 2 decades focused on healthcare analytics, data integration, and enterprise reporting. Deep expertise in SQL Server, T-SQL, SSIS, and large-scale ETL pipeline development. Proven ability to design scalable data solutions, optimize performance, and automate complex workflows. Strong track record of improving data quality, enabling data-driven decision-making, and mentoring engineering teams in high-impact healthcare environments.
Work History
ActiveBatch Automation Engineer (Contract)
9 Months- - Developed and maintained ActiveBatch workflows to automate enterprise file transfers
- - Managed secure data exchange using Axway Managed File Transfer
- - Optimized automation processes, improving job reliability and execution efficiency
- - Collaborated with vendors and cross-functional teams to support seamless data integration
- - Provided production support and resolved automation issues in a large-scale healthcare environment
- Remote
Senior Data Engineer
7 Years 6 Months- - Designed and maintained enterprise SSIS ETL pipelines supporting healthcare data warehouse operations
- - Developed advanced T-SQL solutions for high-volume healthcare datasets
- - Built and maintained reporting solutions using SSRS
- - Implemented HEDIS reporting and Provider Stars logic to support quality initiatives
- - Improved database performance through query optimization and tuning
- - Identified and resolved data quality issues, enhancing reporting accuracy
- - Managed source code using Git, TFS, and SVN
- - Mentored junior engineers in SQL, ETL best practices, and troubleshooting
- - Collaborated with analysts and stakeholders to deliver end-to-end data solutions
Senior System Developer
10 Years 1 Month- - Architected and implemented an enterprise healthcare data warehouse integrating multiple data domains
- - Developed SSIS ETL solutions to streamline cross-system data integration
- - Built enterprise reporting solutions using SSRS and Crystal Reports
- - Administered SSRS infrastructure, including security configuration
- - Developed SQL and C# integrations between EZCAP Claims and Acuity Authorizations, reducing manual processing
- - Automated claims repricing using WebStrat and SQL Server, improving efficiency and accuracy
- - Created secure SFTP automation services using C#, XML, and 7-Zip
- - Developed an HCC coding application to improve Medicare risk adjustment outcomes
- - Automated SQL Server database restoration and deployment processes
Education
Associate of Applied Science - Information Systems Technology
Skills
Data Engineering & Integration
ETL/ELT Development
SSIS
Data Warehousing
Data Modeling
Data Pipelines
Data Integration
Automation & Data Movement
ActiveBatch
Axway Managed File Transfer
Workflow Automation
Database Technologies
Microsoft SQL Server
Advanced T-SQL
Stored Procedures
Functions
CTEs
Performance Tuning
Query Optimization
Reporting & Analytics
SSRS
Crystal Reports
Dashboard Development
Ad Hoc Reporting
Healthcare Analytics
HEDIS
Provider Stars
Development & Tools
C#
Git
Azure DevOps/TFS
SVN
Agile/Scrum
Healthcare Domain Expertise
Claims
Authorizations
ICD-10
CPT/HCPCS
DRG
Revenue Codes
POA
NPI
HCC Coding
Medicare Risk Adjustment
ADDITIONAL QUALIFICATIONS
- - 25+ years of SQL Server development experience
- - 19 years supporting healthcare organizations
- - Extensive expertise in healthcare claims and authorization data
- - Strong background in automation, ETL, and enterprise data systems
- - Proven mentor and technical leader
- - Available for remote opportunities
Timeline
ActiveBatch Automation Engineer (Contract)
Solomon Page – Cigna/HCSC
09.2025 - 06.2026Read More
Senior Data Engineer
Optum
11.2017 - 05.2025Read More
Senior System Developer
Northwest Physicians Network
10.2007 - 11.2017Read More
Clover Park Technical College
Associate of Applied Science from Information Systems Technology
Read More