QAD Finance, Manufacturing and Distribution implementation expert

Sam C. Galea

***** **** **., ******, ** *****

Cell #734-***-****

E-mail- *********@*****.***

SUMMARY Over 25 years of IT experience including extensive functional experience in

Finance, Manufacturing and Distribution. Over 31 years of experience in accounting. Some experience managing projects. Performed successfully as a consultant in several full cycle QAD implementations. Involved in several upgrade projects and coordinating a post-implementation support project. Experienced in Requirements Analysis, Master Data Requirements, Configuration, Documentation, Support, Troubleshooting, Development, and End-User Training. Extensive knowledge of the database definitions (tables).

SOFTWARE QAD MFG/PRO 8.6C, EB, EB2 SE, EE, AUX, Data loading Tools, Office 365, PowerPoint, MS Visio, MS SharePoint.

LANGUAGES: Progress

APPLICATIONS Financial: Product Costing, Cost Accounting, Accounts Receivable, Accounts Payable, General Ledger, Multiple Currency, Sales Analysis. Evaluated Receipt Settlement (ERS), Consolidated Financial Statements, Financial Report Writer, Budgeting within QAD, Global Tax Management, Creation of Browses within QAD.

Distribution: Addresses, Inventory Control, Cycle Counting, Order Entry, Purchasing, Sales Orders/Invoicing, Shipping, Distribution Requirements Planning (DRP), Warehousing. Trade Sales, Labels

Manufacturing: Bill of Materials, Routings/Work Centers, Repetitive, Material Requirements Planning (MRP).

EDI: In-depth understanding of how SNF are received, transformed through system maps into the data tables within QAD.

EDUCATION B.Sc. in Business Administration, Wayne State University, Detroit, Michigan.

Certifications in QAD Finance and Distribution Modules.

WORK EXPERIENCE (35+ years)

12/23-Present Lead Consultant QAD ERP– Infosys, Richardson, TX

Project using QAD AUX

Involved with an implementation of the Financials using the Excel Integrations in the General Ledger, Fixed Assets, Budgets and other Modules of QAD.

Involved with the base setups in QAD.

Extracting data from old versions of QAD For the purposes of loading into QAD AUX

Trained using Project Management tools at Infosys using their LEX training package.

Obtained training on the AI (Artificial Intelligence) functionality.

Received 40 Certificates of Completion from their on-line training programs.

04/20 – 12/23 Business Analyst QAD ERP, Teijin Automotive Technologies, Auburn Hills, MI

Involved in several Plant implementations.

Implemented line charges for the Honda Supplied Parts

Troubleshooted and corrected issues with items received and not removed from reports along with other issues that items were not removed on other Accounts Payable related issues.

Involved in the creation of browses for the Plants.

Created Specification documentation for development of reports for the programmers.

Involved in getting the plants up and running after a cyberattack.

11/17 – 12/19 Supply Chain Consultant QAD ERP, Mueller Industries, Memphis, TN Port Huron, MI

Assisted in the upgrade from 8.5G to 2016EE of the Marysville, MI Plant

Involved in the successful Upgrade from 8.5G to 2016EE of the Forging Plant at the Port Huron location; with the emphasis on shipping.

Tested shipping documents, barcode shipping process and shipping label testing.

Involved in the upgrade of the Brass Rod Mill plant in Port Huron, Michigan

Creating programming documents for the upgrades

Investigating various shipping methods when no barcode scanning is used in the shipping process.

Use of ERS to pay intercompany shipping and receiving.

Developed a process to control sales and the scrap buyback program.

Created/Modified Browses using QAD.

06/17 – 11/17 Business Consultant, Thirdware, Plymouth, MI

Hired in preparation for an implementation project.

04/02 – 06/17 Sr. IT Business Analyst, Lear Corp, Southfield, MI.

Acted as Implementation Lead for Accounts Receivable, Accounts

Payable, Product Costing, Variance Analysis, General Ledger, and Multiple

Currency data on QAD MFG/PRO ERP implementation at manufacturing

plants in North America, and Mexico.

Supported users for the Electrical system division in the areas of Customer Maintenance, Sales Orders, Shipping, Customer Part Cross Reference.

Support the implementation of the ADG initiative in the area of Trade Sales. This is where the component part is manufactured at a supplier and is sent directly to the OEM. Provided ERP functional application support to 23 manufacturing facilities.

Conducted discovery interviews with each department manager in the plants, to understand current business processes and gather example reports used to run day-to-day operations.

Developed GAP Analysis between plant’s Legacy systems functionality and MFG/PRO.

Responsible for data migration such as General Ledger History, product lines, open Purchase receipts, bills of material, price lists, inventories and pricing from plant legacy system into MFG/PRO, using MS Excel spreadsheets to extract. Cleanse and load data.

Responsible for preliminary research of Service Requests for MFG/PRO system enhancements mainly in the manufacturing modules.

Wrote detailed functional requirement specifications of user needs, program functionality, and steps required to modify MFG/PRO system programs in Progress.

Worked with plant’s finance on the ERP implementations to define Product Line Codes for each Vehicle Platform/Model and Product, define Cost Centers, Departments, and Work Centers, and verify standard costs for the first Cost Roll simulations of manufactured parts.

Trained plant Finance personnel, on Bills of Material, and Manufacturing Routings to capture Direct Material, Direct Labor, and Overhead costs including root causes of variances. Instructed them on the accounts payable, accounts receivable, general ledger functionality.

Designed business processes by creating process flow diagrams in MS Visio Professional to map out newly designed processes with ERP functionality.

Responsible for maintaining Data Standards in the Finance areas.

Developed and maintained Finance training documentation in MS PowerPoint listing data standards, process flow diagrams, reports, and data auditing steps for end users. Including the use of the software own process flows.

Used ERS to pay for all Raw Material purchased.

Sending data from QAD to Hyperion for the purposes of Consolidating Financial Statements

Responsible for testing and script documentation on implemented application enhancements.

Worked on EDI implementations for supplier & customers, Covisint,

Gentran 6.0, E-Commerce

Created required reports for the operational and financial departments.

Extensively used Results Report Writer for ad hoc reporting purposes.

Environment: HP/HP-UX, MFG/PRO v8.6C, 9.1eB, eB2, 2007.1

05/97 - 03/02 Sr. QAD Business Systems Consultant, TRW, Inc, Livonia, MI

Clients: Caterpillar, Inc – Pontiac, IL 2000

Ace Controls, Farmington, MI, 1999

Delco Remy, Moncton, New Brunswick, Canada & Montreal, Que 1999

Fapco, Inc, Bucannan, MI 1998

Intertech Systems, Bardstown, KY. 1998

Erie Mfg, Milwaukee, WI 1998

Datex Ohmeda, Madison, WI – Louisville, CO – Atlanta, GA 1998

Elco Textron, South Bend, IN 1997

Liposome, Princeton, NJ 1997

Dura Automotive, Mancelona, MI 1998

Conducted discovery interviews with each department manager in the plants, to understand current business processes and gather example reports used to run day-to-day operations.

Developed GAP Analysis between plant’s Legacy systems functionality and MFG/PRO.

Responsible for the complete implementation of the MFG/PRO system @ Ace Controls. This involved work orders with full manufacturing, sales applications and shipping using standard shipping functionality, MRP/DRP and full financials.

Worked with the accounting group at all facilities to the use of the general ledger report writer.

Trained plant personnel in the use of QAD, Manufacturing, shipping and financials @ the Datex Ohmeda in Louisville, CO

Attained adjunct faculty status with Wayne State University, Detroit, MI in 1997

Implemented MFG/PRO in Automotive, Medical, and Industrial manufacturing facilities at various locations.

08/94 - 05/97 Senior Plant Accountant, Lucas-Varity, Fenton, MI.

Prepared ISO 9000 procedures for the purchasing area

Reduced overtime in the accounting area

Introduced the development of procedures manual in the accounting area.

Installed Financials portion of the MFG/PRO software in the accounting area.

Implemented Work Center, Departments, routings and verified all cost were the same from the legacy system to MFG/PRO

Prepared Budgets, Financial Forecasts and month-end statements

Additional Experiences: Worked with the Boy Scouts of America – Adult counselor for three Citizenship

merit badges. Adult leader at summer camp responsible for signing up Scouts for

their merit badges. Adult committee member for Troop 416 in Saline, MI.

Chairman of the Cub Scout Leader training program

Contact this candidate