Solution: Perl script to automate nightly inventory uploads and an instant messaging robot to query the data. Details

Problem: Existing web travel portal needs overhaul.

Solution: Facelift, and administration interfaces to manage content upload and advertising. Details

The Site: http://www.aloha-hawaii.com
Site design and planning by Tsunami Marketing I was brought in as a contractor to code the administration and advertising interfaces according to client specifications.

It is important to note that the entire site is managed and maintained through these interfaces. The client never needs to fire up an FTP client or see HTML.

Problem: Large East Coast retailer needs a trouble ticketing system to track the repair and replacement of point of sale equipment, primarily the thermal printers used to print customer receipts.

Solution: Clean, robust, user-friendly trouble ticket system written in PHP and backed by a MySQL database. Details

Problem: Client needs simple, bulletproof method to keep web site up-to-date and consistent with product line and inventory. Hand coding is a poor option because some products contain dozens of individual parts, and product line changes frequently.

Solution: Perl script to generate web site from existing Excel spreadsheet. Details

The Site: http://www.quickconveyor.com

Problem: A national pharmaceutical corporation has a valuable (but vast and disorganized) set of data pertaining to their own products as well as competitors products. The goal is to give sales staff access to this information so as to better serve their customers (generating more sales), and to allow sales managers to better understand what is a very complex product line.

Solution: After a good deal of data extraction and massaging with Perl, we have an SQL database and a powerful and flexible PHP front end to query the data. Sales staff can now log in to this web interface and, given a competitors part number or product characteristics, find suitable products for a customer. Details