Customers: Unicredit Leasing Moscow; Financial services, investments and audit Contractors: FB Consult, Navicon Product: QlikViewProject date: 2017/02 - 2018/01
Project's budget: 1000000 rubles руб.
Number of licenses: 10
|
Content |
The project team from the customer | Integrator Consultant |
Okhrimenko Andrey Viktorovich (Chief financial officer (CFO)) Shcheglova Elena (Expert of Department of planning and control)
|
Konkov Ivan (Consultant) Popova Yulia (Systems analyst)
|
2014
At the end of March, 2014 Unicredit Leasing, one of the largest players in the market of the Russian leasing entering into the leading European banking group UniCredit completed the implementation of the complete solution on market risk continuing about 4 months. The solution meaning daily creation of the reporting and its operational analysis for successful management of a risk position of the leasing company is already actively used by her employees.
The help in the choice and implementation of this project was rendered to us by the FB Consult company specializing in implementation of the analytical BI systems and also full-function CRM solutions. FB Consult is a partner of QlikTech BI company.
2017: Project Development
On August 8, 2017 the Navicon company announced upgrade of a system of analytics of QlikView in Unicredit Leasing company.
Project objective - optimization of work of the QlikView BI platform. Specialists of the contractor optimized an installed system so that processes of primary loading of the application in RAM, updates of a data model and reporting took place for business users quicker and more simply, and did not depend on the number of active users in a system.
The significant growth of number of transactions and the leasing portfolio of Unicredit Leasing which happened for the last year imposes requirements both to quality of data, and by the time of creation of the analytical reporting. The BI solution of QlikView adapted by Navicon company to requirements of our business in an available form shows business 'picture' on one screen, i.e. allows to have always the finger on the pulse and to notice even the slightest deviations in indicators of separate departments and the organization in general. Andrey Okhrimenko, chief financial officer of Unicredit Leasing |
The convenience of work with a business intelligence in the companies depends not only on product quality, but also on ability of the system integrator to correctly implement and configure it in the company. Even the most convenient BI system will not bring to business of essential benefits if the user has to wait long for a response to a request or a system often shows errors because of poor executed implementation. Maria Averina, Head of Department of integration services and complete solutions of Navicon company |
The created technology helps to process any data of the company, regardless of their location or a format and to find in them unevident patterns at the expense of mechanisms of the associative analysis.
The ETL tools allow to clean information from the different accounting systems, excepting duplication and errors in it and to consolidate data in uniform storage.
2018
The system integrator and Navicon developer expanded possibilities of the analytical QlikView tools in Unicredit Leasing company. As a result of project completion of analytics the customer had an opportunity to create itemized statements on income and expenses in one click. The optimized functionality allows to deepen detailing of data and also to repeatedly reduce time spent for creation of reports.
Cooperation of Navicon and Unicredit Leasing companies began in 2017 when expansion of the leasing portfolio of the company demanded quality improvement of operation of analytical IT tools. Specialists of Navicon were invited for setup and optimization of the BI system intended for analytics of income on the QlikView platform. They carried out automation of collection of information from tens of IT systems and also developed algorithms of data and associative data analysis. Thus, the staff of Unicredit Leasing received flexible tools for the analysis of revenues in the loss and gain statement of the company.
In 7 months of work, since August, 2017, specialists of Navicon carried out the detailed analysis of sources of data on expenses and careful completion of existing application of QlikView. The difficult, multistage mechanism of expense allocation on so-called "profit centers" of the company was as a result implemented and the general model of analytics of income and expenses is constructed. According to the results of end of two projects of analytics of Unicredit Leasing got access to the complete and detailed information on all company with dynamic monitoring and permanent updating of data.