Customer Solution:
Computer Programmer
Walnut Creek Company
April 2007 - August 2010 -
Walnut Creek, CA
Developed custom applications are requested using Outlook,
Access and VB - Contract work at random times over 5 years
Skills: ASP, Outlook, VBA, Web
HTML, ETL, SQL Server 7/2000/2005, Microsoft Word 2003
Developed custom connectors by integrating VBA, MS Access, VB, with Outlook VBA that processed zipped files that arrived as attachments for daily reports, files and datasets. The MS Access program monitored Outlook via the library, then processed the attachments by unzipping, reading the files, parsing the headers then reformatted the data for Yardi Systems General Ledger property management module.
The client was consuming several hours per day for a daily task that was very tedious that few in the offices wanted to deal with. The net savings in man hours was about 16 to 20 hours per week or the equivalent of part time employee's salary.
Net savings in a professional office was significant enough to justify project.
Payroll Savings: $15,000
Project Cost: $4,000
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.