Sign in

Data Analyst Assistant

San Mateo, CA
October 29, 2019

Contact this candidate


Yu Liu

Email: Tel:302-***-**** Foster City, CA Home Page:



Master of Science in Finance GPA: 4.0/4.0 Aug. 2017 – May 2019 Award: Academic Excellence Award in MSF Program (2019); Dean’s List Scholarship (2018) JILIN UNIVERSITY JILIN, CHINA

Bachelor of Science in Economics GPA:3.3/4.0 Sep. 2013 – July 2017 Award: Academic Excellence Scholarship (2016 & 2017) PROFESSIONAL EXPERIENCE


Data Analyst Intern Sep. 2019 - Current

• Worked with Senior Quantitative Developers to build dashboards for the Portfolio Management Team

• Grabbed trading signal data using SQL query and applied dash library to enable automated updating; Built hard drive cache and memory cache to improve process and inserted dashboards to the flask frame to create multiple pages

• Created a data provider to download, unzip, process, and upload risk data to google cloud and databases in Linux system C3 ALLIANCE MERIT2WORK NEW YORK, NY

Machine Learning Developer Aug. 2019 – Sep. 2019

• Assisted with the data analytics project for an Education Technology company by researching the client data use case and providing business insight by applying various analytical procedures

• Cleaned and wrangled large data sets, refined Machine Learning methodologies, and generated algorithm to produce high- impact predictive analytics; visualized data and compiled a report for client presentation UNIVERSITY OF DELAWARE

Teaching Assistant


Feb. 2019 – May 2019

• Helped Professor Paul Laux with the preparation of course material, grading assignments, and completing required records for 58 graduate Finance students; conducted regular office hours to facilitate learning ZHONGCHENG TECHNOLOGY CO., LTD.

Fin-tech Data Analyst


Jan. 2017 – Dec. 2017

• Assisted with the construction of a Machine Learning Data Model project for client China Merchants Bank - Dalian Branch, to help mine customer data and explore valuable leads for the Wealth Management business

• Examined and cleaned the existing data to ensure data quality and converted charter variables to numeric variables; worked with senior Wealth Managers to gain insight into the data to understand consumer behavior

• Conducted classification for Wealth Management products by risk level and industry; selected key factors affecting the purchase of products and built the models by using python (scikit-learn module)

• Monitored model performance and compiled model documentation to help validate and enhance the model CHINA MERCHANTS BANK

Finance Intern


July 2016 – Aug. 2016

• Used SQL to analyze existing client information for business generation: identified patterns and activities to help Account Managers identify potential leads (i.e., high credit performance with low deposit balance, etc.) RESEARCH & PROJECTS

Empirical Research: “Betting Against Beta” Feb. 2019 – May 2019

• Used SAS and Python to process 3 GB CRSP daily data between January 1926 through March 2012. Calculated rolling expected betas, conducted single and double sort analysis and ran time series regression.

• Constructed long-short portfolio and built Fama and MacBeth regressions to analyze factors affecting excess return SKILLS & CERTIFICATES

Software Python (Pandas, Numpy, Matplotlib, scikit-learn, request, BeautifulSoup) / SAS / VBA / SQL (MySQL, Oracle Database) / Tableau / Stata / Bloomberg / JSON / HTML / XML / Git / GitHub / JavaScript Certificate CFA level 3 (passed)

Language English (proficient), Mandarin (native)

Contact this candidate