At HCL Technologies, I build and maintain ELT pipelines for marketing analytics, including data from HCL Unica Campaign History and Response History. I designed a Bronze–Silver–Gold architecture and developed Power BI dashboards for CTR, CPC, ROAS, and month-over-month analysis.
For P&G retail sales analytics, I built an ELT pipeline that enriched invoice data with master product data and delivered Power BI dashboards for product- and channel-level performance. I also developed an EHR migration pipeline that transformed HL7 v2 messages into FHIR R4 resources and supported data quality, reconciliation, and governance.
My healthcare data work includes an EDI 837P claims pipeline, with HIPAA and ANSI X12 validation and PII masking. I’ve also built an Azure streaming pipeline for retail data and a denials analytics pipeline using FHIR and EDI 835 data.
