Strategy Consultant

Runhan Shi

New York, NY, ***** 516-***-**** ************@*****.*** www.linkedin.com/in/runhanshi0131 EDUCATION

Columbia University Aug 2023 - Dec 2024

MS in Business Analytics, GPA: 3.6/4.0 New York, NY

● Courses: Applied Analytics: from Data to Decisions (SQL), Applied Financial Risk Management, Biotech/Pharma Commercialization and Development Strategies, Human Factors: Performance University of California San Diego Sep 2019 - Dec 2022 B.S. in Joint Mathematics-Economics, Minor in Accounting, GPA: 3.93/4.00 San Diego, CA PROFESSIONAL EXPERIENCE

Career Home Strategy Consulting Intern Remote Feb - Jun 2024

● Conducted quantitative analysis and trend forecasting for employment rates across 100+ schools, identifying key factors and providing evidence-based consulting recommendations.

● Developed the 4R consulting model (Reconcile, Radius, Rank, Resource) to evaluate employment performance for 50+ universities, enhancing institutional employment outcomes through data-driven analysis and strategic insights.

● Assisted in new ToC business initiatives by conducting market and competitor research for 30+ companies, applying market analysis, competitive intelligence, and strategic planning skills, which led to new product design.

● Designed and administered 3 surveys, utilizing survey design, data collection, and market research skills, collecting 100+ responses to gauge market demand for career development services. China Pacific Property Insurance Co., Ltd. Major Customer Department Intern Remote Jun - Jul 2024

● Participated in an enterprise bidding project with one of the major clients, leveraging project management, negotiation, and strategic planning skills.

● Provided analytical support on the appropriate rate to charge when bidding, utilizing data analysis, industry benchmarking, and pricing strategy skills by referring to previous related cases and cases within the same industry. CITIC Securities Company Limited Jul - Aug 2024

Business Center Intern Remote

● Participated in a major corporate bond resale business project, applying financial analysis, project management, and capital markets expertise.

● Served as an intermediary to communicate with bond issuers and investors, utilizing negotiation, stakeholder management, and communication skills to understand their demands on pricing and other aspects, facilitating the process. Account Manager Intern Jul - Aug 2022

● Communicated with 40 clients via phone, utilizing customer relationship management, financial advisory, and persuasive communication skills to provide personalized fund recommendations, achieving a 35% conversion rate. Lions Financial Business Analyst Intern New York, NY Aug - Sep 2021

● Prepared a 'one-pager' summarizing 15 target properties, employing research, data synthesis, and marketing communication skills to identify key criteria and highlight the unique services Lions Financial can provide, better assisting clients in a real estate industrial logistics project.

● Analyzed DIDI’s vehicle service IPO, acquisition impacts in China, and its growth potential, utilizing financial analysis, market research, and strategic forecasting skills. SELECTED PROJECTS AND RESEARCH

Resy with AI New York, NY Jan - May 2024

● Designed a product proposal to implement the instant menu translation function into Resy.

● Identified market demand and target groups, determined product features for the user interface/user experience, and assessed technology requirements while providing engineering considerations. Time Series Clustering at Ask2.ai New York, NY Jan - May 2024

● Enhanced the R2K-Means algorithm for clustering time series data, including developing a line segment intersection detection algorithm.

● Created subscores for silhouette score to assess random initialization, cluster mislabeling, and data changes, and formulated methods to determine the optimal number of clusters. Amazon Fine Food Review New York, NY Sep - Dec 2023

● Conducted sentiment analysis on over 560,000 customer reviews of Amazon Fine Food from October 1999 to October 2012 to predict positive/negative sentiment and understand customer characteristics and preferences.

● Performed data cleaning and utilized machine learning algorithms such as logistic regression and random forest to make predictions, achieving the best ROC of 0.96 when evaluating model performance on test data. SKILLS

Python, SQL, Power BI, Tableau, Visio, BigQuery, Looker Studio, Microsoft Excel (Pivot Table), MATLAB, STATA, Java, FactSet, Github, Asana, Miro, Lucidchart, Word, PowerPoint, iSlide

Contact this candidate