Rahul Roy

About Rahul Roy

Senior Analyst | 5+ Yrs Driving Customer Acquisition & Growth via Statistics, A/B Testing, SQL, Python, Power BI, Predictive Modelling | Stakeholder Management | Product & Funnel Analytics | Forecasting, Market Insights & GTM Strategy Expert

Experience

1. Senior Analyst - Market Intelligence

   Dell Technologies

   Jun 2022 — Present · Bengaluru, IN

   Resolved DSI discrepancies between S & OP and Demand Planning by developing a weighted moving average model, balancing sales and forecast, reducing DSI variation by 20% and improving inventory visibility- Optimized DSI accuracy through A/B testing, using MAPE and RMSE, improving forecast reliability by 15%- Developed interactive, Power BI dashboards for real-time KPI tracking using OLAP data models and DAX- Built a predictive inventory model using forecast, backlog, and incoming supply data, enabling accurate future stock visibility and reducing excess inventory by 15%, leading to better procurement planning- Designed a what-if simulation model to predict aged inventory buildup, allowing planners to adjust forecasts and trigger promotional strategies, improving sell-through rates by 5%- Redesigned shipment mode selection, replaced Excel Solver with a Python-based optimization model,integrating historical trends, multi-factor cost impact analysis and simulations, reducing logistics costs by 10%- Automated ETL using SQL, SSIS, and Python (Pandas), saving 10 hours/week and 100% data accuracy- Architected cloud data solutions on AWS & Azure, optimizing data storage (S3, Synapse, Redshift) and pipeline performance (Data Factory, Glue), reducing query latency by 10%- Translated client needs into tailored data solutions, facilitating effective communication between technical and non-technical stakeholders using JIRA, resulting in 20% increase in customer satisfaction rating- Proficient in storytelling, trained a 100+ member SCM team on the tool\'s use cases and data interpretation- Led data governance initiatives, implementing rigorous data validation, cleansing, and transformation protocol

Education

• Heritage Institute of Technology

  Bachelor of Technology - BTech, Computer Science

  2014 — 2018

• Indian Institute of Technology, Kharagpur

  Master of Business Administration - MBA, Business Administration and Management, General

  2020 — 2022

• Mar Gregorios Memorial Higher Secondary School

  Class XII, CBSE

  2002 — 2014