Web Projects
Internal Bug DB and Web for Visio
Overview...
The Visio corporation is the producer of the line of Visio technical drawing packages. Visio has since been aquired by Microsoft.
The Problem...
Visio was developing a new CAD package (code named Pheonix) with a satellite group based out of San Diego. The group needed to enhance their existing bug tracking and management solution to include a number of new reporting features and to allow web access.
The Solution...
I developed an intranet site to allow the developers and quality assurance personnel to access the bug database either locally or remotely. I also generated a number of reports and interface features that were not available in the original bug tracking solution.
Pheonix was eventually brought to release and is now known as IntelliCad.
Production Management Solution For Express
Overview...
Express Corporation is a manufacturer of industrial bar code labels and tags.
The Problem...
Express' current production management solution was developed in Paradox, and was nearing the end of its usefulness. They needed an improved system, that offered new features and allowed for convenient reporting.
The Solution...
I developed a new production management system for them in Access, and used Visual InterDev, IIS and Active Server Pages to implement the intranet front-end. Day-to-day management of the solution was managed through access while convenient access to reports was made possible by the intranet site. I determined that Access would be an acceptable platform for the system at the time of implementation, but it was designed with the goal of moving to SQL Server when the load demanded.
National Pen's Consumer Focused Site
Overview...
National Pen corporation is a manufacturer of Advertising specialty products. National Pen's main customer base is built via direct mail and telemarketing.
The Problem...
National Pen wanted to expand its customer base by using the Internet, and leveraging the abilities of the web to offer services that would otherwise be too costly. National Pen's customers were normally limited to purchasing products in quantities of 50-100 or more, all with the same imprint. We wanted to offer a means to order low-quantity, individually customized products, and do so at a great price. One last requirement, customer previously payed for their product after receiving it. We wanted to ensure National Pen received payment for the pens on-line before producing the pens.
The Solution...
We developed a customer focused site that allowed visitors to order pens in quanitites of 10 and up. We added the additional benefit of allowing each pen to be individually customized. The sited was populated with a number of suggested imprint ideas, and suggestions.
On-line payment was made avaible by credit card, or deferred payment by check was also possible (but the order would not be produced until payment was received). An instructor at the Univerity of California San Diego (UCSD) informed me that he used this site as an example in his classes of one of the earliest effective implementations of on-line credit card processing on the web.
National Pen has since relocated their site to a couple of differnet hosting platforms, and in the shuffle, support for the consumer focused site had to be dropped.
System Image and Course Setup Site
Overview...
Vortex Data Systems is a leading Microsoft and Novell training center based in San Diego, CA. They offer certification courses to information technology professionals.
The Problem...
Every week new classes run in each room. The systems in those classrooms need to be prepared with the correct operating system, user software, application servers, etc. Vortex uses system imaging solutions to create an "image" of a student machine for a class, and then apply that image to all of the student machines prior to the start of class. Keeping track of where those images are, which image to use for which class, what needs to be done with the system after the image has been applied, and exactly what is in the image has been a major problem.
The Solution...
We developed a SQL database, that linked into Vortex's schedule management database and retrieven information on upcoming courses. The database stored information about all of the images that were created, which images were required for each course, the configuration of the systems after imaging, what software was included in the image, etc. The web based interface to the database made this information available from anywhere at anytime.
Overview...
Vortex Data Systems is a leading Microsoft and Novell training center based in San Diego, CA. They offer certification courses to information technology professionals.
The Problem...
Vortex has a number of sales representatives. Each sales rep is responsible for a collection of regions within the southern california region. When prospective customers call in, they need to be directed to the representative that covers their region. Keeping track of all of the regions, and which rep is responsible can be time consuming.
The Solution...
I developed a SQL database, that linked that contained the rep and region information. Next I developed an intranet front end to the database that allowed graphical viewing of the reqions and their reps via a map of the county, as well as providing an interface for both lookup and maintenance of the data in the database.