John, of PC Professionals, grew up in Scottsdale,
AZ. and worked as a mechanic/welder/construction worker until
the late 70's. He's been programming since the the early 80's.
He
started on Apple IIe/Atari
6502 assembly
and basic, then moved onto the Osborne/Kaypro and CPM/MPM OS. He
worked at Digital Concepts in Scottsdale/Tempe, AZ. as
a salesman/programmer. He moved to the Hartford, CT. area in 1983,
attended Manchester
Community College for Systems Design & Analysis, Cobol plus
Accounting I - II classes. While attending school and working as
a Service
Advisor/Mechanic at Manchester Honda
wrote
a service
scheduling program (in dBase III, Clipper and C) which in turn
got him a position with Digital Dimensions Computer Consulting.
After
a
couple
of
years
of consulting
he went out on his own to create PC Professionals. His clients
ranged from the Automotice & Motorcycle Services to Legal and
Medical offices. His main area of expertise became transportation,
working
as a consultant for ADVO Inc. and TransAdvo Inc. for a period of
12 years. In this time he, along with his employees became proficient
at developing real time dispatching systems written primarily in
Clipper
with
C calls to the Novell OS for semaphore record/file locking, print
services, etc. ADVO Inc. hired PC Professionals in 1990 to develop
the transportation system needed for its 20 mail distribution warehouses
countrywide. The systems, 'Transport' and 'Drop Ship' were needed
in order
to take advantage of the USPS's dropship system just implemeted.
In 1991 the USPS started a program for mass mailers to obtain postage
breaks based upon the location mail entered the postal system.
'The PC Professionals Transport' system took care of the
dispatching
functions and connectivity to their
AS400
systems.
The 'PC Professionals Drop Ship'
system
maximized
the savings
offered by the USPS dropship program. 'PC Professionals Drop Ship'
analyzed the postal costs vs. transportation costs and using a
3rd party software program also showed ADVO how to load and route
their trucks to maximize transportation costs. John also designed
and implemented an online mail tracking program for TransAdvo
long before UPS or FedEx had theirs. In the
mid
1990's John also help write systems for Sony of America and
ABB
Combustion
Engineering, Nuclear Spare Parts Division. In 2003 John designed
a quote/receive/ship/bar code/po
system for Unas Grinding Corp. of E. Hartford, CT. written in .NET
Basic
and
SQL
2000 with a number of components to FAA specs.
Service Dispatching System
for Manchester Honda, Manchester, CT.
PC Professionals were responsible for the
design, installation, and training of the original
service dispatching system written in dBase III for
the motorcycle division in 1983.
This system was a Novell
LAN.
Dispatching Systems for ADVO
Inc., the largest direct mailer & USPS customer in the country.
PC Professionals was responsible for the software
design, installation, training, and on going maintenance
of the
'Transport' and 'Drop Ship' systems from 1990 until
2001.
These systems are small Novell LANs, running
'PC Professionals Transport', connected to an IBM 3090 via
AS4OOs' for access to
the production data needed.
Inventory System
for ABB Combustion Engineering, Nuclear
Spare Parts Division.
John worked for Classic Systems
Design to help develop a Nuclear Spare
Parts Inventory system written in Magic
in 1995.
Interface
to the Stillstore System for the broadcasting division
of Sony.
John worked with Tom Hannum
Consulting Services to design 'The Stillstore Database
System. The Sony StillStore is a piece of Sony hardware
that captures and stores
still
(picture) information
to be later used by production houses, news broadcasting.
etc. Our software downloads these stills and catalogs
them to a database
on an OS/2 workstation or a Netware LAN for access by production
house personnel. Sony of America has chosen to market
our software
instead of the Japanese version of the Stillstore software
because of its flexibility. Sony of Canada and Sony of
Europe have recently
expressed interest in doing the same.
Ship/Receive
System for Unas Grinding of E. Hartford.
In 2003 designed a ship/receive system for Unas Grinding
Corp. of E. Hartford, CT. written in .NET Basic and SQL 2000
with a number of components to FAA specs. This system takes care
of job quoting, receipt of serialized aircraft parts, job description,
job ticket creation, scheduling, bar code labeling, and shipping.
It tracks
employee time and grinding wheel wear and all quote/job associated
reporting. A PO module is also implemented.
Programming Languages:
dBase/Clipper/C Microsoft .NET/SQL 2000 Dreamweaver
UltraDev MX/Fireworks MX Liquid Edition for Video/DVD production
Operating Systems:
NetWare 86 to 5.1 Microsoft Windows 3.X to Windows XP/Windows
Server 2003
AS400
Software design and Video production for
the web or desktop.