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

Data leader with 15+ years across six industries, from telecoms and insurance to consulting and transport. Deep technical skills in Azure, Power Platform, Python and SQL paired with a CPA qualification and postgraduate studies in Information Governance. Twenty certifications aren't a flex, they're proof I never stop learning. Nine companies aren't job-hopping, they're proof I adapt fast and deliver everywhere I land.

Experience
Data Analytics & Engineering Manager
Apr 2024 – Present
Ritchies Transport, Auckland
  • Delivered the company's first Health & Safety app in two weeks using Power Apps, replacing a costly legacy vendor system
  • Architected the company's first greenfield Azure data platform using DuckDB and Python, reducing infrastructure costs significantly
  • Automated high-volume operational workflows with Power Automate across multiple departments, freeing FTE capacity
  • Developed core internal applications (CRM, pricing, integration) on Azure Serverless architecture
  • Key role in the multi-million-dollar Hastus implementation, leading data integration, reporting enablement and system alignment
Power BI DAX Power Query PowerShell T-SQL Visual Studio Power Automate Power Apps Postman Python Azure Static Web Apps Azure Data Factory Azure Data Lake Azure Functions DuckDB PostgreSQL Motherduck GitHub SharePoint Monday.com Hastus Co-pilot Studio PowerBI Report Builder Kiro Azure AD JavaScript
Head of Data Engineering
Jan 2023 – Apr 2024
TRACK Aotearoa NZ, Auckland
  • Led migration of McDonald's Marketing Database from on-prem to serverless OLAP + cloud OLTP, cutting server costs by over $1k/month
  • Developed Power Automate flows enabling account managers to self-serve data needs without engineering involvement
  • Re-engineered Salesforce Marketing Cloud processes, reducing manual intervention by 70%
  • Optimised database queries, reducing query latency from 2.5 days to 10 minutes
SQL Server 2019 SSIS .NET Power BI DAX Power Query PowerShell T-SQL C# Visual Studio Power Automate Salesforce Marketing Cloud GitHub Postman Python Databricks DuckDB Hugging Face
Senior Manager, Data & Automation 3 Promotions
Oct 2021 – Jan 2023
PwC New Zealand
  • Created a one-firm risk application integrating CES, Salesforce and NZ Company Register data for engagement risk monitoring
  • Led various client engagements, managing and coaching associates at different levels
  • Served as Cloud + Data Engineer for PwC NZ Territory Integration Fabric, centralising all internal integrations
  • Co-developed a Xero account reconciliation and monitoring solution, opening a new revenue stream for PwC
SQL Server 2016 SSIS .NET Power BI DAX Power Query PowerShell T-SQL C# Visual Studio Alteryx Power Apps Power Automate Azure Data Factory Azure Storage Azure SQL Azure DevOps Postman Azure Batch Account Python Azure Logic Apps Databricks Power Virtual Agents R Masttro Diligend Eikon Morningstar JavaScript
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
Business Intelligence Analyst
Jul 2015 – Mar 2016
Partners Life, Auckland
  • Part of a major data and infrastructure transformation: cloud hosted database migration and dimensional model restructure
  • Designed and developed requirements using SQL and Microsoft products, or distributed specs to outsourced vendors
  • Assisted actuaries in data investigation, update & extraction for risk modelling, where data had to be 100% accurate
Visual StudioSSISSSRSSQL ServerPower BIT-SQL
Earlier Career
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
2008 – 2009Senior Residential AssistantUniversity of Otago
2007Residential AssistantUniversity of Otago
Skills
PythonSQL / T-SQLPower BI / DAX Azure Data FactoryPower Platform DuckDBC# / .NETSSIS DatabricksPostgreSQLAzure Functions Azure DevOpsSalesforce Marketing CloudTableau RVBAPowerShellGit / GitHubJavaScriptAlteryx SAP BOData GovernanceTeam LeadershipStakeholder Management

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