Keyur Ghaghada

Experience

• 

  Tata Consultancy Services

  May 2013 - Sept 2015

  Business Analyst

  -Working on statistical modeling – Marketing Mix Model to gauge impact of media and promotional activities; understand the impact of all drivers affecting brand sales-Measure ROI and effectiveness of all media executed; understand and quantify impacts using tools like MS Excel and SAS-Experience on data management and modeling tools like MS Excel, MS Access and SAS. Query data from different sources according to specific project requirements-Maintain data integrity during extraction, processing, manipulation and analysis.Ensured documentation of the data and the process flow-Led decision making related to data collection, methodology, design for the custom ad hoc analysis for clients-Liaise with the commercial team and communicate the requirements, feasibility and insights Show less

• 

  General Mills

  Sept 2015 - Oct 2016

  Business Analyst

  -Partner with Trade and Customer team in Canada for accurate delivery of right sized volume and trade fall out reporting-Work on the following databases to enable decision makers with an holistic view of sales – Trade Promotion, Business Objects, Nielsen Nitro, IRI, Dunnhumby tools etc.-Accurately capture sales volume for trade promotions using excel - VBA tools and volume databases and ‘Right Size’ Nexus planned volume-Interact with customer teams on calls/emails resolving queries and understanding nuances and invoicing patterns-Onboard new accounts by showcasing fall out results-Prioritize workload across customer teams and forge relationships with SME’s in Minneapolis to ensure smooth day to day functioning-Transform the business process by simplifying the complicated and facilitating solutions in the form of scalable, turnkey tools Show less

• 

  Enhance Group

  Oct 2016 - now

  Demand and Supply Planning Manager

  Demand Planning & Sales Forecasting:• Lead Demand Planning and S&OP optimizations with stakeholders for distribution and retail businesses, ensuring alignment between forecast and business objectives, addressing gaps, and identifying risks/opportunities• Review historical sales patterns, analyze demand drivers, and develop statistical forecast models while collaborating closely with finance, marketing, and sales to ensure an integrated planning process that aligns with organization goals• Develop and lead demand planning teams to build capability and analytical mindset for change management• Facilitate Demand reviews, presenting key findings and recommendations to senior leadership for revenue planning and budget planning and support decision making. • Leveraging data analytics to enhance forecast accuracy and drive continuous improvement in demand planning processes• Track KPI such as: forecast accuracy, MAPE, and BIAS up to Lag6. Supply Planning:• Manage supplier relationships and coordinating with co-packers to align with demand plans, reviewing consumption vs forecast at product levels, and liaising with replenishment and sales teams to address availability issues and the impact of under/over consumption • Oversee Distribution Requirement Planning (DRP), shipment plans, ensuring product availability aligns with demand projections and Service Level Agreements (SLA) compliance• Coordinate the phase-in and phase-out of NPD, product replacements, product upgrades, and UOM Changes• Track KPI such as:: In-Stock availability, Supplier Fill RateInventory Management:• Manage inter warehouse transfers to attain maximum stock availability throughout the country• Identify SLOBs and liaising with the Sales Team for its liquidation• Administer key warehouse and logistics functions, including inbound management, capacity planning• Track KPI such as: Inventory Health(ageing and freshness), Customer Fill Rates, Days of Inventory, Inventory budget Show less