Queries
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
Anonymous

21st June 2017 From India, Mumbai

PARTICIPATING IN DISCUSSION:
Dinesh Divekar
Business Mentor, Consultant And Trainer
Talentsorcerer
Talent Acquisition Expert
Sajalkumar@mycareerbugs.com
Manager Recruitment
Shamsali
Hr Assistant

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
21st June 2017 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
25th June 2017 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.
25th June 2017 From India, Kolkata
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.
26th June 2017 From India, Mumbai
Please login to participate in this discussion or start your own. Create Account



About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network

All rights reserved @ 2017 Cite.Community™