Data Analyst

• Feb 2023 - Present

Research Assistant

• Oct 2022 - Present

Assisted Professor Luis Cabral, Chair, Department of Economics, Stern School of Business to do the project about Big Tech Acquisition( Apple,Google, Beta,Microsoft, Amazon) • Read academic literature on ‘startup acquisition’ ‘killer acquisition’ ‘how acquisition influence the startup innovation’. • Applied python-beautiful soup to crawl acquisition data from assorted data sources for the top 5 tech companies across 20+ years; calculated acquisition percentage and analyzed their trend. • Assisted Professor to build the optimization model about acquisition using python fsolve, applied senaitivity analysis to intepret model results, helped make merger strategy according to company’s welfare. Show less

Marketing Analyst(Capstone)

• Jan 2022 - May 2022

• Extracted and analyzed sales and customer feedback data of Mend’s products from its website across 5 years (1K+ records), utilized SQL and Excel for data analysis, outputted sales data reports. • Designed and administered a survey questionnaire, randomly distributing it to the consumers, using the important marketing metrics including ROI, Impressions, conversion rate by channel to analyze the outcome of the questionnaire; visualized the output and presented to key stakeholders [Tableau, PowerPoint]. • Conducted market research, competing products, market share and sales revenue of Mend’s products. • Using segment analysis, SWOT, PEST analysis and Porter’s Five Forces Model to complete output the weekly market research reports and received positive feedback. Show less

Teaching Assistant

• Sep 2021 - Dec 2021

Customer Service Department

• Jun 2021 - Aug 2021

Led a team of interns in charge of weekly team reports to executives for the launch of new products. • Implemented daily-membership tracking [Python] and calculated conversation rate of members [SQL]. Analyzed collected data [~2M records]; created data visualization reports [Tableau]. • Designed and conducted client surveys to gather feedback on products and services, and increased conversion rate by 15%. Led a team of interns in charge of weekly team reports to executives for the launch of new products. • Implemented daily-membership tracking [Python] and calculated conversation rate of members [SQL]. Analyzed collected data [~2M records]; created data visualization reports [Tableau]. • Designed and conducted client surveys to gather feedback on products and services, and increased conversion rate by 15%.

Data Trend Center

• Mar 2021 - May 2021

• Exported and analyzed over 10k platform data investigate the impact of labels, products, and brand popularity on sales. - [Excel VLOOKUP and Pivot-Table] • Applied NLP sentiment analysis to customer feedback, to make the list of recommendation products of the day。 • Collaborated with software engineers to build a recommendation model, our company's sales surpassed those of JD during the 6.18 online shopping festival by 8%. • Exported and analyzed over 10k platform data investigate the impact of labels, products, and brand popularity on sales. - [Excel VLOOKUP and Pivot-Table] • Applied NLP sentiment analysis to customer feedback, to make the list of recommendation products of the day。 • Collaborated with software engineers to build a recommendation model, our company's sales surpassed those of JD during the 6.18 online shopping festival by 8%.

Asset Securitization

• Jul 2019 - Aug 2019