EpiPen Expiration Reminder Tool
Bilingual site supporting an eBlast reminder campaign
Developed for King Pharmaceuticals Canada, 2011
Dynamic site content is delivered based on triple level authentication (guest consumer / authenticated consumer / licensed health care professional). 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):
- 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. - 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.
- 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.