Daily data downloads from the Wizard of Avis are processed to provide up-to-date profit and loss analysis by rental station. Handles long term rentals, maintenance, insurance claims, and traffic court fine tracking. Exports receivable and payable information for internal accounting software. Project involved a race to replace a failing IBM mini computer.
The bio technology field requires quality control over constantly changing manufacturing, testing, packaging, and distribution procedures. The FDA constantly monitors every operation. Every procedure from how to test to what is placed on product label is documented in writing from the original and every revision through document obsolesence. In case of FDA investigations or legal actions this document history is crucial.
This multi-user system provided hierachical document tracking by division and function for all employees. This included each person writing, revising, approving, training, and trained on the procedure.
The system provided statistical analysis to determine how often procedures changed. It helped tracked operational problems to document activity. Over 3 work years from design through testing — accomplished in 1 calendar year.
AT&T needed to track and report employee time and expenses for a major government military projects DSREDS and EDCARS.
DSREDS is the Army’s Digital Storage and Retrieval Engineering Data System
EDCARS is the Air Force’s Engineering Data Computer Assisted Retrieval System
EDCARS is the Air Force’s Engineering Data Computer Assisted Retrieval System
The system produced the bills to the government. A major feature of the system was its budget variance reports produced to defend government audits.
Management also received detailed reports by type of service, department, by employee, and several other variables.
The system was multi user on a network and was optimized for fast data entry.
In 1992, Lon wrote and self-produced a 3 hours training video on Paradox database programming. The course became internationally known and sought as far away as India and South Africa.
Lon began working with CALC teaching Rbase 4000, a database like dBase.
Lon designed the Rbase course and later CALC´s Paradox, and dBase IV courses.
Courses ranged from beginner to advanced programming.
1986-92
Seminar Presenter
Lon participated in the AMA computer program in NYC. Lon designed their courses on Symphony. Symphony was Lotus´s spreadsheet, wordprocessor, database, and communications package. Lon also taught Lotus 1-2-3 and dBase courses.
Lotus version 2.4 courseware developer
Lon also designed the AMA´s Lotus version 2.4 courses
American Management Association Web Site
1986-91
ECN was one of the first private personal computer training schools in the United States. Lon was one of the first instructors.
1986-90
Early in the days of two floppy personal computer, taught Lotus 1-2-3, Symphony, and dBase and created course materials hard to find at the time.
More recently participated in their Web Master´s certification program teaching courses including HTML, Javascript and Web Design.