Arun Konda

Built interactive Tableau dashboards for a healthcare payer client, presenting claims and utilization trends for non-technical operations leads. Designed Tableau views with calculated fields and parameters so stakeholders could drill into member and provider metrics without ad hoc requests. Analyzed claims and utilization trends in SQL and Tableau, identified an authorization-bottleneck pattern, and produced an exception summary that helped the client revise intake review. Translated complex payer datasets into accessible dashboards, cutting manual reporting effort by 25% across recurring operational reports. Partnered with project leads to define key metrics and visualization needs, documenting HIPAA-aware handling rules for sensitive member and claims data.

Built Power BI dashboards with DAX measures for a healthcare payer client, providing analysts a governed view of eligibility and claims reporting. Chose SQL-side aggregation over heavy DAX calculations to keep dashboard refresh times low on large claims extracts. Reconciled source-to-target mappings across SQL Server and Snowflake, flagging mismatches in member eligibility feeds before they reached reporting. Improved data accuracy by 20% on migrated claims reporting by adding validation checks and RCA documentation to the Power BI refresh cycle. Coordinated UAT for reporting workflow changes, documenting test scenarios and defect triage in JIRA for the payer client team.

Developed SQL queries against claims, member, and provider data to support Medicaid and Medicare Advantage operational reporting. Built Tableau reports for utilization and authorization tracking, using scheduled extracts over live connections to keep refresh stable for plan operations. Consolidated 6 data sources into a single Tableau reporting view covering eligibility, claims, and provider network metrics for managed care teams. Validated CMS compliance reporting outputs and documented HIPAA-aware handling steps for sensitive member data across plan reporting.