Projects — Kartik Bhimrao Aher

Featured Projects

Problem → Solution → Impact

Selected case studies showcasing measurable business outcomes.

95–98% accuracy

Demand Forecasting Optimization

Problem: Forecast inaccuracy leading to stockouts & overstock.
Solution: Built ML-assisted forecasting model with Power BI integration.
Impact: In-stock improved to 98%; obsolete stock cut by 22%.

PythonPower BISQL

₹15 / shipment saved

Logistics Cost Optimization

Problem: Inefficient carrier allocation and route planning.
Solution: Designed cost-to-serve model and dynamic carrier-mix logic.
Impact: ₹45K–60K daily savings across the network.

ExcelSQLPower BI

50–60% time reduction

Process Automation & MIS

Problem: Manual MIS reporting consuming hours daily.
Solution: Automated end-to-end ETL with scheduled refreshes.
Impact: Daily reports auto-generated; team time freed for analysis.

PythonSQLPower BI

Reduced by 3%

RTO Reduction

Problem: High Return-to-Origin rate eroding margins.
Solution: RCA framework + address-quality scoring + SOP rollout.
Impact: Significant reduction in RTO rate, improving delivery success and margin recovery.

SQLExcelPower BI

70–75% recovery

Invoice Audit System

Problem: Carrier overbilling went undetected at scale.
Solution: Built automated invoice reconciliation & dispute workflow.
Impact: 70–75% of disputed amounts recovered.

PythonSQLSAP

Published author

Content Writing — Supply Chain Insights

Problem: Complex supply chain concepts often inaccessible to wider audiences.
Solution: Authored articles on forecasting, inventory, and logistics for Globy.com.
Impact: Published thought-leadership pieces simplifying SCM topics for global readers.

WritingResearchSCM

Real-time KPI visibility

Data Analytics & KPI Dashboards

Problem: Operational KPIs scattered across systems with no single source of truth.
Solution: Built interactive Excel & Power BI dashboards with automated data refresh and drill-downs.
Impact: Enabled real-time visibility into supply chain KPIs — driving faster, data-backed decisions.

Power BIExcelSQLDAX

View dashboards

More Work

Case studies & external links

Explore deeper case studies, dashboards, and code samples on GitHub.