ANKIT JAIN

adjkq6@r.postjobfree.com 619-***-**** https://www.linkedin.com/in/ankit-jain-34466b109/

OBJECTIVE

A motivated and hard-working individual looking to make a career as a Data Engineer. Seeking a full-time position starting May or June 2021

EDUCATION

Master of Science, Computer Science

Rochester Institute of Technology, NY, USA. GPA- 3.50 Expected: May 2021

(Big Data, Database Management Systems, Big Data Analytics, Data Warehousing, Foundations of Intelligent Systems, Foundations of Cryptography, Foundations of Algorithms)

Bachelor of Technology, Computer Engineering

Thapar University, India. GPA-7.24/10 August 2013-May 2017

(Data structures, Object Oriented Programming, Operating Systems, Database Management Systems, Software Engineering, Introduction to Data warehousing and Data Mining) SKILLS

Programming languages: Java, Python, R, Javascript, Lua for web scraping, C++, C and React Native Database Management: SQL, MongoDB, PL/SQL, SQL Server, Postgresql, H2 and Cassandra databases Libraries/Packages: Numpy, Pandas, Matplotlib, Scrapy, scrapy_splash Other Tools: Looker, Postman, Eclipse, Pycharm, Anaconda, IBM BlueworksLive, Power BI, SharePoint online, Splash, SAS, familiarity with Hadoop and Spark

WORK EXPERIENCE

Commonwealth Care Alliance (CCA), Boston, MA, Software Engineering Coop January-August 2020

Enhanced the project code that processes electronic data interchange (EDI) enrolment files in the HIPAA-834 format from Mass- Health into the CCA enrolment system

Developed and implemented a security analytics Power BI dashboard for the CCA’s Information Security department where data was extracted using REST API’s

Developed Looker dashboards that track in house applications and communication tools like Skype, Teams and Zoom to track useful statistics during COVID and understand which tool is being used the most

Developed Looker and Power BI dashboards to show CCA staff occupancy based on badge swipe, cell phone and laptop data.

Languages/Tools: Python, PL/SQL, SQL, SQL Server Management Studio, Oracle SQL Developer, Looker, PowerBI, Postman, REST API’s and Microsoft Graph API’s

Byju’s Think and Learn, Karnataka, India, Internship January-June 2017

Worked in the team that gathered data and ran analysis on application downloads. Data Visualization based on geography helped

identify new markets that could be targeted to increase sales

Worked on analysing in-app test scores of existing students enrolled to help them improve on their scores ACADEMIC PROJECTS

The Product Company’s Data Warehouse with ETL September-Present 2020

Built a data warehouse for ‘The Product Company’ involving customer, product, supplier, sales, orders and invoice data

Designed a Dimensional Model as per Kimball’s approach with conformed data marts, slowly changing and conformed dimensions. Implemented using SQL, MySQL Workbench, Pentaho Predicting Airbnb Prices May-August 2020

Worked on predicting Airbnb New York’s prices based on various factors. Visualized and analysed data after data cleaning.

Implemented PCA for dimensionality reduction and performed forward-backward stepwise selection for feature selection.

Used different Regression algorithms to predict the price of the Airbnb listings and fine-tuned Linear Regression. Implemented in R Optimal Path Detection Using GPS Data August-December 2019

Found the most optimal path by designing a cost function based on time spent on stop signs between a start and end point. Detected stop signs and turns along the route to select the best route amongst many

Converted GPS files to KML in Python to view on Google Earth. Data extracted and cleaned from the .kml files to read valid values. Implemented using Python, pyKML

IMDB Data Management, Introduction to Big Data January- May 2019

Built a consumer database on IMDB dataset. Designed Entity relationship diagram to create a normalized dataset.

Wrote a program to load data from RDBMS to MongoDB and perform clustering using Euclidean distance. Implemented using Python, SQL, MongoDB, Postgresql Author Identification, Foundations of Intelligent Systems January-May 2019

Trained logistic regression classifier to determine the authors of different passages of texts

Implemented using Logistic Regression’s Sigmoid Activation function and Decision Tree approach using Entropy and Information Gain. Implemented in Python