Overview
Work History
Education
Skills
Websites
Timeline
Generic

Keyi Wang

Brooklyn,NY

Overview

3
3
years of professional experience

Work History

Data Analysis Intern

Bilibili
Shanghai, China
06.2024 - 08.2024
  • Extracted trending keywords for high-frequency user segments by writing and executing SQL queries
  • Utilized Python (Pandas, Numpy) for data analysis and reporting process automation, resulting in weekly market reports, improving team efficiency by 50%
  • Conducted data analysis on influencer shop user behavior using SPSS and Python, employing decision trees to analyze factors influencing user churn and proposed recommendations on product capability enhancements, leading to a 3% increase in influencer shop ROI
  • Analyzed digital product-related Bilibili content using Python and Excel to create visual reports on content type, purchase scenarios, and key selling points
  • Leveraged Power BI to develop interactive data-visualization dashboards about key metrics and trends, producing a platform consumption decision report, which helped secure partnerships with 10+ clients
  • Applied clustering analysis (hierarchical clustering, k-means, and model-based clustering) in R to profile users based on demographic data and clustering variables
  • Used regression trees and linear regression to predict user ratings based on term frequency and TF-IDF weights, ultimately contributing to a 15% increase in user satisfaction metrics

Business Analysis Intern

EKOS.AI
Boston, USA
11.2023 - 02.2024
  • Designed and implemented interactive dashboards utilizing Google Analytics and Tableau; performed multivariate analysis on key performance indicators such as visit duration, browsing paths, and click-through rates, which informed data-driven marketing and product strategies leading to a 10% increase in user engagement and a 5% uplift in conversion rates
  • Initiated and guided A/B testing campaigns to refine digital marketing tactics, utilizing statistical significance testing methods; optimizations led to a 7% cost reduction in customer acquisition and a 12% improvement in retention rates
  • Collaborated closely with product development teams to translate analytical insights into actionable product enhancements, contributing to a projected 8% growth in product adoption within target markets for the upcoming quarter
  • Evaluated multiple cloud platforms (e.g., AWS, Google Cloud, Microsoft Azure), focusing on scalability, cost efficiency, and ease of integration, assisting in the implementation of cloud-based data solutions that reduced overall data retrieval time by 15%

Strategy Analysis Intern

Frost & Sullivan
, Remote
10.2023 - 02.2024
  • Developed a Python-based web scraping tool to automate data extraction from over 70,000+ property listings, including names, locations, and pricing details, reducing manual data entry time by 80% and leading to a 50% increase in the team’s data processing efficiency
  • Collaborated on projects involving cutting-edge technologies such as robotics, artificial intelligence, and autonomous driving
  • Identified risks and opportunities for innovation in logistics, e-commerce, and automotive sectors, resulting in the development of three strategic recommendations that improved operational efficiency by 20% and reduced associated risks by 15%

Business Operation Intern

Unilever (China) Co., Ltd.
Shanghai, China
06.2021 - 09.2021
  • Elevated brand awareness for the incubator through establishing strategic partnerships with 5 entrepreneurial support organizations, investors, and digital solutions companies, and organizing 8 brand workshops, averaging 25 companies in attendance
  • Designed co-creation product strategies with a global cosmetics retailer and a coffee chain brand by market analysis, user research, and cross-departmental coordination; participated in implementation of product launch and marketing, generating 6K+ in sales
  • Delivered a potential 15% boost in profitability of a pet fragrance product through spearheading marketing strategies based on social media engagement, website traffic, customer feedback, etc
  • And sourcing with 20+ suppliers to reduce packaging costs by 8%

Education

Master of Science - Applied Analytics

Columbia University in The City of New York
New York, NY
12.2024

Bachelor of Science - Applied Economics

Macau University of Science And Technology
Macau, China
06.2023

Skills

  • Excel (Pivot Table, Vlookup)
  • SQL (CTE, ETL)
  • Python(Numpy, Pandas)
  • R
  • Power BI
  • Tableau

Timeline

Data Analysis Intern

Bilibili
06.2024 - 08.2024

Business Analysis Intern

EKOS.AI
11.2023 - 02.2024

Strategy Analysis Intern

Frost & Sullivan
10.2023 - 02.2024

Business Operation Intern

Unilever (China) Co., Ltd.
06.2021 - 09.2021

Master of Science - Applied Analytics

Columbia University in The City of New York

Bachelor of Science - Applied Economics

Macau University of Science And Technology

Similar Profiles

CREATE PROFILE
Keyi Wang