Data Engineer

ASHISH BANSAL

** ****** ******, *** #** Brooklyn, NY 631-***-**** ******@***.***

https://github.com/ab6995 https://www.linkedin.com/in/ashish-bansal-7b0b129a/ https://ab6995.github.io/ EDUCATION

NEW YORK UNIVERSITY TANDON SCHOOL OF ENGINEERING, BROOKLYN, NY MAY 2018 Masters of Science in Computer Science (GPA 3.633) SRM UNIVERSITY, NCR CAMPUS, INDIA MAY 2015

Bachelors of Technology in Computer Science (GPA 3.4) SKILLS

Software Languages: C, C++, Java, SQL, HTML, Prolog, Python, R, Tableau, Mongo DB, Hadoop, Pig, Apache Spark Operating Systems: Windows, Linux

Application Tools: Microsoft Suite, Oracle 9i, IntelliJ, Scikit-learn, Jupyter, Visio, Git, Tensorflow, Docker, MySql workbench, AWS, Kafka

EXPERIENCE

MTA New York City Transit, New York, USA SEP 2017 – Present SYSTEM & DATA SCIENCE RESEARCH INTERN

• Built an api using python for calculating performance metrics and ridership estimations by producing aggregated data.

• Writing and maintaining ETL scripts.

• Implementing KAFKA to build real-time data pipelines and streaming applications by collecting data from different zmq's. HCL TECHNOLOGIES, NOIDA, INDIA OCT 2015 - APRIL 2016 SOFTWARE ENGINEER INTERN

• Performed bug tracking in C++.

• Designed and developed software for operating systems.

• Fixed ill-defined requirements of the software.

• Deployment of various requirements using Scrum Methodology. ACADEMIC PROJECTS

iNEWS: NYU SEP 2017 – DEC 2017

• Mobile application that uses a News API to fetch the latest news from sources including CNN and the New York Times and deliver it to the user; whether or not user is connected to the Internet.

• Sends a push notification to user every day at 9 AM EST to awaken the app, so that the latest news can be downloaded.

• Developed backend of the application using Amazon Web Services such as Lambda, SQS, SNS and DynamoDB to retrieve unique news from source. Also, developed APIs to retrieve and search news from AWS ElasticSearch.

• Two factor authentications are provided for security purposes using AWS Cognito. ANALYZING NYPD COMPLAINT DATA (HISTORIC): NYU JULY 2017 – AUG 2017

• Analyzed NYPD Complaint data to uncover hidden patterns, unknown correlations, crime trends and other anomalies.

• Generated hypothesis based on revelations by correlating with datasets like Weather, census and employment data.

• Used Spark Scripts, Map-reduce and Sql queries to clean data.

• Python libraries such as seaborn, matlib, bokeh and folium are used for data visualization. YELP DATASET ANALYSIS: NYU JUNE 2017 - JULY 2017

• Performed some basic statistics like summarizing reviews by city and category, ratings of businesses around University of Wisconsin-Madison, based on number of reviews on the dataset by executing scripts written in PigLatin and ApacheSpark.

• Performed port mapping to run Hue web Interface through local browser by setting cloudera quick start container in Docker

• Created visualizations in Tableau based on data obtained from the resulted scripts. CLASSIFIERS TO IDENTIFY TWITTER ACCOUNTS AS BOTS OR NOT BOTS: NYU JAN 2017 - APRIL 2017

• Built four classifiers (Multinomial Naive Bayes, Decision Trees, Logistic Regression and Random Forest) using python libraries pandas to train our model to predict twitter accounts as bots.

• Compared model’s accuracy from different classifiers we built. ADDITIONAL INFORMATION

Honors and Awards: Top Performer in fitness challenge at NYU, Secured First Position in App builder competition and Third position in Cyber Crime event at SRM University

Student Clubs: Captain of University Cricket team, Graduate orientation leader, Volunteer at Red Cross Blood Donation Club

Contact this candidate