Contact us

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

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 & 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.

LTI Solu­tion

  • 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.

Key Benefits