
ABOUT THE CLIENT
World leader in cosmetic industries.In India they have 2 manufacturing plants Have huge network of CFA, Sub CFA, Distributors across India. Have more than 20,000 SKUs.
PROBLEM
There are many sources of huge data and ensuring all are considered at appropriate time by manual methods is very difficult.
It involves various steps of manually doing tedious calculations in excel sheet. Chances of manual error are high, leading to miscalculations in stock to be sent, triggering either over stocking or stock out position.
Since process is human dependent, getting the correct data for dispatches takes time. A person or sometime 2 are involved in doing this activity for whole day.
Also truck load is not correctly calculated, causing underutilization of truck capacity.

SOLUTION
Made the process human less.
Automated the process of collecting various data reports.
These reports are automatically uploaded to the server, where client defined calculations happen and data is prepared for consumption.
Various reports like Allocation of stock report based on current stock position, stock in transit, forecast and sell cycle. Generates stock allocation report considering following scenario Over selling, Normal selling and Under selling
Create an update file to be uploaded to SAP for sales order generation.
Also keep backup to know how stock allocation has happened over the period.
BENEFITS
The shift to a high-tech model delivered significant business benefits:
Optimized truck capacity utilization.
Managed FIFO, scheme-related SKUs, and other factors efficiently.
Eliminate stock-out situations, leading to enhanced operational efficiency.
Automated calculations for in-transit stock, available-to-promise, and capable-to-promise data.
Independent processing with near-real-time results, requiring no human intervention for calculations.
TOOLS & TECHNOLOGIES USED

Utiliy
To improve the efficiency of Sales Development Representatives (SDRs) and maintain high campaign hygiene, we implemented an automated lead disqualification process integrated with the Five9 dialer platform. The objective was to instantly remove unqualified leads based on predefined disposition logic, streamline exception handling for web leads, and provide end-to-end visibility through logging and audit trails. This solution ensures SDRs spend time only on quality leads, enhancing productivity while maintaining a clean, real-time lead pipeline.

Rental
This case study examines how a utility rental company shifted from a call-centric high touch model to a high-tech online portal, solving understaffed call center issues.The new system improved operations and customer experience, attracting 800-850 new users to the site and pleasing both management and sales teams.