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
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.
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.
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(0)Amend(0)
8035Recently, 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
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.
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.
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(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Emplyee Database Management.xls