JOEL G FERMIN

248-***-**** home

248-***-**** cell

SUMMARY:

Most recently acquired over five years of extensive work experience as a special project/business analyst in the R&D (Research and Development) Engineering support environment, collaborating with (R&D) product engineering team members, and other cross-functional team members utilizing PDM (Product Data Management) and PLM (Product Lifecycle Management) tools, (i.e. Enovia), along with MM (material management), PP (production planning), and Logistics modules in SAP, in order to best support and manage engineering change management activities (related to components and products – top assembly & sub assembly). I also worked as a senior analyst in finance and accounting in the automotive industry for over ten years utilizing ERP software tool-SAP ECC6 (FICO modules) for financial analysis and financial reporting activities.

ACHIEVEMENTS:

Created a system utilizing Excel to cross-check engineering Bill of Materials to Production (Serial) Bill of Materials and Service BOMs to ensure accurate builds and JIT manufacturing of top assemblies for timely shipments to the customer

Prevented failed service orders from customer (NISSAN) saving Faurecia Automotive Seating Company tens of thousands of dollars in expedite fees and other charges by developing and performing data mining procedures to identify NISSAN Service parts and by updating and revising EBOMs based on most current drawings released

Provided the current status of components in over 5,000 sub-assembly and top assembly BOMs to report BOM failure by combining, revising, and refining standard SAP reports into one summary BOM report

Successfully assisted in transitioning Takata Incorporation’s accounting and finance function from Greensboro, NC, USA to Hyderabad, India

Successfully performed data migration and data validation checks

Identified and defined gap analysis utilizing workflows, reports, interfaces, conversions, enhancements, and forms

Essential part of a team that successfully launched ENA (Eberspaecher NA) Commercial Vehicle business unit in North America by providing support with the roll out of the ERP system (SAP)

Assisted in transitioning/integrating a manual shop floor (prototype) operation over to SAP ERP system

Created the master files, Bill of Materials, and routings in SAP modules for Eberspaecher NA Commercial Vehicle business unit for the prototype shop and manufacturing plants

Conducted a special study by creating elaborate Excel spreadsheet analysis to precisely track the weekly inventory count of an essential component sourced from Japan (after the Earthquake and Tsunami in Japan, March 2011) that was used in manufacturing process, to determine when the parts would run out and determine the company's exposure to risk of production shut down due to lack of parts

Successfully completed an internal project to reconcile (particulate filters –containing precious metals) inventory, reducing write off by 400K

Successfully completed the Consumer Driven Six Sigma Green Belt Training sponsored by Ford Motor Company

EXPERIENCE:

04/14 – 10/16 Faurecia Automotive Seating – Auburn Hills, Mi – Contract w/Venteon

Title: Sr Business Analyst/Engineering BOM Analyst

Manage Engineering Change utilizing PDM (product data management) system (Enovia) and ERP system (SAP)

Track ECR’s and ECO’s (engineering change requests/engineering change orders) for accurate and timely management of bill of materials in the ERP system (SAP)

Translated engineering BOMs to Production BOMs by loading engineering Bill of Materials in SAP for NISSAN Serial Program

Cross-check engineering bill of materials to Production Bill of Materials and Service BOMs to ensure correct parts are being ordered and assembled for JIT manufacturing

Participate in weekly meetings with cross-functional teams to communicate status of NISSAN serial program

Generate and create Material Master Report and Plant BOM report on a weekly basis in SAP to track component revision levels for accurate BOM updates in SAP

Modified standard SAP Plant BOM Report to check the current status of components within sub-assembly and top assembly BOMs to check for content accuracy (correct drawing revision of components) of BOMs

06/13 – 09/13 Takata Corporation – Auburn Hills, Mi – Contract w/KForce

Title: Sr Business Analyst

Successfully assisted with the transitioning of the accounting and finance oversight function from Greensboro, NC to Auburn Hills, MI

Oversaw the training of the Genpact accounting personnel to offshore the SG&A accounting and finance function to Hyderabad, India

Reviewed the SOP’s (standard operating procedures) created by the Genpact team (outsourcing contractors) to assure daily, weekly, monthly, quarterly and year end accounting and finance activities were properly documented

Acted as an accounting and finance liaison to help guide the Genpact team to successfully accomplish their daily, weekly, and month-end accounting tasks and activities

Utilized PRMS (Pansophic Resource Management System – ERP system)

12/11 – 04/12 Herndonwood Associates - Bloomfield Hills, MI - Contract

Title: SAP Implementation Analyst

Consulting work associated with Faurecia North America acquisition of ACH (Automotive Components Holding Company – formerly a Visteon business unit)

Assisted with SAP implementation due to project falling behind schedule

Participated in the data validation and testing process in SAP AP (accounts payable – FI module, ACH legacy systems, CCAPS)

Documented full-cycle AP process – SAP Finance module

Worked with SAP ERP ECC6 FICO (Finance and Controlling) modules and ACH Legacy systems

05/08 – 08/11 ENA - Eberspaecher North America - Novi, MI

Title: SAP Special Project/Business Analyst

ERP System - SAP ECC6 MM (Materials Management) module

Created entire engineering master data files in SAP MM module, MM01 transaction (TEIL-component parts, sub-assembly, FERT-Finished Products-top assembly) for the CV (commercial vehicle) business unit totaling over 6,000 parts

Created, structured, and maintained SAP BOM’s (bill of materials) utilizing SAP CS01, CS02 transactions for new programs and new product releases in accordance with manufacturing process map

Knowledge of basic data structures and basic manufacturing processes (back flush points) for proper structuring of bill of materials

Managed component revision levels (related to engineering changes in geometry, dimension, and tolerance) in SAP MM module utilizing CC01 and MM02 SAP transactions

Acquired ability to read engineering blue prints and drawings by working collaboratively with designers and product engineers to track changes in GDT (geometry, dimension, tolerance) of sourced parts (components) and in-house builds; sub-assemblies and top assemblies

Setup and maintained Routings in SAP - CA01, CA02 transactions for new and existing programs for purpose of product cost collecting in appropriate work centers

Managed SAP MM module for commercial vehicle program by working directly with the Development Engineering group to implement on-going engineering changes related to components and products and reflecting the changes in SAP (bill of materials) and communicating the changes to the purchasing and material group partners for SAP implementation

Maintained quarterly product pricing and price adjustments in SAP (FI - Sales Module) for commercial vehicle program per the direction of account managers to prevent/limit retro billings in AR (accounts receivable)

Downloaded data from SAP to create reports for analyzing material surcharge data for customer pass through billing or customer payback depending on inflationary or deflationary economic conditions

Extracted actual monthly sales data(Outbound deliveries) from SAP system to create clear concise monthly summary sales reports utilizing pivot tables and charts for use in CV (commercial vehicle) business unit account manager’s and program manager’s sales trend analysis

Devised an excel spreadsheet to identify and prevent the duplication of parts being loaded in SAP bill of materials

Assisted program director with finance support (CVP – cost, volume, profit analysis) on annual budget and forecast rollout

Developed commercial vehicle parts matrix for quick V-Look Up reference

Other essential duties as assigned by CV (commercial vehicle) program director

10/07 – 05/08 Continental AG formerly Siemens VDO - Auburn Hills, MI - Contract

Title: Senior Business Analyst

Analyzed IT cost center charges – (SAP CO module) by projects and by account for current month and YTD reporting

Performed monthly review and reconciliation of Balance Sheet and Income Statement accounts – SAP FI/CO module

Responsible for accurately coding and monitoring internal charges with the appropriate account and cost

Reclassified costs from cost centers for proper accounting of cost and expense items

Miscellaneous journal entries based on GAAP principles - SAP FI/CO module

Month-end cost center accounting reports (MTD,YTD) results

Researched and documented cost center variances - actual compared to forecast and budget

Prepared monthly headcount report

Performed cost received analysis for 35 cost center /departments

Month-end closing procedures

Ad hoc projects; ie (AR Aging, Transfer pricing activities - Mexico operations)

System - SAP ERP (FI/CO) Finance and Controlling modules

04/07 – 08/07 Panasonic Automotive - Southfield, MI - Contract

Title: Senior Business Analyst

Monthly Budget, Forecast, and Actual financial preparation and variance analysis (Actual vs Forecast)

Monthly reporting of actual P& L and Balance Sheet results to VP of sales, VP of finance and department/business unit managers (SAP FI/CO-module)

Daily analysis of cash position

Miscellaneous month end journal entries based on GAAP principles including revenue recognition and expense accruals - SAP FI/CO module

Month end SAP R/3 data upload to Hyperion for Excel Hyperion Retrieve for actual, budget, and forecast reporting

SAP ERP (FI/CO) Finance and Controlling modules, Hyperion reporting package

01/06 – 02/07 Affiliated Computer Systems (ACS) - Dearborn, MI

Title: Senior Finance Analyst

P&L Actual vs Budget/Forecast Variance Analysis (Actual vs Forecast)

Quarterly Forecast Rollout & Annual Fiscal Year Budget Rollout

Prepared and reported monthly P&L activity for Managers, site CIO’s, and Senior-level financial officers

Prepared and entered journal entries according to GAAP to capture revenue and expense items for month end accruals-Microsoft ERP system

Other projects on as needed basis

Utilized Microsoft based accounting system

05/05 – 11/05 TRW Automotive - Livonia, MI - Contract

Title: Profitability Analyst

Business Unit/Cost Center Financial Analysis – Budget/Forecast vs Actual variance analysis

Monitored and tracked sales and price change activity

Monthly consolidation of pricing changes at the top level using Excel Hyperion Retrieve

Provided a consolidated summary of revenue (price) change activity by customer

Prepared and distributed monthly financial reports for senior-level managers

Other daily, weekly, and monthly tasks associated with product line profitability reporting

System - Hyperion Reporting Package, Business Objects and Pivot Tables

08/04 – 04/05 Ford Motor Company - Dearborn, MI - Contract

Title: Automotive Remarketing Services Finance Analyst

Business and Financial Analysis

Department budget coordinator – monitored administrative and selling expenses and department costs by keeping track of open purchase orders

Applied daily cash proceeds to drawdown bank account

Prepared quarterly invoices for Trustmark service fees utilizing Business Objects

Prepared and distributed monthly financial statements to finance and operations managers

Prepared month end journal entries - PeopleSoft finance module

Created desk procedures that are Sarbanes-Oxley compliant

Worked with internal audit to implement internal controls for Sarbanes-Oxley compliance

Legacy Systems – CCAPS, CPARS, Peoplesoft accounting system, Business Objects, and Access Database

01/04 – 07/04 Perot Systems Inc - Southfield, MI - Contract

Title: Financial liaison for Account Manager

IT Financial Analysis

Prepared and distributed financial reports to Account Managers

Prepared monthly and quarterly forecasts and annual budgets - PeopleSoft

Budget/Forecast vs Actual variance analysis

Application of GAAP compliance for expense versus capitalization treatment

Month-end close processing

ERP System - PeopleSoft accounting

06/01 – 12/03 Ford Motor Company - Dearborn, MI - Contract

Title: Business and Financial Analyst

Transitioned and implemented full-cycle Volvo North America A/P function from Rockleigh, NJ to Dearborn, MI (Note: Volvo North America Sales, Accounting/Finance offices were located in Rockleigh, NJ)

Trained Ford accounting personnel in full cycle SAP R3 A/P function

Monthly analysis of income statement and balance sheet accounts

Inter-company billings/settlements

Month-end close processing

Journal entry preparation based on GAAP principles - SAP FI/CO module

Preparation of daily and monthly financial metrics

In-transit inventory reporting

Worked with internal audit to implement internal controls for Sarbanes-Oxley compliance

Documentation of accounting processes for Sarbanes-Oxley compliance

Legacy systems utilized – CMMS, CCAPS, CPARS, SAP R/3 finance and controlling modules, PeopleSoft accounting system, BPCS, Business Objects reporting package

Education:

Bachelor of Science in Business Administration/Finance – University of Detroit Mercy

Contact this candidate