Metcombank (Kamensk-Uralsky) (iT Pro: BI.Qube)

2016: Construction of analytical CD and multidimensional data mart

The individual solution involves the construction of analytical CD a multidimensional showcase. data The filling of planned and non-system data is implemented in, Microsoft MDS SQL Server Analysis Services and SQL Server Integration Services are used.

Customers get

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.

Realized

Deployment of storefronts by accounts and turnover. Deployment of specialized storefronts for complex financial instruments - loans, securities, plastic cards Collection of part of regulated reporting, control of standards. Data unloading to NBCH and DIA. Non-system accounting of directories, key parameters and relationships for clients and contracts to ensure a complete picture in management reports. Implementation of a part of regulated reports and standards - N6/N7, Appendices 1-6 of the FORA, OBM, OVT and O, etc. Implementation of functionality for the formation of management reports on the banking group. Develop DWH migration to the Windows Azure cloud to reduce cost of ownership. Analytical Data Warehouse combining information from geographically and organizationally distributed heterogeneous sources by customers, contracts, accounts, documents, products.

Creation of data marts for transactions, accounts and turnover. Collection of management reports for the bank as a whole (management balance sheet, OPU, client analytics, fin portfolios . instruments, payment calendar). Deployment of specialized storefronts on complex financial instruments - loans, securities, plastic cards. Preparation of data for individual units of regulated reporting, control of standards. Ability to upload data to NBCH and DIA. Non-system accounting of directories, key parameters and relationships for clients and contracts to ensure a complete picture in management reports. Formation of consolidated management statements for the banking group, including in the form of interactive Power BI charts.

Management Analytics:

• Management Balance Sheet;
• Management P&L;
• Fin portfolios. instruments, loans, deposits, cards, paid settlement accounts, securities;
• Payment calendar.

Reporting for Regulator:

• FORE, 102 f.;
• Standards N6, N7, О, ОВМ, ОТТ;
• Register of depositors for DIA;

Unloading to PSD CAS.

Technologies

Construction of analytical CD, multivariate data mart.

Connection of sources

RS-Bank v.6 (Core, RS-Retail RS-Loans ,),; Oracle DBMS ETO (), TranzWare CompassPlus Oracle DBMS; Diasoft Treasury, ; DBMS MS SQL Server Front office system (ELMA as well as data upload to ELMA); Geographically remote, ABS Bank 21 Century Oracle DBMS; Other sources, including for DB private purposes and; MS Excel Integration with the portal. MS SharePoint