×
Daniel Wong Jerng Foong

Daniel Wong Jerng Foong

Data analytics and GIS

No 359, Jalan 5/54, Taman Petaling, Seksyen 5, Petaling Jaya, Selangor, US
Bahasa Malaysia, Cantonese, English

Background


Work Experience

Work Experience

  • Senior Associate, Regional Network Planning, Lazada Logistics Malaysia

    May, 2023 - Present

  • Senior Associate, Network Planning, Lazada Logistics Malaysia

    Jan, 2023 - Jun, 20235 months

  • Associate, Network Planning, Lazada Logistics Malaysia

    Jan, 2022 - Dec, 202211 months

    • Map and analyse transportation network consisting of First Mile, LH, Lastmile using GIS tools like QGIS

    • Extract and use SQL tools to analyse and present data for decision making

    • Forecast trends on network volume to impact facility build and setup/closure

    • Build dashboard reports

  • Associate, Payment and Analytics, Lazada eLogistics Malaysia

    Nov, 2020 - Jan, 20221 year 2 months

    • Drive automation projects by providing gap analysis and gathering feedback conducting requirement sessions

    • Used Power Query and M Language to consolidate multiple sources of data into existing consolidated payment file

    • Reduced processing time for manual processing associated with payment files in Excel

    • Follow up with subcons to gather invoices during month-end payment period

    • Train team on Power Query functions to streamline manual process

  • Post Graduate Student. Master of Decision Science, Universiti Utara Malaysia

    Sep, 2018 - Oct, 20224 years 1 month

    My research interests are Operation research, Meta-heuristics and Optimization

    • Obtained a score of 4.0 overall GPA

    • Gained technical skills in Python, Matlab & Visual Basic

  • Functional Consultant, Careware Systems Sdn Bhd

    Aug, 2017 - Aug, 20181 year

    • Get system requirements

    • Map customers process flow against standard flow and identify gaps

    • Prepare business flow documentation

    • Conduct training and UAT

  • Support Consultant, Tectura

    Jun, 2015 - Dec, 20161 year 6 months

  • Functional Consultant, Tectura

    Oct, 2014 - Jun, 20158 months

    Implement GST solution-Lead consultant for 4 GST projects. Prepared training notes, and conducted training for customers to successfully knowledge transfer and train users. Provided post-live support up to 2 months after GST-go live in April 1st 2015

  • Functional Consultant, 9 Dots Consulting

    Feb, 2014 - Jul, 20145 months

    Functional Consultant for Microsoft AX

  • Business Analyst, Advance Infosys Sdn Bhd

    Feb, 2012 - Sep, 20131 year 7 months

    Advance Infosys is a Microsoft Navision vendor. I was involved in 2 full life-cycles of ERP implementations. One was in the Remittance business, and the other a large electrical appliance retailer. In this job I got a better understanding on costing methods, and how separate modules work together in a full-fledged ERP system. I was also involved in gathering requirements, drafting functional requirement documents, and testing customisations.

  • Account Executive, Columbia Leisure Sdn Bhd

    May, 2011 - Dec, 20117 months

    Columbia Leisure is a medium size travel agency which mainly dealt with inbound tours. Their main clientele were Taiwan, and China tourists. In my role as account executive I was in charge of bank reconciliations, TT transfers, and credit card transactions. I also had to liaise with hoteliers as they were the main suppliers for boarding for the tourists. In this job, the biggest challenge was to manage the cash flow as incoming funds were seasonal.

  • Finance Officer, Malaysian Care

    Jul, 2010 - May, 201110 months

    My second time in Malaysian Care . I was in charge of the full set of accounts , budgeting , bank reconciliation and report directly to the Finance Director. I also provided ad hoc support to Project Managers on enquiry on Project Funds. In this job, I learned to handle full accounting set, as well to manage two assistants and interns.

  • Business Analyst, Deloitte

    Aug, 2009 - Jul, 201011 months

    Deloitte ERS core business are IT audits. They provide due diligence IT audits for Financial audit partners. During my time here I was involved in IT audits on SAP and UNIX based systems. These are risk based audits , and we had to identify risks, and mitigating controls. We worked mostly in teams of 2-3 people per engagement. I learned a lot on risk management concepts as we had to sit for the CISA (Certified Information System Auditor) paper, in which I passed.

    • Passed CISA sitting in first try

  • Account/IT Staff, Malaysian Care

    Jul, 2007 - Oct, 20092 years 3 months

    Malaysian Care is a Christian based NGO with services in Drug rehab, Learning Disabled, and Rural/Urban poor. During my time here, I implemented the ACCPAC accounting system, and retired their manual accounting processes to system. I served a dual role, providing IT support (mostly hardware and network) as well as a daily part-time role in the finance department.

  • Software Support, Careware Systems

    Dec, 2005 - Jun, 20071 year 6 months

    Careware Systems are vendors for the ACCPAC brand ERP software. In this job I was assisting the senior consultants in their ERP implementations and ad hoc support ,software installation, and user training. In this job I learned how to setup an ERP system , especially on Accounts Receivable/Payable side. I also picked up skills in data massaging, especially in Excel for data migration purposes.

  • Software Support, Ideal Perfect

    Jun, 2005 - Dec, 20056 months

    Ideal Perfect are vendors for the UBS accounting software

Projects Experience

Projects Experience

  • Senheng Electric Malaysia

    Dec, 2012 - Mar, 20133 months

  • Merchantrade Asia Sdn Bhd

    Aug, 2012 - Feb, 20136 months

  • RBS Bank

    May, 2010 - May, 20101 day

  • Koperasi Sengoi Perak Pribumi

    - Present

  • Sunway University College

    - Present

  • Taylor University College

    - Present

Skills

Skills

  • Scripting

    R

    Linear Programming

  • Database

    Postgres

    Maxcompute-Alibaba

    PostGIS

  • GIS

    QGIS

    sf package (R)

    PostGIS

    Shapefile manipulation

    Google API geocodings

  • BI

    PowerQuery (Excel)

    Dashboards

  • Optimisation and Operations Research

    Excel Solver

    Linear Programming

  • Administration

    Git

    JSON

    Postman

  • R programming

    tidyverse

    sf

    httr

    jsonlite

  • Discrete and System Dynamics simulation

    Vensim

    Arena

Education

Education

  • Decision Science, Masters , Universiti Utara Malaysia

    Oct, 2018 - Sep, 2022

  • Accounting, Bachelor of Accountancy, Universiti Tenaga Nasional

    Dec, 1999 - Dec, 2004

  • SPM, , SMK Damansara Utama

    Dec, 1994 - Dec, 1998

Certificates

Certificates