ExxonMobil Upstream IT leads with expertise and collaboration on Power Platform wins
This article originally appeared in MSDynamicsWorld.
Microsoft often promotes Power Platform for its vast utility. And while nearly everyone in an organization – from a non-technical line of business worker to professional developers – can build applications, process flows, chatbots, integrations and dashboards with these services, each organization must weigh their options for how exactly to make Power Platform a part of their IT landscape.
When ExxonMobil Upstream IT prepared for a new development effort that would rely on Power Platform, they pledged to deliver complex, high-value solutions quickly, to do it primarily with centrally-managed IT processes and developers rather than citizen developers across the business, and to make their delivery team – Avanade and Accenture – equal members.
The work by ExxonMobil Upstream IT since 2020 has at times pushed the limits on Power Platform services, both in terms of usage and advanced development requirements. Huy Tran, ExxonMobil Upstream IT product manager, and Sacha Abinader, managing director for Accenture North America Energy, spoke with MSDW about some of their experiences and observations related to ExxonMobil’s IT-driven investment, including their professional-grade Power Platform practice and how the team can continue to adapt in a corporate context.
Designing solutions with users at the center
An area of attention for ExxonMobil teams in the field was the shift handover. While shift handovers are a known point of higher risks for both safety and equipment damage as a new crew begins work, taking over from the old crew, methods for tracking these daily interactions had become inefficient, inconsistent, and outdated, ranging from paper and spreadsheets to massive OneNote notebooks and manual entry of data into a series of legacy systems.
“By continuously striving to enforce effective communication, and sustainable processes, we strengthen people and equipment safety, while enabling effective learnings,” Tran said about the practices and techniques from crews around the world.
To bring handover data out of multiple systems and give on-site teams a consistent, reliable toolset, the ExxonMobil Upstream IT team looked to Azure Data Explorer and its high frequency data connector to capture facility equipment status at the time of handovers. Their Digital Shift Handover (DSH) solution brought external data together with Dataverse data in Power Apps for both DSH users and administrators. Power Automate flows generated handover-related PDFs and log attachments for historical records.
With DSH, users manage checklists and answer questions in a consistent way. It was also built to be flexible and secure by allowing different types of teams to use the app with the questions they need to see. Administrators can set up the right questions through a configuration table and avoid case-specific coding.
“ExxonMobil Upstream IT very consciously went with a user-centered design approach and worked directly with teams in Operations to help design and think through how this would all work out,” says Sacha Abinader. “And then, based off those designs, our teams looked at how to implement the application from a technical perspective, focusing on leveraging reusable components and limited customizations while staying true to the design. Our guiding principles were to have the users’ needs in mind while balancing scalability and limiting support and maintenance needs.”
DSH has provided tangible ROI for the company that totals in the hundreds of thousands of dollars in reduced downtime, productivity gains, and safety incident prevention. The application has helped crews navigate over ten thousand handovers among hundreds of operators and counting.
Re-usability at scale
One of the challenges that Tran and his team wanted to address with their Power Platform development efforts was to create evergreen digital products, or to give products as long a life as possible with the right business conditions. The company tends to run applications a long time if they can, Tran says.
“While the Power Platform is being continuously updated, improved, and enhanced, we focus on protecting and capturing additional value through deploying to more users and enhancing product features with new offerings from the technology over time as long as the benefit to technology cost stays attractive.”
Another Power Platform-based solution at the company, the Enterprise Annual Maintenance Plan, or AMP, was the team’s first real success with scaling a Power App. AMP provides a central workspace and common repository for teams to do risk-based work selection with a zero-based budget development approach. The new app aimed to improve an existing process that required managers, business team leads, and planners to work for hours with enormously complex Excel files that pulled in equipment maintenance data from dozens of company sites. With AMP, that equipment maintenance data flows through an Azure Data Factory Pipeline and is then accessed via Dataverse to serve AMP users and admins. Management can monitor activity via business intelligence dashboards, while automated reviews and calculation processes run as Power Automate flows. The application is being deployed and used across ExxonMobil manufacturing sites around the world.
As it was developed, AMP aimed to use longer and more resource-intensive flows than what Microsoft had previously allowed for, says Tran.
“We ran into throttling limits, [which is when] the number of steps in the Power Automate flows exceed an enterprise limitation. We had to work with Microsoft to [figure out if we could] increase that limitation to include more steps or work together to optimize the flows in a way that doesn't require [as many] steps,” he explained.
When the ExxonMobil team built the first version of AMP a few years ago, they could not yet give engineers the ability to edit data in it with Excel Online, which was a key requirement. Microsoft did deliver the updated Excel Online capabilities, which helped build confidence from both IT teams and the business, says Tran. Gaining that improvement helped the team move on to other wins with their apps as they improved the user interface, brought in embedded Power BI reports, and built out model-driven apps.
“All that information is fed back to Microsoft on how we can work together to improve the platform,” said Tran.
Reusability of technical components has helped the team deliver solutions with work that incorporates tools and services like Azure Data Exchange, Azure DevOps and GitHub in the development team, and Power Platform Managed Environments.
A skilled development team supported by centralized governance
ExxonMobil have invested in a dedicated Low Code Center of Excellence team that is responsible for enforcing ExxonMobil IT policies in areas like data loss prevention, cyber security, apps development techniques, and deployment framework. There are also tech-savvy teams across the businesses, a.k.a. citizen developers, and the ExxonMobil Upstream IT team and the ExxonMobil IT Central Low Code CoE are also partnering to support them on Power Platform-related efforts in some cases. Tran’s team currently has 17 people including developers, product owners, and business analysts. The team has “plenty of backlog” and they plan to hire several more skilled team members in the next year to tackle enhancements and new solutions.
Relating to their collaborators as equal members of the ExxonMobil Upstream IT team also required a shift in thinking, Tran explained.
“In the past, when we [at ExxonMobil] have worked with a vendor or another company, we tended to be the biggest voice in the room. But for this kind of engagement, we truly are empowering the team and fostering a collaborative culture. We are working as one team,” he said. “All of the developers coming from Accenture and Avanade have access as an equal team member with our business customers inside ExxonMobil.”
As a product manager, Tran expects his team will need to justify the business value as they go, especially if they want to bring apps to more users.
““For now, our job is focusing on proving values, focusing on scaling the product to more business units and users for wider adoption in the future since we have already built a robust foundation,” he said. “We already know what to do in terms of how to get these things done, how to solve these requirements.”
Embrace the low-code revolution with Microsoft Power Platform to accelerate innovation, drive agility and efficiency and create business value.
Want to talk to an expert?
Headquarters
North America
1191 Second Avenue
Suite 100
Seattle, WA 98101
Europe
30 Fenchurch Street
London
EC3M 3BD
Growth Markets
Avanade Asia Pte Ltd
250 North Bridge Road
#30-03 Raffles City Tower
Singapore 179101