Pavan Konjeti

Experience

• 

  ITC Limited

  Aug 2013 - Nov 2019

  Business Analyst

  • Orchestrated end-to-end MIS and SAP activities for the head office business operations of a $300 million brand.• Achieved a service level exceeding 95% for wheat flour products through the implementation of statistical inventory and production methods.• Modeled end-to-end business operations, encompassing wheat buying to selling wheat flour, in i2 optimizer. Analyzed the results and successfully implemented insights derived from the modeling, resulting in substantial cost savings of $25 million.• Conducted in-depth analysis of a dataset comprising over a million shipment records using Power Query, resulting in a 5% reduction in transportation costs by optimizing the loading of various products based on truck type.• Recommended new factory sites by geotagging sales and raw material data, contributing to strategic decision-making.• Proposed and implemented highly efficient shipment routes leveraging Excel Macros, Google Maps API, and Linear Optimization through Solver in MS Excel. This strategic initiative yielded substantial cost savings, totaling $10 million.• Led monthly sales and operations meetings from the production planning perspective, fostering effective cross-functional communication and coordination. Show less

• 

  Britannia Industries Limited

  Nov 2019 - Nov 2021

  Planning Analyst

  • Analyzed weekly and monthly production plans using various statistical techniques to capture variability. Provided valuable insights to procurement for dynamic order adjustments, resulting in a notable 10% reduction in stock-outs.• Spearheaded the implementation of SAP S4HANA, establishing a resilient material planning system for enhanced efficiency.• Attained a remarkable 80% reduction in material write-offs by strategically collaborating, orchestrating internal movements, and implementing effective shelf-life extensions. This accomplishment was informed by a thorough analysis of patterns and trends extracted from historical data.• Facilitated seamless product launches, recipe changes, and promotions, achieving less than 5% wastage. Leveraged projection reports created with precision using Tableau Prep Builder and Tableau. Show less

• 

  Genpact

  Dec 2021 - Aug 2023

  Assistant Manager - Analytics

  • Enhanced customer fill rate by an impressive 20%, reaching 95%, by meticulously analyzing the weekly Blue Yonder optimization model output. Successfully fine-tuned its parameters to achieve more efficient planning. • Oversaw the Integrated Business and Tactical Planning for the Supply Planning team at the largest Kraft-Heinz factory in the ANZ region, developing comprehensive capacity plans and production schedules. Utilized Excel linear programming models to ensure precise and efficient inventory delivery.• Played a pivotal role in strategic decision-making through the generation and presentation of insightful reports and dashboards, utilizing tools such as Excel, Tableau, and Power BI.• Collaborated closely with marketing and demand teams to initiate and oversee product listing, delisting, and withdrawal processes. Provided detailed analyses of the impacts of continuing versus delisting, contributing to the formulation of a dynamic product lifecycle management strategy.• Led the successful implementation of process improvement projects, including the automation of the workflow for weekly business operations and the ETL process using Power Query in Microsoft Excel. Show less

• 

  Naveen Jindal School of Management, UT Dallas

  Oct 2023 - Jul 2024

  Data Analyst

  • Spearheaded efficient data entry and management for a comprehensive pool of 400 PhD applications, utilizing proficiency in SQL, Excel, and OnBase.• Innovatively optimized application processing workflows by implementing automation techniques, leveraging SQL and Power Query to streamline operations and enhance overall efficiency.• Developed a predictive model in Python using logistic regression, achieving 60% accuracy and precision in estimating successful PhD student placements.

• 

  Boehringer Ingelheim

  Jul 2024 - now

  Supply Chain Data Analyst

  • Building and enhancing dashboards to track KPI’s and report on trends using SAP, Excel and Power Platforms.• Gathering data related to Distribution & Logistics Operations, analyzing and identifying problematic areas with recommendations for improvement using Machine Learning techniques.