Multi-Year Infrastructure Modernization (1,200+ Employees)

Context

Overhaul of R&D and production IT infrastructure supporting a facility of 1,200+ employees.

Challenge

High-stakes delivery across R&D, IT, Finance, and external contractors, with strict production schedules and long-lead hardware bottlenecks.

Actions

• Translated R&D technical requirements into bills of materials and procurement schedules.
• Tracked dozens of long-lead items end to end, from vendor sourcing through installation and handover.
• Built one automated SQL and Tableau dashboard per project, giving tens of executives live visibility into milestones, risks, and budget.
• Moved server workloads to a colocation site.

Results

• 30% lower compute cost after moving servers to a colocation site.
• On-time milestones with no downtime to R&D schedules during the upgrade.
• Full executive visibility: Manual status reporting replaced by real-time KPI dashboards.
• Streamlined forecasting: Recurring budget cycles run in step with Finance and Purchasing.

What I’d do differently

I’d assign an owner to every dashboard input on day one. A dashboard is only as reliable as the data feeding it, and keeping inputs current turned out to be its own ongoing effort, not a one-time build.

Artifacts

An illustrative program view reconstructed from the format actually used, not the real dashboard, all on synthetic sample numbers: schedule risk by workstream (Finance, IT, R&D, contractor teams), a multi-workstream timeline, and budget utilization over time. Click a workstream to see its status detail.