I build, model and visualise financial data — engineering the layer between raw ERP systems and trusted, decision-ready analytics. Multi-ERP ETL pipelines, secure extraction tooling, .NET data platforms and Power BI, delivered across global audit engagements.
I'm a Manager in Technology Risk Assurance Data & Analytics at BDO UK, leading a team of 4–6 and building the data infrastructure that makes audits faster, more reliable and better governed. My work sits at the intersection of financial systems, software engineering and analytics.
From architecting multi-ERP ETL pipelines and .NET data platforms to delivering executive Power BI dashboards for FTSE-listed clients — I turn complex, messy financial data into trusted, decision-ready intelligence.
Previously a Senior Data Analyst at EY Global Delivery Services, where I led development work on EY Helix data extraction and transformation across 30+ client engagements worldwide.
A secure data extraction engine designed and built from the ground up — a self-contained, portable .NET application connecting directly to ERP databases with read-only access. Automates extraction of GL, Trial Balance and Journal Entry data across 15+ ERP platforms, encrypts output using AES + RSA cryptography, and delivers audit-ready datasets with a full extraction memo.
Orchestration engine that replaces a manual process for provisioning audit engagements and ingesting their financial data into an AI audit analytics platform. REST API integration, SQL Server state management, a header-driven column mapper and chunked large-file export — tested in UAT across multiple live engagements.
Automated general ledger pipelines that pull company, GL transaction and period-balance data from an accounting data provider's API, stage and transform it with SQL, validate it and publish it to Power BI. Includes a Blazor admin dashboard for engagements, chart-of-accounts mapping, pipeline monitoring and failed-job retries.
Mapping and standardisation platform on Azure Databricks, normalising multi-source ERP outputs into a unified, audit-ready schema. Handles complex field mapping, currency normalisation and period alignment at scale.
Led development work on global audit data extraction and transformation — automating ingestion, validation and reporting from multiple ERP systems across 30+ client engagements worldwide. ETL standards adopted firm-wide; Gold Badge in Data Integration.
WPF desktop cleanser and Blazor Server frontend using graph visualisation to map transaction networks for audit investigation. Drill-down modals, high-risk node marking and sortable transaction tables for large datasets.
Desktop tool for bulk-loading pipe-delimited financial extraction files into SQL Server via SqlBulkCopy. Handles multi-million row imports with automatic date-format detection, timestamp processing and full error reporting.