Ambition
Williams Energy, a 116-year-old leader in energy infrastructure based in Tulsa, Oklahoma, United States, handles one-third of the natural gas used daily for cooking, heating homes, and generating electricity. Their legacy is etched in pipelines that crisscross the nation, fuelling progress and prosperity.
Williams sought to disrupt the energy Industry by creating the first certified gas marketplace with a gas certification process to encompass the end-to-end supply chain: from production through transmission and delivery. Participants share emissions data throughout the value chain with the certification agency, Context Labs.
The Decarbonization-as-a-Service™ platform will enable Context Labs’ partners in upstream, midstream and downstream firms to track and quantify emissions associated with natural gas procurement, transmission, and delivery down to the individual molecule.
Achieving this ambitious goal involves ingesting and analyzing vast amount of complex time series data from proprietary systems like FlowCal, Maximo, and Pi which house critical data of transmission, emissions etc.
Action
Wipro collaborated with Williams to design and implement the solution using capabilities of the Databricks Data Intelligence Platform. The design followed the industry standard Databricks Medallion Architecture for Data refinement, which was sourced from various systems, including PI. The data was stored in Delta format. While Wipro ensured governance and security of the data through Unity Catalog, the data pipeline orchestration was implemented through Azure Data Factory.
Wipro successfully tackled complex data engineering challenges by developing a PI Asset Framework (AF) for the NextGen use case, enabling seamless querying of data through PI AF using a linked server. Wipro leveraged Delta Share from Databricks for delivering data to Context Labs, while also provides necessary access tokens to the third party, in less than 48 hours which was a significant achievement. From complex data engineering to pioneering Delta Share and AI-driven tag consistency, Wipro’s solutions paved the way for NextGen Gas.
Ambitions Realized
The collaboration between Wipro and Williams Energy has yielded remarkable achievements, particularly in sustainability and commercial success. Williams Energy has realized an impressive $6M increase in margin from additional volume and secured new next-gen gas contracts in 2023.