Social Media Data

Mengtian (Monica) Hu

Los Angeles, CA • 612-***-**** • ********@********.***.*** • linkedin.com/in/mengtian-hu • github.com/mengtiah EDUCATION

University of Southern California, Marshall School of Business – Los Angeles, CA May 2020 Master of Science in Business Analytics (STEM), Dept. of Data Sciences and Operations; GPA: 3.81 Honors: Dean’s List University of Minnesota – Twin Cities, School of Liberal Arts – Minneapolis, MN May 2017 Bachelor of Arts with Distinction, Economics, Minor: Interdisciplinary Design; GPA: 3.886 Honors: Dean’s List Sichuan University (TOP 10 in China), School of Economics – Chengdu, Sichuan Jun 2017 Bachelor of Economics, National Economic Management; GPA: 3.7 Honors: Outstanding Student, First Prize SKILLS & INTERESTS

Tools & Language: Python, R, SQL, NoSQL, Tableau, GCP, Gurobi, Git, SSAS, AtScale, Google Analytics, Microsoft Office, Azure Specialization: Data Visualization, Machine Learning (Supervised: Linear and Logistic Regression, Decision Tree, Random Forest, Gradient Boosting, SVM; Unsupervised: K-means Clustering, PCA; Neural Networks, Deep Learning; NLP), Regularization, Classification, Segmentation, Product Analytics, Marketing Analytics, Casual Inference, Experimental Design (A/B Testing), Statistics, Optimization, Time Series Forecasting Soft Skills: Communication, Problem Framing, Data-Driven Insights, Strategizing, Decision Making PROFESSIONAL EXPERIENCE

Rising Realty Partners – Los Angeles, CA Feb – May, 2019 / Sep – Nov, 2019 Data Science Intern

• Set up a SQL database; built comprehensive Tableau stories to track the performance of assets management, acquisition matrix, financial and employee data, maintained database and created real-time update dashboards and manage user permissions

• Improved working efficiency at the management level 50%; assisted company leaders to monitor KPIs and supported business decision making by developing completely automated interactive dashboards using Tableau Wayfair LLC – Boston, MA Jun 2019 – Aug 2019

Data Solutions Engineer Intern

• Increased query efficiency 75%; built dimensions, calculated measures and fact tables in Cube database, wrote Python export script, migrated marketing and product SSAS Cube to AtScale by Git and GCP

• Developed and measured KPIs including time series, query performance; benchmarked AtScale against legacy SSAS

• Raised working efficiency 50% for all BI teams; detected procedure slowness factors using EDA and machine learning, set up triggered email service to notify teams of abnormal procedures using Python & Html, developed a dynamic dashboard for procedure run time, Cube update status, average query performance and general health KPIs using Tableau Deloitte Consulting – Beijing, China Jun 2018 – Aug 2018 Business Intelligence Summer Analyst

• Data Organization: Streamlined 90 tables, 5K+ fields of past five years’ sales data in Daimler’s Data Warehouse using Oracle SQL Developer and spreadsheet, wrote Data Quality Report to explore data info and summary statistics

• Data Delivery and Visualization: Enhanced decision-making speed for aftersales departments by 50%; organized daily, monthly and on-demand reports, plotted data using Python & Tableau

• Project Management: Improved managing efficiency and productivity 50%; operated five projects, framed business users’ problems, constructed 60 KPIs, converted business requirements to tech logic, wrote BRD and technical specification Erisonic Innovation Technology, LLC – Kansas City, MO Jan 2018 – May 2018 Growth Analyst (worked on three unique products)

• Boosted searching efficiency 70% and click-through rate 50%; built websites using JavaScript, tracked ad data with Google Analytics and Facebook Pixel, crawled data on search engine and social media, conducted search engine optimization

• Optimized product by collecting data from user experience and Google Analytics; designed MySQL database to increase the efficiency of project management (eliminating 30% data redundancy and 25% searching time)

• Calculated Net Promoter Score (NPS), charted time series of user satisfaction, assessed NPS by SQL and R; visualized data

(eg. sales volume, advertising costs and revenue) in Tableau to facilitate business strategy PROJECT & COMPETITION EXPERIENCE

Electrical Load Forecasting Project & Competition (Southern California Edison) Aug 2019 – Dec 2019

• Developed a system with the lowest testing MAPE (2%) among all submissions to forecast short and long-term SCE electrical load by executing classic time-series models, machine learning and neural network methods Visit Type, 1st Yr Members’ Renewal Analysis (Sam’s Club, Project Lead) Aug 2018 – Dec 2018

• Data Processing & Modeling: Cleaned 40M+ raw data, and 1) Created logistic regression to identify 8 renewal promoting factors, executed train/test split and cross-validation, verified the model by evaluating AUC. 2) Constructed a decision tree to segment customer into 7 groups based on impurity. 3) Designed statistical methods (hypothesis test) to find significant characteristics within each customer groups

• Business Intelligence: Plotted analysis results, extracted useful perspectives, created valuable customer portfolios, presented insights and business recommendations to corporate data science lead

Contact this candidate