Like many utilities navigating ongoing modernization efforts, the client engaged HEXstream to better manage its work, assets, and workforce. The proposed single platform solution would benefit both the organization's Electricity Transmission & Distribution division and its Natural Gas Transmission & Distribution division.
HEXstream partnered with industry-leading field service implementer Group7 Consulting.
Using Oracle Integration Cloud (OIC) to integrate data from Maximo, Oracle Field Service (OFS), Cornerstone, and ESRI GIS, HEXstream helped the utility reduce manual, paper-based processes and automate timecard processing.
About the Client
Natural Gas and Electricity divisions of a publicly-traded Canadian engineering, logistics, and energy holding company
Over 1 million natural gas customers
Over 200,000 electricity customers
What We Built
OFS Integration with Maximo
The utility sought a cloud-based mobile work force management solution to improve how the business managed its assets, work, and workforce. The implemented scheduling and dispatching tool leveraged the Enterprise Asset Management system (IBM Maximo) as the key integration point with Oracle Field Service for asset tracking and field activity information. In addition, the application leveraged data from Cornerstone for competency and resource skill data to improve routing and dispatching, also providing users with links into the ESRI GIS system to provide relevant additional data.
The real-time bidirectional flow of data between Oracle Field Service and Maximo relied on OIC. The newly-automated real-time integration brought together Maximo's scheduling capabilities and OFS's field resource data. This included integration with Oracle Autonomous Data Warehouse (OADW) and customizations within OIC.
Custom Reports & Dashboards
With all the data coming together, HEXstream gained the ability to provide the client with real-time insights into their transactional information rather than just sharing batch data at the end of each day. Further, this has helped the client analyze and identify trends in their resource usage in various conditions.
Through this partnership, HEXstream and Group7 Consulting have helped the client utility lay the foundation for ongoing dashboard & analytics development. By continually refining data operations and making data available throughout the organization, the client stands to derive more value from its data than ever before.
How can we help your utility manage and analyze data more effectively? Ask the utilities analytics experts!