ncyoung.com

You are here: Top->Hire Me!->experience->projects by role->Database Designer



Cisco QA database project

Cisco's recent redesign of the public Cisco.com website involved integrating the website with a content management system and gathering content from diverse sources.

As content was gathered and imported into the CMS, there was potential for things to get screwed up. Checking each piece of content was a massive undertaking so I helped to design and implement a system that would allow for keeping track of which content that had passed QA, content that had not passed, etc.

Issues that complicated matters:
  • The list of content came is a massive export from the CMS. The import mechanism needed to look at each new export as a new snapshot. Information that had changed from one snapshot to the next was considered important.
  • Content could be un-checked, checked and approved or checked and unapproved. Additionally, content that had been checked in the past and assigned a status, then changed had a second set of statuses
  • The system had to support a manager assigning large groups of content pieces to many QA workers. It had to track and organize content for those workers so that it was easy for them to check content, assign status, and repeat while the application managed and updated their active lists for them.


The system used perl scripts to automate import of the snapshots from the CMS, and access front end for the administrator and QA workers, and a MSSQL backend.

Moderated community ordering system

This site allows members of the National Charity League (NCL) to order charms (charms are jewelry items signifying acheivment and dedication within the NCL).

Charm orders must be approved and grouped by the Chair of each Local Chapter of the NCL. The website allows the Chair to manage, group, submit and report on the charm requests made by members.

Lynn's Jewelry is the exculsive supplier of charms to the NCL. The site provides administrators at Lynn's Jewelry with the user management tools, order management and reporting, and fulfillment reports and functions.

started: 2001-10-01

Ended:

B2B Marketplace

Sellers can use the system to define products and zones. They can then set minimum order goals for a product in a zone.

Buyers use the system to order products. Buyer requests are aggregated by zone to meet minimum orders.

Buyers can take advantage of bulk discount yet still order just the ammount they need. Sellers can cut their fulfilment costs by handling larger orders, yet sell to smaller customers.

started: 2001-10-31

Ended: 2002-01-15

Prepay.com

I was responsible for creating a development strategy that would provide our company with software and server infrastructure capable of scaling to meet massive usage, and of being very reliable.

I wrote a custom transaction server application and client software to provide transactions against accounts held in our data center. This included building in fault tolerance, recovery and monitoring to ensure availability of the service. It also included client verification, security controls, and transaction integrity to prevent fraud and assure the accuracy of our account data.

Gyrus

On-line education environment for teachers and students. It includes a user authentication system with quick messaging, integrated educational components, and a tightly integrated user interface designed in shockwave by a colleague.

started: 1998-01-05

Ended:

Hot Spots

Web site for a hotel information and reservation service based in Santa Barbara, California.

started: 1999-04-05

Ended:

A1 doors

Worked to evaluate the business needs that were driving a company using a traditional paper only accounting system to adopt an ERP system.

started: 1999-05-01

Ended: 1999-08-11

Ranch and Country Magazine

Created a database driven listing of properties for sale by region, allowing the editors of Ranch and Country to easily post the listings from their magazine on-line.

started: 1999-02-10

Ended: 2000-02-10

Media Makers

I created an application for an order fulfillment house that allowed their wholesale customers to place orders online. It also allowed their suppliers to view the inventory of product that particular supplier provided. It would set visible flags and sent email warnings to suppliers when stock at the order fulfillment company dipped below acceptable levels.

Invoices and account information were also available online. In a separate project I implemented an online payment solution.

This system replaced a communication system that used many fax transmissions each day and required considerable person to person interaction on the phone. It also allowed the companies on both sides to respond more quickly to inventory levels, to avoid rush delivery costs, and in many cases to hold a leaner inventory.

started: 1998-12-15

Ended: 1999-05-15

Paradise Falls

Created an on-line store for a retail store selling native American handicrafts.

started: 1998-10-01

Ended: 2000-11-01

100 Movies website

Website for the AFI's celebration of the first century of movie history.

started: 1998-05-01

Ended: 1998-07-01

Pilot's Travel Guide

An on-line service for small plane pilots. Provides Runway lengths, radio frequencies, etc. for airports around the country (data from the FAA). Also provides information about lodging dining, and other businesses in the vicinity of the airports. Allows Pilot's Travel Guide sales reps to enter their own ads into the site.

started: 1998-03-20

Ended:

Venoco Inc. Land Department

A database application managing the extremely complex contractual obligations of mineral leases.

started: 1998-03-18

Ended: 1999-01-12