Patrick Dunlevy Email & Phone Number

West Springfield, Ma, Us

West Springfield, Ma, Us

Fort Lauderdale, Fl, Us

East Hartford, Ct, Us

• Management of purchasing and production planning for multiple locations across the U.S.• Maintain both finished goods and raw materials projections for order planning• Collaborate with Sales Management and Territory Sales Representatives on sales projections by regionand product• Maintain approximately 1,000 item records in the ERP system• Work with Procurement and Sourcing to maintain vendor pricing and specifications in ERP system• Issue and follow up on purchase orders for all raw materials ensuring the proper pricing, location andETA according to inventory needs• Issue work orders to various production locations to produce finished goods. Work with local Production Managers to re-prioritize work orders based on sales and stocking needs and raw material availability.• Play a key role in the Product Label process as the liaison between New Product Development, LabelImprovement, QA/QC and Design to plan for label needs.• Communicate overstocked and slow-moving items with Management and the Sales team• Monitor and report on obsolete inventory and work with Management on an appropriate resolution.• Work with the Accounting Department to ensure direct costs are captured accurately and cost of goods is accurate for each product produced.• Maintain accurate inventory quantities by lot number and perform physical inventories as needed.

Inventory Control tracking for major customers and their suppliers, including receipts, processing status, supplier payments, shipping, and invoicing.Working with system developer to improve efficiencies, and update features of the software.Identified as a “process expert” to work with group wide ERP implementation.Database reporting using SQL inquiries from the system database, to increase visibility of inventory and production processes.Advanced user of Excel, creating pivot table reports and charts, and collecting system data through the system database tables.Updating and customizing system reports and forms with Crystal Reports.Working with project teams to identify system gaps that would affect inventory, improving processes and procedures, and creating efficient material flow through the plant.Provide monthly records and reports for inventory positions, movements, and valuation.Creating tools and reports to reconcile inventory between inventory and finance systems.

East Granby, Ct, Us

• Worked with consulting company to implement MRP package into existing ERP system• Maintained master schedule and forecast to keep up with 20+% yearly growth for 4 consecutive years• Planned production tasks and schedules based on forecast and master schedule• Implemented use of Engineering Change History within ERP system and administer engineering changes for products• Took on purchasing tasks to analyze inventory numbers, safety stocks, lead times, and MRP requirements• Reduced raw material inventory costs 30% while maintaining production needs• Wrote SQL inquiries and designed multiple weekly SSRS reports, including warranty order history, open/late production orders, on time scheduling, production build changes, and available inventory of product based on allocations and safety stock• Maintained Production Work Orders from scheduling to completion of orders• Implemented the use of sub-assemblies and capacity planning in production and within the Bill of Materials to shorten lead time of final product from 5 days to 1• Coordinated operations between the Supply Chain, Engineering, Sales, and Operation teams• Created and established new policies and procedures in Production• Wrote SQL inquiries and designed multiple SSRS reports to increase quality and performance, including Indented Bill of Materials, Production Travelers, Production Work Orders, Picking Lists, and Packing Lists• Implemented use of physical and cycle counts within the ERP system to create better history, accuracy, and shorten length of physical inventories from 4 days to 2 days• Monitored and altered forecast and schedule based on customer demands, material availability, and production capacity• Provided ERP system expert assistance as needed and analyzed information to track history and errors• Created item numbers, bill of materials, and maintained item master of inventory• Analyzed data with SQL inquiries to continuously improve processes, procedures, and inventory information

Arlington, Virginia, Us