Oil & Gas contractor

Data Analytics for an Oil & Gas contractor

HomeCasesOil & Gas contractor

Overview:

An Oil & Gas contractor needed to replace a heavy, manual workflow for extracting engineering tag numbers from a massive archive of technical PDFs.

Project in numbers

Industry: Oil & Gas
Location:Oslo, Norway
Time period:2023-2024

TEAM SIZE

1 FTE:Data analytics
0.5 FTE:Project Manager

KEY TECHNOLOGY

Core Language & Performance:Python 3.12, concurrent.futures
Document & PDF Parsing:PyMuPDF, Camelot
Image & Text Processing:Tesseract OCR, Pillow
Data Manipulation & Export:pandas, openpyxl

01Challenge

The customer is an Oil & Gas contracting company. They have accumulated a large number of PDF documents with various technical data. Engineering tag numbers had to be extracted from these documents. The initial solution was rather heavy and required much manual effort.

02Solution

Our Data Analyst has helped the customer develop an end-to-end pipeline to automate the extraction. This solution ensures accurate identification of tag references and their association with corresponding documents and predefined actions.

03Results

Partnering with CodeIT Innovation gave Oil & Gas contractor measurable gains through a cohesive delivery model:

Execution Time: Multiprocessing + optimized OCR significantly reduced runtime
Architecture: Modularized for better scalability and maintainability
Tag Accuracy: Improved with advanced matching, expansion logic
Output Quality: Structured Excel with hyperlinks and tag traceability
Maintainability: Easier debugging, extensions, and collaboration
1. Introduced new modular architecture
3. Added intelligent tag recognition
4. Improved excel output

Do you have a different challenge?

Get a free expert advice from us

Collaboration AI Assistant

Answers based on our experience and solved cases