Data Engineer / Senior Systems Data Forensics at Lightbeam Health (2016-05 – 2026-02)
SQL and Python data forensics across clinical datasets of 10M+ patient records, diagnosing pipeline failures, duplicate records, and integrity issues. Traced data lineage end-to-end, ingested and reconciled MSSP/CMS and commercial claims data, engineered patient attribution tables, and built Power BI dashboards.
- SQL and Python data forensics across clinical datasets of 10M+ patient records, diagnosing pipeline failures, duplicate records, and integrity issues before propagation to downstream environments
- Traced data lineage end-to-end across HL7 feeds, ETL processes, and clinical pipelines to identify root cause of reporting discrepancies and establish data governance standards
- Ingested and reconciled MSSP/CMS and commercial claims, eligibility, and CCLF data across multiple payer sources in Snowflake, resolving hundreds of complex data mapping conflicts
- Engineered patient attribution table tracking member movement by NPI across ETL runs — achieving 98% accuracy and adopted as shared team infrastructure
- Built and maintained Power BI dashboards and DAX-driven measures surfacing value-based care KPIs including care gap trends, attribution rates, and HEDIS benchmarks
- Guided client and facility data teams on platform schemas and PaaS data architecture, enabling self-service analytics
- Built LLM-powered care gap explanation layer on medallion architecture using AI
- Built proactive population health monitoring framework surfacing why members were not meeting HEDIS numerators
- Built Python-based ETL pipelines to ingest and transform multi-source clinical data
- Engineered reconciliation frameworks using SQL and Excel for root-cause analysis
- Participated in migration of multiple client databases from on-premises SQL Server to Snowflake
Senior Data Engineer / EDI & Implementations Analyst at Teladoc Health (2013-01 – 2016-05)
Engineered and validated HIPAA-compliant EDI pipelines across payer contracts. Owned end-to-end monitoring of multiple ETL scripts, BI automation workflows, and API jobs. Maintained technical metadata across EDI pipelines.
- Engineered and validated HIPAA-compliant EDI pipelines (834/837) across payer contracts, implementing automated data quality controls and validation rules
- Owned end-to-end monitoring of multiple ETL scripts, BI automation workflows, and API jobs; transforming raw healthcare data into standardized formats
- Maintained technical metadata across EDI pipelines including source definitions, field mappings, and transformation logic
Mortgage Analytics & Reporting Analyst at Wells Fargo (2008-07 – 2013-02)
Built SQL-based statistical and financial models to identify cost reduction opportunities. Converted raw data warehouse content into structured analytical datasets aligned to business requirements.
- Built SQL-based statistical and financial models to identify cost reduction opportunities across 3 vendor relationships, supporting executive forecasting and compliance reporting
- Converted raw data warehouse content into structured analytical datasets aligned to business requirements, enabling trend analysis and operational efficiency measurement
Logistics & Supply Chain Data Analyst at Lennox International (2005-11 – 2008-07)
Led cross-functional business analysis in Agile/SCRUM environment for Manhattan TMS implementation. Leveraged energy network data for predictive cost modeling. Optimized routing and carrier analysis across hundreds of vendors.
- Led cross-functional business analysis in Agile/SCRUM environment to drive Manhattan TMS implementation, translating business requirements into technical specs
- Leveraged U.S. Department of Energy fuel network data to build predictive cost models, forecasting fuel price trends
- Ran comparative carrier analysis using SQL, rate matrices, and demand forecasting across hundreds of vendors, cutting order-to-delivery time by 3%
- Developed supply chain cost forecasting models in SQL, SAP, and Excel using external market data and seasonal trend analysis
Project Manager, Logistics & Supply Chain at W.T.C. Logistics (2002-07 – 2005-10)
Directed supply chain operations for 15+ person team, managing vendor sourcing and competitive bidding. Built fuel cost projection models and route forecasting analyses. Achieved 12% cost savings through process optimization.
- Directed supply chain operations for a 15+ person team, managing vendor sourcing, competitive bidding, and performance standards across national interstate commerce
- Achieved 12% cost savings through process optimization and reduced delivery lead times by 10%
- Built fuel cost projection models and route forecasting analyses from historical consumption data and market pricing
- Built vendor performance measurement scorecards and ad hoc analyses to evaluate carrier efficiency and service level adherence
