A trucking and logistics client was a member of an industry group that shared some operational data among the members. This data took several days for an employee to compile from various reports, queries, and other sources around the company. They were looking for a way to compile that information more quickly and efficiently.
Harkening back to my Excel programming days at McDonald’s, I built a automated the spreadsheet to compile the data at the click of a button. There were several data points that still needed to be manually figured and entered. But the result was many saved hours of work on a monthly basis.
Skills: MS Office automation, database queries
Tools: Excel, MS Office VBA, SQL