PHP / MySQL : WEB DEVELOPMENT RESUME    Page 1  Page 2  Page 3  Page 4    The following pages describe 4+ years of commercial experience in programming enterprise level web applications using PHP language and MySQL database interactions to create dynamic web content. All of these projects were developed from concept to completion by myself as the sole code writer. For contact information, click here.

Page 4

PROJECT: Blue Market Creative Call Center Blue Market Creative is a advertising agency that specializes in TV and radio ad media buying. They also create custom music for advertising for their clients. The sales staff needed a customizable call center for keeping track of potential and current clients in all markets in the US. The database was populated by staff entering in the contact info for a prospect, ...and then the sales team searched through the entries based on their needs for that day's cold calling session. Setting the search to "call backs for today's date" returned all calls that needed follow ups. Once a lead was ready for a sales executive to pursue, it became flagged as "hot". When search results return, an editable form is populated for updating. A timestamp system ensures that if two people open the same record in the database the first saved data is preserved without overwriting any newly added data. An automated billing and client file access system (not shown here) also aided in the accounting and customer care areas of the business.

PROJECT: Passport Music's Free MP3 of the Month Club and online dealer applications Passport Music is a recording label specializing in nature sounds and world music. This automated email newsletter is very simple, yet extremely effective. Signing up for the "FREE MP3 of the month Club" is as simple as filling out a two line form: The database tables store the info, and contain a record for each month's free mp3 file (link to file, title, album and specials for that month). A monthly cron job executes a php script that reads the current months data, populates an html email template with the info, and then emails each signup record found. Removal links are also included for a member to automatically remove themselves from the list. It has error checking functions that will email admin about errors, however no errors have ever been made. This system will work unattended until the year 2011, when it will notify the admin that more records are needed. Passport Music also had a need for online order forms for their wholesale dealers. Much better than a form mailing cgi, these online order forms email the dealer and admin about the orders, stores the info into a database, and displays it back in a "production table" style, so that technicians can access the info and post the job status.

PROJECT: Online Discography - J R Sanson As a producer, recording engineer, and graphic designer, I needed a "discography" to display all the CDs that I've worked on, and the PHP code writer in me couldn't resist the challenge of making a searchable resume with many extra functions. Completely database driven, this discography defaults to a "show all" state, displaying all CDs in sets of 4 per page, with previous and next buttons to see more. Extra functions include: searching for CDs by style categories, or keywords from the descriptions, or both. Also, a "cron" checkbox that can alter the results into cronological order. Each results display includes: cover image, description, roles I played, audio sample, and external links. A special M3U playlist link for playing all the samples is located next to a contact form link and a short pop-up resume. Click here to see this Discography in action.

<<  Previous Page

Thank you for viewing my portfolio... Return to Page 1
For contact information, click here.