Ben Lai

Survey Officer (Land) @ Lands Department

About

- Spatial data specialist focused on turning manual, error‑prone map work into auditable, automated workflows using ArcGIS/QGIS, Python, and Azure DevOps. - Build end‑to‑end “field‑to‑office” pipelines: mobile scanning to 2D/3D plans, point‑in‑polygon counts, spatial joins, and master‑table updates that cut processing time from a full day to under 30 minutes. - Ship clear dashboards and report packs so planners, inspectors, and managers can verify zones, counts, and links at a glance with traceable geometry and data lineage. - Open to opportunities in business analysis, Korean translation / event organizers. - Using AutoCAD to production Construction and pipeline drawings - Microsoft Excel Dashboards and reporting - Oracle SQL Developer - UEM remote device management - 2D & 3D model scanning

Country

Hong Kong SAR

City

Hong Kong

Industry

Information Technology & Services

Skill

JavaScript, Land Surveying, Geographic Information Systems (GIS), Civil Engineering, Korean Translation, ArcGIS Pro/Online, QGIS, Point‑in‑Polygon, Geoprocessing, Reporting, Workflow Automation, Field‑to‑Office Capture, Measurement & Inspection, Microsoft Clipchamp, SQL, 3D Modeling, 2D Plan, Floor Plans, Remote Device Management, Airwatch

Experience

Survey Officer (Land)

Lands Department

2022-1 - Present · 4 yrs 9 mos

Hong Kong SAR

Working at Business and Data Analysis Section Scope: Mobile and Web App developement on village house and grave surveys; Business flow restructure and automation on household counts by custom polygons; inspection scheduling and status tracking. Provide client technical support; communication support among service contractor, project manager and client on and off site through Azure DevOps and Excel dashboards, as well as checking data by Oracle SQL Developer. Produce training materials and promotion videos. Tools: ArcGIS Pro/Online, QGIS, Python, SQL, Azure DevOps queries/tags/linked issues/dashboards. Outputs: PDF/DXF maps, verified polygon geometries, point lists per zone, spatial‑join summaries, master‑table joins. Impact: Replaced print‑and‑count workflows; reduced cycle time ~90% and improved auditability of counts and boundaries. Projects Field scan to 2D floor plan: mobile capture → cleaned 2D plan (PDF/DXF) → labeling, scale, viewpoints; before/after time and accuracy comparison. Spatial analytics pack: point‑in‑polygon and spatial join pipeline with reproducible notebooks and dashboard snapshots. DevOps visibility: query presets, tagging schema, linked issues, and stakeholder dashboards for issue flow and SLA.