Xinran Xu

Experience

• 

  联合利华

  May 2020 - Jul 2020

  Big Data Intern

  Product AnalysisData Mining

• 

  SHEIN

  Oct 2020 - Apr 2021

  Data Analyst

  •Market Analysis: Monitored daily sales data and completed activity analysis reports for Canada market via SQL and Excel; conducted daily detection on abnormalities of key indicators (GMV, Conversion rate, ROI etc.), overall generated 40+ analysis report and gave reasonable suggestions for market planning in the next stage;Predictive Analysis: •Used Facebook Prophet model in R to estimate daily sales within 20+ market for the two brands (SHEIN, ROMWE) in SHEIN, sorted out weekly and annual trends of different markets with the tolerance of less than 10%, which relieved the pressure of logistics and stocking;•Estimated various probabilities for lucky draw simulation to control the upper limit of redemption/acquisition of points, saved 30% costs for company in total Show less

• 

  GEEKO Information Technology Co., LTD.

  Apr 2021 - Oct 2022

  Data Analyst

  •Market Operation: Established SensorData/Tableau BI dashboards and kept daily monitoring of key metrics, including user-path, conversion rate, GMV, etc., conducted business analysis reports and supported the optimization of operation department;•Data Analysis: Extracted and processed data using SQL, Excel, monitored and evaluated user behavior and operation activity indicators, processed 100,000 pieces of records of data everyday;•Event Tracking Management: Implemented event tracking system and designed data collection schemes within custom dimensions, events, etc., responsible for event tracking document updates, beta-test, version management and application of data collection;•Membership System: Redesigned membership system to improve user experience and conversion rate, including points system, return policies and coupon services; increased cumulative members from 80,000+ to 750,000+, and repurchase rate of members from 1.2% to 3.3%;•User Operation: Developed user operating index system to project the needs of marketing sector, conducted business analysis (sales funnel, user persona, group segmentation etc.) and increased the number of registered users by 12%;•User Growth: Constructed shopping procedure via data analysis, including display of shopping cart, product recommendation, retention popup window etc., increased overall retention rate by 30%, increased time on page by 66% and enhanced conversion rate by 53%•Portfolio Planning: Formulated campaign planning for the UK market and set up the specific activity targets and indicator system;•Market Analysis: Established SensorData and Tableau dashboards based on operation, user flow quality, conversion rate, etc., and delivered daily/weekly market analysis reports to marketing sector Show less

• 

  YELOPACK Technology Co., LTD.

  Nov 2022 - Feb 2023

  Data Operation

  •Fixed Asset Periodic Review: Responsible for the periodic inventory of shared pallets, including asset data management, customer inventory management, and waste pallets disposal, ensuring that the fixed assets are consistent with the actual accounts, reducing the overall pallet purchase volume by 47%, increasing the pallet turnover rate by 16%, and reducing the vacancy rate by 5%;•Data System Operation: Fixed trigger points in the current system(statistical deviation of customer shipping records, delayed broadcast of recycling data, inconsistent statistical standards,etc.) and optimized the online asset management process; Use SQL and Excel to construct full-link business indicators for shipping, allocation, procurement and recycling; Set real-time refresh of key metrics through Alibaba BI dashboard;•Supply&Demand Analysis: Coordinated shipping plans of 40 major customers across the country, optimized logistics routes by calculating logistics costs and delivery timeliness, reducing the proportion of long-distance allocation by 46% under the premise of ensuring customers' production and supply. Show less