Skip to content

Selected Work ​

Professional highlights

A small selection of work I am proud of.

I work across financial analysis, reporting and automation. The examples below are intentionally concise and use only non-confidential information.

My role

Connecting business questions with data, building the solution, and communicating the result clearly enough for people to act.

01

Month-end reporting, made faster and easier to trust.

Automated reporting and reconciliation with Python, SQL and Excel VBA, replacing repetitive manual work while keeping exceptions visible.

Outcome60% faster · 80,000+ records · $2.4M in discrepancies surfaced
02

Portfolio analytics that answered a Finance question.

Built a clearer view of interest-rate movements and their impact across a funded portfolio for Finance and senior stakeholders.

FocusPortfolio performance · Management reporting · Power BI
03

Reporting designed to scale beyond spreadsheets.

Created ETL pipelines and semantic models across multiple systems while supporting the move from legacy reporting into Azure.

Scale15+ source systems · AU, NZ and UK

Earlier work ​

Before my current role, I worked across compliance automation, predictive premium modeling, financial crime analytics and large-scale data migration. That experience shaped how I think about controls, explainability and data quality.

For a conversation about this work, email zkqbill@hotmail.com.

Financial data · Reporting transformation · Risk automation