Resume · Perth, WA · Available Now

Simon Hooi

Finance × Data × AI
simonhooi.cs@gmail.com 0480 218 240 Perth, Western Australia
CPA Australia Snowflake SnowPro PL-300 Power BI Xero Advisory AWS · Azure Python · SQL

A CPA-licensed, data-driven professional bridging the gap between finance and technology — turning complex data into strategic business intelligence. With deep expertise across the modern data stack and cloud infrastructure spanning AWS and Azure, I bring both technical depth and commercial acumen to deliver insights that matter.


Experienced in architecting end-to-end data pipelines, financial reporting systems, and AI-powered analytics solutions that scale with business complexity. Passionate about applying AI capabilities for forecasting, operational analytics, and decision support — moving beyond traditional FP&A toward an intelligent, data-first approach to financial strategy.

Financial Analyst
2023 — Present
Knight Health Pty Ltd · Perth, WA
  • Pioneered and built the company's Data function, introducing analytics through Power BI dashboards to provide operational and financial insights across the organisation.
  • Initiated the Snowflake data platform, designing structured and semi-structured database architecture and integrating data across multiple systems through APIs.
  • Developed an internal LLM AI-enabled web application using Python and Claude to allow company-wide access to data insights and automation tools.
  • Oversaw Accounts Receivable, improving debtor management and operational efficiency with Power Automate.
  • Developed invoice automation tools using Python, reducing accounting headcount by 50%.
  • Built financial models to evaluate new business locations, acquisitions, and strategic collaborations — including breakeven, pricing strategy, and profitability analysis.
  • Managed invoice financing facilities, audit, and end-of-month reconciliations.
  • Developed the annual budget, forecasts, and variance analysis across multiple departments.
  • Contributed to the preparation of R&D Tax Incentive claims.
Finance Manager
2017 — 2023
CMYK Summit Pty Ltd · Malaysia
  • Managed relationships with external stakeholders including suppliers, investors, lenders, auditors, and corporate secretaries.
  • Created and monitored cost structures, profit margins, and company budgets.
  • Managed Malaysia's statutory obligations including EPF, corporate tax filings, and annual financial reporting.
  • Led implementation of CRM and accounting systems including HubSpot and Xero to improve operational efficiency and financial tracking.
  • Managed the HR function including employment contracts, payroll administration, and staff remuneration structures.
  • Supported business performance through data analysis using Excel (Power Query, Power Pivot), credit control, P&L forecasting, and cash flow management.
Global Project Architect → Transactional Specialist
2013 — 2017
Microsoft · Singapore
  • Developed and documented secure, reliable, and scalable process solutions within defined timelines adhering to Microsoft's data privacy and security protocols.
  • Managed project timelines, deliverables, and resources leveraging project management and technical expertise.
  • Collaborated with cross-regional operations teams, internal auditors, and global project stakeholders to ensure successful delivery.
  • Selected for an international assignment to the Philippines to provide training and mentorship for staff at a newly established operations centre.
Data Platform

Snowflake, Fivetran, Census, Power BI (PL-300), Power Query, Power Pivot

Cloud Infrastructure

AWS (EB, RDS, S3, EC2, Lambda, EventBridge, IAM) · Azure (App Service, SQL DB, API Mgmt)

Programming

Python, SQL, HTML, CSS, JavaScript · Cursor, Replit, VS Code

Finance & Accounting

Xero (Advisory Certificate), Salesforce, Employment Hero, Deputy

Automation & AI

Power Automate, Power Apps, Claude API, LLM application development

API & Integration

REST APIs, Postman, AWS API Gateway, Azure API Management, Xero API

Commercial Acumen Data-Driven Decision Making Process Automation Digital Transformation Financial Modelling Project Management — Agile/Waterfall SDLC Critical Thinking Attention to Detail Stakeholder Management
Certified Practising Accountant
CPA Australia
CPA
Snowflake Fundamentals Certificate
Snowflake Inc.
SnowPro Core
Power BI Data Analyst — PL-300
Microsoft
PL-300
Xero Advisory Certificate
Xero
Xero
BSc (Hons) Mathematics and Economics
University Malaysia Sabah
English
Mandarin
Malay
Hokkien