Neoflex Reporting Big Data Edition

Neoflex Reporting Big Data Edition is the new version of the Neoflex Reporting system which, as of September, 2018, is used in more than 20 banking and non-bank financial institutions for receiving a different type of the reporting. Neoflex Reporting Big Data Edition integrates advantages of classical technologies and the last practices in the field of processing of Big Data.

Neoflex Reporting Big Data Edition allows the customers having large volumes of diverse data to prepare the regulatory reporting according to strict requirements of the Central Bank of the Russian Federation. High high-speed performance of a system is reached due to use of technologies of a stack of Big Data. For storage of detailed data HDFS (Hadoop), and for processing — Spark which supports the distributed calculation in-memory is used.

Neoflex Reporting Big Data Edition interface: a working window in the form of the calendar, Drill-Down transitions, the configured role model, an opportunity to use report templates and test steps

Optimization of cost of ownership (TCO) of Neoflex Reporting Big Data Edition is reached due to use of the open source software (open source) and, therefore, economy on paid DBMS and ETL means. Besides, possibilities of Hadoop and Spark on parallel processing of data allow to provide high fault tolerance of a system at smaller costs for the server hardware. In addition this technology provides a possibility of almost unlimited horizontal scaling of system performance, speak in Neoflex.

Advantages of a system

Setup of algorithms of calculation of forms and indicators by business users

For convenient verification of reports in a system the set of the rasshifrovochny, detailed and sverochny reports is implemented. Users can change settings of the main calculations and indicators, and also to create own rasshifrovochny reports and indicators from scratch or on the basis of already created reports without involvement of IT specialists.

The subsystem of quality control of data contains 350 preconfigured data validations. Summary and detailed reports allow in a convenient form to receive as a top level picture of quality of data, and in grouping by different parameters. If necessary it is possible to fall to the level of the specific personal account / transaction.

Fast processing of large volumes of data due to Big Data technologies

Use of Big Data technologies for storage and processing of large volumes of data allows to provide the high speed of data loading from diverse sources (data from the structured and semistructured sources: csv, xls, xml, etc.) and their processing in compliance to tough SLA of providing the reporting in the Bank of Russia. As the instrument of data processing in a system the product of own development Neoflex Datagram is used.

Low TCO

Use of Open Source Software and Commodities Hardware allows to reduce considerably acquisition value and ownerships of a system. For data processing using Hadoop servers of lower cost at reliability augmentation and fault tolerance at the expense of a possibility of repeated reservation can be used. Also use of open source allows to reduce the budget by acquisition of expensive licenses for industrial DBMS and ETL tools.

Linear scalability and fault tolerance

At increase in volumes of the processed data and/or at the same time working processes a system easily is scaled due to adding of new machines in Hadoop cluster. And the mechanism of reservation of data on nodes of a cluster allows to increase fault tolerance of a system.

Types of the reporting

Neoflex Reporting allows to automate receiving obligatory, managerial, tax, IFRS reporting, reportings under risks and other reporting of financial institutions. A system provides a wide covering of financial instruments.

Obligatory reporting

The module provides formation of the most demanded forms of the obligatory reporting for the Central Bank, including 0409101, 0409102, 0409115, 0409120, 0409303. Now delivery of Neoflex Reporting includes about 200 reports. In case of implementation of the module "Obligatory Reporting" the organization has an opportunity to use service of support of changes of requirements of the Central Bank. In Neoflex company there is a division of specialists who perform monitoring of changes of the legislation connected with the reporting of the organizations for the Central Bank. In addition to monitoring of changes, specialists carry out the analysis of all connected materials for the purpose of determination of influence on the reports and business processes concerning obtaining the reporting for the Bank of Russia.

At the publication of the project of changes on the website www.cbr.ru specialists of Neoflex company send the information letter to responsible business users of the organization in which they in addition specify the term of providing analytical materials on this project of changes.

Management reporting

The module "Management reporting" reflects information in the detailed type at the maximum approach to an economic entity of transactions and transactions. Use of specialized settings and the Qualifier tool allows to implement individual structure and methodology of a reporting preparation for each organization.

Possibilities of the module:

• maintaining layered design of articles of management accounting;
• maintenance of the reference book of the Centers of the financial responsibility taking into account multifilial structure of the organization;
• flexible configuration of mechanisms of transfer redistribution of results of operating activities;
• flexible configuration of mechanisms of allocation of non-operating expenses;
• use of adjustments at agreements about income redistributions / expenses at the level of transactions between divisions of the organization;
• possibility of carrying out plan fact of the analysis of results of activity of credit institution;
• possibility of planning and budgeting, the reporting under budget implementation under different levels with deep detailing of all income types and expenses;
• measure calculation of efficiency of activity of divisions, profitability of a product, profitability of investment projects and so forth;
• tracking of all process of formation of a managerial financial result by the organization of multistage checks by a subsystem of quality control of data.

Reporting under IFRS

The module "Reporting under IFRS" supports a reporting preparation method by method of transformation of accounting data under RAS. The module contains a broad set of show-windows and the implemented algorithms of transformation of accounting of RAS in IFRS, the mechanism of calculation and generation of automatic adjustments and also allows to perform input of manual adjustment postings.

The module provides following features:

• maintaining multilevel hierarchy of articles of IFRS;
• flexible configuration of correspondence rules (mapping) of the chart of accounts under RAS to articles of IFRS for reclassification implementation;
• use of a packet of the automatic preconfigured standard adjustments;
• creation of adjustments in the manual mode by means of the user interface;
• implementation of sdelochny model of information representation;
• detailing of horizontal model of transformation to the level of accounts of the 2nd order, by terms, currencies, the countries and the industries;
• implementation of checks at each stage of drawing up IFRS of the reporting and quality control report generation.

Distinctive feature of the module is preparation of the audited reporting and a possibility of consolidation of the reporting under the IFRS standards. Neoflex has experience of implementation of the module IFRS according to the IFRS and US GAAP standards.

Tax statements

The module of tax statements automates process of data preparation for obtaining registers of tax accounting, data purification of tax accounting, calculation and issue of tax declarations of the organization according to requirements of the Tax Code of the Russian Federation.

The module allows:

• keep the qualifier of an income / expenses of the organization for the purposes of tax accounting;
• make grouping and "coloring" of personal accounts according to lines of the tax declaration;
• perform input of the global indicators which are used by drawing up tax statements taking into account their time of action (a refunding rate, tax rates, extreme values of the recognized costs, etc.);
• perform reconciliation of initial data with reporting indicators for the Bank of Russia;
• make predesign of a taxable basis according to accounting data;
• calculate analytical registers of tax accounting on the basis of data of operational accounting;
• generate automatic adjustments and perform input of manual adjustments via the user interface;
• consider the created adjustments when calculating a taxable basis;
• perform calculation of measure values of tax declarations for income tax (Chapter 25 of the Tax Code), for the VAT (Chapter 21 of the Tax Code), for the property tax (Chapter 30 of the Tax Code);
• store archives of the handed-over tax statements for the previous reporting periods;
• provide information of tax declarations in detailing to primary data.

Reporting under risks

The module "Reporting under Risks" is intended for compliance to requirements of the Bank of Russia to the capital, measure calculation of risk and internal ratings, many organizations are faced by a problem of data preparation and reporting according to Basel II and Basel III are included tools:

• on implementation of data loading with identification of changes in last periods;
• on quality control of data;
• on creation of the specialized show-windows consolidating information from separate sources for calculation of key hazard rates;
• on integration with models of calculation and forecasting of risk and to use this yielded and results of stress testing in the reporting;
• on sale of mechanisms of control and monitoring on all to types of the financial transactions subject to credit and settlement risks regarding observance of the set limits, using on-line of the reporting and formation of warnings and mailings to responsible specialists and divisions;
• on a possibility of development by specialists in risks of the organization of own analytical models — implementation of specialized area for work with the cleaned data, to fast connection of new sources, opportunities for use of data mining, modeling, stress testing and aggregation of risk;
• on implementation of a system of the analytical reporting and integration into the industrial BI tool facilitating process of formation and the analysis of the reporting.

Add-on modules

For long-term practice by experts of Neoflex specialized modules to the system of preparation of the reporting Neoflex Reporting are developed for the solution of a large number of the tasks of the organization connected with preparation of the reporting:

• Subsystem of quality control of data - the module is developed for identification and elimination of problems with quality of data.
• The module "Uniform Client" is the tool for consolidation of customer information, its cleaning and deduplication. It is relevant for the organizations with a large number of sources of data on the client.
• The module "Qualifier" and the Module of adjustments are developed for simplification of process of preparation of the reporting by users of a system of preparation of the reporting of Neoflex Reporting.
• The module "Allocations" - is intended for setup of drivers via the user interface and directly calculation of allocations.
• The module "Transfers" - provides calculation of transfers for the configured transfer rate for each tool and assembly of necessary show-windows taking into account the received results.
• The module "Calculation of Reserves for RAS" - allows to configure settings of formation of reserves for portfolios of homogeneous loans and for individual loans. This module is used if in the organization a system source which has no built-in functionality by calculation of reserves according to requirements of RAS is used.
• The module "Financial Monitoring" - is intended for preparation of data on the transactions with money and other property which are subject to mandatory control and also about the suspicious transactions connected with possible financing of terrorism and legalization of income gained in the criminal way.

Features of implementation

According to developers, Neoflex Reporting Big Data Edition organically fits into an IT landscape of any bank. Two main schemes of system implementation are applied: with own layer of detailed data and also based on already available storage.

As a result of implementation of Neoflex Reporting Big Data Edition the client receives not only the fast system of preparation of the reporting, but also Data Lake with financial information which can be used for the solution of the most different analytical tasks of bank, including for the analysis of unstructured information — Elena Lukutina, the partner, the director of operating activities and technology development of Neoflex company notes.

High speed of setup of algorithms and processing of data at system implementation is provided thanks to the built-in Neoflex Datagram visual development environment. Model Driven Architecture implemented in a paradigm, Neoflex Datagram provides visual design of transformations of data and automatic generation of Scala/Spark of the code for execution on Hadoop a cluster. As a result, use of Neoflex Datagram allows to lower requirements to qualification of developers, and, respectively, system implementation cost.