Data Analyst Summer Intern

Hailey Hanyue

************@*****.*** +1-412-***-**** LinkedIn

EDUCATION

Carnegie Mellon University Pittsburgh, PA, USA

M.S in Data Analytics GPA: 3.65 09/2022 – 05/2024 Tsinghua University, School of Economics and Management Beijing, China B.S. in Economics and Finance GPA: 3.63 09/2018 – 07/2022 WORK EXPERIENCE

Eos Energy Enterprises Pittsburgh, PA, USA

Data Analyst Summer Intern 07/2023 – 08/2023

Utilized SQL to develop databases and manage the past 2M production data, and created a predictive model with Python based on the dataset that discovered leakage correlation factors in lithium batteries with 94% precision and 81% recall, greatly improving quality control and leading to a projected future order increase of $1.5M

Conducted Difference in Difference (DID) statistical model analysis to validate the production quality improvement from integrating the capability index (Cpk) monitoring and auto-intervention into the production process, driving the company-wide adoption of the methods, leading to a projected 16% quality improvement and $1M annual savings

Implemented automated data integration and standardized report templates with a Tableau dashboard and highlighted KPIs metrics to visualize weekly production efficiency

Designed the sprint workflow through interviews and peer research and built it on Jira to regulate the production performance data collection, analysis, and review process, increasing the transparency during task track JKuli Trading Hong Kong S.A.R.

Business Development Intern, Marketing Strategy 07/2022 – 08/2022

Cleaned and pre-processed data with Python on 500k customer purchase histories to ensure data integrity, imputed missing values, and performed feature engineering via one-hot encoding, interaction variables, and time encoding

Built propensity models on a 1GB promotion season sales dataset to reveal hidden markets for 1k+ online retailers by identifying the types of customers that are most likely to purchase their products, and labeled the relevant customers with clustered profiles, improving marketing effectiveness by 19%

Presented model insights and corresponding market recommendations to stakeholders, offering clarifications of background setting and usage scenarios, and addressed concerns regarding the practical applicability ByteDance (TikTok) Beijing, China

Business Intelligence Intern 04/2021 – 10/2021

Contributed to A/B testing to verify the effect of promotion for agriculture products on TikTok by Difference in Difference (DID) Statistic model, checking the causal effect and driving the strategy which led to 19% sales increase

Designed the Tableau dashboard to monitor the KPIs during the industry promotion, covering relevant DAU, retailer live selling time, shop traffic, and shop revenue, etc., providing the promotion effect and ROI trend visualization

Initiated competitive analysis on two peers about the promotion strategy for the same market and the performance, providing insights for marketing strategy adjustment and customer retailer preference update trends

Assisted with updating K-means clustering models to target high-potential revenue retailers for TikTok advertising service promotion and traffic allocation strategy, identifying 20k retailers with medium sales revenue, high product ratings, and low natural traffic from a 4.5 M retailer pool, ultimately increasing ad conversion rate by 11% Boston Consulting Group Beijing, China

Strategy Consulting Assistant 09/2020 – 10/2021

Conducted industry research on the live streaming e-commerce industry and identified the risks of top anchor market dominance and MCNs’ overreliance on influencers, both of which have indeed come to pass

Conducted market research on the pet food market by web scraping Amazon, interviewing experts, and comparing prices and consumer preferences to inform advice on price and food type strategies ahead of market entry

Advised client to focus on entering and repurchasing rates after building a cost-profit model with the Ansoff matrix to analyze promotional campaigns and leading a team of 4 PTAs through in-store competitive analyses Accenture Shanghai, China

Business Analysis Intern for System Integration 07/2020 – 09/2020

Defined requirement scopes for the online mall product through client interviews, and worked as the liaison between technical and business teams to translate business needs into technical solutions

Analyzed the data flow of payment among all system modules and defined the data type, preparing for database design

Engineered an efficient and high-performance user and product relational database storage structure for the online mall that optimized the data query speed during the user payment process, achieving low computation and space cost SKILLS

Relevant courses: A/B test, Business Decision Making, Big Data and Large-Scale Computing, Database Management

CS and statistics: Python (NumPy, pandas, scikit-learn, seaborn), SQL (MongoDB, MySQL), R, Stata, Tableau

Contact this candidate