Local Australian with extensive CRM/excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in Australia/globally (eBay, Groupon) creating automated solutions to drive optimisation. It is part of my day job to create reporting functions to oversee business areas and give greater visibility to the senior leadership team of performance.
I know how build a process framework that makes most sense, and posses the skill to execute. I have set up countless databases for companies, extracting data from various sources and formats into excel, categorically redirected the data to different master files depending on relevant criteria. The data can then manipulated in a format that could be analysed to your needs, and exported, even emailed, straight from excel. To accompany this, I created a dynamic dashboard linked to the database which displayed key metrics, KPI achievements, and could be altered by the user. I can build all the functionality you need into a program scripted within excel.