Data Analyst

Aakash Rami

1-551-***-**** github.com/aakashrm *****@*******.*** linkedin.com/in/aakash-rami

EDUCATION

Stevens Institute of Technology, Hoboken, NJ May 2021 Master of Science in Information Systems (GPA: 3.8/4.0) Relevant Courses: Knowledge Discovery & Data Mining, Web Mining, Applied Analytics, Digital Innovation, Project Management Fundamentals, IT Strategy

Dharmsinh Desai University, Nadiad, Gujarat May 2018 Bachelor of Technology in Information Technology (GPA: 3.2/4.0) SKILLS

Programming: C, C++, HTML, CSS, Java, Python, R Programming Database: SQL, MySQL

Analytics Software: Excel, Tableau

Technologies: R Studio, Pandas, NumPy, Matplotlib, Seaborn, plotly, scikit-learn Anaconda, Signavio, Simul8, MS Excel, MS PowerPoint, Android Studio, Visual Studio Knowledge Area: Data Analysis, Data Manipulation & Visualization, Data Scraping, Machine Learning Certification: Introduction to Data Science by IBM, Data Analysis in Python, Logistic Regression in R EXPERIENCE

Data Analyst Intern, Mangalam Information Technology Pvt. Ltd., India Sep 2018 – May 2019

• Optimized SQL query processing to enhance data retrieval and reduce processing time by 30%

• Delivered end to end analytical support to identify gaps and recommended solutions to application issues

• Gathered targeted client’s details them from different sources and merged them in Excel spreadsheets to create centralized data platform for easy access and data analysis using Tableau

• Conducted predictive analysis on dataset using classifier algorithms to forecast application performance using Python and achieved accuracy of about 76%

• Generated weekly reports and created dashboards using Tableau to make projections of performance and sales ACADEMIC PROJECTS

Stevens Institute of Technology, Hoboken, NJ

Employee Attrition Data Classification (R, Excel) Jan 2020 – May 2020

• Developed classification models on Employee Attrition data to predict potential of employees leaving the company

• Generated correlation matrix and feature importance graph to forecast influence of various features on target attribute

• Performed EDA and feature selection algorithms for deciding important features from data set and imputed missing values using suitable techniques

• Applied Nonlinear Classification Models like KNN, Decision tree, Naïve Bayes, Random Forest and ANN to predict whether employees will get Terminated or not and achieved accuracy of 70.02% Data Analysis for Player Behavior at EVE Online (R, Excel, Tableau) Aug 2019 – Dec 2019

• Performed predictive analysis for massive multiplayer game with over 3 million user data to recommend changes for increasing player base by 36%

• Computed Correlation and Sobel tests to analyze relationship of ‘social’ and ‘affiliation’ variable among other outcome variables

• Created interactive dashboards in Tableau and incorporated data visualization of various trending events from online traffic

Sentiment Analysis on Amazon Fine Foods (Python, Excel) Aug 2019 – Dec 2019

• Analyzed half a million reviews and categorized into positive, negative and neutral reviews using count plot and generated heatmap

• Created Word cloud to analyze word pattern and trained Decision Tree classifiers to predict polarity of use reviews

• Built predictive models like Logistic regression, Naïve Bayes, Random Forest to predict customer satisfaction with highest accuracy of 87.42%

ACTIVITIES

• Vice-President, Graduate Student Council at Stevens Institute of Technology

• Student Mentor as a part of master’s Peer Mentor Program

Contact this candidate