Practical experience of use of BI in VTB Insurance

Premises of implementation of BI

Purposes of implementation of BI

Creation of analytical service

• Uniform source of analytical information, distribution of knowledge
• Maximum scope of data and data domain
• High automation

Performance

• High speed of calculations
• The limited time of ETL
• Separation of functionality of the accounting and reporting systems

Consolidation of data of the IC

• Use of all necessary sources

Available development

• Self-Service
• Costs and speed of development and deployment

Control of data

• Separation of information streams

Zone of interests of BI

Main sources and data streams

BI project blocks

Development of basic financial statements

• Reports for FD
• Reports for sellers
• Reports for actuaries and underwriters

Management reporting

• Reports for the management
• Data of reports of the closed accounting bases

Distribution of RVD

• Reports on not insurance expenses
• General result of division

Specialized financial models

• PL
• Awarding, labor costs
• Reserves

Customer intelligence

Block 1. Basic reporting

Analysis of Products application

Measurements

• Analytical quantum – boom. wiring, Dogovor-objekt-risk.
• Units – managerial analysts, branches, Lines of business.
• Analytics of the insurance contract.
• Dates of the financial facts.

Indicators

• GPW, GPC.
• AB.
• Returns, Termination.
• Quantitative facts.
• ZP, RNP.
• ZU,RZU, VV.
• Unprofitability.
• Triangles of losses.

Block 2. Management reporting

Managerial Report application

• The principle of creation – accumulation of the delta on GPW between the closed periods.
• Transfer of volumes between divisions at change of organizational structure.
• Is a data warehouse source on GPW.
• Dashboards for the management.

Measurements

• Analytical quantum Dogovor-objekt-risk.
• Units – managerial analysts, branches, Lines of business.
• Analytics of the insurance contract.
• Dates of cuts of the closed bases.

Indicators (RAS + IFRS)

• GPW, GPC.
• AB.
• Plan fact, forecasts.

Block 3. RVD

Analysis of RVD application

Analysis of Products application

Goal

• Carry out allocation of costs on lines of business and divisions.
• Information on RVD – the most operational, and more than once in a month.
• General view on insurance result and not insurance costs.

Result

• The separate application for the detailed analysis of distribution.
• Daily updating of calculation.
• Distribution error control.
• Flexible logic and scenarios of distribution.
• Aggregated distributions it is integrated into the Analysis of Products application.

Block 4. Specialized financial. models

PL is expansion to model of the basic financial reporting

• Calculation of RNP, RZU, DAC (IFRS/RAS). Both data of calculations in 1C, and calculations for a data model are used.
• Detailing – from the agreement to segments.
• As data source – the Analysis of Products application and data of registers of calculation of 1C.
• The block of calculation of awards, AV, losses on reinsurance, calculation of shares of Re in reserves.
• Unloading of the fact in Hyperion.

Labor costs

• Calculation of costs for data entry, regulation and expense allocation.

Awarding model

• Calculation of a financial result of the specific seller.
• Separate accounting of motivation on PCB.
• Accounting of prolongations and transfer of volumes between divisions.
• Implementation of logic of calculation of awarding depending on result of sales.

Block 5. Customer analysis

Goal

• Consideration of insurance processes by the client.

Result

• Financial result of the client.
• Accounting of communications the client – a system source.
• Distribution error control.
• Notifications to clients.
• Uniform information with financial models.

Analytics of QlikView for the operational block

"To the operational QlikView block helps to increase quality of control of data: together with consultants of ATC we put into operation model on processing of malformed data which will recognize more than 100 types of the errors connected with operational input in the accounting systems. Specifics of the companies with a big branch network - a long cycle of work with agreements, since their receiving from primary selling divisions, finishing with diversity of payments and a binding of payments on them, processing of additional agreements. Now operational management will have in QlikView the tool for control of a cycle of the agreement, the analysis and process optimization" Yazykov Alexander, the chief specialist of department of financial systems.

Together with the product NPrinting and communications systems we configured preparation of reports for automatic client mailing by e-mail and the SMS. In the automatic mode we send reminders on prolongation of agreements and the forthcoming payments and also we generate lists of call-down of clients for call center.

On start of the QlikView project integrated a number of data sources, including the main accounting system 1S:USK to which we were connected through ATC of QlikView of 1C of the Connector.

Results

For business

• High speed of work with traditional reports.
• Essentially new reporting in terms of volumes and a scope of data, complexity of algorithms.
• Consolidation of these all ICs.
• "High-precision calculations" with attraction of new data sources, the increased sampling.
• Possibility of the detailed analysis.
• Uniform source of the truth.

For IT

• Output of reporting loading from US.
• Easy way of obtaining information.
• Flexible mechanism of development.
• Self-Service.
• One iznemnogy tools for transaction with Big Data.

Specific Features

For business

• Change of a picture of times a day
• Limitation of an object model

For IT

• Self-Service
• Assembly time of models
• Permanent process of optimization
• Performance requires resources

Development of the platform