Kevin J. Stern
9151 West River Rd. (763) 439-4387
Brooklyn Park, MN 55444 email@example.com
Extensive experience in budgeting, forecasting and variance analysis and guidance on achieving individual departmental goals as well as meeting corporate goals.
Sr. Budget Analyst 2013 to 2016
Xcel Energy Monticello Nuclear Plant, Monticello, Minnesota
· Support 49% of the business units with financial reporting and analysis representing 46% of annual budget.
Assist with the month end general ledger close by preparing entries including accrual and amortizations.
Provide rate case and prudency analysis and documentation.
Prepare account reconciliations for liabilities and pre pay accounts.
Prepare variance explanations for current month, quarter and YTD compared to budget and forecast as well as year over year differences.
Primary Financial Analyst for the bi-annual refueling outage totaling $35M.
Calculated annual budget departmental targets totaling $106M for the site and monthly financial forecasts for my assigned business units totaling $43M.
Manage value transformation weekly/monthly scorecard reporting, a $300M three year project.
Validate weekly business transformation data submitted by supporting depts.
Primary approver for corporate user access to microstrategies, finance and vendor funds.
Primary liaison between finance and IT for merchandise data warehouse requirements.
Provide merchandising teams with detailed weekly sales performance analysis to determine strength of promotional activities. Supported 3 major departmental categories.
Prepare annual budgets and quarterly forecasts for several Merchandising departments along with supporting variance analysis.
Responsible for providing guidance to the Health & Beauty merchandising team in creating quarterly forecasts.
Prepared 20 account reconciliations for Management Review.
Reviewed inventory reconciliations for departments.
Responsible for vendor accrual true-ups.
Financial Analyst 2006 to 2013
Supervalu, Eden Prairie, Minnesota
Senior Analyst, Store Support 1996 - 2006
The Musicland Group, Inc, Minnetonka, MINNESOTA
Provided analytical support for all stores and field management.
Prepared annual budgets and monthly financial forecast, variance analysis and supporting variance explanations for VP review.
Administered the quarterly and annual bonus for all store and field management personnel.
Prepared daily sales reporting for review by VP and District Management.
Bachelor of Science, Business Management University of Mary, Bismarck, ND
Skills & Interests
: Oracle Predictive Solutions, JD Edwards, CompetiSoft Budget Systems, Passport, SAP/BW. Financial Products
: Passport, PeopleSoft, Citrix Applications, DevonWay, Business Objects, Essbase, Microsoft Office. Productivity Software
: USA Hockey Referee & Instructor, Youth Hockey Coach & Volunteer Interests
When selling, do not put your home address in your ad.
To avoid scams, buy and sell with people you can meet locally, in person.
When meeting with someone you don't know, meet in a public place. If that's not possible, have a buddy with you. Also, carry a cell phone; if you feel unsafe, you can call a trusted friend, and stay on the line.
Never give out financial or private information like account numbers, PayPal login, or social security number.
If an offer sounds too good to be true, it is. Walk away!