Mouli Ch

Data Engineer @CVS Health

Fairfax, VA, US

Architected end-to-end healthcare data pipelines using AWS Glue, S3, Redshift, Apache Kafka, and Amazon MSK, processing 200GB+ daily clinical and billing data with 99.8% accuracy for HIPAA-compliant reporting systems.• Built real-time healthcare analytics platform using AWS Lambda, Kinesis, Apache Kafka, Kafka Streams, and Athena, enabling instant patient care insights and reducing clinical decision-making time by 45%.• Developed automated ETL workflows using Apache Airflow, Apache NiFi, and dbt, transforming multi-source healthcare data (EHR, claims, lab results) into dimensional models supporting 15+ clinical dashboards.• Implemented data quality monitoring framework using AWS CloudWatch, Apache Flink, and custom Python validators, achieving 99.5% data accuracy and preventing $2.3M in compliance penalties.• Created executive healthcare analytics dashboards using Tableau, Power BI with embedded SQL optimization, consolidating 25+ reports into 6 comprehensive scorecards for C-suite decision-making.• Designed fraud detection models using PySpark, Apache Spark, Spark Streaming, and AWS EMR, processing 500K+ daily healthcare transactions and identifying suspicious patterns with 87% accuracy.• Optimized Redshift and Snowflake data warehouse performance through query tuning, Kafka Connect integration, and compression strategies, reducing report generation time from 2 hours to 12 minutes for critical healthcare KPIs.• Established CI/CD pipelines using AWS CodePipeline, Jenkins, Terraform, and Git, automating healthcare data deployment processes and reducing manual deployment time by 70%.