Joseph McKinley

Financial Analyst @Uchicago Medicine Adventhealth

Hinsdale, IL, US

Managed month-end close for two of four hospitals in the region, pulling financial reports while also utilizing Power BI to maintain financial models displaying departmental revenues and expenses for the operational region, total revenue for all regions exceeding $1.4 billion in FY24 - Developed and analyzed pro forma financial models for 10+ hospital service lines, providing insights that informed investment decisions for over $100 million in new programs and expansions- Leveraging Oracle and EPIC Systems to maintain the 3-month rolling forecast for several departments in the hospital, monitoring different accounts for the 3-month average on these accounts- Led multiple different quarterly meetings with the Accounting team, walking through different expense reports across 20+ different hospital departments, supported by vendor-level expense detail and purchase logs - Developed pivot tables to manage revenue data, calculating variance and growth %’s for each month while creating graphs and models to visualize any major variances throughout the fiscal year

Andrews University

Bachelor's degree, Finance, General