David Choi

Key responsibilities

• Provide technical expert knowledge and design services in system solutions and system integration architecture to deliver integrated cloud data solutions that meet business needs.
• Produce Azure Data Lake platform architecture and data architecture design that leverages Azure data services and MS analytics solutions, including Lakehouse Medallion architecture.
• Contribute to improving the processes, defining design patterns, and mentoring junior architects as required.

Achievements

• Delivered an endorsed and secure end-to-end solution architecture design for the mission-critical Realtime Worktime Breach project under the Commercial Vehicle Safety Programme.
• Delivered an endorsed and secure end-to-end solution architecture design for the SPE project, NZTA's first-ever modern data analytics solution, leveraging modern Azure Datalake platform technology.
• Delivered an endorsed and secure end-to-end Asset Data Management System solution architecture design.

Key responsibilities

Lead the development and operation of the cloud analytics platform and data processes.

• Provide technical leadership in data lakehouse, data warehousing, and data governance.

Manage the Azure cloud platform and data assets to support business intelligence, visualization, and analysis.

Achievements

• Architected, built, and deployed an Azure data lakehouse and data platform to replace the legacy Infrastructure Data Pipeline.

• Led in the data ecosystem via data engineering, Medallion architecture, Delta Lake, data sharing, and data governance functioning in Azure Databricks.

Key responsibilities

• Contribute to CIP's data management strategy, and provide guidance to determine the most appropriate data platform strategy.

• Establish data storage solutions.

• Lead Cloud DevOps implementation.

Achievements

• Contributed to the successful transformation of Data and Analytics from a legacy Google and AWS-based platform into the modern Azure data platform by leading Azure DevOps CI/CD.

• Contributed to data solutions by introducing and implementing new ways of developing data pipelines using Azure Data Factory for data warehousing.

• Provided proof of concepts for data API, Azure Databricks, and Delta Lake.

Key responsibilities

• Lead development and technical management of platforms for CIP’s data and systems.

• Design cloud-based data solutions, and implement Azure Data Platform and change management.

• Contribute to projects as a technical architect or subject matter expert by providing technical leadership with cloud-based solutions, data integration, data management, and data service delivery.

Achievements

• Architected and implemented the backend 'Shovel Ready' Reporting System in Azure, which contained project data worth $2.43 billion.

• Designed and set up an end-to-end CIP Data Platform by building a single source of truth in Azure.

• Developed Power BI dashboarding for reporting insights.

• Developed and implemented a PoC for data warehousing and data insight using Azure Databricks and Azure Synapse Analytics.

• Designed and developed RESTful web APIs for reporting databases, and deployed them as Data as a Service in Azure.

Key responsibilities

• Lead the setup and implementation of GIS data ingestion and analytics solutions.

• Contribute to the deployment of a web GIS system.

• Take responsibility for the design, build, and integration of the GIS system.

Achievements

• Led and set up the CIP's centralised GIS Data Platform in an AWS cloud environment

• Implemented Geospatial data integrated into Azure Data Platform for a reporting project

• Developed a Power BI dashboard for geospatial data KPI reporting.

Key responsibilities

• Lead the development and integration of applications and web services within the ESRI and Microsoft platforms.
• Develop innovative and maintainable solutions using data integration tools to automate analytics and analytics workflows, to access and display data from various core datasets.
• Collaborate with team members from the DevOps cross-functional Data Analytics team to deliver successful outputs.

Achievements

• Designed and developed data warehouses and change management for various data sources, including geospatial datasets integrated into the AWS platform.
• Designed and implemented an automated machine learning process for detecting changes in land parcel use over time using images stored in an SQL database.
• Designed and implemented Dev, Test, and Production systems using Azure PaaS for Salesforce integration to the Census data hub in other Azure Data Platforms.

Key responsibilities

• Provide coaching, mentoring support and advice to GIS analysts.

• Lead geospatial projects and engagement with key users across MPI.

• Demonstrate intellectual leadership in or where necessary be responsible for leading large geospatial projects

Achievements

• Designed and developed automated data change detection system using LINZ Data Service via web API

• Improved workflow for loading and updating various datasets into SQL DBs

• Led technical sessions and provided second & third level technical support

Key responsibilities

• Provide System management and administration

• Provide Technical Support, advice and customer services

• Demonstrate continuous improvement, customer service and relationship management

Achievements

• Contributed to building the Infrastructure and data platform for 'Development and Financial Contributions' project

• Contributed to building web services for award winning 'Auckland Plan' project

• Contributed to data management of award winning 'Future Plan Framework' project

Key responsibilities

• Manage information and database systems including the PMIS database, Statistics NZ data, local body data, and GIS data.

• Contribute to procedures and processes that ensure Network Planning activities facilitate improved education outcomes for Maori and Pacific peoples.

• Provide effective Data analysis on the planning function, ensuring effective demographic analysis

Achievements

• Contributed to long range plan 'Albany Area Strategy' project

• Contributed to long range school network growth analysis for wide Auckland areas