Hospitalist & provider performance scorecards
Built an Epic dashboard from Reporting Workbench reports and SlicerDicer sessions to bring patient-flow and quality measures into one clinical reporting view.
I’m a Data & Reporting Analyst who turns complex operational data into trusted reporting for performance, quality, and regulatory decisions. I combine SQL development, Power BI, and Epic analytics with rigorous validation and data governance practices to help leaders identify gaps and prioritize improvements.
A foundation of clean data. A focus on useful answers.
Case studies in quality, patient flow, and regulatory analytics, with dashboard recreations you can explore.
These case studies describe my professional work. Two browser-based dashboard recreations use fictional data to demonstrate the reporting approach; they do not show actual hospital results.
Built an Epic dashboard from Reporting Workbench reports and SlicerDicer sessions to bring patient-flow and quality measures into one clinical reporting view.
Translated complex infant-feeding and care-practice requirements into SQL-defined populations and a Power BI dashboard.
Connected encounter-level activity with unit-level reporting across 12+ units, supporting operational review and DPHHS reporting.
Turned years of ambulance event data into a service-area performance baseline and a CMS-ready Excel reporting deliverable.
My work spans the reporting lifecycle: translating stakeholder requirements, developing SQL datasets, building dashboards, and reconciling results to source systems. I connect technical development with business context so leaders can understand what a metric measures, how it was calculated, and where it needs further investigation.
Within Epic, I develop Reporting Workbench reports and SlicerDicer content, bring individual measures into dashboards, and collaborate with Community Connect partners on reporting validation and release readiness.
Data governance is part of that approach: consistent metric definitions, traceable calculation logic, data quality checks, and clear reporting requirements. I collaborate with stakeholders to resolve discrepancies and clarify definitions, supporting the shared understanding that business leaders, data owners, and data stewards need to interpret reporting consistently.
Healthcare is where I’ve developed this experience. The skills carry across industries: understanding performance, investigating operational gaps, and making data reliable enough to support decisions.
Recurring census and discharge reporting scope.
From clinical records to Baby-Friendly reporting.
Flagged 10 ambulance records with inconsistent timestamps for when crews became available for the next call.
SQL Server / SSMS · T-SQL · CTEs & joins · Stored procedures · SSIS
Power BI · Tableau · Epic Radar / SlicerDicer · DAX · Power Query · Data modeling & relationships · Scheduled refreshes
Data quality validation · Source reconciliation · Metric definitions · Traceable reporting logic · Advanced Excel / PivotTables
Stakeholder requirements · Business definitions & reporting standards · Epic Clarity / Caboodle · Reporting Workbench · SlicerDicer · Jira / Slack
Translate stakeholder needs into clear business questions, agreed metric definitions, and decisions the reporting should support.
Identify source systems, define the reporting grain, and build SQL datasets with traceable transformation logic.
Reconcile source totals, test eligibility and date logic, and resolve data quality exceptions with stakeholders.
Present findings clearly, explain calculation rules and limitations, and refine the reporting around stakeholder use.
Interested in data and reporting opportunities where SQL, thoughtful analysis,
and clear communication make a difference.