Introduction
Our client, a power generation manufacturer, divested from a larger organization to become a brand-new company. With the looming deadline of a cutover from the existing data platform, the client engaged HCLTech to validate and test the existing technology stack and determine the best way to move forward.
The Challenge
Slow data platform performance
The client had an existing, on-premises data platform for handling commercial data but was suffering from slow report loading, sometimes longer than 60 minutes, frustrating the primary data consumers, as well as the sales and marketing teams.
The Objective
Migration to cloud platform
The client was looking to migrate its data platform to the cloud. Included in this analysis was a technology evaluation and determining the feasibility of migrating the stack components to the cloud. The client also wanted to optimize data and analytics platform performance, reduce long-term operating costs and enable cloud-native solutions while ensuring a fast time to value on the migration.
The Solution
Optimize the existing data platform components
HCLTech data engineers completed a full design review of the existing technology stack, which included Oracle ERP as the system of record, HVR for data replication, Greenplum as the database, Talend for ETL and Tableau for data visualization. This design review included a detailed review of code and configuration for the various technologies used as well as reviewing data governance.
Our experts designed a cloud-based architecture incorporating the existing technology on-premises components. After a lengthy testing phase and a Proof of Concept (PoC), the HCLTech team optimized the components of the existing data platform to increase performance, validating the technology stack for post-divestiture operations.
The Impact
Reduced cost and efficient reporting process
With a successful migration of the Oracle ERP source system to Oracle Cloud and the other data platform components to an AWS environment, the client benefited from reduced hardware, licensing and maintenance costs. The new cloud-based data platform rendered reports several times faster than the on-premises version.
