Problem:  A professional services company launched an initiative to standardize and improve employee recruiting efforts.  New recruiting goals and incentives were established for each manager.  The company set up an Excel spreadsheet designed to track each manager's progress.  The spreadsheet system created several challenges:

1. Only one user could update the file at a time
2. Managers did not populate all required fields
3. Managers found they were misspelling candidate names and as a result, there were a number of managers attempting to recruit the same individual simultaneously
4. It was difficult for the executive team to analyze the recruiting statistics due to the inaccurate nature of the data

Solution: Exactivate.com developed a custom web-based application using ASP.NET 2.0 technology and C# with a SQL Server back-end.  The managers use the primary module to record all interactions with potential employees.  In addition, managers may schedule events and tasks in the system, which are saved to a companywide calendar.  The system is integrated with MS Outlook, which allows managers to easily export contacts, events, and tasks.  Further, the executive team may view a number of reports, including:

1. Achievement - Compares each manager's actual recruiting statistics with weekly and monthly goals.
2. Rankings - Ranks all managers on key recruiting metrics.
3. Closing - Calculates the average number of days it takes each manager to bring a new employee on board.

To address duplication of recruiting efforts, the system is synchronized weekly with a professional association's membership list.  The membership list serves as the entire candidate pool for the professional services company.  Managers may only add candidates from the master pool.  If a manager wants to add a candidate that is not part of the master pool, an approval workflow was implemented to ensure the manager is not attempting to add a candidate that is already part of the system or the master pool.