Qingyun Yan

I'm a new graduate student from the University of British Columbia majoring in Statistics. I'd like to find a job about Data Analyst or Consulting in the area of Toronto, Ontario or Vancouver, British Columbia.

Xiaohongshu Shanghai, China

Data Analyst Intern, Operations, IT, & Support Engineering Department  Jun 2022 – Aug 2022

• Analyzed and compared the weekly business data of the department in four dimensions: location, category, personnel, and data volume;
• Imported the data with RStudio, confirmed the extreme value of the data with statistical tests, and helped the department predict two possible network crashes in advance;
• Conducted a user test for the "internal procurement platform" system, put forward the UI problems of the platform, and assisted the system in data optimization;
• Coded all the warehouses, computer rooms, and conference rooms and displayed them in the form of front-end web pages; optimized the python code, the work order upload function of the SDP system

New Media Specialist, Marketing Operation & Management Department Aug 2020 – Dec 2021

• Independently published 30 articles of which most received more than 20,000 views; 
• Captured massive opinions online towards the hot issues and conducted relevant sentiment analyses;
• Infiltrated marketing through articles concerning social issues with a specific educational perspective;
• Tracked the progress of the cross-department cooperation and time management, provided relevant statistics for the KPI evaluation of the team

The University of British Columbia Vancouver, Canada

Bachelor of Science in Statistics (transferred from Engineering, 2020) May 2023

Relevant Courses: Linear Algebra for Engineers, Engineering Communication, Engineering Analysis III, Software Construction, Applied Linear Algebra, Advanced Methods for Human-Computer Interaction, Introduction to Relational Databases