Shelly Agrawal

Hartford, CT, USA


Last updated October 9, 2020

Who I Am  

Languages

Hindi
English

What I Do  

Professional Experience

Alliant Infotech

Data Analyst

Jul 2016 - Dec 2017
1.Sales Forecasting using Classification Models * Performed customer segmentation by developing K-means clustering models that allows to anticipate purchase made by new and returning customers for an e-commerce company improving strategies for advertisement campaigns 2.Website Analysis using Google Analytics * Boosted web traffic by providing quality score, google analytics reports and recommendations to client resulting in 11% increase in client-base, 18% reduction in bounce rate of homepage and 8% improvement in transaction conversion rate 3.Sales Forecasting Tableau Dashboarding using MS Excel * Used MS Excel tools to find relevant KPI’s like profit margins/ revenue by sales reps, incremental sales, up-sell & cross-sell rates to build sales monitoring tableau dashboards increasing quality and performance of sales for retail business 4.SQL Scripting for Inventory Management Dashboarding * Extracted data by running SQL queries (ETL Process) and build product availability tableau dashboards for FMCG client helping identify gaps in inventory levels, track DIFOT deliveries and maintenance of OOS products to reduce lost sales

SAS Communications

Analytics Consultant

2020 - Present
1.Market Research Analysis for Mentorship App  Executed competitive analysis in order to find market trends and draw business strategies using data gathered from surveys in schools and social media platforms raising number of subscriptions by 12%  Implemented classification modeling techniques to predict student behavior and provide business insights using age, gender, demographics as parameters improving user retention rate on application by 20%

What I Stand For  

Volunteer Experience

National Service Scheme(NSS, India)

Indore, India

Aug 2013 - May 2016
It is an Indian government-sponsored public service program wherein the program aims to improve student’s personality through community service

Education  

School

Devi Ahilya University of Indore

Bachelor’s, Computer Application

2013 - 2016

Master of Science, Business Analytics and Project Management

2019 - 2020
+1 more school