Data Lake Modernization Using Snowflake for a US-Based Consumer Goods Giant

Client

The customer is an American brand used for oral hygiene that manufactures and distributes household and commercial cleaning products, and dental and other personal-care products. 

Challenges

• Build a supply chain use case in Snowflake
• Setup a near real-time data replication between Snowflake and multi-regional SAP systems
• Shift the BW consumer workload to Snowflake for supply chain analytics
• Build monthly/daily snapshot collection tables in Snowflake for trend reporting

LTM Solution

• Initiated the migration project for the supply chain KPIs that include inventory management, demand management, and customer service.
• Re-engineered the existing SAP Business Warehouse (BW) extractors, BW transformation rules, routines, and Business Explorer (Bex) queries by adopting an accelerated migration to Snowflake using PolarSled. 
• Setup near real-time replication of SAP ERP Central Component (ECC) data using High Volume Replicator (HVR).
• Re-designed the overall data model, staging, and DSO layer having views in Snowflake. 

Business Benefits

• 100% data matched between SAP BW and Snowflake
• 16 weeks end-to-end implementation of supply chain use case with near-real-time replication in Snowflake
• 50% automation achieved in object analysis from SAP BW using PolarSled