John Macleod Email & Phone Number

Fort Myers, FL, US

• Charter School Finance PracticeFrom single school to multi-school, multi-state networks:
• Provide financial modeling, KPI definition, management reporting and dashboard
• Budget development and implementation
• Advise on planning and budgeting process improvement, best practices, internal controls
• Consult on strategy and financial feasibility/sustainability of new and expanding initiatives, and structured finance/facilities funding

Weslaco, Texas, US

• Led Annual Planning, Budgeting, and KPI/Variance Analysis for a portfolio of schools across three states
• Streamlined and provided documentation for dramatically more efficient and auditable annual budget process.
• Improved data management strategies and processes to significantly reduce cycle time, enhance auditability, and minimize errors during annual budget upload process; decreased budget cycle by 4 weeks.
• Engaged in proactive budget reviews and expense management discussions with schools, ensuring alignment with financial targets and led to 90% of schools achieving surpluses in discretionary budgets.

• Led a revamping of the FP&A process.
• Implemented strategic initiatives to improve organizational efficiency and financial performance
• Designed and developed new Executive Dashboard providing new visibility into effectiveness of GTM tactics and resource allocation.
• Seamlessly integrated data from diverse internal/external sources and APIs, published, and continually refreshed resulting in an average reduction of 85% in management reporting cycle time.

• Mentored early-career technical analysts in application of skill set, infusing thorough understanding of business context and how their work impacted management decisions.
• Instrumental in developing and maintaining customer acquisition, retention, and loyalty dashboards during challenging period of restrictive travel due to Covid Pandemic.

• Provided daily and weekly insight through comparative analysis of product, segment and channel pricing actions resulting contributing to the delivery of 10 consecutive quarters of revenue growth.
• Reduced bias and MAPE by 70%; led multiple projects to improve accuracy of demand forecasting.
• Collaborated cross-functionally with multiple departments on competitive intelligence, price elasticity, and optimization efforts.
• Developed reporting to rapidly execute ad-hoc analysis of pricing and volume changes week-over-week and YoY; identified underlying components of change and enabled tactical responses.
• Streamlined process and automated management reporting of system performance and user activity, enabling faster deployment of tactical actions to maximize revenue; slashed time to produce various reports by 70-90% and.

• Led a diverse team of analysts to develop a predictive model for health plan members at risk of incurring a major health expense in the next 12 months.
• Developed Cox PH Regression model to target preventative interventions yielding 13% reduction in major claims.

Dover, New Hampshire, US

• Transitioned in career to educate students in areas of Orchestra, Musical Theatre, Musicology, Music theory, and AP Physics. Elevated multiple programs to gain competitive edge within marketplace for school.

• Chief Administrator
• Marketing analytics, budget planning, financial management, contracts and regulatory reporting
• Subscription/membership sales and marketing, grant writing and management
• Introduced CRM, improving marketing and sales processes increasing subscriptions by over 600%

Bachelor Of Science, Mechanical Engineering/Materials Science

Mba, Strategy & Finance

Master Of Science (Ms), Analytics