Project Manager — Data Platform & ETL Delivery - Cognizant Technology Solutions - India
(2016-07 - 2021-02)
Client: Kaiser Permanente (US Healthcare) | Domain: Healthcare Insurance & Value-Based Care | Team: 15+ engineers, onshore & offshore
- Spearheaded end-to-end delivery of Kaiser Permanente's Health TranZform enterprise data platform — integrating clinical, claims, and care-coordination data streams from multiple source systems into a unified Oracle data warehouse using Informatica PowerCenter 9x/10x.
- Directed 15+ concurrent ETL and software development projects simultaneously, achieving 100% Defect Removal Efficiency (DRE) and zero missed release deadlines across all programme tracks.
- Orchestrated Agile/Scrum delivery across distributed onshore and offshore teams — running sprint planning, backlog refinement, stand-ups, sprint reviews, and retrospectives — improving team velocity and reducing delivery cycle friction.
- Governed end-to-end programme scope, release planning, and risk mitigation for cross-functional data initiatives supporting value-based healthcare transformation for one of the largest US healthcare providers.
- Produced Functional Requirement Documents, Technical Design Documents, and Application Design specifications; acted as primary bridge between business stakeholders and engineering teams, eliminating ambiguity and accelerating decision cycles.
- Established offshore delivery governance frameworks — including daily monitoring protocols and structured escalation paths — that proactively identified risks and protected project timelines.
Technical Lead & Specialist — ETL & Application Development - Hewlett Packard Inc. - India
(2013-04 - 2016-06)
Client: GADSC-HPIT (IPG Factory Systems) | Domain: Global Manufacturing & Quality | Sites: USA, Singapore, Puerto Rico
- Designed and delivered CMQMR (Contract Manufacturing Quality Metrics Repository) — a multi-site ETL solution consolidating LaserJet supplier quality data across 5 global manufacturing sites, improving reporting load efficiency by 3x and team productivity by 25%.
- Engineered 135 Informatica ETL mappings spanning 5 international factory sites, reducing end-to-end data load time from over 1 hour to approximately 6 minutes — a 9x performance gain — through source-level pushdown optimisation, partition parallelism, and sorted-input aggregation.
- Independently architected and built VDI (Vertica Data Integrator) — a standalone .NET application for ingesting structured and unstructured data into the Vertica analytics platform; awarded Gold Medal at Cognizant Tech'Day for innovation.
- Implemented a SharePoint Workflow automation solution that eliminated manual metadata validation processes, delivering full end-to-end data traceability and significantly reducing operational overhead.
- Led incident and problem management across the ETL and .NET application landscape — reducing support ticket volumes and generating measurable cost savings validated by the client.
- Earned multiple performance awards including E-Award and Bravo Award for sustained delivery excellence and technical innovation.
Senior Application Programmer — ETL & Data Integration - IBM India Private Ltd. - India
(2010-03 - 2013-02)
Clients: Lincoln Financial Group (USA), Vodafone Greece | Domains: Financial Services & Telecommunications
- Architected and built Informatica 9.1 ETL pipelines for Lincoln Financial Group's Client Communication Database (CCDB) — a mission-critical data warehouse powering daily regulatory and ad hoc policyholder mailings across thousands of policyholders.
- Led full-cycle module design and development for the D1STD (Daily First Dollar) programme — translating complex financial business rules into automated ETL workflows driving daily fund prospectus delivery to Merrill Lynch.
- Designed and implemented an ETL integration solution for Vodafone Greece's Financial Planning Tool — ingesting accruals, budgeting, and forecasting data from Oracle and Siebel CRM into the FDH reporting layer, enabling near-real-time financial analysis.
- Owned requirements analysis, high- and low-level technical design, performance tuning, unit testing, and production implementation planning — delivering all modules on schedule with zero production defects post-deployment.
Software Engineer — Application Development & ETL - Hewlett Packard Global Soft - India
(2006-06 - 2010-03)
Domain: HP Printing & Personal Systems | Global Factory Systems
- Developed and maintained enterprise applications across .NET, Java, and ASP/ASP.NET for HP's global factory systems — including LabNET, AutoPpk, MasterTool, and TIJ 2.5 — spanning front-end application interfaces and back-end ETL data integration layers.
- Re-platformed AutoPpk from legacy ASP to ASP.NET, delivering a fully modernised application with zero production defects; awarded Bravo Award for on-time delivery to the Singapore factory.
- Built and maintained Informatica 7.x ETL pipelines feeding factory quality and production metrics into the central enterprise reporting layer.
- Migrated legacy Informix databases to SQL Server 2005; designed and implemented data collection and quality audit systems for HP's printer manufacturing production lines.
