| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLE LinkedInEDUCATIONCarnegie Mellon University Pittsburgh, PA, USAM.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 EXPERIENCEEos Energy Enterprises Pittsburgh, PA, USAData Analyst Summer Intern 07/2023 08/2023Utilized 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.5MConducted 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 savingsImplemented automated data integration and standardized report templates with a Tableau dashboard and highlighted KPIs metrics to visualize weekly production efficiencyDesigned 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/2022Cleaned 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 encodingBuilt 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, ChinaBusiness Intelligence Intern 04/2021 10/2021Contributed 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 increaseDesigned 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 visualizationInitiated 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 trendsAssisted 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, ChinaStrategy Consulting Assistant 09/2020 10/2021Conducted 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 passConducted 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 entryAdvised 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, ChinaBusiness Analysis Intern for System Integration 07/2020 09/2020Defined 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 solutionsAnalyzed the data flow of payment among all system modules and defined the data type, preparing for database designEngineered 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 SKILLSRelevant courses: A/B test, Business Decision Making, Big Data and Large-Scale Computing, Database ManagementCS and statistics: Python (NumPy, pandas, scikit-learn, seaborn), SQL (MongoDB, MySQL), R, Stata, Tableau |
