Snowflake (On Azure) Migration for Contractor Data Management system

Apr 01, 2023

Our client is a US-based multinational oil and gas corporation.

The client wanted to:

Create comprehensive reporting for all non-process-related transactional manufacturing data that does not exist today.
Leverage a data repository to serve as a one-stop-shop for analytics and reporting.
Centralize global reporting for all sites, instead of maintaining reporting for each site.
A modular and scalable data mode to minimize the cost of ownership and reduce IT spend on data consolidation.

Created a data model in-lined with the client’s strategic roadmap for Azure cloud migration.
Created a data model that can accommodate future integration of SAP data in CDMS reporting
Created a new UI to easily conduct health checks across all sites.
Cost savings due to change in design approach from on-prem SQL Server to snowflake – $45Mn/year starting from 2023
Created automation script for building wrapper view on top of the raw layer which reduces manual efforts.

55% reduction in efforts for data consolidation which is done currently by swapping tools.
95% reduction in efforts by an automated creation of wrapper views
Created an Azure cloud data repository as a one-stop-shop for analytics and reporting of non-process related manufacturing work.
Eliminated the need of swapping between tools to run queries. – SQLServer, MS Access, Tableau.
Eliminated constraints around the processing of large volume data for doing system and health checks.