Portfolio Visibility Without Adding Project Management Headcount
The Challenge
A professional services firm was growing their client portfolio, but their project visibility wasn't keeping up. Status updates lived in scattered spreadsheets, resource allocation was guesswork, and risks only surfaced when they became fires. Leadership couldn't answer basic questions: Which projects are at risk? Who's overbooked next month? What happens if this deliverable slips? The reflexive answer was to hire another project manager — but the real problem wasn't bandwidth, it was the lack of a system.
Our Approach
We built a project management platform that gives leadership a portfolio-level view without requiring teams to change how they work. The platform organizes work from strategic initiatives down to individual tasks, tracks resource capacity and allocation across projects, scores and monitors risks, and maps dependencies so downstream impacts are visible before they cause problems. Dashboards aggregate health and progress across the entire portfolio in real time. We also connected it to the team's existing tools so that project data flows in automatically — no double entry, no adoption friction.
The Outcome
Leadership gained a single dashboard showing the health of every project in their portfolio. Resource conflicts are flagged before they cause delays. Risks are tracked systematically instead of surfacing as surprises. Cross-project dependencies are visible at a glance, so teams can anticipate impacts rather than react to them. The firm scaled their project load without adding PM headcount — the platform provides the visibility that would have required another full-time hire.
Starting State
The firm had grown from 8 to 22 active client engagements over 18 months without adding project management infrastructure. Status lived in weekly status emails, resource allocation was tracked in a shared Google Sheet with no formula validation, and risk tracking happened in Slack threads that no one revisited. Leadership could not answer basic portfolio questions — "Which projects are at risk this quarter?", "Who is overbooked in October?", "What happens to Project C if Project A delays?" — without spending 2–3 hours pulling data from multiple sources. A project manager had been quoted at $90,000/year, and the firm was actively recruiting.
What We Built
- Portfolio dashboard showing health status, RAG rating, and key dates for all active projects
- Resource capacity and allocation tracker with overbooking detection and conflict flagging
- Structured risk register with likelihood/impact scoring and assigned owners
- Dependency mapping between projects with downstream impact visualization
- Automated weekly health score calculation based on schedule, budget, and risk indicators
- Integration with existing project execution tools to pull status without double entry
- Leadership summary report generated automatically each Monday morning
Technology Stack
Project Timeline
Interviewed 4 PMs and 2 leadership stakeholders, mapped current status tracking habits, identified data sources, defined health scoring methodology.
Designed project, resource, and risk data models; built portfolio dashboard; built resource capacity tracker with conflict detection.
Built risk register with scoring, built dependency map, implemented automated health scoring algorithm.
Built Asana and Google Sheets sync connectors, migrated existing project data, trained PM team, configured automated Monday summary report.
Constraints We Worked Within
- Teams would not adopt a new tool that required them to change how they worked — integrations had to pull data from existing tools
- Health scoring methodology had to be agreed upon by leadership before build, not after
- No dedicated DevOps or infrastructure team — platform had to run on managed services with minimal maintenance
- Budget ceiling of $40K for the build — could not justify the equivalent of 6 months of a PM salary for the platform cost
Lessons Learned
- The PM hire was cancelled — the platform provided the visibility that was the actual underlying need, not more headcount
- Health scoring requires calibration: the first version over-flagged projects as at-risk; thresholds were refined over the first month of real data
- Dependency mapping is the highest-value feature but the hardest to populate — required a dedicated session with each PM to map their active dependencies
- Leadership adoption was immediate because the Monday summary report replaced a meeting that had been consuming 90 minutes per week
