Near-/Realtime Data Warehouse

Parallel to the development of the new payment system, sumIT was commissioned to design and develop a completely new data warehouse. This DWH forms the base for the development of several data marts, regulatory reporting and operational interfaces.

Business Intelligence

Development of reporting with dashboard and reporting functionalities for tracking business activities from various perspectives, such as trending and alerting.

Customer Intelligence

Adaptation of financial services to customer needs by linking and evaluating information about previous use of services and deepening customer relationships.

Challenge

 
  • Timely implementation of use cases on the Databricks platform
  • Near-time/real-time provision of data in an Oracle-based data warehouse
  • Creation of special loading processes designed for hundreds of millions of transactions per day
  • High-performance loading and provision of information, taking into account the large volume of transactions

Approach and customer benefits

 
  • Requirements analysis and target vision creation
  • Design and conception of the new analytics platform
  • Use case-driven platform development
  • Development of a structured roadmap with iterative implementation based on predefined priorities
  • Ability to analyze business activities from different perspectives, such as trends and alerting
  • Quality dashboard for visibility of transaction security and ensuring transaction quality and processing speed
  • Ensuring compliance with financial regulatory requirements, including reporting
  • Coverage of future analytics use cases and services for affiliated banks
Delivery sumIT
  • Support in creating a detailed technical/IT concept for the first phase and support in creating rough concepts for further phases
  • Setting up raw data storage in the DWH and implementing loading processes from various sources in daily and near/real-time mode
  • Logical setup of a represented CI data mart as a provisioning interface for the CI application
  • (Partial) modeling and filling of the provided OP-CI data mart
  • Ensuring operational performance

Tools and technologie

    • Oracle Datenbank (DMBS)
    • Oracle Data management with SQL/PLSQL
    • Oracle Replication to ensure real-time processing