I build small, complete data/automation projects to demonstrate practical skills for tech apprenticeships, currently applying across three tracks:
- Data & AI — SQL, Python, dashboards, pipelines
- Network / Infrastructure Engineering — troubleshooting, connectivity, documentation
- IT / Digital Support — workflow automation, triage, technical communication
Every project below is built to be finished, not a fragment — each has a working script, a real dataset or API, and a README explaining the decisions behind it.
| Project | What it shows |
|---|---|
| Cyclistic Bike-Share Analysis | 5.4M rows in BigQuery, SQL analysis → business recommendations. Live site |
| Equity Portfolio Risk Analytics | End-to-end pipeline: ingest → metrics → SQLite → charts → risk analysis |
| UK Transit + Weather Pipeline | Two live APIs → DuckDB → Streamlit, scheduled hourly via GitHub Actions |
| Project | What it shows |
|---|---|
| Home Network Commissioning Lab | Structured troubleshooting: topology docs, DNS/connectivity testing, traceroute, root-cause writeups |
| Cyber Incident Triage Toolkit | Rule-based alert classification, escalation logic, incident reporting |
| KEV-first Vulnerability Prioritizer | Prioritizes by exploited-in-the-wild status (CISA KEV) over raw CVSS score |
| Project | What it shows |
|---|---|
| AI Workflow Support Dashboard | Enquiry triage, prioritisation, and structured logging for manual admin processes |
| Apprentice Project Builder | Parses a CV, finds skill gaps vs. live job data, suggests tailored projects. Live app |
| API-to-Database Integration | Flask REST API with full CRUD, SQLite, input validation |
| CarIQ CLI | CLI tool: vehicle valuation + profit-margin analysis logic |
Languages: Python, SQL, JavaScript, Java Data/Analysis: pandas, DuckDB, BigQuery, Power BI Web: Flask, Streamlit Tools: Git, GitHub Actions, VS Code, Linux
Google Data Analytics · Cisco Introduction to Cybersecurity · Deloitte & KPMG virtual experience programmes
📬 Reach me on LinkedIn