Résumé · kepakisan.co.nz
Maha
Kepakisan.
Senior Data & Technology Leader
Certified Practising Accountant
🌺 Bali, Indonesia  →  🥝 Auckland, NZ
kepakisan.co.nz
CPA Australia · Ritchies Transport Holdings
15+
Years in Data
28
Certifications
$500k
Savings Identified
2.5d→10m
Query Optimised
71
Tools Mastered
🌐
Personal Website & Portfolio
kepakisan.co.nz
Full career timeline, blog, consulting services and personal brand. A deeper look at who I am and how I work.
Profile

Data and technology leader with 15+ years across six industries: telecoms, insurance, consulting, marketing technology, and transport. Currently operating as sole digital developer and 2IC to the Director of IT at Ritchies Transport, owning the full technology and data function end to end. A CPA as well as an engineer, so every data and platform decision is grounded in commercial outcomes, not just technical preference. Operates AI-first across the full delivery lifecycle: production OpenAI and Copilot Studio integrations live in the business, with Kiro and Claude Code replacing manual authorship as the standard.

Experience
Data Analytics & Engineering Manager
Apr 2024 – Present
Ritchies Transport Holdings, Auckland
  • Sole digital developer and 2IC to the Director of IT, owning the full technology and data function
  • 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 on v3.0 migration to Azure serverless) and RADAR, a full stack MoE SESTA compliance platform for school transport
  • 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 Azure SWA Data Factory Azure Data Lake Azure Functions Azure SQL DuckDB PostgreSQL GitHub Hastus Azure AI Foundry Copilot Studio Kiro
Head of Data Engineering
Jan 2023 – Apr 2024
TRACK Aotearoa NZ, Auckland
  • 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
Senior Manager, Data & Automation 3 Promotions
Oct 2021 – Jan 2023
PwC New Zealand
  • 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 Data Factory Azure SQL Azure Storage Azure DevOps Azure Batch Account Azure Logic Apps Python C# Databricks Alteryx R Masttro Diligend Eikon Morningstar
Maha Kepakisan.
Résumé · continued
kepakisan.co.nz
Experience · continued
Senior Data Engineer
Jan 2021 – Sep 2021
PwC New Zealand
  • 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, architecting and building various data pipelines
SQL Server 2016SSISPower BIT-SQLC#PythonAzure Data FactoryAzure SQLAzure DevOpsDatabricksPower AppsPower Automate
Business Intelligence Developer
Mar 2019 – Dec 2020
PwC New Zealand
  • 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 2016Power BIT-SQLC#AlteryxPower AppsPower AutomateVBAGoogle App Script
Business Intelligence Consultant
May 2018 – Mar 2019
Now Consulting, Auckland
  • 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 a 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 RedSQL Server 2016Power BIDAXNetezzaOracleSAP Business ObjectsPostgreSQLPythonTableauR
Senior Business Intelligence Analyst (Finance)
May 2016 – Apr 2018
2Degrees Mobile, Auckland
  • Provided quantitative analysis to help 2Degrees scale its ever-growing operations
  • Developed underlying data for financial reporting and new data models for the EDW
  • 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
NetezzaOracleSAP Business ObjectsVBAPostgreSQLPower QueryDAXRPython
Earlier Career
Jul 2015 – Mar 2016Business Intelligence AnalystPartners Life, Auckland
Mar 2015 – Aug 2015Business Intelligence Specialist (Finance)Vend, Auckland
Mar 2014 – Feb 2015Data Analyst2Degrees Mobile, Auckland
Jan 2012 – Mar 2014Business Intelligence Data AnalystBartercard New Zealand
2010 – Dec 2011Trade BrokerBartercard New Zealand
Core Skills
PythonSQL / T-SQLPower BI / DAX Azure Data FactoryPower Platform DuckDBReactC# / .NETSSIS DatabricksPostgreSQLAzure Functions Azure DevOpsSalesforce Marketing CloudTableau RVBAPowerShellJavaScriptGit / GitHub Data GovernanceEnterprise ArchitectureStakeholder ManagementProduct Ownership Azure AI FoundryLLM IntegrationCopilot StudioOpenAI APIGitHub CopilotAgentic AI

Originally from Bali, Indonesia. Arrived in New Zealand at 17. Built an entire career here. Still curious about everything.

Maha Kepakisan
CPA · kepakisan.co.nz