Andy Cai Email & Phone Number

Sydney, New South Wales, Australia

• Develop and maintain tailored automated dashboards for competitor price intelligence, sales reporting and cost reporting, to track the performance of over 15,000 Woolworths products against competitor equivalents and.
• Develop automated CI/CD data pipelines of up to 30 tables from source data to final Tableau input using BigQuery and Airflow
• Improve team processes by introducing version control and use of CI/CD pipelines into projects
• Collaborate with a multi-disciplinary team of data scientists, data engineers and Tableau engineers to design project solutions

Sydney, New South Wales, Australia

• Developed and maintained Python codebase which automated Snowflake querying and calculation of a suite of 100+ metrics
• Collaborated on developing a Python codebase which mimicked the calculations and format of 15+ reports from Quantium’s retail product suite, used for analytical testing
• Developed and coded the definitions of three new metric features that were added to Quantium’s retail product suite

Conducted tutorials of more than 20 students to teach two courses: Probability and Mathematical Statistics & Actuarial Data and Analysis

• Consolidated APRA annual fund-level superannuation statistics of 250 superannuation funds fordata projections
• Reviewed a customer serviceability calculator with 53 test cases to ensure updated version ofmodel remained consistent with previous models
• Assisted in audit of a life insurance client to ensure accuracy of numbers reported in headactuary’s Financial Condition Report and valuation reports

Bachelor Of Actuarial Studies/Bachelor Of Commerce, Finance, General, 86.375 Wam

Activities and Societies: Actuarial Society of UNSW (Multimedia Director), University Network for Investing and Trading Competitions.

99.70 Atar

Activities and Societies: School Vice Captain, SRC Secretary, Sergeant in school's army cadet unit