02 — Data & analysis
Data & analysis
SQL · DuckDB · Python · Power BI · Power Query · Excel/VBA · Gen AI
Finding the data problem hiding inside a business process, and building the pipeline or model that settles it.
TB & sub-ledger reporting pipeline
Automated the transformation of trial balance and sub-ledger data into reporting-standard output, using SQL and generative AI with layered validations. A proof of concept that cut rework and put the tax team's questions on the table before the numbers were all in.
Deloitte
REIT deferred tax model
Advanced Excel model of deferred tax positions across a real estate investment trust, encoding the accounting treatment.
Deloitte
Phone lifecycle analysis Read →
Does the carbon cost of a handset sit in manufacture or in use, and enough to change what you buy? SQL analysis across published lifecycle data.
Personal