Prashanth Sundar Email & Phone Number

San Francisco, California, Us

San Francisco, California, Us

San Francisco, California, Us

Chicago, Il, Us

Business Analytics - Forecasting - Network Strategy - Inventory Management - Warehouse & Vendor relations - Supply Chain Management - Data Analytics SQL | Tableau | Python | Excel | VBA➢ Leveraged large, potentially messy data sets to derive meaningful insights and actionable business recommendations.➢ Improved the Hybrid process through enhanced analytics and collaboration with Inventory and Merchandising teams to increase adoption from 15% to 30% resulting in $1.8M gain.➢ Partnered with multiple merchandising, product, transportation and engineering teams to explore data, conduct analyses and improve processes.➢ Coached peers on advanced Excel, Tableau and SQL through classes and 1 on 1 mentoring.

Boise, Idaho, Us

➢ Orchestrated​​ the ​​future​ ​strategy​​ of ​​the​ ​facility​ ​by ​​driving​ ​scenarios​ ​to​ ​introduce​ ​new​ ​technology,​ ​​collaborating​ ​with​ ​Supply​ ​Chain, Planning,​ ​Purchasing,​ ​Facilities​ ​and​ ​Leadership➢ Implemented​​ data​ ​collection​ ​systems​​ through​​ advanced​​ SQL​​ queries​​ and​​ tools ​​like​ ​R, JMP​ ​for​ ​planning​ ​health​ ​metrics​ ​analysis​ ​to​ ​improve​ ​model​ ​accuracy➢ Managed​​ the ​​​Max-Outs​ ​and​ ​Capacity ​​profile​ ​processes​​​ to​ ​analyze​ ​bottlenecks​ ​and improve​ ​Fab​ ​throughput​ ​by​ ​8%​ ​in​ ​the​ ​last​ ​2​ ​years.➢ Assessed​​ correlations​​ of​​ key​​ metrics​ ​that​​ affect​ ​the​​ Fab​ ​performance​​ through regression​ ​tests​ ​and​ ​forecasted​ ​the​ ​performance​ ​based​ ​on​ ​the​ ​triggers➢ Created​​ effective​ ​and​ ​user​ ​friendly​​​ KPI​ ​dashboards​ ​​and​ ​ETL​ ​systems​ ​using​ ​R,​​SQL, Report​ ​Builder,​ ​Excel,​ ​Tableau​ ​for​ ​reporting​ ​data➢ Recommended​ ​opportunities​ ​and​ ​worked​ ​with​ ​teams​ ​to​ m​​inimize​ ​capital​ ​expenditure by​ ​20%​​ ​and​ ​increasing​ ​Fab​ ​output​ ​by​ ​improving​ ​the​ ​constraints​ ​in​ ​the​ ​Fab➢ Summarized​​ various​ ​‘what-if’​ ​scenario​ ​studies​ ​and​ ​recommended​​ solutions​​ to ​​suit business​ ​needs,​ ​and​ ​presented​ ​to​ ​different​ ​stakeholders➢ Mentored​​ and​​ trained​​ capacity​​ planners​ ​in​​ Max​​Outs​​ and​​ metric​​ audit​​ processes,​​ data analysis​ ​tools,​ ​and​ ​assisted​ ​in​ ​troubleshooting​ ​data​ ​discrepancies

Boise, Idaho, Us

➢ As​​ a ​​Manufacturing​​ Engineer,​ ​assisted​​ multiple​ ​teams​ ​in ​​making​ ​the​​ machines​​ and processes​ ​more​ ​efficient​ ​using​ ​analytical​ ​techniques​ ​and​ ​data​ ​visualization​ ​methods➢ Participated​​ in ​​Micron-wide​​ Cycle​​ Time​ ​improvement​​ projects​​ CT19​​ and​ ​CT22➢ Identified​​ and​ ​implemented​​ enhancements​​ to​ ​the​ ​Scheduling​​ system➢ Probe-Metrology-RDA (Realtime​ ​Defect ​​Analysis)​​: ○ Launched​ ​focus​ ​teams​ ​involving​ ​Engineering,​ ​Production​ ​and​ ​Quality​ ​teams​ ​for driving​​ ​Cycle​ ​time​ ​reduction​ ​by​ ​25% ○ Formulated​ ​the​ ​RDA​ ​Sampling​ ​calculator,​ ​a​ ​monitoring​ ​system​ ​for​ ​Sampling. ○ Involved​ ​in​ ​the​ ​Test​ ​Wafer​ ​Management​ ​Project​ ​to​ ​improve​ ​TW​ ​auto​ ​staging.➢ PVD-Implant​​: ○ Maximized​ ​the​ ​efficiency​ ​of​ ​machines​ ​by​ ​5%​ ​through​ ​Load​ ​balancing​ ​project ○ Assumed​ ​the​ ​responsibility​ ​of​ ​Q-time​ ​champion,​ ​guiding​ ​teams​ ​in​ ​reducingQ-​ ​time​ ​related​ ​issues​ ​to​ ​improve​ ​the​ ​flow​ ​of​ ​the​ ​line.➢ Production​​ Control​​ department: ○ Led​ ​the​ ​Auto​ ​Lot​ ​Start​ ​Project,​ ​involving​ ​cross​ ​functional​ ​teams​ ​reducing​ ​the workload​ ​in​ ​the​ ​Starts​ ​process​ ​by​ ​16​ ​hours ○ Actively​ ​participated​ ​in​ ​the​ ​Transfer​ ​Offload​ ​Business​ ​process,​ ​making​ ​the offloading​ ​process​ ​more​ ​efficient.

College Station, Tx, Us

• Tutoring developmental math students one-on-one in math skills ranging from basic mathematics to intermediate algebra.

College Station, Tx, Us

Boise, Idaho, Us

Interned in the Real Time Defect Analysis (RDA) department of Micron Technology Virginia, one of the world's best semiconductor manufacturing company.• Analyzed data and understood performance measures used in RDA Department.• Worked in coordination with the Planning department, to create various tactical efficiency metrics for RDA department, relating to Cycle Time, Sampling data and Utilization. • Created a multitude of reporting applications for the same, through scripts written in JMP, HTML, VB and Excel.• Created and maintained performance indicator dashboards for the RDA department.• Summarized the RDA Weekly Metrics Presentation, through automated scripts generating Fab-wide data.• Constructed an application that runs correlations between inspection data and die failure data (from probe) to understand patterns in the parameters and processes which cause defects.

Third Party Logistics Provider Selection• Examined the data obtained from companies to prioritize the important criteria required for Logistics provider selection. • Developed an integrated model using Structural Equation Modeling (SEM) and Fuzzy Logic(AHP- Analytic Hierarchy Process) based on 24 criteria to find out the best 3PL provider.

Chennai, Tamilnadu, In

Internship : Case Study on Reverse Supply Chain of Automobiles • Analyzed the base scenario using car consumption data and surveys from automobile retailers. • Studied the correctional implementations that could be done to improve predictability of theSupply Chain.

Masters In Engineering, Industrial Engineering

Bachelor Of Technology, Production Engineering