XINGYU (MAGGIE) WEI

ac7uv2@r.postjobfree.com +1-585-***-**** linkedin.com/in/xingyu-wei/ EDUCATION

SIMON BUSINESS SCHOOL, University of Rochester - Rochester, NY Master of Science - Marketing Analytics (STEM Certified) Dec. 2018

• Activities: Simon Data Analytics Club, Simon Vision Consulting

• Coursework: Programming for Analysis(Python, R), Business Analytics (SQL, R, Tableau), Database Management(ETL, MySQL), Social Media(Text Mining, NLP)

SUN YAT-SEN UNIVERSITY - Guangzhou, China

Bachelor of Science - Human Geography and Urban Planning; GPA: 3.9/4 June 2017

• Leadership: President of Faculty Student Association (serving more than 500 students)

• Coursework: Computer Aided Design (ArcGIS, AutoCAD, Photoshop), Advanced Mathmatics

• Award: First-Class Merit Scholarship of SYSU (top 10% of whole faculty); National Student Innovation Award for research on E-commerce Development Dilemma in Chinese Villages. UNIVERSITY OF CALIFORNIA, BERKELEY – Berkeley, CA May 2016 Exchange Program - Statistics

• Coursework: The Time Series, Probability and Statistics to Business Statistics EXPERIENCE

J.D. Power and Associates – Great Los Angeles Area, CA July 2018 – Present Data Scientist Intern, AI and Machine Learning Team

• Cleaned and aggregated over 210,000 residual value data from Oracle database for more than 5,000 vehicles with SQL and Python; analyzed 48 feature variables and pinpointed key metrics that drive the residual value; generated summary report about data exploratory analysis and made the presentation to the chief data officier.

• Built models to forecast residual values for new vehicle models including Random Forest model for initial value and multi- time series forecasting model for value changing rate.

• Optimized traditional SAS code with new Python code for PIN Analytics to help improve project efficiency; collaborated with IT team to realize automation of data analysis process as well as visualization dashboards on new AI Cloud platform. DTZ Cushman&Wakefield – Guangzhou, China June 2016 – Sept. 2016 Marketing Consultant Intern, Retail Real Estate Department

• Extracted business insights from marketing trend analysis by social media listening (Web Scratching) and marketing background research, providing strategical consulting services for four commercial complexes projects, successfully improving profitability and customer traffic.

• Visualized key metrics (traffic, Revenue etc.) via Tableau dashboards and generated reports for weekly meeting with clients.

• Led intern team in conducting field investigations for ongoing projects to ensure collection of first-hand quality data; developed guidebook to summarize work processes and ease transition to new role, improving efficiency for new interns. MARKETING ANALYTICS PROJECTS

SIMON PROJECT: New Product Development Project for Wegmans – Rochester, NY Jan. 2018 – Mar. 2018

• In order to launch a new product under greek yogurt catalog, aggregated over 80,000 data from Wegmans Loyalty Panel.

• Depicted the target segment and evaluated key factors for purchase decision by analyzing consumer survey and transaction records, providing recommendations for product concept design.

• Forecast sales volume and market share in a new group (1.2 million households) by using Machine Learning (decision tree) to segment potential customers and calculating demand with Neural Network Regression Model via R. SIMON PROJECT: Consumer Insights Research Project for Xerox – Rochester, NY Jan. 2018 – May. 2018

• Cleaned and aggregated customer survey data from CRM system for over 10,000 individual respondents using SQL

• Pinpointed key metrics that drive Client Recommendation Ratings by conducting Segmentation and then building Multi Variate Regression Models using R, creating data dashboards via Tableau, R and Powerpoint .

• Generated reports and presented to Xerox company representatives, got appreciations about suggestions on improving service quality of human touch part.

SKILLS & INTERESTS SUMMARY

• Tech Skills: Python, R, SAS, SQL, Tableau, PowerBI, Domo, Advanced Excel, Google Analytics, AWS, ArcGIS

• Volunteer work: Led 10 international volunteers in launching a charity art exhibition for autistic children.

• Interests: Gym, Skateboarding, Violin (classical).