Building a Resume Database: How Can I Organize Thousands of CVs Efficiently?

shamsali
Dear Seniors,

I am working in a consulting firm. I have thousands of resumes/CVs, and I want to put them in a structured manner. I want to build a strong resume database. How can I do it? I am looking for some kind of automation. Please suggest to me.

Shams
Dinesh Divekar
Dear Shams, Recently, I have given a reply to a similar query. You may click the following link to refer to it: https://www.citehr.com/585209-simple...ml#post2356558

Developing an Offline Database

If you want to develop an offline database, then create a master folder. In this folder, create folders specific to an industry. Within these industry folders, create function-specific folders like HR, Purchase, Finance, etc. For each industry folder, create an MS Excel workbook. In the Excel workbook, create function-specific worksheets for HR, Purchase, Finance, etc. In the particular worksheet, write the name of the candidate in a particular cell, and then create a hyperlink in this cell for the CV. With this method, you need not refer to the actual CVs each time. You will come to know how many CVs are there in each folder, and if you wish to refer to the CV, you will be able to do it by just clicking the hyperlink.

Using Google Drive for Online Storage

The method that I have described above can be exactly replicated even in Google Drive. Each Gmail account gives you 15 GB of free space. Since Google Drive comes free with a Gmail account, you should be able to store more than 50,000 CVs in one Gmail account. The benefit of online storage is that you do not have to carry a hard disk or laptop with you. You can access the database even from your mobile.

Learning MS Access for Database Management

The third offline method would be to learn MS Access. This is far better than MS Excel and is the exact solution for database management. Somehow it is not so popular in India, maybe because it is a paid one!

Thanks,

Dinesh Divekar
talentsorcerer
It's best to invest in an applicant tracking system - an ATS will help you get competitive faster and keep a record of all applicant notes, etc. So you can just pick up the phone and reach out with all pertinent information.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute