Talk to sales Try for Free
Yanyu Li

Yanyu Li

Senior Manager Assistant, Intern

Followers of Yanyu Li127 followers
location of Yanyu LiChatswood, New South Wales, Australia

Connect with Yanyu Li to Send Message

Connect

Connect with Yanyu Li to Send Message

Connect

  • Timeline

  • About me

    Senior Data Engineer / Analyst

  • Education

    • National Taipei University of Technology

      2015 - 2015
      Exchange Student Material Physics 4.0/4.0

      One semester's exchange program

    • University of Sydney

      2016 - 2018
      Master of Information Technology and Master of Information Technology Management Management Information Systems, General Distincition

      Activities and Societies: Working as a casual research assistant for School of Public Health; Summer research scholarship project for School of Information Technology; Volunteered for NSW International Student Welcome Desk at Sydney Airport; Event volunteer for Lord Mayor's Welcome to International Students 2018 Be passionate about work and challenges;Experienced skills to communicate with people from different cultures;Quick learner and hard worker;Web developer (Javascript / Wordpress);High responsibility;

    • Pohang University of Science and Technology

      2016 - 2016
      Exchange Student Material Physics

      One semester's exchange program;Scholarship fully supported by China Scholarship Council

    • University of Science and Technology Beijing

      2012 - 2016
      Bachelor of Engineering - BE Materials Physics 84/100

      Activities and Societies: Member of Chinese university students visiting Japan project (Scholarship project); Vice Director of International Exchange Association, Part-time receptionist for International Office

  • Experience

    • Beijing Benz Automotive Co., Ltd.

      Oct 2015 - Jan 2016
      Senior Manager Assistant, Intern

      Interactive interpretation between the senior manager and group leaders in the morning meeting (English - Mandarin);Quality inspection of cars production lines;Slides preparation for the senior manager

    • University of Sydney

      Mar 2018 - now
      Lab Helper

      Python helper in tutorial classes at the School of Business. (Courses: Predictive Analytics / Machine Learning for Business)

    • Industrial and Commercial Bank of China, Sydney

      Apr 2018 - Jun 2018
      Information Technology Intern

      Maintenance and update of business operation forms database (SQL Server)

    • RASSURE

      Sept 2018 - now

      - Implemented auto-audit system for sold airline tickets by processing airlines' commercial data, using MySQL and Python. Transformed air tickets business logic into computer program-based auditing system.- Implementing data process pipelines solution, using MySQL Stored Procedures driven by Python on Airflow.- Achieved data process automation both on Cloud and on-premises- Handle the program codes on the cloud (GitHub, AWS S3)- The auto-audit air tickets system processed 100+ million data records per client weekly.- Expertise in ATPCO Air Tickets Rule, Tax, Fuel Surcharge(YQYR) documents interpretation, solid knowledge in IATA sales data, PNR data, and the GDS system- Daily/weekly meeting with stakeholders to update project status, gather requirements, and discuss project plans- Generating business analytics results for airline clientsTechnical skills in use:- Data Analytics: MySQL, Python, Excel, VBA,- CICD: Jenkins, Github- Cloud: AWS S3- ETL Pipeline: AirflowProject Management skills in use:- Agile, Jira, Confluence Show less

      • Senior Data Engineer / Analyst

        Jul 2022 - now

      • Data Engineer / Analyst

        Sept 2018 - Jul 2022

  • Licenses & Certifications

    • AWS Certified Solutions Architect – Associate

      Amazon Web Services (AWS)
      Sept 2025
      View certificate certificate

    • Training of Customer Services

      TAFE NSW
      Oct 2017

  • Honors & Awards

    • Awarded to Yanyu Li
      Summer Research Scholarship The University of Sydney Nov 2017 Developed an integrated cancer risk assessments portal as a decision-making tool for general practices and nurses to do cancer pre-screening for patients;Researched and found out the limitation of current pre-screening scenario;Designed experiment of user tests and collected data from users;Analyze the experiment data and wrote a report of it.
    • Awarded to Yanyu Li
      Excellent undergraduate students exchange scholarship China Scholarship Council Feb 2016
    • Awarded to Yanyu Li
      Chinese university students representatives visiting Japan scholarship Ministry of Foreign Affairs of Japan Dec 2014

  • Volunteer Experience

    • Member of Lord Mayor's Welcome to International Students 2018

      Issued by City of Sydney on Mar 2018
      City of SydneyAssociated with Yanyu Li

    • Crew member of International Students Welcome Desk

      Issued by Sydney Airport on Dec 2017
      Sydney AirportAssociated with Yanyu Li