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.
As part of these phases, source-to-target (S2T) mappings, table structures, and transformation models were developed; the CDC mechanism is used for loading changes. The scope of work also included the preparation of technical and test documentation, as well as output data in the formats prescribed by the Central Bank.

Expert Commentary Roman Solovyov, CEO of DataScale, comments: "The completion of these phases is an important step in the development of Universal Bank's data warehouse. We have expanded the CDW's coverage from core customer and accounting data to complex product areas. The credit and deposit domains form the foundation for consistent preparation of regulatory data with the necessary detail and traceability of its origin. This allows the bank not only to meet regulatory requirements but also to build high-quality analytics on verified data."

Summary The completion of these two phases means an expansion of the CDW's coverage from core entities to important product areas of the bank. Universal Bank's data warehouse now includes not only reference information and balances but also a complete history of credit and deposit operations, opening up new opportunities for reporting and business analytics.