Cloud Business Analyst

• May 2022 - Present

Data Management Analyst

• Feb 2020 - Jun 2021

Managed over 50,000 internal course data by using Excel and google drive. - Investigated efficient ways to finish work and provided better solutions to manage data including: Self-learned google-script as a beginner and wrote a script for batch processing files in google-drive for data cleaning and reduced workload from 20 hours to 30 minutes. Transferred 20,000-course data from Excel to Mysql database and classified those data by categories. Designed and implemented relational database structure based on their relations and database normalization (BCNF). Used SQL to query required data and reduced workload from 20 hours to 5 hours. Show less

Lab Data Analyst

• May 2019 - Sep 2019

Monitoring data from more than 50 patients for a project and managing all data on Excel. Organized over 200 Excels tables and combine those into one. Analyzed the tendency of change on patients' body composition by Excel tools Monitoring data from more than 50 patients for a project and managing all data on Excel. Organized over 200 Excels tables and combine those into one. Analyzed the tendency of change on patients' body composition by Excel tools

QC Analyst

• May 2018 - Sep 2018

Recorded everyday quality control data from multiple production lines on Excel. Analyzed the fluctuate on data and identify those out-liners by using Excel tools. Participate in R&D program of new flavors of ice cream. Recorded everyday quality control data from multiple production lines on Excel. Analyzed the fluctuate on data and identify those out-liners by using Excel tools. Participate in R&D program of new flavors of ice cream.

FOOD BANK COFOUNDER

• Feb 2017 - May 2018

• Set communication network with local community in order to reach out people in need • Oversaw a team of 10 to deliver the food bank services • Managed the social account on the largest Chinese social platform WeChat and posted over 30 articles • Built cooperation with large food companies like Griffith, Carrefort, Kraft Heinz, Kellogg’s, etc. • Collected is more than 12 tons of food and helped more than 3000 people in Guangdong • Held social events in local community with over one hundred participants in total • Completed McGill’s LEAN START-UP program and learned the knowledge of running a business and communicating with consumers • Participated the final presentation of LEAN START-UP program Show less