Investment project management

The project is aimed at automating the collection, aggregation and control of production and economic indicators of investment projects in an oil and gas company

Order a project

Oil and gas industry
2018-2024 year

Client

Investment planning department in a vertically integrated oil company.

The main activity of the department is aimed at performing a full cycle of investment planning. The calculation of an investment project requires the participation of several departments.

The methodology for conducting the functional business process “Investment planning” includes

Problem

To consolidate data, subsequently process it and perform calculations, employees used Excel – manually configured macros, complex formulas and reports compiled in a free, unregulated form.

The main problems of the Customer were:

The presence of ineffective investments
Lack of centralized tools for assessing investment efficiency
Lack of transparency in the calculations of departments, related services and departments that were used in preparing the data; calculations were made locally in separate files
Lack of automation and standardization of processes, high labor costs for the process

The planning tools available to the Customer have become ineffective in terms of speed and quality of data processing: complexity of data collection, errors and loss of data during calculations, complexity of processing large volumes of data, high-level data at the output
Lack of a suitable ready-made solution on the market that could meet the Customer's needs

Tasks

Key objectives of the project

01.

To improve the efficiency of investments in production projects.

02.

Improve the quality, speed and accuracy of calculations.

03.

Set up cross-functional interaction.

04.

Improve the timeliness and quality of decision making.

05.

Automate routine tasks.

06.

Optimize business processes.

07.

Create a single database.

Technologies

Client

HTML5, CSS3, Angular

Server

.NET Core, WebSockets

Data

PostgresPro, Hadoop, Spark, Parquet

Solution

Comprehensive optimization and automation of investment management activities: automated data collection and automatic reporting, calculation of economic efficiency of projects, analysis and visualization of results, examination and decision-making on projects, integration with related systems
Possibility of managing investment projects at all stages of the life cycle: from the emergence of an idea to post-investment monitoring
A single and intuitive space for departmental collaboration, a transparent and flexible role model

Automation of information exchange with accounting systems of technological indicators and cost accounting systems has been carried out:

- Automatic loading of actual costs and production indicators from external accounting systems at the monitoring stage;
- Fast and regular updating of data;
- Reliability of the data obtained;
- Obtaining planned data, both forecast and actual;
- Flexible configuration of obtaining actual costs.

A single space has been created for joint work of departments participating in each stage of the life cycle of investment projects:

- Quick viewing of information;
- Displaying information received from services and related systems in one place;
- Providing access to employees, experts and company management;
- Storing historical data.

A tool for automating procedures for examination and approval of investment projects has been developed:

- Modular planning of investment projects. Modules: well, cluster, field, license area;
- Loading data from configured templates;
- Coordination of data provided by subordinate units and downloaded from related systems;
- Recording the history of provision and approval of data on an investment project;
- Getting through the data approval stage with the heads of departments.

A system for automatic calculation of economic efficiency and reporting has been prepared:

- Mathematical calculations of performance indicators according to scenarios: changes in macroparameters (oil and gas prices, discounting and inflation dates, etc.), use of different methods (calculation for the project as a whole, well-by-well calculation);
- Formation of a passport in the form of a multi-page report with graphs and tables with the ability to export to Excel;
- Creation of various reports in terms of the project, project portfolio, subsidiary and the company as a whole;
- Generation of a report on monitoring the main indicators of the active portfolio.

The amount of time resources required to collect and coordinate data has been reduced:

- Reduction of time resources for the formation of a project portfolio;
- Conducting project examination and monitoring both by individual experts and by the department;
- Possibility of project approval and monitoring;
- Add comments to projects and portfolio in real time;
- Automatic sending of notifications.

The system has a convenient graphical data output for visual tracking of all investment project indicators.

Project results

I want the same

The implementation of the project led to a significant improvement in investment project management processes in a vertically integrated oil and gas company.

Result of implementation

Effects

by 12%

increased investment efficiency

10 times

the speed of calculating indicators has increased

by 2 times

reduced the time for planning processes

Other projects in the industry

Apply

We are ready to answer all your questions.

Investment project management

Client

Problem

Tasks

Key objectives of the project

To improve the efficiency of investments in production projects.