Reimagined Data and Analytics Landscapewith Snowflake for a Leading GlobalSoftware Company

Client

A leading American software company that develops a cloud computing platform to help manage digital workflows for enterprise operations.

Challenges

The client relied on SAP HANA for its business functions and was looking to modernize its data and analytics stack for increased stability, flexibility, and performance while optimizing costs. The company had a key ask - to forklift all business functions from SAP HANA to Snowflake while optimizing the data analytics and BI tools platform without business disruption.

LTM Solution

• Team LTM involved IT and business partners with shared responsibilities from the early planning stages to the soft launch.
• Aligned the team in a POD model for business areas and performed proof of concept for every change in approach with approval from the architecture/ electronic data platform team.
• Migrated all SAP objects to Snowflake-compatible objects and optimized them for better performance. 
• Reengineered the existing extracts/transformation of SAP BODS, Dell Boomi to Matillion ingestion pipelines. 
• Set up near real-time replications data using HVR and Perspectium and repointed Tableau, Power BI, MSTR, and BO reports to Snowflake.
• Persisted the data across the processing layer to meet business service level agreements..

Business Benefits

• Implementation of a modern analytics platform with future-proof analytical capabilities.
• Reduction of existing technical debts in the integration area.
• 3x improvement in rendering time.
• Creation of master inventory for future usage.
• 40% reduction in code development time.
• Reduction in SAP HANA licenses.