Data Scale Completes Development of Corporate Data Warehouse for Credit Products and Deposits at Universal Bank
12 ноября 2026 г.
Data Scale announces the successful completion of the third and fourth phases of the Corporate Data Warehouse (CDW) project for Joint-Stock Commercial Bank "Universal Bank" in Uzbekistan. The new data domains cover two key areas of banking operations — credit products and deposits.
While the previous phase focused on core entities — customers, accounts, balances, turnovers, and reference data — the project team has now concentrated on describing banking products, contracts, and related transactions. For each domain, Data Scale specialists analyzed source data, identified relationships between entities, and defined transformation rules for the corporate data warehouse.
Phase 3: Credit Products
Within the credit domain, a detailed data model was developed. It covers a wide range of entities: credit contracts and applications, credit products, financing terms, related accounts, interest rates, principal and interest repayment schedules, as well as collateral information. The model includes the necessary reference data and links to customer data.
This approach enables credit relationships to be represented as a consistent dataset: from credit product and contract characteristics to the information required for regulatory data marts. The development took into account various types of credit products, including overdrafts, factoring, and leasing, within the requirements of the RegTech model.
Phase 4: Deposits
The deposit domain covers information on deposits of both individuals and legal entities. The scope of work included contracts and accounts, deposit products, placement terms, currencies, interest rates, and payment schedules. To the extent required by regulatory requirements, data on related card products is also included.
The developed structure combines information about the customer, contract, product, and its servicing. This ensures a unified approach to preparing deposit data for the regulatory model and allows relationships between entities to be used instead of disparate datasets from the source system.
Architecture and Technologies
For both domains, the established multi-layer CDW architecture was used:
- RAW — data ingestion from the source;
- STAGE — a layer for intermediate data cleansing and preparation;
- DDS — formation of a normalized detailed model;
- RegTech — preparation of specialized datasets for regulatory reporting.