CV

Claire Tsao

EDUCATION

MS in Information Management
University of Illinois Urbana-Champaign

Expected Graduation: May 2020

Coursework: Distributed System, Data Visualization, Statistical Learning, Econometrics
GPA: 3.83/4

BS in Agricultural Chemistry
National Taiwan University

2012

WORK EXPERIENCE

Data Solution Analyst
Cloud Imperium Games

Austin, TX
Sep 2020 -

  • Defined key metrics and analytics schemes for executives to understand user behaviors and identify trends, measuring the performance of campaigns and events.
  • Created straight-forward and structured Tableau dashboards for, and designed visual templates of data report, improving readability and consistency in company identity.
  • Established full-cycle analytics pipelines from data sources to reports. Tools include ElasticSearch, MySQL, EMR, S3, Hive, Athena, Spark, Shell, Python, Kubernetes, QuickSight and Tableau.
  • Provided hypothesis-driven and data-proven recommendations to ad-hoc business questions from executives timely, applying new and suitable methods through quick research.
  • Mentored junior analysts from analytics insights exploring to Python and SQL scripting.
Analytics Intern
Chegg

Santa Clara, CA
Jun 2019 - Aug 2019

  • Established an end-to-end streaming data pipeline from data sources to dashboards by DynamoDB, Spark Structured Streaming, S3 and Django. Deployed it on EC2 using Jenkins.
  • Built a D3.js-based dashboard with real-time data to show the potential of team’s new service.
  • Converted a vague idea to a well-defined project framework by interviewing cross-functional stakeholders and evaluating solutions to best fit the requirements under development restrictions.
Data Analyst/Information Designer
Freelancer

Taipei, Taiwan
Aug 2017 - Aug 2018

  • Developed MongoDB and Python scripts to identify key metrics and potential paid customers for 8 Interactive, a chat bot startup in Taiwan, which improved trial-to-paid conversions by 35%.
  • Built performance monitor dashboards on Redash for 8 Interactive.
  • Conducted trend and regression analysis for Cathay Financial Holdings on sustainable energy and inclusion topics, and delivered the presentation in infographics on their corporate social responsibility report.
Instructor
Freelancer

Taipei, Taiwan Feb 2018 - Jul 2018

  • Instructed a data visualization and journalism course at NCCU, a top-5 university in Taiwan.
  • Assisted as mentor in a four-day internal data science in R camp in BenQ.
Data Analyst
Taiwan Star Telecom

Taipei, Taiwan
Sep 2016 - Jul 2017

  • Designed and developed the database schema and ETL of new daily KPI report across channels from scratch on Oracle and MySQL, saving 28 labor-hour everyday from manual report works
  • Optimized SQL scripts, which shortened some scripts runtime from hours to seconds.
Research Assistant
MIT Media Lab

Cambridge, MA
Feb 2016 - Jul 2016

  • [Project: Multi-layer interactive maps of cities' topics of interest] Led a team of 3 undergraduate students to analyze civic data through statistics and machine learning methods from data collection to interactive visualizationScraped 400k records reviews, posts, and photos from social media using Python. Obtained descriptive statistics in R to see the whole picture, text mining, and computer vision using NumPy, Pandas, NLTK, TensorFlow to better understand topics of interest.
  • .
  • [Project: Sightseeing hotspots by time] Processed call detail record data of 200 GB via Shell Script and Python and visualized as minute-scale movement on map in D3.js.
Project Manager & Data Analyst
BigObject

Taipei, Taiwan

 Nov 2014 - Jan 2016

  • Led data and engineering teams to understand clients’ needs, analyzed their data, and established an analysis procedure/system for clients. Won the startup’s first paid customer.
  • Built an automatic system to collect real-time tweets and pipe to database via FluentD for demo.
  • Identified and categorized customers by transactions, user-data, and web logs to target consumers for a E-commerce client using R, Python, and BigObject (an analytic database).
Channel Sales
Philips

Taipei, Taiwan

 Jan 2013 - May 2014

  • Marketed Sonicare products to targeted clinics, and improved sales by 20% in 2013 yoy.

COMMUNITY

Founder
Cicadata

The first data journalism & visualization community in Taiwan


 Sep 2016 -

Graph Editor
TalkEcon

A Economics popularization blog

Organizer
Taiwan R User Group
Talks & Events
  • May 2014 Study Group: Machine Learning for Hackers, R Ladies Taipei
  • Oct 2016 Coordinator, Data Visualization Afternoon Tea by Cicadata
  • Dec 2016 Talk: Data Journalism 101, Taiwan R User Group
  • Dec 2016 Coordinator & Speaker, Data Visualization - GIS workshop by Cicadata
  • Dec 2016 Tech Mentor, Facebook #SheMeansBusiness Workshop Taiwan
  • Mar 2017 Coordinator & Mentor, Data Visualization - ggplot2 Workshop by Cicadata
  • May 2017 Talk: Data Journalism & Visualization, R Ladies Taipei
  • Aug 2017 Coordinator, Women & Data Science Joint Meetup by R Ladies Taipei, PyLadies Taipei & Girls in Tech
  • Sep 2017 Talk: Exploratory Data Analysis & Prototyping in PowerBI, R Ladies Taipei
  • Jan 2018 Talk: ggplot2 Basic, Taiwan R User Group
  • Jan 2018 Coordinator & Mentor, Tableau Day, R Ladies Taipei
  • Mar 2018 Panelist, Women in Data Science Conference Taipei 2018
  • Aug 2018 Mentor, Kaggle Competition, R Ladies Taipei
  • May 2019 Organizer, Visualization Workshop, NATSA Annual Conference
  • Jun 2019 Moderator, Women in Silicon Valley, Cafe Philio @ Bay Area