Java, Python, R, SQL

Moran Wang

720-***-**** *******@**.*** seeking internship

EDUCATION

University of Washington, MS, Computer science (G.P.A. 3.64/4.0) September 2018 - December 2019 University of Denver, MS: Data Science June 2017 – August 2019 University of Denver, BSBA: Business Information Analytics June 2013 - June 2017 WORK EXPERIENCE

Business Analyst Internship

Able.co (Denver, Colorado) March 2017 – June 2017

• Analyzed the business models and competitive advantage for multiple startup companies’ web traffic data. The final report successfully helped Able.co to notice one start-up company and finally invested this company

• Collected the housing price data and number of houses provided in the Airbnb market to apply to the demand and supply curve and analyze the equilibrium point

• Conducted test analysis on the comments and build sentiment model to predict the implication of the text and built regression models in Python and R to predict the future rental prices based on the historical price, room types, sentiment evaluation and so on

PROJECT EXPERIENCE

AWS Lambda ETL Fall 2018

• Implemented a multi-stage ETL pipeline as a set of independent AWS Lambda services and finished extracting, transforming and loading raw sales data in AWS Lambda implemented by Java

• Stored intermediate data in S3, final data in SQLite and speeded up the performance of inserting data into SQLite

• Implemented and compared client flow control and microservice flow control

• Analyzed the relationship among memory used, data size and overall throughput to find the most economical way to configure the memory allocated to lambda function

Fake News Detection Summer 2018

• Collected news labeled as fake and real and converted news into sequential integer by using tokenizer and then converted them to vector by using Word2Vec

• Trained these news vectors by using LSTM networks and Keras package in deep learning in Python

• Extracted online news by using the Beautiful Soup package and predict the news reality by 95% accuracy Denver Police Department Data Analysis Spring 2017

• Analyzed arrest, offense and neighborhood demographic data in each zip code of the Denver Police Department and built multiple regression and classification models to indicates how Denver Police Office to assign their police force.

• Identified the patterns of the arrested individuals by demographics and crime types to predict the key attributes that are most likely to trigger an arrest and the pattern of the number of offense and number of arrests based on time

• Visualize the data analytics result in PowerBI

TECHNICAL SKILLS

• Programming Languages: Java, Python, R, SQL

• Tools: AWS, Pandas, MySQL, SQLServer, Spark, Hadoop, SPSS, JMP, Tableau, PowerBI

Contact this candidate