Project/Program Name: Bergen-Linden Corridor
Description: Build a 345kV transmission system running from PSE&G’s Bergen Switching Station in Ridgefield, NJ to its Linden Switching Station in Linden, NJ; remove legacy 138kV lattice towers and conductors.
Project Owner: Public Service Electric & Gas (PSE&G)
Stakeholder Agencies/Departments: PSE&G Delivery Projects & Construction, Burns & MacDonnell
Involvement: Project Controls - accruals, forecasts, Primavera Contract Management, Primavera P6; Access database administration; Excel PowerQuery administration (as consultant to Burns & MacDonnell through Collabera Inc)
Notable Challenges: data quality/data integrity issues (accrual and forecast files manually maintained independent of P6 and Contract Management); multiple interface files; frequent turnover of consultant staff; undocumented Access and PowerQuery configurations.
Results Achieved: Improved data quality, reduced processing time, reduced rework.
Critical Actions: Enhanced procedures and training, documented data flows, troubleshot defective logic and configuration issues, optimized database and query performance, developed error detection logic, and mistake-proofed data entry forms.
Period of Involvement: 2018 - 2019