Data Analyst Social Media

Yiman(Ingrid) Yu

******@***.*** 929-***-**** linkedin.com/in/yimanyu Github: https://github.com/yy2897/Data-Analysis EDUCATION

New York University

Major in Management and System

l Related courses: Data mining and Data Warehouse (ETL), Database Design, Quantitative model, Managing in Global Economy, Financial Management

Xianda College of Shanghai International Studies University Major in Finance

l Courses: Quantitative, Econometrics, Financial Analysis, Corporate Finance, Microeconomics Expected 05/2020

06/2018

EXPERIENCE

Data Analyst, Guotai Junan Securities 12/2019-02/2020 l Gather the business needs from sales and financial product departments and transfer them to technical requirements l Based on the documents of technical requirements, I calculate benchmark indicator using different algorithm and update those indicators in the database

l Use Multi-factors Linear Regression analysis to estimate the relationship between customer acquisition, market index and revenue. Based on the regression relationship, I calculate Search Engine Marketing (SEM) Project’s ROI(Return Of Investment), BEP (Break-Even Point) and Payback Period to get the insight on effect of the SEM project and make the data report Data Analyst, The Wright Star 10/2019-12/2019

l Use Python to extract the essential industry stock benchmark data such as P/E ratio, EPS from Dow Jones Factiva l Conducted Discounted Cash Flow (DCF) valuation and Earning Per Share (EPS) estimation for multiple stocks l Analyzed stock performance using technical indicators including MACD, KDJ, and RSI to make short-term stock investment recommendation Data Analyst, Mean Value Consulting 05/2019-10/2019 l Collect and analyze the followers number change on social media and develop data visualization report via Excel & R l Proposed client pattern based on descriptive statistics & comparison analysis in Excel & Tableau l Conduct market research and competitor analysis

Investment Analyst Intern, Jidian Investment Management Co., Ltd. 06/2016-09/2016 l Analyze financial statement, balance sheets, income statements, etc. of photovoltaic companies which are preparing to be listed on New OTC Market

(New Over-The-Counter Market) and evaluate their financial situations by profitability, debt management ability and liquidity with spreadsheet l Assist the team with due diligence and prepare the related files l Collect and analyze data such as the Return of Investment, the average payback period of a photovoltaic company’s power station and financial subsidies provided by the government

l Build the Discounted Cash Flow model with Excel

Financial Analyst Intern, Dept of photovoltaic and electricity, China Merchants Securities Co., Ltd. 06/2017-09/2017 l Assist the project team with due diligence and prepare the related files l Assess financial risk and opportunities of 3 projects in order to help the team k now the overall situation of related company l Evaluate projects using Net present value and Internal rate of return model l Perform industry research

SKILLS & HOBBIES

Skills: Python(sklearn, numpy, seaborn), SQL( Mysql, Oracle), R(ggplot, dplyr), PL/SQL, Tableau, PHP, Excel (Vlookup, PivotTable), Photoshop Language: Chinese (Fluent)

Hobbies: Pipa(Level 10), Kickboxing (Blue-red Belt), Yoga, Hiking, Skiing, Snowboard, Climbing

Contact this candidate