Paul Bissex

Selected Portfolio

Lionbridge OnDemand Translation Portal

Technology: Django, PostgreSQL, Django REST Framework, Amazon Web Services

Goals:Provide a translation services portal with both a browser-based interface and a powerful API.

Notes:Work included enhancing performance of management interface used by all sales and operations staff.

Cox Media Group sites

Launched: 2011

Technology: Django, PostgreSQL, Solr, Akamai

Goals: Provide core web and mobile publishing platform for all newspaper, radio, and TV properties of a large national media corporation. Maximize stability. Add requested new features. Fix existing bugs.

Notes: Heavy traffic, tens of millions of page views per day. Extensive use of automation to test, deploy, and maintain sites.

Launched: 2006

Technology: Django, SQLite, nginx, Gunicorn, Fabric

Goals: Provide a programmer pastebin that is simple, streamlined, and stable. Use "private" (unguessable) URLs for all items. Allow users to delete or change expiry on their recent posts. Manage spam without inconveniencing normal users. Offer a convenient REST API for item creation.

Notes: Major application upgrade performed in May 2014 with no downtime. Legacy REST API is still used by Django's built-in error page for sharing troubleshooting information. The database is cleaned hourly of expired postings and spam.

Hallmark Alumni

Launched: 2006

Technology: Django, MySQL, Apache mod_python

Goals: Provide a social and information hub for alumni of the school. Facilitate alumni connections through searchable and browsable directory. Provide editable member profiles with automatically resized images.

Notes: Replaced a PHP site created by an outside vendor, retaining the legacy database schema and active data. Originally built with then-current Django 0.91, later upgraded to Django 1.0 without downtime.

Hallmark Housing

Launched: 2007

Technology: Django, MySQL, Apache mod_python

Goals: Help enrolled students for the upcoming academic year find rental properties in the local area. Collect data via a detailed questionnaire to help students evaluate roommate compatibility. Give housing coordinator ability to track communications with students and review questionnaire data. Handle images in various formats submitted by landlords.

Notes: Migrated landlord and property data from existing desktop database. Added group-email system for sending news and help to selected groups of users.

Hallmark attendance and equipment loan system

Launched: 2007

Technology: Django, MySQL, Apache mod_wsgi

Goals: Allow flexible attendance recording and reporting. Deliver report data in needed formats (daily emailed summaries; CSV for import to parent-company’s multi-school system; web reports of per-class attendance detail). Replace a third-party application for tracking photographic equipment checked out by students. Manage other student-specific data, such as vehicle parking permits. Allow relevant administrative staff to easily view, add, edit, and delete data as needed.

Notes: This is a mission-critical system: attendance data is a linchpin of accreditation, and the equipment inventory is worth over $1 million. Availability has to be 100%. Interface has to serve busy non-technical instructional staff. Data has to be accurate and complete and available for daily reporting to parent company. System was successfully adapted, with no downtime, to the mid-year addition of a second class.

Restricted-access application, no screen shot available

Launched: 2011

Closed: 2011

Technology: Django, nginx, PostgreSQL, RabbitMQ, jQuery

Goals: Create an engaging Penny Auction e-commerce site. Produce responsive, continually updated pages. Accurately handle customer transactions. Enable customer support staff to monitor site activity in real time. Enable managers to adjust operation of the running site.

Notes: Five-member core development team did ongoing code review using Review Board. Heavy use of Git branches in development process. Extensive automated tests. (Site no longer live; business has closed.)

Yiddish Book Center

Launched: 2002

Retired: 2009

Technology: PHP, MySQL, Apache

Goals: Upgrade the website of the largest and fastest-growing Jewish cultural organization in America. Allow richer and deeper content. Allow administrative personnel to edit web content easily in their browsers. Provide a platform for integration of sales of books and event tickets, book content search, and other third-party services.

Notes: After their successful 25th-anniversary campaign raised over $25 million, the Book Center stepped up to using a larger team to produce and manage their web presence. I served as a consultant in this process, evaluating vendor proposals and helping plan content migration.