Curriculum Vitae · 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.
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
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
Maha Kepakisan.
Curriculum Vitae · continued
kepakisan.co.nz
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
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 (Honours)

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.

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