Data Analyst · BI Developer · Full-Stack Developer · Hull, UK

Emmanuel Abolade

I turn business data into decisions, and decisions into working software.

I take operational and performance data from raw tables to a decision: clean it, define the KPI from the source field, check the grain before joining, and recommend only what the evidence supports. Then I build the tools that keep the answer in front of people: APIs, dashboards and full-stack applications.

10case studies with code or live evidence
6live apps, demos and prototypes
150automated tests passing in two featured apps
120ksupport tickets in one Power BI baseline
01 — What I do

Three strengths, one discipline.

Analysis and software share one standard: define the question, respect the grain, enforce constraints, and only ship claims the evidence supports.

02 — Selected work

Real projects, real evidence.

Selected analytics, BI and software projects. Figures come from the project repositories, published write-ups and live demos, and each card links to the source.

Event Travel Intelligence web app home screen with event selection and journey inputs over a map
Live demo
Full-stack · Decision intelligence

Event Travel Intelligence

A travel-intelligence platform for journeys to major UK events. Enter a starting point and an event to get route analysis, event-adjusted journey estimates, travel risk, Park & Ride options, an interactive map and overnight return analysis. Modelled conditions are clearly separated from measured live data.

  • Python
  • FastAPI
  • SQLite
  • JavaScript
  • Leaflet
  • OSRM
  • Nominatim
Outbound + returnjourney analysis incl. overnight
7 test modulesAPI, engine, live transport
Pages + Renderfrontend and API hosting
FastAPI Swagger documentation page (/docs) for the live Jobs API, showing the interactive OpenAPI interface
Live API · live-ready payments
Full-stack · Payments API

Jobs API with Stripe payments

A jobs-board API with a production-grade Stripe payment flow: hosted Checkout, signature-verified webhooks, idempotent recording and nightly reconciliation. The API is live; payments run in Stripe test mode and are ready to switch to live keys.

  • Python
  • FastAPI
  • PostgreSQL
  • psycopg
  • Stripe
  • Render
  • GitHub Actions
Hosted Checkoutcard data never on the server
Idempotent writesUNIQUE session id
Nightly reconcileStripe as source of truth
Power BI CEO overview for the restaurant financial analysis with sales, payments and trend visuals
Portfolio analysis
Data & BI · Financial controls

Restaurant Financial Intelligence & CEO Dashboard

Multi-unit hospitality financial analysis that surfaced a control gap, not just a dashboard. It became the grounding for the ControlDeck NG product UI.

  • Python
  • pandas
  • SQL
  • Power Query
  • Power BI
≈ ₦2.89bnrecorded sales
19,146payments without payee
Apr 2026expense records collapse
ControlDeck NG CEO Home screen with naira KPI cards, a revenue and expense trend and critical alerts
Proof of concept · live
Full-stack · BI product UI

ControlDeck NG — Executive BI Dashboard

The restaurant analysis turned into a product surface: CEO Home, Financial Control Centre, Sales, Cost & Profitability, Inventory, Purchasing, an AI assistant with demo responses, and alerts. Mock data shaped by real findings.

  • React 19
  • TypeScript
  • Vite
  • Tailwind
  • Recharts
8 screenssingle-page app
₦2.888Bgrounding sales figure
Mock datano live POS feed
Public homepage of the church website with a plum and gold design and a Plan your visit button
Live public site
Full-stack · Auth, roles & realtime

Church Website & Presence Platform

A Next.js 16 and Supabase platform for a church in Hull: a public visitor website, sign-in for members, role-scoped pastor, admin and media areas protected by row-level security, and a projector display updated in real time from the media dashboard.

  • Next.js 16
  • React 19
  • TypeScript
  • Supabase
  • Postgres RLS
  • Realtime
  • Vercel
33 testsauth, session and roles, passing
4 signed-in areasmember, pastor, admin, media
Realtimepresentation display
CV Analyzer Streamlit interface showing the evidence matrix
Completed & tested
Software · Applied AI (guarded)

CV Analyzer & Job Match Optimizer

Matches a CV against a real job description with a traceable evidence matrix and gap analysis. An optional AI phrasing layer is checked after the fact and rejected if it adds anything the CV cannot evidence.

  • Python
  • Streamlit
  • pdfplumber
  • reportlab
  • pytest
117 testspassing locally
CLI + webone shared engine
DOCX / PDFreport export
Olist delivery SLA analysis chart of late-delivery rates
Portfolio analysis
Data & BI · SQL Server

Olist Marketplace — Delivery SLA & Seller Sizing

Public Kaggle e-commerce data analysed in T-SQL and cross-checked in Python, with a recommendation targeted at the sellers driving late volume.

  • SQL Server
  • T-SQL
  • Python
  • Tableau
96,470delivered orders
6.77%late-delivery rate
44%of late orders >8 days
CloudDesk Power BI executive overview of support resolution times
Portfolio analysis
Data & BI · Statistics

CloudDesk — Support Root Cause

Hypotheses on documentation, reassignment, team and category tested against resolution time, CSAT and renewal.

  • Python
  • pandas
  • statsmodels
  • Power BI
2,400tickets
7.80 hmedian resolution
4.52average CSAT
Nigeria at 66 Power BI dashboard with KPI cards and a 1960 to 2025 trend
Completed analysis
Data & BI · API to Power BI

Nigeria at 66 — World Bank Data Story

World Bank API extraction in Python, pandas validation and a one-page Power BI story.

  • Python
  • requests
  • pandas
  • Power BI
7 × 4indicators × countries
1,848rows prepared
1960–2025coverage
03 — How I work

From raw tables to running systems.

Analysis that stops at a slide deck leaves the operational problem unsolved; software that ignores grain and validation invents confidence.

01

Question

Start from the business decision, not the chart. Clarify users and non-goals.

02

Data

Profile source tables, document grain before joins, keep exclusions auditable.

03

Insight

Define KPIs from source fields and cross-check findings in more than one tool.

04

Decision

Recommend actions only where the evidence is strong enough to act.

05

System

Build the product: entities and constraints first, then UI, tests and deployment.

Analytical practice

  • Start from the business decision, not the chart.
  • Profile source tables and document grain before joins.
  • Clean and validate with explicit rules; keep exclusions auditable.
  • Define KPIs from source fields, not preferred narratives.
  • Cross-check findings in more than one tool when the stakes are high.

Data → software

Restaurant financial analysis became ControlDeck NG, a product UI over the same control gaps. Booking demand became Bibiunique: an availability API, a unique slot constraint and admin approval instead of inbox chaos. A church’s Sunday logistics became a role-based platform with a realtime projector display.

04 — Experience

Experience

Data analysis roles in the UK, alongside independent software projects.

2025 – Present
United Kingdom

Data Analyst

Amdari

  • Analyse business datasets to identify trends, patterns and performance gaps using Excel, Power Query, SQL, Python and R.
  • Develop analytical reports and dashboards in Power BI and Excel; build KPIs and performance metrics.
  • Query structured and relational datasets using SQL, including a three-table NHS A&E analysis.
  • Present findings to stakeholders via dashboards, reports and stakeholder meetings.
2024 – 2025
United Kingdom

Data Analyst

Pinntech Ltd

  • Cleaned and transformed data using Excel, Power Query and SQL; performed validation and quality checks.
  • Queried and aggregated relational data, including a 191-row NHS A&E activity dataset.
  • Built PowerPoint presentations and presented directly in stakeholder meetings.
Current
Remote

Freelance

Data Annotation, Outlier AI, Handshake

  • Light, ongoing freelance work in data annotation / AI evaluation and full stack development tasks.
05 — Skills

Tools, mapped to evidence.

Each skill is mapped to the public project that shows it on the skills and evidence page.

Data & BI

  • SQL Server
  • SSMS
  • Excel
  • Power Query
  • Power Pivot
  • Power BI
  • DAX
  • Python (pandas)
  • R
  • Tableau
  • Looker Studio
  • BigQuery

Frontend

  • HTML5
  • CSS3
  • JavaScript (ES6+)
  • TypeScript
  • React
  • Next.js
  • Tailwind CSS
  • Recharts
  • Vite
  • WebGL

Backend

  • Node.js
  • Next.js API routes & server actions
  • REST APIs
  • FastAPI
  • NextAuth
  • Supabase Auth
  • Prisma
  • Zod validation
  • Resend email
  • Python (CLI / Streamlit apps)

Databases

  • PostgreSQL
  • Supabase (RLS, Realtime)
  • SQL Server
  • SQLite
  • Prisma schema & migrations

Engineering practice

  • Git / GitHub
  • pytest
  • Node test runner
  • VS Code / Cursor
  • Jupyter
  • Vercel
  • Render
  • GitHub Pages

Analytical practice

  • Data cleaning & validation
  • KPI definition
  • Grain checking
  • EDA
  • Root-cause analysis
  • Regression
  • Evidence-based recommendations
  • Stakeholder presentation

Applied AI: an optional, guarded LLM phrasing layer in CV Analyzer (OpenAI-compatible API, output verified against the evidence and rejected if it adds claims). Cloud (learning): AWS analytics and data-engineering learning paths (S3, Glue, Athena, Redshift, Bedrock), a training environment, not production experience. Full Stack JavaScript certified (The Odin Project).

06 — More work

The wider archive

Smaller builds, prototypes, training simulations and earlier analyses. Additional SQL, Python and course repositories are on GitHub.

Bibiunique Booking

Next.js · TypeScript · Prisma · PostgreSQL · NextAuth · Resend

Appointment scheduling MVP for an independent makeup artist business: public pages and Book flow, an availability API, duplicate start-time prevention (unique Booking.startsAt), admin login to approve or cancel bookings and manage services, and confirmation emails.

MediaSuite (MediaDesk) prototype

React · TypeScript · Vite · Tailwind CSS

Interactive browser prototype for an all-in-one media production and church presentation workspace: media library, songs and lyrics, service planner and a preview-to-live projection flow. A proof of concept, not the final desktop application.

GreenTech Manufacturing Downtime Analysis

SQL Server · Power BI · Excel · Power Query · DAX

645 batches and 885 downtime events analysed; 56.3% batch delay rate, with Cleaning/Sanitation the leading cause (86 incidents).

E-commerce Orders — Cleaning, EDA & SQL

Python (pandas) · SQLite · matplotlib

The same 1,200-order dataset across cleaning, SQL analysis and explanatory charts: 41% of orders cancelled or returned, $519,674 of revenue not collected.

Daikibo Industrials — Deloitte job simulation

Forage · Tableau · Excel

Training simulation (Forage / Deloitte Australia), not employment. Factory device downtime analysis and a Tableau dashboard with factory-to-device drill-through. Completed August 2026.

DecodeLab — Order cleaning & EDA

Python · pandas

Cleaned 1,200 e-commerce orders (types, dates, coupon fill, total checks) and documented distribution and status findings.

RCCG Games Day Coordinator Portal

HTML · CSS · JavaScript

Lightweight client-side portal: enter a first name to see an assigned role for a games-day event. A front-end utility, not a full-stack application.

07 — Currently building

Work in progress

An active development track: work in progress, not finished portfolio claims.

NHS A&E Operational Performance Analysis

Analysing NHS England public A&E monthly data against the 78% four-hour target, using SQL Server and Power BI.

Continuously developing

  • Full-stack delivery on real business workflows (booking, roles, persistence, deployment).
  • Turning analytical findings into usable product surfaces.
  • Test coverage and evidence discipline in my own tools.
  • AWS analytics and data-engineering learning paths (training environment, not production experience).
08 — Contact

Have data that should be driving decisions?

I’m open to data analyst, BI developer and full-stack developer roles. The quickest way to reach me is email; my LinkedIn and GitHub carry the rest of the story.