周碧莹 Email and Phone Number

• Built robotic excel based on VBA: establish risk-based filtering model; enabled robotic excel to identify low-risk policies, make automatic judgments and pre-fill data, which reduced manual operations and helped the team improve operation efficiency;• Conducted data analysis based on claims cases: conducted multi-dimensional comparison, e.g. claim type, claim amount, user behavior, etc.; drew PPT and provided suggestions; successfully helped departments optimize resource allocation

• Goal: helped NGO conduct outreaching to target segment• Conducted Customer research: interviewed relevant stakeholders and made desk research to gain insight• Conducted STP and TOWS analysis: segmented and targeted at 18-24-year-old low-education youth; developed online promotion strategy based on customer habit; maximized its advantage of partnership resource;• Implemented the project: tried to optimize the content on JobDB and Indeed, and smoothed user connections; successfully proposed a cooperation project with After school App, a HK start-up;

• Built Financial model: built profit forecasting model of vending and retailing enterprises based on business assumptions for the next 5 years in Excel; carried out sensitivity analysis of key assumptions;• Conducted business performance analysis: made comparisons with its historical performance and other benchmarking enterprises, analyzed reasons for the difference, and proposed suggestions for improvement• Provided investment suggestion: used the payback period method, NPV method and IRR method to make corresponding recommendations to investment decisions; conducted sensitivity analysis based on assumptions;