Mavis (Mengxi) L. Email and Phone Number

NLP Modeling; Product Analytics; Data Engineering; Text Analytics focusing on Customer Journeys; A/B Testing

· Fulfilled Requirements for Product Analytics, Predictive Modeling, Data Pipelines and DataVisualizations of a team of 10+ people.

· Collaborated with Sales team to Translate Business Requirements into Analytics Products;· Prepared and Organized QBR Reports and Dashboards/Slides by SQL & Google Dashboard.‐ Designed and Implemented an Internal Customer Insights Tool using SQL and Data Studio.‐ Built Staging Tables at 100‐million‐row level and Maintained Data Pipelines.

· SST Project: Collaborated with Data Products team to Develop and Implement ETL framework for automatic reporting system using Python (pandas, numpy), Teradata & Hive.· Built and Updated Revenue Dashboard using Tableau, Excel & SQL.· Gathered Data and Conducted KPI (eCPM, CPA) Analysis using R.

· Job Responsibilities: Pulling Data by PostgreSql on a daily basis; Assisting team members to do Email Marketing Campaigns; Reporting and Analyzing Platform / Channels Stats on a weekly basis; Providing data insights and Supports to Sales Team.

Projects / Contracts: · Mobile App Marketing Project: Investigated the Relationship of between Ranking and Downloads Data · Video Game KPI Project: Prepared DAU, ARPPU & Retention Rate using SQL. · Conducted statistical analyses such as Logistic Regression, Binary Classification and Power Analysis using SAS.

Research: Bullying and Aggression, Social Relationships among Middle-Childhood Students.Classroom Visits (Data Collection), Making Protocols, Data Entry &Analysis.