RUTVIK BHOPATRAO

addvwa@r.postjobfree.com +1-857-***-**** https://www.linkedin.com/in/rutvikbhopatrao Open for Relocation Immediate Availability

Data cruncher with a hybrid of Statistics, Programming and Business looking to work for a Technology-driven company SKILLS

Languages: SQL, R, Python 2.7/3.6, Scala, DAX, VBA, C, C++, Advanced Java Tools/BI: MS Excel, Jupyter Notebook, SAS, Tableau, Looker, DOMO, PowerBI, Salesforce, Visio, Minitab, IBM Watson Studio Databases/ETL/Integration: MySQL, SQL Server, IBM Netezza, Oracle, Spark, MongoDB, PostgreSQL, SSIS, SSRS, Alluxio, Alteryx Analytical techniques: Regression, Classification, Clustering, Forecasting, Neural Networks, PCA, EDA, Databricks, Spark ML Libraries: Pandas, NumPy, SciPy, sklearn, Seaborn, Tensorflow, Keras, Matplotlib, ggplot2, tidyr, dplyr Cloud: AWS EC2, AWS S3, AWS Redshift, AWS Quicksight, AWS EMR, AWS DynamoDB, GCP BigQuery, GCP CloudSQL EXPERIENCE

Data Analyst Consultant at Codersdata LLC, Boston, United States 01/2020 – 04/2020

• Designed and maintained data systems and SQL databases, fixing coding errors and other data-related problems

• Prepared reports through Excel, Tableau that effectively communicate trends, patterns, and predictions using relevant data Data Scientist Co-op at State Street Corporation, Boston, United States 07/2018 – 12/2018

• Analyzed Tableau dashboards to present to 18-person panel of application teams to ensure queries were optimized by 30%

• Improved 30+ Python and SQL scripts for data cleaning and feature engineering used by the team

• Predicted client behavior for liquidation risks based on fund transaction data by yielding an average score of 0.86

• ETL Design and Implementation using Spark, Hive for on-prem databases.

• Implemented Statistical, ML techniques on Netezza and Oracle DB data sources to help build regression models

• Documented SOPs and benchmarked it with AWS tools to assist in effective decision making for cloud migration Operation Coordinator at R. B. Auto Consultancy, India 04/2017 – 08/2017

• Administered family business firm for issuing registration and taxation certificates for around 50 clients from RTO

• Initiated development of a database of more than 700 vehicles for computing insurances and taxes Program Analyst at Cognizant Technology Solutions India Private Ltd, India 07/2016 – 03/2017

• Facilitated support base work of LexisNexis company database in the Corporate Java and AVM Business Unit Team

• Troubleshooted application related problems using JAVA increasing its reliability by 28% EDUCATION

Master of Science in Industrial Engineering (Data Analytics spec.) 09/2017 – 05/2019 Northeastern University, Boston, United States

Relevant Courses: Data Mining, Database Management Design, Statistical methods, Neural Networks & Deep Learning, Data Science Bachelor of Engineering in Mechanical Engineering 08/2012 – 06/2016 MIT College of Engineering, Pune, India

ACADEMIC PROJECTS

Bankruptcy Prediction model using Neural Networks (Spring '19) Examined bankruptcy data from UCI repository for Polish companies with 93% prediction accuracy model for finding risk of bankruptcy Sentiment Analysis of Spam SMS messages (Fall ’18) Devised a prediction model with 96% score with help of NLP library for categorizing a SMS as Spam or Ham Visualization of UK Bank Customer data (Fall ’18)

Showcased a Tableau visualization for customer segregation for UK Bank Customer dataset and further analyzed dashboard Logistic Regression and Goodness of fit test on Summer Olympics data (Summer ‘18) Built a 55% accuracy score regression model and whether number of gold medals won by USA follow Poisson distribution Car Rental Database Management System (Spring ‘18) Created a user-friendly full-fledged database in MYSQL workbench for car rental business Predictive analysis of Airline Delays (Spring ‘18) Assessed DOT 1.9Mn airline records, preprocessed data and formed prediction model with 78% accuracy in R programming Statistical analysis of parameters for delays of MBTA (Fall ‘17) Investigated data obtained from MBTA website in Excel, Minitab and formulated various distribution plots for delays CERTIFICATIONS

IBM Data Science Professional Certificate, Tableau Analyst, AWS Data Analytics Fundamentals Udemy: Machine Learning A-Z: Python and R, Tableau 10, Microsoft Power BI, PowerQuery and Powerpivot, Python for Data Analysis LinkedIn: Advanced SQL for Data Scientists, Data Science Healthcare Analytics, SQL Tips, Tricks & Techniques, Excel Data Visualization