This is an overview of many projects I have worked on. These projects range from single user solutions to large multi-user solutions. While most of my projects have been database applications I have done some web applications, utilities, maintenance projects.  In addition to the projects listed here I have a lot of experience in hardware and software support which has been part of almost every project I have worked on.

No project is done in a vacuum, where you see Programmer (1 of 2), this means I was lead. Also, programming almost always includes hardware advice, implementation, and support/maintenance. For example the first project below included setting up a full testing environment including an Oracle database server.

My First Project

My first project was a Win16 to Win32 conversion of a Borland Turbo C++ application connected to an Oracle database for Parke-Davis Research, this was a two man project. After the conversion many enhancements were made using Borland C++ Builder, including interfacing with external lab equipment. This application tracked assay and validation information for clinical and pre-clinical drug studies. This project included a full validation of the software per FDA requirements. The length of my participation on this project was three years (+).   My Participation: Programmer (2 of 2 then 1 of 2), supervised documentation, completed FDA validation requirements.

Database Projects

Application: Ford Workshop Manuals (Roush) Purpose: Track Ford Workshop Manual publications through the authoring process. Users: 40 simultaneous users Notes: This application has been in use, including upgrades, for 9 years and tracks all Ford workshop publications. It started out as an Access front and backend database but has since been upgraded to an Access front-end connecting to a SQL server backend. Technologies: Microsoft Access, Microsoft Excel, ActiveX, VB, Microsoft Project, Microsoft Word, Microsoft SQL Server, InstallShield My Participation: Programmer

Application: Volvo/Mack Dealer Directory (Volvo/Mack) Purpose: Provide the update information for dealer directories Users: 3 simultaneous users Notes: This application faxed all dealers with a coversheet and current database information for that dealership so they could fax updates back for publication. Output MML files for PageMaker layout. Technologies: Microsoft Access, WinFax Pro My Participation: Programmer

Application: Detroit Diesel 2000 and 4000 series Labor Time Study databases (Detroit Diesel) Purpose: Track labor time studies and publish the labor time guides for the 2000 and 4000 series Detroit Diesel engines. Users: 4 users updating with synchronization. Notes: These applications included video tracking reading an external SMTPE timecode generator. Technologies: Microsoft Access, ActiveX, VB, InstallShield My Participation: Programmer (1 of 2)

Application: Caterpillar Time Guide Requirements Database (Caterpillar) Purpose: Track labor time studies and publish Labor Time Guides for Caterpillar products. Users: 3 users using a single application. Notes: Did exports to update the Caterpillar mainframe. Technologies: Microsoft Access, InstallShield My Participation: Programmer

Application: International Truck and Engine Labor Time Guide (International Trucks) Purpose: Track labor time studies and publish Warranty Time Standards Books. Users: 3 users updating with synchronization. Notes: Publishes full or partial Warranty Books for all International Truck Time Guides Technologies: Microsoft Access, InstallShield My Participation: Programmer

Application: Champion Equity Database (Ford) Purpose: Track owner equity for publications Users: 8 simultaneous users Technologies: Microsoft Access My Participation: Programmer

Application: Pre-Delivery Tracking (Roush) Purpose: Tracked pre-delivery inspection times for Ford vehicles. Users: 1 user Notes: The output was a fully formatted Excel worksheet that allowed the user to do a cost analysis based on tasks and production. Technologies: Microsoft Access, Microsoft Excel My Participation: Programmer

Heavy Truck Dealer Application

Application: Mack Parts Price List (Mack Truck, now Volvo Trucks North America) Purpose: Publish part price book CD. Users: Distributed to dealers and wholesalers. Notes: Includes the ability to set price matrices by customer or product lines so that dealers, wholesales and salesmen can set customized prices and deliver partial updates. The CD eliminated truckloads of paper distributions per quarter (literally). Technologies: VB, Microsoft Access, C++ (splash), InstallShield My Participation: Programmer (1 of 2 then 2 of 2)

Application: Volvo Trucks North America Part Price List (Volvo Trucks North America) Purpose: Publish part price book and ordering guides on CD. Users: Distributed to dealers and wholesalers. Notes: Includes the ability to set price matrices by customer or product lines so that dealers, wholesales and salesmen can set customized prices and deliver partial updates. Technologies: VB, Microsoft Access, C++ (splash), InstallShield My Participation: Programmer (2 of 2)

Application: Mack Trucks Service Publications on DVD Purpose: Publish service, warranty and recall publications to dealers Users: Distributed to dealers Notes: This application developed over many years. I wrote the splash screen and menu application along with the original installation process. This was a (nearly) fool proof installation procedure that automatically determined version and support requirements in installed the necessary software. I also developed the process to compile the various publications and database warranty information into CHM (Windows Help) files. While this was by no means a one man effort I laid the foundations for the current process. I also did second level support for Mack Trucks, including visiting dealerships to troubleshoot system issues. Technologies: VB, CHM, Microsoft Access, C++ (splash and menu), InstallShield My Participation: Programmer (1 of 2, then 2 of 2)

Support Projects

Application: Support for Microsoft Retail Management Software (TeamCaliber) Purpose: Provide programming and hardware support for retail and wholesale operations Users: Large operation including 25 stores, wholesale and distribution warehouse and retail store.  Notes: This included all aspects of support including accounting support, tax audits, warehouse operations, inventory control and audits, hardware support, network support, POS support (phone and direct), and user training. I was primary support on-site in NC for 2 race seasons.

---

Handheld Barcode Application

Application: Launch Rework Program (Roush) Purpose: Track vehicle rework progress for DiamlerChrysler reworks. Users: 6 scanners, 4 database users Notes: The scanner application transmitted messages via the internet/intranet to a SQL Server that processed the messages. An intranet application was used for management and reporting. The scanner application included lot inventory, vehicle shipping and receiving. Messages could be batched to allow for remote lot inventory and subsequent transmission of the messages via the internet. I wrote the scanner and SQL message processing applications. Technologies: VB with Appforge Components, SQL Server, Internet My Participation: Programmer (2 of 3, then 1 of 3)

---

Internet/Intranet Applications

I have done various snippets for web and intranet applications. Some of the snippets include: - Fanclub membership login and signup for Roush Racing - Dynamic menus for Roush Racing - News and article publication for Roush sites, including Roush Racing and Roush Intranet (IRIS) - Phone book application for the intranet - Mack EIS (Dealer Extranet) My emphasis has been the functionality in the background more than the user interface, but it's not hard to put a pretty face on a stong foundation.

Utility

Application: Favorites ActiveX Control
Purpose: To allow Mack dealers to save favorite places
Notes: This mimicked the Favorites tab in a CHM (Windows Help) file so that favorites were independent of the browser favorites.
Technologies: VB, IE, InstallShield
My Participation: Programmer

Application: Phone Monitoring System
Purpose: Read the phone system switch, create logs and transmit the info to PeopleSoft.
Users: 0, 12 unmanned systems
Technologies: Microsoft Access
My Participation: Programmer

Application: Bitmap to TIFF converter
Purpose: To convert BMP files to TIFF
Notes: This was used to covert automated barcode screenshots to tiff for publication for Ford Training Manuals
Technologies: Delphi (Pascal)
My Participation: Programmer