Supply Planning Assistant
San Francisco Bay Area
• Collaborated with Supply Planners to ensure on-time delivery of quality products. • Support execution of inventory strategies and issue PO’s (Production Orders) for a large array of products to ensure a seamless flow of raw materials and finished goods through the supply chain• Consolidate POP (Pre Order Production) information to help identify issues that may arise due to production capacity restraints or availability of raw materials• Identified potential problems through review of shipping reports, and analyzed the possible impact to the S&OP• Populate, flag and adjust sizes in Manugistics. • Maintain integrity of Excel based data for in house tracking system and mainframe systems. • Maintain accurate system lead times from PO issuance to WIP (Work in Progress) to inbound transportation to on lot at DC.• Initiate Regionalization from single to multiple stocking DC for core Dockers products• Reconcile fabric markdown, on hand recap and Bill and Holds.• Track inbound trailers to DC utilizing in house tracking system and logistic partners. Prioritizing when necessary.• Provide ongoing summary of Weekly Attainment to ensure weekly cut schedule is met.• In Supply Planner’s absence, responsible for covering and communicating concerning issues surrounding delivery, scheduling and inventory issues. • Created and rolled out various Excel based tools to help streamline and automate common tasks• Fabric inventory tool to help utilize fabric inventory efficiently to minimize wastage• Pivoted tracking tool that combined several different reports to summarize tracking, existing schedule, inbound transportation and on lot at DC information• PO issuance template to massage forecast and stockout data to a simple copy and paste into the SAP PO upload template• PO deletion macro that concatenates Excel based data into a DOS usable format. Saving core programs hours of weekly manual input