Project: Telecomm Asset Control System (TACS)

Customer: Sarcom - Orlando Regional Hospitals

Environment: Appforge 3.5 for Pocket PC

Description: Orlando Regional Hospitals has to keep track of and maintain oer 11,000 pieces of telecommunications equipment (phones, etc.). The need was to have a PDA based application that replaces the current paper based process for inventory, moves, and changes. The resulting application was designed for the Pocket PC device using Appforge 3.5 (Mobile VB).

My involvement: Specifications, design, development.

Project: Surelock Evidence Tracking System

Customer: R-D Enterprises

Environment: Visual Basic 6.0, Oracle, MS SQL Server, Appforge, Satellite Forms

Description: Via a partnership with R-D Enterprises, I became involved with this wonderful product. Aside from managing the product development, sales, and marketing, I was also involved with the development of the PDA based application. I also developed several complex data conversions systems for moving legacy data into MS Access, Oracle, and MS SQL Server. SureLock is in use by multiple law enforcement and security agencies throughout the US.

My involvement: Managed the design, development, marketing, and sales of the application. Established business relationships with distributors and clients. Participated in the development of the Palm OS application and the Windows based data conversion applications. Creation of process, functional, and stress test plans. Managed the QA testing process and bug tracking.

Project: ACT! for Palm OS

Customer: Interact Commerce

Environment: Codewarrior C for Palm OS

Description: Interact contacted us with a dilemma. They had a Palm OS project which had been under development for almost a year and the resulting application had performance issues, was imcomplete, and had numerous bugs. Originally we were to just do a code review of the existing application and submit a report of our findings. It actually turned out to be some of the worse PalmOS code we had ever seen and the underlying design was not within the scope of normal Palm OS application architecture. Shortly thereafter, we received the project to do a complete rewrite of the application.

The resulting application is ACT! for Palm OS. The application was completely written in CodeWarrior for Palm OS in C, and was written to specifications provided by Interact.

My Involvement: Management of the design and development. Hands-on code development. Creation of process, functional, and stress test plans. And managed the QA testing process and bug tracking.

Project: Smart Data Systems

Customer: MitchellRepairs / Snap-On Tools

Environment: Codewarrior C for Palm OS, Visual Basic 6.0, MS Access, Handspring Visor, Handspring Springboard modules

Description: This was a very unique set of applictions targeted for the Automotive Repair Industry. The following applications were developed:

• Data Viewer - A specifications lookup application for retrieving aotomotive data by Year, Make, Model, and Category.
• Tool Inventory - An application for allowing a mechanic to build a personal tool inventory datase, based on the Snap-On catalog of tools.
• Labor Tracker - For keeping track of labor hours and projecting end of week financial income.
• KnowledgeBase - An application for keeping track of new tips and tricks that a mechanic learns about specific automobiles.
• Racing Schedules - A calendar of racing schedules for the year, for CART, NASCAR, INDY, etc.

We created a very unique technology for data compression and decompression for the Palm OS environment. Our tools would strip the HTML & XML tags from the source data, format the data into a readable format, create the indexing tables for retrieving the data, and then compress the data for storage on the Handspring Springboard modules. We then designed a decompression process that would display the data on the PDA.

My Involvement: Feasibility study, business analysis, and functional specifications. Management of the project and the development team. Hands-on application development in Palm OS and Windows based tools. Created User and Technical documentation. Creation of process, functional, and stress test plans. Managed the QA testing process and bug tracking.

Project: RoadRunner Product Routing and Distribution Tracking

Customer: Whirlpool Corporation

Environment: Visual Basic 5.0, MS Access, Oracle 7.3, FormLogic 3.5, Windows NT Server.

Description: The RoadRunner application was designed for providing the management of Trucks, Drivers, Trailers, automatic and manual management of distribution routes, and management of associated electronic documentation. This enterprise wide application supported 600 HandHeld devices, 30 warehouse locations, and a single centralized Oracle database. Three different applications were developed:

• RoadRunner Console - PC based application that provided the overall management of the trucks, drivers, trailers, routes, stops, and electronic documentation.
• RoadRunner Server - PC based application that provided connectivity between the Oracle database and the handheld device. Via the use of Digiboard serial devices the server supported up to 8 simultaneous connections, with support for up to 128 connections.
• RoadRunner Client - Handheld based application (Apple Newton) which provided the route driver with a list of routes, stops, and assigned deliveries. Signature gathering and exceptions gathering with barcode scanner support.

My Involvement: Feasibility and Business analysis for requirements adherence. Functional Specifications. Database and application design. Actual application development of the Console module. Managed the development of the Client and Server applications. Creation of the process, functional, and stress test plans. Manged the QA testing process and bug tracking. Oversaw the implementation of the system.

Project: Product Consolidation System

Customer: Hunter Industries

Environment: Visual Basic 3.0, Novell Network, MS Access, INMASS MRP, AS/400, Rumba, Barcode scanning and printing system

Description: ProdCon was designed for the tracking of finished goods and managing the automatic transfer of materials inventory from the manufacturing MRP system to the Finished Goods Warehouse inventory. The core VB application interfaced with a barcode scanning system, a INMASS MRP database, and the company AS/400. As boxed product passed through a conveyor belt system, the product id would be scanned from the barcode label. Product quantities would be displayed in real-time and could be adjusted for damaged product, test product, and recalled product. During pre-defined time periods, the accumulated product counts would be sent to INMASS for transferring raw materials out of manufactoring. Finished counts would be sent to the AS/400 via Rumba for updating warehouse inventory.

My Involvement: Functional specifications document. Design and development of the ProdCon scanning application. Design and development of the ProdCon barcode printing application. Project management and coordination with the AS/400 developer, and coordination with the implementation of the box scanning and printing system.

Customer: Baxter Health Care

Environment: MS Windows 3.1, Visual Basic 3.0, Banyan Vines, MS Office

Description: A system was needed for installing MS Office on 1000+ computers via an automated process. To accomplish this, 2 applications were developed.

• Sneeker - The purpose of sneeker was to poll all the computers on the network and determine their configuration. This info was stored into a centralized database. This gave management the ability to determine what computers needed for upgrading to the new MS Office.
• OPI (Office Program Installer) - OPI performed the actual installation of MS Office. Due to the configuration of Baxter's network, the use of a standard installer script was not possible. Plus, Baxter had special features that needed to be implemented during the installation as well. This VB application installed all the required components and fonts, updated the INI files, and updated the Windows registry.

My Involvement: Requirements analysis. Functional Specifications. Design, development, and implementation of the application. QA testing. Technical support during the implementation.

Project: Network Segmentation Project

Customer: Baxter Health Care

Environment: Banyan Vines, TCP/IP, Network General Sniffer, HP Analyzer, SNMP, Cabletron, Cisco Routers, 10Base-T, FDDI, T-1's.

Description: Baxter has eight facilities in Irvine within a 2 square mile area. Some of the facilities were not networked, and the others were using 56KB links. The network was also using a combination of Banyan Vines and Class B TCP/IP addressing. What Baxter wanted was to implement Class C TCP/IP addressing for the entire network, implement FDDI and T-1's between facilities, implement segmentation of the network, and provide full networking support for PC's, Mac's, Sun, and HP workstations. The team implemented six Cisco Routers, six Cabletron concentrators, FDDI connectivity, SNMP monitoring, Class C TCP/IP on top of Banyan Vines.

My Involvement: Project Manager over the entire project. Analysis of the requirements, available resources, and Vendor participation. Project planning by utilizing function point analysis for the most accurate estimate of project milestones. Managed the coordination and implementation of networking equipment and TCP/IP addressing. Hands-on assistance with the physical implementation of the equipment. Network performance analysis and troubleshooting with HP Analyzer and Network General Sniffer. Network was completed ahead of schedule and I was awarded the Employee of the Month Award from Alternative Resources Corporation during this project.

caelique ruina, nec latuere doli fratrem Iunonis et irae. Eu