Global Analytics Platform for a US-Based IT Service Management Organization

Client

The customer is an American software company based in Santa Clara, California, that develops a cloud computing platform to help companies manage digital workflows for enterprise operations.  

Challenges

• Optimize all business functions from SAP HANA to Snowflake by 2022.
• Leverage a cost-effective solution that delivers increased stability, flexibility, and performance. 
• Modernize data analytics and Business Intelligence (BI) tool landscape without business disruption.

LTM Solution

• Migrated all SAP objects to Snowflake-compatible objects. 
• Optimized the Snowflake objects for better performance.
• Re-engineered the existing extracts and transformed SAP BO Data Services (BODS), Dell Boomi to Matillion ingestion pipelines (outbound and inbound) via reusable/near-real-time ingestion framework.
• Ensured near real-time replication data using HVR and Perspectium.
• Repointed Tableau, Power BI, Microstrategy (MSTR), and Business Objects (BO) reports to Snowflake.

Business Benefits

• Delivered significant cost reduction due to the elimination of SAP HANA licenses
• Automated ingestion framework built for various source types
• Optimized platform capacity management for future analytics use cases 
• 2-3x performance improvement in extract refresh and dashboard rendering time
• Met critical Business SLA/KPIs 
• Reduced existing technical debts in the integration area
• Created master inventory for seamless ServiceNow usage