|
The Work I build Python, Django, SQL, and dbt analytics tools that transform operational data into reliable, decision-ready outputs — KPI dashboards, BI-ready exports, tested dbt models, and data-quality-checked reporting across FX and FinTech domains.
|
The Evidence
|
╔══════════════╗ ╔══════════════════╗ ╔══════════════════╗ ╔══════════════╗ ╔═════════════╗
║ RAW DATA ║────▶║ STAGING (SQL) ║────▶║ dbt TRANSFORM ║────▶║ MODELS ║────▶║ DASHBOARDS ║
║──────────────║ ║──────────────────║ ║──────────────────║ ║──────────────║ ║─────────────║
║ CSV Exports ║ ║ Clean & Type ║ ║ Business Logic ║ ║ Curated Data ║ ║ BI Exports ║
║ APIs · Files ║ ║ Validate & Dedup ║ ║ Test & Document ║ ║ Trusted Data ║ ║ KPI Reports ║
╚══════════════╝ ╚══════════════════╝ ╚══════════════════╝ ╚══════════════╝ ╚═════════════╝
│ │ │ │ │
DataBridge BakeOps SQL bakeops-dbt bakeops-dbt BakeOps
Market API Evidence Layer staging models mart layer Intelligence
bakeops-dbt |
|||||||||||||
| Layer | Models | Purpose |
|---|---|---|
| Staging | stg_orders · stg_order_items · stg_snapshot |
Clean · type · validate |
| Intermediate | int_product_revenue · int_product_margins |
Join · compute margins |
| Mart | mart_product_performance · mart_rank_inversion |
Rank · insight · action |
Django app ──▶ SQL evidence layer ──▶ dbt mart
Local DuckDB only — no cloud warehouse, no orchestration, no production claim.
mart_rank_inversion — live output
SELECT cake_name,
revenue_rank,
waste_adjusted_margin_rank,
margin_rank_gap,
has_rank_inversion,
action_flag
FROM mart_rank_inversion;┌──────────────────┬──────┬──────┐
│ cake_name │ rev │ marg │
├──────────────────┼──────┼──────┤
│ Birthday Classic │ 1 │ 4 │
└──────────────────┴──────┴──────┘
margin_rank_gap → 3
rank_movement → -3
has_rank_inversion → 1
action_flag → review
Revenue #1 drops to margin rank #4. Rank inversion confirmed.
Birthday Classic: revenue rank #1 → margin rank #4 after waste. |
Manual and advisory — no auto-apply, no scraping. |
||||||||||||||||||||
|
|
||||||||||||||||
|
|
||||||||||||||||
| Category | Primary | Supporting |
|---|---|---|
| Analytics Engineering | dimensional modelling · mart design · data quality · sources | |
| Data Processing | NumPy · openpyxl · Plotly · Chart.js · xhtml2pdf | |
| Backend & APIs | Django ORM · REST APIs · management commands · ETL | |
| Reporting & BI | Power Query · DAX · VBA · KPI dashboards · PDF exports | |
| Delivery | sprint delivery · dbt tests · Django TestCase · claim-safe docs | |
| Domain | FX operations FinTech |
money transfer · reconciliation · KPI reporting · AML |
|
Daily cash volumes managed
|
UK agents supported
|
Full UK work authorisation
|

