KHUSHAL MOHITE

*** ******* **, ******, **

adkejx@r.postjobfree.com +1-815-***-****

SUMMARY: A passionate Data Analyst with an eye for detail, possessing strong analytical skills along with multi-tasking, planning, and time management skills. A self-learner as well as a team-player with an academic background in technology as well as business and a meticulous individual holding expertise in Data Analytics, Business Analytics, Business Intelligence, Project Management, Data Management, Data Visualization, Requirements Gathering & Documentation, Machine Learning, and Statistics. EDUCATION

Northern Illinois University, DeKalb, IL, GPA: 4.0 Dec 2020 Master of Science in Management of Information Systems (Specialization in Business Analytics) University of Pune, India, GPA: 3.2 July 2018

Bachelor of Engineering in Computer Engineering

TECHNICAL SKILLS

Reporting Tools: Tableau, Microsoft Excel PowerPivot, Power BI, SSRS Database: MS SQL Server, MySQL, MongoDB, Redshift

Programming Proficiency: Python (Pandas, Scikit learn, NumPy, Matplotlib), SAS, R (dyplyr, Tidyverse, Sparklyr, ggplot2) BI Tools: SSAS, SAP NetWeaver Business Warehouse, SAP Business Object Analysis, and Query Designer Statistical Techniques: Regression, Hypothesis Testing, Moderation Analysis, Chi Square, Cluster and Factor Analysis Other Tools & Techniques: MS Office Suite, UML & Use Cases, SAP ERP, SAP S/4 Hana, Agile/Scrum development, ETL Certifications: SAP Certified Application Associate 2019, Post-Crisis Leadership Certificate – USF 2020 Publications: CrowdOp: College Finder Web Application using Query Optimization – International Journal of Advance Research and Innovative Ideas in Education, Volume-4 Issue-2, 2018 PROFESSIONAL EXPERIENCE

Graduate Teaching Assistant, Northern Illinois University, DeKalb, IL Aug 2019 – Dec 2020

• Assisted a class of 30+ students in understanding SAP WM & MM models for the course Supply Chain Systems.

• Corrected 60+ assignments & H/W each week, proctored tests, and provided grading assistance according to the university standards.

• Mentored students to easily understand and resolve issues while performing SAP case studies. Held office hours for extra support and maintained atmosphere of academic learning and advancement. Consultant, The Shelby Group, Exp. Learning Center, Schaumburg, IL Jan 2020 – May 2020

• Conducted meetings with stakeholders to determine project intent, requirements and provided updates to stakeholders on key milestones for projects. Supported with business analysis and documentation.

• Evaluated the Procurement Operations team of 12 members and performed data analysis on the data (100+ tickets) generated on the ticketing system for the services offered to clients.

• Developed graphs and charts in Tableau and Excel to communicate the insights and results to the Management team and developed KPIs to measure the profitability of the Procurement Operations team and designed strategies to increase profit.

• Identified opportunities for improvements in business processes and provided recommendations for optimization. Machine Learning Intern, Microsoft in-partnership with Verzeo, India Feb 2020 – Mar 2020

• Building a regression model to predict the cost of used cars in a dataset of 1200+ Used Cars from different cities. Prediction of the cost based on attributes like Year, Location, Miles driven, Engine, Power, and Transmission.

• Tasks included cleaning unstructured datasets, performing statistical analysis for existence of correlation, building prediction models, feature selection, and visualizing results using matplotlib. ACADEMIC PROJECTS

Give Me Some Credit- Kaggle Competition (Big Data Analytics in R) Aug 2020 – Dec 2020

• Performed cluster analysis on the credit dataset from the famous Kaggle competition to Profile Credit Borrowers based on their age, debt ratio, revolving utilization, etc., used K-means clustering algorithm to build the model in R using Spark.

• Built a linear regression model to predict monthly income of a credit borrower based on other attributes, performed Feature Engineering and Selection to increase accuracy and reduce RMSE to obtain the best model.

• Built a Logistic Regression model to predict if a borrower will seriously delinquent (default), obtained 80% accuracy. Data Analysis on Airlines Data using Python (Skytrax.com) Aug 2019 – Dec 2019

• Performed Sentiment Analysis on a data set of around 14k records of reviews of different customers about their flying experience on a particular flight, calculated and visualized polarity scores alongside other attributes to understand customer satisfaction.

• Developed a Topic model using LDA to identify and analyze 30 dominating keywords from different topics across the whole corpus and created tables, graphs, and word cloud using Tableau to communicate the results and delivered a final presentation. Northern Illinois University Catering System using BI tools Jan 2019 – Dec 2020

• Created a snowflake schema based centralized data warehouse for the University’s catering services data for sales, staff, prices, food, vendors, customers, etc.

• Accessed the DW using SSAS to perform advanced analytics and multidimensional modeling (creating data marts, cubes, analyze facts and dimensions). Used PowerPivot to create multidimensional reports and created interactive dashboards using Power BI. Web Scraping – Twitter N/W Data Analysis Jan 2019- May 2019

• Scraped live Twitter Network data for #mondaymornings that included 1500+ nodes and derived inferences by performing analysis using Python and Tableau.

• Developed ideas to promote Cafe Coffee Day (once popular but now dying cafe chain from India) to make use of the #tags to increase sales of their products and leverage opportunities to expand their customer base

Contact this candidate