Resume
SUMMARY
Shelly Agrawal
Data Science and Analytics professional with 3+ years of experience in Data Modeling and Visualization techniques with strong
analytical skills and proficient knowledge in SQL, Excel, Hadoop, Python, Web Analytics, R, Tableau and Linear Programming
EDUCATION University of Connecticut, School of Business | Hartford, CT Aug 2019 - Dec 2020
Master of Science (M.S.) , Business Analytics and Project Management
Coursework: SQL, Predictive Modeling, Statistics, Data Mining, Big Data (Hadoop), Web Analytics , Data Visualization
Rabindranath Tagore University (Formally AISECT University) |Indore, India Jan 2018 - Feb 2019
Post Graduate Diploma in Computer Application
Devi Ahilya University, International Institute of Professional Studies |Indor e, India Aug 2013 - May 2016
Bachelor�s in Computer Applications
PROFESSIONAL EXPERIENCE TESLA | Business System Analyst Intern | Fremont, CA Aug 2020 � Dec 2020
Linear Programm ing Model for Optimization Process
� Developed Linear programming model using Analytical solver s to optimize # of parts and shipment counts for Truck loading
Improvements , reducing shipping and inventory cost for various supplier -warehouse routes by ~4M
� Leveraged SQL server management studio to map database schema and Tableau dashboards for improvising inventory, building
functional designs, data dictionary and documentation of alloc ation solver for Material Requirement Planning
Life IO | Analytics Consultant | Princeton, NJ Aug 2020 � Dec 2020
� Build ML model to learn current user behavior and increase percentage of registered users on platform by segment ing
customers to various attributes using Python
� Performed Sentiment analysis on email subject line by keyword recommendations to improve email marketing campaigns
Momentum | Analytics Consultant | Hartford, CT Oct 2019 - Aug 2020
� Executed Market research and Competitive analysis to find market trends and provide business insights using data gathered
from surveys improving user retention rate on application by 20% and raising number of subscriptions by 12%
Alliant Infotech |Data Analyst| Indore, India Jul 2016 - May 2019
Sales Forecasting using Classification Models
� Performed Customer segmentation using K-means clustering model to anticipate purchas ing behavior of new and returning
customers for an e -commerce client improving strategies for advertisement campaigns and item recommendations
Customer Engagement Improvements using Website Analysis
� Boosted Web traffic by performing A/B testing and building Go ogle analytics reports deploying various acquisition, retention
and marketing metrics resulting in 11% increase in client -base , 8% increment in conversion rate
Sales and Inventory Management Tableau Dashboards
� Designed Sales Monitoring dashboard using Oracle SQL (ETL Process) and MS Excel tools to find relevant KPI�s like profit
margins/ revenue by sales reps, up -sell & cross -sell rates enhancing Sales performance by ~12% for Retail client
� Build Product availability dashboard using OTIF deliveries , OOS rates metrics to identify gaps in Inventory levels reduc ing lost
sales by ~20% for FMCG client
ACADEMIC PROJECTS
Bank Marketing Campaign | Term Deposit Prediction | Predictive Modeling | JMP | MS Excel
� Designed and analyzed bank dataset using machine learning techniques such as logistic regression, tree -based methods and neural
net works to predict term deposits subscriptions by customers in order to raise banking revenue
Facebook Ad Campaign Performance Analysis | Web Analytics | R | Python
� Build Interaction based Linear regression models to understand impact of advertisement on audience profiles using attributes like
total conversions, Ad budget, interest groups, enquiry details for increasing brand awareness and revenue of Cruise line company
Hotel Management System | Data Management and Business Process Modelin g | MS Visio | Oracle SQL
� Derived business use cases for management of resources, regions of improvement and profitability of hotel by running complex
SQL queries in Oracle database and created swim lane for AS -IS, TO -BE models with ERD�s describing business scenario
Popularity of Reddit Comments Analysis| Text Processing and Mining | R | Sentiment Analysis using Python
� Performed analysis to predict popularity of �AskReddit� comments using feature engineering like readability, data visualiz ations
and modeling techniques for prediction utilizing Python packages, R Studio and its various core packages (CRAN)
SKILLS Languages and Tools: Python (Pandas, NumPy, matplotlib, sklearn), R, SAS, JMP -14, Tableau, Advanced MS Excel (V/H -Lookup, pivot
tables, macros , solver ), Power BI, Jupyter Notebook, GitHub, Google Analytics , Analytical So lvers
Databases: Oracle SQL, MySQL, Microsoft SQL Server Management Studio , MS Access, Hadoop (AWS), Linux
Analytics Skills: Data Mining, Data Visualization, Linear & Logistic Regression, Statistical Analysis, Hypothesis Testing,
Recommender Systems, A/B t esting, Marketing & Customer Analytics, Spreadsheet Engineering, Text Mining, ML Algorithms
Project Management : Microsoft Project, MS Visio, Risk & Cost Management, FMEA, Gantt Chart, Swim lane, Microsoft Office Suite
Product Management : Agile Methodologies, Product Life cycle, PRD�s, Process flows, JIRA, Wireframing, Strategy development
SUMMARY
Shelly Agrawal
Data Science and Analytics professional with 3+ years of experience in Data Modeling and Visualization techniques with strong
analytical skills and proficient knowledge in SQL, Excel, Hadoop, Python, Web Analytics, R, Tableau and Linear Programming
EDUCATION University of Connecticut, School of Business | Hartford, CT Aug 2019 - Dec 2020
Master of Science (M.S.) , Business Analytics and Project Management
Coursework: SQL, Predictive Modeling, Statistics, Data Mining, Big Data (Hadoop), Web Analytics , Data Visualization
Rabindranath Tagore University (Formally AISECT University) |Indore, India Jan 2018 - Feb 2019
Post Graduate Diploma in Computer Application
Devi Ahilya University, International Institute of Professional Studies |Indor e, India Aug 2013 - May 2016
Bachelor�s in Computer Applications
PROFESSIONAL EXPERIENCE TESLA | Business System Analyst Intern | Fremont, CA Aug 2020 � Dec 2020
Linear Programm ing Model for Optimization Process
� Developed Linear programming model using Analytical solver s to optimize # of parts and shipment counts for Truck loading
Improvements , reducing shipping and inventory cost for various supplier -warehouse routes by ~4M
� Leveraged SQL server management studio to map database schema and Tableau dashboards for improvising inventory, building
functional designs, data dictionary and documentation of alloc ation solver for Material Requirement Planning
Life IO | Analytics Consultant | Princeton, NJ Aug 2020 � Dec 2020
� Build ML model to learn current user behavior and increase percentage of registered users on platform by segment ing
customers to various attributes using Python
� Performed Sentiment analysis on email subject line by keyword recommendations to improve email marketing campaigns
Momentum | Analytics Consultant | Hartford, CT Oct 2019 - Aug 2020
� Executed Market research and Competitive analysis to find market trends and provide business insights using data gathered
from surveys improving user retention rate on application by 20% and raising number of subscriptions by 12%
Alliant Infotech |Data Analyst| Indore, India Jul 2016 - May 2019
Sales Forecasting using Classification Models
� Performed Customer segmentation using K-means clustering model to anticipate purchas ing behavior of new and returning
customers for an e -commerce client improving strategies for advertisement campaigns and item recommendations
Customer Engagement Improvements using Website Analysis
� Boosted Web traffic by performing A/B testing and building Go ogle analytics reports deploying various acquisition, retention
and marketing metrics resulting in 11% increase in client -base , 8% increment in conversion rate
Sales and Inventory Management Tableau Dashboards
� Designed Sales Monitoring dashboard using Oracle SQL (ETL Process) and MS Excel tools to find relevant KPI�s like profit
margins/ revenue by sales reps, up -sell & cross -sell rates enhancing Sales performance by ~12% for Retail client
� Build Product availability dashboard using OTIF deliveries , OOS rates metrics to identify gaps in Inventory levels reduc ing lost
sales by ~20% for FMCG client
ACADEMIC PROJECTS
Bank Marketing Campaign | Term Deposit Prediction | Predictive Modeling | JMP | MS Excel
� Designed and analyzed bank dataset using machine learning techniques such as logistic regression, tree -based methods and neural
net works to predict term deposits subscriptions by customers in order to raise banking revenue
Facebook Ad Campaign Performance Analysis | Web Analytics | R | Python
� Build Interaction based Linear regression models to understand impact of advertisement on audience profiles using attributes like
total conversions, Ad budget, interest groups, enquiry details for increasing brand awareness and revenue of Cruise line company
Hotel Management System | Data Management and Business Process Modelin g | MS Visio | Oracle SQL
� Derived business use cases for management of resources, regions of improvement and profitability of hotel by running complex
SQL queries in Oracle database and created swim lane for AS -IS, TO -BE models with ERD�s describing business scenario
Popularity of Reddit Comments Analysis| Text Processing and Mining | R | Sentiment Analysis using Python
� Performed analysis to predict popularity of �AskReddit� comments using feature engineering like readability, data visualiz ations
and modeling techniques for prediction utilizing Python packages, R Studio and its various core packages (CRAN)
SKILLS Languages and Tools: Python (Pandas, NumPy, matplotlib, sklearn), R, SAS, JMP -14, Tableau, Advanced MS Excel (V/H -Lookup, pivot
tables, macros , solver ), Power BI, Jupyter Notebook, GitHub, Google Analytics , Analytical So lvers
Databases: Oracle SQL, MySQL, Microsoft SQL Server Management Studio , MS Access, Hadoop (AWS), Linux
Analytics Skills: Data Mining, Data Visualization, Linear & Logistic Regression, Statistical Analysis, Hypothesis Testing,
Recommender Systems, A/B t esting, Marketing & Customer Analytics, Spreadsheet Engineering, Text Mining, ML Algorithms
Project Management : Microsoft Project, MS Visio, Risk & Cost Management, FMEA, Gantt Chart, Swim lane, Microsoft Office Suite
Product Management : Agile Methodologies, Product Life cycle, PRD�s, Process flows, JIRA, Wireframing, Strategy development