Oil & Gas contractor

Document Cleaning Automation

HomeCasesOil & Gas contractor

[SOFTWARE DEVELOPMENT]

Overview:

Manual document cleaning was error-prone, with subjective interpretation leading to data inconsistencies.

Project in numbers

Industry: Construction and installation in O&G
Location: Bergen, Norway
Time period: 2024

Team size

Business analyst: 25% FTE
Senior Developer: 75% FTE

Tech stack

Python
Pandas
Openpyxl
Domain-specific rule modules

01Challenge

High Error Susceptibility: The reliance on an entirely manual document-cleaning workflow significantly increased the likelihood of operational mistakes.
Labor-Intensive Execution: Requiring human intervention for every single cleaning and standardization step created a slow and inefficient process.
Output Inconsistencies: A lack of automated, uniform rules led to varying results, as multiple operators applied their own subjective interpretations to the data.

The customer had a manual document-cleaning workflow with an increased risk of errors. All cleaning and standardization steps were performed manually. Inconsistencies occurred due to subjective interpretation by multiple operators.

02Solution

What we delivered

Improved data automation: Scripts auto-filled fields using predefined vocabularies stored in a local database.
Introduced domain-specific logic: Embedded rules handled edge cases and special scenarios using configurable Python logic.
Added SOP cheat sheet: A documented procedure outlined each step, ensuring consistency across operators.

The workflow was fully automated to streamline data preparation and ensure consistent application of domain rules.

03Results

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

Faster processing of document batches
Reduced manual error rates
Consistent application of business logic
Easier onboarding and process handover

Do you have a different challenge?

Get a free expert advice from us

Collaboration AI Assistant

Answers based on our experience and solved cases