APOORVA PATIL

Jersey City, NJ adl5oy@r.postjobfree.com +1-201-***-**** LinkedIn

EDUCATION

Masters Information Systems, Stevens Institute of Technology, USA – GPA: 3.92/4 May 2021 Bachelor of Engineering in Information Technology, University of Mumbai, India – GPA: 3.5/4 May 2019 Diploma in Computer Engineering, University of Mumbai, India – GPA: 3.8/4 May 2016 SKILLS

Programming Languages: SQL, R, Python (NumPy, Matplotlib, TensorFlow, Pandas, SciPy, Scikit-Learn, NLTK, ggplot2) IDE & Tools: Visual Studio, Git, Spyder, PyCharm, Jupyter Notebook, R Studio Cloud Technologies: AWS- S3, RDS, EC2, Sagemaker, QuickSight; Google DataStore/ Firestore, Snowflake BI/Analytics Tools: MS Excel, Tableau, Google Analytics, Power BI, Qlik Sense, MS VBA, Data Studio, BigQuery Database: MS Access, MySQL, Oracle, PostgreSQL, SQLite, PostgreSQL Core Competencies: Data Analysis, Data Visualization, Data Modelling, Agile Methodology, Business Decision Making, Machine Learning, Business Forecasting, Data Management, Ad hoc Reporting & Analysis Certifications: Data Analysis and Machine Learning (Stevens Institute of Technology), Tableau Desktop Specialist

(Tableau, March 2021), AWS Cloud Practitioner (AWS, April 2021) Publication: Box Office Movie Prediction System – International Journal of Research in Engineering, Science and Management (Paper)

PROFESSIONAL EXPERIENCE

Entuber LLC United States August 2020 – Present

Junior Data Analyst Intern (ChatBot)

● Automated 75% of CSR tasks, by developing AI Customer Service Chatbot for Energy & Utility industry

● Built ETL pipeline to migrated data in BigQuery & created DataMarts for multiple teams

● Executed complex SQL queries on data and performed data analysis on the chatbot data

● Devised python scripts to identify KPIs that helped business to better understand customer journey

● Constructed insightful omni channel dashboard in Tableau to monitor KPIs that offers in-depth analytics with extensive live reporting

● Improved customer experience, lowered cost and increased the containment rate by 60% Open My Network LLC United States May 2019 – July 2020 Business Intelligence Intern

● Performed complex CRUD operations on SQL database consisting 50 datasets from 20 schools in NYC

● Generated weekly Ad hoc reports and presented the actionable insights to principals & departmental staff

● Performed Ad hoc data analysis in Python and determined operational and educational KPIs

● Analyzed trends in student subject preferences and tracked academic performance against organizational and governmental threshold

PROJECTS

Restaurant Prediction Machine Learning, RStudio January 2021 – April 2021

● Prepared data for analysis operating R packages such as tm, word-cloud for text processing and visualization

● Implemented GridSearchCV to determine Hyperparameters for XGBoost, Naïve Bayes, KKN model

● Created interactive flex dashboard in R utilizing ggplot, plotly, dplyr and visualized restaurant datapoints University Placement Analysis Machine Learning, Python, EDA January 2020 – April 2020

● Extracted data from University Placement database and preprocessed using numpy, pandas, sklearn

● Applied statistical methods and performed EDA to determine features that affects student’s placements

● Engineered Logistic Regression & Random Forest algorithm to predict students placed with 90% accuracy NBA players data analysis MS Excel, Tableau September 2019 – December 2019

● Imported data from text files, databases using automatic outlining, advanced filters & database functions

● Performed data manipulation, transformation, cleansing and execution of macros to automate data points

● Built impactful and interactive data visualization in Tableau that projected athlete performance Box Office Movie Recommender System Machine Learning, Python August 2018 – May 2019

● Built a movie success recommendation system to predict success of movie before its release

● Extracted tweets, cleaned, and performed Sentiment Analysis utilizing Text Blob, NLTK (tokenize), Sklearn

● Initiated the SVM algorithm on pre-realized features and took Lexicon Based Approach for calculating polarity ACTIVITIES

Vice President of Information Technology Student Association University of Mumbai August 2018 – May 2019 Devised executive plan for events, supervised the team of 40 people and organized technical events for university