Material Planning Intern, Business Analytics

at  Seagate Technology

ABOUT OUR GROUP:

Join our dynamic Materials Department, where we play a pivotal role in shaping the Media Demand Plan in supporting the Master Schedule (MS) of our drives. We are tasked with converting the Drive MS quantities into Media quantities by products, thereby crafting the crucial Recording Media Operation Demand Plan (RDP). This plan is integral to our factory planners’ ability to synchronize production capacities with RDP requirements, considering yield rates, machine/tooling limitations, and material constraints to formulate the Master Production Schedule (MPS).

YOUR EXPERIENCE INCLUDES:

• Currently pursuing a bachelor’s degree in supply chain, business analytics or any relevant fields
• Creating advanced Microsoft Excel templates, including linked files, formulas, criteria setting, pivot tables, and V-lookups.
• Developing tables and charts in Microsoft Excel.
• Designing workflows in PowerPoint and possessing strong presentation skills.

As a Material Planning Intern, contribute to support the seamless execution of the MPS by factory personnel, ensuring a continuous supply of Media to meet Drive MS requirements. Involve in projects that enhance the accuracy of translating Media demands from the Drive MS Demand, using improved Excel-based planning files.
A key aspect of your involvement will be aiding in the capturing and reporting of Inventory costs to aligned with Finance reporting. You will be supporting to ensure Recording Media Operation Inventory costs effectively within budget, particularly important due to our recent transition from Oracle to SAP systems.

You will embark on three exciting projects designed to enhance our operational efficiency and align with our strategic objectives:

• Develop a standardized Media demand computation template to expedite the EBO/LRP process and facilitate “what-if” scenarios.
• Generate SAP reports that accurately reflect Inventory information, ensuring alignment with Finance reports.
• Consolidate and organize Inventory data into user-friendly spreadsheets, streamlining reference and reporting processes.