Andrea Huo
Edmonton,AB
Summary
Enthusiastic Data analyst with proficient problem-solving skills with sufficient experience in data processing including simulating, planning, forecasting, analyzing, and modeling data. Strong communication, organization, and time-management skills. Comprehensive background in Excel, SQL, R and VBA.
Overview
2
2
years of professional experience
Work History
Data Management Analyst
LUMIST
Toronto, ON
02.2020 - 06.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.
Lab Data Analyst
The First Affiliated Hospital of Soochow University
Suzhou, China
05.2019 - 09.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
Education
BBA - Operating Management(After-degree)
University of Alberta
Edmonton, AB08.2022
Bachelor of Science - Food Science / Nutrition (double Major)
McGill University
Montreal, QC08.2020
Skills
- SQL
-MS Access
-Mysql
-Tableau
-Oracle
- Excel
- VBA
- R
- Supply-Chain Network, planning, pricing, and managing inventory
- Designing relational database
- Statistical forecasting skills with ForecastX
- Strategic and tactical business decision making
- Designing data flow structure by using Arena
- Simulating and analyzing data flow by using @Risk
Language
- English
- Mandarin
Timeline
Data Management Analyst
LUMIST
02.2020 - 06.2021
Lab Data Analyst
The First Affiliated Hospital of Soochow University
05.2019 - 09.2019
BBA - Operating Management(After-degree)
University of Alberta
Bachelor of Science - Food Science / Nutrition (double Major)
McGill University
Similar Profiles
Keisha MavungaKeisha Mavunga
Brand Associate at Banana RepublicBrand Associate at Banana Republic
Wayne NormanWayne Norman
Security Officer at Comissionair Northern AlbertaSecurity Officer at Comissionair Northern Alberta
Mandeep SinghMandeep Singh
Rail Car Mechanic at Canadian National Railway (CN)Rail Car Mechanic at Canadian National Railway (CN)
Asitha RanasingheAsitha Ranasinghe
OPERATIONS SUPERVISOR at ISLZ Logistics LtdOPERATIONS SUPERVISOR at ISLZ Logistics Ltd
Victoria CarvalhoVictoria Carvalho
Data Management Analyst at CBREData Management Analyst at CBRE