Highly skilled and analytical SQL Data Analyst & Data Modeller with expertise in advanced statistical analysis, Machine Learning, BigQuery and data modelling. Proven experience delivering data transformation, complex SQL interrogation and business data modelling across energy, financial and academic environments. Proficient in designing and maintaining ETL pipelines, performing data discovery and root cause analysis. Expert in translating ambiguous business requirements into structured, scalable data solutions.
A strong problem-solver with a solid command of data extraction, transformation and visualisation, I am adept at data mapping, documentation and applying business rules to develop clean and reliable data models. Skilled in tools such as SQL, R, MS Excel, Python, Power BI and Tableau, with a keen eye for data quality, governance and process optimisation.
I bring excellent communication skills and the ability to present complex analytical findings to both technical and non-technical audiences, supporting evidence-based decision-making at all levels. Passionate about uncovering actionable insights and trends. I combine technical expertise with strategic thinking to drive business value through data.
          This project examines the impact of the COVID-19 pandemic on trends in mental health services in Scotland. It focuses on immediate and long-term shifts in psychiatric admissions, demographic disparities and regional variation. Using high-frequency, population-level data from Public Health Scotland and NHS Scotland (2018-2023), the study employs reliable quasi-experimental methods, Interrupted Time-Series (ITS) analysis and Mixed-Effects Regression modelling, to measure both sudden and sustained changes in service utilisation and diagnostic patterns. Interactive Shiny dashboard visualizes findings, informs policy and resource allocation. The ShinyApp facilitates stakeholder engagement, real-time monitoring, evidence-based decision-making and targeted interventions.
          This end-to-end data analytics project explores the drivers of daily road collisions over eight years, combining exploratory analysis with two predictive modelling approaches: Linear Regression and a Deep Neural Network (DNN). Implemented entirely in Python on Google Colab, the project demonstrates proficiency in data cleaning, feature engineering, statistical analysis and TensorFlow-based model development.
This project illustrates a full analytics lifecycle from data ingestion and exploratory visualisation to advanced predictive modelling. It delivers actionable insights into collision dynamics. The combination of statistical rigour and machine learning sophistication makes it a compelling showcase for both data science and applied analytics roles.
          This Power BI dashboard explores sales and profitability for Classic Models Ltd, a retailer of collectible vehicles. It provides an interactive view of global performance from 2003 to 2005, helping managers identify profitable regions, products and customers.
Users can filter by year, month, product line or country to explore trends and compare performance. Designed entirely in Power BI Desktop, this project demonstrates strong skills in data modelling, DAX measures and storytelling with visuals. It turns raw sales data into actionable insights for operational and strategic decision-making. The analysis highlights the USA and France as leading markets and shows that Classic Cars consistently drive the highest profit. The dashboard illustrates how clear data visualisation can guide evidence-based business decisions and improve sales planning.
          This Tableau project presents an analytical overview of electric vehicle (EV) adoption across Washington State. This highlights trends by vehicle make, model, type and geographic distribution. The dashboard integrates registration and ownership data to help policymakers, researchers and businesses understand patterns in EV usage and infrastructure needs.
The analysis focuses on Battery Electric Vehicles (BEV) and Plug-in Hybrid Electric Vehicles (PHEV), identifying Tesla, Nissan and Chevrolet as the leading manufacturers. Users can explore data interactively by county, year and vehicle type, gaining insight into how EV adoption has evolved from 2014 to 2023. Geographic maps reveal concentration hotspots such as King, Snohomish and Pierce counties, which collectively account for the highest EV ownership.
This is built entirely in Tableau Desktop, the dashboard demonstrates strong capability in data visualisation, geospatial analysis and interactive storytelling. It transforms complex datasets into an accessible, evidence-based tool for promoting sustainable transport and supporting data-driven policy decisions. This project showcases how visual analytics can bridge the gap between environmental data and actionable insights for a greener future.
          R is one of my core languages for analysis and modelling. I use it to clean large datasets, run advanced statistical tests and build predictive models. I also develop interactive dashboards in R Shiny so stakeholders can explore real-time insights.
          I turn complex data into clear, decision-ready visuals. From KPI dashboards and time-series trends to categorical comparisons, I design visuals that tell a compelling story and drive action.
          I write robust SQL for extraction, transformation and performance-minded joins and build reusable queries and views. Experienced across MySQL, PostgreSQL and BigQuery designing efficient data models and pipelines.
          I translate analysis into strategy, clear recommendations, crisp reports and confident presentations for both technical and non-technical audiences.
          Advanced Excel for rapid analysis and automation: dynamic dashboards, complex formulas, PivotTables and VBA macros to streamline recurring reports and data wrangling.
University of the Highlands and Islands - August 2025
University of the Highlands and Islands - June 2023
Delft University of Technology (edX) - July 2017
Pontifical Urban University - June 2006