Business Services · Results

Three programs. Measurable results.

Three projects I led, some as an employee and some through Vibrant Blue. Names are withheld; the scale and the outcomes are real.

Andrew Johnson
Andrew JohnsonMBA, PMP, PMI-PMOCP
Project controls · Renewable energy

Project controls for a municipal utility-scale solar project

Northeast Ohio municipality

About $50Mproject tracked line by line
100 hoursof PM admin time saved per year

The challenge

A municipal owner needed one place to see budget, contracts, invoices, schedule, and decisions on a multi-year solar build, without buying an enterprise project-controls platform.

Result: budget, contracts, invoices, schedule, and decisions moved out of spreadsheets, email threads, and loose documents into one connected system. Reporting and tracking now run on their own, which saves the project manager about 100 hours of administrative work a year, and council briefings come straight from the live data.

What I built, in Smartsheet

  • 17 connected data sheets covering budget, budget variance, contracts and change orders, quotes, vendor financials, invoices and EPC payables, forecasting, burn-down, schedule, milestones, deliverables, exhibits, stakeholders, and actions
  • 16 reports that roll that data up for the project team, individual owners, meeting minutes (open actions and a schedule look-ahead), and problem-task tracking
  • A live project dashboard plus a print version for council and leadership briefings: budget status, variance log, forecasted cash flow, burn-down, milestones, latest update, and photos
Contractor management · Forecasting

Contract crew management for a major investor-owned utility

Major investor-owned utility

130+contract crews
5 yearsof visibility, from 6-month job lists to the long-range portfolio

The challenge

More than 130 contract crews, with no single, current view of who was working where, how far along the work was, or what resources the next months would need.

Result: crews went from "I don't know what my next job is" to a six-month job list and a one-year plan, and leadership got a five-year portfolio view. With steady, visible work, crew attrition dropped, completion dates became predictable, material was ordered against real timelines, and field issues between utility and contractor staff were settled faster.

What I built

  • Internal Smartsheet base sheets, reports, and integrations that pulled data in from other company systems
  • Stakeholder and leadership reports showing the current state of work
  • Controlled external access so contractors could update their own data points: crew assignments, percent complete, estimated finish dates, photos, and notes
  • A weekly meeting cadence with each contractor and internal field oversight to clear material needs, schedule interruptions, and issues with external parties
Utility and regulatory programs

Rebuilding three PUCO-regulated inspection programs

Major investor-owned utility, Ohio

100,000+poles rebalanced in the pole program alone
20%of each region's facilities per year

The challenge

Three programs regulated by the Public Utilities Commission of Ohio (ground-line pole inspections, overhead line inspections, and underground equipment inspections) had drifted far out of balance. Some districts inspected 100% of their facilities in one year, repaired the next, then did nothing for the rest of the five-year cycle, causing major disruptions each time their turn came back around.

Result: predictable annual workloads for engineering, design, procurement, and operations, and an end to the boom-and-bust cycle. Spending on all three programs leveled out year to year, which smoothed the company's cash flow and kept every required program on schedule.

What I led

I used historic equipment failure data plus geographic and equipment-demographic information to rebuild all three programs so every region carries an even share of the work each year.

Regulatory approval

Rebalancing meant inspecting some facilities earlier or later than the prescribed cycle for one round, which required PUCO approval. PUCO approved the plan quickly.

Get in touch

Facing something similar?

A 30-minute conversation is usually enough to tell whether Vibrant Blue can help, and how.

Book a free 30-minute call

Calls are on Microsoft Teams. Prefer to write? Send a message instead.