We are an Overseas Recruitment Agency and Cater to Various Industries
We are currently Facing a Problem with our Database Management System, Everyday we receive Many Resumes from Candidates through Email and our Associates add those profiles in our Database. They save the Resumes in a Particular Folder Sorted Month Wise (For e.g. All Resumes Received in the month of June will be Saved in the June 2017 Folder and so on), At the Same time Important Data from the Resume such as the Name, Designation, Contact, Experience etc is Copy Pasted in an Excel sheet which is Again sorted Month wise (For e.g. All Data from Resumes Received in the month of June will be Saved in the Excel File "Excel - June 2017" and so on)
Now the Problem is when we Receive a Requirement from our Client we find it Extremely Time Consuming to Find Suitable Candidates from our Database as we have to Open Each Excel sheet and then Sort and Filter Data to get Relevant Profiles. (Each Excel Sheet has Data in thousands)
Is there any Simpler Method to Handle Database and maintain Candidates Record ?
How can I Make the Searching and Filtering Part Easier
From India, Mumbai
We are currently Facing a Problem with our Database Management System, Everyday we receive Many Resumes from Candidates through Email and our Associates add those profiles in our Database. They save the Resumes in a Particular Folder Sorted Month Wise (For e.g. All Resumes Received in the month of June will be Saved in the June 2017 Folder and so on), At the Same time Important Data from the Resume such as the Name, Designation, Contact, Experience etc is Copy Pasted in an Excel sheet which is Again sorted Month wise (For e.g. All Data from Resumes Received in the month of June will be Saved in the Excel File "Excel - June 2017" and so on)
Now the Problem is when we Receive a Requirement from our Client we find it Extremely Time Consuming to Find Suitable Candidates from our Database as we have to Open Each Excel sheet and then Sort and Filter Data to get Relevant Profiles. (Each Excel Sheet has Data in thousands)
Is there any Simpler Method to Handle Database and maintain Candidates Record ?
How can I Make the Searching and Filtering Part Easier
From India, Mumbai
Dear friend,
Rather storing the resumes month-wise, I recommend you storing it industry-wise.
For the easy search, you may create one E-mail ID on Gmail. Rather than using it for email communication, you need it to use it for Google Drive which gives 15 GB data free for each Gmail ID. In this drive create folders for the industries to which you cater your requirement. Thereafter, create folders within folder which can be on HR, Finance, Purchase and so on. The benefit of storing the resumes at one place is that it becomes quite easy to search for one specific industry.
Secondly, the way you store the resumes in your PC, same way you store in Google Drive also. Therefore, what your Google drive should be mirror image of what you store in PC. For further queries, feel free to contact me.
Thanks,
Dinesh Divekar
From India, Bangalore
7736Rather storing the resumes month-wise, I recommend you storing it industry-wise.
For the easy search, you may create one E-mail ID on Gmail. Rather than using it for email communication, you need it to use it for Google Drive which gives 15 GB data free for each Gmail ID. In this drive create folders for the industries to which you cater your requirement. Thereafter, create folders within folder which can be on HR, Finance, Purchase and so on. The benefit of storing the resumes at one place is that it becomes quite easy to search for one specific industry.
Secondly, the way you store the resumes in your PC, same way you store in Google Drive also. Therefore, what your Google drive should be mirror image of what you store in PC. For further queries, feel free to contact me.
Thanks,
Dinesh Divekar
From India, Bangalore
Thanks Mr.Dinesh.
I read your post it is so valuable to me, please tell me if i want to go for One Time Solution, if it is paid service i am ready to pay.
but i want such kind of system through which i can upload 100 or 200 resume at once. so that i can utilize my thousands of resumes for my clients
From India, Karnal
I read your post it is so valuable to me, please tell me if i want to go for One Time Solution, if it is paid service i am ready to pay.
but i want such kind of system through which i can upload 100 or 200 resume at once. so that i can utilize my thousands of resumes for my clients
From India, Karnal
I would like to add to what Dinesh Sir said. In addition to saving all the Resumes in your Google Drive, you may also switch to using Google Spreadsheets from Excel. There are many advantages in using Google Sheets viz. you can access the files on go, you can let a whole team have varied levels of access to sheets and collaborate on work, you may just share the link instead of going through the hassle of attaching the whole document. Also, aiding to the concern raised by @SHAMSHALI, one can make a specific folder for each assignment and push just the link to the client instead of uploading the pile of documents therein.
Having said that, there are always a plethora of Applicant Tracking Systems in the market that can help you be on top of your game in managing the candidate databases.
From India, Kolkata
Having said that, there are always a plethora of Applicant Tracking Systems in the market that can help you be on top of your game in managing the candidate databases.
From India, Kolkata
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
How to handle.doc
Lucid Dreaming - The Sleep, Wake, Back To Bed Method.pdf