Provides EDI Analytics support to Sales and Customer ServiceOracle Master Data and TraceLink Master Data adminstrationAssists in data reconciliation for ETL activities

Provides MDM and Business Analytics support to Supply Chain OpsOracle Master Data and TraceLink Master Data adminstrationAssists in data reconciliation for ETL activities

• Provided innovative solutions to overcome legacy system constraints and developed analytical tools and metrics required to assist Supply Chain Operations group as the company transitioned to a new ERP system.• Oracle Operations Business Lead / SME for ASCP, Formulator, Formulator Chemist, Master Data Management, MES and Production • Wrote Work Instructions for ASCP, Formulator, Formulator Chemist, Master Data Management, MES and Production • Created supplemental training aids using Oracle UPK Developer. • Conducted training for personnel on use of Oracle ERP modules.

• Inventory and Supply Analysis - developed, implemented and maintained a 26 week report for use in prioritizing and risk assessment. Also created a warehouse replenishment report used by Distribution to maintain correct inventories and ensure service level.• Other responsibilities include trend analysis and the creation, manipulation, analysis and presentation of data for executive management analysis. • Provided training for Planning as well as Manufacturing personnel in the use of Oracle and other business-related software applications.• Planning Manager for Functional Chewables Global Ops - responsible for forecasting, rawhide procurement, master production scheduling, warehouse inventory replenishment and capacity planning. Provided quarterly budget reports, sales/inventory analysis, SLOB inventory action recommendations to Management.• As a member of the Harper acquisition due diligence team, acquired sales and inventory data and prepared reports for Executive review.• Spent 6 months traveling to Ohio to help integrate new plant into Hartz MPS/MRP system. Used a modified APICS formula for Reorder Point Planning that determined optimum stock levels which resulted in increased service levels while reducing inventory by a significant margin. Savings in excess of $2 million were realized within 5 months of implementation while service levels improved from 95% to 98+%. This method of Planning was then applied in Hartz manufacturing facilities in Indiana and New Jersey.• Introduced the use of Microsoft Access integrated with an Oracle server for enhanced and systematic retrieval and dissemination of production, sales and inventory data. Initiated the use of Dataload macros and SmartPad routines in Oracle to facilitate the application of repetitive tasks and increase employee productivity.• Pre-Oracle implementation, created and implemented an MS Access-based MPS/MRP system used by the New Jersey manufacturing facility.

• Assisted in the initial purchase and installation of computer hardware and software for Merry Heart Health Care Center. • Trained key personnel in Lotus Smartsuite applications, and in MDS+, a proprietary Medical History and Billing software.• Developed a simple order entry and inventory system using Lotus Approach.• Designed logs and created admittance brochures and mailers using Amipro and Corel 3.

• Utilized MRP, Bill of Materials, and production work orders to monitor inventory flow of raw materials and finished goods. Created component shortage reports and worked closely with the purchasing department to ensure timely delivery and optimal levels of raw materials to support production schedules.• Prepared effective production schedules for multiple production facilities and lines in order to maximize yield, meet customer request dates, and optimize operating efficiency. • Assisted in the training of the office staff on the use of Smartsuite software, and created a six-page guide to help new users navigate between inquiry screens on the AS400 network.

• Administered Shop Master Scheduling, including management and oversight of junior staff.• Used written and verbal communication in discussing production issues with manufacturing personnel, vendors and customers. • Assisted MIS Manager in computer hardware/software installation, support and training.

• Specialized in completion of quick turnaround prototype circuit boards from design review to final QA • Performed the circuit design review for functionality and adherence to mil-spec standards, production planning and, as needed, some phases of production of printed circuit boards.• Coordinated the various phases of production according to customer specifications.• Interfaced with customer engineers regarding design problems and recommended modifications.• Expedited jobs by troubleshooting any process problems.• Performed 1st article inspection for possible artwork and programming problems.• Performed Photo QA, artwork lay-up and darkroom tasks.• Operated Excellon Mark III and Mark V CNC Drill machines.• Operated LaserPhotoplotter and Film AOI equipment.