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

Foundation, advanced and integrative courses in the area of marketing for executives →
Promoted: Program in Marketing & Sales Management from IIM Kozhikode (Explore Course)
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.
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 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
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.
From India, Mumbai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server