Srinivas Uppalapati

Data Analyst @UnitedHealth Group

Miami, FL, US

Built robust Azure Data Factory pipelines to centralize patient and claims data from over 10 healthcare systems into Synapse Analytics, streamlining operational reporting and reducing dependency on legacy data sources. • Applied validation rules and schema verification using ADF pipeline activities such as Lookup, If Condition, and For Each to ensure data consistency and reduce downstream reporting failures by over 95%.• Created real-time Power BI dashboards using DAX to track medical costs, provider efficiency, and network coverage across regions, enhancing insights for executive and operational leadership teams.• Collaborated with actuarial and data science teams to deliver clean and model-ready data, increasing the precision of risk scoring and improving model deployment timeframes by 35% across divisions.• Defined OLAP cubes and star schema relationships for Synapse-based datasets, enabling self-service analytics and minimizing ad-hoc data requests by automating the reporting layer logic and views.• Migrated legacy Excel-based workflows to automated dashboards and pipelines, saving analysts over 200 hours monthly and reducing reporting errors stemming from manual transformations.• Used GitHub Actions and Azure DevOps to create CI/CD flows for analytics solutions, standardizing code management and reducing incidents during production deployment of ETL scripts.• Built audit logs and lineage reporting using Azure Monitor and Log Analytics for compliance with HIPAA standards, while also providing traceability for data quality reviews and governance audits.• Trained junior analysts and end-users on building Power BI reports, improving team proficiency in BI development and enabling 2 new departments to become self-sufficient with data.• Applied PySpark on Azure Databricks for high-volume batch jobs processing discharge and referral records, improving ETL performance and consolidating over 1TB of records weekly.