Yizhe Chen

Experience

• 

  中国民生银行

  Jan 2019 - Feb 2019

  Management Intern

  --Collected data in loan business and customer materials--Processed data with Excel and R, draw summary graphs with R, helped perform sales report--Help coordinate tasks of different groups.

• 

  S&P Global Market Intelligence

  Jul 2019 - Sept 2019

  Risk Consulting

  --Collected the annual report of securities companies, and obtained data from the balance sheets, income statements, and cash flow statement and imputed vital data into Excel (cash and cash equivalents, loans to clients, loans and financial liability)--Imported the data into R, processed data with Data Frame, and calculated the various ratios (net fee & commission income ratio, net interest income ratio, high-risk assets ratio, equities investment ratio, etc.) to act as quantitative references for qualitative assessment--Drew conclusions, visualized the summary, and provided them to the analysts for further analysis Show less

• 

  Opera

  Sept 2020 - Dec 2020

  Data Analyst Intern

  -Use Superset platform to visualize and monitor data of Opera News（DAU，rerention，ctr...）-Based on the needs of operations and product departments, use hive sql statements to extract user behavior data, use excel and R to analyze, sort and periodically output data reports to provide decision-making reference for business development and improvement of recommendation algorithm-Use large amounts of data to analyze user profiles and provide growth strategies for Opera News

• 

  滴滴

  Jan 2021 - Apr 2021

  Data Analyst Intern

  -Create SQL templates to for operation team and product managers, build hive SQL weekly report scheduling and tableau dashboard, saving time on weekly report by more than 2 hours-Participate in AB-test for in-trip monitoring function, analyze the safety perception of passengers under different stay duration thresholds, as well as the effects of major case reduction, conclude that major case reduction is significant at 5% level.-Responsible for strategy analysis, such as the losses caused by the interception function to the first call of potential dangerous passengers, women's car strategy -Design the time-slice rotation experiment in Mexico to test order reassigned function, taking 30 minutes as the time slice length, the average GMV and response rate are both improved at 5% level Show less

• 

  快手

  Apr 2021 - Aug 2021

  Data Science Intern

  -Partcipate AB tests such as: open T-1 pull-active flow barrel, ROI is used as the evaluation index; divide the population into layers according to the income of dsp, and the difference with the barrel which excludes T-1 users. Conclude the T-1 pull-live strategy improves the 80-100% layers by about 15%, and the rest layers are reduced-Independently design the experiment for blocking low quality ad position. Based the predicted LTV365 of ad location granularity to determine the blocking threshold. Use LTV7, 30, retention rate, etc as indicators, difference in difference (DID) method is used to calculate the improvement of the experimental group. Finally, it is concluded that the LTV improvement is significant at the 10% level-Design a click-not-pull-active frequency control strategy, block users that are not pull active after several clicks on deeplink. Use ROI as an indicator, finally, the roi will be improved by more than 6%. Show less