https://public.tableau.com/views/FilmsofA24/Final?:language=en-US&:display\_count=n&:origin=viz\_share\_link

Films of A24

Data Analyst

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

Tableau Ambassador

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

Alteryx Designer Advanced

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

Astronomer Certification for Apache Airflow Fundamentals

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

Alteryx Designer Core

▪ 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.

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.

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

Co-leader of Singapore Tableau User Group

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

Data Analyst Intern

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.

Reporting Data Analyst

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.

Aloysius Ong

2023