Work Experience
Senior Analytics Engineer / Data Engineer / Senior Data Engineering Specialist at Delivery Hero
03/01/2023 - Present
Designed, built, and maintained robust and scalable data marts/models, established data governance standards, optimized performance of data pipelines, and collaborated with various stakeholders to deliver impactful data solutions.
- Designed, built, and maintained robust and scalable data marts/models to support complex analyses.
- Established and enforced data quality standards with validation checks and documented data lineage.
- Defined key business metrics and ensured their consistent calculation across the organization.
- Developed documentation and self-serve tools to empower analysts in data access and usage.
- Monitored and optimized data pipelines and queries for performance efficiency.
- Collaborated closely with product teams, data engineers, analysts, and business stakeholders.
Data Engineer at Foodpanda
04/01/2022 - 03/01/2023
Led GCP migration to reporting layer, optimized dbt models, developed data pipelines, maintained schema integrity, and conducted code reviews to uphold engineering standards.
- Led the migration of country project in GCP to the reporting layer using dbt and Airflow.
- Converted full-load models into incremental models to optimize performance and reduce costs.
- Gathered and documented data requirements across cross-functional teams.
- Developed robust data pipelines to enable efficient table movement into the data warehouse.
- Maintained downstream model integrity by incorporating upstream schema updates.
- Conducted code reviews on GitHub to ensure best practices and project standards.
Data Analyst at Foodpanda
01/01/2021 - 03/01/2022
Managed and mentored junior analysts, optimized SQL performance, developed revenue simulations, and led data-driven projects to improve key operational KPIs.
- Managed and mentored a team of junior analysts, enhancing team productivity.
- Optimized SQL queries, achieving 0% downtime for critical Tableau dashboards.
- Developed simulations in Python to optimize delivery fees and increase revenue per order.
- Led data and automation projects for operational efficiency and insight generation.
- Improved KPIs like revenue per order and basket size through market basket analysis.
- Automated commission calculations for the commercial team, saving manual hours.
Senior Officer R&D at Beaconhouse Group
02/01/2019 - 01/01/2020
Conducted academic data analysis, automated reports, and provided strategic insights through nationwide survey analysis to support education policies.
- Performed exploratory data analysis to support strategic decision-making.
- Designed, analyzed, and reported on nationwide surveys.
- Automated academic reports using Power BI, saving significant manual effort.
- Analyzed student performance data to guide subject selection for A Level exams.
Regional Officer Examinations at Beaconhouse Group
01/01/2017 - 01/01/2019
Managed examination operations for 38 branches, led a team of 20 officers, introduced data-driven reporting practices, and collaborated on academic reporting software development.
- Managed examination operations for 38 branches across the central region.
- Led a team of 20 examination officers, ensuring operational excellence.
- Introduced data analysis trends and spearheaded key reporting initiatives.
- Implemented Power BI dashboards to support data-driven decision-making.
- Collaborated with IT to develop local academic reporting software.
Projects
This Website
My portfolio website.