Description

Grace (Xing) Zhu

426 University Ave, Toronto, Ontario M5G 1S9        647-879-1809 · zhuxingrace0115@gmail.com

Highlight of Qualification

·          Aspiring solution oriented analyst with solid academic background in quantitative analysis and Propensity modelling, a keen interest in data quality analysis; equipped with superior attention to detail and accuracy

·          Excellent problem solver with high business acumen, outstanding interpersonal and organizational skills

·          Advanced knowledge in data analytical software and desktop applications such as SQL, R, STATA, Python, SAS, MS Excel (Pivot Tables, Solver, VBA Macros), MS PowerPoint, MS Word, Access, Outlook

·          Dynamic team player with effective verbal and written communication skills, with the maturity to work well both independently and in a cross functional team

·          Great time management skills to manage competing demands and meet tight deadlines

·          Highly self-motivated with an interest in problem solving and root cause analysis

Education & Certificates

University of Toronto St. George, Honours Bachelor of Science                                                                               Graduation: Jun 2017

·          Major in Statistics, minor in Economics and Physiology

·          SAS Institute, SAS Certified Base Programmer for SAS 9

Professional Experience

Analyst, Analytics & Insights Excite Club, Toronto, ON                                                                                                                    Jun – Aug 2017

·        Conducted industry data analysis and market trend analysis of the retail market in Canada for the past 10 years; and    predicted customer behaviors and delivered data-driven business recommendations to the marketing team

·        Analyzed the transaction size of retail market using MS Excel to estimate the market size of Canada in 5 years;          presented the analysis results on a weekly basis to the president and the 9 team members by MS Power Point

·        Approached the optimal Internet provider with lowest price in the market, resulting in over 35% savings of budget

·        Successfully optimized the platform with the technical team and promoted the app instalments by 23% compared      with the previous year

SQL Programming Trainee SavvyPro Education, Toronto, ON                                                                                               Jan – April 2017

·        Conducted standard SQL statements to create, drop, and update tables used in risk management team and fixed income team; utilized SQL functions to load financial data from multiple sources.

·        Analyzed collateral transactions from artificial dataset and generated reports to summarize analytical results

·        Utilized different SQL solutions, such as inner join, outer join, and sub-query to resolve same business questions

·        Created high-quality business reports across multiple tables using all available SQL functions

Data Management iamsick.ca, Toronto, ON                                                                                                                                         May- Aug 2016

·        Collected data of holiday operation hours from 500 clinics via cold-calling and built the database in MS Excel

·        Aggregated, manipulated, and transformed clinical data related to 1200 health care providers from multiple sources

·        Created web scraping automation tool by Python to extract, transform and load (ETL) around 10K medical   pharmacy records accurately in 10 minutes, boosted working efficiency at least by 70%

·        Assisted marketing team to develop marketing strategies and contributed to the marketing campaigns by      successfully identifying around 100 potential clients (pharmacies and clinics) across Canada

Data Analyst Research Institute of Zhejiang Hua Hai Pharmaceutical Co. Ltd, Zhejiang, China                                 May- Sep 2015

·        Cleaned data by R and maintained clinical datasets of 12K pharmaceutical records using advanced MS Excel functions;         improved data robustness by at least 15% through validation process

·        Analyzed transactional data of drugs from past 5 years (2010-2014) by SQL and MS Excel VBA

·        Identified market trends regarding to different months, and provided insightful suggestions to marketing team

·        Automated 12 detailed sales reports with written interpretation and graphical representation by utilizing MS Excel     Macro (Pivot Table) and VBA, which resulted in over 13% savings in human resource