Andrew Gao

Data Analyst at Australian Curriculum, Assessment and Reporting Authority
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Sydney, New South Wales, Australia, AU
Languages
  • Chinese Elementary proficiency
  • French Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Data Analysis with Python
    freeCodeCamp
    Dec, 2021
    - Nov, 2024
  • Legacy Full Stack
    freeCodeCamp
    Dec, 2021
    - Nov, 2024
  • Quality Assurance
    freeCodeCamp
    Dec, 2021
    - Nov, 2024
  • Back End Development and APIs
    freeCodeCamp
    Nov, 2021
    - Nov, 2024
  • Data Visualization
    freeCodeCamp
    Nov, 2021
    - Nov, 2024
  • Front End Development Libraries
    freeCodeCamp
    Nov, 2021
    - Nov, 2024
  • JavaScript Algorithms and Data Structures
    freeCodeCamp
    Oct, 2021
    - Nov, 2024
  • Responsive Web Design
    freeCodeCamp
    Oct, 2021
    - Nov, 2024
  • Scientific Computing with Python
    freeCodeCamp
    Oct, 2021
    - Nov, 2024

Experience

  • Australian Curriculum, Assessment and Reporting Authority (ACARA)
    • Australia
    • Education Management
    • 1 - 100 Employee
    • Data Analyst
      • Nov 2020 - Present

      I help with the collection of data and subsequent data processing for eventual reporting on the My School website, Australian Schools List website, Australian Schools reports, and occasionally custom requests. This predominantly involves SAS and Excel data cleaning/manipulation. I help with the collection of data and subsequent data processing for eventual reporting on the My School website, Australian Schools List website, Australian Schools reports, and occasionally custom requests. This predominantly involves SAS and Excel data cleaning/manipulation.

  • Precision Economics, LLC
    • United States
    • Financial Services
    • 1 - 100 Employee
    • Research Analyst
      • Jul 2019 - Nov 2020

      I worked on the creation of expert reports in litigation cases, with a focus on transfer pricing. Day-to-day responsibilities included researching case documents, preparing exhibits and citations, and helping implement economic theory into argument. I worked on the creation of expert reports in litigation cases, with a focus on transfer pricing. Day-to-day responsibilities included researching case documents, preparing exhibits and citations, and helping implement economic theory into argument.

  • Cornell University
    • United States
    • Higher Education
    • 700 & Above Employee
    • Research Assistant
      • Aug 2016 - May 2019

      I run and record research studies for the Johnson School of Business.

    • Library Assistant
      • May 2016 - Aug 2016

      I helped with shipping books, delivering mail and managing packages for the various libraries in Cornell.

  • Analysis Group
    • United States
    • Business Consulting and Services
    • 700 & Above Employee
    • Summer Analyst (Litigation)
      • Jun 2018 - Aug 2018

      The internship involved performing analysis on litigation cases regarding mergers and acquisitions, mutual funds and 10b-5 securities fraud. Analysis included creating exhibits in Excel, running regression estimates in SAS/Stata, compiling data from sources such as Bloomberg and quantifying damages. The internship involved performing analysis on litigation cases regarding mergers and acquisitions, mutual funds and 10b-5 securities fraud. Analysis included creating exhibits in Excel, running regression estimates in SAS/Stata, compiling data from sources such as Bloomberg and quantifying damages.

Education

  • Cornell University
    Bachelor's degree, Economics
    2016 - 2019
  • UNSW
    Bachelor of Commerce - BCom
    2015 - 2015

Community

You need to have a working account to view this content. Click here to join now