Shaoran Li

E-Mail: ac78vz@r.postjobfree.com Phone: 434-***-**** Address: 1904 Jefferson Park Avenue, Apt 19, Charlottesville, VA, 22903

SUMMARY OF QUALIFICATIONS

●Proficient with R, Python, SQL, SAS, Bloomberg and Visio

●Advanced skills in Microsoft Excel VBA and Access

●Additional skills: Statistical Modeling (Logistic regression, KNN, Lasso), Data Mining, Machine Learning, AWS

EDUCATION

Master of Science in Data Science, University of Virginia, Virginia, USA, GPA: 3.8/4.0 July 2018 – May 2019

Relevant courses: Statistical Computing for Data Science (R, SAS), Programming and Systems for DS (Python), Data Mining

Bachelor of Mathematics, University of Waterloo, Ontario, Canada Sept 2010 – Aug 2015

Majoring in Statistics and Actuarial Science with Finance Option, Co-op Program

Relevant courses: Generalized Linear Models and Applications, Forecasting, Computer Simulation of Complex Systems

PROJECTS

Capital One: Center for Machine Learning, University of Virginia, Charlottesville Sep 2018 – Apr 2019

●Creating alerting methodology that sits in Amazon Web Services and ingests real-time data to increase the accuracy to identify false positives in volume spikes/dips of internet traffic

●Build an alerting model to detect application downtimes to reduce costs and productivity loss with three different approach entropy, moving average convergence divergence and time series

●Construct an expectation interval for normal behavior, if the traffic falls outside of the detection expectation interval then we identify it as anomaly

Python Web Scraping, University of Virginia, Charlottesville July 2018 – Aug 2018

●Web-scraped 17000 players’ data of FIFA18 video game from kaggle.com using Panda and Numpy of Python

●Explored scraped data with scatter plots, box plots and histograms to illustrate relationship among regressors

●Conducted analysis on historical data to construct and tested machine learning models such as linear regression, lasso regression and decision tree to forecast new player’s ranking and value with 94% accuracy

●Created an interactive user interface in Python to select various queries for users to manipulate data with ease

SQL Programming, SavvyPro Education, Toronto June 17 – July 2017

●Analyzed and created corporate bond trade report templates, collateral transactions summary analysis and account liquidity disclosure reports across multiple tables using all available SQL functions

WORK EXPERIENCE

Business Intelligence analyst, Global Transaction Banking, TD Securities, Toronto Nov 2016- July 2018

●Created new macros and queries for billing procedures to improve efficiency from 2 hours to 30 minutes/month

●Interpreted high fluctuations and explained inconsistencies in interest paid to clients with interest rate changes

●Reduced discrepancy between Monthly Report Statement and Operational Review by 3% in one quarter

●Provided account analysis for regional managers by extracting transaction details with SQL coding

●Conducted, summarized and presented Financial Institution Revenue Analysis reports for 116 financial institutions with Access Databases and Excel pivot table

Actuarial analyst, ORPP implementation secretariat, Ministry of Finance, Toronto Feb 2016- Aug 2016

●Wrote, reviewed and debugged Excel VBA code for pension modeling of the Ontario population projection, including analysis for crucial factors that affect pension plan retirement, investment and demographics

●Summarized and presented sensitivity analysis of the ORPP pension model to the Associate Deputy Minister of Finance

Report Analyst, Asset Management, Hydro One, Toronto Sept 2012 – May 2013

●Utilized VBA to revise the Replace VS Repair model; constructed graphs and maintenance analysis for 20 types of equipment to assist pricing estimation

●Provided recommendations on historical data trend model selection to Asset Analytics team and proposed suggestion for management decision on budget of one million dollars maintenance expenditure

●Updated performance formulas for 10 equipment types in Excel spreadsheets to reconstruct the maintenance algorithm and increase the efficiency by 10%

VOLUNTEER EXPERIENCE

Industry Programming, Toronto International Film Festival, Toronto, Ontario Sep 2016

●Assist Industry delegates attending TIFF’s Industry Conference by answering questions, managing line-ups, and scanning passes

●Provide event support at scheduled outdoor attractions on the streets outside TIFF Bell Lightbox

Climber, World Wildlife Fund, Toronto, Ontario May 2013

●Trained for a week to climb the 1776 steps of the CN tower in 28 minutes to show support for Wildlife Fund

●Raised fund of $120 from colleagues and friends to contribute to the total amount $1,238,920

Resume Critique and Mock Interview, Math Society Waterloo, Ontario Oct 2011 – Nov 2011

●Assessed and edited resumes of university/PhD students based on workshop training

●Mock-interviewed students and addressed their communication skills with personal advice

ACTIVITIES AND INTERESTS

Human Resource Department Head, UWCSSA, Ontario May 2013 – Mar 2014

●Established proposals for events with 10 sponsors and 200 audiences within the executive team

●Interviewed and coordinated over 30 volunteers in different events

University of Waterloo Modeling Workshop, Math Society Waterloo, Ontario Sept 2013 – Oct 2013

●Extracted, analyzed and modelled financial data using Bloomberg and Excel

●Investigated firm’s economic factors, market structure and competitive advantages

AWARDS AND HONORS

●President’s Entrance Scholarship 2010 for an entrance average of 90% and over, University of Waterloo

●Alexander Rutherford Scholarship 2010 for outstanding provincial academic performance, Government of Alberta

Contact this candidate