Manager Management

John D. Johnson

**** ********** ***** ? Rochester, MI 48306 ? 248-***-**** ?

******@*****.***

QUALIFICATIONS

Finance Manager with a successful record of identifying profit and cost

drivers, increasing profit margins, managing financial consolidations,

streamlining business processes, and creating uniform financial reporting.

Experienced in the areas of budgeting, controlling, variance analysis,

financial and non-financial reporting, and database administration;

proficient in all Microsoft applications, Hyperion, SAP, Oracle, and JD

Edwards software.

Master of Business Administration ? Walsh College of Accountancy and

Business, Troy, MI

Bachelor of Arts ? Economics ? Oakland University, Rochester Hills, MI

PROFESSIONAL EXPERIENCE

2/2010 - Current Comerica Bank Auburn Hills, MI

Position: AVP, Finance

Implement Project Accounting process

Manage the Accenture Cost Savings Initiative (7-year project)

Responsible for lease vs buy analysis / policy

Perform special projects to automate manual processes

10/2008 - 2/2010 Pitney Bowes, Inc. Troy, MI

Position: Finance Manager, Pitney Bowes Management Services

Managed Inventory, Balance Sheet, and Income Statement for 2 Divisions

Increased EBIT % from 5% to 13%

Managed cross-functional teams to build efficiencies within back office

operations

Cleaned up inventories and streamlined warehouse / inventory finance

operations

Created tiered-level management budgets and forecasts, and monthly

financial reporting

2009 budget responsibility of $20M (revenue/expense); $5M (inventory)

11/2005 - 4/2008 Volkswagen of America Auburn Hills, MI

Position: Financial Controller - IT (Company moved to Herndon, VA in May,

2008)

Also Financial Controller for Customer Care, HR, and Corporate Relations

departments

Managed IT budget in excess of $80M; full budget responsibilities in excess

of $100M

Performed all annual budgeting, monthly forecasting, and variance analysis

for four departments

Managed cross-functional teams to build efficiencies within IT / PMO

operations

Approved all IT project spending during weekly IT Charter Committee

meetings

Managed capital vs expense budgets for all stable business infrastructure

projects

Reviewed and approved all IT vendor contracts; managed IT vendor

relationships

Strong project management finance experience; worked closely with PMO

senior management

Year-end budget performance exceeded company expectations all 3 years

1/2005 - 11/2005 American Axle & Manufacturing Detroit, MI

Position: Financial Systems Administrator

Managed monthly financial consolidations and data integrity for 24 plants

worldwide

Administrator of Hyperion Enterprise and Upstream WebLink software

Worked closely with Oracle Administrator to ensure proper data flow and

data accuracy

Responsible for M/E closes, including currency translations and inter-

company reconciliations

Provided variance analysis for monthly financial results

Assisted finance management with the preparation of external financial

reporting

John D. Johnson

3048 Bridlewood Drive ? Rochester, MI 48306 ? 248-***-**** ?

******@*****.***

6/2002 - 1/2005 GKN Sinter Metals Auburn Hills, MI

Position: Manager, Financial Systems

Managed monthly financial postings and data integrity for 38 plants

worldwide

Administrator of Hyperion Enterprise and Upstream WebLink software

Worked closely with BaaN Administrator to ensure proper data flow and data

accuracy

Responsible for M/E closes, including currency translations and

consolidations

Created and maintained monthly "Blue Book" for executive management team

Managed all executive management teams' and regional controllers' financial

ad-hoc reporting

5/2000 - 6/2002 Kmart Corporation Troy, MI

Position: Financial Analyst IV

Created financial analysis and spreadsheets to project sales forecasts

Created variance analysis reporting to measure weekly performance vs. plan

Maintained financial planning models within JD Edwards application

Extracted data into Excel via Hyperion Essbase models

Managed all day-to-day technical and financial operations and G/L postings

in JD Edwards

Responsible for M/E and Y/E closes and monthly G/L account reconciliations

7/1999 - 5/2000 St. Joseph Mercy Hospital Bloomfield Hills, MI

Position: Financial Analyst - MPS (Merged with Holy Cross Health System in

May, 2000)

Created M/E financial statements/analyses for physicians' practices

Maintained site performance benchmarks/analysis; capitation & RVU's

Assisted with all budgets, forecasts, and physician performance

presentations

Performed all system integration, database mapping, and G/L interfacing

Analyzed historic trends and account performance by cost center

Created several Access databases, spreadsheets, data models, graphs

4/1989 - 7/1999 Fleet Leasing Corporation Troy, MI

Position: Senior Financial Analyst

Promoted from Accountant to Senior Financial Analyst

Super user of Hyperion Enterprise software

IT Liaison for Finance department; assisting with system changes and report

creation

Performed daily / monthly journal entries and processed daily A/R and A/P

activity

Performed M/E and Y/E closes, maintained G/L, and prepared financial

statements

Performed daily treasury functions - wires, checks, and ACH transfers

SOFTWARE

Hyperion Enterprise

Hyperion FDM (UpStream WebLink)

SAP FI/CO R/3

JD Edwards

Oracle

BaaN

Info-Lease

Microsoft Excel

Microsoft Access

PowerPoint

Contact this candidate