Scott Rupprecht
St. Louis,MO
Summary
Professional analyst with 5+ years of experience in data-driven analytics, process validation, and driving results for the business. Proven track record translating information into a simple and effective medium. Experience in building, analyzing, and maintaining reports using Microsoft Office, Power BI, Adaptive, BPC, Planful and Tableau.
Overview
7
7
years of professional experience
Work History
Finance Analyst
Global Medical Response
O'Fallon, MO
03.2025 - Current
- Solely responsible for forecasting and budgeting GMR’s Flight Crew Payroll, the organization’s highest‑cost expense line.
- Collaborated with HR Compensation to model cost impacts of compensation and scheduling changes, preparing over two dozen analyses for review and approval by executive leadership during tenure.
- Demonstrated ability to quickly learn and master new financial systems, including Planful and Spotlight XL, to streamline reporting workflows.
- Implemented AI solutions to streamline data processing, ensure timeliness in project turnaround, and improve accuracy across multiple projects.
Financial Operations Analyst
West Star Aviation
East Alton
06.2023 - 01.2025
- Present to leadership the monthly P&L results, KPI's, and effectively communicate the story while working with the accounting team in ensuring accurate journal entries.
- Create the yearly budget for the supported business unit which includes: Communicating between the Ops team and leadership for continuity, identify financial assumptions to be used, and presenting the budget in an effective way to leadership.
- Used data models in Power Bi and Adaptive to provide insight to the Ops team by looking at low-performing projects, generated a new analysis around part returns over 5 years, and historical departmental trends.
- Modified the sales forecast document used for the company which improved efficiency dramatically and its accuracy. Submit bi-weekly forecasts to provide realistic expectations for the business.
Sr. Analyst, Corporate Finance
Caleres, Inc
08.2022 - 05.2023
- Owned the cash flow forecast for the company which included: analyzing the company’s debt to EBITDA ratio, monitoring the revolver borrowings, and report on future cash flow projections to leadership.
- The subject matter expert for Marketing which key components included: Tracking expenses using SAP as well as work with accounting’s journal entries, create decks for leadership, and forecast/budget their cost centers and accounts.
- Perform financial analysis of company spending and ROI projections for different initiatives to show to leadership.
Customer Maintenance & Credit Analyst
Save a Lot
01.2022 - 07.2022
- Provide in-depth analysis to leadership on potential customers’ financial standing using tax documents, insurance policies, and financial statements.
- Simplifying and automating accounts receivable reports in Excel which resulted in 600+ man-hour savings annually.
- Streamline the franchising process by providing communication and customer service to potential Save a Lot clients.
FP&A Analyst
Save a Lot
07.2019 - 12.2021
- Launched new Marketing analysis initiatives that increased organization performance by evaluating data input from the marketing team.
- Instituted standard reporting and analysis using Power Bi, Tableau, and Excel for the Regional and District Managers.
- Provided in-depth analysis on our Instacart launch. The data provided key insights and actions across the company and was used in C-Suite level presentations.
- Developed and refined custom Power BI reports by leveraging connected enterprise data sources and publishing enhanced dashboards through Power BI Desktop.
Education
Bachelor of Science - Economics
University of Missouri - St. Louis
St Louis, MO01-2018
Skills
- Data Analysis
- 6 years of Experience in Power Bi
- Advanced Excel Experience
- Project Leadership and Management
- Efficient and Effective Communication
- Team-Oriented Collaboration
- Visualizing Results
- AI Incorporation
Websites
Interests
Volunteering, Cooking, Sports, US Economic Trends, Music, Mentorships, Fitness, Home Renovation
Timeline
Finance Analyst
Global Medical Response
03.2025 - Current
Financial Operations Analyst
West Star Aviation
06.2023 - 01.2025
Sr. Analyst, Corporate Finance
Caleres, Inc
08.2022 - 05.2023
Customer Maintenance & Credit Analyst
Save a Lot
01.2022 - 07.2022
FP&A Analyst
Save a Lot
07.2019 - 12.2021
Bachelor of Science - Economics
University of Missouri - St. Louis