MySQL and Database Design:

This RMA system manages hundreds of RMAs a day from multiple companies, held in multiple databases, saving the company thousands in lost product and missed freight claims.
My position at The Salzman Group has afforded me the opportunity to get much deeper into MySQL database design and theory than I’ve ever been in the past. At this company, it has been necessary to manage several different web site’s inventory levels to produce both an RMA (Returned Merchandise Authorization) system and an order entry system. The RMA system in particular manages RMAs held in multiple databases and presents them as a single set of data to the user, allowing customer support representatives and warehouse mechanics to work off the same set of data for the first time in the company’s history. Doing so has allowed the company to save time, money and resources from being sucked into unnecessary work. The order entry system I developed allows agents to work off the exact same data as the website currently offers, making it easier than ever for the company to maintain accurate stock levels and keep track of sales promotions and campaigns.
- Managing data from multiple companies in multiple independent databases.
- Managing nightly imports of data from a FoxPro database into the MySQL system.
- RMA system tracks the receipt, repair, restocking, crediting and shipping of all RMA products for all companies.
- Order entry system handles charging cards through Authorize.net
- Order entry system maintains inventory levels at Webgistix, a third-party shipping warehouse, through the use of the Webgistix API and a nightly rebuild of a local inventory table.
WordPress:

The DFE News Harvester plugin makes it possible to import news feeds from a variety of sources into a manageable format in WordPress.
Demonstrating my knowledge of the internals of the WordPress/MU API, the below links showcase the tutorial sections of HN.net. The Design Studio discusses HTML and CSS, Plugins discusses how to build WP plugins and publishes my current versions. Links to my current plugin list is also included.
- Instructional and Documentation Pages:
- Plugins (hosted on WordPress.org svn):
JavaScript, AJAX, and User Interfaces:

The EssentialEspresso.com website features jQuery flyout menus of my design which provide a quick and consistent navigational element to the page.
JavaScript is fast becoming the free replacement to many of the things companies have often done with Flash in the past. With frameworks like jQuery, prototype and MooTools – all of which I have worked with – offering rich, cross-browser user interface tools and myriad development tools, it is important to stay current with trends in this area. My focus on easily-navigable websites and feature-rich content means that becoming an expert in AJAX and JavaScript in its many flavours has been a must. Below are a few examples of my JavaScript front end work
- EssentialEspresso.com ~ flyout menus on left developed in jQuery.
- The Kodak Picture Kiosk ~ sample switching done in Scriptaculous and prototype.
- WholeLatteLove.com ~ left hand navigation done with Scriptaculous and prototype.
- “The Spot” @WholeLatteLove.com (membership req.) ~ commenting animation in Scriptaculous and prototype.
Web Design, Kodak:

The Picture Kiosk home page is a Flash and JavaScript-driven sitelet that allows customers to preview options available at in-store Kodak Picture Kiosks
I worked for the Eastman Kodak Company for two years as a contractor. During that time, I was responsible for building multi-million dollar e-Commerce and marketing web pages and “sitelets” that demonstrated the available products from Kodak. Unfortunately, many of these are seasonal sites which are no longer available at Kodak.com, but here are a few currently-available examples of my work:
- The Kodak Picture Kiosk:
- The Kodak Gift Guide
- The Kodak Printers comparison matrix
- The Kodak EasyShare Software Insert
- The Kodak Printing supply pages
Web Design, Freelance:
Below are sites I run or have built for other entities. DragonFlyEye.Net is my community portal run on WordPress MU; HolisticNetworking.Net is also WPMU; TheBuddhahood.com is a local band’s website, built in WordPress and iam.bit-character.com is my “zen garden” design project.
- DragonFlyEye.Net
- HolisticNetworking.Net
- TheBuddhahood.com
- iam.bit-character.com
CakePHP

PotholePatrol.org is a social ticket tracking system aimed at fusing social networking with civic participation. It is currently in Beta 1 development.
My newest project is called PotholePatrol.org. It is aimed at taking the best of social networking and putting it to use in the service of local civic participation. Users are able to register “potholes” or problems for which local governments are responsible, vote on their importance, comment on their status and promote them on their FaceBook or other social networking services. For more, please read here.
- PotholePatrol.org (currently in beta)


