Johnny Ho
Menu

Johnny HoSupply Chain, AI Automation & Data Analyst

I map business workflows, build forecasting models and automate reporting pipelines for supply chain, finance and BI.

View projects Contact
Portrait of Johnny Ho in a linen shirt

Based in Sydney

Master of Logistics & SCMUSYD, expected May 2027

Open to roles in

  • Supply Chain & Logistics
  • AI Automation
  • Business Analytics
  • Data Analytics
  • Data Engineering

Behind the portrait, an illustration of tools I work with (Excel, SQL, Python, PySpark, Make, Google Apps Script, Power BI and Tableau) drawn as a connected data pipeline.

Tools I work with proficientlyUsed hands-on in the projects belowSee all

Featured projects

Short visual walkthroughs of real work.

More projects

Tech x Supply Chain

Where my tools plug into each supply chain stage.

  • Automation & AI
  • Data & BI
  • Engineering & cloud
  • ML & forecasting

  1. Plan

    Forecast demand

  2. Procure

    Fix process bottlenecks

  3. Inventory

    Right stock, right time

  4. Make

    Less scrap, better yield

  5. Transport

    Safer, smarter routes

  6. Order-to-cash

    Fast, accurate quotes

  7. Measure & improve

    Prove the gains

About me

Johnny pitching the InspirEd career guidance platform at the UNSW INFS3605 Innovation and Transformation Showcase
Pitching InspirEd · UNSW INFS3605 Showcase, Bronze Award

I graduated from UNSW with a Bachelor of Commerce (Finance) and a Bachelor of Information Systems, and I am currently studying a Master of Logistics and Supply Chain Management at the University of Sydney (expected May 2027). In 2025 I also completed 1 year of a double master's degree at UNSW: Master of Information Technology (Data Science) and Master of Commerce (FinTech).

My work sits where finance, supply chain and data meet: financial analysis, process optimisation and process modelling, demand forecasting and inventory planning, and automation of reporting pipelines. I also design UX/UI mockups in Power Apps and Figma, and bring project management experience to delivery.

  • EnglishProfessional (IELTS 7.5)
  • VietnameseNative
  • ChineseElementary (HSK 2)

What I do

  • AI automation

    Built an internal AI-powered agent for reporting, pricing and operational queries, and a Python and Make pipeline into a Notion AI workspace.

  • Data & BI analytics

    SQL extraction, financial models in Excel and Python, and dashboards in Power BI and Tableau for portfolio, project and KPI reporting.

  • Supply chain analytics

    Time-series demand forecasting (Moving Average, Exponential Smoothing, ARIMA) and inventory planning with reorder points, safety stock and DIO.

How I work

  1. Map: Map procurement, inventory or finance workflows to find bottlenecks.
  2. Model: Build forecasting, pricing and financial models on the data.
  3. Automate: Automate the data flow with Python, Make and Apps Script.
  4. Report: Ship dashboards and KPI reports that support decisions.

Tech stack

  • Automation & AI
  • Make (Integromat)
  • n8n
  • Google Apps Script
  • Power Apps
  • UiPath
  • LLM APIs / AI agents
  • Notion
  • Data & BI
  • Python
  • SQL
  • pandas
  • NumPy
  • matplotlib
  • seaborn
  • plotly
  • Jupyter
  • Alteryx
  • Power BI
  • Tableau
  • Microsoft Excel
  • Engineering & Cloud
  • PySpark (Apache Spark)
  • Snowflake
  • AWS
  • Hadoop
  • Kafka
  • MongoDB
  • Cassandra
  • ETL
  • Git / GitHub
  • ML
  • scikit-learn
  • Time-series forecasting
  • Business & Design
  • Figma
  • Miro
  • SAP Signavio / BPMN
  • Jira
  • Agile / Scrum

Experience

  1. Sep 2025 - Feb 2026

    Finance Business Analyst Intern

    Amplify

    • Built an automated data pipeline using Python and Make (Integromat), integrating Sales, Make and Finance data into a centralised Notion AI workspace for business insights.
    • Built and compared pricing prediction models with scikit-learn to examine pricing approaches and profitability considerations.
    More from Amplify
    • Automated financial reporting and dashboards with Google Apps Script and the Google Finance API, providing KPIs (net profit, gross profit, payback period) with executive-only cost data restricted.

  2. Mar 2025 - Sep 2025Hybrid

    Business Intelligence Analyst

    Tan Quoc Steel, steel distribution and structures

    • Mapped procurement and inventory workflows; applied demand forecasting and inventory planning models (reorder points, safety stock, DIO) to identify bottlenecks and support stock decisions.
    • Developed time-series demand forecasting models (Moving Average, Exponential Smoothing, ARIMA) to predict monthly demand for hot-rolled coil and structural steel products.
    More from Tan Quoc Steel
    • Built an internal AI-powered automation agent to support reporting, pricing and operational queries.

  3. Jan 2024 - Mar 2024

    Data Analyst Intern

    UNSW Finance Automation

    • Developed a Continuous Improvement Dashboard to track project performance, ROI and payback periods.
    • Designed and tested Power Apps wireframes for a form-routing application.
    More from UNSW Finance Automation
    • Designed a QR-code scanning feature for a Travel Expo app for check-in and prize collection.

Education

Expected May 2027

Master of Logistics and Supply Chain Management

University of Sydney

  • 20% tuition scholarship for academic excellence
  • Time-series demand forecasting
  • Inventory control (safety stock, EOQ, reorder point)
  • Supply chain network optimisation
  • Logistics systems & ERP integration
  • Spatial analytics

Feb 2025 - Dec 2025

Double master's: Master of Information Technology (Data Science) and Master of Commerce (FinTech)

UNSW Sydney

  • 1 year completed (not awarded)
  • 15% tuition scholarship
  • Hadoop
  • Kafka
  • MapReduce
  • MongoDB
  • Cassandra
  • ETL
  • Snowflake
  • Time-series analysis

2021 - 2025 (conferred Feb 2025)

Bachelor of Commerce (Finance) / Bachelor of Information Systems

UNSW Sydney

Awards & certifications

Awards

Certifications

Community

Johnny standing beside the NVIDIA AI Day Sydney sign at SXSW Sydney
SXSW Sydney, NVIDIA AI Day: sent by Amplify to explore applied AI and ML for workflow automation
Johnny in graduation gown and cap holding his UNSW testamur
UNSW graduation

Leadership & volunteering

  • UAVS-NSWSponsorship, Aug 2023 - present
  • AIESEC in UNSWOutgoing Global Volunteer Executive, Aug 2023 - Jan 2024
  • Arc UNSWFun-a-Thon Volunteer, 2023

Contact

Open to Supply Chain & Logistics, AI Automation, Business Analytics, Data Analytics and Data Engineering roles in Australia.

johnny.quocho14@gmail.com

Sydney, Australia