Menu
search
Let's Talk
Back close

Business Impact

  • 30TB

    Of data migrated to Google Cloud

  • Faster access to real-time querying

  • Improved actionable insights

Customer Key Facts

  • Location : North America
  • Industry : Insurance

Problem Context

The customer, a leading P&C insurer company, had an on-prem enterprise data warehouse (EDW) hosted on Oracle Exadata which had evolved into a massive and complex system that was difficult to own and maintain. This made the native connection and visualization of data sets from the EDW even more difficult. The customer wanted to migrate to Google Cloud Platform (GCP) to facilitate flexible consumption of their EDW data.

Challenges

 

  • Need for more efficient methods to build and manage ETL/ELT Extract Transform Load processes to transfer the data between systems for real-time analysis
  • Lack of an automated system to build, test, and deploy software for continuous integration and testing between systems

Technologies Used

Google's BigQuery
Cloud Data Fusion
Cloud Storage
Cloud Composer
Cloud Dataproc

Building A Processing Pipeline To Ingest, Process And Load Raw Data From Claims System Onto GCP

Solution

Quantiphi migrated 150 terabytes of Claims, Premiums, Policies, and Financial transactions data from Oracle Exadata to Google’s BigQuery and built a financial transaction model, a production-ready claim center data warehouse on Google Cloud, and an enterprise-grade DLP solution to manage its RED data.

Quantiphi also created a scalable data architecture and data processing pipelines that will ingest, process and load the raw data from the Claims system onto GCP. 

Result

  • Petabyte-scale functionalities, and flexible pricing
  • Improved data governance and security
  • GCP’s scalable architecture reduced querying time, automated backups, and decreased downtime 
  • Significant cost savings for the customer
  • Higher performance with BigQuery over the on-prem Oracle database 
  • Flexible data ingestion pipelines and serverless capabilities enabled data warehouse creation for analytics and machine learning
  • Improved actionable insights through faster and flexible consumption of EDW data on Google Cloud 
  • Real-time analytics

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk