Energotransbank (ATI Pro: BI.Qube)

2014: Development of a tool for analyzing portfolios, products, customers, sales networks, liquidity

Task

The task was to develop a tool for analyzing portfolios, products, customers, sales networks, liquidity. In the situation of the presence of a large number of heterogeneous data sources, we form a Single Truth Center, including the construction of a management balance and a GPO, the systematization of methods for analyzing fin portfolios . instruments, loans, deposits, cards, accounts, securities. Construction of the Payment Calendar, Funding Matrix. Collection of part of regulated reporting, control of standards, data uploading to NBCH and DIA. Non-system accounting of directories, parameters and relationships for clients and contracts to ensure a complete picture in management reports. Initially, the task was to form management reporting - the management balance sheet and OPU, deposit and loan portfolios, as well as the allocation of fins. result on customers, divisions, and products. In the stage of implementation of the task of calculating about 100 different KPIs for: balance sheet indicators; business lines; products; units. In particular, a plan-factual analysis has been implemented to compare the calculated and enter planned KPIs.

Features

Combining data from heterogeneous sources on accounts, documents, customers, contracts, products, CSA, etc.; collection of management reports as a whole (management balance sheet, GPO, client analytics, portfolios on financial instruments, payment calendar) and integration with the portal to provide reports to management.

Management Analytics

Group 1 - daily report for the Management Board and product owners:

• Lending: balances for each day, in dynamics, in terms of products, interest income;
• Deposits - term and on demand by type, number, channels, expenses;
• Commission business: income in the context of offices, sellers, products (RKO, acquiring, transfers without opening an account, safe deposit boxes,...);
• Occupancy of safe cells;
• Coins - number of sold, income;
• Cards: number and commission income by systems, by type, by card product, by Yule/FL, analysis of additional services;
• Self-service devices: cash movement, services;
• Securities: quantity and income;
• Currency exchange transactions: object by currency pairs.

Group 2 - Financial Result Statements (P&L).

Group 3 - Actual Calculation for a Plan-Based Analysis in Oracle Hyperion.

Technologies: active use of analytical data stores BI.Qube for off-system accounting on the MD platform; maintaining reference books, posting products to business lines, linking contracts to responsible departments, etc. Connection of sources: UBS (UniSab); SQL Server DBMS; RBS (CFT); Synthetics and analytics data consolidation Oracle DBMS.