Dingting Shen Email & Phone Number

Shanghai, China

Beijing, China

• Collected and wrangles 16 car stores quarter-end sales data via SQL, prepared and update data for further resolution by cleansing out irrelevant statements and handling missing records.• Built Tableau dashboards to display weekly operational metrics to track company performance and developed and implemented tests to measure effectiveness, which improved 20% operation productivity.• Visualized 30k+ car sales data in different categories using Python (pandas and Scikit-learn) to identify trends with model predictions and extracted insights for stakeholders to develop decisions, increasing profits by 13%.

Hangzhou, Zhejiang, China

• Extracted product KPI databases from e-commerce, processed and visualized data using VBA for weekly and monthly reports, improving efficiency in supporting strategies adjustment.• Collaborating with cross-functional teams to collect sales performance data from 45 stores across the city, used Excel (VLOOKUP, pivot table) for data analysis and helped upgrade services which exceeded goals 5%.• Promoted 10+ new products launching and evaluated performance of digital marketing campaigns with Excel and Access, analyzing quantitative impact for business operations planning.

Hangzhou, Zhejiang, China

• Researched and evaluated financial products to meet clients’ different demands, and collaborated with 3 sen-ior managers to developed investment plans for individuals, increasing survey feedback by 10% • Developed training materials and functional systems for operations processes to analyze financial statements, business reports to obtain data based on product, enhancing efficiency by 14%.

Master'S Degree, Applied Analytics

Bachelor Of Science - Bs, Statistics