Data Analyst/ Reporting Analyst/ Business Analyst

JIE SONG

416-***-**** *************@*****.*** ** Becca Hall Trail, Toronto, M1V2T7

HIGHLIGHTS OF QULIFICATIONS

Over 2 years hands-on experiences on data analysis and problem-solver with expertise in most edging analytical tools

Deep understanding of full lifecycle of data analysis, data modeling, and statistical analysis such as correlation, classification, hypothesis testing, confidence interval, multivariate regression

Versatile communicator delivering outstanding presentations and actionable recommendations

Technical skills: Advanced Excel (Pivot Table, V/H-lookups, Macros), SQL server, MySQL, SSMS, Python, Tableau, Microsoft Office Suite (Word, PowerPoint)

EDUCATION BACKGROUND

Master of Engineering in Industrial Engineering, University of Toronto 2016-2018

GPA: 4.0; Related courses: Introduction to Data Science and Analytics; Algorithms and Data Structures; Non-linear Optimization; Project Management; Operations Research

Bachelor of Engineering, Zhejiang University 2012-2016

PROFESSIONAL EXPERIENCE

Project Assistant, DAXUE Consulting 2016/03-2016/05

Optimized marketing strategies of a European RCV company by collecting and analyzing 9 competitors’ financial statements and KPIs over past 5 years; Presented data-oriented recommendations to management.

Conducted quantitative offline & phone surveys and extracted, transformed and loaded surveys to spreadsheets.

Led the customer data acquisition and achieved customer segmentation analysis by Excel.

Initiated client and competitor analysis, market entry feasibility and global market trends by consolidating internal and external financial performance and sales data to provide actionable high-level strategies.

PROJECTS EXPERIENCE

Predictive model design about credit card application to minimize default risk 2019/02-2019/04

Developed binary classification model for credit card default and applied AUC performance metric to measure the effectiveness of the model using Excel

Evaluated the model for over-fitting by applying the model to test set

Developed multivariate linear regression model for bank profits (LINEST Function in Excel) to forecast each applicant’s expected profitability

Analyzing user data to increase the number of tests customers complete on websites 2019/01-2019/03

Built Structured Pyramid Analysis Plan to guide data analysis

Translated business questions into SQL queries and retrieved data from MySQL databases that contain over 1M data

Combined and manipulated data from multiple tables across a database and identified the relationship between different independent variables and test completion

Provided marketing and promotion recommendation to increase user stickiness based on data analysis result.

Data mining and political sentiment analysis to predict the outcome of elections 2017/01-2017/03

Extracted data (historical tweets) from Twitter via API and stored data in MongoDB database

Parsed, cleaned and segmented data based on keywords using Python.

Developed prediction model using machine learning algorithm to calculate sentiment score for every tweet selected.

Forecasted and articulated political sentiment of electorate to wide audience with story-telling visualization.

Contact this candidate