RAY SHI
79 West 93rd Street, 10D, New York, NY 10025
917-574-0597 | shi.lei@columbia.edu | linkedin.com/in/shi-lei
Columbia University, Columbia Business School, New York, NY
MS in Management Science and Engineering Expected Feb 2024 Courses: Product Management, Data Analytics, Marketing Analytics, Operation & Pricing Strategy.
GPA: 3.5/4.0.
Boston University, Boston, MA
BS in Electrical Engineering; BS in Mechanical Engineering Sep 2020 GPA: 3.9/4.0.
CONSULTING COHORTS
Louis Vuitton North America - Sales Seasonality Prediction, New York, NY
Technical Project Manager Sep 2022 - Expected May 2023
● Led a team of seven to create tools for the LV logistics team to achieve digitalization and sales forecasting.
● Performed exploratory data analysis on the past five-year sales data and created feature engineering reports.
● Conducted interviews with all the flagship store managers in NY state to verify the model results.
● Other duties include hosting weekly briefings with the client, data visualization, practicing agile, phase checking, etc.
HearMe - Teenage Segment Peer-Support App Product-Market Fit Research, New York, NY
Product Manager Sep 2022 - Apr 2023
● Led a team of four to conduct user research for this client’s product expansion to the teenage peer support market.
● Conducted over 30 user interviews and recommended seven feature improvements to be included in the app.
● Conducted a user recruiting campaign and a quantitative survey on Reddit to measure the WTP and market size.
● Other tasks include weekly briefings, building user persona, legal compliance research, and competitive analysis.
WORK EXPERIENCE
Hanyu Group Joint-Stock Co., Ltd, Jiangmen, CN
Managerial Trainee Sep 2021 - Aug 2022
● Completed a one-year rotational program across e-commerce, investment, and human resource departments.
● Led a team of four in successful live-streaming campaigns on Tiktok and Taobao, achieving 10x ROI on bath product.
● Conducted investment due diligence and contributed to two dissent reports that were adopted by top management.
● Led monthly reception and communication with industrial associations, investors, and stakeholders.
Timesbole Venture Capital Investment Co., Ltd, Shenzhen, CN
Market Research Analyst (Intern) Nov 2020 - Jun 2021
● Produced four market reports analyzing the new trends of consumer products in Chinese e-commerce and AR tech.
● Conducted field study and two large-scale user surveys to analyze consumer insights on Genki Forrest’s beverages.
● Composed three fast-moving consumer goods product reports on Genki Forest, Ramen Talks, and RELX.
● Led a team of three to conduct extensive interviews with at least two startups and founders per week.
BinaryGrow, Inc., Boston, MA
Sales Engineer (Intern) Nov 2019 - Jan 2020
● Planned, prepared, and operated product showcases of the company's VR software in exhibitions such as CES.
● Established connections with more than ten industrial clients and six national/regional accelerator programs.
LANGUAGE AND SKILLS
● Languages: Chinese Mandarin, Cantonese, German (elementary).
● Technical: Python, SQL, MATLAB, Tableau, Figma (learning).
● School organization: Columbia Product Managers Club member