Shawn Zhao

**** ***** ***, ***** *****, CA ***** / 408-832-6542mailto:acs22d@r.postjobfree.com / acs22d@r.postjobfree.com

EDUCATION

Santa Clara University, Leavey School of Business Jun 2015

Master of Information Technology

Track Representative: Computer-Based Decision Modeling, Database Management, Statistical Method

Liaoning Technical University Jul 2012

Bachelor of Management in Information System

Track Representative: Advanced Mathematics, Database and Data Mining

WORK EXPERIENCE

MVP.help, LLC Winter, 2015

Big data Analyst

Utilized Python to build a web crawler to crawl data from Chinese real estate website

Cleaned data with Tableau and Excel and stored in server side PostgreSQL database

Utilized Python statistical packages and Tableau to virtualize the Chinese real estate data

Laoqian Technology Company, Beijing, China Summer, 2014

Data Analyst

Designed, developed and built “Design Your Beauty” App to win the “Top10 of Audi Innovation Lab”

in China.

Utilized MySQL and Python statistical packages such as Pandas to conduct data analysis of target audiences and their location to help company accurately and rapidly reach its target customers, leading to a 10% increase in downloads.

Microsoft China, Beijing China Spring, 2013

Search Engine Optimization Analyst

Led a ten-member team to optimize video search algorithm leading to a 10% higher accuracy in Chinese

character-based search.

Conducted computer-based Bing Search Engine analysis using primary data out of questionnaires;

Contributed to 20% increased efficiency of Bing Search Engine.

Evaluated designs, identified potential problems related to Chinese Policy and proposed feasible

Improvements; discovered a major debug violating China’s pornography regulation policy during

Optimization process and solved it by eliminating video samples existent in test file.

PROJECT EXPERIENCE

Yelp Review Data Modeling and Analysis Winter, 2014

Used Import IO to build a crawler and crawled the data from Amazon website; utilized “Catnet”

Package to test some models using Amazon review data.

Utilized Python packages and MySQL to retrieve and clean Yelp review data; Specified the behavior and text mining Features to detect fraud reviews in review data using machine learning;

Built and applied the model involving Maximum Expectation algorithm to cluster fraud and non-fraud

Data in DataRapidMiner

Advanced Ion Exchanged Service (AIS) Fall, 2014

Used Linear Regression, Capacity and utilization consumption model with the leverage of EXCEL

to detect problems of AIS system Plant operation;

Conducted comprehensive metrics analysis of Capacity, Efficiency and Profitability of the plant operation;

made recommendations to improve profitability.

ADDITIONAL INFORMATION

General Technical: MySQL, SQL Server, Tableau, R, Visio, Import IO, Microsoft Visual Studio,

Computer Language: Python, JavaScript, Java, C#, CSS, PHP

Contact this candidate