Skip to content

resume_data_engineer.md

Latest commit

 

History

History
54 lines (44 loc) · 5.25 KB

resume_data_engineer.md

File metadata and controls

54 lines (44 loc) · 5.25 KB
Raw

Daniel Wong Jerng Foong

Data Engineer / Analytics Engineer — SQL · Python · Spark/Hive-family · ETL pipelines · data modeling Bandar Rimbayu, Telok Panglima Garang 42500, Selangor, Malaysia wongjerngfoong@gmail.com | 016-3119496 | LinkedIn

Professional Summary

Data engineer with five years building and maintaining production analytical data pipelines at Lazada Logistics (Alibaba Group). Designs partitioned SQL data models and ETL workflows on Alibaba MaxCompute (ODPS) — a Hadoop/Hive-lineage, Spark-capable cloud data warehouse where SQL transfers directly to HiveSQL and SparkSQL. Implements data-quality controls, optimizes query cost, and models the data assets that power business-intelligence dashboards for regional stakeholders. A Master of Decision Science (operations research, optimization) underpins the data-modeling and analytical work, while earlier ERP and IT-audit delivery (CISA) provides end-to-end project experience across SDLC and Agile and the controls discipline that keeps production data reliable.

Core Skills

  • Data Engineering: production SQL data pipelines, partitioned table design, query-cost optimization, ETL (Excel Power Query / M), data-quality monitoring, data modeling.
  • Big Data & Platforms: Alibaba MaxCompute (ODPS) — Hadoop/Hive-lineage, Spark-capable cloud columnar data warehouse, conceptually equivalent to BigQuery / Snowflake; HiveSQL / SparkSQL (transferable from ODPS SQL); data-warehouse concepts (star schema, slowly changing dimensions).
  • Languages: SQL, Python (Python Data Structures), M; R for analysis.
  • BI & Visualization: dashboard development, enterprise BI platforms (FBI / Starwheel), Power Query / M.
  • Geospatial: QGIS, Leaflet.js, geospatial analysis.
  • Optimization: SCIP solver, meta-heuristics, mathematical optimization (Master of Decision Science research focus).
  • ERP & Delivery: Microsoft Dynamics AX / NAV, ACCPAC, SAP (IT audit); SDLC, Agile, UAT.
  • Certifications: CISA (Certified Information Systems Auditor — Passed), Python Data Structures, MS Dynamics AX 2012 R3 Financials, MCTS Dynamics NAV 2009.
  • Languages (spoken): English (Native/Bilingual), Bahasa Malaysia (Native/Bilingual), Cantonese (Limited Working).

Experience

Lazada (Alibaba Group) | Nov 2020 – Present

Manager, Regional Network Planning | May 2024 – Present

  • Build and maintain production analytical SQL data pipelines on Alibaba MaxCompute (ODPS) — a Hadoop/Hive-lineage, Spark-capable cloud data warehouse — applying partitioned table design, query-cost optimization, and data-quality controls.
  • Model data assets and maintain the data sets powering network-coverage dashboards used across regional teams.
  • Manage technical data workstreams and data migration for optimization projects, including the migration of Starwheel to LOP (internal parcel-tracking tool).
  • Implement data-engineering and geospatial frameworks to support network optimization in the Philippines (PH).
  • Collaborate with regional and technical stakeholders across project delivery.

Senior Associate, Regional Network Planning | May 2023 – May 2024

  • Developed hub-location optimization models (HELIOS) for the PH network expansion (HYPERION), preparing and validating the underlying data.
  • Provided guidance to junior team members and aligned with regional and local stakeholders.

Senior Associate / Associate, Network Planning | Jan 2022 – June 2023

  • Extracted and analyzed transportation-network data (First Mile, Line Haul, Last Mile) with SQL and GIS tools (QGIS) to support network-capacity decisions.
  • Forecasted network volumes and built dashboard reports for monitoring logistics performance.

Associate, Fleet Payment | Nov 2020 – Jan 2022

  • Automated payment data flows using Excel Power Query and M (ETL), consolidating multiple sources into reconciled outputs and reducing manual processing time.

Earlier Career — ERP Delivery, IT Audit & Finance

  • Functional Consultant, Careware Systems (2017–2018) — requirements gathering, ERP gap analysis, UAT, training.
  • Support / Functional Consultant, Tectura (2014–2016) — Dynamics support and root-cause analysis; drove GST solution implementation projects (proposal, implementation, testing) and training.
  • Functional Consultant, 9 Dots Consulting (2014) — Microsoft Dynamics AX implementations.
  • Business Analyst, Advance Infosys (2012–2013) — full life-cycle ERP implementations (remittance, retail); functional requirements and customization testing.
  • Account Executive, Columbia Leisure (2011) — cash flow, reconciliations.
  • Finance Officer / Account & IT Staff, Malaysian Care (2007–2011) — full set of accounts; implemented the ACCPAC accounting system and managed IT/network support.
  • Business Analyst, Deloitte (2009–2010) — IT audits (risk-based assessments) on SAP and UNIX-based systems.
  • Software Support, Careware Systems / Ideal Perfect (2005–2007) — ERP and UBS accounting software support, installation, and user training.

Education

  • Master of Decision Science, Universiti Utara Malaysia | 2018 – 2022 — operations research, meta-heuristics, optimization.
  • Bachelor of Accountancy, Universiti Tenaga Nasional | 1999 – 2004.