Data Analyst

Yunhan (Abby) Li

347-***-**** ****.******.**@*****.*** https://www.linkedin.com/in/yunhanli/

EDUCATION

Columbia University Feb. 2020

Master of Science in Enterprise Risk Management (STEM) – GPA 3.75 New York, USA

• Courses: Traditional Risk Management, Quantitative Methods, ERM Modeling, Financial Risk Management Tamkang University Jul. 2018

Bachelor of Business Administration in International Business & Accounting (Double Major) – GPA 3.91 Taipei, Taiwan

• Courses: Statistics, Accounting I II III, Financial Management, Auditing, Macroeconomics, Microeconomics

• Honors: Academic Merit Scholarship, Business School (Rank 1st in the department) PROFESSIONAL EXPERIENCES

Financial Data Analyst Sep. 2019 – Dec. 2019

The Wright Star LLC New York, USA

• Streamlined the data scraping process of 160+ stocks’ daily quotes and quarterly company financial ratios to update database resulting in increased data quality and data integration efficiency by 200% using Python

• Performed financial statement projections, DCF valuations, EBITDA valuations and sensitivity analyses for companies in interest from different industries to provide investment recommendations using Excel

• Developed a stock evaluation system that scores financial indicators based on their positions in the population distribution from corresponding industries to filter out unhealthy stocks by 35% using Python

• Evaluated the risk level of targeted companies by building an integrated risk model and metrics which consider potential financial risks, operational risks, strategic risks and short-term stock performance in Excel Business Analyst Jun. 2019 – Aug. 2019

NetEase Corp. E-Commerce Division Zhejiang, China

• Optimized the return policy by clustering and analyzing the population characteristics of different return behaviors using Excel pivot table, statistical t-test, and visualizations

• Applied financial models to perform profit & loss analysis on 5k+ SPU items to investigate the factors attributable to unprofitable products’ high costs for more than 80% of the items and improved the expense evaluation logic

• Researched on mitigations of compliance risk on current expense-reimbursement process and helped to develop a digital expense management system with control points and standard documentation requirements

• Analyzed the root causes of customers’ favorable reviews by studying 100k+ feedbacks (free text) and constructed these root causes as the business’s core competency to enhance the user experiences using Python and SQL Accountant Assistant Jun. 2018 – Aug. 2018

Zhejiang Materials Industry International Co., Ltd. Zhejiang, China

• Managed accounts of daily collections and payments by using the SAP system

• Reviewed the invoices of various departments, improving the collaboration and communication efficiency ACADEMIC PROJECTS

Enterprise Risk Management Program for Uber (NYSE:UBER) Winter, 2019

• Proposed a future state COSO & value-based ERM frameworks for Uber after analyzing current risk control practices

• Quantified the enterprise risk exposure in risk scenarios by conducting financial projections using DCF methods Risk Analysis for Bitcoin Investment Fall, 2019

• Evaluated the market, liquidity and cybersecurity risks of bitcoin investment and analyzed potential losses and returns via Monte Carlo Simulation in Python to find the revenue distribution; made investment decisions based on the company’ risk appetite, ROC, the 95% daily VaR and Expected Shortfall gained from the simulations in Python Everest Re Group (NYSE:RE) Economic Capital Modelling Spring, 2019

• Utilized poisson, lognormal, exponential and other distributions to model risk exposures of reserve, premium, asset and catastrophe risks via @RISK™ and analyzed economic capital needed (insurance company data)

• Calculated VaR using historical method, normal distribution method, and Monte Carlo via Excel SKILLS & CERTIFICATES

• Skills: SQL, Python, Tableau, Visio, Word, PowerPoint, Excel (pivot table, VLOOKUP, visualizations, etc.)

• Certificates: FRM Level II Candidate, CFA Level I Candidate

• Interests: Traveling, Swimming, Movie filming, Cooking

Contact this candidate