Report-Centric DataMart Development Projects

Client Description

Sberbank Hungary was the Hungarian subsidiary of the international Sberbank Group, providing banking services for both retail and corporate clients. Its activities included lending, account management, and offering various savings and investment products. It operated under the ownership of the Russian parent company and aimed to provide innovative, customer-focused financial solutions in the Hungarian market.

Project General Description

We participated in the creation of various reports with diverse data content. These tasks included data migration, design, specification, development, optimization, testing, and submission on the database side. Additionally, we worked closely with the business area related to the reports, conducting activity assessments and developing business specifications. This also encompassed integration processes with the existing system, the development of new and custom loading engines, and ensuring regular and scheduled runs—particularly to support monthly data submissions. Notable examples include the monthly data submission for MNB HITREG, the Basel II capital adequacy reporting system, Risk Data Pool for bank risk management, and the development and enhancement of IFRS calculation engines and balance management.

Let's talk!
Banking, Financial, and Insurance Sectors
​ / ​
Risk Management
​ / ​
Controlling
​ / ​
Accounting
​ / ​
Treasury
​ / ​
RWO

Challenge

The bank's main goal was the integration and unification of various data sources and data marts. Harmonizing different formats, definitions, and quality standards required precise planning and execution. We needed to ensure data accuracy and reliability across the different reporting systems.

Close collaboration with the business units was essential for the successful implementation of the project. We conducted a detailed activity assessment in cooperation with the client. Our tasks also included defining precise requirements and harmonizing processes.

We had to consistently meet tight deadlines, which was further complicated by the limited availability of expert human resources. We addressed this challenge through effective project management techniques and continuous development of team members' skills.

How we helped?

  • Database Development and Optimization
  • In addition to migrating existing databases, we created new, more efficient structures capable of handling increased data volumes and complexity.
  • Activity Assessment
  • We conducted a detailed mapping of business processes and data requirements, identifying current practices and challenges.
  • Specification Development
  • Precise definition of business requirements, including data structures, reporting formats, and processing logic.
  • Process Harmonization
  • We aligned processes across different areas, optimizing data flow and eliminating redundancies.
  • Data Model Creation
  • Harmonizing different formats, definitions, and quality standards required precise planning and execution. As a result, we developed a unified and consistent data model that ensured the accuracy and reliability of data across various reporting systems.
  • Integration Processes and Custom Loading Engines
  • We developed complex ETL (Extract, Transform, Load) processes that allowed for the efficient collection, cleansing, and loading of data from various source systems into the new data mart.
  • Key Reporting Systems Implementation
  • Throughout our projects, we have implemented several key reporting systems that comply with strict regulatory requirements.
  • IBM DB2
  • DataStage
  • Basel2 engine generator