Resume

Sign in

Data Analysis

Location:
Chicago, Illinois, United States
Posted:
October 19, 2016

Contact this candidate

Boyang Tian

*** * ******* ***, *******, IL, *****

312-***-**** acw45q@r.postjobfree.com

Education Background

DePaul University, Kellstadt Graduate School of Business, Chicago, IL Expected 11/2016 Master of Science in Computational Finance

Core Courses: Investment Analysis,Financial Accounting, Monte Carlo Algorism, Data Analysis and Regression, Time Series Analysis Forecasting, Mining Big Data University of International Relations, Beijing, China 07/2013 Bachelor, Public Administration

Skills

Proficient in Python, R, Hadoop, Microsoft Word, Excel, PowerPoint, Outlook, Access

Basic in C#, SQL,C++

English(Fluent) Chinese(Native)

Work & Internship Experience

DePaul University, Chicago, IL 09/2015-Present

Computer Lab Tech

Maintain routine lab checks and manage inventory of supplies and replacement parts.

Use HP Web JetAdmin to monitor printers and resolve problems when necessary.

Export printers’ data to make analytic report to help supervisor be wise to usage of printing resources on each region.

Repair and replace hardware of PCs and reimage the operating system (Win7, Win10, and Mac OX).

Respond to CRM tickets and demonstrate how to use various software and printing functions to students in order to help resolve problems.

Ernst & Young, Beijing, China 12/2012-07/2013

HR Campus Recruiter

Planed and prepared the following program: Ernst & Young Winter Internship Program for Auditing Department, Ernst & Young Summer Leadership Program, and Ernst & Young Autumn Campus Recruitment Program.

Designed and leaded Ernst & Young Ambassadors Program.

Arranged the schedule of written tests and face-to-face interviews for candidates, and updated interview progress, offers and feedback in tracking system.

Conducted new employee orientations to help them involved in Ernst & Young.

Collected and processed data from application system to make analytic report to help formulate competitive recruiting strategy.

Gathered and analyzed past five years recruiting data to make forecast report of next year, to help allocate recruiting resources on each target school.

Project

Data Regression Analysis --- forecasting NBA players' salaries

Collected recent two seasons information about each player in NBA and used R to built four models and analyzed their coefficient, F-Stat, T-Stat, Adjusted R-square and finding the relationship between each model

Analyzed residual plots for each variable to solve multicollinearity and Q-Q plot for the each model to delete outliers

Compared each model and found the relationship between salary and positions. Analysis of Airline On-Time Performance and Causes of Flight Delays based on Hadoop

Collected 2014 and 2015 Airline Performance data from U.S. Department of Transportation (more than two million records) and used Hadoop to compute most three frequent cause of flight delay, the relationship between distance and delay and three carriers that are most easily to cause flight delay.

Compared the results of each quarter and analysis the differences, and gave customers traveling advice based on results.

Monte Carlo Algorism --- Portfolio profits analysis and forecast based on python

Collected and filtered the five years finance data of five Large-cap companies (AAPL, EMC, HPQ, QCOM, and STX), calculated average yearly log return and yearly volatility for each company.

Implemented two Monte Carlo simulations (Gaussian model and resampling) to compute the value of the portfolio in one year and 5% VAR then compared both simulations. Taxol Trading Engine based on C#

Collected and filtered eight years price data of Taxol.

Construct exchange engine based on TCP/IP and XML.

Implemented Gaussian model to simulated the price for each trader and send the trading information to exchange engine to process orders matching.



Contact this candidate