Faik Öz · Melbourne

HVAC operations × Software architecture

Head of Estimation & Project Delivery at Vic Air Supplies · M.Sc. Mechanical Engineer (CFD) · Full-stack architect of the company's internal software stack — six production platforms plus a shared Microsoft Dynamics 365 Business Central client SDK.

About

M.Sc. Mechanical Engineer with 10+ years of front-line HVAC project delivery in Melbourne. Today: Head of Estimation & Project Manager at Vic Air Supplies, owning the commercial, procurement, and operations interfaces across Sales, Sheet Metal, Warehouse, and Finance. Alongside the operational role, I architect and operate the company's internal software stack.

The combination matters mechanically: the systems that run an HVAC business — estimating, procurement, forecasting, workforce, finance, BI — fail or succeed on the same operational details I see daily on the delivery side. Building them in-house, with that context, has produced leverage that neither discipline could deliver alone.

What the stack has displaced

The Power BI + Azure data-warehouse + ETL pipeline for live sales-ledger visibility
The forecasting-SaaS tier (Netstock / Slimstock category) for inventory and supplier planning
The workforce-management SaaS tier
External banker-grade financial modelling — the in-house three-way model is the analytical basis for ongoing NAB facility reviews

Selected work

Sales Analytics Dashboard View screens →

Live executive view of the sales ledger, built directly on Microsoft Dynamics 365 Business Central via OData v4. MSAL-secured, with runtime $metadata schema discovery so the application is immune to vendor entity-name drift across upgrades. Single-tenant, free-tier deployment.

Business outcome: replaces the Power BI + Azure data-warehouse + ETL pipeline that would otherwise be required to give the leadership team a live read on sales performance.

JavaScript
MSAL OAuth 2.0
BC OData v4
Chart.js
XLSX.js
GitHub Pages

Item Demand & Procurement Forecasting View screens →

Statistical forecasting engine wired live to Business Central. Inventory demand and supplier purchasing volumes are modelled directly off the same operational ledger finance reports run on — so purchasing decisions reconcile to a single source of truth.

Business outcome: replaces the subscription forecasting-SaaS category (Netstock / Slimstock tier) for inventory and supplier planning.

JavaScript
BC OData v4
Time-series forecasting
Chart.js
date-fns

HR & Workforce Portal View screens →

Contractor onboarding, time capture, payroll self-service, and an auditable leave-accrual ledger with full transaction history. Firebase Authentication and Firestore Security Rules calibrated to organisational policy.

Business outcome: replaces the workforce-management SaaS tier the business otherwise would have subscribed to.

Firebase Auth
Firestore
Security Rules
JavaScript
GitHub Pages

Calendar & Quoting Operating Surface View screens →

Office-wide view aggregating the team's Outlook calendars through Microsoft Graph and overlaying them with live quoting context. Single-tenant architecture refreshed on a scheduled cadence via GitHub Actions.

Business outcome: one operating view where team availability and commercial pipeline intersect — replacing the manual stitching across calendar tools and quote spreadsheets.

Microsoft Graph
MSAL
Firebase
GitHub Actions
JavaScript

Productivity & Performance Analytics View screens →

Nine-view analytics suite instrumenting team productivity, error taxonomy, and performance trends — the evidence base for continuous-improvement reviews and the quarterly business-reporting cadence.

Business outcome: makes operational performance legible at the resolution executives need but rarely receive.

JavaScript
Chart.js
Firestore

Three-Way Financial Forecast View screens →

Driver-based three-statement model — profit & loss, cash flow, balance sheet — used as the analytical basis for ongoing NAB facility reviews.

Business outcome: supports management decisions, scenario analysis, and banking discussions through a single in-house forecasting framework, removing dependence on external modelling.

Financial modelling
Cash-flow architecture
Scenario design

bc-library — BC Client SDK

bc-library — Business Central Client SDK

The integration spine beneath every internal application. A JavaScript SDK that gives the company's tools unified, MSAL-authenticated OData v4 access to Microsoft Dynamics 365 Business Central, with runtime $metadata schema discovery so each downstream application resists vendor version drift across upgrades.

Business outcome: one integration layer underneath every platform — eliminates duplicated MSAL / OData code and removes per-app maintenance from each Business Central release cycle.

JavaScript
MSAL
OData v4
Schema introspection
SDK design

HVAC Estimator Platform

Full-stack estimation platform combining PDF drawing takeoff, vision-based component detection, labour-hour calculation calibrated to Australian HVAC standards (NCC / BCA · AS 1668 · AS 4254), quote revisioning, and Business Central interoperation.

Business outcome: targets quoting-cycle compression from hours to minutes, with consistency and traceability across revisions.

Node.js
Express.js
React.js
MongoDB
Tesseract.js
Google Cloud Vision
Docker

PDF-Driven HVAC Takeoff R&D

PDF-Driven HVAC Takeoff Automation

Multi-generation applied-research programme exploring three successive architectures for extracting duct geometry from mechanical drawings: vector-geometry traversal with OCR; drafter-assisted polyline interpretation; and annotation-driven extraction. A parallel line of work — DimensionX — explores pure vector measurement in the absence of OCR.

Business outcome: establishes the technical pathway to automated estimation workflows and a step-change in quoting throughput.

Python
PyMuPDF
RapidOCR
Shapely
NetworkX
Graph algorithms