Skip to main content

Automating Car dealer ADP System to Web Sites

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.

4-ISP Linux firewall

1999:

Called in to take over networking issues that prior consultants were unable to solve.

After purchasing two competitors, the client was required to maintain connections to the internet and required by vendors have direct WAN connections to 3 third-party vendor networks.

Client had a complex routing issue consisting of multiple Cisco routers, multiple digital lines, managed switches, fiber repeaters, a satellite connection, and the local network.

Mobile (Android) Routing Ap

Led team to build demo mobile traffic and travel ap.

Application recorded a users driving via GPS probe points and then used
real-time traffic data to estimate travel time over the routes that were recorded.

System was used as the framework for a system built later for Fortune 5 automotive company.

Enterprise Architecture for Fortune 5 Company: Web/voice/mobile/traffic/routing application

Demo:

Led team in Sprint that in two weeks had designed system to build fully functional in-car demo for one of the world's largest companies integrating web, voice (VXML), traffic, phone and mobile application.  Assisted with sales for final demo which used real-time, in-car, routing, voice-activated system using potential client's in-car, voice-activated system. Stepped in to program the voice activated system leveraging VXML tools when team ran into difficulty. 

Full system:

Subscribe to Automotive