Kapil Gururani

About Kapil Gururani

I am a Data Analyst with 4+ years of experience specializing in Power BI, SQL, Advanced Excel, Power Query, and Demand Planning Analytics across FMCG, production, and tech environments. I have worked with leading organizations including Nestlé, Country Delight, and Elcamino, supporting business teams through data-driven insights, automation, and performance reporting.My expertise includes dashboard development, forecasting, supply chain analytics, sales reporting, inventory analysis, and process automation. I have hands-on experience working with large datasets (2M–10M+ records), building data models, and creating interactive reporting solutions that improve decision-making at both operational and strategic levels.I enjoy solving complex business problems using data and transforming raw datasets into clear, actionable insights for cross-functional teams. With a strong command of Power BI, SQL, Excel (Pivot Tables, Power Query, Macros), and Python, I continuously work toward improving planning accuracy, automation efficiency, and reporting clarity.I am passionate about building scalable data solutions, improving business processes, and contributing to high-performance analytics teams.

Experience

1. Associate Analyst

   Nestlé

   Feb 2025 — Present · IN

   At Nestlé, I support the Demand Planning, Supply Chain by building data-driven solutions that enhance forecasting accuracy, operational visibility, and decision-making across regions and distribution centers.Key Responsibilities & Impact:Led development of automated forecasting and stock visibility dashboards using Power BI, Power Query, and DAX, improving planning accuracy and reducing manual reporting time.Maintained 4-month forward stock forecast (tons) and collaborated with regional and national planners to align demand and supply.Built and managed advanced planning files including Base Demand File, Database2, MSR, and MFR, streamlining plan vs actual tracking.Consolidated RDBN + Invoice data to generate monthly manufacturing inputs for plants.Managed Material Master updates, tracking new/working/upcoming/discontinued FERTs using Excel, Power Query, and VBA automation.Owned CVC Mapping, Creation, and Deletion, ensuring accurate DC allocation and FERT-to-FERT mapping for supply chain operations.Developed KPI dashboards: D & SP KPI, OT DPA, ECOM DPA, Apollo DPA, Stock Ageing, enabling leadership to monitor demand planning performance.Automated the OPDSR Proposal system (VBA + Power Query) used by channels for stock confirmations, improving demand fulfillment accuracy.Worked with large SQL datasets (6M+ records) for extraction, validation, and transformation.Designed region-wise and DC-wise tracking systems to support end-to-end supply chain distribution decisions.Applied Advanced Excel (Power Query, Pivot, Macros, Power Pivot) for trend analysis and performance insights.Tech Stack:Power BI | SQL | Excel (Advanced)| VBA | Power Query | SAP MM/SD | Data Modeling | Forecasting | Supply Chain Analytics

Education

• Maharshi Dayanand University

  Bachelors of Tours and Travels Management, Tourism and Travel Services Management