Engineering Data Integration & Validation

Context: Xcel Energy · Transmission Modeling
Period: 2025–2026 · Engineering-data workflows
Focus: Data Engineering
Tools / methods: Python · Databricks · industrial data concepts

Engineering question

Power-system models, measurement systems, and engineering reference tables serve different purposes. Joining them requires careful treatment of identifiers, timestamps, units, and expected data quality.

My work

  • Worked with engineering datasets used to support transmission model checking.
  • Supported data reconciliation and repeatable preprocessing workflows.
  • Explored ways to make comparison and validation results easier for engineers to interpret.

Technical approach

A robust pipeline validates schema, normalizes units, checks temporal alignment, and treats unmatched or stale records as first-class review results. Reference-data consistency should be examined separately from physical model validity.

Engineering considerations

Operational measurements and static planning models need not correspond to the same operating state. Apparent disagreement can arise from time alignment or reference-model differences rather than sensor malfunction.

Evidence and maturity

Engineering-data analysis and validation contributions; not a claim of a deployed real-time control system.

Public scope

No plant tag, internal endpoint, operational timeseries, authentication detail, or source database is shown.

Shivam Vashishtha
Shivam Vashishtha
Engineer

Electrical Engineering and Computer Science student working across power, AI, energy systems, and emerging technologies.