Data Analyst - Shanghai Chengmu Cosmetics Trading Co., Ltd.
SegmentationAs a Data Analyst, the candidate collected e-commerce sales data and delivered sales and performance analysis using BI tools. They monitored daily business metrics such as traffic, user purchase behavior, and conversion rate, and translated raw data into actionable insights. They also built analyses including funnel, RFM value modeling, retention, and user segmentation to support refined operations. • Collected and processed e-commerce sales and behavioral datasets, using SQL/query for cleaning and transformation • Used BI tools to calculate conversion and retention metrics and conduct comparisons across segments • Prepared daily reports, weekly summaries, and data analysis reports for stakeholders • Collaborated with e-commerce operations teams and supported operational decision-making with data-driven recommendations.