Rod Johnson
Phone: 248-***-**** E-Mail: ************@*****.***
OBJECTIVES
Building on multiple skills in Finance/Accounting. Work for a thriving organization. To collaborate with a committed team that aims to deliver reliable information, helping people make informed choices and improve the quality of products and services.
QUALIFICATIONS
Twenty-five plus years of financial analysis and accounting in both manufacturing & corporate environments.
Core Competencies
Cost Accounting- Cost Review/Variance Analysis/Absorption/Usage
Physical Inventory Auditing (SOX Compliant)
Cycle Count Testing/Standard Cost Rolls
BOM Analysis/Capacity Planning/Inventory Turns
ERP Implementation- Part of two new system implementations. Corporate
representative for JD Edwards (One World) SAP
implementation
Financial Analysis - Built Budget reviews based on previous results and
current forecast models. P&L statement analysis and
cash forecasting. Financial Statement modeling, based.
on different financial variables.
Computer Skills
Excel/Word/Access Hyperion Database Query Building
Pivot Tables/V&H-Lookups ERP Data Mining Macro Creation
Google Sheets/Docs/Slides
EDUCATION
Bachelors of Accountancy, Walsh College GPA 3.4
MBA-Finance Program, Walsh College GPA 3.8
ISO 9001 Auditor Certification
EMPLOYMENT
05-201*-**-**** Senior Inventory/Cost Manager, FCA/Stellantis Auburn Hills, MI
Developed a Purchase Order Issue Tracking System 2025
Transitioned an Office Team from Poland to India 2025
Lead Product Cost Study Assembly Model Year 2020
Created and Administrator MGA Assembly SharePoint (Designed and Administrate)
Google Guide and Lead for MGA Assembly/Manufacturing (On Google since September 2018)
Maintained current ASCM Cost Structure. Part of the Product Cost Study
Manage multiple Fiat Services analyst on SIR/Shipper related transactions.
Lead on PO related variances and reconciliation
Worked with Multiple Departments to Resolve Cost Issues Including:
o(Engineering/Assembly/Manufacturing/Aftermarket)
Analyzed and generated cost records for missing standard costs.
Managed multiple plant Inventory Records Monthly Blackline/OneStream Reconciliations.
Accountable for overseeing monthly and quarterly reversals of intra-company transactions in transit.
Analyze cost of sales vs stock status movements and reclass identified differences to Cost of Sales/Inventory
Performed a Deep Dive Audit on CAD Corporate Car
02-201*-**-**** Senior Financial Analyst, FIAT Services Royal Oak, MI
Managed multiple analysts during month end process.
Lead on Intercompany Inventory Transaction Resolution
Work with Multiple Departments to Resolve Cost Issues Including:
o(Engineering/Assembly/Manufacturing/Aftermarket)
BOM Analysis and Cost Rollup for Multiple Suppliers and Plant Locations
Managed Unmatched Single Inventory Records Monthly Reconciliation for Thirteen Profit Centers
Created Month End Inventory Reconciliation Process That Reduced Creation Time and Manual Calculations
Build Month/Quarter End Entries Including Inventory and Expense Accruals
Resolved Non-Reconciled Accounts Payable/Inventory Transaction Matches Between Multiple ERP Systems
06-201*-**-**** Cost Accountant, EO Tech Ann Arbor, MI
Lead on improvement Initiatives/LCM & Inv. Reserve Analysis
Built a Process for Physical Inventories
Lead on Cycle Count Program
Responsible for all Manufacturing Journal Entries
Perform Product Performance/Absorption Analysis
11-200*-*-**** Financial Consultant, Experis (Jefferson Wells), Southfield, MI
Clients: Chrysler, GM, Lear, Tecumseh, Detroit Schools, Others
Built new audit procedures for SAP Variance Account Analysis (Chrysler)
Review Supplier Contracts to find errors, missed reductions and contract negotiation opportunities. Recovered over three million dollars (GM)
Valued & Booked Cost Savings for Chrysler Purchasing (Scorecard Analysis)
Auditing Purchases Orders for validity for transfer to an SAP Implementation (Chrysler)
Analyzed and provided updates for metal market indexes for all Chrysler Purchase Orders.
Conducted an audit of standard material costs for consigned materials, which identified misappropriated assets valued at eight million dollars.
Built Audit Procedures For both consigned and pseudo consigned inventories (GM)
Managed cost structures for scrap steel inventory pricing based on the American Metal Market averages (GM)
Forecasted scrap and processed steel shipments for multiple steel mills and steel processors (GM)
09-200*-**-**** Cost Accountant, Honeywell Troy, MI
Directed physical inventories at multi-million-dollar warehouses.
Built a Perpetual Inventory Tracking System for Asbestos Inventory that saved the company $500k.
Built an excel worksheet that calculates the values of Excess and Obsolete Inventories
Built and maintained a cash distribution forecast that assisted management in cash flow analysis.
Helped create a link to two ERP databases that reduces cost variances.
Created cost studies to determine if new products would be profitable.