Sowmya Palvai

Experience

1. Data Analyst

   Optum

   Jan 2024 — Present · MI, US

   Developed interactive Tableau dashboards to analyze patient demographics, claim denials, revenue cycle KPIs and provider performance, leading to a 25% reduction in manual report generation time.• Designed and optimized ETL pipelines using Apache Spark (PySpark), SSIS and Talend to process structured and unstructured healthcare data, improving data ingestion efficiency by 40%.• Ensured compliance with HIPAA, HEDIS, ICD-10 and CPT standards by implementing data governance frameworks and validation checks, reducing compliance errors by 30%.• Enhanced data pipeline performance on Microsoft Azure by leveraging Azure Data Factory, Synapse Analytics and Databricks, reducing query execution time by 50%.• Performed in-depth Exploratory Data Analysis (EDA) using Pandas, NumPy and Seaborn to identify key patient trends, high-risk populations and operational inefficiencies, enabling targeted interventions.• Developed and automated Python scripts for data cleaning, standardization and transformation of EDI X12 transactions (835, 837, 270/271, 276/277), improving data accuracy by 35%.• Implemented machine learning-based clustering and segmentation models (K-means, Hierarchical Clustering, DBSCAN) to identify high-risk patients and optimize care management strategies.• Designed CI/CD workflows in Jenkins and GitLab to automate data pipeline deployment, ensuring 95% uptime and faster release cycles.• Optimized SQL queries and managed complex data warehouse queries in Snowflake and SQL Server, reducing report execution time from 15 minutes to under 2 minutes.• Developed advanced VBA macros in Excel to automate claims and financial reporting, reducing manual effort by 60% and increasing accuracy in revenue cycle analytics.

Education

• Central Michigan University

  Master's degree, Computer Science

• Bhoj Reddy Engineering College for Women (BRECW), Hyderabad

  Bachelor of Engineering - BE, Electronics and Communication Engineering