Yagnyesh Sangani

Experience

• 

  Micron Technology

  Jan 2004 - Jan 2013

  Supported Sales Operations, Demand Management, Supply Chain, and Marketing Operations teams. Compiled large and complex data sets into meaningful analysis and presentation for leadership team. Collected, documented and communicated business requirements for business system development and enhancements. Worked with IT teams to identify opportunities and defined requirements and system capabilities for technical solutions and automation of data extraction, reporting, and analytics. Assisted with root cause analysis and business process improvement. Developed and maintained departmental SharePoint site and published content, metrics, dashboards. • Extensively used Excel macros and JMP (statistical analysis) to analyze and summarize large data sets using exception-management based methodologies to solve demand, supply, forecast, shipments, backlog, inventory, allocation, and revenue problems. Results included improved Demand/Supply Planning, Forecast, and S&OP processes. Provided weekly/monthly reports and analysis like inventory levels/change, demand-supply gap, forecast accuracy/trends• Validated, unified and consolidated scattered and unformatted large data sets from multiple sources into standard formats by writing macros that generated meaningful analysis and presentation which provided the foundation for subsequent business reports/solutions. Transformed and reported data in response to specific business need. Performed ad hoc data analysis and communicated results in concise and meaningful way.• Data Analytics and Demand Forecast Accuracy Metrics Development project:Set up an automated and complete data structure and demand forecast metric system for Demand Planning, Sales Operations, and MSR processes and activities. Mined data and defined metrics to measure forecast accuracy/variance/churn. Significantly improved forecast accuracy (60 to 75%) through exception management methodologies resulting in improved S&OP process that generated quality demand signal. Show less Coordinated with corporate teams, Fabs & back-end planning, JVs, finance, BUs, and R&D to ensure optimal Fab operations strategy by generating long term product loading scenarios and its financial impact. Identified opportunities for improvement of metrics and costs through internal benchmarking. Manipulated data from multiple data sources to perform analysis and to create metrics and reports. • LTOP (Long Term Fab & Back-end Operations Strategy Planning) Project: Key member of four person team tasked to develop, deploy, and optimize LTOP project, a strategic tool used for Fab executives for long term (5 years) strategic planning. Simulated and modeled various data sets (Demand, ASP, CapEx, costs, yields, depreciation, technology transition, bit growth) to generate the outputs (cost per wafer, revenue per wafer, cash flow etc) for the executive team to predict outcomes for 5-year operations strategy, financial impact and sensitivity analysis. • Developed a solution using complex Excel macros to create long-term CapEx profiles for global manufacturing sites based on technology transitions and loading stages. This solution facilitated optimum utilization of world-wide manufacturing capacity through demand allocation and alternative product assignment scenarios for given capital and investment alternatives.• Developed complex data models which addressed the challenge of creating standard line yield curves and provided strong insight to executive management for their global product deployment strategy. Show less SPC Engineer for one of the largest FABs running a complex mix of products: memory (DRAM, NAND, NOR) and IMAGER chips. Monitored SPC performance at Boise Fab for better yield, good quality products, and to reduce excursions. Assisted area engineers for complex process data analysis to solve process performance related problems and help them to reduce process variation through continuous improvement. • Played key role to launch and implement the successful SPC program from floor level to management. Successfully designed and developed various SPC metrics to gauge and improve SPC performance. Facilitated weekly meetings to improve the processes. • Formed quality team with area process engineers (DryEtch, Photo, PVD) to reduce the OOCs (out of control conditions) by 27%-64% across all products families in time frame of 10 weeks. • Developed and automated SPC related metrics using SQL, Perl, and R languages to report process performance at the process control charts level that helped engineers to prioritize the issues to reduce process deviations and excursions. Mentored and trained engineers for SPC related topics, concepts, methods to deal with out of control conditions and future prevention. Show less

  • Business Operations & Data Analyst

    Jan 2009 - Jan 2013

  • Manufacturing Integration Engineer

    Jan 2008 - Jan 2009

  • Process Control Engineer

    Jan 2004 - Jan 2008