Itron OpenWay Smart Grid Diagnostics to Streamline Workflows

Improved reliability of 2M+ AMI meters for Itron at SDG&E Sempra Energy streamlining service workflows end-to-end.

Client
ChallengeTroubleshooting 2M+ smart meters across electric and gas infrastructure
ResultReduced diagnostic delays and improved meter servicing efficiency
TagsOracle, .NET, JavaScript & TS, Public, Energy & Transport

Itron, a leader in AMI and smart grid solutions, contracted TaylorMade Software to assist SDG&E with complex diagnostics on over 2 million electric and gas smart meters deployed throughout San Diego and Orange County. Our work spanned embedded systems, RF communication, GIS mapping, and enterprise IT systems.

The troubleshooting process involved querying and analyzing meter health using advanced SQL in both Oracle and SQL Server. We integrated RF LAN sniffing tools and Zigbee diagnostics to isolate network communication failures. GIS-based visualization tools were enhanced to overlay outage and fault patterns geographically, significantly improving field crew dispatch efficiency.

We also built internal utilities using C# and .NET to automate diagnostics, interrogate endpoints, and correlate device-level telemetry with backend WCF services and data warehouse analytics. The combined result was a streamlined diagnostics workflow from embedded meter firmware to blade server endpoints, recognized by Itron and SDG&E management as pivotal to system-wide reliability improvements.

Related Case Studies

HD Supply - A Snowflake Case Study Highlighting Security, Governance and Compliance via RBAC Automation

Snowflake enterprise roadmap for RBAC, governance, disaster recovery, and SOX compliance

Tags: Snowflake, Big Data, GCP, Energy & Transport

Building a Snowflake Pipeline for Citi

Self-service Snowflake automation portal with GitOps provisioning and onboarding workflows

Tags: Snowflake, AWS, Big Data, Financial, Java

Freddie Mac - Snowflake Snowpipe and Governance Case Study

Snowflake governance and CI/CD modernization with iData no-code pipeline, SSO security, and role-based integration on AWS

Tags: Snowflake, AWS, Java, Python & AI, Big Data, Financial, Public

American Airlines - A Case Study in Snowflake Data Lake Modernization

Automated Snowflake RBAC, workspace provisioning, and lifecycle management for enterprise users

Tags: Snowflake, Big Data, Azure, Python & AI, Energy & Transport

Worldpay - A FinOps Case Study with Snowflake Tableau

Snowflake Tableau cost monitoring system with chargebacks and business unit allocation

Tags: Snowflake, AWS, Java, Big Data, Financial

GE Digital Ghost - Embedded IoT & Kibana Analytics

Stabilized GE's Digital Ghost C++ system and built custom Kibana React plugins for real-time Elasticsearch data access and advanced analytics

Tags: Big Data, JavaScript & TS, C++ & Embedded, Public, Energy & Transport