Data Warehouse Development for a Bank

Project overview

A data warehouse was implemented to connect and analyze business data from heterogeneous sources. The data warehouse is the core of the BI system, which is built for data analysis and reporting. It is a blend of technologies and components which aids the strategic use of data. It is the storage of a large amount of information by a business that is designed for query and analysis. It is a process of transforming data into information and making it available to users.

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 significant bank operations.

Client information

Bank al Etihad is a Jordanian bank that offers a wide range of financial services, including online payments and mobile banking. It is one of the fast-growing banking entities in Jordan that strives to keep pace with the current global economy and technological advancements.

Team composition

10 members
Client name

Bank al Etihad
Expertise used

Data warehouse and ETL, BI and reporting, Oracle
Duration

Ongoing
Services provided

Software architecture, System integration services, Data migration services, UI/UX design
Country

Jordan
Industry

Banking, Financial Services

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

The challenge was to develop and integrate a data warehouse, to implement a liquidity risk management system for cooperation with the European Bank for Reconstruction and Development. The final goal was to get a “golden source” and develop the main analytical and reporting dashboards.

Solution delivered

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 15 integrated systems, reporting systems for credit and deposit portfolios. We run multiple tests and delivered the project on time.

Case study

Data warehouse for bank

diceus.com

Data warehouse for bank

15

15 integrated reporting systems
Partnership with the International Advisory Services Frankfurt School of finance and management
Implemented a liquidity risk management system for cooperation with the European Bank for reconstruction and development

Project overview

Client information

Information

Team composition:

10 members
Client name:

Bank al Etihad
Expertise used:

Data warehouse and ETL, BI and reporting, Oracle
Duration:

Ongoing
Services provided:

Software architecture, System integration services, Data migration services, UI/UX design
Country:

Jordan
Industry:

Banking, Financial Services

Business challenge

Technical challenges

In a very short period, we had to build a new design for data warehouse architecture, the managerial reporting system. The challenge was to develop ETL processes for extracting, transforming, and loading the data from the 15 source systems to a warehouse.

Solution delivered

Key features

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.
Bank-specific business measures

BI deliverables include improved risk review model, better credit scoring, and customer segmentation.
Improved business processes

They resulted in reduced load on commercial transaction systems and paved the way for optimized integrations.
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.
User-friendly interface

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

Value to our client

15

integrated source systems. These tools provide extra functionality, including robust reporting dashboards and BI deliverables.
New

data model for the deep analysis, strategical planning, forecasting.
The main data

“golden source”.

Tech stack used in project

PL/SQL
Oracle Apex
Oracle SQL Developer
Git
Jira
Microsoft Project

diceus.com

Software solutions bringing business values

4.9/5

46 reviews

Phil Reynolds CEO at BriteCore

"DICEUS team has consistently supported the BriteCore team for many years. Their engineers are well-educated and highly invested in the ongoing quality of the BriteCore platform with sustained relationships that extend over four years. We appreciate everything the DICEUS team brings to the table as a development partner."

Soren Hundeboll Founder at InsuBiz

"The DICEUS team is flexible in this collaboration, their expertise shines. I like that they are not afraid to suggest alternative designs. If DICEUS team thinks that my way of crafting a user interface is not ideal, they will confront me with an alternative. They don’t simply take what I give them and run with it if there is a better way."

Soren Hundeboll Founder at RiskVille

"Existing clients were introduced to the cloud software and are eager to adopt it. Although accustomed to full stack development, the team is flexible in this work, because they managed to develop a certain part of the stack. DICEUS could recommend me alternatives to solve the issues."

Richard Haynes CEO at eTool

"The project ran smoothly. DICEUS delivered good work and increased resources in an effort to maintain deadlines. The project itself was adding functionality to an existing web app and DICEUS had to quickly become familiar with a very large code base to deliver the work which is commendable. We will consider them for future projects."

David Abbott CEO at Take Note

"We were relieved when we started the work with DICEUS, the competence level promised, was evident with a real commitment to quality. They gained a quick understanding of our business which meant they were highly productive very quickly. The price was also competitive, reducing the costs of working with our previous partner in India and probably halving the price we would pay for less qualified developers in the UK."

Robert Koval Managing Director at TeamBase DMCC

"The collaboration has increased by as much as 25% each year, thanks to DICEUS’ technical capabilities and quick feedback adoption. The team’s professionalism, cost-effective rates, and consistent delivery continue to support both the engagement and product end-users."

Andrew Kagan Project Coordinator at AMFS

"DICEUS demonstrated a very high degree of expertise in the type of programming and the product environment that they’re working in, which is exactly what I was hoping to find. I would say their core competency was having a very strong depth of programming expertise and knowledge within this particular market, and also within the platform that they were working on."

Data warehouse for bank

Project overview

Client information

Business challenge

Technical challenges

Solution delivered

Key features

Advanced DWH

Bank-specific business measures

Improved business processes

Multi-level reports

User-friendly interface

Value to our client

15

New

The main data

Our tech stack