Data Analyst

Guo (Iris) Chen

**** ****** *** ****, ********, California 94704 510-***-**** *********@********.*** EDUCATION

University of California, Berkeley

Major: Bachelor of Arts, Statistics December 2016

Coursework

- Linear Modelling: Theory and Applications - Industrial and Commercial Data

- Financial Information Analysis - Time Series

- Applied Econometrics - Geographic Information Analysis SKILLS

Computer: Statistical software – R, STATA, SAS; MATLAB, SQL, MS Excel, Word, PowerPoint; ArcGIS, ESRI, QGIS and Google Earth; HTML, LaTeX

Languages: Bilingual proficiency in Chinese; basic speaking, reading, and writing skills in German RELEVANT EXPERIENCE

Google Earth Intern April 2017-May 2017

Joint Earth Education Project

• Functionally built KMLs and created tours within Google Earth

• Sourced imagery and videos in terms of global change and anthropogenic activities

• Helped support the creation of UGC stories on new Google technology that will be publicly launched Part-time Virtual Intern: Data Analyst August 2015-March 2016 Technical Consulting & Research, Inc. (TCR) Weston, CT

● Manipulate real data with R for educational surveys from high schools in Hungary, Brazil, Kenya, and Hong Kong

● Data visualization

● Provide findings of data to the VP and discuss with the team on the results found every week during the webinar Research Assistant August 2014-December 2014

The Mishler Lab: Quantitative Analysis of Specialized cells in Devonian Liverworts, UC Berkeley

● Generated spreadsheets for data from 642 slides of the liverworts’ fossil specimens and modern specimens, each with 22 different variables/categories on Excel

● Compared among different categories of certain slides, calculated correlation and covariance of them, and made clearly- demonstrated graphs on Excel

● Made graphs more informative by adding photographed pictures and contributed to a more successful presentation for the supervisor

PROJECTS

GIS Project: Effect of TRIs and Superfund Sites on House Prices in Sunnyvale, CA April 2016

● Extracted real data on house price to points and digitized polygons in Google Earth

● Performed Kriging analysis in ArcGIS and got multi-layer maps out of the software for presentation

● Purged the dataset on house in Excel to make regression analysis on the marginal effect of proximity in distance from superfund sites and distance from TRIs

● Overlaid an interpolated surface in terms of fluoridated and non-fluoridated area with the under five population data to determine whether children under five are affected by the fluoride contamination Statistical Project: Prediction of the Winning Party in the U.S. Presidential Election December 2014 Teamwork with a group of four students

● Used data from the previous election to build the models: k nearest neighbors and rpart

● Made a map that compares the change in votes from the previous year to the year predicted

Contact this candidate