Data Analyst

Location:

Salary:

80k/year

Posted:

May 19, 2017

JIAYING(Zoe) LIU

EDUCATION

University of California, San Diego 09/2015 - Present Master of Science in Statistics

China University of Mining and Technology (CUMT) 09/2010 - 06/2014 Bachelor of Science in Applied Mathematics

China University of Mining and Technology (CUMT) 09/2012 - 06/2014 Minor in Finance

WORKING EXPERIENCE

Data Analyst, Mortgage Capital Trading, San Diego, CA 06/2016 - 12/2016

• Aggregate data from different files by Macro.

• Built data model between security price and investor pricing, added market share as a new factor.

• Wrote R functions to control residuals, visualize process bar and output pdf report automatically.

• Constrained optimization. Wrote R functions to find op- timal combination of multiple kinds of loans with linear constrained of each bank.

• The results helped company save over 10% cost.

PROJECTS

Google Auto Completion Java

• Build N-Gram library based on Wiki dataset, build Lan- guage Model by probability, generate data and write it into database.

• Use JQuery, PHP, Ajax to call database makes real- time autocompletion realize. Show the auto completion of search engine on the Webpage.

Movie Recommender System Java

• In this project, we use data from Netflix and help peo- ple find movies that may interest them.

• Based on Item Collaborate Filter algorithm, build co- occurrence matrix and rating matrix. Matrix computa- tion to get the recommending results.

• 5 MapReduce Jobs Chain.

Page Rank Java

• Integrate page rank algorithm based on Wiki dataset which is used by Google Search to rank websites in their search engine results

• Use transition matrix to build relationship between vari- ous websites. Generate PR matrix to calculate Page Rank of each Webpage.

• Use convergence value of Page Rank to get the rank of Webpage.