• Develop and optimize T-SQL queries and stored procedures to support hospital billing analytics, including charges, payments, and accounts receivable aging.

• Design and maintain dashboards in Tableau and Spotfire to track key revenue cycle metrics such as denial trends and clean claim rates, with a focus on clarity for executive stakeholders.

• Collaborate with revenue cycle and operations teams to translate business questions into well-defined KPIs and reporting requirements.

• Manage and maintain a comprehensive billing report library, including updating logic for system changes and retiring obsolete reports.

• Implement data quality monitoring processes to proactively identify issues such as missing claims and duplicate records.

• Support finance teams with variance analysis by integrating operational and financial data to explain revenue performance.

• Fulfill ad hoc reporting requests using Excel, including payer scorecards, pivot tables, and variance summaries for leadership.

• Conduct detailed data analysis to identify root causes of discrepancies, including denial spikes and charge capture gaps.

• Create and maintain clear documentation for metric definitions, reporting logic, and operational runbooks.

• Troubleshoot reporting issues end-to-end by reconciling data across source systems such as Epic and Cerner and coordinating with IT for resolution.

• Partner with finance and clinical teams to ensure consistency and alignment in reporting across departments.

• Designed SQL-driven reports analyzing inbound receiving, inventory movement, order fulfilment, returns, shipment delays, and operational productivity for cross-functional business teams.

• Built operational dashboards, exception reports, reconciliation files, and performance summaries using SQL Server, Oracle, and Excel; presented insights to operations leaders.

• Performed custom ad-hoc analyses based on business guidance, including aging analysis, transaction failures, discrepancies, user activity reviews, and process bottlenecks.

• Developed Python and SQL automation for recurring data validation, report extracts, refresh checks, and exception identification, reducing manual review effort.

• Improved reporting accuracy by reconciling data across source systems (WMS, ERP, workflow) and aligning report definitions with stakeholder expectations.

• Updated existing reports and queries to improve performance, simplify business logic, and align with the most current technology versions and reporting standards.

• Supported UAT and report validation by comparing dashboard outputs against source data, documenting defects, and confirming corrected results before release.

• Collaborated with interdisciplinary teams to translate business questions into reusable SQL datasets and reporting metrics, contributing to enterprise-wide reporting consistency.