Ankit Agrawal www.linkedin.com/in/ankitagrawal*** 1 Frederick Street, Hartford, CT 06105 860-***-**** *****.*******@*****.***
EDUCATION:
University of Connecticut School of Business Hartford, CT
Master of Science, Business Analytics and Project Management, GPA 3.91/4 December 2016
National Institute of Technology Jamshedpur, India
Bachelor of Technology, Metallurgical and Materials Engineering, CGPA- 8.4/10 May 2012
ACADEMIC PROJECTS:
Off Airport Parking System (LAZ Parking), Capstone Project September 2016- December 2016
Derived actionable insights from parking data to suggest measures to LAZ Parking to improve market share
Defined data-driven solution for the business problem and performed sentiment analysis of the customer reviews
Visualized word clouds and predicted polarity using Naïve Bayesian, SVM in R to suggest areas for improvements
Airbnb user interface design August 2016-September 2016
Designed user interface based on distance and cost using Googlevis, Maps and Shiny packages in R
Generated infographics to update directly on the website from data set using animation package Magick
Developed comprehensive data visualizations to illustrate complex ideas to various stakeholders
Amazon Product Review May 2016-July 2016
Designed new algorithm to sort product based on popularity using SAS
Segregated data into clusters and identified trends in product sales using time series modeling
Analyzed sentiment data (customer feedback) using text mining methods to enhance model
Developed ARIMA model to forecast peak periods to improve inventory management and sales strategy
Risk Classification for Prudential January 2016-May 2016
Classified the risk associated with the customers based on their profile and health history into eight categories
Performed K- Means Clustering, Principal Component Analysis, correlation and variance analysis, missing value treatment, multivariate analysis, outlier analysis, scaling, transformation, recoding etc. as part of data preparation
Used Ordinal Logistic regression, Neural Network and Bootstrap forest to build the predictive model
Social Network Analysis January 2016-May 2016
Network Cluster Analysis using spreadsheet modeling to determine the density of people in the network
Developed an optimization model to influence the maximum number of people in the network using fewest number of promotional offers
WORK EXPERIENCE:
JSW Steel Limited Bellary, India
Junior Manager June 2012 – December 2015
Analyzed production parameters and modified standard operating procedures to increase efficiency of the six-million-tonnes steel melt shop
Commissioned mathematical model to optimize production cost which led to saving of 10 million INR (USD 150000)
Reduced process time from 49 mins to 46 mins which led to saving of 96 million INR (USD 1.4 Million) in 8 months
TECHNICAL SKILLS:
Analytical tools: SQL, SAS EG, SAS EM, SAS JMP, SAS Base, Tableau, Hadoop, Apache Hive, Spark, Scala, R-studio
Programming: R, SAS, Python
Techniques: Predictive modeling, Regression, Data mining, Classification, Time series forecasting, Clustering, Segmentation, Ad-words Optimization, Process modeling, Decision modeling, Visualization, Marketing
ADDITIONAL EXPERIENCE:
Student Maintenance Assistant, UConn Building Services, Storrs CT May 2016-August 2016
Volunteer, MSBAPM Fall 2016 Orientation August 2016
Joint Secretary, Society for metallurgical Engineering, NIT Jamshedpur August 2011 - May 2012