Dan Stephenson | Portfolio
Portfolio
A collection of my most recent professional work, research projects and general development outlets.Learn More
Blog
Random thoughts and insights into the abyss of modern technology and software development.Learn More
Curriculum Vitae
A place for prospective employers to download an electronic copy of my Curriculum Vitae.Learn More
Independent Pilots Association
The Independent Pilots Association is a Professional Association that was formed and is managed by Flight Crew. The Independent Pilots Federation is a registered trade union and offer employment assistance to all pilots who join their membership, from help in compiling CVs, to assistance in securing a job through their many diverse contacts.
In this project, the brief was for a web based replacement for their previous 10 year old user management software (written in VB). To begin development on this project i initially had to decrypt and migrate the legacy applications Access Database over to a newer MySQL Database system (using an innoDB database engine for proper data integrity). The new database migration involved creating a migration plan and database related cleanup scripts with which we used during the final migration before going live.
The new Customer Relationship Management (CRM) web application itself was written in PHP under the CakePHP framework and involved heavy use of new technologies such as AJAX and JSON data formats. I was responsible during this project for all front end template design, including modifications to several bespoke DHTML/Javascript elements (dual sliders, jQuery DatePicker etc)
Features included: Add/Edit/Delete members, Saved searches, Generating monthly direct debit CSV data for bank, Email members, Dynamic search fields (approx 30), Search results downloadable as CSV, Integration with websites payment gateway + members areas / member login access, Document Repository and more.
