systems


SCR CALCULATOR

SCR Calculator

SCR Calculator

the SCR Calculator I built for Mack Trucks was actually a translation of an Excel application the company had put together. this web version is also deployed on disk I believe. HTML, CSS, JavaScript, jQuery, image optimization.


MACKPROSPECTMANAGER

Mack Prospect Manager

mackprospectmanager

this system replaced the MACKFETCH system below. this system was much better because i was allowed to go server-side with my architecture. this system made heavy use of jquery in that the user rarely has to leave the page to enter or retrieve data, it has a full backend management system, printer-friendly versions of important data, mysql fulltext search indexing so that truck dealers can find the information they’re searching for, and exportation of data to excel spreadsheets.


MACKFETCH

mackfetch website

mackfetch website

this was a closed system in which salespeople would get a reward for each sales lead they entered into the system. the design was made to match that of the titanbymack.com website. flash actionscript programming, custom flash components, html, css, javascript, integration with the salesforce api.


DATA MINE

data mine

homemade data mine

This was probably the most interesting system I’ve built. It was a KDD (knowledge discovery in databases) system, i.e. – a data mine. Basically, while working in the travel industry I built these systems in which, during checkout, customers would enter some requests outside of the standard reservation options which hotels would try to fulfill for their guests. Very often a guest would request things like “please spread rose petals over the bed” or “we’d like to have champaign ready.” I used some basic PHP functions like split() to generate a list of the most common words in these requests to arrive at a list of keywords. I then organized those keywords into some basic categories and built a system using MySQL’s FULLTEXT indexing to figure out which customers would be interested in certain promotional emails at what times of the year based upon previous reservations. It broke all sales leads into “probably interested,” “might be interested,” and “probably not interested.” I think I even threw in some levenshtein() to account for typos.


CONTENT MANAGEMENT SYSTEM

content management system

my first cms... doin' things the hard way

This custom CMS came about from a need to modify advertisements (about 300,000 positions) on a number of websites (some 200)  in which the websites were built in Dreamweaver both with and without templates. Furthermore, the web staff were basically working independently without version control software in place. So basically, I needed to devise a templating system which would open the web pages, parse out some comment tags before and after the ad positions, insert, remove or modify the ads, then resave the web pages. You can tell from the screenshot that this was before jQuery really took off and I obviously didn’t know about TinyMCE or FCKEditor at the time. (I see FCKEditor is now CKEditor.)


REAL ESTATE SEARCH ENGINE

God these things are so old I don’t even want to put them on my resume but there’s so many of them I kind of have to. This one had a zip code-to-latitude/longitude search, search by city, state, exact zip, price, number of bedrooms, number of bathrooms, etc., a JavaScript search widget which would be dropped onto any website, and of course, a custom CMS behind the scenes.

Real Estate Search Engine

custom real estate search engine


GOLF BOOKING ENGINE

This one had a JavaScript widget which could be dropped onto any web page (pic 1), which would take the user to a system where s/he could choose which golf courses had available tee times (pic 2), and then after making a selection place a booking. The system also had a CMS so that the golf courses could log in and modify their availability and information and a CMS so that inhouse staff could manage the reservations.

golf engine javascript widget

javascript widget for the golf engine

Golf Engine - Golf Course CMS

cms for the golf courses

Golf Reservation System - Inhouse CMS

inhouse cms for golf reservations


VOTING SYSTEM

Basically companies would pay to have their businesses listed on these various websites where customers could vote on their favorites. Businesses were broken into categories and locations.

voting system

business voting system


DINNER RESERVATION SYSTEM

You get it by now… a customer books a reservation, this time at restaurants.

Dining Reservation System

dining reservation system


INVENTORY CONTROL SYSTEM

This was a very, very big system. The system allows for inhouse staff and hotel managers to create, edit and manage hotel reservations, down to the room. The system is so big that I don’t even want to talk about it, having to imagine all the work that went into building the thing. Here’s a screenshot.

Inventory Control System

a very large inventory control system for hotels


TRAVEL IMPRESSIONS INTEGRATION

This system integrated Travel Impressions’ GDS (global distribution system) so that customers could book flights, reservations and packages in areas not covered by the other systems.

Travel Impressions Integration

travel impressions gds integration