London, United Kingdom

AliAbdo

Turning raw operational data into clear, actionable insight โ€” across SQL, Excel and Power BI dashboards, statistical analysis, and full-stack data projects built end to end.

View selected work Get in touch Download CV (PDF)
4+Projects
2+Years Experience
10+Technologies
Data AnalysisSQLPower BI ExcelPythondbt Statistical TestingFull-Stack Development
01

Experience

Where I've worked

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

Data Analyst
Scafflinq โ€” Remote
  • Built and maintained Power BI dashboards to monitor business performance, customer activity and platform usage.
  • Used SQL and PostgreSQL to extract, join and aggregate data for recurring reports and ad hoc analysis.
  • Developed ETL workflows to consolidate application, billing and CRM data, processing API and JSON data and automating preparation with Python and pandas.
  • Cleaned and validated data through deduplication, missing-value handling, standardisation and reconciliation; investigated reporting discrepencies.
  • Analysed onboarding funnels, custom cohorts, feature adoption and engagement, including usage before and after product releases.
  • Tracked subscription revenue, active tag usage, customer retention and churn to support commercial decisions.
  • Analysed onboarding funnels, customer cohorts, feature adoption and engagement, including usage before and after product releases.
  • Worked with product, sales and customer support stakeholders to define KPIs, respond to data requests and present findings and recommendations.
  • Documented data sources, metric definitions and transformation logic; maintained SQL queries and analysis scripts using Git.
02

Education

Foundations

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

Royal Holloway, University of London
BSc Computer Science โ€” First-Class Honours
Software Engineering ยท Algorithms and Complexity ยท Security Management ยท Operating Systems ยท Database Systems ยท Project Management
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
03

Selected Work

What I've built

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

01

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 โ†—
02

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 โ†—
03

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 โ†—
04

GravityIQ โ€” Football Analytics Platform

ReactNode.js
  • Built a full-stack analytics platform combining data from multiple sources into a single analytical view.
  • Designed an original statistical metric (the Gravity Index).
  • Built interactive dashboards and visualisations (radar charts, positional maps) to present findings clearly.
3core technologies
View Repository โ†—
04

Certificates

Recognition & learning

Structured, verified learning alongside hands-on project work.

2026
Data Analysis with SQL, Excel & Power BI
Microsoft
2026
Data Science Job Simulation
British Airways (via Forage)
05

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

08
SQLExcelPower BIPythonRdbtStatistical TestingData Cleaning & Validation

Languages

07
PythonJavaDartJavaScriptSQLRHTML/CSS/Sass

Frameworks & Tools

07
Git/GitHubReact/Next.jsNode.jsFirebaseMongoDBVS CodeFigma

Process

02
SCRUMAgile
06

Get In Contact

Let's talk data

Open to data analyst roles in the UK and Australia โ€” happy to talk through any of the work above.