Xiwen Chen
Data Scientist at Meritco Services- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
APIS AND WEB SCRAPING
Dataquest.io -
PYTHON FOR DATA SCIENCE: INTERMEDIATE
Dataquest.io -
SPARK AND MAP-REDUCE
Dataquest.io -
SQL AND DATABASES: ADVANCED
Dataquest.io
Experience
-
Meritco Services
-
China
-
Business Consulting and Services
-
100 - 200 Employee
-
Data Scientist
-
Oct 2020 - Present
1.Assisted in social media product iteration: * Combine onsite-spending, social spending and social medial data of kols across different social media platform to build predictive models to predict the search num each kol can acquire. * Built index to estimate the Weibo exposure for all the kols and designed index to estimate the duplicate ratio across cross platform and inner platform to calculate the exposure for new products. * Use statistical methods to normalize names for skincare and cosmetics products on social medial, the precision and recall are both above 90%. 2.Analyzed data for strategy delivery: * Analyzed order and member data to find insights about user base and user behavior to deliver strategies about coupons for MDN to attract new users. * Use nlp methods to analyze data from social media to find signature product for the competitive companies to help clients deliver strategies for more social media exposure. Show less
-
-
-
SV Summit Inc.
-
San Jose, California, United States
-
Product Specialist
-
Jun 2020 - Sep 2020
• Conducted competition analysis and market analysis to design new courses and make promotion strategies • Designed questionnaires and analyzed data to know students’ preferences to improve our course quality and attract new users • Collaborated with marketing team and sales team to make sure deadlines and students’ expectation are met • Communicated with teachers to ensure course quality and help operate the courses • Manage separate projects with competing deadlines • Conducted competition analysis and market analysis to design new courses and make promotion strategies • Designed questionnaires and analyzed data to know students’ preferences to improve our course quality and attract new users • Collaborated with marketing team and sales team to make sure deadlines and students’ expectation are met • Communicated with teachers to ensure course quality and help operate the courses • Manage separate projects with competing deadlines
-
-
-
72 DRAGONS, LLC
-
Hong Kong
-
Media Production
-
1 - 100 Employee
-
Data Analyst Intern
-
Apr 2020 - Sep 2020
• Used Python to scrape, clean film data from different resources to collect film rate sheet data and film school data • Drew ERDs and collaborated with engineers to create film databases • Created visually impactful dashboards in Excel and Tableau for data reporting to help our clients make strategies. Attended weekly meeting to gather the requirements and present updates to team lead • Used Python to scrape, clean film data from different resources to collect film rate sheet data and film school data • Drew ERDs and collaborated with engineers to create film databases • Created visually impactful dashboards in Excel and Tableau for data reporting to help our clients make strategies. Attended weekly meeting to gather the requirements and present updates to team lead
-
-
-
Columbia University
-
United States
-
Higher Education
-
700 & Above Employee
-
Grader
-
Sep 2019 - Dec 2019
correct students’ homework and answer their questions correct students’ homework and answer their questions
-
-
-
Hello Bike
-
Remote
-
Business Analyst Intern
-
Jul 2019 - Sep 2019
• Conduct market analysis, user analysis and competition analysis to formulate the plan of Hello bike app • Design interview samples, interview users and write an interview summary; design a questionnaire and collect 200+ valid questionnaires, analyze the data and visualize the users’ requirements of tool type mobile apps • Conduct market analysis, user analysis and competition analysis to formulate the plan of Hello bike app • Design interview samples, interview users and write an interview summary; design a questionnaire and collect 200+ valid questionnaires, analyze the data and visualize the users’ requirements of tool type mobile apps
-
-
-
Nielsen
-
United States
-
Technology, Information and Media
-
700 & Above Employee
-
Data Analyst Intern
-
Feb 2018 - Apr 2018
• Executed scripts written in supported languages including Python, SPASS and R to deal with outliers to help data scientists build predictive models and increased model accuracy by 10% • Wrote SQL queries to finish data cleansing, remove duplicates, reorganize data formatting and establish tables. Designed reports in Tableau visualize important metrics utilizing maps, scatter plots, pie, bar, density plots • Executed scripts written in supported languages including Python, SPASS and R to deal with outliers to help data scientists build predictive models and increased model accuracy by 10% • Wrote SQL queries to finish data cleansing, remove duplicates, reorganize data formatting and establish tables. Designed reports in Tableau visualize important metrics utilizing maps, scatter plots, pie, bar, density plots
-
-
-
Kantar Media CIC
-
Shanghai City, China
-
Assistant Analyst Intern
-
Aug 2017 - Dec 2017
• Analyzed hot discussions of Dell and its competitors from different social media platforms, and delivered branding strategies in building and promoting healthy social media brand image • Used SQL to query the brand name, the post date, the URL and the discussion content from client database, and classified sentiment of the tokenized contents • Analyzed hot discussions of Dell and its competitors from different social media platforms, and delivered branding strategies in building and promoting healthy social media brand image • Used SQL to query the brand name, the post date, the URL and the discussion content from client database, and classified sentiment of the tokenized contents
-
-
Education
-
2018 - 2019
Columbia University in the City of New York
Master's degree, Statistics -
2014 - 2018
Shanghai University of Finance and Economics
Bachelor's degree, Statistics
Community
