A car dealer had an ADP DMS access via "Reflections" and remote access only via modem. I was approached by a company with the problem that nightly updates were being done by hand to pull from the ADP system in order to upload them to a web server. This was a complex problem requiring scripts in Windows, ADP “English statement” scripts, Reflections Visual Basic Macros, and finally a bash/PHP script to move the downloaded data into a MySQL database. Met with client and setup a completely automated system. The end result was a system that completely eliminated user interaction saving hundreds of person-hours and allowed client to take system to multiple car dealers with a working and automated system.

This project was essentially the beginning of automated online car dealer pages and a company launched to sell that system to car dealers.