Sign in

Social Media Data

Boston, Massachusetts, United States
April 23, 2019

Contact this candidate


Xiaoyi 'Charlotte' Sun


Highly analytical and result-oriented analyst with knowledge of database types, research methodologies, and data capture, manipulation, and analysis

Bring insights and business intelligence based on customer behavior, with a passion for learning new technologies that create more efficient processes and corporate growth


SAS, SPSS, KNIME, Tableau, SQL, Python, VM, Hadoop, Access, Teradata Studio, HTML, Gephi, NodeXL, Google Analytics


Eduhup, Boston, MA January 2019-Present

Analytics/Quality Assurance Specialist

Monitored HubSpot, Google Analytics and Baidu Analytics to generate web analytics report

Developed overall quality maturity roadmap, site map, and analytics results for each Web Development functional area

Audited design to be development-ready, conduct audits and analyzes findings to develop appropriate corrective action recommendations

Updated internal/external websites data

Clark University, Worcester, MA August 2017-February 2018

Business Analytics Graduate School Assistant

Assisted students with the installation of Hadoop, R-Hadoop, Ubuntu, NodeXL, etc.

Provided analytical, research, and technical support, including processing data in Excel, SAS, and SPSS, to explore, manipulate, and analyze large data sets

Used Python and KNIME to build regression and recommendation models, as well as Tableau to generate visualizations during the academic project work

UBER Xi’an Office, Xi’an, CHINA December 2016-March 2017

Automotive Finance Program and Operating Intern

Performed research on customer behavior by studying customer data; analyzed the source of user, activity, retention, turnover rate, behavioral path, conversion rate, and other operational data

Assisted in identifying the firm’s key drivers of attrition and recommendations to enhance customer retention

Prepared research reports monthly and provided data support and reference for company marketing strategy and brand planning in Xi’an. Collaborated with IT teams to conduct data analysis and testing

Shaanxi Broadcast & TV Network Intermediary (Group) Co., Ltd., Xi’an, CHINA June 2016-October 2016

New Media Analyst Intern

Assisted in advertisement analysis, interviewed over 30 targets, and edited core text and videos for the show

Assisted in weekly reports that deliver focused, in-depth analysis of specific events and highlight the organization’s key metrics and pinpoints developing trends across the organization

Managed social media Weibo of the show City Express; successfully gathered 2,000 - 5,000 hits on each Weibo piece


Predictive Modeling in Health Insurance Rate Using SAS® by the case of Florida in 2017

Visualized the descriptive analysis of health insurance rates

Built the model for predicting the health insurance rate in Florida based on each plan’s attributes

The model could be used as a valuation factor for customers when selecting their health insurance plans and for insurance companies when establishing individual rates for the next year

YouTube Video Recommendation System Using Python

Extracted comments related to YouTube videos and compile them using KNIME via YouTube API

Based on the relevance of the search words and the topics extracted from YouTube video comments

The top three most relevant videos would be recommended for the users and corresponding links to the videos would be provided

Investment Strategies for Reducing Aggregate Carbon Emissions of New England’s Energy Sector

Built a stress model for economic uncertainty with three different scenarios

Ran Monte Carlo simulation to identify NPV risks and sensitivities

Executed cost-benefit analysis in consideration of non-monetized benefits valued by stakeholders, in addition to NPV

Online Bookstore with cryptocurrency Feature: cryptocurrency Feature

Applied input mask decisions, validation rules, and normalization rules

Ensured the integrity by Entity Integrity Rule, Referential Integrity Rule, and Business Logic Integrity


Clark University Graduate School of Management, Worcester, MA

MS in Business Analytics, May 2018

Xi’an International Studies University, Xi’an, CHINA

BA in English Literature and Linguistics, June 2016

Contact this candidate