Sign in

Data analyst

Toronto, ON, Canada
March 04, 2019

Contact this candidate


Henry Chen


Rotman School of Management, University of Toronto, Toronto, ON Master of Management Analytics Candidate, 2019

• Specialization in data analytics

• GMAT 740/800; top 3%

• Python, PySpark, SQL, SAS, Microsoft products (e.g. Access, VBA, Vlookups, Pivot Tables), Tableau, Hadoop Nanjing University, Nanjing, China

Bachelor of Science, Major Telecommunications Minor Finance, 2018

• Specialization in Electronic Engineering, minor in Finance

• People’s Scholarship Recipient (top 15% of the class) 2016 & 2017 EMPLOYMENT EXPERIENCE

Rubikloud, Toronto, Canada

Data Analyst, August 2018 – Present

• Assess the impact of social influencer behavior on browse and purchase behavior both online and offline using analytics tools (SQL, PySpark and Python) using over 45 million data points

• Identify ad-impacted categories; cluster customers into four groups according to purchase patterns L’Oreal, Nanjing, China

Project Intern, May 2018 – June 2018

• Wrote a Python program to compile raw data from multiple sources into actionable data, increasing efficiency by 80%

• Managed the logistics and financials of a sales campaign which generated over $60,000 of revenue ranking 2nd among 34 competitors worked with YSL, Vichy and other L’Oreal brands Jones Lang LaSalle (JLL), Shanghai, China

Strategic Intern (SCON), July 2017 – September 2017

• Conducted field research for 3 potential real estate projects by conducting 20 cold calls, 3 industry expert interviews

• Synthesized regional characteristics data using SAS, giving clients comprehensive view of the region Union Bank of Switzerland (UBS), Shanghai, China

Middle Office Intern, June 2017 – July 2017

• Managed daily issuance of new Equity Linked Notes including setup and trade capture in the relevant securities systems; provided support to the front office’s daily risk management teams in London, UK Bain & Company, Shanghai, China

Part-time Assistant, March 2017 – May 2017

• Conducted competitive analysis for an educational company by leading a team of four, sent out over 100 questionnaires with 4 field interviews, analyzed raw data with SQL offering support for consultants Monitor Deloitte, Shanghai, China

Part-time Assistant, Feb 2017 – May 2017

• Collected 9 significant financial indicators from annual reports using Macro in Excel; predict future economic performance (e.g. annual gross domestic product) by running regressions in Python

• Researched government policies of different areas (e.g. logistics industry) to estimate the potential future of some particular industry by analyzing key policy changes; offering support for consultants EXTRA-CURRICULAR ACTIVITIES

NJU SKY, Nanjing, China

President and Co-founder

• Raised awareness of prominent issues within the LGBTQ community by organizing 3 campaigns with contraceptive sponsors, held 5 Women’s Rights Forums, raised attention to minority groups in campus;

• Held 1 Blood Donation event; donated 800ml of blood ADDITIONAL INFORMATION AND OTHER SKILLS

• Interests: Photography, Swimming, Running; Tutoring GMAT

Contact this candidate