Shifting Data Platform to Snowflake for a Leading American Coffee and Beverage Company

Client

The client is a US-based beverage company selling coffee, sodas, juices, and other soft drinks. 

Business Challenges

• Transform & modernize the existing data platform through mindful migration and frictionless integration of data with the acquired company. 
• Consolidate a variety of data types (POS, trade promotion, financial, demand management, master data) from multiple data sources (SAP BW, Azure SQLDB, Oracle Demantra, SAP ECC) onto a unified cloud data platform.
• Smoothly re-engineer the existing architecture to help facilitate both hot and cold business data entities into a unified orchestrated view. 
• Enable self-service capability for business by implementing adequate data management and augmenting the reporting services for insightful analysis.

LTM Solution

• Smart lift & shift migration of existing on-premise SQLDB models by consolidating data from various sources and other external files to Snowflake-based cloud data platform.
• Redesigned and re-engineered data objects from SAP BW application having complex multi-level views to move it into Snowflake data platform.
• Data ingestion using Informatica Cloud and SnowSQL conserving business logic.
• Integration of both entities’ master data with a global view enabling smooth transition to Snowflake, leveraging LTI’s Canvas PolarSled platform, and a suite of tools to automate the workload and governance.
• Financial data consolidation from different source systems by integration of Cognos TM1 Data, leveraging the ELT approach for EPM reporting.
• Ensure data validation by exercising the spot and comparative testing to maintain business continuity on Snowflake.
• Built a semantic data layer on top of snowflake using Atscale to enable self-service capability for business teams.

Business Benefits

• 30 - 50% reduction in IT spend by providing better and efficient data platform
• 2X improvement in the overall business reporting
• Faster Transformation Enhanced computation power leveraging the high scalability of Snowflake, helping both the companies with a smooth and successful merger.