I am an expert with over 20 years' experience designing and building complex reporting, financial models, scorecards/dashboards, automations, data pipelines, and business intelligence tools.
I have designed many Excel files and Access database applications that integrate with various data sources and export destinations (SQL Server, Oracle, SharePoint, Power BI, Excel, flat files, etc.). I specialize in building forms, queries, and automations to help simplify repetitive and highly complex processes.
Additionally, I have created many Power BI models and reports, as well as apps to house them. I am well versed in SQL, DAX, M, and VBA code.
I can work with your vision to develop a framework and impactful reporting.
- VBA/Macro Automation
- Scenario building (what-if)
- Data entry/cleansing/normalization
- PowerPivot,PowerQuery, PowerAutomate
- Python scripting (Pandas, Selenium browser automation, file management, etc.)
- Command line scripting
- Just about anything needed - please reach out.