Ong Pei Yong

Data Engineer / SQL Developer

Email: florexong99@gmail.com

Phone: 011-1198 5387

Location: Selangor, Malaysia

GitHub: github.com/florexong

LinkedIn: linkedin.com/in/ong-pei-yong

Professional Summary

Versatile and proactive Data Engineer with hands-on experience in building ETL pipelines, managing data warehouses, and delivering business intelligence insights. Demonstrates strong skills in Python, SQL, and system administration. Adept at streamlining data processes, ensuring data governance, and supporting decision-making through analytics and reporting tools.

Technical Skills

Data Engineering

ETL/ELT Pipeline Design
Data Warehouse Architecture
Data Modeling

Programming/Development

Python
DBT Core
SSIS
Git

System Admin

Linux (Debian/Ubuntu)
Docker
Network Configuration
Server Management

Database

SQL
AWS Redshift

BI Tools

Power BI
Tableau
SSRS

Security

Data Encryption
Data Governance

Professional Experience

SQL Developer – Swap Asia

Petaling Jaya, Malaysia | Jul 2023 – May 2024

Improved Power BI dashboard performance by solving a critical query issue in under a month.
Modified and deployed SSIS packages, integrating Cozyrocs for smooth execution.
Deployed SSRS financial reports to enhance data-driven decision making.
Automated EDI exports from SQL Server using SSIS and SFTP for secure delivery.
Implemented AES-256 encryption to ensure PDPA compliance in SQL Server.

Junior Data Engineer – Whip Mobility

Selangor, Malaysia | Jul 2022 – Jul 2023

Designed complete data infrastructure including ETL/ELT pipelines and a centralized data warehouse.
Cut manual ETL time by 90% by implementing automated tools.
Maintained data accuracy >90% across the pipeline and applied governance policies.
Created tailored data models and maintained DBT Core SQL queries for analytics needs.

Software QA Analyst – Whip Mobility

Selangor, Malaysia | Jan 2022 – Jun 2022

Ensured successful integration of third-party APIs through comprehensive testing.
Supported new feature launches with thorough QA testing cycles.

Education

Bachelor of Computer Science (Hons) – Specialization in Data Science

Multimedia University, Cyberjaya | Dec 2018 – Dec 2021 | CGPA: 3.1 / 4.0

Projects

Home Lab Server

May 2024 – Present

Hosted on Debian 12 using Docker containers.
Runs Jellyfin, P2P file sharing, and multiplayer game servers (e.g. Minecraft, Palworld).
Configured remote access via ZeroTier virtual LAN.

Certifications

SAFe 6 Practitioner – Scaled Agile

Languages

English | Chinese | Malay | Hokkien