Oil & Gas ERP
All-in-one ERP Solution for Oilfield Service Company with a Field Force Companion App
Short summary
Client: Global oilfield service company
Need: To build a custom ERP solution
Challenge: The client wanted to change the approach in managing business processes and get the long-term solution within customized software as none of the off-the-shelf solutions comprehensively addressed all their needs and requirements.
Solution: EXISTEK had provided the cross-functional dedicated team to be involved in the full-cycle software development. Our team helped to deliver the cutting-edge ERP software and a mobile companion application.
Impact: The assigned developers managed to get quickly acquainted with the specification of ERP software for the oilfield industry and roll out the required solution in a timely manner and with all required functionality.
Location
Technologies
MS SQL
azure
java
.NET
dotNetNuke
Team size
Duration
Users have been satisfied with each solution, giving reason to expand the original scope of the engagement. Existek meets deadlines and communicates daily. The developers are committed and resolve problems quickly when they arise. They never say “no” and always deliver above expectataions.
What’s the ERP solution for?
The custom Oil & Gas ERP helps one of the largest global oilfield service companies to perform everyday tasks faster, better, and more efficiently. While integrated with all the organization services, the provided solution allowed the customer to achieve significant increments in various areas and resulted in better business performance.
ERP software
The development team has delivered the fully-functional web ERP solution while focusing on the core functionality required for the oilfield service company. It helped to gain increased visibility, enhance analytics and build business efficiency.
Field force companion app
Besides, the team has come with the idea of developing the field force companion application to allocate tasks, optimize work orders and search assets.
Core features
The implemented ERP solution integrates required functionality into one unified system to streamline processes across the entire business unit. The main requirement was to address most specific operational processes and identify new options for improving the oil and gas industry activities.
ERP Software
Order tracking module
The core functionality that supports the creation and management of work orders for different assets and locations. It provides a broad overview of order service activity, product, and budget planning. The dashboard helps structure such data as user activity, RFID assets, repairs, and work order reporting.
Reporting module
Effective reporting handles timely data processing, operational issue identification, and improved decision-making. The module compiles such data as incoming reports, various types of statistics, inspection results, rotating hours, etc.
Repair module
The essential module to maintain repairs and component replacements. It covers the entire process from assigning the repair to completing the order, whereas administrators get the overview and check the detailed statistics.
Logistic module
The oilfield industry requires quality management of the supply chain. Besides, it usually needs to cover coordination in different locations worldwide. This module deals with inventory, storage, packing lists, asset movements.
QMS Module
The quality management system focuses on compliance enforcement and high-quality production. It supports continuous advancements as it gains insight into various processes and independently identifies new areas for improvement in each location.
Admin data module
Launching the admin module enables managing factual data for the oilfield services. It allows collecting, processing, viewing, or analyzing data on orders, customers, business areas, report changelogs, localization, etc.
HR module
Human resource management focuses on hiring, developing, and retaining the right talent in each location. It gets the organization to align human resources strategically while meeting the outlined business goals and needs.
Field force companion app
The application increases the productivity of the field force team and enables better operation processing. With the adoption of the RFID (Radio-frequency identification ) technology, the mobile solution focuses on supporting rapid and accurate identification and inventory management. The field force companion app is designed to streamline work orders, manage inventory, pair RFID items, search and relocate assets. Being integrated with the ERP software enables efficient processing of daily operations and supports a connected workforce.
Discovery stage
Project objective
Challenges
- Improve business processes
- Streamline reporting and analytics
- Utilize the real-time data for asset optimization
- Gain better visibility of field operations
- Higher management performance
Solution
Collected requirements
- Business process management
- Data consolidation to the digital forms
- Strategic reporting
- Asset optimization
- Scalable and flexible solution
Discovery stage
- Assigned the dedicated business analysts
- Involved the technical lead and the data architect to conduct the comprehensive research
- Discovery meetings with the client’s team
- 160+ hours to produce documentation
Deliverables
- The Software Requirements Specification (SRS) document
- System Architecture and Database Design documents
- The detailed development plan
- The project’s timeline and engagement model
- The dedicated development team with required expertise
SRS Document Contents
- Project scope
- Product features
- User roles
- Assumptions and dependencies
- Functional requirements
- External interface requirements
- Nonfunctional requirements
Oil & Gas ERP structure
Development and testing
Technology choice
The development team looked for the right set of technologies as the key to attaining primary project objectives. EXISTEK has conducted comprehensive research to identify technologies that enable adapting long-lasting workflows and operations within the custom Oil and Gas ERP solution.
Backend
Microsoft SQL
azure
29%
MS SQL takes the 5th place among commonly used databases
31%
Azure is the 3rd widely used cloud platform
ERP Frontend
.NET
dotNetNuke
37%
.NET framework gets the most love among professional developers
1M+
members of the DNN community
Mobile
java
35%
Java takes the 5th place among commonly used programming languages
9M
developers in the Java community worldwide
Development tools
jira
slack
65K+
Jira customers worldwilde
600K
companies around the world use Slack
Technologies used by
How we ensure visibility for the client
It’s one of the fundamental principles for EXISTEK’s team to get our customers fully involved in the development process. We use the best market practices to establish direct and effective communication on both sides. It ensures closer collaboration, supports the mindset of continuous improvement, and enables quality software implementation.
Dedicated team composition
The dedicated development approach was a perfect match for this project collaboration. Our client was interested in a wide range of technical expertise and the ability to scale the team according to rising requirements. They started with 4 developers and later extended the team to 10 dedicated specialists.
The dedicated team model is chosen for transparency of the development process and efficient project management. The client gets access to task tracking, directs the development process, and adjusts it to the rising needs. As for EXISTEK, we take responsibility for project management, performance improvement, and high-quality software implementation.
Assigned specialists
Backend developer
Frontend developer
Android developer
Backend developer
Frontend developer
QA engineer
Backend developer
Frontend developer
QA engineer
Project manager
Project summary
EXISTEK’s dedicated development team helped the customer roll out custom ERP software in due time and with all planned functionality. The results of digital tools implementation were quick and impressive. Information consolidation and organization in the legible form increased the number and quality of operations over time. Data standardization enabled the oilfield service company to generate reports and analytics to screen the performance of territory units and avoid potential obstacles. It also helped speed up routine activities, like payrolls, improved customer experience, health, safety, and environment management. Besides, the team created the field force companion app to simplify daily workflows and increase business productivity.
85%
Custom Oil and Gas ERP software development
15%
Field force companion app development
85%
Custom Oil and Gas ERP software development
Oil and Gas ERP software modules:
- Order tracking
- Reporting
- Repair
- Logistic
- HMS
- QMS
- Admin data
- HR
15%
Field force companion app development
Field force companion app features:
- Work Orders
- Inventory
- Pair RFID item
- Packing list
- Search assets
- Length report
Highlights
Our locations
Warsaw, Poland, 00-645
Bucharest, Romania, 011663
Vinnytsia, Ukraine, 21021
