Mengxiao (Michelle) He

+1-240-***-**** adjknj@r.postjobfree.com Flushing, NY

EDUCATION

University of Maryland, College Park College Park, MD Master in Business Analytics December 2020

Course: Data Visualization; Operation Analytics; Database Management; Data Mining; Big Data and AI; Data Processing and Analysis in Python ; Pricing Optimization; Operation Analytics President of Professional Communication Club; Shanghai University of Political Science and Law Shanghai, China Bachelor of International Economy and Trade June 2018 Activities: 1st University Cricket League; VP of Union Arts Department Awarded academic scholarships TECHNICAL SKILLS

Tableau(Certification), SQL, R, Python, Machine-learning, MS Office, Advanced Excel Languages: English, Mandarin ANALYTICS PROJECTS

E- commerce Market Basket Analysis (SQL, Python, Tableau) College Park, MD

● Used Exploratory Data Analysis of 30000+ Instacart data to summarize online shopping market and customer behavior

● Applied ML algorithms to make predictions and provided corresponding bundling strategy, customer segmenting and optimize delivery options to help retain online customers Customer Performance Analysis: Propensity to Pay Collection Model (R,Machine-Learning,Tableau) College Park, MD

● Performed data analysis on Genpact’s B2B transaction data; create a XG boost model to predict the propensity to pay of customers historical data, achieved 92% accuracy based on 45,000 invoices and 14 final features;

● Provided managerial implications such as dynamic customer segmentation for collections operations and real-time strategy on the collection of debt to enhance Genpact’s financial health based on model feature importance Supply Chain Analysis: Identify Cost Savings for Pilot Freight (Snowflake, SQL, @Risk Simulation) College Park, MD

● Leading client stakeholder communications to clarify objectives and understanding of available raw data

● Collaborating on team of five to analyze logistics and operations data using SQL on Snowflake, collect data on fluctuations in volume, market rates, and potential network disruption

● Presented business suggestions with potential cost savings by performing and analyzing @Risk Simulation model in Excel Airbnb Quantitative analysis (R, Machine-Learning, Tableau) College Park, MD

● Conducted a statistical analysis on the popularity of the listings of Airbnb providers; Used machine-learning algorithm to make predictions based on 100,000+ observations with 70 features, achieved the 84% accuracy of the true popularity

● Provided feasible recommendations regarding listing and pricing strategy based on the model performance PROFESSIONAL EXPERIENCE

Sponsor United Washington DC, United States

Research Analyst Intern June 2020 – September 2020

● Collected and analyzed sports sponsorship data from NBA, NFL, MLS, and eSports teams through social media, websites, podcasts, broadcasts, and venues.Using SQL to combine data and Tableau to produce a summary dashboard.

● Researched brands and companies that sponsor sports properties; compiled findings into reports; cross-functional collaboration to manage data in a private online database platform for clients to use and generate insights. Allied Millennial Partners, LLC. New York, United States Data Analyst Intern December 2019 – February 2020

● Used statistical tools R studio to analyze data over 15 years to test Efficient Market Hypothesis on the target stocks and target investing companies, generated quantitative analysis report

● Discussed the empirical findings by different statistical tests and creating models in R to examine the properties of autocorrelation, serial dependency; find an incoming trend for possible stocks and investment suggestions Ipsos Marketing Consulting Co, Ltd Shanghai, China Research Associate June 2018 – June 2019

● Executed client research through working with teams and interdepartmental collaborations; created market insight reports and generated client strategy pivot; engaged directly with clients and participated in C-level client presentation

● Analyzed data using SQL, directed competitive landscape analysis, and constructed customer segmentation for companies, including Mary Kay, Kinder Chocolate, and Adidas; analysis outcome led to client strategy implementation PricewaterhouseCoopers Shanghai, China

Finance Intern September 2017 – February 2018

● Took initiative to lead cross-bank high-importance one billion RMB transaction under high time pressure; juggled numerous non-overlapping responsibilities and prioritized based on need

● Conducted and verified 13 branch offices’ bank accounts; worked directly with Directors and Managers to monitor reimbursement process and ensure the legitimacy of each transaction.

Contact this candidate