Application Modernization and Database Migration to GCP for an American multinational consumer goods Client

Our Client

Leading CPG major in the world with revenues of close to 80 billion USD with operations in over 180 countries and portfolio of 50+ brands. 

Challenges

• Multiple existing systems are used to collect first party data in multiple formats and structure, bringing all PII Data in one place to have a single consistent view of data. 
• Lowering maintenance cost.
• Reduction in campaign/ incentive launch turn-around time, launching campaign used to take 2 weeks as it was manual process. 
• Consolidating multiple campaign management systems into one system.
• Difficulty in scalability of the applications, due to lack of standard across systems. 

Solution

To achieve the desired system, the suggested solution was to leverage Google Cloud Platform (GCP) services (listed further down) and leverage the rich PaaS capabilities provided by GCP.

The solution implemented is to enable traffic though internet via application gateway (APIGEE) to multiple cloud run services (micro-services) which intern talk to external systems or other micro service internally via sync API calls (cloud run to cloud run) or async call via Cloud Pub/Sub, based on scenario to scenario whichever applicable.  

For heavy transaction data, Firestore is used for faster reads and writes, whereas for reporting needs where aggregation of data on multiple dimensions were required Cloud SQL (Postgress) is used to ensure multi-dimensional queries can be fired up. Storage of images and files are done on multiple buckets to segregate the owner of the bucket based on the micro-service.

To enable performance, additionally wherever applicable data is cached in Memory store (Redis) with business applicable TTL.

• Artifact Registry 
• Cloud APIs
• Cloud CDN 
• Datastore (Firestore) 
• Cloud Functions 
• Identity and Access Management (IAM) 
• Pub/Sub 
• Cloud SQL 
• Cloud Storage
• Cloud Run 
• Cloud Scheduler
• Cloud Tasks
• Compute Engine
• Secret Manager 
• Cloud Vision 
• Document AI

Result

• Faster time to market. Manual process to launch was automated, earlier business was taking 1 – 2 weeks to launch. With new modernised system business can launch with-in 4 hrs (half a day), which made go to market in minimal time. 
• Single view of first part data in one system.
• Single system for all Digital Campaigns and Incentives management. 
• Reduced maintenance cost.