At DIRECT TYRE MANAGEMENT LTD, I moved reporting from Excel to Power BI as the business prepared for acquisition by Caledonia Private Equity. I worked with C-suite executives to define project MVPs and delivered finance and operational dashboards.
I developed the Azure SQL data model and warehouse, creating SQL tables, views, procedures, and functions. I also documented data flows and models for Snowflake and mentored junior staff on T-SQL.
At SNOWFOX GROUP, I built and maintained a central SQL Server data warehouse, bringing together data from internal systems and external sources. I also created ETL packages and used Python to extract data from a REST API.
On my Hospitality Analytics Medallion Project, I built a Bronze–Silver–Gold solution in Microsoft Fabric using pipelines and PySpark notebooks, then developed Power BI dashboards for revenue, labour costs, and profitability by location.
