Data Analyst

Hongyi Chen

•201-***-**** •adhukz@r.postjobfree.com •Jersey City, NJ 07307

•LinkedIn: https://linkedin.com/in/hongyi-chen-007545a2/ •Github: http://github.com/charleschen0611 Education

Stevens Institute of Technology, Hoboken, NJ May.2019 M.S. of Business Intelligence & Analytics, Data Science Concentration, Major GPA: 3.67/4.0 Armour College of Engineering, Illinois Institute of Technology, Chicago, IL Dec.2017 B.S. of Electrical Engineering

Skills

• Programming Languages: Java, Python(Selenium, TensorFlow, PySpark), SQL, R, MongoDB, Hadoop

• Professional Skills: Tableau, PowerBI, Gephi, VOSviewer, Excel(VLOOKUP, Pivot Table) Professional Experience

AADM LLC, Harrison, NJ, US 07/19 - Present

Data Analyst

l Query and maintain customer info database utilizing SQL & conduct analysis of customer insight l Partner with DS team to develop data pipelines & utilize statistical methods to drive business results l Build predictive models to analyze future trends of ETF & other economic data scraped from web l Conduct data regression analysis of the relationship between ETF prices and industry trends l Develop visualizations to provide analysis & ratings for investors using Tableau Dashboards Jones Lang LaSalle, Beijing, China 07/18 - 08/18

Data Analyst Intern, Strategic Consulting Department l Constructed models comparison for Analysis Report of Relic Protection Project in Beijing l Cleansed geographical data in ArcGIS system that accelerated the analysis process l Evaluated project of infrastructure constructions in Beijing Capital Airport for group presentation Chinese Academy of Sciences, Beijing, China 06/18 - 07/18 Data Analyst Intern, Department of Big Data

l Converted semi-structured XML files of Medical Patent Application Information to Excel l Discovered relationships between Residential & Commercial Information in OSM using SQL l Generated visualizations in Climate Reports for Beijing Municipal Bureau of Agriculture Capital Market Statistics and Monitoring Center, Beijing, China 06/17 - 08/17 Data Analyst Intern, Statistics Dept.1

l Programmed Stock Trading Information Masking using Java l Built predictive models to evaluate their accuracies of analysis the residential reviews l Completed the flowchart & writing of Regulation of Data Masking in Central Database Projects

Stevens Institute of Technology, Hoboken, NJ

Web Mining of Manhattan Restaurants Reviews on Yelp Spring, 2019 l Scraped Customer Info, reviews & scores for 25 top restaurants for modeling using Hadoop l Extracted top 4 topics in tokenized reviews using Latent Dirichlet Allocation model by Python l Evaluated multiple Machine Learning models for reviews & sentiment for accuracy using ROC & AUC Bibliometric Data Analysis of Authors of Wiley Projects Spring, 2019 l Scraped Bibliometric information from the web to find out relationships between authors using Python l Analyzed the impact factor of authors and its relationship with funding & publication features l Validated top 5 authors in bio-material area in 2013-2015 using co-authorship network in VOSViewer Customer Churn Rate Analysis: Predictive Analysis Model for Retaining Customers Fall, 2018 l Conducted multiple analysis to data of customers’ services usages in Telecom Companies using R l Generated top 5 reasons of churning based on the comparison of the five analysis models l Provided suggestions on generating more competitive service plans Optimizing Capacity Utilizing & Location Planning of Hudson Bike Share Spring, 2018 l Cleansed raw data of trips & generated Gravity Location Model for new station locations using Python l Visualized the numbers of trips between stations with Network Statistics Analysis using Tableau

Contact this candidate