US

Data Warehouse
for Bank

CASES

Advanced data warehouse with a reliable architecture that delivers an efficient workflow and information reliability thanks to automated processes. This solution provides consistent real-time control and analysis of the major bank operations.
  • Time decor icon

    Time

    Ongoing

  • Team decor icon

    Team

    10 members

  • Platform decor icon

    Platform

    Oracle DB / Web

  • Industry decor icon

    Industry

    Banking

demo screen
project idea bg item project idea bg item project idea bg item project idea bg item

Project idea Project idea

decor arrow

Challenge

There was a strong need to verify the information from the reports, clarify the business needs about the reporting systems and improve the data warehouse architecture to reach a smooth and consistent workflow.

separation icon separation icon

Project goal

To develop and integrate a data warehouse, to implement a liquidity risk management system for cooperation with the European Bank for Reconstruction and Development.

separation icon separation icon
decor arrow

Solution

A new design for data warehouse architecture was built, the managerial reporting system got formalized and clarified. ETL processes were released for extracting, transforming and loading the data from a source system to a warehouse.

Our Project Approach Our Project Approach

approach main image
  • 01

    Business Analysis and Specification
  • 02

    Legal Agreement and Agile Development
  • 03

    MVP
  • Our business analysts provided an in-depth research of the business needs and planned what functionalities the product required. After that, we were able to make an estimation for the final product.
    Our first task when we start creating apps is to understand the customer's requirements. For this, we run complex analyses to define the needed and not as required goals. Surely, we base our thoughts on the client's ideas.

  • Both sides have signed an SRS documentation for each iteration. This document was a basis for a legal agreement.
    The process of software development is built with an agile approach. Our SDLC is always agile and is divided into the milestones that last 4 weeks. So, the customer was able to monitor each stage of the development.

  • The Minimum Viable Product stage requires having enough features to capture feedback that will drive the integration of new functionality through the “build-measure-learn” approach.
    So, after the specification and extracting the requirements, we defined all the steps the potential customer would take while using our product. After that, we developed a list of specific features for each stage to plan the product.

  • Business Analysis and Specification

    Our business analysts provided an in-depth research of the business needs and planned what functionalities the product required. After that, we were able to make an estimation for the final product.
    Our first task when we start creating apps is to understand the customer's requirements. For this, we run complex analyses to define the needed and not as required goals. Surely, we base our thoughts on the client's ideas.

  • Legal Agreement and Agile Development

    Both sides have signed an SRS documentation for each iteration. This document was a basis for a legal agreement.
    The process of software development is built with an agile approach. Our SDLC is always agile and is divided into the milestones that last 4 weeks. So, the customer was able to monitor each stage of the development.

  • MVP

    The Minimum Viable Product stage requires having enough features to capture feedback that will drive the integration of new functionality through the “build-measure-learn” approach.
    So, after the specification and extracting the requirements, we defined all the steps the potential customer would take while using our product. After that, we developed a list of specific features for each stage to plan the product.

results results

We have developed and implemented a process of regular control and analysis of the core banking operations based on Oracle UBS Flexcube in partnership with the International Advisory Services Frankfurt School of Finance & Management. We built a data warehouse with 6 integrated systems, reporting systems for credit and deposit portfolios. We run multiple tests and delivered the project on time.

background image
results item

Key features Key features

  • User-friendly reports icon

    User-friendly reports

    Consistent and unified information source for scalable and reliable reporting. An interface provides users with easy-to-navigate elements.

  • Improved business processes icon

    Improved business processes

    A basement for further development and integration with other systems was built, the load on commercial transaction systems was eliminated.

  • Advanced DWH icon

    Advanced DWH

    A comprehensive data warehouse was built and based on the own information model with the data marts for all the operational workflow of the bank.

  • Multi-level reports icon

    Multi-level reports

    A new multi-level reporting system is based on Oracle BI, and it provides the opportunity to track each operation and transaction.

key features demo image

  • User-friendly reports icon

    User-friendly reports

    Consistent and unified information source for scalable and reliable reporting. An interface provides users with easy-to-navigate elements.

  • Improved business processes icon

    Improved business processes

    A basement for further development and integration with other systems was built, the load on commercial transaction systems was eliminated.

  • Advanced DWH icon

    Advanced DWH

    A comprehensive data warehouse was built and based on the own information model with the data marts for all the operational workflow of the bank.

  • Multi-level reports icon

    Multi-level reports

    A new multi-level reporting system is based on Oracle BI, and it provides the opportunity to track each operation and transaction.

Technologies Technologies

The product was built with the latest technology stack selected by our senior developers and tech leads.

Languages and Frameworks icon

Languages and Frameworks

  • PL/SQL

  • Oracle Apex 18

Development Environment icon

Development Environment

  • Oracle sqldeveloper

  • Git

Project Management and Requirements icon

Project Management and Requirements

  • Atlassian Jira (Requirements, Sprint planning, Defects)

  • MS Project

  • Scrum

  • CorkBoard

Let’s get in touch

Name

E-mail

Phone

Message

Thank you! We will contact you soon

To top of page
To top of page