SQL, Pyhton, Java, R, JS

Harsh Mehta

917-***-**** ● College Park, MD – *0740 (Open to relocation) ● *********@*****.***

https://www.linkedin.com/in/harshmehta17/

EDUCATION

University of Maryland, A. James Clark School of Engineering College Park, MD, USA Master of Engineering, Software Engineering, GPA: 3.48 May 2020

● Relevant coursework: Data Science, Database Design, Data Structures & Algorithms, Data Mining Gujarat Technological University Ahmedabad, GJ, India Bachelor of Engineering, Electronics & Communication Engineering June 2017

● Graduated with “First Class with Distinction” honor(GPA: 8.55/10) WORK EXPERIENCE

District Department of Transportation(DDOT) Washington, DC,USA Database Developer Aug 2019 – Dec 2019

● Worked with a team of 3 to develop accessible SQL databases for Permanent Count Stations(PCS) datasets to provide flexible and efficient access to information and increased overall efficiency by 25%.

● Generated data visualization reports in R and demonstrated presentations to a group of 50+. Database Development & Management Intern June 2019 – Aug 2019

● Developed Python script to retrieve data from Virginia Connected Corridor API to extract details of Basic Safety Messages transmitted between vehicles, the location of potholes and as it’s severity. Improved real time situation awareness by 15-20%.

● Invented the idea of monitoring all the Permanent Count Stations on daily basis using a Python script and MS-SQL server database to detect the dormant stations on a daily basis opposed to manually checking it at the end of the month. Reduced workload by 15-20% and increased availability of data by 33%.

● Designed database in SQL for datasets of real-time ITS devices and established accessible repositories for existing datasets in MS-SQL server.

BrillBrains Techno Labs Ahmedabad, GJ, India

Software Engineer Aug 2017 – May 2018

● Gathered and analyzed the requirements from the stakeholders and created the initial design based on the set of requirements to develop a school portal using ReactJS and NodeJS.

● Participated in the development activities and led the testing efforts for the applications built and deployed in an Agile fashion. PROJECT EXPERIENCE

Coronavirus 2019 data set analysis and visualization

● Developed data analysis system to carry out comparative analysis to examine the differences in the spread of the disease in China and other parts of the world using R and Python.

● Built decision trees and generalized linear model in R to predict the growth rate of number of cases.

● Designed python script using web scrapping and google trends API to monitor state-wise total number of cases and casualties as well as set up alert trigger when these states reach certain number of confirmed cases. Lending Loan data set analysis and visualization

● Developed a loan data analysis system using R to classify potential customers in custom creditworthy groups.

● Built the decision trees and generalized linear model in R using dplyr, ggplot2, ggthemes, corrplot libraries. Smart healthcare application

● Developed a web based application using SQL server and Java as back-end support.

● Predicted diseases based on symptoms and helped patients take an appointment and medical treatment from nearby doctors. Hospital Management System

● Created a database system to maintain records of doctors, patients, prescription, diagnosis, and medicines.

● Designed Entity Relationship diagram(ERD) and relational schema in MySQL to store, manage and access data efficiently. SKILLS

● Programming languages – JavaScript, ReactJS, NodeJS, Python, R, SQL, MySQL, JAVA

● Tools/Software – MSSQL, Tableau, Android Studio, Dip Trace

● Other Skills – Database Design, Data Visualization, Requirements Gathering, Software Design LEADERSHIP EXPERIENCE

● Graduate Teaching Assistant – Responsible for supervising, training, and managing Undergraduate Teaching Assistants and leading a team of 5 to manage and teach 100+ students in practical sessions of the INST 123 class.

● Captain of professional Cricket team of University of Maryland – Leading Cricket team of University of Maryland at regional and state level Cricket tournaments and participating in life skills sessions that focus on effective team leadership, team player mentality, and time-stress management.

Contact this candidate