Gazprom Neft Planning and Reporting Automation Project at Oracle Hyperion Planning

At the end of 2015, LANIT completed the first stage of the implementation of the planning and reporting system of the Gazprom Neft group of companies. The information system is based on Oracle Hyperion Planning.

Gazprom Neft has been implementing a large-scale project to create a planning and reporting system (SPO) since 2013. The goals of the project include migration to a high-performance platform, Oracle EPM the creation of a single information space for business planning and the formation of management reporting of the group and units, the transition to a single set of reference books in the preparation of management reporting and reporting on. IFRS Previously, business planning and management reporting processes were carried out on the basis of a software product (Microsoft Performance Point Server MSPP).

The project queues cover such areas of automation as macro parameters, profit and loss indicators, natural indicators, technical and economic indicators; procedures for factor analysis of planned, forecast and actual values ​ ​ of EBITDA, operating expenses; indicators of cash flow statements and management balance sheet.

The design and implementation of the first stage are completed, the design of the second stage of the project is nearing completion.

Specialists from the LANIT Management and Consulting Department (since 2015, the department has become part of the Consyst Business Group) were involved in the project at the stage of implementation of the first stage of the system in March 2014. The project executor has been cooperating with Oracle Corporation for more than 15 years. He has the status of a platinum partner of Oracle and specialization in Oracle Hyperion Planning in creating solutions for the oil and gas industry.

The SPO collects input data from the operating units, calculates the financial result in the context of all levels of the Gazprom Neft business structure, reconciles and eliminates intra-group turnover (from the level of operating units to the level of business areas and group of companies) and consolidates the reporting.

The planning and reporting system is integrated into the landscape of corporate information systems, automated information exchange with systems based on SAP BW software is configured.

During the project, special attention was paid to user training. Consultants conducted trainings on the system for ten groups of students. Since at the beginning of the pilot operation of the SPO, management reporting was formed in the system on the basis of MSPP, the phase of transition to work in the new system was carried out in a short time to avoid unnecessary burden on the specialists of the customer's economic services.

The system generates a business plan for the following years and prepares management reports for several reporting periods. SPO has been put into commercial operation. Despite the large amount of data processed, the system allows you to prepare the group's consolidated statements and Gazprom Neft's business plans/forecasts in a short time.

The implementation of the SPO allowed us to significantly improve the efficiency of the management reporting process, speed up the receipt of information and improve its quality, as well as be able to quickly recalculate the business plan when changing macro parameters. Within the framework of the project, we solved many related tasks: we unified the business perimeter of the company group, improved the process of reconciling intra-group turnover and calculating financial indicators on intermediate elements of the hierarchy, including calculating unrealized profits in product balances, set up new reporting forms from the system directly to Excel, and created a control panel for the information collection process for reporting. Alexey Urusov, Director of Gazprom Neft's Economic and Corporate Planning Directory '