API Churn Prediction Analysis • Obtained the public data of API service provider and utilized Alteryx to clean the address information• Identified the large enterprise activities and established the churn model for large commercial clients

• Recruited three incubators and 15 start-ups to participate in a financial funding competition and organized the judging committee to determine a winner• Partnered with numerous electric charging stations on regulation and policy as part of market research for a Clean-tech start-up company, Dynergy

• Tracked the key financial data of targeted companies in the electricity sector with Wind terminal and Bloomberg, updated the relative data bases and drafted weekly reports for the Chief Analyst and 5 clients• Delivered insights of power market by illustrating and predicting the influences of coal price fluctuations on ROE of 5 targeted companies, and proposed the annual investment strategy of electricity sector

Project: Financial Procedure Reconstruction (2nd stage) of Shou Gang Group Co., a top 500 company in China• Communicated with client needs through X interviews and pitching, independently redesigned the financial procedures of expenses with Microsoft Visio, including travel expense and conference claim• Exercised the sandbox simulation to test the new financial procedures of expenses and payables with Excel and delivered an 80-page report of the 2nd stage and two 40-slide PPTs to present the simulation results• Improved 40% processing efficiency and saved 55% of human resource cost with innovative construction outcomes

• Data Preparation for the Predictive Analysis and Optimization Project: Extracted the weekly data of class volume from user databases with SQL and visualized key insights with Tableau for budget and marketing planning optimization• Student User Segmentation and Churn Warning Strategy Project: Segmented 15,000+ elementary school students by conducting k-means clustering and behavior analysis with R, created more effective customer labeling methods, and proposed churn warning strategy for the product manager • Data-driven Curriculum and Teacher Resource Planning Project: Collected the historical data of business volume with SQL, performed time series analysis with R to predict the business volume of primary school students in summer session, and provided suggestion of the number of employed teachers for 12 branches

Project: annual auditing projects for of Huarong Real Estate Co., Ltd. and its 13 subsidiaries• Executed tests of effectiveness over revenue, accounts payable for Huarong Real Estate Co., Ltd.• Prepared due diligence report on the income statement and audited the depreciation of various asset classes• Collected and responded inquiry letters in a timely manner to improve management efficiency

• Summarized the key notes of 4 industry conferences and 5 site visits to nursery homes in China and conducted desk research on healthcare sector to seize the good environment influenced by government policies, • Independently delivered a 17-page competitive analysis report of 1 hospital in Qingdao as part of the due diligence project for the investment manager to implement and adjust the investment strategy

Worked on the analysis of stock, security and financial statement.Helped the clients select stocks and manage wealth, using the quantitative methodParticipated in the case competition on stock selection and hedge fund and our team did a great job