As a rule, enterprise companies in the oil exploration and production field have many established processes that get more complicated over the years and become hard to manage manually. One of our clients decided to optimize the oil equipment construction with the help of a system that would help shift the workload from the employees and eliminate the possibility of a human error.
Our client is a prominent oil exploration and production company that offers specialized custom pumps for oil extraction to its own clients and partners. Companies that want to order the equipment submit a special form filled with information and details on the machinery they need: its expected power, all measurements, and multiple other parameters. Our client, in turn, constructs an offer that is based on tens of thousands catalogues that contain exhaustive information of all the parts they have available.
Previously this task was solved by an Excel file with several dozen dictionaries that helped navigate through the enormous pool of information on equipment parts. The process had a number of downsides:
We did not have a formal specification for this project, only an understanding of what had to be done. We dived deep into the complex formulas and elaborate calculations our client employed in their Excel table, and wrote a detailed specification after an extensive research.
The system we developed for the automated and optimized offer construction requires some entry parameters to be specified by companies that wish to obtain a piece of equipment. After this information is received, it is parsed into an easy-to-read table. Then the system goes through all catalogues, using calculation formulas, and builds the piece of equipment using the cheaper option available. When this is done, the system compiles a comprehensive equipment specification in an Excel format. If some parts were not found, they are marked so that employees can fill them in later manually.
Here’s what changed in the process:
It was a challenging and complex project where we had to immerse ourselves into the process we were asked to automate. We gained a lot of experience and can’t wait to see more enterprises optimizing their routine for more productive and effective business process.