Production Control Planner
CurrentReviewed changes from EBOM to current MBOM and changed component part numbers and component part number revisions in Costpoint as needed. Programmed an automated process with Macros in Microsoft Excel to remove duplicate assembly part numbers, organized parts inside a visual table, and track the current revision is for that partMaintain manufacturing orders to most relevant revision per coordination with Configuration Management and release orders to production shop floor per coordination with DTS Main Master Scheduler. Inspect manufacturing orders for ability to be released based on material available and most recent process plans released via Solumina, stat using missing parts / process plans. Developed report tracking all manufacturing orders and purchase order statuses for Enduring Shield at DTS Main using Costpoint, Dynafact, Solumina, and IBM Cognos. Wrote multiple formulas in Excel that pulling in data from multiple reports via Xlookups and Offsetsto obtain the description of the current operation the manufacturing order, the percent status of competition of the manufacturing order, and concatenated this info into one cell per assembly part number.Wrote and programmed macros utilizing Visual Basic to parse information from the Cognos report Excel file and dump it into the active tracking Excel file on our SharePoint via a clickable button. Created visual representation for assemblies and subassemblies to map manufacturing process.