Senior Finance Analyst

MARY ANN ERWIN-CPA CANDIDATE

*** ******** ** • Wheaton, IL • (Cell) 630-***-**** • ****.*******@*****.***

SUMMARY OF QUALIFICATIONS

• 5 years of corporate budgeting/finance experience, including managing and reporting on Capital projects,

expenditures for manufacturing organizations.

• 5 years strong forecasting, analyzing and reporting on corporate expenditures

• 5 years’ experience in developing and reporting on Financial, Planning and Analysis (FP&A)

• 5 years’ experience in data collection, and spreadsheet programs for accounting and statistical analysis for

reporting functions

Government Finance Analyst

Contract- (HCSC, Division of Blue Cross Blue Shield, Constellations' Brands) Jan 2013- April 2014

• Conducted weekly meetings to ensure all Governmental enrollment to track enrollment and head count goals

• Performed financial analysis and sales reporting on business performance, including weekly review of actual

against forecast and plan, reported on variances and trend shifts

• Prepared and distributed Key Business Indicators (KBI) on brand, volume, mix, expenses, penetration,

insurance sales performance by state, outlet level Look-of- success, and compliance with channel specific Game

Finance Analyst

Contract- (Sears) April 2011- Jan 2013

• Transferred all capital projects from Oracle to SAP

• Conducted weekly meetings to ensure all capital projects meet corporate profitability and cash flow objectives

• Performed financial analysis and sales reporting on business performance, including weekly review of actual

• against forecast and plan, reported on variances and trend shifts

• Prepared and distributed Key Business Indicators (KBI) on brand, volume, mix, revenue, new outlets,

penetration, sales associate performance, outlet level Look-of- success, and compliance with channel specific Game

Finance Analyst Sr.

Coca-Cola Refreshments April 2010-March 25, 2011

• Conducted weekly sales meeting to evaluate customer profitability on customer contracts

• Provided analytical support in preparing, studying, evaluating and modifying sales contracts

• Maintained Financial Models for all Market units and to ensure they meet corporate profitability and cash

flow objectives

• Reviewed all contracts to insure they were in compliance with corporate guide lines

• Analyzed and reported on sales performance for Volume, Gross Profit, Net Income and SG&A expenses

• Conducted sales meetings and updated forecasts models for executive management. Forecast accuracy was

achieved within 95% of gross volume

• Reported on variance analysis on sales and profit margins while producing forecasts and trend analysis for the

On Premise sales organization

• Performed financial analysis and sales reporting on business performance, including weekly review of actual

against forecast and plan, reported on variances and trend shifts

• Prepared and distributed Key Business Indicators (KBI) on brand, volume, mix, revenue, new outlets,

penetration, sales associate performance, outlet level Look-of- success, and compliance with channel specific Game

• Performed cost benefit analysis to pricing models to increase volume performance and drive business results

MARY ANN ERWIN-CPA CANDIDATE

Finance Analyst II ( Con't)

PepsiCo June 26, 2006 – April 30, 2009

• Supported the Gatorade BU in the developmental of manufacturing, budgets, forecasts and strategic plans for capital

• Supported departmental budget of $173 million by increasing the sophistication and accuracy of budgeting and

forecasting through process development

• Facilitated weekly meetings presenting Key Business Indicators (KBI) to NA Gatorade and Tropicana BU’s

• Improved financial and operation performances as a service contractor saving the company $100,000

• Assisted in the production of the user manual for the SAP Finance Module saving $50,000 in training cost

• Developed the business documentation process by identifying the system and software requirements for SAP capital

financing projects

• Negotiated pricing, terms and other contractual issues for Gatorade and Tropicana products

• Acted as Project Leader for Gatorade sports marketing by implement and managing the installation of and service

metrics for bag in the box fountain systems

• Consistently built and maintained strong relationships with vendors and customers through timely and effective

communication

• Processed and Reviewed Service contracts resulting in resulting in 5% increased Gatorade and Tropicana DSD Sales

Information Specialist II

College of DuPage, Glen Ellyn, IL April 2001- August 2003

Austin Peay State University, Clarksville, TN August 1998 - December 2000

• Forecasted and coordinated specific training and scheduling for computer technology and software needs.

• Project manager for Y2K, which included project planning for the testing of computer systems,

documentation, and replacement of both PC and software applications

• Coordinated the design and distribution of the Y2K flier to inform users on the purpose

• Provided software and hardware support and training in word processing, spreadsheets, relational databases,

communications, graphics and macro programming

MILITARY EXPERIENCE

Logistics Supervisor US Army, Camp Humphreys, Korea April 1995 - April 1998

• Managed a $3.1 million budget for 377th

• Managed the procurement and delivery of military supplies including electronics modules, aircraft engines,

petroleum products and spare parts

• Responsible for budget preparation and financial analysis ensuring commanders’ financials were within

budgetary requirements

• Responsible for preparing paper work for inventory management, shipping, purchasing, accounting and end

of month reporting

• Prepared and analyzed expenditure analysis, earnings schedule

EDUCATION

Master’s in Business Administration-Emphasis in Finance, Murray State University, Murray, Kentucky, 2001

Bachelors of Mechanical Engineering, University of Texas at El Paso, 1995

CPA preparation courses, College of DuPage, Glen Ellyn, IL 2006

TECHNICAL SKILLS

Software: Advance M.S. (2007 and 2003) Word, Excel, Access and PowerPoint, Hyperion, OLAP,

Business Objects

Operating Systems: Windows XP, SAP 3.0/FICO, Oracle 11g

Contact this candidate