Overview
Oncor runs one of the largest distribution grids in the U.S. On the asset management team, I built tools that help decide which equipment to inspect and replace first.
The problem
A distribution grid is made up of a huge number of individual assets spread across a large service area. Grid modernization means deciding where inspection and replacement money goes first, and that decision is only as good as the data behind it. Asset management needs one place to see what is in the field and a consistent way to compare one asset's risk against another's.
What I did
- Asset tracking system. I worked with cross-functional teams across the company to build a SQL-based tracking system for asset management and grid modernization work.
- Risk score. I used statistical analysis to model a risk score in SQL that ranks distribution assets for inspection and replacement, so the riskiest equipment rises to the top of the list.
Connection to my earlier work
The summer before, at POWER Engineers, I designed distribution circuits for Oncor projects. At Oncor I saw the other side of the same grid: once equipment is in service, how the utility tracks it and decides what to replace.
The intern class
Besides project work, the internship included site visits to see the grid up close.

