Stephen Lounsbury ----------------- email: steve.lounsbury@gmail.com phone: 613-733-1971 -------------------------------------------------------------------------------- EDUCATION -------------------------------------------------------------------------------- Carleton University ------------------- Bachelor of Engineering, Computer Systems Graduated June 2006 with High Distinction -------------------------------------------------------------------------------- SOFTWARE SKILLS (years experience) -------------------------------------------------------------------------------- PHP (3), MySQL (3), HTML (5), JavaScript (2), CSS (2.5), Python (0.5), Java (1.5), Perl (1), C++ (0.5), Object-Oriented Design (2), Design Patterns (1) -------------------------------------------------------------------------------- SELECTED PERSONAL PROJECTS -------------------------------------------------------------------------------- stephenminded.com - Personal Website ------------------------------------ My personal website acts as a blog and a reference for problems I have came across in the past, how I solved them, etc. The content management system is custom built using the open source MVC framework, CakePHP. The site allows for reader comments as well as multiple "tags" for each article. Adhering to web standards, all markup is valid XHTML strict and is styled entirely with CSS to separate content from presentation. Website can be seen at: http://stephenminded.com/ Languages and Tools: PHP (CakePHP framework) MySQL XHTML and CSS Fourth Year Design Project - GeoTagger -------------------------------------- Allows users to define, tag and share locations they find interesting using the Google Maps API. Back end is a Java servlet running on Tomcat. The browser sent XMLHttp requests to the back end, which would respond using JSON. The servlet provided a geocoding service to the browser using a freely available XML over HTTP API. Project used MySQL as the database with Hibernate as the object-relational mapping layer. Website is not online due to hosting restrictions. Languages and Tools: Java Hibernate Tomcat JavaScript (AJAX) XHTML and CSS -------------------------------------------------------------------------------- WORK EXPERIENCE -------------------------------------------------------------------------------- Carleton University Engineering May 2006 - October 2006, February 2007 -------------------------------------- Designed and developed a proof of concept student scheduling tool, which has matured into a widely used tool in the Engineering department. Allows a student to dynamically generate a schedule using course data imported from the public class schedule. Informs the user of conflicts in their schedule, allows for PDF printing and custom time slot definitions. This tool is mainly used by students who want to propose a class schedule to their faculty advisor. The back end is PHP, which interfaces to a MySQL database using Pear DB_DataObject for object-relational mapping. The back end to client data serialization is achieved using JSON. A demo of the application is at: http://phizero.net/scheduler/ Languages and Tools: PHP MySQL JavaScript (AJAX, jQuery) JSON (JavaScript Object Notation) PHP Pear Libraries XHTML and CSS Carleton University Engineering January 2007 - February 2007 ---------------------------- System to manage applications for the Ritual of the Calling (Iron Ring) ceremony. Students apply online where their applications are submitted to a pending queue. These applications can then be reviewed by a staff member who can approve or deny their application. Students are automatically emailed when their application status changes. Languages and Tools: CakePHP (CakePHP framework) XHTML and CSS MySQL Videora Holdings August 2006 - January 2007 -------------------------- Modified a popular online forum engine, adding an XML over HTTP API, a marketplace of products sold by its users, and optimization for high volume traffic. Work included database design, query optimization, user and administrative interfaces as well as security implementation. Languages and Tools: vBulletin (forum system) PHP XHTML and CSS MySQL Canadian Bank Note September 2004 - April 2006 ---------------------------- Developed a web-based interface for the public key infrastructure certificate authority on our product's VPN. This involved using PHP to interface to a Python back end process using XMLRPC and to provide an intuitive user interface. Performed database table and index optimization on a PostgreSQL database used in an online lottery system. Drastically improved the performance of several report generation queries. Tested and debugged an open source database clustering tool called CJDBC (now called Sequoia) for use with the company lottery product. Was an active contributing member to the open source community surrounding CJDBC. Solved several bugs crucial to the products' continued success. Languages and Tools: PHP Python PostgreSQL CJDBC (open source database clustering, now called Sequoia) Virtual Ventures Tech Camp September 2003 - August 2004 ---------------------------- Developed an online community for the camp staff in order to allow better collaboration. Community included message boards, shared calendar, document sharing, training manuals, tech references, camp enrollment statistics, and meeting minutes. Included group permissions so as to allow certain users access to features like user administration. The system is still used today. Languages and Tools: PHP MySQL HTML -------------------------------------------------------------------------------- EXTRA CURRICULAR -------------------------------------------------------------------------------- - Parliamentary Debate Judge at 2007 Ontario Engineering Competition. - Frosh week facilitator for three years. - Engineering Society Tech Director in second year. - Delegate at the Canadian Federation of Engineering Students Congress 2003 - Organized many events for Carleton Engineering including Yuk Yuk's comedy night and National Engineering Week. -------------------------------------------------------------------------------- HOBBIES AND INTERESTS -------------------------------------------------------------------------------- - Mountain biking - Snowboarding - Golf - Ultimate Frisbee - Speaker and Audio Amplifier Construction