O&G Major Saves Millions of Dollars by Implementing Reporting Automation for Real-time Insights
The oil and gas (O&G) industry operates in a highly dynamic and complex landscape with fluctuating market demands, stringent regulatory requirements, and significant operational challenges. Reporting automation can play a crucial role in this industry. It streamlines data collection, analysis, and reporting processes, reducing the time and effort required for manual tasks. This helps O&G companies capture market trends as well as achieve regulatory compliance and faster decision-making. The result is improved operational efficiency and cost savings.
Client Brief
Our client, one of the largest publicly traded oil and gas companies, did not have a clear picture of their key performance indicators (KPIs) because they lacked an effective way to gather data and develop business metrics. This caused challenges in comparing the business performance of their units across regions. The client needed a robust solution to strengthen their decision-making ability by gathering meaningful data through a real-time, granular, and singular view of their operations.
Challenges
The client had to produce almost 1000 daily, weekly, and monthly reports across departments such as revenue management, pricing, and marketing. The team had to work through a series of manual, time-consuming, and error-prone processes involving dependency on multiple teams for the extraction of data and its manual consolidation. This led to errors, particularly with disparate data sources such as SAP-HANA, SAP-UI, and SQL, premature or missed updates to the product list, lack of insight into key business metrics, and absence of single source of truth for supply chain managers, business managers, and product owners.
Infosys Solution
Infosys developed a unique solution by scoping the skills needed and created the “Tool as a Service” billing model. We had the capability to provide the required talent at short notice as the team was skilled in Alteryx, Tableau, SQL, MSBI, Micro Automation, Power Query, Tableau Server, MS Access, and Power BI.
As part of the solution delivered using the agile methodology, the Infosys team identified data sources and designed a data flow mechanism to ensure accurate and convenient access to information. We developed Alteryx workflows with HANA and SQL data sources, built formulas and logic into the workflow to get the final prices, and created layouts in the workflow for all required files.
The team implemented multiple forms for users to view customer data, update/delete information, and download results in MS-Excel. A tableau-based data lake was built to analyze structured and unstructured data with tabular and graphical charts to help compare data across categories for low-level and high-level insights. Interactive dashboards provide real-time insights, allowing the client to analyze past performance across LOBs, strategize, and identify areas of concern and growth areas.
Business Benefits
Infosys leveraged its team’s extensive experience and expertise across various tools and technologies to deliver several key business benefits to enhance the client’s decision-making abilities. This includes expenditure analytics to help plan and allocate budgets, customer buying behavior analytics to plan financial assistance payments, analysis of underperforming contracts, and KPI and SLA analysis from all ticketing platforms to help the client track ageing tickets and take appropriate action.
Marketing Investment Tool (MIT)
This tool provides insights on key business metrics such as rebates, accrual calculations, settlements, underperforming contracts, budget tracking, financial assistance payments, customer growth, and retention of business. This led to business enablement and savings to the tune of US $4.7 million.
Global Reliability Management System (GRMS) Dashboard
GRMS provides a single source of truth to track product availability, events (planned and unplanned), and impact of events to monitor terminal performance and provide solutions to improve performance. With this, the client can save about 4000 hours of effort and US $16.2 million per year.
Aviation and Marine (A&M) Partner Channel Pricing
This tool calculates the price of each product sold across 14 ports globally. It can process factors such as transportation cost, freight cost, inbound costs, raw prices of the product, and calculate the final price of each product. A&M automatically extracts data from SAP HANA and generates monthly reports capturing current prices and costs with significant savings.
