Sales Analyst

Frank D. Chan, Jr.

[pic]

*** ******** ***** ( Columbus, Ohio 43213 ( cell 248-***-**** (

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

EDUCATION

[pic]

. Franklin University - Columbus, OH

Bachelor of Science in Business Administration Majoring in Accounting

. Central Ohio Technical College - Newark, OH

Associate of Science in Business Administration Majoring in Accounting

EXPERIENCE

[pic]

Temporary Assignments

Hexion Specialty Chemicals - Columbus, Ohio March 2010 to April 2010

Financial Analyst - Intercompany Accounting, Invoicing, Loans & Interests,

SAP, Pivot tables.

Wasserstrom Company - Columbus, Ohio October 2009 to November 2009

Freight Payables - Processing, coding & research online UPS freight

payments via CT Logistics.

Birchwood Foods - Columbus, Ohio February 2009 to May 2009

Maintenance Analyst - Sourcing, ordering, requisition & purchase order

preparation of maintenance parts/tools and plant supplies. Inventory

Control and summarizing of expenses.

Limited Brands -Beauty Avenues - Reynoldsburg, Ohio September 2008 to

January 2009

Costing Analyst - Compiled costs based on vendor RFQ, update Vendor Profile

and contacts.

Exel, Inc - Westerville, Ohio June to September 2008

Real Estate Project Analyst - Proof read, organize and archive property

leasing & legal documents.

Prepare Leasing Property budget expenses.

United Security Management Services - Columbus, Ohio October 2008 to

Present

Security Concierge - Road Patrol, monitor surveillance camera, and monitor-

building activities.

Misc. Temporary - November 2007 to Present - Shuttle Driver, Document

processing.

Continental Teves (formerly ITT Automotive) - September 1985 thru October

2007

Manufacturer of Automotive Brake Components - ABS antilock brake system,

ESC electronic stability control, caliper, booster, TMC tandem master

cylinder, wheel speed sensor, crash avoidance and other electronic

products. North America annual Sales exceed $ 1.0 billion with plants in

USA and Mexico.

Senior Financial Analyst - Headquarter & RDE Center Auburn Hills, MI

. Responsible for managing the North American FIRE (Financial Reporting)

system process, coordinating Strategic Plan/Budget/Forecast

preparations, Headcount reporting, Sales Analyses of 15 Product Lines

and training of Finance team members

. Responsible for maintaining the Hyperion Financial System, Prototype

Billing via SOS Special Order System, and RD &E reporting.

Senior Financial Analyst - Manufacturing Plants - Culpeper, VA - Asheville,

NC - Henderson, NC

Supervisor Plant Cost and Operations Analysis

. Conducted Month-end closing and annual Physical Inventory

. Implemented the BPCS Business Planning and Control System

Manufacturing System

. Provided assistance in plant startup Henderson, NC

. Lead training of Finance staffs in Asheville and Henderson, NC

ACCOMPLISHMENTS

[pic]

. Lead the review and updated Bills of Material versus Engineering

Drawing at the Culpeper, VA plant in conjunction with Manufacturing,

Purchasing and Engineering.

. Trained key financial users within NAFTA locations on the operational

use, organizational structure, databases available, and methods used

to retrieve financial data in a standardized reporting format.

Traveled to Mexico, Virginia and North Carolina to familiarize users

in utilizing Excel upload models.

. Developed Excel files to upload and retrieve financial data.

Maintained communications between various headquarters and the

manufacturing plants of the FIRE (FI nancial RE porting) and Hyperion

reporting structure changes, processes and database revisions.

. Developed Excel Sales model spreadsheets to track volume, revenue,

price, cost, and margin by product, by customer for budget, actual,

forecasting and strategic planning.

. Developed Excel PCIS (preliminary commitment information sheet), a

quotation model based on volume, selling price, cost, capital

spending, and depreciation probabilities by customer product mix,

including Pro forma Income Statement and Balance Sheet by year.

SKILL SUMMARY

[pic]

. Responsible and establish Standard Costs on a full absorption cost

basis for multiple products (Diesel engine, Brake Caliper & Booster,

Anti Lock Brake System, Power Tools).

. Communicated updates to financial procedures between various

Headquarters and NAFTA locations while providing a key link to

facilitate preparation and submission of financial data.

. Conducted Month-end closing and annual Physical Inventory

. Trend Analyses

o Cost & Expense Variances

o Mexico Sales Commission split between North America & Europe

o Sales by State & Country for State & US Federal Tax reporting

o Accounts Receivable Customer, Accounts Payable by Vendor, Capital

Expenditure

SYSTEM IMPLEMENTATIONS

[pic]

. FIRE FI.nancial RE.porting System-Key North America contact to facilitate

implementation of the Continental World Wide reporting system initiated by

Hannover, Germany. Ensured all product lines data were properly coded to

the FIRE Chart of Accounts from Hyperion.

. MPC Manufacturing Product Cost - Automated standard cost accounting

systems developed for Cummins Engine Company. Maintained the standard

cost per BOM Bill of Material along with preparing the horizontal flow

analysis of the MPC system.

SKILLS / OTHER

[pic]

. American Management Association Course on Financial Analysis

. KPMG IFRS International Financial Reporting Standards Seminar

. SAP, SAP Business Warehouse, Hyperion, CMI, BPCS, McCormick and Dodge

. Institute of Management Accounting - Charleston, SC

. United States Army Specialist 5/E5 Sergeant Micro Electronic Repairman

27F20

Contact this candidate