
Results-driven Business Analytics and Digital Transformation professional with 10+ years of experience enhancing revenue growth and commercial performance across diverse industries. Certified in Digital SCM (IIM Visakhapatnam) and Lean Six Sigma Green Belt. Expertise in sales KPI governance, market execution analytics, and demand forecasting, utilizing automation tools and executive dashboards. Focused on developing actionable strategies to optimize profitability and service levels.
Project Portfolio – Aritra Chattopadhyay, Supply Chain & Logistics Analyst, Digital Transformation Specialist, IIM-V, LSSGB
Digital Transformation & Automation ProjectsProject / Initiative
Role
Objective / Scope
Technical Highlights
Key Business Impact
Project SWAYAM – Reporting Automation
Project Lead
Automate manual daily reporting across supply chain
RPA, UI path automation, auto-report generation, formatting, and scheduled distribution
⬛ Saved 18.72 man-hours/day
⬛ 90% reduction in manual effort
⬛ Improved reporting accuracy
Payroll Automation System
Automation Designer
Automate payroll generation & distribution
Biometric attendance integration, VBA macros, PDF pay slip creation, Outlook dispatch
⬛ Reduced processing time from 8 hrs to 60 mins
⬛ Zero manual errors
⬛ Scalable and secure delivery
Stock Coverage & Movement Tool
Developer & Planner
Optimize inter-warehouse stock planning
Excel VBA macros, stock dashboards, scenario analysis, email triggers
⬛ 70% reduction in manual planning
⬛ Stock imbalance cut by >30%
Project / Initiative
Role
Objective / Scope
Technical Highlights
Key Business Impact
Project Helix – Supply Chain Control Tower
Project Lead
Create real-time supply chain command center
Dashboard integration across logistics, inventory, demand planning
⬛ Real-time E2E monitoring
⬛ Faster decision-making
⬛ Enhanced collaboration & visibility
Re-Networking
Project Data Analyst
Optimize high-cost secondary transportation lanes by redesigning routes, consolidating loads, and re-mapping customers to nearest warehouses.
Apply DMAIC methodology to reduce logistics cost while maintaining service levels. Freight cost analysis by lane, vehicle type, and load utilization. Scenario modeling in Excel/Power BI to compare current vs. optimized network. Designed new shipment frequency model to balance cost and OTIF.
⬛ Improved vehicle utilization from 72% to 88%.
⬛ 12–15% reduction in freight cost per ton/km on optimized lanes resulting operating below the freight cost of FY 17-18 at CY
⬛ Enhanced service level consistency
On-Shelf Availability Optimization (OSA)
Data Analyst
Reduce retail stockouts & ghost inventory
Excel forecasting, Access DB, StoreConnect integration, KPI modeling
⬛ Stockouts cut by >25%
⬛ Reduced ghost inventory
⬛ Improved fill rate
Secondary Dispatch SAP MIS Automation
Project Lead
Automate secondary dispatch reporting
SAP T-code automation, LOB-wise analytics, Excel-based data visualization
⬛ 23% efficiency improvement
⬛ Removed Excel dependency
⬛ Faster decisions
Project / Initiative
Role
Objective / Scope
Technical Highlights
Key Business Impact
Project FDFR – Fixed Day Fixed Route
Logistics Optimization Lead
Standardized secondary distribution routes
Route planning, scheduling optimization, customer delivery mapping
⬛ Improved fleet efficiency
⬛ Predictable delivery windows
⬛ Lower logistics cost
Transport Management System (TMS)
Digital Logistics Lead
Centralize & automate transportation workflows
Carrier management, real-time tracking, route optimization
⬛ SLA improvement
⬛ Freight cost reduction
⬛ Enhanced shipment visibility
Vendor Managed Inventory (VMI)
Inventory Strategy Consultant
Implemented vendor-led replenishment system
VMI logic, consumption analytics, distributor–vendor integration
⬛ Reduced stockouts
⬛ Lower inventory cost
⬛ Strengthened supplier collaboration
Project / Initiative
Role
Objective / Scope
Technical Highlights
Key Business Impact
Emami StoreConnect App Rollout
Project Lead
Digitize field retail execution
Mobile app rollout, PJP dashboard, stock tracking, competitor analysis
⬛ 1,000+ app installations
⬛ 100% UAT success
⬛ Real-time visibility into in-store ops
Project / Initiative
Role
Objective / Scope
Technical Highlights
Key Business Impact
Cost Data Reconciliation
Analyst
Align Finance and Operations data
Cross-system audit, cost center matching
⬛ Improved data sanity
⬛ Reduced finance–ops mismatch
Surprise Plant & Branch Audit (Stocks + SOP)
Compliance Auditor
Check adherence to SOP & stock accuracy
Physical stock audits, process checklists, exception reporting
⬛ Improved compliance
⬛ Closed stock variances
⬛ Stronger internal controls