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
From India, Karnal
Acknowledge(0)
Amend(0)
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
From India, Karnal
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(1)Amend(0)
8047Developing 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
From India, Bangalore
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Emplyee Database Management.xls
Exit Management and Transition Checklist.pdf
Challs hr resume.doc