Case StudiesGas and Electric Utilities Case Studies Data Quality ManagementPipeline Integrity

Operator Qualifications Analysis

Celerity’s client, a large East-coast public utility, was ordered by regulators to report on the extent to which its employees and contractors had experienced lapses in the qualifications required to perform utility maintenance, inspection, and construction work. 

Strategy for Training Records Data Set Identification

Celerity worked with counsel and subject matter experts to identify and gather 18 sets of data, in varying formats, that constituted 14 years of training records related to 22 different training courses and examinations. Considering the varying certification periods and the elaborate rules that established how the courses interacted with one another (e.g., prerequisites, changing curricula, etc.), Celerity’s data analysis team developed SQL-based queries to analyze each individual’s qualifications and report on any potential lapses. 

Results: Compliance Report for Utility’s Governing Regulatory Agency

Our findings were reported to the utility’s governing regulatory agency. They were also used to identify specific jobs and projects at risk for non-compliance. Our efforts enabled our client to accurately identify its potential exposure and develop its necessary regulatory defense.

About Celerity

Celerity is an agile risk optimization company that helps public utility organizations convert complex data into clear, actionable intelligence to mitigate risk, optimize assets, and maximize project results.

Want to learn more? Contact us below

This field is for validation purposes and should be left unchanged.


Walnut Creek
Los Angeles
San Diego