• 节前防停投节后拉回监控：日监测行业*城市(共646个子市场)商户数、流量及广告效果，据春节期间三者走向，向销售提出针对性建议；观测五大区域百余销售小组的负责门店广告投放情况，计算达成率和重点品类留存率及其日环比数，于群内通晒，调动销售积极性并助其找到可提高方向，撰写SOP，独立设计近全自动excel模型。• 不可拉回案例分析：针对月目标分发可拉回作战名单，设定高ARPU及高利品类为高优先级商户，并每日监控拉回进度；月底分发问卷调查商户不可拉回的原因，帮助来年节后开学季运营动作，协助估测月底留存及达成率• 月度新签目标设定：基于有效CPC新签的定义以及过去6个月MEM新签的CPC客户转化率，评估次月的新签目标；同时下钻到分行业明细，根据历史业务经验敲定下月的低标和高标目标• 月度留存模型搭建：根据新定义，重新计算过去3月的月留存日记录以及月一转二日记录，基于过去数据趋势变化以及对于销售业务经验，制作可视化动态模型，预估次日及当月月底的留存情况

Financial analytical intern (continuous auditing platform and financial auditing project) • Continuous Auditing Platform: summarized historical auditing clues, risks and statistical models, designed prototype with Excel and Axure for an audit platform with surveys and interviews to collect internal needs. • Payment Product Auditing: Learned third-party payment related knowledge, brainstormed with teammates to spot risks and find the corresponding solutions for a new payment… Show more Financial analytical intern (continuous auditing platform and financial auditing project) • Continuous Auditing Platform: summarized historical auditing clues, risks and statistical models, designed prototype with Excel and Axure for an audit platform with surveys and interviews to collect internal needs. • Payment Product Auditing: Learned third-party payment related knowledge, brainstormed with teammates to spot risks and find the corresponding solutions for a new payment product. Show less

Finance and Budgeting Division, Full-Time Internship • Account Analysis: looked at the suspicious historical changes in main account with QlickView and Oracle and communicate with the related division and colleagues to find out the reasons behind these changes; • Workflow Optimization: improved VBA codes to simplify the process of trail balance and final financial statements, which improved work efficiency by 10% and got… Show more Finance and Budgeting Division, Full-Time Internship • Account Analysis: looked at the suspicious historical changes in main account with QlickView and Oracle and communicate with the related division and colleagues to find out the reasons behind these changes; • Workflow Optimization: improved VBA codes to simplify the process of trail balance and final financial statements, which improved work efficiency by 10% and got approved to be used next year;• External Audit Support: extracted trade details according to the sampling list within 5 hours to prove the compliance with internal control and accounting standards and wrote detailed notes to help auditors understand. Show less

• Main responsibility: actively involved in the revamping of a new strategic plan for a hosted NGO, aggregating data from the implementation of a program fund and external sources to ensure informed decision making. • Built an index to create top 40 countries with highest burden and lowest ability in terms of water & sanitation comprising 4,000 data points (computed missing data with simple R-MissMDA and trend analysis), whose result is reported to the steering committee, academics and… Show more • Main responsibility: actively involved in the revamping of a new strategic plan for a hosted NGO, aggregating data from the implementation of a program fund and external sources to ensure informed decision making. • Built an index to create top 40 countries with highest burden and lowest ability in terms of water & sanitation comprising 4,000 data points (computed missing data with simple R-MissMDA and trend analysis), whose result is reported to the steering committee, academics and potential donors for fundraising and future strategy • Tracked program implementation by national household survey for key performance indicators on program impact, equality & sustainability, and visualize them with Power BI and Power Pivot (with R-ggplot & plotly). Show less

Main responsibility: brainstormed for new hypotheses and ideas and provided support with data collection, tabulation and analysis in a team (working for over 400 hours). • Financial product Market Extensiono Proposed conversion to a diversified product offering including real-time health management, illness prevention and insurance policy based on a comprehensively-investigated benchmark case.o Filed 6 industry practices based on 5 useful cases home and abroad to acquire high net… Show more Main responsibility: brainstormed for new hypotheses and ideas and provided support with data collection, tabulation and analysis in a team (working for over 400 hours). • Financial product Market Extensiono Proposed conversion to a diversified product offering including real-time health management, illness prevention and insurance policy based on a comprehensively-investigated benchmark case.o Filed 6 industry practices based on 5 useful cases home and abroad to acquire high net worth customers for our client, complemented with suggestions on company organization and product portfolio. • Real Estate Planning o Provided competitive landscape of 5 businesses conceived to operate in the Auto City by grabbing their geographic details (~1000) with web crawler and visualizing with Tableau within 5 hours. Show less

Main responsibility: gathered and analyzed data to provide insights and recommendations for the client• Real Estate Development (Government Cooperation) o Researched and analyzed seven benchmark cases in one week, recognized four types of government cooperation mode by plausible hypothesis derived from market insights and expert interview. o Assisted modelling by outlining local tax policy in 1 day for 5 industries and 3 procedures (land acquisition, development & operation) and… Show more Main responsibility: gathered and analyzed data to provide insights and recommendations for the client• Real Estate Development (Government Cooperation) o Researched and analyzed seven benchmark cases in one week, recognized four types of government cooperation mode by plausible hypothesis derived from market insights and expert interview. o Assisted modelling by outlining local tax policy in 1 day for 5 industries and 3 procedures (land acquisition, development & operation) and made 50 cold calls to obtain selling rate and period of >10 estates in 3 hours. Show less