magiccv
CV management

How to build a searchable CV database for your consulting team

A step-by-step guide to turning a folder of Word CVs into a searchable CV database: what to import, how to structure profiles, and how to keep them current without chasing people.

MCMagicCV TeamProduct & bid operations3 min readPublished
The end state: every consultant scored per skill, filterable in one view.

Every consulting firm we talk to has the same folder: dozens of CVs, several versions of each, and no reliable way to answer "who has done pharma work and speaks French?" without asking around. This is how to turn that folder into something you can query.

Step 1: Import what you already have

Resist the urge to design a perfect taxonomy first. Import the existing Word and PDF files and let parsing build a first draft of each profile. The gaps that appear are your actual to-do list - and they are usually far smaller than the imaginary one.

Step 1: existing Word and PDF CVs are parsed into structured profiles rather than retyped.

Two rules make this stage painless. Import the most recent file per person, and do not clean anything until the whole bench is in. Cleaning as you go triples the time and produces inconsistent results.

Step 2: Structure the fields bids actually filter on

You do not need forty fields. You need the four that people filter on under deadline pressure:

  • Skills, with a level or years - not a flat tag list
  • Seniority, so shortlists respect what the client is paying for
  • Languages, at a stated level, because tenders ask for exactly this
  • Certifications, with expiry dates, because expired ones fail compliance checks

Everything else - project narratives, education, publications - can stay as prose. It gets read, not filtered.

Step 2: with skills stored as levels rather than tags, the bench becomes a matrix you can filter.

Step 3: Make search the default way to staff work

The test of a CV database is not whether it holds data. It is whether anyone uses it at 4pm on a Thursday. That means search has to be faster than asking a colleague - filters on the fields above, plus availability, in one view.

Our consultant profiles are finally in one place and always current. Resourcing a bid is a search now, not a scavenger hunt.
JKJonas KellerResourcing Manager · Kessler Partners

Step 4: Keep it current without chasing anyone

Annual "please update your CV" emails do not work, because there is no trigger attached to them. Tie updates to events that already happen:

TriggerWho updatesWhat changes
Project closesConsultant confirms, lead reviewsNew project, skills used, outcome
Certification earned or expiresConsultantCertification and expiry date
Role changePractice leadSeniority, title
Bid submittedBid teamNothing - it reads, never writes

The last row matters most. If producing a CV pack edits the record, your data degrades every time you bid.

Step 4: project history and certification expiry live on the profile, so currency is visible at a glance.
Step 4 in practice: filters plus availability in one view, which is what makes search faster than asking a colleague.

Step 5: Generate documents, never maintain them

Once the profile is the record, a CV is a rendering of it: tailored to a brief, in your brand template, in whatever language the client needs. Nobody edits a document to produce another document.

How to tell it worked

One number: how long the next CV pack takes end to end. If it has not moved, the data is not being used - and the problem is workflow, not tooling.

Start free - 10 candidate profiles and 30 CVs, no credit card.

GDPR by design · EU data residency

Get started free

FAQ

Frequently asked questions

What is a CV database and how is it different from a shared folder?

A shared folder stores documents; a CV database stores structured data about people - skills, projects, certifications, languages - and generates documents from it. That difference is what makes search, filtering and bulk updates possible at all.

How long does it take to import existing CVs?

Most mid-market teams import their whole bench in an afternoon. Word and PDF files are parsed into structured profiles automatically, so the existing files become your starting data rather than a migration project.

Do consultants have to maintain their own profiles?

It works best when they contribute and someone owns quality. In practice a practice lead or resourcing manager reviews changes, and consultants only confirm details at project close - which is when the facts are freshest.

How is this different from an ATS or an HRIS?

An ATS manages external candidates through a hiring pipeline, and an HRIS holds employment records. A CV database covers the people you already employ and optimises for client-facing output: tailored, on-brand CVs for bids and introductions.

What should we do about duplicate CVs for the same person?

Pick the most recent file as the seed, import it, then use the older versions only to recover project history the newer file dropped. After that the profile is the single record and the old documents can be archived.

Is a spreadsheet enough to start?

A spreadsheet gets you search but not output: you still handcraft every document. It is a reasonable stopgap for very small teams, but it breaks as soon as two people need to produce CV packs at the same time.

Get proposal & CV-ops tips in your inbox

From scattered CVs to a polished, on-brand pack in minutes.

See it on your own consultants, or start free today - no credit card.

GDPR by design · EU data residency · Free plan, no credit card