Abhishek Shetty-| +1-(857)- | www.linkedin.com/in/abhishetty | github.com/shettyabhi
EDUCATION:
MS Data Analytics Engineering, Northeastern University, Boston, MA, (May 2021)
Courses: Machine Learning, Data Warehousing and Business Intelligence, Data Mining, Computation and
Visualization, Probability and Statistics, Project Management, Operations Research.
Bachelor of Technology, Chemical Engineering, Manipal Institute of Technology, India, (Jun 2017)
Publications: Development of Iron Doped Manganese oxide (Mn2-xFexO3) Catalysts for Soot Oxidation Applications:
IJAER Journal
SKILLS:
• Languages: Python, R, C/C++, SQL
• Databases: SQL Server, MySQL
• Software/Tools: AWS, Tableau, Jupyter, Git, Matlab, Talend, Power BI, Visual Studio, MS Office Suite
• Libraries: numPy, pandas, tensorflow, scikit-learn, Seaborn, caret, rpart, dplyr, ggplot2, nnet
WORK EXPERIENCE:
Anchor Refractories Pvt Ltd
Mumbai, India
Junior Engineer
Jul’17-Jul’19
• Performed quantitative analysis on chemical products to recommend effective combinations.
• Conducted statistical analysis using SQL, Python, R Programming and Excel to determine demand patterns
and product mixes; helped increase the company turn-over by 8%.
PROJECTS:
IMDB Movie Analysis (Python, SSIS, SSAS, Talend, Tableau) | View Project
• Designed an analytical system to study the factors which make a movie more successful than others.
− Employed Talend, SSIS, SSAS, SQL Server to construct an enterprise Data Warehouse and utilised dimensional
modelling (star schema) for querying, gathering, transforming, validating data from different data sources and
documenting workflows.
− Dashboards and visualisations were created in Tableau to support the analysis.
MBTA Database (SQL, Tableau) | View Project
• Created and maintained a relational database for all the transit services offered by MBTA to provide a single source
of repository for creating user interfaces/mobile apps.
− Led a team of 4 to implement the system and reduced data retrieval time with 10+ tables in 3rd normal form.
− Designed the data model using ER Studio, implemented physical model database architecture on the MBTA
services for the users, depending on factors such as cost, destination, and the services available using SQL
Server.
− Reduced the data retrieval time by developing optimized and complex SQL queries, triggers, stored procedures,
and developed Tableau dashboards to extract business insights.
Shill Bidding Prediction (Python) | View Project
• Built a system to identify the bidders resorting to Shill bidding by applying ML algorithms to eBay auction data.
− Performed Exploratory Data Analysis, data cleaning, created ML models like Logistic Regression, KNN and Deep
Neural Networks from scratch, optimized these models to obtain a prediction accuracy of > 90% for each of
the models.
Mental Health Treatment Prediction (R, Tableau) | View Project
• Built a system to help predict the need for Mental Health Treatment in the tech sector.
− Using the data from a survey, performed Exploratory Data Analysis, data cleaning, implemented Logistic
Regression, SVM, Decision Trees, Naïve Bayes to optimize the model and used grid search for better prediction
accuracy of 81% on test data. Plotted feature importance and identified impactful features.
Rainfall Prediction Model (R, R Studio) | View Project
• Developed a statistical model to predict annual rainfall for different regions in India. Performed multicollinearity
analysis, outlier detection, feature significance with A/B testing, t test, p values, stepwise selection, error analysis,
hypothesis tests.
