XIN REN

Dallas, TX 682-***-**** adhjsj@r.postjobfree.com

Professional Experience

Match.com, Data Analyst, Dallas, TX Sept 2019 – Current

Collaborated with product managers in the design and implementation of A/B tests. Used SQL Server, Hive and Excel Pivot table to build report templates summarizing the results.

Built automatic product analytics dashboard with over 50 critical KPIs using Power BI and Tableau and drove the adoption within the product team, which increased 40% of the efficiency in monitoring the app performance.

Worked with the CRM team to set up and analyze the Premium Subscribers/New Feature surveys using online survey tool Used python to perform sentiment analysis on the comments.

Developed Random Forrest models to detect key factors impacting the video date connection rate, which helped 10% more user pairs to connect.

Tik Tok, Operation Intern, Shanghai, China Jun 2017 - Aug 2017

Captured Daily Active Users, Retention Rate and the Number of New Users from a SQL database; produced data reports on Brazilian server to analyze inactive users and identify causes for low retention rates.

Re-engineered the traffic assignment algorithm to increase real traffic to the User Generated Content, which achieved 30% increase in retention rate in “Saving-Brazil” campaign.

Developed a co-branding campaign jointly with Universal Pictures and Sony Music to promote the movies and artists from Tik Tok on their platforms for resource exchange which increased the number of new users by 30,000. Technical Skills

Python • SQL • R • Tableau • Alteryx • Excel • Power BI • Hadoop • Google Analytics • Spark • Scikit-Learn • Hive • Visio Academic Projects

American Airlines (Practicum for SMU), Data Analyst, Dallas, TX Jan 2019 – Apr 2019

Converted complex business needs into code-friendly model requirements. Improved the efficiency of data cleansing and modeling for the revenue management team.

Used R to build K-means cluster models and identified Origin & Destination markets based on market structure information; Summarized competition patterns using Tableau and proposed pricing strategy according to market price sensitivity.

Analyzed American Airlines’ pricing strategy for domestic markets and built 2SLS regression models estimating flight level price elasticity for customers and predicted optimal pricing points. JC Penney, BI Analyst, Dallas, TX Jul 2018 - Oct 2018

Cleansed, blended and analyzed over 100 million records of data using Alteryx; built a Business Intelligence application on Tableau to evaluate the previous supply chain strategies, and measured the impact of the Trade War.

Created storylines to illustrate the advantages of JC Penney’s in-house brands, and suggested work-load strategy and sourcing countries, which were adopted by the analytics director. Extracurricular Activities

Rio 2016 Olympic Games, Volunteer of Language Service Team, Rio de Janeiro, Brazil Jul 2016 - Aug 2016

Selected as one of the translators for official BOCOG Volunteer Team to provide services to the Tennis, Badminton, and Weight lifting teams. Interpreted for world’s top Chinese athletes including Ma Long, Zhang Jike, Lin Dan, and Ding Ning.

Assisted media such as The New York Times, CCTV and Phoenix TV with one-on-one interviews to the athletes. International Humanity Foundation, Volunteer, Bali, Indonesia Aug 2015 - Aug 2015

Taught the junior and senior students English, Math, and basic computer skills.

Publicized IHF overseas activities by reaching approximately 300,000 impressions and raised over $2,000 funds. Education

Southern Methodist University, Dallas, TX Aug 2018 - May 2019 Master of Science in Business Analytics

GPA:3.94/4.00

Core Curriculum: Big Data Platform, Business Intelligence, Data Visualization, Database Design and Management The University of Nottingham Ningbo China, Ningbo, China Sept 2014 - Jun 2018 BSc (Hons) in International Business Economics

GPA:3.67/4.00

Recipient of Nottingham Dean’s Scholarship (TOP 10% in Business School) Fun Fact

Singer & song writer with 4 octaves vocal range, can sing whistle notes like Mariah Carey

Contact this candidate