EndorsedendorsedOngoing

SQL Equipment-Tracking Application for Oil & Gas Company

Services Covered:

Custom Software Development • Application Integration • Software Maintenance and Support
Project hero — replace with case study imagery
Industry
Industry

Energy & Natural Resources

Duration
Durationinfo-circle

18 months

Budget
Budget

200K - 999K

Start Date
Start Date

1 June 2016

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
73/100
Good

Project Capability Score (PCS) estimates how capable Makeen Technologies is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

Confidential

map United States of America

Project Summary

Makeen Technologies migrated a high-volume Excel-based equipment tracker to a SQL database and built an internal application with a friendlier UI for an oil and gas company's pumping services. They interfaced the application with the client’s N4 and WellView truth databases, used an agile approach with user-story-driven sprints, and continue to provide ongoing maintenance and enhancements. Stakeholders reported increased trust in the vendor due to quality delivery and responsive collaboration.

Key Challenges

  • Existing Excel spreadsheet lost data and froze under high usage
  • Large volume of data compromised the tool’s integrity
  • Need to convert the spreadsheet to a SQL database with a friendlier UI

Project Deliverables

  • SQL-based equipment tracking application
  • Integration with N4 and WellView databases
  • Improved user interface for internal users
  • 3-4 rounds of enhancements and iterative releases
  • Ongoing maintenance and support contract

Project Solution

Makeen Technologies supplemented the client's internal team, performed initial analysis in mid-2016 using an agile approach, and developed an internal SQL-based equipment tracker. They integrated the application with the client's N4 and WellView databases to feed real-time data, conducted requirements gathering via a lead analyst, implemented sprints for build and testing, and completed multiple rounds of enhancements. The tool runs on the client's servers and Makeen provides ongoing maintenance and support under a contract.

Project Outcome

  • Stakeholders gained trust in Makeen Technologies due to quality work and collaboration
  • Consistently high quality and efficiency in deliveries
  • Lead analyst/project manager provided quick turnarounds and effective project management
  • Prompt correction of issues, with accountability for mistakes

Platforms

  • CloudCloud

Tech Stack

  • SQLSQL

Client Endorsement

Overall Review Rating

4.75star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

Expertise and project management garnered positive user feedback, earning trust among stakeholders. The deliverables’ quality reflected a deep understanding of unique technical environment specifications. Although mistakes occurred, quick corrections resolved issues with full accountability.

Anonymous

Lead Project Manager

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Makeen Technologies

Endorsed
Ongoing
Arts, Entertainment & Recreation

React Native & Electron App Development for Entertainment Group

Preview of the React Native & Electron App Development for Entertainment Group
Budget:
1M - 10M
Duration:
6 months
Team Size:
21-25

Services Covered:

+5 more