EpiPen Expiration Reminder Tool

Triple level security (guest consumer / authenticated
consumer / licensed health care professional), bilingual site with an eBlast reminder
campaign.

EpiPen project was developed in C# for the ASP.NET 2 / IIS / Windows 2003 Server
platform. Data maintained on SQL Server 2000 is isolated through a data tier
providing added protection against SQL injection attacks. EpiPen site is divided into three major sections, all bilingual (English and French):

1) consumer site, HTML based with some video streaming and PDF links. This
portion of the site has no dynamic content other than email sign-up, where customers
register for periodic newsletters.

2) reminder tool, where consumer maintains basic information on their EpiPen autoinjector
expiry date, location etc. Reminder tool includes a registration module,
separate from the consumer site’s email sign-up, with a certain level of cross
integration. Authenticated users are redirected to the reminder maintenance screen
where they can enter, update or delete information on their EpiPen injectors. Expiry
dates are pre-loaded, where available, based on the supplied injector lot number.

An ongoing eBlast campaign was configured to send email reminders to consumers
at a configurable period before the expiry date. Email are personalised and sent
through the ViperMail Scheduler, standard Code Revolt Windows Service in production
on several sites.

3) health care professionals site, login protected portion of the site accessible only to
the users authenticated through a health care license validator. Validator is .NET code
based and does not require SQL back-end.