About
More than two years of data analytics and business intelligence experience in ETL pipelines, dashboard building and data analysis. Highly skilled in Python, SQL, Alteryx, Power BI 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
Organized and presented at numerous meet ups since 2023 to share Tableau tips and dashboard best practices.
Features
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
Responsible for reporting on the health of the APAC iTero sales operations by working closely with sales, marketing, operations and services teams. Responsible for creating SQL data pipelines and Power BI dashboards.
-
Developed sales performance dashboards to benchmark sales performance against forecasts, sales funnel stage progression, leads and demo conversion rates to provide a holistic view of APAC sales.
-
Conducted comprehensive analysis to measure the performance and impact of distributors, comparing gross margins between direct and indirect sales, sales volume and market penetration. Provided actionable insights on sales targets and pricing to optimize distributor partnerships.
-
Measured the effectiveness of various rental programs in driving sales by implementing a dashboard to measure revenue growth, utilization rates and automate customer invoicing.
-
Designed the data model suited for role-level security protocol deployment to automatically calculate sales incentive payouts using SQL queries and DAX formulas in Power BI, reducing the cost of manual labor by more than 95%, from 3 days to less than a day.
-
Integrated data from various sources such as Salesforce and SharePoint files using Databricks and SQL to provide actionable insights to stakeholders.
-
Migrated data from an on-premise SQL server to Azure cloud environment, enhancing data scalability and accessibility.
Responsible for implementing automated weekly reports for the Data Defence 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.
Responsible for building ETL pipelines and automated reports for the Credit Due Diligence (CDD) Team at an international bank. Oversaw the testing of newly created data fabrics to reduce 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.
Developed weekly performance reports and analytical dashboards for sales and finance teams, using data insights to drive procurement opportunities and highlight supply chain risk.
-
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
▪ 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
Served a year as a User Group Ambassador for Tableau from September 2023
Demonstrate the fundamental skills needed to create, manage and monitor DAGs on Apache Airflow effectively.
Able to design analytic applications, build custom macros and perform advanced data preparation.
Able to use the core toolset to clean, prepare, blend, parse, transform and analyze data.
Served a year as a Social Media Ambassador for Tableau from September 2021