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