University of Central Oklahoma July 2020
Master of Science in Business Analytics Edmond, OK Savitribai Phule Pune University June 2017
Bachelor of Engineering in Computer Science Pune, India TECHNICAL STRENGTHS
Computer Skills Python programming, T-SQL, SSIS, SSAS, Tableau, Power BI, SAS Enterprise Miner, SAS Studio, SPSS, Microsoft O ce, MSSQL, PostgreSQL. Interpersonal Skills Accuracy, Analytical Skills, Communication Skills, Critical Thinking, Detail-Oriented, Multitasking, Problem solving, Teamwork, Time Management. PROJECTS
Restaurant Reviews https://github.com/agarwalsahil2013/RR.git Implemented methods to clean the text containing special characters and URL. Further used nltk libraries to check words and spelling in each sentence. Finally, I created a Bag of Model to apply Naive Bayes, Decision Tree & Random Forest to check Misclassi cation rate. Bike Sharing Demand https://github.com/agarwalsahil2013/BSD.git Removed irrelevant columns, imputed missing values, checked multi-collinearity & auto-correlations between the variables. Applied regression algorithms to minimize the root mean square error value. Achieved root mean square log error (rmsle) 0.3561 which lies in top 1% of the Kaggle competition. Fueldup Consumer Behavior https://github.com/agarwalsahil2013/FCB.git Cleaned the dataset i.e. splitting, tiding, replacing & imputing data. Explored the dataset to analyze patterns and trends. Tools used are Python, Tableau & Excel (Pivot Table). Vehicle loan & Amount of money sanctioned https://github.com/agarwalsahil2013/VL-AMS.git Vehicle loan approval and how much amount needs to approve to the borrower? Performed Deep Learning
& Machine Learning Classi cation Algorithms to achieve high accuracy. Moreover, Dimensionality re- duction techniques implemented to increase e ciency. AdventureWorks Employee https://github.com/agarwalsahil2013/AWEBA.git Created a database of the company’s employees using 1NF, 2NF and 3NF. Uploaded the database and ex- tracted required tables to analyze employee’s performance using stored procedures, temporary tables, aggregate functions sub-nested queries.Data exported in Excel to visualize using Pivot Table. WORK EXPERIENCE
Data Associate April 2019 - Present
Extracted data from Blumen-Bot and Qualtrics into MS Excel, implemented advanced functionalities like VLOOKUP, Pivot Table, and macros to perform data analysis in making recommendations.
Assisted in gather data from the student database and putting data into a format for management reporting.
Responsible for auditing all data reports for accuracy before presenting them to management.
Implemented SQL queries using joins and sub-queries to update our database. Assistant Data Manager - Internship Sept 2017 - Jan 2018 Hero MotoCorp
Used predictive analysis to segment di erent customers according to their two-wheeler interest.
Saved the company over $2500 on marketing by developing a strategy from the data..
Assist in the development and improvement of data collection, retrieval, and submission processes.