SMP Bank has automated the issuance of mandatory reporting forms on the Kontur platform

2022: Form Release Automation 0409122, 0409157, 0409302, 0409401

NSR Bank put into industrial operation the issue of mandatory reporting forms 0409122, 0409157, 0409302, 0409401 from the corporate data warehouse. This was announced by Intersoft Lab on November 22, 2022. In addition to reducing labor costs for preparing forms, the Bank was able to ensure detailed control over the quality of the reporting data and minimize operational risks.

Illustration: rpkkub.ru

Thus, the portfolio of automated regulatory reports issued from the Bank's corporate data warehouse (QCD) was replenished with 4 more forms:

• 0409122 "Calculation of Short-Term Liquidity Indicator (Basel III),"
• 0409157 "Information on large lenders (depositors) of a credit institution,"
• 0409302 "Information on funds raised,"
• 0409401 "Report of the authorized bank on foreign transactions."

The project was implemented by the joint project team of Intersoft Lab and NSR Bank on the domestic software platform "Kontur." The preparation of forms 0409157, 0409302, 0409401 is based on data previously collected in QCD. To automate the form 0409122, the missing analytical characteristics for the deal portfolios are loaded into QCD. The transfer of the reports to commercial operation was preceded by 3 (three) issues of each form, accompanied by the vendor's specialists in the pilot operation mode.

Шаблон:Quote 'author = noted Veronika Divid, Chief Accountant, JSC "SMP Bank."

2021: Automation of Reporting Form 0409155

On the basis of the corporate data warehouse (QCD), built on the Kontur platform from the domestic company Intersoft Lab, the NSR Bank automated the release of reporting form 0409155 "Information on contingent liabilities of a credit nature and derivative financial instruments." Intersoft Lab announced this on August 26, 2021.

The previously used technology for preparing form 0409155 involved the manual collection and processing of data on financial instruments from several accounting systems of the Bank. Due to significant differences in the formats of provision and a significant range of processed data, this process was highly laborious and required automation.

By the time of the start of the project, QCD Bank already had most of the data required to prepare form 0409155. Analysts at Intersoft Lab analyzed and determined the composition of the missing data specific to the release of the form. Guided by it, the Bank's IT staff modernized the necessary procedures for integrating QCD and source systems. The Intersoft Lab project team set up the solution for calculating the report form indicators and implemented the necessary data quality checks. Accounting employees are provided with a special interface to monitor totals in the reporting form. With it, you can detail any amount before a separate transaction. Reconciliation of the form issued according to the QCD data with the reference data confirmed its correctness.

As part of the pilot operation, Intersoft Lab specialists provided support for the solution during three cycles of submitting the form to the regulator.

The solution ensures fully automatic calculation of parameters of form 0409155 based on data collected in the Bank's QCD for the purpose of their export to the Bank of Russia's KLIKO PC.

{{quote 'author = said Aleksei Nazarov, Head of Information and Analytical Systems Department of Information Technology Department, SMP Bank Group. |

The data of the corporate data warehouse is already used in the preparation of regulatory reports, and the automation of the preparation of form 0409155 is a natural step in the development of QCD as a single source of reliable data to support various analytical tasks. This approach allows you to reduce the time and labor costs for the implementation of information needs, ensures the consistency of reporting prepared in various business verticals, and, in general, increases the return on investments made in QCD,}}

Шаблон:Quote 'author = noted Veronika Divid, Chief Accountant, JSC "SMP Bank."

2018: Integration of CDS with CABS "Bank 21 Century"

On September 26, 2018, Intersoft Lab and Inversia announced successful cooperation within the framework of the corporate data warehouse development project in the SMP Bank Group. As a result of the joint work, QCD was replenished with data from the deposit portfolio of individuals and legal entities from BANK 21 VEK, operated by Mosoblbank.

For September, 2018 from KHD on the CPM platform Kontur is issued the administrative and analytical reporting under the loan and deposit portfolio of SMP Bank, cash cards of participating banks of Group, form 04091120 in SMP Bank and Mosoblbank, data for Bureau of credit histories are prepared. Systematic work is underway to scale QCD to a banking group: the range of storage data is expanding, data sources from other banks of the Group are connected: the branch of InvestCapitalBank, Mosoblbank and FinanceBusinessBank.

The development and implementation of ETL processes is the most laborious task in the creation of QCD. To minimize the time and labor intensity of integration of SMP Bank Group CDS with Mosoblbank ABS - BANK 21 VEK CABS - it was decided to invite Inversia as a partner of the banking system vendor. As a result, Inversion specialists prepared procedures for unloading data from the accounting system, and Intersoft Lab took over the transformation of this data and loading it into the QCD model.

This reduced the integration time and ensured the required capacity to fill the storage with data used for reporting. The application of the Pentaho Data Integration (Kettle ETL) OSS platform for the integration of CABS and QCD has provided additional savings for the customer.

2017

Automation of form preparation steps 0409120

On November 28, 2017, Intersoft Lab experts presented the results of the project to automate form 0409120 in the NSR Bank group.

The project to create a corporate data stores (QCD) on the SRM platform "" has been Kontur conducted in the NSR Bank group since 2016. As of December 2017, QCD is charged with the tasks of consolidating and reconciling accounting data of the Group's participating banks, as well as preparing management reports for SMP Bank JSC and PJSC; Moscow regional bank in parallel, work is underway to expand the QCD data model and scale the solution to other members of the banking group.

Storage is used by financiers, marketers, risk managers and business unit specialists. Since October 2017, the composition of QCD users has been replenished by accountants of SMP Bank and Mosoblbank, by order of which the mandatory reporting form 0409120 "Concentration Risk Data" began to be prepared on the basis of the storage facility.

As explained in Intersoft Lab, the release of form 0409120 is quite simple from a methodological point of view. The main difficulties are technological in nature and are associated with the need to process large amounts of primary data for customers, accounts and contracts in order to ensure their quality, segmentation and calculation of reporting indicators.

As a result of the project, almost all technological stages of preparation of form 0409120 were automated in the group's banks for 3 months:

• collection in CDS of almost all data for preparation of the form;
• classification (enrichment) of data on personal accounts and sub-accounts by types of requirements and obligations;
• calculation of daily items and aggregated indicators of the form;
• uploading the form to Kliko;
• Service monitoring and control of limits on a daily basis.

For the issuance of the form for the reporting period, including the preparation of data, their enrichment and calculations, specialists of SMP Bank, for example, require no more than 2 hours. It takes less than 500 minutes to calculate daily items for 2 thousand personal accounts involved in the calculation. Employees of the group's bank accounting departments were able to independently control the quality of the initial data, manage the settings of the enrichment rules, and make changes to the calculations of the form indicators.

Release of Form 0409120 Regulatory Reporting Based on Intersoft Lab Solution

Intersoft Lab on November 8, 2017 announced that it had implemented support for form 0409120 in the appendix "Reporting for the Bank of Russia." The application operates on the basis of the Kontur repository and automates the data preparation process and the release of more than 60 reporting forms in accordance with the requirements of the Bank of Russia. With the help of a solution from Intersoft Lab, banks of the SMP Bank group submitted to the Bank of Russia Form 0409120 for the 3rd quarter of 2017 on time.

Form 0409120

The reporting form, which credit institutions with assets of less than 500 billion rubles are required to provide quarterly from October 1, 2017, contains information on the level of risk concentration by types of economic activity, geographical areas, types of instruments and individual sources of liquidity, as well as information on established limits and their violations on transactions, counterparties, financial instruments. The application supports the export of the report to KLiKO and CAS formats. Users can preview and adjust the quarterly report data, and quickly recalculate the report form, if necessary.

Project Summary

Within the framework of the project, the issue of Form 0409120 based on the appendix "Reporting for the Bank of Russia" was implemented in the Bank's SMP group.

On form 0409120 in October, banks reported for the first time. We passed this exam together with credit institutions of the SMP Bank group. Automation of form preparation based on corporate storage has largely contributed to solving the problem of lack of individual data in ABS, "said Julia Amiridi, Deputy General Director of Intersoft Lab for Business Development.

According to her, by the end of 2017, Intersoft Lab should complete the next stage of data storage development in the NSR Bank group, which will optimize data preparation for the release of form 0409120.

Implementation of the domestic information and analytical system

On May 25, 2017, the company Intersoft Lab announced the introduction of a domestic information and analytical system SRM-platforms "Contour" in the group. NSR Bank

SMP Bank (2017)

Project progress

The project started from the pilot stage, during which the main mechanisms of the Kontur platform were tested at the head bank of the Group for the creation of ECC and automation of management and analytical reporting.

Intersoft Lab specialists deployed the Kontur data warehouse, using the Pentaho Data Integration Kettle ETL open platform, they loaded accounting data distributed across several sources, information on customers, loan agreements of legal entities and individuals, and additional analytical signs on accounts and contracts. An application of the same name was set up for the release of management reports, and loan portfolio storefronts were built for analytical reports.

Project results

As a result, financial results reporting can be detailed not only by financial responsibility centers, as it was before, but also receive information in the context of customers, products and points of sale with the possibility of detailing to the level of primary operational accounting data. It became possible to receive daily management balance sheet, financial result report and other statements. Operational preparation of analytical reports on the loan portfolio of individuals and legal entities is provided.

"The Group has serious business development plans and the introduction of an enterprise data warehouse was an important step towards implementing the strategy. Today, with its help, we receive high-quality management information that will help to quickly solve the priority strategic tasks of optimizing and developing the network of points of sale, introducing products and increasing the profitability of assets of JSC SMP Bank. The next stage, the implementation of which our specialists have already begun, is the scaling of the solution to the entire banking group. " Alexander Rumyantsev, Head of Information and Analytical Department, JSC "SMP Bank"