Shubham Agrawal

Data Analyst @Holcim

Mumbai, IN

Customer Segmentation for Pricing OptimizationDesigned and implemented a K-Means clustering model for customer segmentation across 50 countries, utilizing features such as margin %, average selling price, and cost-to-serve to enable region-specific, data-driven pricing strategies.Engineered advanced features including delivery efficiency, product tier classification, and customer tenure using Python (Pandas, scikit-learn) on 30M+ rows of transactional data, improving model accuracy and extracted via QlikView.Achieved a tangible 4-6% margin uplift in pilot regions by accurately identifying price-insensitive customer clusters and communicating actionable insights through QlikView dashboards for cross-functional pricing and sales teams- Distribution Cost Optimization Using Predictive ModelingDeveloped an end-to-end predictive pipeline utilizing XGBoost to accurately forecast per-order distribution costs, enabling real-time cost benchmarking across delivery modes, plants, and packaging strategies.Pinpointed and rectified inefficient delivery patterns (e.g,\"bagged cement + long-distance truck\" combinations) through in-depth analysis of cost drivers with SHAP, leading to optimized dispatch planning.Embedded predictive outputs into QlikView dashboards, empowering supply chain teams with actionable cost alerts and contributing to a 7% reduction in logistics overspend during pilot rollouts- Margin Prediction & Profitability OptimizationBuilt a Random Forest model to predict transaction-level margin %, classifying sales into risk bands to flag high leakage segments across 50 global markets.Engineered advanced cost-efficiency and region-level profitability features, enabling the identification of specific product-plant-customer combinations driving negative margins.Facilitated significant pricing, packaging, and routing optimizations by seamlessly integrating comprehensive model results into user-friendly, business-facing QlikView dashboards.

ABES Engineering College

Bachelor of Technology - BTech

Tata Institute of Social Sciences

Master of Science - MS