Healthcare · Case Study · Led by Varun Vashisht (PMP · CBAP · PMI-PBA)
US Healthcare Coordination of Benefits Modernisation
Agile delivery lead. 150+ user-story backlog, automated SSIS ETL testing framework, and advanced SQL validation across complex COB data flows.
The challenge
A US healthcare client's Coordination of Benefits (COB) system processed complex multi-payer claims but relied on manual QA processes that were slow, error-prone, and unable to scale. Data inconsistencies across COB flows were eroding downstream accuracy.
The approach
Served as Agile delivery lead, owning the full backlog in Azure DevOps, driving two-week sprint cycles, and personally designing the automated SSIS ETL testing framework that replaced manual validation.
- Managed 150+ user stories from refinement through UAT sign-off.
- Built automated ETL test suite using SSIS and T-SQL stored procedures, cutting manual QA effort by 50%.
- Authored advanced SQL validation scripts that identified and resolved systemic data inconsistencies.
Outcomes
- 50% Reduction in manual QA effort via SSIS automation
- 15% Fewer data inconsistencies across COB flows
- 150+ User stories delivered across Agile sprints
Stack & methods
- Azure DevOps
- SSIS ETL
- SQL / T-SQL
- HIPAA
- Agile / Scrum
Role on this programme
Varun Vashisht owned this programme end-to-end as the Healthcare delivery lead. Covered scope definition, stakeholder alignment, vendor governance where applicable, backlog and RAID management, and executive reporting against the 50% less manual QA · 15% fewer data inconsistencies outcomes above. The work draws on the same 14+ years of enterprise programme delivery that underwrites his current Senior Program Manager engagement.
Relevant credentials: PMP (PMI), CBAP (IIBA), PMI-PBA, TCS Certified Generative AI Practitioner. Tech & method stack used here: Azure DevOps, SSIS ETL, SQL / T-SQL, HIPAA, Agile / Scrum.
Recruiter or hiring manager? Let's talk.
If you're staffing a similar programme (healthcare transformation, enterprise rollout, or AI-enabled delivery), the fastest path is a quick intro.