Experience

Stackline

• United States
• Retail
• 200 - 300 Employee

• Data Analyst

  • Oct 2022 - Present



便利蜂

• China
• Technology, Information and Internet
• 1 - 100 Employee

• Data Analyst Intern

  • Jun 2021 - Aug 2021

  • Extracted millions of required index records like “quantity sold in recent week” with SQL to help Fresh Food Department analyze the sales performance of stores or productions every week. • Designed the A/B test and analyzed the performance of differing inventory strategies between the control and experiment group of franchise stores then recommended the new strategies to the leadership. • Analyzed abnormal profit rates by breaking down categories, data visualization and examining… Show more • Extracted millions of required index records like “quantity sold in recent week” with SQL to help Fresh Food Department analyze the sales performance of stores or productions every week. • Designed the A/B test and analyzed the performance of differing inventory strategies between the control and experiment group of franchise stores then recommended the new strategies to the leadership. • Analyzed abnormal profit rates by breaking down categories, data visualization and examining assumptions using Python and Excel to find the reason and potential problems behind the data. Made recommendation on the issue. Developed an in-depth mind map for abnormal index data analysis to be integrated into future work. • Automated data generation process using Python to clean, aggregate, cluster data, and parse competition’s inventory of products to facilitate the market research process and increase the team efficiency. • Built a data dashboard to monitor the index like quantity sold, selling price at different type of stores and different products. Show less • Extracted millions of required index records like “quantity sold in recent week” with SQL to help Fresh Food Department analyze the sales performance of stores or productions every week. • Designed the A/B test and analyzed the performance of differing inventory strategies between the control and experiment group of franchise stores then recommended the new strategies to the leadership. • Analyzed abnormal profit rates by breaking down categories, data visualization and examining… Show more • Extracted millions of required index records like “quantity sold in recent week” with SQL to help Fresh Food Department analyze the sales performance of stores or productions every week. • Designed the A/B test and analyzed the performance of differing inventory strategies between the control and experiment group of franchise stores then recommended the new strategies to the leadership. • Analyzed abnormal profit rates by breaking down categories, data visualization and examining assumptions using Python and Excel to find the reason and potential problems behind the data. Made recommendation on the issue. Developed an in-depth mind map for abnormal index data analysis to be integrated into future work. • Automated data generation process using Python to clean, aggregate, cluster data, and parse competition’s inventory of products to facilitate the market research process and increase the team efficiency. • Built a data dashboard to monitor the index like quantity sold, selling price at different type of stores and different products. Show less