Aloysius Ong
🙂

Aloysius Ong

Data Analyst in Singapore

Looking for Data Analyst roles

10 months ago

Two years of data analytics and business intelligence experience in ETL pipelines, dashboard building and data analysis. Highly skilled in Python, SQL, Alteryx and Tableau for data cleaning and manipulation, statistical analysis and data visualization. Experienced with consulting cross-functional stakeholders on dashboard requirements, along with translating business requirements into data requirements. Successful track record of accurately conducting data pipeline and dashboard improvements to ensure data integrity and accuracy are achieved.

Projects

Ongoing

Organized and presented at numerous meet ups since 2023 to share Tableau tips and dashboard best practices.

Features

2022

Passion data viz project was chosen by the Tableau Public Team to be printed and displayed at the 2022 Annual Tableau Conference held at Mandalay Bay, Las Vegas.

Work Experience

2022 — 2023
Reporting Data Analyst at TikTok
Singapore

Tasked with implementing automated weekly reports for the Data Defense and Access Assurance (DDAA) Team and the Global Legal Team. Responsible for maintaining and creating data pipelines and dashboards.
▪ Conceptualized and implemented a custom ETL process using Hive SQL that processed more than 1M records per day, visualizing the outputs in an automated report built with TikTok’s internal dashboarding tool.
▪ Designed a comprehensive visual representation illustrating the intricate interdependencies between over 20 SQL and PySpark scripts; reducing average error resolution time by 90%, from 2 days to 30 minutes.
▪ Analyzed data from more than 100,000 employees and external vendors to evaluate user permissions and access.
▪ Maintained existing data systems to ensure relevant dashboards and data pipelines are operating at more than
90% uptime.

2021 — 2022
Business Intelligence Developer at InfoCepts Technologies
Singapore

Responsible for building ETL pipelines and automated reports for the Credit Due Diligence (CDD) Team at an international financial institution. Oversaw the testing of newly created data fabrics and reduced run-time of queries.
▪ Incorporated Python scripts within Alteryx to automatically refresh Tableau dashboards every 15 minutes.
▪ Managed redevelopment of existing Alteryx workflows in use by 10 employees; reducing run-time by 85%, from 6 hours to 1 hour every week.
▪ Cut projected time for testing newly created fabrics by one week by developing reusable ETL components using Alteryx and Excel for test reports.
▪ Practiced Agile Scrum methodology for project management, including facilitating daily stand-up meetings, sprint planning and retrospectives.

2020 — 2021
Data Analyst Intern at Shimano (SEA Division)
Singapore

Developed weekly performance reports and analytical dashboards for sales and finance teams, using data insights to drive procurement opportunities and highlight supply chain risks.
▪ Led the transition to an automated report practice by implementing dashboards in QlikSense as a faster and more accurate system; reducing the cost of labor by more than 90%, from 2 days to 15 minutes every week.
▪ Spearheaded semi-automated report generation using ETL scripts within Python and QlikSense; reducing the cost of labor by 90%, from 1 day to 30 minutes every week.
▪ Drove and advocated for a data-driven culture - e.g. pitched for a change in report practices from manual Excel reports to automated QlikSense dashboard reporting.
▪ Advised and translated business requirements into technical dashboard specifications, as well as completing a mock-up design in Figma to present to business stakeholders

Education

2018 — 2022
B.A (Hons) Business Analytics at Nanyang Technological University
Singapore

▪ Demonstrated consistent dedication by posting on LinkedIn for 363 consecutive days in 2020, learning and showcasing data visualizations created in Tableau and R.
▪ Officially selected to be a Tableau Public Featured Author in September 2020.

Certifications

2022

Demonstrate the fundamental skills needed to create, manage and monitor DAGs on Apache Airflow effectively.

2022 — 2024

Able to design analytic applications, build custom macros and perform advanced data preparation.

2022 — 2024

Able to use the core toolset to clean, prepare, blend, parse, transform and analyze data.

2021 — 2022

Served a year as a Social Media Ambassador for Tableau from September 2021

Contact

GitHub
Twitter
Tableau Public
LinkedIn