My role as an IT consultant, required the ability to create complex spreadsheet including tracking tools as well as cost models that helped Senior Executives understand the costs of new initiatives. This required extensive work with Microsoft Excel and Access to design ways to capture and analyze data from diverse sources and report the information in an understandable format. Using advanced Microsoft Excel automation techniques, including VBA, the system automated repetitive tasks and generated informative charts and graphs. One example was my work for a large satellite TV provider, using Access and Excel to analyze alerts captured from email. Using VBA to capture and parse mail messages, the tool was able to graphically demonstrate the impact of an increased workload on response time. This allowed my client to quickly identify problem areas in their process. With the new information the client recognized that they needed to reduce complexity or increase staff. They increased staffing and reduce the response time on outages by 48%. More recently a small business owner asked me to automate a spreadsheet used to generate weekly and monthly performance statistics (KPIs). The client was able to clean up his data and create accurate reports so he could see improvement over time.