On-site workshop with software audit in the oil & gas company

  • 3,000

    3,000 new deals per year can be automated
  • 5

    5 days it took to prepare the final document
  • UI

    Alternative frontend/UI recommended

Project overview

SubC Partner is a Danish company focused on offshore works in the oil and energy industry. This team had an internal project control system based on Microsoft Access and SQL. We organized a two-day on-site workshop with one core goal: identify how this system can be upgraded and improved.

Client information

SubC Partner is a global service and product provider for the offshore energy industry. It delivers cost-effective solutions to decrease the energy price, reduce weight and cost of systems, keeping their quality high. Products and services include engineering, manufacturing, construction, installation, repair, and maintenance of various oil & gas systems, vessels, rigs, etc.

on site workshop wth software audit in the oil and gas compony logo
on site workshop wth software audit in the oil and gas compony project overview

Business challenge

The main goal of SubC Partner was to identify the best solution with all the required features, user-friendly interfaces, and high efficiency. Existing system required employees to handle many project management tasks manually. As a result, the processes were time-consuming and inefficient.

Technical challenges

The existing software version required optimization. It relied on the Microsoft Access-generated module that let users access the solution. However, this module didn’t provide the required functionality levels. Some documents were missing, as well. Hence, we had to analyze internal processes, check how employees work and how we can improve their experience.

Audit areas

Project Management

After discussions with two SubC Partner PMs, we found that the main tasks were focused on client management. They used several tools, including Outlook and local files for management. The general PM flow included many operations with PDF forms, Outlook folders, and Excel spreadsheets.
on site workshop wth software audit in the oil and gas compony audit 1


To work with files and the related tech aspects, engineers utilized SQL Server Management Studio, C5, and Nova but not Excel. Core functional modules could be optimized via API settings. Time-tracking was done via the internal tool. We found that automation was one of potential improvement areas.
on site workshop wth software audit in the oil and gas compony audit 2


QA engineers used all the mentioned tools in their workflows. The process divided into many manual steps, from log sheet creation to weld testing to Access database transferring. This department also controlled documentation management through the dedicated Outlook mailbox.
on site workshop wth software audit in the oil and gas compony audit 3

Project Controlling

Finally, invoicing and reporting processes could be optimized, too. Project controllers work with Microsoft Dynamics C5 and Excel files, mainly. All data transfers between these systems and specific changes required personal attention of employees, as well. On top of that, it was possible to add a few more general documents for better process understanding.
on site workshop wth software audit in the oil and gas compony audit 4

Audit results

After a preliminary agreement, we collaborated with our client to organize a two-day workshop in Denmark. During it, our team mapped the product features, identified business gaps, use cases, and priorities. We also documented the existing software and estimated further activities.
The most essential wishes were as follows, according to our investigation:
  • Automation can help a lot. This feature and effective data processing were among the most valuable opportunities.
  • Microsoft services and, specifically, Microsoft Azure Cloud security levels were highly desired for improvements.
  • Project managers couldn’t work directly with Microsoft Dynamics C5. It was required to connect several modules to improve process flows.
  • There was a room for production resource planning optimization. The previous software versions included this feature, and we could add it again.

Value to our client

  • 5 days it took to present the final document

    A two-day on-site workshop helped us to understand the client. During the next three days, we analyzed all the info and prepared the specification document.

  • Alternative frontend/UI recommended

    Even before the workshop, we suggested developing a new solution with the existing SQL elements. After the workshop, our ideas were proven.

  • Software specification document prepared

    After this analysis, we outlined core specifications of the proposed custom software solution. Thanks to enterprise process audit, our client got the most tailored and accurate offer.

  • The proposed solution could help with automation

    Our audit results showed that the company can automate up to 3,000 new deals per year. It means that the software can process them much quicker and more efficiently.

Our tech stack

  • DOKIT-Nova DOKIT Nova
  • Microsoft-Access Microsoft Access
  • Microsoft-Dynamics-C5 Microsoft Dynamics C5
  • Microsoft-Excel Microsoft Excel

Software solutions bringing business values

6 reviews
47 reviews

    Contact us

    100% data privacy guarantee

    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447


    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7


    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław


    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands


    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien


    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344


    +4366475535405 Vatslava Havela Boulevard, 4,