Sign in

Java, Python, SQL, R, SAS, Tableau, PostgreSQL, MapGIS

Hoboken, NJ
March 14, 2019

Contact this candidate


Hongyi Chen

• •GitHub:


Stevens Institute of Technology, Hoboken, NJ Expected May.2019 M.S. of Business Intelligence & Analytics, Data Science Concentration (GPA: 3.52) Major Courses: Data Structure & Algorithms, Big Data Tech., Data Visualization Application, Multivariate Data Analysis, Data Warehousing, Applied Analytics of Big Data, Web Mining, Database Engineering, Knowledge Discovery Databases, Data & Knowledge Management, Social Network Analysis Armour College of Engineering, Illinois Institute of Technology, Chicago, IL Dec.2017 B.S. of Electrical Engineering


· Programming: Java, Python, SQL, R, SAS, Tableau, PostgreSQL, MapGIS

· Certificates: SQL, Stanford’s Databases MOOC; Intermediate R for Data Science, edX MOOC; Intermediate Python for Data Science, edX MOOC; Tableau Desktop Specialist, Tableau Professional Experience

Jones Lang LaSalle, Beijing, China 07/18-08/18

Data Analyst Intern, Strategic Consulting Department

· Visualized data for multiple team projects using Tableau

· Prepared Analysis Report of Relic Protection Project in Beijing for internal use

· Cleansed geographical data in MapGIS system using Python that accelerated the analysis process

· Evaluated projects of infrastructure constructions using Big Data for group presentation and discussion Chinese Academy of Sciences, Beijing, China 06/18-07/18 Data Analyst Intern, Department of Big Data

· Converted semi-structured XML files of Medical Patent Application Information to Excel using Java

· Discovered relationships between Residential & Commercial Information in OSM using PostgreSQL

· Generated visualizations in Climate Reports for Beijing Municipal Bureau of Agriculture using Tableau Capital Market Statistics and Monitoring Center, Beijing, China 06/17-08/17 Data Analyst Intern, Statistics Dept.1

· Programmed Stock Trading Information Masking using Java that protect thousands of investors.

· Collaborated in team of 3 to complete the writing of Regulation of Data Masking in Central Database

· Collating more than 1,300 pieces of sensitive information in R China Minsheng Bank, Beijing, China 06/16-08/16

Business Analyst Intern, Business Management Dept.

· Assisted to prepare quarterly analysis report for the business of personal financial services

· Completed the investigation report on e-commerce sector for fresh produce

· Completed the bench-marking report of a leading company in the market Projects

Stevens Institute of Technology, Hoboken, NJ Spring, 2018 Optimizing Capacity Utilization & Location Planning of Hudson Bike Share l Cleansed raw data of trips based on the starting & ending point and time using Python l Visualized the numbers of trips between stations with Network Statistics Analysis using Gephi l Generated suggestions of optimal locations for new stations based on Gravity Location Model Stevens Institute of Technology, Hoboken, NJ Fall, 2018 Customer Churn Rate Analysis: Predictive Analysis Model for Retaining Customers l Conducted multiple analyses to data of customers’ services usages 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 Available May 2019

Contact this candidate