TAPAN RAJPURA

Boston, MA ***** +1-617-***-**** adbdbv@r.postjobfree.com linkedin.com/in/tapan-rajpura EDUCATION:

Northeastern University, Boston, MA December 2019

Master of Science in Industrial Engineering GPA: 3.5/4 Courses: Data Mining, Data Management & Database Design, Engineering Probability & Statistics, Data Warehousing and Business Intelligence, Healthcare Modeling and Analysis, Deterministic Operations Research, Financial Management Silver Oak College of Engineering & Technology, GTU, India July 2016 Bachelor of Engineering in Mechanical Engineering

WORK EXPERIENCE:

Teaching Assistant, Northeastern University, Boston Sept 2019-Dec 2019

• Conducted TA sessions, workshops, assisted in grading, proctored exams and provided instructional support to students Research Assistant, Northeastern University, Boston Sept 2019- Dec 2019 Hyperparameters Database Project

• Created a conceptual model and Entity Relation diagram of the database in MySQL workbench

• Identified hyperparameters generated with H2O to be used as important features for better understanding

• Transformed the schema by performing normalization up to 3NF for achieving better results using ad-hoc queries

• Analyzed data on the database using complex queries to achieve valuable business insights Industrial & Site Engineer, S.R. Engineers, Ahmedabad, India July 2016-Dec 2017

• Analyzed and identified functional issues of 15-20 boilers and made recommendation for repair to clients

• Managed team of 40 workers to ensure efficient use of manpower and to minimize resource waste for sole boiler provider

• Directed customer service team coordinating with boiler authorities for scheduling sales and repairs Design and Development Engineer, Helium Ink. Pune, India Aug 2015-Dec 2015

• Researched product development cycle of 3D printer extruder using Thermoplastic material to reduce cost for better access

• Analyzed the working of 3D printer extruder and collected data for components

• Designed a 3D model using SolidWorks and Manufactured a basic prototype of 3D printer extruder reducing its cost by 30% TECHNICAL SKILLS:

Programming Languages : R, SQL, Python

Visualizations Software : Tableau, Microsoft Excel Database Management Systems : MySQL, Microsoft SQL Server Tools : Lingo, Julia, Minitab, Weka, Creo parametric 2.0, SolidWorks ACADEMIC PROJECTS: Northeastern University, Boston, MA Social Data News Site-Web Scrapping Database Project Spring 2019

• Extracted data of top 20 Twitter users using Twitter API with ‘twitter’ library in Jupyter notebook

• Modeled Data by creating E-R diagram consisting of entities and attributes in MySQL workbench using dataset

• Normalized the schema upto 3NF by filtering the significant features to get enhanced outcomes

• Created views, stored procedures and functions to get insights for better customer experience Forecasting of Emergency Room Department of a Private Hospital Spring 2019

• Collected Data of a private hospital’s patients’ arrival, departure, age, gender and triage for 2 years

• Performed exponential smoothing, time series regression, linear regression created visualizations in Tableau and Excel

• Divided dataset into test data and validation and calculated accuracies for testing with Data Analysis tool and Pivot table

• Forecasted Emergency Room Patient demand for next year using regression algorithm giving best error metric Blue Collar Employee’s Benefits Classification After Unemployment Fall 2018

• Classified employees’ profiles based on response variable to determine eligibility for benefits with R

• Preprocessed data by filling missing values, adding dummy variables and removing duplicates using Jupyter Notebook

• Performed k-NN, Naive Bayes’ and Random Forest models in R with 81% accuracy

• Visualized inter-relationship amongst predictors through heatmaps, bar graphs, box plots, correlation matrices Summary of Summer Olympics Fall 2018

• Built four Tableau dashboards and two stories for Olympics database from year 1896 to 2012 (29217 records)

• Contextualized data by joining 5 data tables to bring in more relevant info like continents for participated countries

• Added additional dimensions for analysis through feature engineering by creating Calculated Fields, Sets, Groups, & Bins

• Highlighted key insights by meticulously selecting relevant type of charts, labels, marks, and annotations

Contact this candidate