OMM - IMS

Oilfield Material Management provide an extensive range of downhole drilling tools for rental to the oil & gas industry worldwide. Largely consisting of drill collars, stabilizers, hole openers, roller reamers, various subs, tubing and drillpipe, their drilling equipment has assisted many drilling companies and operators in meeting their objectives.

NEED

OMM had a manual system that they used to track their rental tools based on spreadsheets and paper printouts. In 2004, OMM approached Codify to replace this with custom software that would resolve four main issues.

Firstly, the amount of information that needed to be processed was in excess of 2000 transactions a day. The sheer scale of this meant it was almost impossible to keep up with administration and to trace a tools location. Secondly, the speed of processing the transactions was a burden as data had to be manually duplicated into different areas. For example, the shipping out of a tool alone required information to be duplicated into 12 different areas. The third reason was the scope for human error. Due to the high level of duplication, it was easy for errors to occur. For example, if a user entered the wrong serial number this would cause problems between departments and potentially with customs control. Finally, some clients were not being invoiced or being invoiced incorrectly due to lost or inaccurate information passed between the departments.

SOLUTION

As the data is now stored in a central database it has removed the need to duplicate information which has saved time and reduced the possibility of administrative error. OMM can now have instant access to their data which has brought benefits to both OMM and their customers as Irene Holden, Director explains, "IMS has allowed us to provide our clients with a faster turnaround for their orders. In addition, if a customer rings with an urgent requirement we can check availability whilst they are on the phone and quickly reassure them that a specific tool is available."

An audit trail gives OMM 100% traceability of all the transactions that take place in IMS. This gives OMM's management the ability to monitor the team to make sure their staff perform as expected and ensure they are providing the high level of service that their clients expect.

BENEFITS

IMS has allowed OMM to maximise the utilisation of the rental fleet through reports that can be generated from IMS such as highlighting where there are equipment shortages or surplus. OMM also use reports to allow them to monitor the business and to highlight where any inefficiency is occurring, such as the time taken to repair equipment at their facilities.

Furthermore, the invoicing module has sped up the invoicing process. OMM used to print out the delivery tickets and type them into a spreadsheet to create an invoice. IMS now generates the invoices so there is no need to type them out manually saving time, preventing human error and lowering administrative costs.

OMM look forward to continuing their relationship with Codify as Irene explains, "Right from the first meeting we felt Codify understood our requirements and our business even though they had not done any similar projects at the time. Although Codify have grown a lot since we first met them, and they are continuing to grow, you feel that you can speak to anyone there and they know our system and understand our business. In fact, I can still access the original team who started the project in 2004. IMS is a brilliant tool which has improved the efficiency and quality of our business and this has been recognised by our clients. I wish Codify continued success for the future and I look forward to continuing to work with them and expanding IMS into new areas."

Technology Used

  • .NET 3.5
  • Windows Forms
  • SQL Server 2005
  • Reporting Services
  • Analysis Services

And I Quote...

"IMS has allowed us to provide clients with a faster turnaround for their orders."
Irene Holden Director, OMM