Data Analyst and Engineer

HANSEN HE

Long Island City, NY 949-***-**** **************@*****.*** linkedin.com/in/zhiyuan-he TECHNICAL SKILLS

Experienced in data analysis, data science, and CRM; Eager to learn more about big data and data management

• Advanced in Python, SQL, R, Excel (lookups, pivotable, VBA), Tableau, Bloomberg; Proficient in C++, Docker, Unix/Linux, Git/GitHub, AWS, Airflow, Spark, Hive, Pig, MongoDB, Cassandra, Power BI, Elasticsearch, Alteryx

• Certificates: Financial Risk Manager (FRM®) Part I Passed, Bloomberg Market Concepts

• DataCamp Tracks: Data Scientist with Python, Data Analyst with Python, Python Programmer, Spreadsheet Fundamentals

• DataCamp courses: Data Visualizations, SQL Database, Machine Learning, Shell, Spark, Natural Language Processing

• Coursera: Algorithms Specialization, Deep Learning Specialization, Intro to Big Data, Apache Spark, SQL for Data Science EDUCATION

FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY MS Quantitative Finance Aug 2018-May 2020

• Relevant Courses: Machine Learning, SQL, R, Python, C++, Tableau UNIVERSITY OF CALIFORNIA, IRVINE Irvine, CA

BA Economics Sep 2014-Jun 2018

BA Psychology and Social Behaviors

• Relevant Courses: Python, R, Econometrics

EXPERIENCE

MOYI-TECH (MOYI INC.) New York, NY

Data Analyst and Engineer Jan 2020-Present

• Contributed to Python API development project, “Minerva”, for quant research using VS code, Jupyter, Git and Django

• Designed data and ETL pipelines to fetch and transform 100 million+ of financial data in JSON, XML, and CSV

• Built AWS CI/CD pipelines to maintain and automate loading to python Django web app (datahub), SQL, MongoDB

• Used Angular JS for website UI designs and designed Tableau dashboards as presentations to clients

• Conducted NLP with RNN, LSTM, GRU to identify trends and classify time-series sentiments of 70,000+ news articles POINT ZERO ONE TECHNOLOGY LTD. Hong Kong, China

Equity Quant Research (Data Science) May 2019-Jan 2020

• Constructed ETL, data, and NLP pipelines for 20 million+ data and automated loading to MySQL with Airflow

• Designed ML pipelines of over nine supervised learnings for cryptocurrency and stock trading (SciPy, Sklearn)

• Published a literature review Gradient Boosting Machine: A Survey on arXiv.org as first author

• Developed and back tested cryptocurrency trading strategies with 2 million+ data using XGBoost, SGD, PCA, and DWT

• Created stock algorithmic trading strategies and back tested using Python and Quantopian

• Researched deep reinforcement learning trading using OpenAI algorithms (Gym, TensorFlow, Keras) VISION QUEST INTERNATIONAL FUTURES CO. Hong Kong, China Data Analyst Mar 2018-Oct 2018

• Maintained client information and orders with Excel, SQL and produced data analysis and visualizations in R, Tableau

• Compiled weekly reports of orders, clients, capitals, and traders to management using SQL, Excel and Tableau

• Presented investment proposals to senior managers and investors using PowerPoint and Tableau

• Designed cross-market and cross-asset stat-arb and hedge strategies for commodity and FX futures by R, Python, Excel UNIVERSITY OF CALIFORNIA, IRVINE Irvine, CA

Research Assistant, Economics Department – part time Jan 2018-May 2018

• Researched and called master’s programs in Economics of 100+ institutions worldwide

• Compiled targeted information and built relational databases of 150+ master’s programs with Excel Pivotable and SQL

• Produced statistical summaries (std, max/min, etc.) and data visualizations (histogram, boxplot, pie chart, etc.) with R

• Recorded 200+ student responses from questionnaires and imputed information to SQL Server and Excel Pivotable VISION QUEST INTERNATIONAL FUTURES CO. Hong Kong, China Assistant Financial Analyst Jun 2017-Aug 2017

• Reconciled and maintained seven ledgers; accelerated liquidity of operating cycle by 15% in Excel

• Created 10 detailed financial models (P&L, CF) of company and financial analysis of product in Excel

• Improved workflow efficiency by over 50% using alternative methods and new database layout by VBA and Pivotable

Contact this candidate