Subham Kumar Barnwal

Audit Task Creation.

• Created an automated task creation system that prioritizes tasks based on inventory sanity, item availability, manpower, and effort per resource.
• This system reduced PNA (Product Not Available) quantity by 60% (2 → 0.5), cut item pick time by 20%, saving 5 hours per manpower, and $0.2M per month
• Developed an auditor scoring system that improved efficiency, reduced fake audits from 35% to less than 10%, improved working hours by 15% (7.5 to 6.5), and enhanced audit accuracy.

Inventory Migration and Product Placement.

• Identified inventory issues, such as high SKU/location, scattered items, space misallocation, and incorrect mappings, wasting approximately 0.5 average working hours of a picker daily.
• Developed three task types, reducing the average. SKU/location by 60% (12 → 5), incorrect space usage to less than 5%, and scatter by 33% (6 → 4) across pan-India warehouses, boosting working hours by 5%.
• Developed a dynamic SKU/location suggestion system, optimizing inventory thresholds based on real-time data, projected demand, and ensuring seamless operations and smart inventory management.

Putaway Suggestion

• Simulated and tested a location suggestion system using volumetric data, reducing distance traveled during putaway by 35%, increasing manpower productivity by 28%, and boosting net inbound capacity by 20%.
• Built dashboards to track adherence metrics and conduct RCAs, identifying faulty putters and item-location issues, improving adherence to putaway suggestions by 12% (85% → 95%)
• Analyzed putter performance by evaluating idle time, hourly productivity, and active hours, enabling the Ops team to optimize individual throughput. This resulted in a 33% increase in average working hours, from 4.5 to 6 hours.

Learning Management System

• Developed a Python-based training module on item and location awareness for new pickers, designed to accelerate onboarding and improve efficiency.
• Error scans decreased by approximately 40%, while the median pick time per item improved by approximately 20%, saving close to 1.5 hours per new picker, which translates to approximately $0.5 million per month.
• Daily IPP (items picked per picker) increased by approximately 1.5 times compared to untrained pickers in the first two weeks.
• First-week new picker churn dropped significantly from 60% to 35%.

• Set up the Call Centre Sales Team Dashboard from scratch to track critical metrics like inbound calls, revenue, cancellations, conversions, etc. while performing regular RCAs.
• Helped improve conversion (inbound call to booking) from 25% to 40% by analyzing data on call source, peak call hours, call language, and tracking agent productivity, which streamlined our call center operations.
• Created and maintained dashboards for the Lead Generation team, tracking critical conversion metrics, and automating monthly and weekly mailers measuring the performance of lead campaigns.