Handovers

Rendered and finalised Matthew's CV for the Savills BI Fabric Developer contract and SUBMITTED the application. Built out the full Kerv section with indented client sub-headings (Savills Europe/UK/migrations/BAU, Turner & Townsend, Gamma, A2Dominion, WDH, AX), expanded every pre-Kerv role from the original CV, and settled a styled-HTML to headless-Chrome PDF pipeline (Calibri 11.75px, 4 pages; RenderCV dropped as it cannot do the nested sub-headings). Produced a separate general/agency version (Matthew-Denison-CV.pdf) adding a profile retention line, a "hands-on, designs and builds" positioning phrase, and a "requested by name by Savills" line under Kerv. Next: the LinkedIn update pack (decision pending on public client naming), then the parked kb sync, the .docx, and temp cleanup.

Set up the Fabric Medallion Demo project under Disseminate\Projects as a de-branded learning and interview build based on the Turner and Townsend medallion repos. Copied all five repos in without their .git history, renamed Fee Flash to Revenue Forecast (surgical scope, data-layer names left intact), and backed up the key coamappings.csv mapping file to _context\seed-data. Also fixed the 30-day session cleanup (set cleanupPeriodDays 3650) and diagnosed the lapsed Fabric trial capacity. Next: get the Disseminate Azure DevOps details, git init and push the repos, then the remaining T&T de-branding and deploy to a new trial workspace (North Europe).

Data driven CV: YAML knowledge base is the single source of truth, mirrored to Compass pages. CAPTURE PHASE COMPLETE — every engagement from Hitchen Foods (1997) to NG Bailey (2026) captured, relevance-rated and given a slim page; the index has zero placeholders. Seven strength themes (incl. six medallion platforms, 35 renewals, the 27-year Spice/Enserve/NG Bailey thread), a patterns registry with a reuse render rule, and the full style rules. Next: the RENDER phase — flavour configs, RenderCV to PDF/docx — then the LinkedIn pack and a web CV with a client relationship map.

Built the MUFC Ticket Sniper: reacts to Pitchside Pass Discord alerts by popping the right Old Trafford block page on tickets.manutd.com in Chrome, with a tray app (United crest) to start and stop it. All 136 blocks and all 23 home fixtures mapped. Automated seat clicking abandoned after the site's DataDome bot protection blocked it; popup plus human click by design.

Consolidated all Silver→STG→DW dim load procs into single Silver→DW stored procs for the Savills CRL Fabric Warehouse migration. Fixed DimClient count discrepancy (SELECT DISTINCT + ROW_NUMBER() no-op bug), applied UPPER() case-safe fixes across DimPerson/DimDocumentDescription/DimOfficeDepartment, built usp_DimDocumentDescription with s_ConsolidatedDocuments rebuild and BIGINT key writeback. Next: build usp_FactFinanceTransaction.

Northern Powergrid property access dispute at 18 Sandal Avenue. Latest session (31 May): read NPG formal letter (dated 22 May, received on return from holiday), analysed WhatsApp evidence from neighbour's wife confirming NPG committed to alternative route via Orrs' property only. Drafted comprehensive formal response challenging inconsistent stated purposes, unenforceable deadline, and disconnection threat — ready to send after call to Andy Molden (Surveyor, 03711 946325) to obtain job reference. Key deadlines: 14 June NPG response, 21 June SAR responses due.

Designed and documented the Fee Flash Gold layer for T&T Fabric Medallion. Established a three-fact-table architecture (fct_fee_flash_gl, fct_fee_flash_budget, fct_fee_flash_projtrans), wrote GL and Budget filter SQL queries, and fully rebuilt the schema mapping Excel workbook (16 sheets) including column maps for all three facts and Bronze/Silver build requirements for the ProjTrans Phase 2 build.

Renamed all 4 Savills project folders and associated documentation to append "Fabric Medallion" to each project name (CRL, EU Finance, Reapit, UK Finance). All 6 files updated; UK Finance folder renamed successfully. CRL, EU Finance, and Reapit folder renames are pending — blocked by OneDrive sync in progress; Matthew to complete in File Explorer once sync settles.

Built the complete Claude Code workspace and completed a full visual redesign of Claude Compass. Covers: workspace structure, 13 global rules, 11 skills, encrypted secrets vault, Azure DevOps pipeline to Cloudflare Pages, Turner & Townsend Fabric Medallion project with 3 repos, /clone-repo local-folder check, /create-project Personal/Disseminate workspace support, awwwards-inspired site redesign (top nav, amber accent, two logo variants, hero banners on all pages), nav reordered, structure page repos workflow rewritten, /update-handover renamed to /handover-update, Playwright MCP installed. Next: push Compass changes to trigger deployment, then set up compass.disseminate.co.uk custom domain and Cloudflare Access.