Home/Experience

Asset Management Intern

Oncor Electric Delivery

Data tooling for grid modernization: tracking distribution assets and ranking them by risk.

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.

Kyle and fellow Oncor interns standing outside Oncor Building F next to a lattice transmission tower during a substation visit
Visiting a substation with fellow Oncor interns
Kyle and fellow Oncor interns in hard hats and safety vests outside Oncor's Distribution Hub
Touring Oncor's Distribution Hub
Kyle and fellow UTA alumni interning at Oncor on an indoor pickleball court
Fellow UTA alumni interning at Oncor