Employees required to submit holiday request forms in triplicate for each leave period. HR department are manually entering details into a spreadsheet to create an audit trail.

Create an intranet application.

HR are not fully on board with this due to concerns about the audit trail.

Submit holiday requests to relevant manager, require reason if declining request, reassure HR that any report can be created.

Success - solution rolled out to company and subsequently extended to sickness reporting.

No facility for speculative applications on the company's careers web site

Create a form with the facility to upload CVs and specify which types of jobs are of interest.

Save the applicant's details to the database, upload the CV attachment and email it to HR.

Create a console application to query the HR database for new jobs posted, check the job category against an applicant's specified categories of interest and send an email (with an 'unsubscribe' option) to a candidate where there is a match. Create an executable for this code.

Success - a Scheduled Task was created to run the executable, thereby sending the emails.

Company CRM data needs cleaning

Create an application to send a templated email to all clients in the database asking them to log in and update their details.

This email contains a link to a website where the client's information is retrieved from the database (removing the client's ID from the querystring to prevent anyone from trying to access any other account details).

The client can either confirm that their details are correct, update the details or remove the details from the database.

Dates and times of visits and updates are recorded to enable a follow-up request to those who have either not visited the site or visited the site but didn't update their details.

Outstanding response with hundreds of client details being updated.