Business Objective:
Our client is one of the largest garment's manufacturer in India.
Client was facing issues while tracking the orders, multiple calls need to make and
files need check to get the information. Still sometime information which was supplied
to business partners were on the assumption basis related to delivery of the goods.
-
Identify the status of the order from the initial booking to delivery of the goods, with multiple batch tracking.
-
Identifying the cause of delay in the systems which makes the delay in shipment of goods.
-
Identifying the availability of the all goods in warehouse when the order placed and generating an intimation to the product level specialist for any kind of future shortage, which may create ad-hoc.
-
Build a smart alert system that generate alerts for the store level specialist and product level specialist and the production teams to main a healthy stock level in backup and to increase the profitability.
Challenges:
-
The key challenge faced by the data experts was that the necessary information was deployed to multiple databases which resulted in redundancy in the process-flow.
-
Eliminating the redundancy by identifying key parameter and accuracy of the data by performing the data cleaning operations.
-
Few of the databases were on-prem and the other was deployed on the cloud.
Approach:
The approach to address the client’s challenges involved certain operations.
-
Analyze the duplicacy of the data at database level, and combined all the relevant information at one platform, by the ETL process and pushing the data to Google Big Query.
-
Setting the update frequency for Big Query to get updated at every point.
-
Deploying a full-fledged BI system which generate smart alerts for the for the operation level teams to check and remove the bottle neck in the systems.
-
Analyze behaviour of all the products and maintain estimated inventory.
-
Calculate right inventory at the store to estimate reordering value.
Benefits:
-
Scalable platform to understand the key requirements of trade partners
-
Tracking an order number to check at which stage its in the process and can provide delivery date to the delivery party based on the calculation done on historical data.
-
Visualization platform cum scenario planner was embedded to help category managers optimize trade spends.
Business Impact:
-
Ability to quickly generate customized, ready-to-consume insights for any audience
-
Transparent system to check details at each stage.
-
Remove hindrances from the business, which directly impacted a 16-18 % operational growth in the organization
-
Decrease in operating cost by $ 1.7 million post rollout of program.
-
Productivity of ticket support team increase by 4.2 times
