Data Analyst Financial

Ives Liu

**** ************ ****. 682-***-**** *********@*****.*** www.linkedin.com/in/ivesliu

Authorized work permission in any employers at United States until 2023 EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics May 2020

GPA: 3.66/4

Coursework: Applied Predictive Analytics, Database design, Data Mining, Data Visualization, Business Intelligence Central University of Finance and Economics, School of International Trade and Economics Beijing, China Bachelor of Economics in International Trade and Economics & Sep 2014 Bachelor of Business in Risk Management of Victoria University GPA: 3.5/4

TECHNICAL SKILLS

R, Python, SQL, Tableau, Alteryx, MATLAB, Google Analytics, SPSS, EViews, Data Visualization, Predictive Modeling PROFESSIONAL EXPERIENCE

Deloitte Consulting-BMW Website analyzation project Beijing, China Data Analyst (Intern) of Digital consulting department Mar 2017-Sep 2017

• Analyzed BMW website visit data to provide advice on advertising, website design and pricing strategies

• Extracted customers' cookies from BMW official website and connected to Baidu's data ecosystem to get user portrait tags

• Analyzed the website data using Google Analytics combined with user portrait tags to understand demographic characteristics, credit information, consumption preference, education background and hobbies Beijing Tuoming Technology-Credit evaluation project Beijing, China Data Analyst (Intern) Dec 2016-May 2017

• Used location data and applications usage data of 5 million China Mobile users to determine where a user lives and whether a user owns a car

• Built a back-propagation neural network model using Python to establish a credit reference system to access a user’s credit combining the results with bank data and social media data

• Extracted data from data warehouse using SQL and processed data in Alteryx for predictive model

• Provided loan recommendations to financial institutions based on the evaluation results of the credit reference system to reduce the risk of bad debts

Citibank, Beijing Branch Beijing, China

Summer Financial analyst training program Jul 2016-Aug 2016

• Participated in an Elite Training program for one month as the leader of a team of twelve

• Worked as a financial analyst, and completed a highly feasible and recognized business plan of financial products for people who had received compensation for house demolition PROJECT EXPERIENCE

Oncor Electric Delivery-Electric Vehicles charging detect project Dallas, Texas Data Analyst of Advanced Technology Department Jan 2020-May 2020

• Analyzed electricity usage of 3 million households to identify which households have Electric Vehicles (EV)

• Built an algorithm in MATLAB to disaggregate EV charging signal from household electricity consumption data and requires no training, demands a light computational load, delivers high estimation accuracy of 92% and works well for data recorded at the low sampling rate 1/60 Hz

• Embedded a dashboard into the Oncor website to allow users view their daily electric vehicle power consumption

• Analyzed consumers' energy consumption preferences to help marketers conduct precision marketing VNA Texas Hospice-Data visualization project Dallas, Texas Data Analyst Aug 2019-Oct 2019

• Analyzed 10k+ hospice records for inferring volunteer behavior pattern to provide insights of which location is the best to recruit more volunteers

• Established an interactive data visualization dashboard using Tableau to meet customers' needs of recruiting more volunteers

• Cleaned and analyzed data using Alteryx to identify key columns correlated to the target variable

• Led a team of five to work with VNA's in-house analytics team and Presented to the key executives National Hockey League-Database management project Dallas, Texas SQL Developer Oct 2019-Dec 2019

• Built a website to transform NHL data in a way that help people track the performance of their favorite teams and players

• Designed a database using Entity Relationship Diagram (ERD) and accessed it with a SQL Server database

• Created an interactive R Shiny online application that interacts with that database to perform CRUD (Create, Read, Update, and Delete) operations and basic analytics

Contact this candidate