Van Quan Dong

Advised on cyber security reporting infrastructure; profiled data from APIs (SOAP & REST with Postman) for cyber security reporting; developed metrics/KPIs and data models for cyber metrics, including profiling, calculations, and roll-ups; designed integration methodology using Snowflake data warehouse; advised on Power BI / Microsoft Fabric integration for reporting semantic model. Advisory clients included Blackmores Limited, Cochlear Limited, and Australian Red Cross Lifeblood; built foundational data products and dashboards to support sales, operations, and cloud strategy.

Led Synapse Analytics platform development for web application performance metrics; designed security and access policies (IAM & RBAC) for Azure Cloud; built Synapse Pipelines to transform unstructured data into structured analytics on ADLS2; managed Power BI data extraction and SQL reporting.

Designed and built the Enterprise Data Lake Analytics Platform (EDLAP) on MS Cloud (ADF, Databricks, ADLS2, Delta Tables, SQL, Python, Tableau); developed analytics capacity for ALDI metrics and KPIs (Store Sales, Losses, Purchasing, Staff Turnover, Store Capacity) in Databricks; built ML models for store benchmarking using MLFlow and AutoML; led showcases/workshops to educate business teams; developed Data Quality Assessment Framework and Tableau monitoring; created Tableau Balance Score Card dashboards for 600+ stores, supporting 12,000+ employees and stakeholders; implemented scalable ETL patterns with Azure Data Factory and Databricks (PySpark, Spark SQL); designed Data Vault models and optimized Spark SQL; promoted CI/CD with GitLab on Databricks. Advisory clients included Enov8 and Cochlear Limited.