Case study

CLIENT MC-07099

***

Rod services & inventory management in a single tool

Open field: rod lift consulting

Rod Services And Inventory Management Platform
AI SOLUTIONS + ENGINEERING

The problem

Our client (a rod services company acquired by Schlumberger) has long been encumbered with fragmented spreadsheets and a ton of valuable data that hasn’t been used effectively. The entire process is tedious, time consuming, and is held as domain knowledge by a single employee. The entire workflow is prone to error and requires an excessive amount of redundant data entry. Ultimately, our client was bottlenecked by an old-school process, which hindered its potential of servicing more clients and pursuing more value-based work.

Our solution

Our team took a design-centric approach in tackling this problem. We designed a tool that took paper-based, manual processes and digitized them in a way that streamlines the entire rod servicing process, creating a pool of accurate data in the process. We also helped standardize our client’s operational processes by helping them reduce their reliance on spreadsheets in favor of a real-time database, eliminating nearly 50% of manual tasks in the process. Additionally, we built the product as customer-facing, so their customers could log in and view their inventory and place orders in real-time, whenever they wanted. Our goal was to empower RLC to tackle more value-based tasks, service more customers, and scale geographically without being bottlenecked by an old-school, conservative process.

PROBLEM ANALYSIS

Problem analysis

Consulting

Design

Engineering

Our team redesigned the entire rod management program with the intent of consolidating all data in a centralized way. We embedded each step (either spreadsheet based or paper based) of the rod management workflow inside the application and opened it up to our client’s customers to ensure that key fields are auto-populated without the need of human input. Our idea was to help our client save time on redundant data entry, while giving real-time insights to their customers when they needed it.

Hypergiant

OUR SOLUTION & APPROACH

 

OUR SOLUTION & APPROACH

RLC’s dashboard is a view of the most important metrics for each of their customers. In this case, it was the total number of guided and slick rods by size, the number of trucks out for inspection, and the location that the inspection took place. Once clicked, RLC could dive deeper into the customer’s inventory and complete the applicable form requirements within that customer account.

RLC’s customers would also get visibility into their inventory in real-time. Their password protected account would allow them to view inventory, their order history, and easily manage their communication with RLC within the application. Additionally, customers would be able to place new orders and download the required documentation in the application easily.

Technological change is never an isolated phenomenon. This revolution takes place inside a complex ecosystem which comprises business, governmental and societal dimensions. To make a country fit for the new type of innovation-driven competition, the whole ecosystem has to be considered.

Klaus schwab
Founder & executive chairman
WORLD ECONOMIC forum