Lead financial partner to three R&D Divisional Vice Presidents, managing variance analysis, quarterly forecasts of an overall budget of $250M+ budget, executive reporting, headcount planning, and capital expenditures.
Streamlined reporting processes to improve efficiency in data collection and analysis for reports such as financial dashboards, resource allocation uploads, and monthly landing estimates.
Assist in the month-end close process, including, but not limited to, landing estimates, journal entries, and analysis.
Team lead for consolidating activities like presentation preparation and monthly landing estimates.
Contributed to the launch of the Balance Sheet initiative and owned balance sheet forecasting for the EP R&D division.
Financial Analyst II
Xcel Energy
Minneapolis, MN
05.2022 - 03.2024
Lead in streamlining the business area's driver-based budgeting process to successfully load a $279M budget while improving monthly forecasting models.
Assist in the implementation of SAC Planning to help Xcel Energy in better forecasting, budgeting practices, data integrity, and intuitive analysis.
Support pulling historical data and future adjustments for CO, NM, TX, and WI rate case filings, as well as follow up with discovery questions.
Financial Analyst
Xcel Energy
Minneapolis, MN
06.2021 - 05.2022
Implemented driver-based budgeting using historical financials and CPUs to create a $268M budget for 2022.
Created PowerPoint presentations to illustrate a 5-year budget plan by creating expenditure waterfalls, assisting in data pulls, and planning spend for current and future company programs.
Analyzed financial data to complete variance analysis by GAAP and the Federal Energy Regulatory Commission code.
Prepared and presented monthly financials to three business leadership groups to bring awareness to CM and YTD financial variances, and provided business partners with ad hoc reporting.
Education
Bachelor of Arts - Accounting and Finance
College of Saint Benedict
St. Joseph, MN
05-2021
Skills
Variance analysis
Analytical thinking
Process improvement
Report preparation and presentation
Problem solving
Team leadership
Business partnership
Resource allocation
Microsoft applications (Excel, PowerPoint, Word, and Analysis)