Resume 9

Since 1980 Mr. Scott has been designing and implementing complex custom application software as the Principal Consultant for Advanced Systems, Inc. In the late 1980s Mr. Scott started using FoxPro as a development environment and has continued to use it and its successors, currently Visual FoxPro 7.0, as the cornerstone of all of his application development. He is experienced in Object Oriented development and has developed in Client/Server and MultiUser environments using ODBC, OLE and COM and on the Web using Web Connection.

Mr. Scott is the author of several articles on FoxPro programming and has successfully competed in International Programming Competitions using FoxPro. He is very experienced in all phases of system development and has the ability to develop a complete system from scratch on his own or as the leader of a small group of developers.

Visual FoxPro, FoxPro, Access, Fortran, Visual Basic, C++, Excel, Word, Outlook, Crystal Reports, SBT, Web Connections, SQL Server, OOP

BS Electrical Engineering University of Arkansas
MS Operations Management University of Southern California

Advanced Systems, Inc., was started by Mr. Scott, to provide consulting and software development services to medium size businesses whose needs could best be served by custom software. As the lead software engineer for ESI Mr. Scott has participated in the development of a number of systems, several of which are being turned into commercial software products. Examples of this type of development are the Warehouse Manager developed with Compact Merchandising Corporation, Full House property management developed with DeBourne Properties and the Physicians Desktop developed with Zaur OB/GYN.

Mr. Scott participates in all phases of software development from design to implementation. He is qualified to do a complete development on his own or to manage larger groups of programmers in a larger scale environment.

Terra is a retirement community located in Walnut Creek, CA., consisting of some 8,000 homes and condominiums. The maintenance of these homes and the financial administration of the individual units and the home owners associations is handled by the Mutual Operations Division MOD . Historically MOD has utilized FoxPro based programs to accomplish all of these administrative tasks. In 1999 it was determined that the existing, SBT DOS based, programs were non-Y2K compliant. A decision was made to replace all of the exisiting programs with more modern Visual Fox Pro based systems that would convert the existing data and offer advanced capabilities. Mr. Scott was retained to do this system development. The work accomplished so far consists of Work Order, Unit Status, Accounts Receivable, Property Tax, Banking Interfaces and Water Meter management systems. MOD has decided to hire an on-staff programmer to support and enhance these programs. Mr. Scott is currently in the process of training this staff person.

Ercel is a multi-million dollar international company whose primary product is called Honeycomb. There are currently over 300 different versions of the Honeycomb product each of which has its own complex set of pricing parameters. Mr. Scott has developed the Honeycomb Pricing Program for Ercel using VFP 5.0. The system is to be used by its 60 plus Customer Service Representatives to provide on-line, accurate pricing to its customers. The program has the ability to provide "what if" pricing logic in order to provide the best order for the customer s money.

When a quotation has been input it can be automatically output, using OLE, into an MS Word formatted document that can be eMailed directly to the manufacturing facility in Phoenix for immediate lead-time and availability information.

The Zaur OB/GYN Group is a multi-doctor medical office that has decided to automate most of its internal procedures. Mr. Scott has developed the Physicians Desktop in Visual FoxPro for them. This system provides Patient Record information, Patient Encounter information, Appointment Scheduling, On Call Scheduling, Out of Office Scheduling, Internal Messaging, Individual To Do processing, Phone Book with auto dialing, and Prescription Writing for the office.

A recent enhancement, using MS Outlook as an automation server, allows the firm to automatically email the results of medical tests such as a PAP Smear to their patients.

The system is currently in use by Zaur OB/GYN and long term plans call for it to be marketed on a commercial basis.

NTA provides Advanced Training Seminars for the education community. Mr. Scott converted and enhanced parts of a legacy system written in FoxPro for Windows 2.6 into VFP 5.0. The system provides for registration and management of multi-day, multi-track educational seminars.

Rislen provides vertical market software to the Health and Athletic Club industry. They are currently in the process of a complete re-write of their system from FPW 2.6 into VFP 5.0 using Client/Server technology. Mr. Scott designed and wrote a full functioned Inventory Module for this new system that provides matrixed information i.e., Large, Small, Medium / Red, Yellow Brown and is fully integrated into a Point of Sale System.

The system is based around Client\Server technology and uses VFP s latest capabilities for ODBC, SQL, SQL Pass Through, and Parameterized Views to provide its functionality.

All of the reporting capabilities of this module were implemented using Crystal Reports.

DeBourne Properties provides Property Management service for 48 large apartment complexes in Northern California. Mr. Scott wrote the Full House Property Management system for them in VFP 3.0.

The system provides Credit Checking, Move In, Move Out, Work Order, Rent Roll, Cash Receipts, Accounts Payable, General Ledger and Management Reporting for each property.

Using DLLs Mr. Scott implemented an integrated communication facility that allows the Main Office to automatically query each of the properties each night and maintain a centralized database of current information from each property.

ISE provides on-site hospitality to corporations at major sporting events. Mr. Scott wrote a lead tracking and ticket and lodging management system for ISE to use at the 1996 Olympic Games in Atlanta, GA. The system provided automated synchronization of all data between the main office in Pleasanton, CA and a satellite office in Atlanta. The system also provided for on-line credit card processing.

Compact is a wholesale distributor of consumer electronics. In the spring of 1991 they decided to automate their operations. Mr. Scott was retained to become a pioneer in the utilization of database products and local area networking. The original system, developed in FoxBase, consisted of Order Entry, Inventory Control, Accounts Payable, Accounts Receivable, General Ledger, Purchase Orders, Receiving, Warehouse Management, UPS Interfacing, Bar Code scanning and printing, Cycle Counting and Physical Inventory, Picking, Packing, and the integration of Electronic Scales.

This system is still in use at Compact and controls the daily operation of the entire company. It is has since been enhanced to provide for the use of hand-held computers Telzon by its sales force and Radio Frequency transmission for inventory control.

In 1976 Mr. Scott resigned from Comstar Research to start up his own systems company, Jerry K. Scott Associates JKOA . JKOA developed software for the automation of large law offices. Modules included Time and Expense Billing, Accounts Payable, Accounts Receivable, General Ledger, Litigation Support, Docket Control and Word Processing. This software was sold and installed into over 50 major firms around the country and is still operating in many of these firms. Before the company was sold in 1986 it had grown to include over 20 programmers and customer support staff.

After his tour in the Air Force Mr. Scott joined Comstar Research, Inc., in Buffalo, New York, as a Project Manager for the development of Real Time Command and Control software for the U.S. Navy. In 1972 he moved to California and setup and managed a West Coach Branch of Comstar. This Branch had responsibility for the development of the Sensor Interface Data System SIDS modules for the Navy s Naval Tactical Data System NTDS . This Branch consisted of approximately 30 programmers and analysts who were managed by Mr. Scott.

As a Flying Officer in the Air Force Captain Scott logged over 2,000 hours of flying time. He was awarded the Distinguished Flying Cross and 12 Air Medals. He served tours of duty in Thailand during the Vietnam War and in Germany.

• Local Area Networking MultiUser Remote Communication
• Client-Server Remote Views Parameterized Views
• SQL SQL Pass Through ODBC
• Automation Servers DLL COM
• Object Orientation Data Compression Serial Device Interfacing
• Project Manager Class Libraries Low Level File Functions
• Designers Crystal Reports Internet Web Programming

• Property Management Distribution Warehousing
• Medical Office Legal Office Dental Office
• Aerospace Manufacturing Telemarketing Cable Television
• Health Clubs Service Bureaus Golf Clubs

• Order Entry Accounts Payable General Ledger
• Inventory Banking Purchasing
• Receiving Accounts Receivable Contact Management
• Point of Sale Caller ID Predictive Dialing
• Laser Check Printing Automated Check Reading Financial Reporting
• Litigation Support Docket Control Calendaring
• Bar Coding Electronic Scales Bill of Materials
• Physical Inventory Cycle Counting Dispatching
• Data Exchange Scheduling UPS Interfacing
• Credit Card Processing Picking Packing
• Proposal Preparation Reservations Move In/Move Out
• Work Order Control Water Meter Tracking SBT