• Sole digital developer and 2IC to the Director of IT, owning the full technology and data function across a nationwide transport operation
• Architected and built the company's greenfield Azure data platform: Data Lake, PostgreSQL ODS with SCD Type 2, DuckDB analytics layer, ETL across 30+ source systems
• Built OpsCentre, a real-time fleet safety dashboard on Azure serverless, avoiding ~$5,000/month (~$60k/yr) in Power BI Fabric capacity cost for equivalent live streaming reporting
• Delivered SHIELD H&S platform v1 in under two weeks via Power Apps; now leading SHIELD 3.0 migration to full stack Azure serverless
• Built and deployed RADAR, a greenfield full stack school bus routing and MoE SESTA compliance platform for the Ministry of Education
• Delivered a production OpenAI pipeline via Power Automate: summarises H&S records, desensitises PII, indexes for semantic search, and auto-populates insurance claim forms
• Built Richard.bot, a Copilot Studio chatbot in Microsoft Teams using MS Graph and SHIELD dataverse for role-aware H&S and policy queries

Power BI · Power Platform · Python · React · Azure SWA · Azure Data Factory · Azure Data Lake · Azure Functions · Azure SQL · DuckDB · PostgreSQL · GitHub · Hastus · Entra · Co-pilot Studio · Kiro

• Reduced query latency from 2.5 days to 10 minutes through database re-engineering and query optimisation
• Re-engineered Salesforce Marketing Cloud processes, reducing manual intervention by 70%
• Built self-service data workflows enabling account managers to access data independently, removing engineering bottlenecks

SQL Server 2019 · SSIS · T-SQL · Python · Power Platform · Salesforce Marketing Cloud · DuckDB · GitHub

• Led PwC NZ's Integration Fabric as Cloud and Data Engineer, centralising internal integrations across Lines of Service
• Built a risk engagement app integrating Salesforce CRM and NZ Companies Register data for real-time engagement risk monitoring
• Developed a Xero reconciliation tool that automated financial matching and opened a new revenue stream for the firm

Power Platform · Power BI · .NET · Azure Data Factory · Azure SQL · Azure Storage · Azure DevOps · Azure Batch Account · Azure Logic Apps · Python · T-SQL · C# · Databricks · Alteryx · JavaScript · Masttro · Diligend · Eikon · Morningstar

• Developed and implemented a data strategy aligned with business goals, refactoring the data pipeline to Azure Data Factory + Azure resources
• Integrated various PwC Global data sources (Salesforce, Workday, Talent Link) through Global Fabric Layer API
• Part of a team creating a common Local Layer for all integrations, standardising inbound and outbound data flows
• Led as Data Engineer for PwC Private Office application, where I architected and built various data pipelines

SQL Server 2016 · SSIS · .NET · Power BI · DAX · T-SQL · C# · PowerShell · Alteryx · Power Apps · Power Automate · Azure Data Factory · Azure Storage · Azure SQL · Azure DevOps · Python · Azure Logic Apps · Databricks · JavaScript

• Enriched client dataset with NZBN and geolocation data, enabling smarter, integrated client engagement and resource allocation by location
• Improved Accounts Receivable matching rate from 24% → 70% using String Distance algorithm + dynamic data feedback loop
• Rebuilt Expense Transfer and Credit Note applications from Lotus Notes to Power Apps
• Enhanced billing process leveraging Google stack and Google App Script

SQL Server 2016 · SSIS · .NET · Power BI · DAX · T-SQL · C# · Report Builder · Alteryx · Power Apps · Google App Script · Power Automate · VBA

• Helped 2Degrees with unit cost allocation for financing products, merging financial information with EDW data for more accurate views
• Updated Now Consulting’s data models using Wherescape Red and .NET, built PowerBI reporting layer for the executive
• Assisted ASB CVS team with operational reporting using Tableau for regulatory remediation, ensuring equal case distribution for agents

Wherescape Red · Qlik View · Qlik Sense · SQL Server 2016 · Power BI · Netezza · Oracle · SAP Business Objects · PostgreSQL · DAX · PL/SQL · Python · Tableau · .NET

• Provided quantitative analysis to help 2Degrees scale its ever-growing operations
• Developed underlying data for financial reporting and new data models for the EDW
• Acted as indirect manager to the Financial Data Analyst
• Crafted scalable solutions for automating reports, dashboards and business insights
• Geocoded the entire fixed customer base using Google API, Python & NZ Stats shapefiles, enabling Census data mashups
• Automated vendor E-Bill reconciliation, reducing 2 FTE monthly task to 2 hours, identified over $500k in savings

Netezza · Oracle · SAP Business Objects · SAP Universe Design Tool · VBA · PostgreSQL · Power BI · DAX · R · PL/SQL · Python

• Part of a major data and infrastructure transformation: cloud hosted database migration and dimensional model restructure
• Assisted actuaries in data investigation, update & extraction for risk modelling, where data had to be 100% accurate
• Responsible for continuous development and maintenance of current reporting solutions
• Worked directly with customers to identify and document business requests, translating them into technical specifications
• Designed and developed requirements using SQL and Microsoft products, or distributed specs to outsourced vendors

Visual Studio · SSIS · SSRS · SSMS · SQL Server · Power BI · JIRA · T-SQL

• Performed cost analysis, ROI analysis, unit cost allocations and financial forecasting & modelling used for company restructuring
• Developed the SSIS package to extract data from Xero into the Data Warehouse (80% completed before redundancy)
• Responsible for support & maintenance of Vend's Enterprise Data Warehouse, ensuring high levels of BI availability through in-depth testing

Visual Studio · SSIS · Tableau · SSMS · GitHub · SQL Server · MySQL · T-SQL

• Development, testing, implementation and ETL support for the EDW
• Worked with business stakeholders to determine EDW reporting requirements
• Developed, tested, implemented and supported interactive and static reports
• Identified problems and provided creative reporting solutions through analytical and conceptual skills

Netezza · Oracle · SAP Business Objects · SAP Crystal Reports · SAP Universe Design Tool · PL/SQL

• Reporting support & exchange analysis for all aspects of the business, including target setting and bonus calculations
• Maintained reporting on exchange health indicators: money supply, regional trade movements, credit/debit pots, international flows
• Point person for all data repositories and data requests across the business
• Maintained and developed the data warehouse through CLR functions, data testing and other methods
• Acted as conduit between internal customers and the Software Architect for bugs, defects, change requests and business requirements

VBA · Visual Studio · SSMS · SQL Server · MySQL · T-SQL · .NET

• Service provision for approximately 100 members through trade analysis, research and recommendations
• Developed loyalty and advanced customer service by understanding member businesses and finding ways to expand them
• Generated referrals for member businesses while maintaining high service standards

• Pastoral care of residents and R.A. staff; leading the residential team
• Administrative duties, event planning, low-level disciplinary action and conflict resolution
• Role modelling and demonstrating leadership skills

• Pastoral care of residents in a hall of residence housing 160+ students from New Zealand and around the world
• Community management and event planning with risk assessment
• First role working at the same college where I lived as a student