David L. Zehr

**** ******* **

Chandler, In *****

Phone: 812-***-****

EMAIL: abn6u5@r.postjobfree.com

Professional Summary

A seasoned Accounting and Oracle professional who has worked in

manufacturing industries and the government sector obtaining progressive

experience in a wide range of positions, which provided the opportunity for

leadership, written/verbal communication, and quality workmanship within

the organization. Expertise in all areas of Controller/Staff Accounting

positions, cost management, plant experience also having worked as a

consultant to several manufacturing plants in US and Mexico as a startup of

new organizations and implementation of new ERP systems. Recent experience

is having worked in the government sector on the deployment team

implementing Oracle apps for sections of the military. A consultant who

has the experience from the client and the consultant side of the

implementation, good at building relationships with the client, as having

lived in their position on several stages of implementations.

. Solid background of experience in Costing, Month End Closings,

Forecasting, Budgeting, Inventory Control, Capital Expenditures

. Proficient with 11i and R12 Oracle Applications Cost Management,

Inventory (INV), Bill of Materials (BOM), Work In Process (WIP),

General Ledger (GL)

. Experienced with the creation of setup documentation for system

implementations including creation and validation of BR100's and like

documentations.

. Experienced in rolling out the ERP systems at plants in US and Mexico.

. Experienced in training all levels of plant personnel.

. Worked on documents and processes for Sarbanes-Oxley (SOX) Compliance

in multiple companies.

. Worked on multiple ERP systems like Oracle Applications, COPICS,

Avalon and SAP

. Plant Controller for an $80 million plant responsible for quoting

standards, item motion study on plants, overhead rates. All of these

rolled up to the controller.

. Cost Manager for a $350 million, tier 2 automotive supplier who was in

the process of implementing Oracle as its' ERP system.

Work History

Independent Consultant

December 2011 to Present

December thru January : Review and trouble shot an instance set up to

assure that Oracle setups of inventory and related applications were

providing correct information and the results that Oracle was providing

were consistent with actual plant performance.

February 2012 to Dec 28, 2012: Member of the Deployment team of the USMC

project, primary functions relate around the BR100 creation, validation of

application set up and help trouble shoot potential issues with setup and

user knowledge. Deployment team successfully completed their assignment on

12/28/2012.

Manager Projects and Special Assignments November 2009 to

November 2011

As of 8/29/10 VP of Business and Finance

Assigned system review and upgrade of various processes. Working as

Project manager to choose operating system that will meet our needs and

allow for future growth. As of 8/29/2010 became head of finance

department.

Work related as consultant

Independent Consultant

March 2006 to November 2009

Worked for various consulting firms as either a sub-contractor or employee

depending on the wishes of the firm. Some of the clients and my duties are

listed below. References can be provided if required.

Internal company project for consulting firm

Nov 2008 to April 2009

(Company: Terillium)

Between projects with the consulting firm that I was employed, worked on

various company related projects. These included UPK documentation of

scripts for future use, Internal build for certification of team members

for accelerator projects and worked with our technical group to develop

cutover process for Items, BOM's, Routings, and related items for setup of

new instances. Also participated in search for potential new clients.

Responsible for apps BOM, Inventory, Costing and worked in conjunction with

consultants who were responsible for WIP, MRP, Purchasing and Engineering.

Manufacturing Lead Hardware and Consumer Prod Mfg March 2008 to

Nov 2008

(Company: Terillium, Client: Knape and Vogt)

Using the Oracle Accelerator approach worked as an implementation

consultant responsible for Inventory, costing, and BOM using Oracle R12.

Completed functional design and supplied client with BR100's and MD50's for

setups. Conducted core team training, direct client through cost design.

Facilitated all conference room pilots, completed gap analysis and

associated resolutions. See apps listing above.

National not for profit charity

Nov 2007 to Dec 2007

(Company: Clear Peak, Client: Feed the Children)

Worked as part of an independent group to do an ERP assessment and a GAP

analysis to determine the potential for growth in a "Not for Profit". Used

interview, flow charts and GAP documentation to determine what the

potential was for this organization to grow with the least amount of

expenditures.

National Manufacturer homebuilding industry

July 2006 to Oct 2007

(Company: GCI-International, Client: USG)

Worked with the client's wants and needs using Oracle Software to help them

solve the business needs that are present in their current market

conditions. The goal was to make the most of the software's capabilities

and the resources of the client to make a smooth flow of data and

information to help make business decisions.

Responsibilities

My responsibilities included the audit of data (BOM and Routings) to ensure

that Oracle setups were in line with the legacy buildups of the past.

Costing was a main focus with the cutover of items, the cost of

manufactured items along with the set up of new items with an initial cost

before the system generating the costs relating to accurate information for

Oracle to process correctly I also taught the process to be used to update

data after conversion to the new system. I did 1 on 1 training, review of

Oracle results and worked with the staff that was responsible for system

accuracy after we left. We also trained them the proper way to correct

system problems. I dealt mainly with Cost, Inventory, Production, and

General Ledger. I also have had some experience with BOM, Routing, OEM,

AP, and related applications especially as they relate to Inventory and

Cost.

My Work history in Industry

Airtex Automotive Products

March 2005 to July 2006

As a part of automotive industry this OEM manufacturer is a leading

manufacturer aftermarket water pumps and mechanical and electric fuel pumps

and assemblies. This manufacturer went through a company wide

implementation of Oracle Applications 11i in 2004-2005. Its legacy systems

were JD Edwards applications.

Cost Manager

Responsible for the standard cost system, updating of the yearly standards,

the physical inventory and the reconciliation between the perpetual and the

trial balance. Also had responsibility for various corporate reporting

including various reports for the corporate auditors, Inventory

Reconciliation report, Use and Comparison reports between operations and

prior years etc.

. Inventory Controller

. Involved in the requirements, implementation, go-live and post

implementation support of Oracle Applications 11i implementation

project. Duties included the development of training documentation,

delivery of end user training and post go-live support, preparation of

test scripts related to Inventory system and performance of system

module, integration and user acceptance testing.

. Rolled cost in JD Edwards system before go-live for Oracle

Applications so that the data that was converted was accurate before

bringing into Oracle Applications.

. Responsible for Inventory month-end close, inventory period close and

inventory reconciliation processes

. Worked to improve Internal Control documentation and to implement

needed improvements. Met with internal auditors, documenting the

current process. Identified the gaps and made sure that the gaps were

closed in documentation as part of Sarbanes-Oxley (SOX) Compliance.

E.g. E&O (Excess & Obsolete) process.

. Developed new standards ready to be rolled into Oracle Applications

after mapping existing structure into Oracle Applications and helped

to resolve issues that arose during implementation and post

implementation phases. For example:. Initially the way the costs were

put in Oracle Applications did not give accurate results. After in-

depth analysis it was determined that Automotive BOMs have sub-

assemblies sourced from various locations (organizations/warehouses in

Oracle Applications). To get accurate costing, traditional cost roll-

ups did not present accurate results. Hence, we had to implement

supply chain cost roll-ups which would consider standard cost across

organizations to make sure that supply chain cost roll-up worked.

. Led the team responsible for 2005 Physical Inventory and Year End

Close in Oracle Applications.

. Assisted with the margin analysis reports. These are required to be

monitored daily, monthly and quarterly.

Kimball International (Heritage Hills) 1983 to March 2005

Controller

We were a contract furniture manufacturer specializing in the entertainment

industry. Main product line was television cabinets for the projection TVs

for the major manufactures in the market. We moved from using manual

systems to COPICS ERP system. Several years later it migrated to Avalon

ERP systems in their US and Mexican operations.

. Primary responsibilities included Costing, Month end Closings,

Forecasting, Budgeting, Inventory Control and Capital Expenditures.

. Over the years at the plant level, I was part of the team that

implemented 3 ERP systems. Upon the implementation of Avalon this was

a change from an actual to a standard costing system. This involved

the education of the management on the variance accounting principles

and setting and

. Maintaining of the standard costs in the Avalon system. The

implementation was a 6-12 months project.

. There were 4 manufacturing plants, 2 in US and 2 in Mexico for sister

companies. Led the team to implement costing part of ERP systems in

these plants. Interacted with personnel at different levels to

develop the cost structure for satellite operations, selling prices,

to include the sales price, developed the plant overhead rates and

developed cost saving strategy with our customer to share savings with

our customer who to justify our move to the foreign markets.

Developed cost saving and sharing with the customers.

. Helped train the Controller, Cost accountant and staff accountant in

how to use the Avalon system in Mexico plants. Worked with training

and testing in the SAP implementation in US plants. Implemented an in-

month review of our financial situation. This allowed the management

staff to react and make changes to the present month to maximize the

current month results. The Avalon system allowed us to create

periodic financial statements to review the current month's trend.

. Worked to revise our documentation to meet the upcoming Sarbanes-Oxley

requirements.

Kimball International ( Artec)

1982 to 1983

Responsible for all general accounting functions.

. Converted from a manual system to a computerized spreadsheet format.

Kimball International (Jasper Stylemasters)

1976 to 1983

Responsible for duties of the assistant controller.

Kimball Int. General Office

1975 to 1976

Responsible for cash and accounts payable

Education

UNIVERSITY OF EVANSVILLE, Evansville, IN

MBA - August 1984, GPA 3.33

INDIANA STATE UNIVERSITY OF EVANSVILLE, Evansville, IN

BS - Accounting; minor in Data Processing and Liberal Arts, June 1975, GPA

3.32

Contact this candidate