A local real estate agency purchased a Perl-based commercial real-estate listing management package and purchased a commercial realty office management software that used Microsoft Access with a Visual Basic back end. Agency wanted to integrate those two products and expand on functionality of online version. Met with principles of agency, and setup deliverables, timeline and budget. Lead DBA and programmer for project able to exceed client expectations and setup a new data-driven website that agency claimed was responsible for becoming the dominant agency in the region. Agency expanded and became so busy that office managers could no longer keep up with the number of new houses being entered into database. Agency then asked to automate addition of listings by adding EDI between Paragon MLS system, third-party web-mapping service, and existing commercial systems. Successfully implemented system allowing both import from MLS system and updates from office managers.
Required a complex integration of UNIX bash scripts, Windows wscript scripts, Perl data munging, PHP scripts, and Kermit ftp scripts.