A 250-Person Firm Found Its "Master Project List" in a Retired Employee's Outlook

Why Most AEC Firms Don't Own Their Project History

Forty-one percent of organizations rarely or never attempt to collect knowledge from retiring employees, according to APQC's 2025 study of 1,000 professionals¹. In AEC, where more than a quarter of workers in architecture, engineering, and related industries are already 55 or older², that number has teeth.

Consider what's converging right now:

• By 2030, 40% of the current AEC construction workforce will have retired²
• 11,000 Baby Boomers turn 65 every day in the United States²
• 51% of organizations expect the majority of their workforce to retire or leave within five years³
• 41% of employees have had to start a job essentially from scratch due to inadequate knowledge transfer from predecessors⁴

Each of those stats describes an HR problem. Together, they describe a capability problem — the master project list that most firms need to win work five years from now is already walking out the door— and the firms that capture it now will have a structural advantage that no software purchase can replicate. See how the institutional knowledge crisis plays out across AEC.

What a Master in Engineering Project Management Actually Tracks

A master project list in engineering project management is a centralized, searchable record of every project a firm has completed or pursued — including scope, team, budget range, delivery method, client sector, and reusable proposal language. It's the firm's institutional memory, made searchable. Think of it as the single source of truth for your competitive history.

The fields that matter for AEC proposals:

• Project name and type (bridge rehab, K-12 education, mixed-use, data center, etc.)
• Client sector and geographic area (federal, municipal, commercial; state or region)
• Approximate scope ($ fee, SF, or narrative scope description)
• Delivery method (design-build, CMAR, design-bid-build, P3)
• Team leads (principal-in-charge, PM, key discipline leads)
• Reusable project narrative — one to two sentences, Challenge-Solution-Outcome structure, ready for SF 330 submissions
• Key subconsultants — including notes on who not to call again

Six fields, one project record. That's the minimum. Everything else is searchable bonus.

The difference between a master project list and a shared drive full of PDFs is taxonomy. One is searchable; the other is a storage problem. As Flowcase notes in their work with AEC proposal teams⁵: "The challenge isn't just creating project narratives, it's storing and structuring them in a way that makes them findable, reusable, and tailorable across proposals." That's the gap most AEC firms haven't closed.

The Four Ways Firms Lose Their Master Project List

Project data in most AEC firms doesn't disappear — it disperses. Across Outlook folders, shared drives with no taxonomy, ERP fields nobody updates, and the mental indexes of principals who've been there twenty years. Each is a different failure mode with a different fix.

1. The Outlook/SharePoint Chaos Personal drives and email folders accumulate proposal files, scope documents, and project narratives with no consistent naming, no taxonomy, no way in. The person who organized it knows how it's organized. Nobody else does.

2. The Incomplete ERP Deltek Vantagepoint, Unanet — the data fields are there. They just don't get filled in. Project data capture was never required at project close-out. An ERP with incomplete project data isn't a database; it's an expensive filing cabinet.

3. The Principal-as-Index This is the failure mode software cannot solve. One or two senior principals hold the entire project history in their heads— which subconsultants never show up on time, what the actual scope creep was on that county job, which client relationship is warm and which is complicated. According to our analysis of AEC institutional knowledge, roughly 42% of institutional knowledge is unique to the individual who holds it: never written down, never filed, never searchable. When that person retires, no retrieval tool can recover what they knew.

4. No Close-Out Protocol Every project ends. Almost no project ends with a data capture step. The institutional memory deficit compounds with every close-out that doesn't capture anything — and most of them don't.

What Your Scattered Project Data Is Actually Costing You

Proposal teams at A/E firms average 33 hours per RFP response with nine contributors involved, according to our research on AEC proposal operations. The majority of that time isn't writing— it's searching. For the right project example. For the team member who worked on that highway rehab four years ago. For the fee schedule from the last similar job.

When the majority of proposal time is spent searching rather than writing, a structured project library doesn't just improve quality — it changes your capacity. Firms can't read the label from inside the bottle; they often don't know what scattered data is costing them until someone maps it from outside. The hidden costs of disorganized project data compound beyond what most BD teams realize.

The ROI on organized data is real. According to Autodesk research cited by Tektome⁶, firms using disciplined, data-driven practices achieve around 50% higher profit growth than their AEC peers. A structured proposal content library can eliminate enough search time to automate 40–80% of boilerplate-eligible RFP sections— the standard-form content like project descriptions, team bios, and past performance narratives⁷ — but only if the library exists and is searchable.

How to Build a Master Project List That Survives Personnel Turnover

The firms that own their project history follow three steps: audit what you have, establish a minimum viable data standard, and build an update protocol that runs at project close— not at proposal time.

Step 1: Audit What You Have Start with the last five years of closed projects. Identify where the data actually lives: ERP fields, Outlook archives, shared drives, principal inboxes. Don't try to recover everything; start with the project types you pursue most often. Perfect is the enemy of searchable.

Step 2: Establish Minimum Viable Fields Six fields that matter for AEC proposals: project name/type, client sector, approximate scope, delivery method, team leads, and a one-to-two sentence Challenge-Solution-Outcome narrative for each project. Resist the urge to build the perfect database on day one. A minimum viable project record is better than a perfect record that never gets filled in.

Step 3: Build an Update Protocol Update at project close — not at proposal time, when you're under deadline pressure. Assign ownership to a marketing coordinator or a designated data steward per practice area. Best-performing enterprises tracked by APQC start knowledge capture programs three to five years before projected retirement dates⁴. If you're already in the middle of a retirement wave, starting now is still better than starting at proposal time.

Once the data is organized, the path to AI-powered proposal retrieval becomes clear. Before that, it's noise.

AI and the Master Project List: Order Matters

AI-powered retrieval tools— OpenAsset (with Shred.ai AI search), Kantiv, Flowcase— can surface past project data in seconds. But they require well-organized data to function. Applied to a disorganized archive, they produce confidently wrong answers: the wrong project pulled for the wrong RFP, the wrong team member attached to the wrong outcome. AI applied to a disorganized project archive doesn't solve the problem— it accelerates it.

Only 27% of AEC firms currently use AI for automation or decision-making, according to Bluebeam's 2025 industry report⁸. The firms getting ROI are the ones who organized their data first. Bluebeam's survey of early AI adopters in AEC found that 68% saved at least $50,000— and 46% reclaimed 500–1,000 hours⁸. Those numbers assume the data was ready.

Once the data is structured, the tooling decision is almost secondary. Flowcase, Kantiv, and OpenAsset each integrate with Deltek Vantagepoint and Unanet— and any of them can automate significant portions of your proposal workflow once the underlying library exists. The decision that matters isn't which tool. It's whether the data is ready for any of them. Building an AI-ready team starts with building AI-ready data.

Where to Start If You're Starting from Chaos

In our work with AEC firms, the ones seeing ROI from AI-assisted proposals started with the same move: they audited what they had before they bought anything.

If mapping your firm's current state feels like a project in itself— that's exactly where an implementation partner adds value. Dan Cumberland Labs helps AEC firms build the data infrastructure that makes AI implementation work: organized, tagged, and ready for proposals. If you don't know where your firm's project history actually lives right now, that's the conversation to start.

FAQ

What is a master project list in engineering project management?

A master project list in engineering project management is a centralized database of every project a firm has completed or pursued — including project type, scope, team leads, budget range, delivery method, and reusable proposal language. It's the firm's searchable institutional memory, distinct from active project management tools like Deltek or Procore that track live work. Purpose-built AEC platforms like Flowcase, OpenAsset, and Kantiv are built around this concept.

How do AEC firms typically lose their project history?

Project data disperses through the retirement of senior staff who held it in personal systems (Outlook folders, hard drives), lack of project close-out protocols, incomplete ERP data entry, and no centralized database standard. APQC's 2025 research found that 41% of organizations rarely or never attempt to capture knowledge from retiring employees¹.

What percentage of the AEC workforce is approaching retirement?

By 2030, 40% of the current construction and AEC workforce will have retired, according to the National Center for Construction Education & Research (NCCER)². More than a quarter of workers in architecture, engineering, and related industries are already 55 or older — and 11,000 Baby Boomers turn 65 every day in the US².

Can AI help recover a firm's lost project data?

AI can help surface and organize existing digital project files, but it cannot recover undocumented tacit knowledge held by retired staff. More critically, AI applied to disorganized data produces confidently wrong answers — retrieving the wrong project for the wrong proposal. The correct sequence is: organize and tag project data first, then layer AI retrieval tools on top of a structured foundation.

What tools do AEC firms use to manage project experience databases?

Purpose-built platforms include OpenAsset (with Shred.ai AI search), Flowcase, Kantiv, and integrations with Deltek Vantagepoint and Unanet CRM. Each offers varying degrees of project data centralization, proposal language retrieval, and AI-powered search. The right tool matters less than having structured data before you deploy it.

References

1. APQC, "The Great Retirement: Knowledge Loss, AI and the Workforce Shift" (October 2025) — https://www.apqc.org/resource-library/resource-listing/great-retirement-knowledge-loss-ai-and-workforce-shift
2. KNOWRON, "Lack of Skilled Workforce and Baby Boomers Retirement: Top Stats & Trends" (2024) — https://www.knowron.com/blog/lack-of-skilled-workforce-and-baby-boomers-retirement-top-stats-and-trends
3. APQC, "APQC Study Warns of Looming 'Great Retirement' Crisis" (October 2025) — https://www.nasdaq.com/press-release/apqc-study-warns-looming-great-retirement-crisis-highlights-role-ai-and-knowledge
4. Tektome, "APQC's 'Great Retirement' Findings: What Teams Can Do About Knowledge Loss" (2025) — https://tektome.com/expertise-center/blog/great-retirement-findings
5. Flowcase, "How to Write, Manage, and Tailor Past Performance Sections for Construction Proposals" (2025) — https://www.flowcase.com/blog/how-to-write-manage-tailor-past-performance-sections-for-construction-proposals
6. Tektome, "Research Shows Data-Driven AEC Firms Grow Profits ~50% Faster" (2024) — https://tektome.com/expertise-center/blog/data-driven-firms-grow-profits-faster
7. Dan Cumberland Labs, "Proposal Management for Engineering Firms: Winning More Work with Less Overhead" (2025) — https://dancumberlandlabs.com/blog/proposal-management-engineering/
8. Bluebeam, "New Bluebeam Report Shows Early AI Adopters in AEC Seeing Significant ROI Despite Uneven Adoption" (October 2025) — https://press.bluebeam.com/2025/10/new-bluebeam-report-shows-early-ai-adopters-in-aec-seeing-significant-roi-despite-uneven-adoption/