Prathamesh Bawaskar

1-551-***-**** ** Poplar St, Jersey City, NJ https://www.linkedin.com/in/pbawaskar/ adjddo@r.postjobfree.com EDUCATION:

MASTER OF SCIENCE IN INFORMATION SYSTEMS (Dec 2020) Stevens Institute of Technology, Hoboken, NJ GPA: 3.69 /4.00 BACHELOR OF ENGINEERING, ELECTRONICS ENGINEERING (Jun 2018) University of Mumbai, Mumbai, Maharashtra

SKILLS:

PROGRAMMING: Python (Matplotlib, Seaborn, Plotly, Scikit-learn, Numpy, Pandas, Scrapy), R(ggplot2, Caret), SQL(MSSQL, PostgreSQL)

BI/ETL TOOLS: Tableau, RStudio, Power BI, SSIS (SQL Server Integration Services),SSRS (SQL Server Reporting Services) MODELLING: Supervised Learning (Linear and Logistic Regression, Classification, LDA, ANN, CNN, Decision Trees, Random Forest), Unsupervised Learning (K-Means Clustering, Hierarchical Clustering) CORE COMPETENCIES: Business & Data Analysis, ETL Development, Data Modeling, Data Mining, Web Mining, Multivariate Data Analysis, Data Analytics & Machine Learning, Applied Analytics AWS: S3, EC2, Redshift

EXPERIENCE:

DATA ANALYST INTERN Consolidated Engineering Enterprises Mumbai, Maharashtra (Jul 2018)

• Pre-processed and cleaned unstructured data of different users by extracting data from varied data sources

• Effectively executed relational database concepts like joins, indexes, group by, order by, referential integrity

• Leveraged SSIS (ETL) to perform cleansing and transformation method for data consistency and data manipulation and developed interactive Tableau Dashboards to summarize data results to inform business insights GRADUATE ASSISTANT Stevens Institute of Technology Hoboken, NJ (Jan 2019)

• Audited library financial data sales, deposits and withdrawal utilizing EXCEL (VLOOKUP, HLOOKUP, Macros)

• Developed SQL queries for database design and maintenance for Interlibrary Loan Department

• Administered access to vital research tools and support, including but not limited to journal and eBook databases, research guides, technology resources, borrowing and lending services, and archives WORKSHOP:

KPMG Virtual Internship by InsideSherpa (Jul 2020)

• Identified quality issues in provided dataset provided by KPMG’s client using Advanced Excel Formulas

• Interpreted and analyzed useful customer insights to be used in tailoring marketing strategies towards a specified target and constructed dashboards succinctly visualizing data trends and recommendations using Tableau

• Implemented RFM model identifying and targeting high value customers based on demographics and attributes ACADEMIC PROJECTS:

CUSTOMER RETENTION SYSTEM Python (Dec 2019)

• Studied dataset from Kaggle to understand customers that are likely to leave an organization. Extracting

• characteristics from loyal and disloyal customers

• Preprocessed the data to delete missing values, removed unnecessary column data, used one hot encoding, and applied various algorithms to choose the model with maximum accuracy

• Trained on various methodologies like Naive Bayes, KNN, CART, C50, Random Forest, ANN. Random forest was able to clock maximum prediction accuracy of 86.16%

CRIMES IN CHICAGO DATA ANALYSIS Python, ML (Dec 2019)

• Examined a dataset which consisted of crime occurring in Chicago between 2012 - 2017 and performed data cleaning, data exploration and created interactive visualization using pandas, matplotlib, seaborn and cufflinks libraries from python to view the most frequently occurring crimes and the location where it took place

• Identified theft, battery, criminal damage, and narcotics as the most occurred crimes (65.7% of all the crimes reported) and the most common locations which are street, sidewalks, and residences SENTIMENT ANALYSIS Tableau (Dec 2019)

• Cleaned and normalized the data using excel formulae and summarized KPI using pivot tables, analyzed user comments data using Tableau for sentiment analysis and leveraged Tableau

• Leveraged statistical result for making better software upgrade decisions and created interactive dashboards on Tableau

CERTIFICATIONS:

• Tableau Analyst Tableau (Jul 2020)

• Data Analytics Consulting Virtual Internship InsideSherpa (Sep 2020)

• SQL fundamentals SoloLearn (Dec 2019)

OPT eligible Feb 2021