Ali Abdo — Data Analyst

Experience

Where I've worked

Hands-on data work inside a live product team, turning operational records into dashboards people actually use.

Jun 2024 — Jul 2026

Data Analyst

Scafflinq — Remote

SQLExcelPower BIData Quality

Assisted with data collection, cleaning and analysis of customer, operational and inspection datasets using Excel and SQL.
Supported the development and maintenance of Power BI dashboards to track key operational and customer KPIs.
Analysed inspection and compliance data to identify trends, anomalies and overdue records.
Prepared regular reports and data summaries for Operations, Product and Management teams.
Conducted data quality checks to identify missing, inconsistent or inaccurate records.
Worked with cross-functional teams to support ad-hoc analysis and data-driven process improvements.

Education

Foundations

A First-Class trajectory grounded in computer science fundamentals, built on an IT foundation from college.

Sep 2023 — Jul 2026

Royal Holloway, University of London

BSc Computer Science — First-Class Honours

Software Engineering · Algorithms and Complexity · Security Management · Operating Systems · Database Systems · Project Management

Sep 2021 — Jul 2023

Uxbridge College

BTEC Level 3 National Extended Diploma, Information Technology — D*DD

Creating Systems to Manage Information · Big Data and Business Analytics · Cyber Security · IT Service Delivery

Selected Work

What I've built

Independent projects spanning reporting, data engineering, statistical analysis and full-stack development.

Retail Sales & Customer Insights Dashboard

SQLExcelPower BI

Cleaned and modelled a public retail transactions dataset using SQL, structuring it for reliable reporting.
Built an interactive Power BI dashboard surfacing sales trends, top-performing products and customer segments.
Documented data sources, assumptions and refresh logic for reproducibility.

3core tools

View Repository ↗

Data Pipeline & Transformation Project

dbtSQLPostgreSQL

Built a dbt project transforming raw relational data through staging and modelled layers into clean, tested tables.
Wrote SQL-based data tests and documentation to ensure transformation reliability.
Applied version control (Git) throughout to track model changes.

dbttransformation framework

View Repository ↗

Marketing Campaign A/B Test Analysis

PythonpandasStatistical Testing

Analysed a public A/B test dataset using Python and pandas to compare campaign performance.
Applied hypothesis testing to determine statistical significance of observed differences.
Presented findings and a clear recommendation in a written summary.

A/Bexperimental analysis

View Repository ↗

GravityIQ — Football Analytics Platform

ReactNode.jsPython

Built a full-stack analytics platform combining data from multiple sources into a single analytical view.
Designed an original statistical metric (the Gravity Index) and validated it using regression and hypothesis testing.
Built interactive dashboards and visualisations (radar charts, positional maps) to present findings clearly.

3core technologies

View Repository ↗

Skills

Everything I work with

A toolkit built for data work end to end — from raw records to a dashboard someone else can trust.

Data & Analytics

SQLExcelPower BIPythonRdbtStatistical TestingData Cleaning & Validation

Languages

PythonJavaDartJavaScriptSQLRHTML/CSS/Sass

Frameworks & Tools

Git/GitHubReact/Next.jsNode.jsFirebaseMongoDBVS CodeFigma

Process

SCRUMAgile

AliAbdo

Experience

Where I've worked

Education

Foundations

Selected Work

What I've built

Retail Sales & Customer Insights Dashboard

Data Pipeline & Transformation Project

Marketing Campaign A/B Test Analysis

GravityIQ — Football Analytics Platform

Certificates

Recognition & learning

Skills

Everything I work with

Data & Analytics

Languages

Frameworks & Tools

Process

Get In Contact

Let's talk data