Download PDF
Franks International
Technology Category
- Analytics & Modeling - Predictive Analytics
- Functional Applications - Enterprise Resource Planning Systems (ERP)
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Oil & Gas
Applicable Functions
- Business Operation
Services
- Software Design & Engineering Services
- System Integration
The Challenge
Frank’s International was using legacy systems for financial reporting and budgeting. The solution was not designed to handle financial consolidations, currency translation, or complex ownership structures. So, there were a lot of manual steps involved in the process leading to inefficiencies. The data warehouse system was bogged down by complex data transformations, with no data validation rules. Planning was being done directly in the ledger, and ad hoc reporting was very limited. Having recently completed an IPO, the company realized it needed to reduce risk and implement new processes and systems, so in 2016 they began evaluating corporate performance management (CPM) solutions.
About The Customer
Frank’s International (NYSE: FI) is an industry-leading global provider of highly engineered tubular services, tubular fabrication, and specialty well construction and well intervention solutions to the oil and gas industry. They provide services to leading exploration and production companies in both offshore and onshore environments, with a focus on complex and technically demanding wells. With approximately $500M in revenue, they are one of the largest global providers of tubular services to the oil and gas industry.
The Solution
Frank’s International initially focused their OneStream implementation on financial consolidation and reporting. Their design was complex with lots of intercompany activity (and accounts), complex holding structures, related party transactions and non-controlling interests, and significant international revenue and FX exposure. The solution was implemented on-time and under-budget. It provided enhanced validation and error-checking, better reporting and visibility and was rolled out globally. The stakeholders were happy and immediately began requesting more data be loaded into the system. Immediately upon going live with OneStream in January 2017, the Frank’s team began working on planning and forecasting. Leveraging the financial model by inheriting and extending dimensions already in use for consolidation and reporting, they were able to deliver a barebones forecasting solution in 30 days. Then three months later, they delivered the full planning solution that included an 18-month rolling forecast.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Taking Oil and Gas Exploration to the Next Level
DownUnder GeoSolutions (DUG) wanted to increase computing performance by 5 to 10 times to improve seismic processing. The solution must build on current architecture software investments without sacrificing existing software and scale computing without scaling IT infrastructure costs.
Case Study
Remote Wellhead Monitoring
Each wellhead was equipped with various sensors and meters that needed to be monitored and controlled from a central HMI, often miles away from the assets in the field. Redundant solar and wind generators were installed at each wellhead to support the electrical needs of the pumpstations, temperature meters, cameras, and cellular modules. In addition to asset management and remote control capabilities, data logging for remote surveillance and alarm notifications was a key demand from the customer. Terra Ferma’s solution needed to be power efficient, reliable, and capable of supporting high-bandwidth data-feeds. They needed a multi-link cellular connection to a central server that sustained reliable and redundant monitoring and control of flow meters, temperature sensors, power supply, and event-logging; including video and image files. This open-standard network needed to interface with the existing SCADA and proprietary network management software.
Case Study
Refinery Saves Over $700,000 with Smart Wireless
One of the largest petroleum refineries in the world is equipped to refine various types of crude oil and manufacture various grades of fuel from motor gasoline to Aviation Turbine Fuel. Due to wear and tear, eight hydrogen valves in each refinery were leaking, and each cost $1800 per ton of hydrogen vented. The plant also had leakage on nearly 30 flare control hydrocarbon valves. The refinery wanted a continuous, online monitoring system that could catch leaks early, minimize hydrogen and hydrocarbon production losses, and improve safety for maintenance.