Zhenyao Dou (Gary)

Experience & Service

A brief overview of my internship experience and volunteering activities.

Internship experience

Business Planning (Data Analytics) Intern Dec 2021 – Feb 2022

Taikang Online Property Insurance Co., Ltd. · Beijing, China

  • Aligned business KPI definitions to reduce weekly reporting inconsistencies and manual reconciliation effort
  • Wrote parameterized PL/SQL scripts for data extraction, validation, and multi-source cleaning across multiple tables
  • Built Tableau / Excel dashboards and standardized report templates (daily/weekly/monthly + campaign reviews)
  • Improved the workflow from “data → reporting → review”, enabling faster insights and more consistent decision-making
Administrative Operations Intern Oct 2025

Hangzhou No. 2 High School Education Group (Tianyuan Huilan School) · Hangzhou, China

  • Supported the organization of a national foreign-language education research conference (on-site operations)
  • Handled equipment setup and technical support to ensure smooth session delivery
  • Organized promotional materials and participant data, improving internal documentation workflows
  • Assisted the International Department with scheduling, document proofreading, and cross-team coordination

Volunteering & campus activities

Student Support Volunteer (Peer Learning Program) Aug 2021 – Oct 2021

The University of Sydney China Centre · Suzhou, China

  • Served as a student volunteer bridge between the university and Chinese international students
  • Supported 500+ students who were unable to enter Australia during border closures
  • Helped students participate in academic activities and maintain a sense of campus community remotely
  • Strengthened cross-cultural communication, teamwork, and coordination in a student-facing support role