RADHIKA SHIVA

Designed interactive Power BI dashboards with DAX measures and Power Query transformations to visualize claims, member, and revenue cycle KPIs for operational stakeholders. Built SQL queries using joins, CTEs, and window functions to extract and validate healthcare datasets for recurring reporting and executive KPI summaries. Analyzed claims denial and revenue cycle exception trends, identifying a recurring gap tied to a prior-authorization workflow step and producing an exception summary that prompted operational intake process revisions. Translated complex claims and eligibility datasets into accessible visualizations for non-technical payer and provider stakeholders. Reduced manual reporting effort by 25% by automating recurring dashboard refreshes and standardizing KPI definitions across reporting views. Documented HIPAA-aware data governance standards and validated source-to-target mappings to ensure accuracy and compliance.

Delivered interactive Tableau dashboards for a healthcare payer client using calculated fields and parameters to present claims and utilization metrics for non-technical stakeholders. Gathered visualization requirements and defined key metrics with client leads, translating reporting needs into dashboard specifications and drill-down views. Validated healthcare datasets in SQL against source systems, reconciling member and eligibility records to ensure data accuracy before dashboard publication. Documented HIPAA-aware reporting controls and data privacy standards for sensitive data handling aligned with compliance requirements. Consolidated six data sources into a single Tableau reporting view to streamline stakeholder review and improve reporting consistency. Facilitated remote stakeholder workshops, capturing feedback in JIRA and Confluence for iterative delivery.

Developed recurring Tableau reports for a healthcare payer client, presenting enrollment and claims metrics in clear formats for operational teams. Analyzed healthcare datasets using SQL and Excel, identifying data discrepancies and documenting RCA summaries to support reporting accuracy. Validated source-to-target mappings and reconciled recurring data feeds to ensure dashboard inputs met accuracy and compliance standards. Improved data accuracy by 20% through systematic validation checks and exception reporting on recurring healthcare data feeds. Supported stakeholder coordination by gathering reporting requirements and documenting specifications for dashboard enhancements.