Arpit Shah

Research Analyst

Indiana University Bloomington•  June 2020 - Present

● Analyzed the effect of COVID on Opioid consumption by developing stored procedures and window functions in Snowflake. ● Developed web scraping scripts to collect data to study the spread of loans in the US and analyzed it using Tableau reports. ● Preprocessed and analyzed mobile data during COVID to understand people’s movement and their effect on businesses.

Machine Learning - Software Engineer Intern

Pocket Coach Corporation•  June 2019 - December 2019

● Designed and developed a recommendation system for complementary recipes and also discovering new food pairings. ● Developed a classifier to predict the meal type of a recipe and also improved its F1-score from 0.53 to approx 0.77. ● Improved model accuracy to 89% for prediction of 10 tags of recipes to recommend them for users customized diet. ● Built a REST API to fetch various attributes of recipes to better describe a recipe; after collaborating with nutritionists.

Database Developer

Indiana University Bloomington•  January 2019 - April 2019

● Analyzed data to identify several indices from Census and other demographic databases, that factor into disaster resilience. ● Developed stored procedures to extract data and visualize it on a Tableau dashboard for those indices.

Associate Software Engineer

Gep Worldwide•  June 2017 - June 2018

● Improved user accessibility and data retrieval process for the website using APIs with Middleware and stored procedures. ● Developed a bulk utility system to set up data through Excel integrating Business validations reducing man-hours by 10%. ● Assisted in simplification of build to remove the dependency of modules and reduce downtime, increasing efficiency by 15%. ● Integrated automatic email service to notify users on the completion of certain actions. ● Enhanced understandability and readability of the document by developing an ‘Export to PDF’ feature using HandleBar.js. ● Refactored legacy code to remove inefficiencies from the product to improve scalability and maintainability. ● Performed unit and regression testing of the features using NUnit for backend and Selenium for frontend. ● Collaborated with other teams to integrate the required functionalities into the product. ● Actively participated in Agile/Scrum ceremonies for sprint planning, brainstorming, knowledge sharing, and retrospection.