Neoflex Reporting

Main article: Business Intelligence determination

Neoflex Reporting is the system of analytics and preparation of the reporting.

2020: Inclusion in the Unified register of the Russian software

The Neoflex company, the developer of IT platforms for digital transformation, announced on November 9, 2020 inclusion of a system for preparation of the reporting of Neoflex Reporting in the unified register of the Russian software.

This product created to a basis on Open Source of technologies allows to automate formation of all types of the reporting (managerial, obligatory, tax, IFRS reporting and also reportings according to standards of IAS/GAAP).

Business of the large organizations, in particular the financial sphere, is directly connected with need to process considerable information volumes. As in one organization there can be several tens of systems sources, even data collection becomes a difficult task. But data are not enough to be collected and consolidated – it is necessary to provide access to them to different categories of internal and external users, to provide the multilateral business analysis and acceptance on its basis of the weighed management decisions. The product Neoflex Reporting allows to solve the listed problems.

Use of the open source software allows to optimize Neoflex Reporting ownership cost. At the same time high performance is provided due to use of MRR-SUBD Greenplum that allows to reach high reliability and fault tolerance of a system, at considerable cost reduction on the server hardware and software.

The functionality of Neoflex Reporting allows to enrich data and to control their quality, gives the chance to users without involvement of IT departments to configure algorithms of calculation of reports and indicators, to create own reports with interpretations. In addition Neoflex Reporting gives a connectivity of specialized analytical products of third-party suppliers, expanding with that functionality of the solution on planning, the analysis and control of activity of all directions of business of the organization.

Neoflex Reporting for November, 2020 is used more than in 15 large Russian and foreign financial institutions.

2018: Neoflex Reporting Big Data Edition

The Neoflex company in March, 2018 submitted the next version of a system of analytics and preparation of the reporting of Neoflex Reporting. The version of Neoflex Reporting Big Data Edition provides the multiple growth of speed of preparation of the reporting and allows to reduce operating costs thanks to Big Data technologies.

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 in the provided version 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.

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, claim in Neoflex.

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, explained in the company.

The updated interface combining convenience of work with spreadsheets and computing power of industrial platforms provides to business users an opportunity to independently create new reports and interpretations and also to configure algorithms of measure calculation and to perform them without involvement of IT specialists. At the same time access isolation of users to data of reports and also complete logging of all actions is provided.

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 noted.

It is possible to learn about Neoflex Reporting Big Data Edition in more detail here.

2015

50 terabyte - the total volume of financial information in Neoflex Reporting data warehouses.

According to requirements of the legislation in the Neoflex Reporting system new forms of the reporting, for example, 0409303 of "Data on the loans allowed legal entities" are implemented. The form, is under construction according to new approach of the Bank of Russia, and contains not the final calculated indicators, but detailed data on loans, up to a tranche of a credit line.

The module "Obligatory Reporting" was a part of the solution

On May 14, 2015 the Neoflex company announced emergence of new forms of the obligatory reporting. The report on one of them needs to be provided in the Bank of Russia in the summer of 2015.

Along with explanations and recommendations, the company announced addition in the Neoflex Reporting system, in the form of the module "Obligatory Reporting".

The functionality of the module "Obligatory Reporting" helps to support quickly changes of the legislation, automating process of preparation of new types of the reporting.

As a part of the module:

• The ready adapters to the most widespread core banking systems allowing to configure automatic loading of all necessary information, an opportunity to load data from any source in the shortest possible time (including CRM, a front office system or internal files of Excel);
• The subsystem of quality control of data performing checks at all levels: engineering control of the unloaded data, logical control of completeness and consistency of the loaded data, checks of mezhduformenny control with other reports (first of all, with forms 0409101, 0409115 and 0409302). Control is exercised in the daily mode, allows to learn about a problem in advance and to correct it till reporting period;
• The system of reports allowing to make the analysis of the report in any section and if necessary to unload data in any external format;
• The module of adjustments helping to enter lacking and to correct wrong data directly in the system of preparation of the reporting;
• The exhaustive documentation describing the solution, its settings and the instruction for work;
• Guarantee of support of changes of the legislation regarding the reporting.

Neoflex Reporting in the status Oracle Exadata Optimized

On October 30, 2015 the Neoflex company announced obtaining the status Oracle Exadata Optimized for the Neoflex Reporting system within the affiliate program of Oracle PartnerNetwork (OPN).

Assignment of this status means positive result of testing of Neoflex Reporting of version 5.7 for Oracle Exadata Database Machine that in itself is considered some kind of guarantee of maximum speed, scalability and reliability of a product.

The system of the bank reporting Neoflex Reporting represents the universal data warehouse providing high efficiency of formation of different types of the reporting: obligatory, managerial, IFRS, tax, internal, etc. Quick implementation of projects provides use of the ready Neoflex Reporting components:

• data models of universal bank (more than 200 business objects),
• the developed quality control system of data (more than 150 requests of quality),
• more than 250 ready report forms of the obligatory reporting
• other types of the reporting.

Neoflex Reporting operates on platforms Oracle Database 12c Oracle Solaris Oracle Linux Oracle Oracle Exadata Database Machine.

Neoflex Reporting is tested on amount of data from 60 million active transactions. Being unrolled on Oracle Exadata Database Machine the Neoflex Reporting system executed calculation of 105 data marts less than in 90 min. For a similar time span at the processor capacities recommended by Neoflex company there is a calculation for 300 thousand agreements — increase in productivity about 200 times.

"We are glad that Neoflex Reporting is recognized Oracle company the system ready to work on Oracle Exadata Database Machine. Among clients there is Neoflex the Russian and international banks, large and medium-sized by the size. Now we can propose to large financial institutions the innovative solutions of Neoflex company working with use of the highly effective database machine Oracle Exadata Database Machine" — Oleg Baranov, the managing partner of Neoflex noted.

2014

Forms of the Central Bank: 0409122, 0409126, 0409127

Reporting system of Neoflex Reporting was replenished with new forms of the Central Bank: 0409122, 0409126, 0409127, the functionality for calculation of standards for standards Basel 3, also in a system implements flexible configuration and the automated calculation of transfers for formation of the management reporting.

Module "Analysis of Sales of Retail Credit Products"

The Neoflex company developed the module "Analysis of Sales of Retail Credit Products" in composition of Neoflex Reporting. The module "Analysis of Sales of Retail Credit Products" of the Neoflex Reporting system is used for the end-to-end analysis of all process of retail lending: from consideration of the request and adoption of the credit solution before customer service and collecting of arrears. It allows to automate the analysis of the loan portfolio, business process, strategy of decision-making and statistics of sales.

Information core of the module is the credit request. The data which are contained in questionnaires of clients, answers of external sources (BKI, the systems of counteraction to fraud, etc.), the loan agreement and also results of consideration of the request are connected with it. The retail front office, the credit pipeline, decision making system, the core banking system and an arrear management system are the main sources of data for the module.

The module is the drawing solution with a boxed set of reports which can be implemented both as a part of Neoflex Reporting data warehouse, and irrespective of it, for one of the systems functioning in bank (the system of decision-making, the credit front office, the core banking system, a collection-system) or at once for several. At the same time integration into other modules is performed using a ready set of adapters to the most widespread systems. Solution advantages in speed of implementation (it takes about 3 months), flexibility, expansibility, a possibility of independent settings, existence of a subsystem of quality of data, high reliability and solution performance due to use of the industrial platform and also availability at the price. The module has an open architecture, and the possibility of creation of additional show-windows and reports and also expansions of structure of indicators of standard show-windows is provided by forces of employees of the bank in it.

Use of a subsystem of quality control of data of Neoflex Reporting promotes reduction of an implementation time. It is intended for check of correctness of the loaded and calculated data. Based on work of a subsystem the special reports allowing to reveal quickly form and to unambiguously identify the reasons of the arisen errors and inaccuracies of data. The allowed level of criticality is configured at implementation together with bank. Such opportunity allows to create operational reports with the acceptable quality level of data, without waiting for correction in the initial systems.

Structure of Neoflex Reporting

In the summer of 2014 became effective the changes concerning Instructions of the Central Bank of the Russian Federation of May 31, 2014 No. 3269-U i of December 03, 2013 No. 3129-U "About making changes in the Instruction of the Bank of Russia of November 12, 2009 No. 2332-U "About the list, forms and an order of drawing up and representation of forms of the reporting of credit institutions in the Central bank of the Russian Federation". According to them banks will be obliged to transfer new forms of the reporting in the Central Bank. Based on the analytical software package Neoflex Reporting solutions for automation of receiving required forms are developed:

• 0409122 "Measure calculation of short-term liquidity ("Basel III")";
• 0409126 "Data on the weighted average values of total cost of consumer loans (loans)";
• 0409127 of "Data on an interest rate risk".

Main advantage of implementation of separate reports is the possibility of fast closing of a task which is not excluding further development of the solution towards expansion of the list of forms of the obligatory reporting. Besides, the company guarantees maintenance of changes of the legislation within subscriber services.

Are a part of solutions:

• interfaces for data loading, for example, financial, sdelochny information according to loan agreements, planned transactions, the purposes and types of crediting and also agreements of providing for form 0409126 and information on main types of banking activities for form 0409127;
• user interfaces for thin setup of an algorithm of measure calculations;
• printed forms;
• working reports with a possibility of detailing of all indicators of the closing statement in any cuts and unloadings of results in the standard formats "CLICQUOT" and "PTK Design and Estimate Documentation", unloading is also provided in the MS Excel;
• standard settings for work of the report "by default".

2012

Business of modern bank is directly connected with need to process considerable information volumes. As in one financial institution there can be several tens of systems sources, even data collection becomes a difficult task. But data are not enough to be collected and consolidated – it is necessary to provide access to them to different categories of internal and external users, to provide the multilateral business analysis and acceptance on its basis of the weighed management decisions. The system of the automated bank analytics and the reporting created by Neoflex company allows to solve the listed problems.

For July, 2012 Neoflex Reporting in the form of the complete solution or separate components of a system is used more than in 20 financial institutions, including BNP Paribas, GE Money Bank, ING Bank, B&N Bank, Rusfinance Bank, National Reserve Bank, Sviaz-Bank, Khanty-Mansi bank, etc. The functional modules Neoflex Reporting allow to solve a broad spectrum of analytical tasks and also to automate formation obligatory, managerial, IFRS, client, risky and other types of the reporting.

Solution core – a specialized data model, and founders of Neoflex Reporting had a choice: develop own model from scratch or use practices of one of foreign vendors. Having carried out the analysis of the models presented at the market, specialists of Neoflex company decided to develop own product. "Models of foreign vendors have three features complicating their use, - Pavel Tsukanov, the top analyst of Neoflex explains the choice of the company. – First, they are not focused on the Russian accounting rules and requirements of regulators. Secondly, many foreign models were created as universal, and we needed the specialized model for banking business considering the Russian specifics. And, thirdly, universal models of the western development it is excessive are difficult – therefore implementation of the data warehouse takes not one year. Most of customers expect to receive result much quicker. Having weighed everything pros and cons, we decided to create own data model".

Basis of storage – reliable and expanded

The data model of Neoflex Reporting is based on classical methodology of creation of data warehouses according to which data are separated into three main areas: field of loading, area of detailed data and area of show-windows. The model was developed taking into account the Russian specifics, it with the maximum detailing displays the main objects and processes of banking activity – personal accounts, clients and the third parties on transactions of bank, wiring, the transaction and agreements, primary payment documents, reference books and many other things. In total more than 200 objects.

Thanks to convertibility of model the storage can be enriched with new objects or, on the contrary, to delete not used. To regulate such adjustments, the methodology of making changes is developed and in details documented. How it is possible to expand model and for what tasks such permission can be necessary? How to add new show-windows, unloadings, objects or attributes to already existing objects? What for this purpose need to be filled fields? How to connect a new system source to storage? How separate blocks of the reporting and analytics are connected among themselves and what types of the reporting essentially should not have such interdependence?

Thanks to the formalized methodology the bank user receives answers to all these questions, so, internal IT specialists can independently develop systems. "If to follow our recommendations, then we are sure that a system will save working capacity – will not occur, for example "explosion of data" when the volume of the loaded information begins to grow as avalanche, - Vasily Kuzmin, the area director "Bank analytics and the reporting" of Neoflex company comments. – The worked methodology plays a role of reliable protection against incorrect actions".

Besides, data are stored in Neoflex Reporting with support of historicity – there is a possibility of history logging of changes of objects and actually objects. Whether to store data on postings of ten-year prescription, depends only on the bank. If it is going to carry out the analysis of long-term trends, then such data will not be superfluous. On the other hand, for years of operation objects attributes of storage can change noticeably, the history of their changes it is also necessary to accumulate – otherwise data for last month and, for example, for 2005 can be incomparable.

For five years of existence of the Neoflex Reporting system the data model, this "skeleton" of storage, constantly develops from the project to the project. Facing new financial products and business challenges, specialists of Neoflex expand a system data model.

"There are areas of data which are used for contact management, for risk management and work with arrears. Not so long ago the model was replenished with specialized area of data on factoring transactions - this layer of information was specially created under the project which is successfully carried out by us to VTB Faktoring companies. There we automated accomplishment of three blocks of the tasks connected with the business analysis and a reporting preparation. The first block — the reporting on a status of a faktorinogovy portfolio in different analytical cuts. The second block — the reporting intended for efficiency analysis of the existing business processes. The third block – financial statements, the analysis of volumes and parameters of the issued financing. We are guided by the business challenges characteristic of a financial segment in general, and not just for classical banking activity though banks still remain our main customers", - Vasily Kuzmin designates a position of the company.

Quality control mechanisms: three levels of diagnostics

Quality checks exist on all processing stages of data. At the level of staging – it is engineering inspections, at the level of detailed data – checks of reliability and consistency, and at the level of show-windows – intra uniform and interuniform control, reconciliations of different types of the reporting with each other.

A system not only will automatically find an error, but also according to the level of its criticality will take necessary actions. The order of such actions contains in the unified register of checks. Algorithms a set, but in the most generalized view it is possible to speak about three methods which a system reacts to inaccuracies.

The most critical errors require the data processing termination. For example, if do not meet an asset with a liability within one day, then there is no sense to prepare data marts according to the obligatory reporting – reports will turn out incorrect, they will need to be created again. In this case data loading stops until the cause of error is found and removed.

The following level of criticality does not require a complete stop of processes. Let's say if a system finds an error in calculation of required reserves, it will not prevent to build the reporting under IFRS in which information on required reserves in principle is not involved in any way. However the fact of such error is registered and registered – it was possible to fix a problem later.

At last, a system can "doubt" whether really there was an introduced error. "For floating interest rates in banks usually there are boundary values, – Vasily Kuzmin gives an example. – Let's tell, there is a rule – the rate on a certain type of loan cannot change more than for 5% a month. But on the separate credits and clients of a rate can change with broader range. In this case a system notifies the user, and that can independently understand whether an exit for repartitions of normal range an error at a data entry stage in the operating system was, or such splash turned out to be consequence of objectively current situation".

The most numerous checks take place at the level of detailed data where the reliability and data consistency is checked. Neoflex Reporting includes a standard "album of checks" more than 500 automated kontroly, during their application the maximum number of business dependences is tested – only this way it is possible to guarantee that the data which are contained in storage truly reflect all aspects of activity of bank. At the same time checks have nonlinear character – they "are tied" not only to data sources, but also to the received types of the reporting and analytics.

The regularity for different "sets" of checks will be Razna also – is executed daily, weekly and monthly and in any mode – upon the demand of users. The last type of checks is most often applied at ad hoc requests – in this case a system can check that data set which the user selected for carrying out the analysis or preparation of the unique report.

Occasionally banks have a need to implement new checks in a system. For this purpose in Neoflex Reporting there is a specialized interface for management of checks using which specialists of bank can independently generate test actions.

The purpose – reliable analytics and the reporting

Competently built storage is some kind of uniform "center of the truth". Its main appointment – to form a reliable basis for the automated business analysis and reporting. These two tasks intercross, but at the same time do not match in the borders. For their solution two types of IT tools are provided in Neoflex Reporting: applications for the business analysis and modules for different types of the reporting.

The data warehouse – the most optimal base for business analysis IT tools, including for applications on planning and budgeting, the solutions data mining, systems for management of assets/liabilities, etc. "Means of the business analysis of different producers can be integrated into structure of Neoflex Reporting, but most often in this quality we use own developments – for example, the module "Analysis of Bank Risks", or products from a line of IBM: it is IBM Cognos BI, IBM Cognos TM1, IBM Cognos Planning, Cognos BI Scorecarding and IBM SPSS, - Vasily Kuzmin details. - Experience of our clients confirms that in banking sector demand for solutions for the business analysis increases every year. It is justified, competent application of BI-applications is capable to increase considerably efficiency of bank".

It should be noted that all seven modules of the reporting – tax, obligatory, managerial, IFRS, client, product, risky – are development of Neoflex. They can be implemented as separately, and in a complex. At the same time not in each case it is about need of full-scale construction of the data warehouse. Pavel Tsukanov comments: "Zachastuyu bank addresses us when in the organization several separate storages which appeared as tools for the solution of certain local tasks are already operated. When there is a need of complex automation of formation of analytics and the reporting, there is a question: what to do with the developed landscape? In such situations we carry always out the careful analysis of the existing architecture, and in some situations it turns out that already operating storages – at their certain completion – are suitable for the solution of assigned tasks. It is enough to configure their joint work and it is correct to install one or several modules of the reporting from those that are a part of Neoflex Reporting".

Really working storage sharply reduces labor input of formation of analytics and the reporting, and trust degree to data grows as influence of a human factor is reduced if not to zero, then to a minimum. The reporting becomes much more transparent not only for management of bank, but also for regulators. When checking the Central Bank auditors can request, for example, data on the currency transactions performed for the last ten days of August, 2008. From storage it is possible to receive instantly such detailing, including accounts, postings and parts of specific transactions.

"The Neoflex Reporting system is operated in absolutely different banks – corporate, retail, universal. Purposes and tasks of these projects very different. These are projects on automation of the obligatory reporting, such as in Rusfinance Banke, GE Money Bank, BNP Paribas, B&N Bank. This creation of solutions for automation of management accounting and financial statements, as in SDM-bank, National Reserve Bank or the Khanty-Mansi bank. And, at last, it is projects on creation of analytical solutions for business management, for example, in VTB Faktoring company, ING bank. Relying on this experience, we are ready to implement storages in banks practically of any scale, including geographically distributed financial institutions with a difficult IT landscape", – Elena Lukutina, the project director of Neoflex company summarizes.

2011: Functionality of a system

The functionality of a system gives possibilities of enrichment and quality control of data, allows to expand number of systems sources and structure of data, gives an opportunity to users quickly to develop new report forms without involvement of the company of the developer. The solution contains more than 200 preconfigured report forms and over 400 quality checks of data. In addition a system gives a connectivity of specialized analytical products of the third suppliers, expanding with that functionality of a system on planning, the analysis and control of activity of all directions of business of bank.