Projects

A selection of things I've designed, built, and shipped.

schemascope — dashboard

$schemascope

SchemaScope v0.1.0

⛁ AppDb localhost,1433 57 scripts SQL · deploy

INSPECT Detect version · Verify

❯Audit: full drift report

MIGRATE Full heal · Versions · Prepatch

schemascope — setup wizard

$schemascope --setup

1/6 Server · 2/6 Authentication · 3/6 Connection check

OKConnected: 12 user databases visible

❯Pick the default database (type to filter)

AppDb · ReportsDb · StagingDb · Type a name

OKConfiguration saved

schemascope — drift audit

$schemascope --audit --database AppDb

OKApplied 42 · Partial 1 · Missing 14

WRN1.0.0.43 missing 0/3 objects

WRNdbo.Invoices: table not present

❯BEHIND HEAD, 14 scripts pending

schemascope — journal cross-check

$schemascope --audit --journal auto

INFdbup · dbo.SchemaVersions · 57 entries

ERRJOURNAL LIES 1: recorded as applied

1.0.0.43: 3 of 3 objects absent from schema

WRNUNTRACKED 1: applied, never journaled

schemascope — hybrid history

$schemascope -d AppDb --track-history

OK1.0.0.57 (recorded in schemascope_history)

$schemascope --audit --journal schemascope

INFschemascope · dbo.schemascope_history

OKThe journal agrees with the schema evidence

schemascope — dry run

$schemascope -d AppDb --dry-run

DRY RUN Nothing will be executed

1.0.0.43 1 batch 3 objects 0 parse errors

1.0.0.44 2 batches 1 object 0 parse errors

WRN1.0.0.45 1 parse error

❯3 steps planned, 1 with problems

schemascope — heal with rollback safety

$schemascope -d AppDb --tx per-script

OK1.0.0.43 (transaction committed)

OK1.0.0.44 (transaction committed)

ERR1.0.0.45 rolled back, no partial changes

INFSummary: 2 OK, 1 FAIL

schemascope — clone for testing

$schemascope --clone --source AppDb --target AppDb_Test

INFBackup AppDb [==========] 100%

INFRestore AppDb_Test [==========] 100%

OKClone complete (2m 14s)

schemascope — CI drift gate

$schemascope --audit -o json --strict

"verdict": "behindHead",

"currentVersionLabel": "1.0.0.42",

"pending": [ 14 scripts ]

ERRexit 1, deploy blocked

SchemaScope

Evidence-based drift auditor and migration toolkit for SQL Server: verifies every migration against the live database with ScriptDom, cross-checks DbUp and Flyway journals, and gates CI with JSON reports.

.NET 10C#SQL ServerScriptDomGitHub ActionsDockerCLI

Walkthrough View on GitHub

Restaurant Ordering Platform

Restaurant ordering and reservation platform with menu browsing, a persistent cart, Stripe checkout, table bookings, real-time order updates, and an admin queue.

LaravelLivewireTailwind CSSStripeWebSocketsMySQL

View on GitHub

Driving School Website

Marketing website for a driving school with course packages, a lesson booking enquiry form, FAQs, and a contact page with map integration. Built for performance and SEO.

Next.jsTypeScriptTailwind CSSFramer MotionResend

View on GitHub

payment-switch — purchase (0200)

$dotnet run --project src/PaymentSwitch.Gateway

INFTCP listener started on port 8583

INFParsed MTI=0200 STAN=635870

INFForwarded to CBS /api/financial

INFCompleted 0200 ResponseCode=00 in 257ms

payment-switch — balance inquiry (0100)

INFParsed MTI=0100 STAN=635871

INFField 3 proc code = 310000

INFForwarded to CBS /api/inquiry

INFCompleted 0100 ResponseCode=00 in 188ms

payment-switch — reversal (0400)

INFParsed MTI=0400 STAN=635874

INFOriginal transaction located by RRN

INFForwarded to CBS /api/reversal

INFCompleted 0410 ResponseCode=00 in 203ms

payment-switch — declined & dedup

INFParsed MTI=0200 STAN=635872

INFForwarded to CBS /api/financial

WRNInsufficient funds

ERRCompleted 0200 ResponseCode=51 in 142ms

INFDuplicate STAN=635870 dropped

payment-switch — card data protection

INFParsed MTI=0200 PAN 537502******1234

INFF64 MAC present, validating

OKHMAC-SHA256 MAC verified

WRNTampered MAC on STAN=635876

ERRRejected: MAC validation failed

payment-switch — DB-driven field schema

$SELECT * FROM FieldDefinitions WHERE FieldNumber = 55

55 ICC Data (EMV) LLLVAR · Binary · max 255

INF20 field schemas loaded from database

INFF35 Track 2 read as LLVAR with BCD prefix

OKSchema change: no code, no redeploy

payment-switch — network echo (0800)

INFParsed MTI=0800 STAN=635873

INFNetwork management: echo test

INFCompleted 0810 ResponseCode=00 in 12ms

payment-switch — malformed message

INFMessage received (41 bytes)

WRNInvalid bitmap at offset 4

ERRMessage rejected: unparseable

INFConnection kept, awaiting next message

payment-switch — test bench

$docker compose up -d

INFsql-server · mock-cbs · gateway started

$python tools/test-client.py --mti 0200

INFSent 61 bytes, received 73 bytes

OKResponseCode=00 from mock CBS

Payment Switch

TCP gateway that accepts raw ISO 8583 financial messages, parses them, forwards to a core banking system over HTTP, and returns packed responses with duplicate detection.

.NET 10C#ISO 8583TCPREST APIsDocker

Walkthrough View on GitHub

Roofing Services Website

Business website for a roofing company with service detail pages, service-area coverage, warranty information, and a client-side contact form. Static, fast, and responsive.

HTMLCSSJavaScriptEmailJSResponsive

View on GitHub

atm-gateway — health check

$dotnet run --project src/Atm.Gateway.Api

INFNow listening on http://localhost:5092

INFApplication started

INFRequest GET /api/ATMBanking/test

INFResponse 200 in 36ms

atm-gateway — financial transaction

INFRequest POST /api/atmbanking/fin

INFAuth OK key=atm-04

INFRouting to core banking

INFResponse 200 in 71ms

atm-gateway — financial reversal

INFRequest POST /api/atmbanking/finrev

INFAuth OK key=atm-04

INFOriginal transaction located

INFReversal posted to core banking

INFResponse 200 in 64ms

atm-gateway — LORO transfer

INFRequest POST /api/atmbanking/loro

INFInter-bank letter of reference

INFResponse 200 in 88ms

INFRequest POST /api/atmbanking/lororev

INFReversal accepted in 59ms

atm-gateway — dual routing

INFRoute decision for BIN 537502

INFLocal: stored procedure in MainDb

INFRemote: forward to client CBS endpoint

OKSame pipeline, two backends

atm-gateway — rejected request

INFRequest POST /api/atmbanking/fin

WRNMissing X-API-KEY header

ERRResponse 401 in 8ms

WRNRate limit hit for 10.0.0.5

ERRResponse 429, retry after window

atm-gateway — security headers

$curl -sI https://gateway/api/atmbanking/test

X-Frame-Options: DENY

Content-Security-Policy: default-src 'none'

Strict-Transport-Security: max-age=31536000

OK7 security headers on every response

atm-gateway — observability

INFPOST /api/atmbanking/fin from 10.0.0.7

INFSerilog: request and response logged (71ms)

$curl https://gateway/health

OKHealthy: database reachable

Swagger UI at /swagger in development

atm-gateway — docker deployment

$docker compose up -d gateway

INFContainer atm-gateway started

INFNow listening on http://0.0.0.0:5092

INFHealth check passed

ATM Gateway

Middleware service that routes ATM and POS transactions between terminals and core banking systems, with API-key auth, per-IP rate limiting, and structured logging.

ASP.NET Core.NET 10C#REST APIsSQL ServerDocker

Walkthrough View on GitHub