| |||
|
Recent News: |
A military recruiting firm hired us to create a program to manage their recruiting efforts. Their technique for matching clients with candidates is to bring (about 25) clients and (about 100-150) candidates together for a single day each month; the event is called a "conference". Candidates are pre-screened and pre-selected to meet with a set of clients for interviews that were scheduled every 30, 45, 60, or 90 minutes, depending on the needs of the client company. Prior to our involvement, scheduling was performed by hand using a series of Excel spreadsheets. We created a program in Visual Basic with a SQL Server backend database to track candidates, clients, and conferences and to automatically generate the best possible schedule for both candidates and clients, based on which clients wanted to meet with which candidates and each client's and candidate's available interviewing time, including allowing for lunches and breaks, as requested. The program would run the scheduling algorithm up to 25 times to maximize the number of interviews and then allow the conference schedulers to manually adjust the schedule, as needed. Finally, the program would print out each candidate's and client's schedule for the day. Once the schedule was complete, however, scheduling conflicts would always result the day of the conference, which was usually held in a hotel without a network connection back to the company's database server. We created a simple replication strategy to allow the conference scheduler to access the entire conference schedule while at the show, make any necessary changes, and then replicate the results back to the main database server the following work day. Separately, we created an accounting application to record the revenue from successfully filled jobs, as well as document the revenue split between the company, the recruiter, and the client account manager. Click Here to Return to Main Samples Page
| ||
