GAGAN SINDHU

Built interactive Power BI dashboards using DAX and Power Query to surface portfolio risk indicators for non-technical business stakeholders. Queried and validated 100M+ account records using SQL and SAS, translating complex data into actionable KPI views for cross-functional review. Developed SQL-based validation and reconciliation frameworks to ensure data accuracy and consistency prior to stakeholder publication. Automated recurring SAS reporting pipelines, reducing manual dashboard refresh effort by 25% and improving turnaround time. Partnered with Pricing, Risk, and Legal teams to define key metrics and visualization requirements, documenting specifications in Confluence and tracking delivery in Jira.

Designed Tableau dashboards for managed care reporting, converting claims, member, and provider datasets into clear visuals for operational stakeholders. Applied HIPAA-aware data handling to SQL Server extracts, ensuring sensitive member and eligibility data remained protected throughout reporting workflows. Analyzed claims denial trends by provider and service type using SQL and Tableau, identifying authorization-related outliers and producing exception summaries to improve prior authorization workflows. Reconciled recurring claims and eligibility data feeds, improving reporting accuracy by 20% and reducing dashboard discrepancies for payer operations teams. Collaborated with care management and utilization teams to define healthcare KPIs and document metric definitions and visualization needs for recurring operational reporting.