Delaney Foster — Business Intelligence Analyst
Columbus, OH
Business intelligence analyst who came to the work from clinic operations and still builds reports the way an operator reads them. Rebuilt staffing reporting in Power BI, turning a six-hour Monday routine into 20 minutes, and now owns the 14 dashboards behind weekly operations reviews.
Experience
Business Intelligence Analyst, Ridgehaven Health Partners · February 2025 – present
Reporting for 26 clinics and 310,000 patient visits a year.
- Owns the 14 dashboards behind weekly operations reviews, covering visit volume, no-shows, staffing and supply spend across 26 sites.
- Replaced a hand-built staffing spreadsheet with an hourly Power BI model, cutting the operations team's Monday preparation from six hours to 20 minutes.
- Found that an overlapping join double-counted 11% of no-show appointments; the corrected rate of 17% changed how three clinics staffed Fridays.
- Wrote the metric definitions page that ended a two-year disagreement between finance and operations over what counts as a completed visit.
Operations Coordinator, Ridgehaven Health Partners · June 2022 – January 2025
Moved into the analytics team after building the scheduling model the department adopted.
- Scheduled 40 clinical staff across four sites and built the Excel model that cut overtime hours 23% in its first quarter.
- Reconciled 1,100 monthly supply orders against invoices, recovering $47,000 in duplicate charges over 18 months.
- Trained 26 site leads on the new visit-tracking workflow, taking same-day chart closure from 62% to 91%.
Education
- B.A. Economics · The Ohio State University · August 2018 – May 2022
Skills
- Reporting: Power BI, DAX, Tableau, Excel, Paginated reports
- Data: SQL Server, T-SQL, Star schemas, Data modeling, Python
- Healthcare operations: Scheduling, Capacity planning, Claims data, HIPAA-safe reporting
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) — Microsoft
- Tableau Desktop Specialist — Tableau