Financial Analyst

 


Kevin J. Stern


9151 West River Rd.                                                                        (763) 439-4387


Brooklyn Park, MN 55444                                                  kevin.stern56@gmail.com     



 



 


 





















Summary of


Qualifications




  • Extensive experience in budgeting, forecasting and variance analysis and guidance on achieving individual departmental goals as well as meeting corporate goals.


 



 



Professional


Experience



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


 


       

 










Professional


Experience



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.


 



 














Education


 




  • Bachelor of Science, Business Management
    University of Mary, Bismarck, ND


 



 



 



 










Skills & Interests



Financial Products: Oracle Predictive Solutions, JD Edwards, CompetiSoft Budget Systems, Passport, SAP/BW.


 


Productivity Software: Passport, PeopleSoft, Citrix Applications, DevonWay, Business Objects, Essbase, Microsoft Office.


 


Interests: USA Hockey Referee & Instructor, Youth Hockey Coach & Volunteer


 



  


 

  • ID#: 114504
  • Location: Minneapolis, MN , 55444

Don't Be Fooled

  • 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!

Look Who's Hiring!

Financial Analyst Business Partner
Shakopee, MN Entrust Datacard
Pharmacy Benefits Financial Analyst in Minneap...
Minneapolis, MN Willis Towers Watson
Sr Financial Analyst
Saint Paul, MN Randstad Professionals
Healthcare Economics Consultant/Sr. Financial ...
Eden Prairie, MN UHG