Custom ERP for Oil & Gas Company
Client
Aristek has developed an ERP system for a major oil transportation company that owns about 3000 km of pipelines and pumps over 63 million tons of oil per year. The functionality of the system to cover everything from storing petroleum product and transportation to accounting and client relations management.
- Duration: 24+ months in total
- Industry: Oil & Gas
Challenge
The managers understood that to keep up with (and get ahead of) the competition, they needed to make their work more efficient. Automating paper-based processes, uniting the disparate electronic elements into one system, and streamlining the decisionmaking process could be a huge step in the right direction. They just needed a reliable technical partner to make this a reality.
When the project began, the customers already had a desktop system. Some of its functions would be transferred into a new one. However, it was outdated and lacked many of the needed features. They had to be built from scratch.
Overall, this was to be a massive project that would require a lot of separate modules to work in perfect unison.
Solution
We developed a system that allowed the customer to control the entire operation from one place. This included both the technical aspects and the financial ones.
A large part of the system was interoperable with the software that the company’s customers and contractors used. This helped make the work more convenient and more efficient.
Examples of the modules we developed included:
Oil Pumping
Monitoring the amount, pressure, and other important data. Visualizing it for the operators’ convenience.
Finance
Conducting the payments in automatic mode, managing client and contractor relations, tracking exchange rates, and integrating with other financial software used by the customer.
Accounting
Managing customs clearance and connected to the client and contractor systems.
Loss Control
Predicting losses, alerting if the losses exceeds the projections at a specific point in the pipeline, managing the inventory in the tank farms, and more.
Loading
Optimizing logistics by predicting the time it would take to load a specific tanker or train.
Chemical Laboratory
Monitoring the characteristics of oil (water and salt levels, mechanical impurities, etc.).
The ERP also included a powerful analytical system with over 500 possible reports for use at every level of the company. Thanks to the flexible access control module, the system could be accessed by the employees of the customer or their partners. In addition, the data was thoroughly encrypted to add an extra layer of security.
Tools & Technologies
- PHP
- JavaScript
- jQuery
- AJAX
- SQL
- PL/ SQL
- JAVA
- ORACLE DB Server
Team
Our team structure for ASKID ERP development:
Business Analyst
UX/ UI Designer
Back-end Developers
Front-end Developers
QA Engineers
Project Manager
Results
The ERP turned out to be a resounding success. It led to a 30% increase in overall productivity.
- 30%productivity increase
- 500possible reports generated