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% reduction in analysis time.• 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 historical records and target comparisons, saving 10+ hours per week of manual reporting work.• 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 inconsistencies and presented recommendations to improve or resolve.• 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 between users’ concerns and their generic competitors to adjust strategies.

Master Of Science - Ms, Statistics

Visiting International Student Program, Data Science

Bachelor'S Degree, Statistics