Like many utilities, our client is undertaking multiple modernization efforts – in this case seeking to better manage assets, work, and its workforce. Our client was using two disparate systems: Work Order Management in Maximo and Crew Management in Oracle Field Service (OFS) which needed to be brought together to have a 360 view of the problem and resolution.
The old process was to open a work order in Maximo and provide that to the crew. However, the crew assignments were taking place in OFS, where activities and final resolutions were logged. Posting updates back to Maximo was a manual activity that took place as the final step in the process. The customer was looking to integrate the two systems to have data flow back and forth in real time and to automate updates.
HEXstream proposed a solution that utilized Oracle Integration Cloud (OIC) to integrate data from Maximo, OFS, Cornerstone resource management, and ESRI GIS. The solution provided better, more accurate information and helped the utility reduce multiple manual, paper-based processes between systems and the customer can see the status of each step of the process in Maximo The utility was also able to automate timecard processing.
What We Built
OFS Integration with Maximo
The utility sought a cloud-based mobile workforce management solution to improve how the business managed its assets, work, and workforce. The newly implemented Oracle Field Service scheduling and dispatching tool incorporated IBM Maximo, the client’s enterprise asset management system, as the key integration point for asset tracking and field activity information. In addition, the application incorporated data from Cornerstone for competency and resource skill data to improve routing and dispatching, and it provided users with links to the ESRI GIS system to provide additional relevant data.
The real-time bidirectional flow of data between Oracle Field Service and Maximo relied on OIC. This included integration with Oracle Autonomous Data Warehouse (OADW) and customizations within OIC. The newly automated real-time integration brought together Maximo's scheduling capabilities and OFS's field resource data to provide more comprehensive information than was previously available.
Custom Reports & Dashboards
With all the data coming together, HEXstream could now provide the client with real-time insights into their transactional information rather than just sharing batch data at the end of each day. This has helped the client analyze and identify trends in their resource usage in various conditions.
HEXstream partnered with industry-leading field service implementer Group7 Consulting on this project. 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.
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
How can we help your utility manage and analyze data more effectively? Ask the utility analytics experts!