De-identified Data Warehouse & AI-assisted Security Review
Lead analyst · Decode Global
Reporting needed real numbers without exposing client identities. I agreed the rules with Compliance and built a star-schema warehouse to them: pseudonymised client keys, small-cell suppression and right-to-erasure in one call. Alongside it I run the group's security governance — multi-pass AI-assisted reviews of access control, money paths, infrastructure and public sites, plus the monthly cybersecurity report for the AFSL entity.
Confidential company project. Built at Decode Global for regulated financial-services businesses — the platform and its data are private, so there's no public link or product screenshots. Happy to walk through the architecture and my contribution on request.
What it does
- Star-schema warehouse with HMAC-pseudonymised client keys, k ≥ 10 small-cell suppression and one-call right-to-erasure.
- Nightly ETL loading transactions, daily holding snapshots (AUM) and NAV history; CSV reporting API.
- Multi-pass AI-assisted security reviews; every finding verified by hand, then ticketed with a severity, an owner and acceptance criteria.
- Monthly cybersecurity report for the AFSL entity, and IT evidence for its AML/CTF risk assessment.
Illustrative UI — confidential project, no real screenshots published