Our client, a British multinational cosmetic, skincare, fragrance and personal care provider headquartered in London with 6.4 million representatives worldwide is the fourth-largest beauty company and second-largest direct-selling enterprise globally. Faced with multiple challenges in operational efficiency and cost management, they turned to HCLTech for a solution. We helped shape their digital strategy to improve overall performance.
The Challenge
Optimizing cost and efficiency with cloud-based platforms
The client faced difficulty in their cost management and operational efficiency due to several impeding factors. Their existing database platform could not handle the increasing sales data, resulting in scalability issues impacting their data and analytics capabilities. In addition, they were experiencing an increasing overall maintenance cost as well as a lack of scalable cloud-based platforms.
The Objective
Optimizing performance by leveraging the cloud
Our client wanted to increase cost efficiency and operational performance by resolving scalability issues with the existing database platform, reducing overall maintenance costs and leveraging cloud-based platforms for data and analytics capabilities.
The Solution
Modernizing data to elevate data handling
HCLTech implemented a solution to optimize our client's cost management and data handling. They migrated sales data at the representative/leader/product level to AWS S3, then placed flat files into the staging area of the Snowflake system and copied them into load tables, which used delete/insert logic to retain only the latest data. Finally, they populated this data from load tables to final summary tables using update and insert logic.
The Impact
Unfolding scalable platform to meet future data requirements
HCLTech delivered a complete data management solution to the client, featuring a scalable AWS and Snowflake platform. This holistic approach not only resolved their immediate needs, but also positioned them for future expansion, with ongoing support from our Center of Excellence for adherence to industry best practices. The result is a 50% decrease in query processing time and the establishment of a flexible platform ready to accommodate any future data or reporting requirements without significant cost implications.
