Saturday, April 29, 2006

Multi-Tier Resume Application Parser (RAP)

RAP OUTLOOK EXANGE April 29, 2002
Task: Build Visual Basic application

RAP initially began as a simple application that used VBA to interact with Microsoft Outlook, to parser hundreds of resumes sent to an specific email address as rap@recruiter.com.

This project demonstrates how to programmatically control Microsoft Outlook using Automation from Visual Basic, looping trough all the INBOX emails received during the week and record email addresses for future use.

Here is a screenshoot of the first version which is a Microsoft Outlook based solution, with the following description:
a. Create as many Outlook folders as recruiters there are.
b. Create as many Outlook rules as recruiters there are, to classify the incoming emails from 18 recruiters.
c. Manually export each Outlook-Recruiter-folder into coma separated values file (CSV) and send them to interim attached into an email.
d. Extract CSV files into a folder in client’s computer.
e. Interim should run a BFW developed program called Parser to extract all the emails contained into all the CSV files.
f. Save email address into a SQL Data base
g. Run an additional BFW developed program to save email address into a SQL Data base, and to send emails to all the emails on the database.


RAP: Congrats! This application has potential.

Based on the success of the previous 'RAP' version, our client needs to add more features to the initial VBA-Outlook application, so I had to develop a new VB/SQL Client Server application instead.

Our client is not just the nation's largest combined provider of supplemental health care and staffing services; but also, is a great choice for a great career with nearly 300 locations throughout America, providing services to 43,000 patients each day. It is also the nation's oldest and most successful health care franchise organization with the average owner tenure of 19 years.

In every effort to succeed in the marketplace and to maintain its recognition and its corporate image in the healthcare community, our client needs to collect contact information from potential job applicants that match certain keyword criteria to keep them up-to-date in all the new positions available along the nation.

To accomplish this task, our client, has purchased numerous media components from various providers and resume agents (i.e. Monster.com, CareerBuilder.com, Medzilla, etc). Now, it is necessary an easy, economic and fast way to obtain contact information of potential applicants on the market, save this information in a place where it could be easily retrieved, as well as, provide week per week reports to monitor email blast, and broadcast important company to all the client who requested.

RAP Parser/Sender has born
How RAP works

a. RAP is conformed by three applications: RAP Admin, RAP txt Sender, RAP Parser & Sender.
b. RAP Admin will create a list of recruiters; can create user-friendly charts to simply explain the quantity of emails perceived per recruiter by week. RAP Admin aloud to change the status for a specific recruiter (Active/Inactive). In addition, RAP Admin let specify three different email addresses search criteria: Subject, From, Body.
c. RAP txt Sender, will classify all the emails send by job applicants depending of the recruiter, and it will extract the applicants email addresses, and then save them into a database. This VB application runs at BFW every Wednesday using an automatic schedule task to automatically run this application without a person supervision.

d. The TXT Sender, will run Wednesdays at 4:00PM and will use the recruiters list saved by the RAP Admin, subsequently will create as many Outlook folders as recruiter would be encountered in that list, and classify them following the search criteria defined by RAP Admin as well.
After this task, it will parser all the emails address contained in each emails, and in each recruiter folder. All this emails will be saved into a CVS text file and sent to Interim by email.
Finally Interim, and our development team will receive an email confirmation, indicating how many emails were sent, and whether it found any problem on the process.
e. RAP Parser & Sender: This VB application runs at Interim, its goal is to extract email addresses from all the resumes and save them into a database.
Interim will move all the CSV files from the email into an already defined folder where the RAP Parser Sender will extract all the email address, save them into a Database, and prepare individual emails with pre-defined information to be sent to every person on the database who have not been emailed before.
Finally Interim, and our development team will receive an email confirmation, indicating how many emails were sent, and whether it found any problem on the process.




Conclusion
RAP: Empowering Efficiency in the Healthcare marketplace.
RAP, is the best solution that insures a complete solution where there is not need of a person supervision. In addition, RAP, reduces the process time since there is not waiting time from step to step. Also, RAP will automatically run at specific time and will send a report/notification by email to all the people involved on the process.

In addition, RAP, reduces the process time since there is not waiting time from step to step. RAP can properly store and classify email address by recruiter, can create user-friendly charts to simply explain the quantity of emails perceived per recruiter by week.

Moreover, RAP can parser email address from job applicant’s resumes to a rate of ~110 emails processed per minute, task that would take hours of manual labor.

For all the above, RAP ensures the best Cost Reduction solution saving time process of thousand of applications, reducing exponentially the response time, and saving the need of supervision.

User Manual
Here is a brief general description for the latest updates of the RAP-PARSER/SENDER.

1)The check box, which automatically runs Rap-Sender after the Rap-Parser has finished to run, has been set on the Setup section of the User Interface, and not on the Rap-Sender button as it was originally designed.


2)This image shows the RAP-Parser/Sender after it has found TXT files into the working folder...
Under theses circumstances, Rap-Parser button will be able and Rap-Sender will be disabled.It will automatically run after a 60 seconds countdown or after a mouse click.


3) To access the check box (new option), as well as other important options, the user should click on the Setup button, on the top right corner.

4) Other important Setup options are saved into a TXT file called PathTXT.txt, and contains information related with ODBC connection, default Email, Email notification Subject and Mail Server settings. In this way no code modification has to be made whether any of the server settings change. If the txt file is accidentally deleted, RAP will automatically create a new one with the following default information:

5) The following images show the RAP-Parser/Sender after not TXT files into the working folder has been found. Under this circumstances, Rap-Parser button will be disable and Rap-Sender will be able.
It will automatically run after a 60 seconds countdown or after a mouse click.


Note:
Check the RAP-Sender checkbox whether you want to automatically run Rap-Sender after Rap-Parser ends. The setup option will let you change any ODBC connection or your Email, besides other options.
After 60 seconds either Rap-Parser or Rap-Sender will run. Emails will be sent just if there is TXT files on your working folder, whether there are not any email waiting to be sent at then E01EmailAddress table, or whether you close the application before 60 seconds.

Finally, the RAP report, which is sent every time RAP is scheduled to run. Here is a screenshot:


Thanks for visiting,
Percy Dyer
www.DyerPROjects.com