Web Site Experience


Web-Based Portal Projects

Metaldyne B2E Portal & BBS

These two tools are being developed to enhance the speed and quality of communication among Metaldyne employees.  The Bulletin Board System can be utilized corporate wide, and has the ability for users to create private sub groups to discuss particular issues.  The ability to upload attachments is included to enhance the dissemination of information.  The B2E portal is just beginning development.  This portal has a corporate area for access to appropriate corporate information such as Health & Safety, Human Resources, Best Practices, etc.  Another area of the portal displays information that is just appropriate for the employee’s division.  This area can include such things as company policies and benefits.  A third area is customizable by the employee and includes such options as news, stock quotes, weather and useful links.


ITW Industrial Finishing B2B Portal & Auction

Illinois Tool Works’ Industrial Finishing Division has just released the second generation of its B2B portal for use by distributors and partners.  This site provides a quick communication medium between ITWIF and its distributors.  Included on the site are such things as price lists, latest news, artwork and upcoming events.  Since this site is utilized by several categories of distributors, all the pages are dynamically created from a database link and only display the information they are allowed access to.  An auction site was also created for use in a United Way Fund Raiser.

Internet/Intranet-Based Projects

GM Remarketing Information Management System (RIMS)

This system was design to be utilized by GM Fleet Remarketing who is in charge of all vehicles that are returned to GM after their lease or use in corporate fleets or car rental agencies is over.  This system gave Fleet Remarketing the ability to track the vehicle when it arrived in a marshalling yard anywhere in the United States, was shipped by GM Logistics to an auction house and then sold.  This program integrated with GM legacy systems that track vehicle manufacturer information and allowed Fleet Remarketing access to the vehicle’s entire life history.  As the vehicle moved through the system, Fleet Remarketing was able to monitor the condition of the vehicle, schedule necessary repairs, and target the vehicle to a specific auction house.  The marshalling yards, logistics and auction houses were able to upload information and place queries to the system via their browsers.


The development of this project was a joint effort with EDS.  John handled initial end-user system design, end-user needs analysis and brainstorming sessions.  These sessions were held individually with key members of the Fleet Remarketing staff and also with a designated auction house.  John then developed the process flow and screen designs based off of these determined needs.  This project had a total budget of $1.5 million.


GM Service Parts Operations (SPO) – US/Canadian Operations

- New Product Release System (NPR)
- Product Information Document (PID)

GM Service Parts Operations is in charge of developing aftermarket products for GM vehicles.  John was brought in to develop an intranet-based system that could handle over 50,000 part introductions a year and would replace their existing paper-based system.  John developed a browser-based workflow system that allowed the parts introduction groups to work as virtual teams.  When a new part idea began, the initiator could select members from various departments (marketing, engineering, finance, etc.) to belong to the team.  As one person finished inputting the information for their section, an e-mail notification was sent to the next person designated in the workflow.  Specific rules and procedures were coded into the pages to prevent anybody from deviating from the prescribed workflow method.  After implementation of the system, Canadian operations were included.


John served as project manager for development of this system.  Other specific areas of service included initial research, end-user needs analysis and brainstorming sessions, overall system design, database design and development, workflow design, system implementation and training manual design.  Since John had overall project responsibility, he also ran the on-going progress meetings and end-user testing.  This project had a budget of $160,000.


GM Chevrolet Marketing

GM Chevrolet Marketing is in charge of coordinating national and regional marketing campaigns for the Chevrolet product line.  Their system involved regional managers filling out marketing campaign forms, sending them to GM Chevrolet Marketing who would then compile all the information into a cohesive marketing campaign for the year.  John was brought in to develop a web-based system that would replace the current paper-based system.  The new system that was developed allowed regional managers to fill out their information on-line, upload supporting materials, and fill in a regional-based calendar for upcoming information.  The data that was compiled into these regional calendars dynamically updated a national calendar.


John served as project manager for development of this system.  Other specific areas of services included review of all existing forms, end-user needs analysis and brainstorming sessions, overall system design, database design and development and running the on-going progress meetings.


GM Public Relations

GM Public Relations handles highly sensitive information dealing with GM’s plans for the next five years.  This information is obtained from the heads of several GM operations: labor relations, salaried personnel, facilities, legal, real estate, marketing, etc.  They would compile this information and make it available to the appropriate members of GM’s executive staff.  John designed a web-based system that would allow the department heads to input their specific information via a browser, compile the data, and provide reports to appropriate GM personnel.


John served as project manager for development of this system.  Other specific areas of services included individual end-user needs analysis sessions with GM department heads, overall system design, database design and development.


Heller Financial

A local agency was authorized to revise and revamp sections of the Heller Financial Web Site and Pinacor Leasing Web Site.  This project was started by the local agency; however, their web designer was unable to handle the database integration of the site.  With the project now three weeks behind schedule, they turned to John to complete the project.  This involved taking existing and new material and changing the format of the design to follow current web site guidelines.  John completed the first phase for review within five days of acquiring the project material. John also designed a Lease Profit Analyzer for use in the sites.


Satisfied with the results, Heller Financial added another phase to the project by authorizing John to revise and revamp the Apple Commercial Credit Web Site.  This project required taking existing and new material and changing the format of the design to current web site guidelines.  

New Media/CD-ROM Experience



Adrian Steel

Adrian Steel is a manufacturer of metal cabinetry and shelving that is installed in the back of commercial vans used by various industries.  A dealer network performs the installations across the U.S. and Canada.  John developed a CD-ROM series of installation procedures and tips that were distributed to this dealer network.  Since Adrian Steel had no control over what type of systems were running the CD-ROM, the program had to be as flexible as possible.  The program was delivered on a hybrid CD that made it accessible by Windows and Macintosh systems.  The primary version of the program included video of the procedures.  For computer systems that were not powerful enough, a version with still pictures timed to an audio track was included.  For systems that did not have sound, both versions included the script in a scrollable text field that could be printed out.


Canberra Corporation

Canberra is a private brand chemical manufacturer.  Most of their products are sold under various distributor names.  The problem they encountered was their product was one of either hundreds or thousands of products that distributor may carry.  How could they get their products noticed?

John created an interactive multimedia CD-ROM tool to be used for marketing and training.  This project was provided as a turnkey solution to Canberra.  It was developed as three modules.  The first module contained all product information such as literature, MSDS, and labels in PDF form.  The ability to search and mark products for later reference was also included.  The second module was designed to include industry-specific sales presentations.  Basically, these were PowerPoint-like presentations for hospitals, offices, factories, etc.  The third module was built as a three-dimensional training environment for end-users.  Using a combination of animation and still photography, an end-user is able to fly around and enter a building, progress down a hallway and enter a specific room.  Once in the room, the end-user can click on a certain surface and get procedures to clean that surface along with the chemicals needed.  All three modules are cross-referenced and allow a user to hop back and forth as necessary.  This program has been reused with new interfaces and information by over ten of Canberra’s customers.



- Plastics Division

In 1995 and 1996, John was involved in the production of CD-ROM based training pieces to be used by plastics operators in learning how to run five different machines.  John’s function was to provide all programming necessary to integrate the video and text, perform static and random testing, create interactive testing opportunities, track the results and forward them to a network system, and bookmark where the user was in their progression through the modules.

- Glass Division

Today, John is working directly with O-I in the production of new CD-ROM based training material for fracture analysis.  John has developed the script and testing procedures, shot the video and is currently creating the coding for the program.  In order to facilitate training in multiple languages, the screen layout is controlled by a database that dynamically loads all the elements: text, graphics and audio.  Each element is coded and linked within the database and, depending upon which language is chosen; those specific elements are loaded.  This enables the program to accept new languages easily in the future.


Sun Oil Company

John was contacted by Sun Oil to help redesign two existing continuing education training pieces.  These pieces were being delivered via their network with scores tracked locally.  One of their major concerns was that end-users could access their results and modify them, thus destroying the integrity of the data.

John revised the system to be delivered via a browser over their Intranet.  New security procedures were designed to prevent end-user modification by making all data storage and tracking remote and inaccessible to the end-user.  The system is being controlled via a database that allows Sun Oil personnel to easily modify the training pieces without having to reprogram the system.  

Database Experience


John programs heavily in the xBase relational database environment.  Programs he develops with include FoxPro, Access, FileFlex, Oracle, and Live Wire. Projects have included the migration of data from a corporation’s mainframe to a PC-based LAN/WAN environment and the creation of all interface programs required.   John has also made this program available as a stand-alone CD-ROM piece for outside salespeople.

GM NAO Design Center

- Business Impact Analysis

The Design Center at North American Operations for GM needed to conduct Business Impact Analysis at over 300 facilities across the country.  They needed to collect this data for use in planning for disaster recovery at their various facilities, and they wanted to develop some type of program that would do it for them.  The twist to this project was that most of the systems in the various facilities did not have access to the intranet, most computers were 386-level machines with only a 3 ” diskette drive, the computers were all running security software that did not allow anything to be installed on the hard drive, and there was over 1,000 pieces of data that needed to be collected.


EDS had been given this project and had been unable to come up with a solution for over two years.  John was able to develop a program that fit on a floppy, asked the end-user all the necessary questions, and stored the data back onto that same floppy.  The end-user would then return the floppy, and all the data from the various facilities was uploaded to a master database from which reports could be run.

DeskTop Publishing Experience


Catalog Production (Printed and Electronic)

John extensive experience in either creating catalogs from scratch or modifying existing ones.  He works closely with his clients to automate as much of the process as possible, thus reducing time and money spent on the job.  He has performed many projects that involved taking data from mainframe systems or from desktop programs such as Excel.  When required, keyboard input of data is also performed.  These catalogs are then ready to go to the client’s printer of choice, or they can be prepared for delivery through an electronic catalog.  John can prepare the files for delivery via CD-ROM, the Internet, or Intranet.

Presentation Experience


Whether it is for a corporate in-house presentation, a presentation for use by salespeople, or any of several other functions, John has the knowledgeto create state-of-the-art multimedia pieces.  He has developed presentations for delivery through CD-ROM, laptops or desktop-based computers.  John works extensively with Microsoft’s PowerPoint and Macromedia’s Director programs, and can combine digital video/audio, animation and images to create a presentation no one will forget.



Office of Naval Intelligence, Pentagon

The Office of Naval Intelligence at the Pentagon contacted John to help them create a solution involving their presentations on the bombing of Serbia & Kosovo.  During the Office of Naval Intelligence’s briefings with the Secretary of Defense and Joint Chiefs of Staff, Microsoft’s PowerPoint is used to display satellite images for bomb damage assessment.  They needed a solution created that would allow them to update these images on the fly while they are running a presentation, a feature not included in PowerPoint.  John was able to create a macro add-on to PowerPoint that enabled live updating of linked pictures while running their presentation.  This solution was designed, programmed and delivered to the Pentagon in less than 24 hours.  

Screen Savers

Screen savers are a nice, fairly inexpensive way to get your message out to a wide range of people, whether through diskette distribution or Internet download.  Almost any type of idea, graphic or animated segment can be made into a screen saver for either the PC or Macintosh platforms.

Industry Specific Work


John has done several projects for Honeywell (Allied-Signal), Champion, Splitfire, OCA Electrical and Automotive Import Manufacturing that involve formatting their parts data into AAIA, AAIA Enhanced, NAPA and Autozone formats.  He has also developed a program that aids him in formatting data for the NAPA Legacy System (TAMS) and has made it simple for maintaining the NAPA PartsPro data in Excel and Access formats.




2004-19, JohnAppt.com - A division of Digital Ability. All rights reserved. 
Hosting provided by Erie Shores Internet