ELISE CAWTHORN (Contract Only) Freelance Contracts I have been freelance since March 2008, contracting for various agencies in the Oxfordshire area, and providing freelance web development for SME’s. Much of the work done for agencies is covered by NDA’s or not in the public domain, so I cannot provide live URL’s however I provide descriptions of some of the more interesting projects below. Reward and recognition (points based) framework Technology: ASP.Net 2.0, SQL Server 2005/2008, DotNetNuke, SQL Reports Server Agency: Oxford Motivation Dates: March 2008 – Current Oxford motivation required a re-useable site on which to base their rewards and recognition system. It needed to be up and running quickly, and to be easily duplicated for other clients in the future. They needed a system which would allow them to add differing content, and users, and with the inbuilt functionality offered by DotNetNuke the site is easily setup. The system was based on the DotNetNuke framework, allowing them to use free modules for most of the site, and buy in extra modules where needed. The Lanzhou DnnStore shop module was purchased, and modified to use points instead of monetary values, and custom points handling modules were developed for uploading lists of users and then their sales figures each month which are converted from pounds to points each month when uploaded. The points module has been developed to cover several states so points can be assigned to a user as pending, available, en-cashed, and total earned, allowing points to be reassigned automatically from pending to available when a user hits a certain target for the quarter. The site has been re-used several times with minor modifications each time, extending the points functionality as required whilst retaining the option to switch back to a previous points arrangement The most recent modifications allowed a custom registration module to be used, and for points to be assigned according to results achieved in various fitness tests, rather than sales values. Other modifications include a custom survey module, a leader board module, and a secondary level of administrative functions where account handlers can view users associated with their account’s details, and their points. All sites have reporting modules available via SQL server reporting services, with several preconfigured reports, and allowing custom reports to be pulled off where needed. Event Management Framework Technology: ASP.Net 3.5, SQL Server 2008, N-hibernate Agency: Indeprod Dates: Autumn 2008 Indeprod provided event management for all their events across multiple clients and sectors with online web sites allowing their clients delegates to register online. They required a custom framework allowing web sites to be setup from one source database, but to be skinned according to the clients brand and configured according to the events requirements. There was an existing internal system using an access database which interfaced with SQL server to manage the data in house, but they needed web sites to be able to run from the same framework allowing data to come straight from the delegates into their system negating the need for data entry internally. A custom framework was created interfacing with the same SQL server 2005 database, allowing both the skinning of the sites, and configuration of the content and registration questions needed to be displayed for each site to come straight form the database. The system handled resource management (flights, hotel booking, activity reservations) basic registration details (name, emergency contact, passport details) and allowed the site to display differing content to different levels of users. The system also allowed for post event analysis questionnaires, post event video and event photos to be displayed. The site was originally built in ASP.net 1.1. This presented some challenges with the skinning, as master pages were not available in this version of .net, so a custom handler had o be written to allow skinning of the site from an ascx file. The framework has now been upgraded to .net 3.5 and the access back end has been replaced by a completely web based solution including report generation and varying levels of admin functionality. Equity Website Technology: ASP.Net 1.1, SQL Server 2005 Agency: Indeprod Dates: Spring 2008 Equity required the migration of thousands of member records, integration with their in-house membership system, and an intuitive admin system to manage their online members and site content. Any loss of data could leave them with unhappy members, and the in-house system was occasionally inaccessible when undergoing maintenance - meaning members would not be able to log into the site. They also wanted an advanced search facility implementing, which still looked clean and easy to use. SQL scripts transferred the member data to a new database, leaving a copy of the old database to refer back to - up to and beyond launch, and the new site was integrated with their in-house membership system via a web service - falling back to the websites local database if a connection cannot be made. A single threaded synchronisation routine then removes any members whose membership has lapsed or cancelled on reconnection. The search facility within the site shows different sections of the form dependant upon previous choices made. The admin system is configured to look like a desktop app, using web 2.0 components such as overlays used to load new content, and uses Ajax to ease the load on the server. 20 Years of Sky Technology: ASP.Net 3.5, SQL Server 2008, N-hibernate Agency: Avvio Dates: Spring 2009 The guys at Avvio brought me in to look after this site and set it live whilst their developer was having a well deserved break. It was their first public site developed for the client, although they had done plenty of work on internal sites prior to this win. The majority of the work had been done, and the framework was already in place for me to start filling out content. There was a custom library handling the majority of the code using N-hibernate, which required a couple of modifications, and there were a couple of teething problems during testing prior to go-live including the synchronisation between the two load balanced servers handling the data requiring modification, as it was failing in one direction, and a last minute fix before go-live with Internet Explorer 6 not being keen on handling the flash bookmarking feature once the client requested question marks were added into some of the titles which were used as the bookmarks, this was overcome by JavaScript substitution of the character on the way into, and back out of Flash – the site was still successfully set live at the agreed time of midnight on the day of the 20 year anniversary. Other contracts Below I list a selection of the other projects I have worked on over the past year and am happy to talk to you further upon request. * Engineers Extranet: for agency Avvio – on behalf of a major broadcasting company * Sales Incentive: for agency Avvio – on behalf of a major mobile phone company * Sales Incentive: for agency Oxford Motivation – on behalf of a major laptop peripheral supplier * Sales Incentive: for agency Oxford Motivation - on behalf of the NHS * Microsites: for agency Indeprod – on behalf of several major automotive supplier * Microsites: for agency JJGroup – on behalf of a major camera manufacturer * Distributor branded site: for agency Creative Hook – on behalf of a major headset supplier.