Molly Bannow
Ann Arbor,MI
Summary
2+ years in workforce analytics and 10+ years of experience solving problems and improving business processes. Resourceful, creative, and a strong communicator with diverse skillset and passion for all things Excel.
Overview
9
9
years of professional experience
Work History
Senior Program Analyst
Aya Healthcare
04.2024 - Current
- Developed dynamic custom Excel dashboards for internal teams in order to answer key business questions.
- Optimized processes by creating and refining Excel templates for recurring reports using table-based formulas, dynamic arrays, pivot tables, and conditional formatting to minimize errors and increase efficiency and consistency across data team.
- Served as SME and data liaison for Aya's largest MSP client spanning 14 health systems and 5 business lines.
Program Analyst II
Aya Healthcare
03.2023 - 04.2024
- Consulted with executive-level stakeholders and business intelligence team to identify key metrics and optimal data sources for new recurring report for emerging business line; developed custom visualizations and automated data processes to independently generate report across 5 brands on a biweekly basis.
- Applied active listening and verbal communication skills to lead program management teams through 4 to 6 QBR prep calls a week, explaining data concepts to non-technical audiences, extracting data stories from team narratives, and crafting visualizations based on feedback.
- Developed calculations and reporting processes for SLAs on 2 new, high-stakes clients; collaborated with program management and business intelligence teams to ensure accuracy and availability of required data.
Program Analyst
Aya Healthcare
04.2022 - 03.2023
- Mastered calculation, explanation, and visualization of Aya's core contingent healthcare staffing KPIs, including cancellation rate, on-time starts, time to fill, and fill rate.
- Applied intermediate Excel skills to clean and summarize client data into charts in Powerpoint to produce average of 2 to 3 comprehensive and customized Quarterly Business Reviews per week across 5 unique brands.
- Completed as many as 15 ad hoc reports per week for any of Aya's 7+ business lines, applying knowledge of internal data sources, reporting limitations, and alternate resources.
Program Administrator
University of Michigan Program in Immunology
10.2021 - 03.2022
- Monitored and made day-to-day independent decisions about program's $300,000+ annual budget, including extracting and updating student financial and benefit packages in HRIS.
- Built spreadsheets to aggregate and and generate custom reports for student data.
- Met weekly with program directors to update and advise on program matters and budget trends.
Program Coordinator
University of Michigan Quant Program
04.2015 - 10.2021
- Designed multi-sheet workbook system in Google Sheets to collect, analyze, and tabulate faculty's evaluations of 400+ admissions applications annually using spreadsheet functions (INDIRECT, SUMIFS), PivotTables, and conditional formatting; wrote documentation and trained faculty admissions committee on evaluation system.
- Built reports in Business Objects to compare student records with degree requirements in order to partially automate advising processes
- Created database in MS Access to store and analyze student and alumni career data used in regular reports.
Education
Master of Arts - Educational Leadership, Higher Education & Student Affairs
Eastern Michigan University
12.2017
Bachelor of Arts with Distinction - English Language & Literature
University of Michigan
05.2010
Skills
- Excel
- Powerpoint
- PowerQuery
- PowerBI
- Google Sheets
- Tableau
- Python
- MS Access
Timeline
Senior Program Analyst
Aya Healthcare
04.2024 - Current
Program Analyst II
Aya Healthcare
03.2023 - 04.2024
Program Analyst
Aya Healthcare
04.2022 - 03.2023
Program Administrator
University of Michigan Program in Immunology
10.2021 - 03.2022
Program Coordinator
University of Michigan Quant Program
04.2015 - 10.2021
Master of Arts - Educational Leadership, Higher Education & Student Affairs
Eastern Michigan University
Bachelor of Arts with Distinction - English Language & Literature
University of Michigan