entry level business analyst

Yidi Zhang Tel: 613-***-****

**** ***** ******* ********, ******, ON, Canada, K1V 1V1

********@*******.**

SUMMARY OF QUALIFICATIONS

• Graduate majoring in Statistics from the University of Ottawa

• Previously obtained a Bachelor of Science degree majoring in Health and Disease from University of Toronto

• Educational background in Statistics, Mathematics, Economics, Health Sciences and Social Sciences

• Expertise with Excel to perform Exploratory Data Analysis, data cleansing, validation and transformation

• Competence with VBA to elicit and analyze requirements, document requirement deliverables, communicate, verify and validate requirements

• Strong ability to query data from SQL server database

• Analysis via Python with clear visualization that effectively summarize the results

• Knowledge of ETL and combining different datasets

• Well-developed problem solving, analytical and process documentation skills

• Experience designing reports and building dashboards

• Ability to work independently and efficiently in a fast paced workplace with multiple stakeholders and competing priorities

• Professional approach with a clear and logical thought process and attention to detail

• Excellent business writing and verbal communication skills EDUCATION

Bachelor of Science, Major in Statistics 2014-2017 University of Ottawa, Ottawa, ON

• Graduation date: June, 2017

Bachelor of Science, Major in Health and Disease 2008-2013 University of Toronto, Toronto, ON

• Graduation date: November, 2013

SKILLS AND ABILITIES

SQL Server

• Built RFM by adhering to the company’s objectives

• Built CRM by setting up BI framework for the generation of report automation Excel

• Performed descriptive statistics, data cleansing and present the results in the appropriate graphs

• Evaluated various algorithm performance

VBA

• Constructed Portfolio Optimization by analyzing the requirements of efficiency frontier

• Constructed Principal Component Analysis to analyze trends in datasets Python

• Produced various plots and real-time data from Yahoo Finance to predict insurance loss

• Produced heat maps on key timelines to predict and simulate real-time housing prices WORK EXPERIENCE

Data Analyst 07/2017-09/2017

Victoria Toronto Training Center, Toronto, ON

• Portfolio Optimization in financial analysis

• Insurance loss prediction

• Customer Relationship Management in retails industry

• Data visualization and prediction with Python

VOLUNTEER EXPERIENCE

Assistant to the recreational therapist 06/2011-04/2013 Sunnybrook Health Sciences Centre, Toronto, ON

• Interacted with patients by providing guidance in the completion of the scheduled programmes

• Planned and participated in the division’s holiday craft sales and luncheons Administrative support 01/2009-01/2010

Dr Wong’s family physician clinic, Toronto, ON

• Corresponded with members of the community by providing assistance in understanding the criteria needed to fulfill to apply for the Special Diet program

• Demonstrated attention to detail by filling out the Special Diet forms

Contact this candidate