Galloway · Kelso / ARA
FP&A reporting and demand-based planning
FP&A Consultant · Full-time consulting engagement
Established FP&A reporting and planning capabilities for an acquisitive $100M+ architecture & engineering platform with 50+ profit centers and no prior dedicated FP&A function.
- Built a Monthly Reporting Package recognized by Kelso as best-in-portfolio and a Value Creation Plan (VCP) KPI package adopted by ARA as a model for other portfolio companies.
- Lead development of the demand-based 2027 budgeting process, linking backlog, bookings assumptions, and practice-leader input to profit-center revenue forecasts, staffing requirements, and labor costs.
- Integrated five acquisitions into consolidated reporting and performance tracking, including organic and pro forma P&L views; supported lender diligence and reporting.
- Developed weekly dollar-based utilization reporting used by leadership to manage utilization and labor margin; directed an external Power BI team to deliver an automated dashboard.
- Automated recurring monthly sponsor data requests across net revenue, labor hours, employee billing, and operating expenses through self-service Power BI reporting developed with AI; enabled one-click refresh of key VCP metrics.