Yiting Xiao Email & Phone Number

Greater Atlanta Area

Increase the click-through rate of Tripadvisor vacation rental newsletter by 32% (a net increase of 11,250 members who clicked through newsletter) by incorporating clicking data and fitting new model using Tableau for data analysis and R-studio for modeling;Improve the click-through rate of vrnl by sending out themed newsletter with topics like adventure, beach, rural and ski. Responsible for selecting target subscribers who have a related tag or have viewed related geos before and selecting target geos by analyzing keyword ratio of geos;Generate recommendation for 7.7 million subscribers of Flipkey and Holiday Lettings newsletter every week based on member inquiry, booking and home origin info using SQL server, hive, FileZilla and ExactTarget; prepare detailed documentation for internal use and stats for client;Work on automation of all newsletters to reduce manual effort.

Greater Atlanta Area

Design responsive website for food recommendation developed with AngularJS and Flask; Improve its user interface by incorporating features like bootstrap image gallery and leaflet map;Implemented Neo4j graph database and calculated user and item similarity on the graph database for recommendation;Build models for IHG that allows dynamic pricing of their Points and Cash option taking into account factors like consumer viability segment, price, points required, check-in day, stay length;Respond to TripAdvisor's request for data collection and data analysis in hive;Provide team with support on sas enterprise guide, slides and advanced excel spreadsheet.

Shanghai City, China

Supported strategic purchasing decisions through consolidating data for all SKU weekly in the SAP system using Excel's advanced features like lookup functions and pivot tables;Implemented a set of KPIs (i.e. stock turnover) and designed visualization correspondingly;Verified the accuracy of each vendor invoice beforehand and printed corresponding POs on receiving the invoices to ensure a timely payment;Processed and tracked inquiries, quotations, orders in SAP and performed accurate system entry.

Master'S Degree, Analytics (Computational Data Analytics Track), 3.91/4.0

Bachelor'S Degree, Logistics Management, 3.76/4.0

Activities and Societies: Class Co-president