Madhulika Vangala

Experience

1. Data Analyst

   McKesson

   Jul 2025 — Present · US

   Designed SQL-based ETL pipelines in Python, processing 1.2M+ healthcare claims records monthly, enabling compliance teams to finalize reports 5 business days faster.Developed Power BI dashboards visualizing 200+ patient care KPIs and compliance metrics across 4 business units, enabling leadership to monitor regulatory adherence and clinical performance.Collaborated with compliance officers and clinical teams to gather reporting requirements, translating them into audit-ready dashboards tracking 200+ KPIs.Ensured HIPAA compliance in analytics workflows by implementing secure data handling practices, audit trails, and access controls for sensitive data.Leveraged Snowflake and Google BigQuery for scalable querying and data warehousing, enabling analysis over 5M+ records with improved performance.Partnered with finance, operations, and strategy teams to integrate Oracle Cloud ERP with AWS S3 and Athena, enhancing reporting speed by 40%.Conducted predictive modeling and time series forecasting (Scikit-learn) to improve churn prediction and revenue forecasting accuracy.Applied predictive modeling and data mining (Scikit-learn, R) to identify high-risk patients and anticipate claim denials, optimizing care delivery and reimbursement.

Education

• KAMALA INSTITUTE OF TECHNOLOGY & SCIENCE

  Bachelor of Technology - BTech, Electrical and Electronics Engineering

  2017 — 2021

• Robert Morris University

  Masters, Information science