Yuxin(Cici) Zhao Email & Phone Number

Shanghai, China

• Designed and built visual displays with SQL & Tableau tools to maintain operations performance tracking, which supports operation leaders are advised of potential issues and areas of improvement, resulting in a 70%.
• Defined SQL logic to extract and integrate data from different sources, established and automated dynamic financial report empowering the FP&A team, which enables timely financial statements generation and facilitates.
• Applied machine learning techniques(decision tree) to predict customer attrition risk and long-term contract transformation; suggested prioritized engagement for maximum retention impact.

Shanghai, China

• Developed analytical dashboards with key business indices using SQL for grocery delivery service; provided analytical deep-dives for sales, customer patterns and supply chain, identified and diagnosed any anomalies.
• Developed statistical predictive models with Python to analyze customer conversion rate and profiled successful conversions.
• Handled ad-hoc data extracting and transformation requests from cross-function teams. Identified coding framework and established automated systems generating weekly reports to raise auditing efficiency by 20%.

Nanjing, Jiangsu, China

• Queried and processed social media data of target brands in Excel and Tableau. Analyzed target customers’ own attributes and demand based on users’ posts on social media; Analyzed the similarities and differences.

Master Of Science - Ms, Statistics

Visiting International Student Program, Data Science

Bachelor'S Degree, Statistics