Curriculum Vitae · 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
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.
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 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
  • Led data and integration workstream for a multi-million-dollar Hastus ERP implementation
  • Built and deployed RADAR, a greenfield school bus routing and MoE SESTA compliance platform, avoiding the licensing and ongoing customisation cost of a comparable off-the-shelf system
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
Head of Data Engineering
Jan 2023 – Apr 2024
TRACK Aotearoa NZ, Auckland
  • Inherited broken legacy infrastructure; migrated McDonald's Marketing Database from on-prem to serverless OLAP + cloud OLTP, cutting server costs by over $1k/month
  • 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 Azure Data Factory Azure SQL Azure Storage Azure DevOps Azure Batch Account Azure Logic Apps Python T-SQL C# Databricks Alteryx R JavaScript Masttro Diligend Eikon Morningstar
Maha Kepakisan.
Curriculum Vitae · 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, where I architected and built various data pipelines
SQL Server 2016SSIS.NETPower BIDAXT-SQLC#PowerShellAlteryxPower AppsPower AutomateAzure Data FactoryAzure StorageAzure SQLAzure DevOpsPythonAzure Logic AppsDatabricksRJavaScript
Earlier Career
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 2016SSIS.NETPower BIDAXT-SQLC#Report BuilderAlteryxPower AppsGoogle App ScriptPower AutomateVBA
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 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 RedQlik ViewQlik SenseSQL Server 2016Power BINetezzaOracleSAP Business ObjectsVBAPostgreSQLDAXPL/SQLPythonTableau.NETR
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
  • 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
NetezzaOracleSAP Business ObjectsSAP Universe Design ToolVBAPostgreSQLPower BIDAXRPL/SQLPython
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
  • 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 StudioSSISSSRSSSMSSQL ServerPower BIJIRAT-SQL
Maha Kepakisan.
Curriculum Vitae · continued
kepakisan.co.nz
Earlier Career · continued
Business Intelligence Specialist (Finance)
Mar 2015 – Aug 2015
Vend, Auckland
  • 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 StudioSSISTableauSSMSGitHubSQL ServerMySQLT-SQL
Data Analyst
Mar 2014 – Feb 2015
2Degrees Mobile, Auckland
  • 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
NetezzaOracleSAP Business ObjectsSAP Crystal ReportsSAP Universe Design ToolPL/SQL
Business Intelligence Data Analyst
Jan 2012 – Mar 2014
Bartercard New Zealand
  • 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
VBAVisual StudioSSMSSQL ServerMySQL T-SQL.NET
Trade Broker
2010 – Dec 2011
Bartercard New Zealand
  • 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
Senior Residential Assistant
2008 – 2009
University of Otago
  • 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
Residential Assistant
2007
University of Otago
  • 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
Education

Postgraduate Diploma in Information Governance (Distinction)

University of Auckland · 2024 – 2026

Data governance frameworks, information architecture, and how organisations should govern data, chosen to complement hands-on engineering experience with formal academic foundations.

BCom: Accounting & Management (Double Major)

University of Otago, Dunedin · 2005 – 2009

Stayed at Aquinas College, which later became a workplace. Built the accounting foundation that underpins my financial literacy today.

Maha Kepakisan.
Curriculum Vitae · continued
kepakisan.co.nz
Certifications
Power Platform
PL-900 Power Platform FundamentalsPL-200 Functional Consultant AssociatePL-100 Apps Maker AssociatePL-400 Developer AssociatePL-600 Solution Architect ExpertPL-500 RPA Developer Associate
Data
Wherescape Data Warehouse DevelopmentDP-900 Azure Data FundamentalsDP-300 Azure Database Administrator AssociateDP-203 Azure Data Engineer AssociateDLF Databricks Lakehouse FundamentalsDP-100 Azure Data Scientist AssociateDP-500 Enterprise Data Analyst Associate
Azure Cloud
AZ-900 Azure FundamentalsAZ-104 Azure Administrator Associate
Analytics & AI
DA-300 Power BI Data Analyst AssociateSC-900 Security, Compliance & IdentityAI-900 Azure AI FundamentalsMS-900 Microsoft 365 Fundamentals
Professional & Agile
CPA Certified Practising AccountantICP ICAgile Certified Professional
Self-paced Courses
FTB Foundation Trade Broker TrainingMVA Getting Started with Microsoft PowerShellUC-8d07646f Introduction to Computer Networks for Non-TechiesUC-FDWRA4F5 A Data Visualization Guide for Management ConsultantsUC-R6HOTYQK Data Visualization Principles to Improve Your DashboardsUC-GJSQJRFM Colors for Data Science A-Z: Color Theory
Skills
Cloud & Data
Azure Data FactoryAzure SQLAzure FunctionsDuckDBPostgreSQLDatabricksNetezzaOracleAzure DevOpsAzure StorageAzure Logic AppsMotherduckAzure Data LakeAzure Batch AccountSQL ServerMySQL
Languages
PythonT-SQLDAXJavaScriptPowerShellC#VBARPL/SQL.NETGoogle App Script
BI & Platform
Power BIPower AppsPower AutomateSSISSalesforce MCTableauSAP BOAlteryx GitHubPower QuerySSRS SSMSQlikSharePoint Hastus Co-pilot Studio Power BI Report BuilderKiro Wherescape Red
Additional

Languages: English (fluent), Bahasa Indonesia (native), Balinese (native)

Interests: Data engineering, cloud architecture, full-stack development, AI/ML, open-source tooling, data governance

Full portfolio & career timeline: kepakisan.co.nz

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