Mehanaz Mohammad Mehanaz Mohammad

Designed interactive Power BI dashboards with DAX measures to present credit portfolio KPIs for non-technical business stakeholders. Built SQL validation scripts and reconciliation reports to ensure data accuracy across cardholder and merchant partner reporting datasets. Automated recurring reporting inputs using Power Query, reducing manual dashboard refresh effort by 25%. Documented metric definitions and data governance standards to keep reporting consistent across 12 recurring business reports.

Delivered Tableau dashboards for a healthcare payer client by translating claims and member eligibility data into accessible visualizations for operational teams. Gathered visualization requirements from project leads and mapped key metrics to reporting needs across utilization and authorization workflows. Validated SQL extracts feeding payer dashboards, catching data discrepancies before release and improving reporting accuracy by 20%. Coordinated remote stakeholder reviews to confirm dashboards supported practical reporting and decision-making.

Developed Tableau dashboards on Medicaid and Medicare Advantage claims data, presenting utilization and eligibility metrics for payer operations teams. Reconciled member and provider data using SQL to maintain HIPAA-aware reporting accuracy across managed care deliverables. Analyzed claims denial trends by provider groups using SQL and Tableau, identified a spike in authorization-related rejections, and produced an exception summary that prompted revisions to the prior authorization review workflow. Documented 45 validation scenarios supporting CMS compliance reporting and payer data governance.