Data Manager

Sharada Tyagi https://www.linkedin.com/in/sharada-tyagi-034b5961/

***** *.***** *****, **********, AZ 85255 602-***-**** *******.*****@*****.***

SUMMARY

Experienced Business Data Analytic Professional with over ten years of experience in interpreting and analyzing data and driving business solutions.

4+ years of professional experience working in the role of Business Data Analyst drawing business insights from data through complex analysis, data mining, and visualization with respect to descriptive analysis and predictive analysis by using modelling, applying mathematical theory, statistical tools, optimization techniques, algorithms and simulations to business data.

6+ years of experience as a Business Analyst/Product Owner in supporting the business and the management with their various new initiatives and software application development using both waterfall and agile methodologies.

Able to work with SQL databases and programming language like Python and statistical software packages such as R (Importing data, cleaning, tidying data, using data manipulation techniques and preparing the data for structured analysis, statistical inference, parameter estimation and visualization and reporting).

Experience in database querying languages SQL(MySQL/DB2/Oracle) and advanced MS Excel for data analysis and visualizations like Excel Charts, Excel Formulas, Pivot Charts, Excel Dashboard and Pivot Tables to help the end users and the business get a better view of the information being discussed.

Experience in developing various machine learning models pertaining to predictive modelling like Regression, Classification, and Clustering.

Working knowledge of other machine learning models like Decision trees, Random Forests, NLP (Bag of Words), Recommender Systems, Deep Learning (ANN for churn rate prediction, building geodemographic segmentation models using stochastic gradient descent) and dimensionality reduction techniques like PCA, LDA and kernel PCA.

Experience in creating different visualizations in BI and visualization tool: Tableau using bar charts/stacked bars, histograms, line charts, pie charts, text tables, highlight tables, symbol maps, geographic maps, area maps, tree maps, circle views, dual combination, box and whisker plots, packed bubbles and bullet graphs. Also created interactive dashboards and storyboards with story points to explain the critical analysis points in the data to help the management take analytics backed decisions.

TECHNICAL SKILLS

Coursework: Enterprise Data Analytics, Data Warehousing, Business Process and Workflow Analysis,

Information Enabled Business Modelling, Artificial Intelligence in Business, Information

Security and Controls, IT Service and Project Management, Big Data and Emerging Technologies.

Programming: Data Analytic Skills in Python and R

IDE: Spyder, R Studio

Machine Learning Models: Regression (Linear, Multilinear, Polynomial, Logistic), CART (Decision Tree, Random

Forest), K-means, Clustering, K-Nearest Neighbors, Naïve Bayes, PCA, K-PCA, LDA,

Hypothesis Testing

Statistical Software: SPSS,Origin

Databases: Microsoft SQL server, MySQL, Oracle, DB2, MS-Access, NO SQL

Hadoop Skills: Working knowledge HDFS, MapReduce, HBase, Hive, Pig, Yarn, Spark, Flume and Sqoop

Doc Mgmt Platforms: Confluence, Sharepoint,Reporting Servers

Defect Tracking Tools: Jira,Rally

BI/Visualization Tool: Tableau,Splunk,PowerBI,Report Builder (SSRS),Google Analytics,Google Tag Manager

Kaggle Competitions: Started predictive model submissions on Kaggle.

Machine Learning: AzureML Studio

Advanced Excel Features: Excel Charts, Excel Formulas, Excel Pivot Charts, Excel Dashboard and Excel Pivot Tables

Operating System: Unix, Mac OS and Windows (95, Vista, XP, 7, 8, 8.1, 10)

Sharada Tyagi www.linkedin.com/in/sharada-tyagi

14926, North 104th Place, Scottsdale AZ 85255 602-***-**** *******.*****@*****.***

EDUCATION

W. P. Carey School of Business at Arizona State University, Tempe, AZ

Master of Science in Information Management (MSIM) 3.8 GPA

Full-Time Evening Programme) Graduating in May 2019

S.P. Jain Institute of Management and Research, Mumbai, India

Post Graduate Executive Management Programme (PGEMP), 3.58 GPA June 2011-April 2013

(Ranked 2nd featuring the “Dean’s Top 3 List of Honor)

National Institute of Technology, Karnataka, Surathkal(NITKS), Karnataka, India Bachelor of Engineering (Mechanical Engineering), 3.5 GPA June 1999- May 2003

CERTIFICATIONS

Certified Data Analyst in Python

Tableau 10 Hands on Training for Data Science

Machine Learning Hands on with Python and R in Data Science

Microsoft Excel - Excel Data Analysis using Excel Dashboard

Certified Data Analyst in R –In Progress

Big Data and Hadoop Certification-In Progress

PROFESSIONAL EXPERIENCE

Business Intelligence Developer Nov-2018 - Present

University Technology Office(Data Stewardship And Augmented Analytics) Arizona State University

Responsible for working directly with internal and external developers to assist with creating and maintaining dashboards using SQL, HTML, CSS and JavaScript/jQuery as well as using the Microsoft Business Intelligence Suite of Tools to build models, visualization and SharePoint/Drupal development.

Responsible for drawing business insights from data through complex analysis, data mining, and visualization with respect to descriptive analysis, predictive analysis and prescriptive analysis by using modelling, applying mathematical theory, statistical tools, optimization techniques, algorithms and simulations to business data.

Preparing adhoc reports, memos, dashboards, and story boards explaining the findings through visuals generated from Tableau, PowerBI to provide recommendations to senior management and other end users in order to help them get a better understanding of the information being discussed.

Responsible for analyzing the web traffic to understand how users are interacting with the new website on multiple properties using Google Analytics, especially Google Tag Manager.

Also responsible for providing support to our internal and external customers.

Graduate Statistics Consultant Aug-2018- Oct-2018

Arizona State University

Responsible for providing one-on-one consultancy services to graduate and Phd Students who are working on the statistical analysis for their Thesis or Dissertation as well as to provide consultancy support for a select number of graduate level statistics courses.

Deep Understanding of a wide range of statistical techniques, including a strong grasp of basic analysis and regression, as well as a familiarity with more advanced topics and working with statistical software packages such as R and SPSS.

Lead statistics workshops on various topics, create content for statistics workshops, develop workshop and presentation materials, worksheets and handouts for student use, as well as to assist with marketing an outreach.

Sr.Business Data Analyst Jan 2008 – December 2013

Tata Motors Limited, New Delhi, India

Successfully interpreted data to draw conclusions for managerial action and strategy

Developed custom analysis tools using programming language like Python and R and applications like MS-Excel and for supporting the business and management with clear and insightful analysis on the data.

Sharada Tyagi www.linkedin.com/in/sharada-tyagi

14926, North 104th Place, Scottsdale AZ 85255 602-***-**** *******.*****@*****.***

Was responsible for drawing business insights from data through complex analysis, data mining, and visualization with respect to descriptive analysis, predictive analysis and prescriptive analysis by using modelling, applying mathematical theory, statistical tools, optimization techniques, algorithms and simulations to business data.

Worked with SQL databases and programming language like Python and statistical software packages such as R. (Importing data, cleaning, tidying data, using data manipulation techniques and preparing the data for analysis, statistical inference, parameter estimation and visualization and reporting).

Worked on several use cases such as using data analytics to device new marketing and pricing strategies, customer complaint analysis to predict churn rate of the customers, customer segmentation for targeted marketing, and to develop a holistic solution to improve customer service and satisfaction levels among dealerships using excel data analysis tools.

Prepared adhoc reports, memos, dashboards, and story boards explaining the findings through visuals generated from

Tableau to provide recommendations to managers, senior management and other end users in order to help them get a better understanding of the information being discussed.

Project #1: Strategic Customer Segmentation for Retail Business (June 2012 to Dec 2013)

(Python(Pandas, Numpy, matplotlib,seaborn,re,math,requests),SQL,Excel))

Source of Data: CRM (Customer Relationship Management), DMS(Dealer Management System), warranty data set, SQL database, containing a few lakh observations with attributes like; Customer ID, product details, payment Mode, all purchases details, last purchase details, location etc.

Project: In this project the dataset from above sources of passenger car and commercial vehicle retail business for the last two years were considered. The objective of this use case was to do customer segmentation in this data set for targeted marketing strategies.

Responsibilities:

Worked closely with different business leads in designing and analyzing the data

Ability to dig into raw data to find and evaluate actionable insights that will help the organization

Extracted, performed validation and generated Python data sets; using SQL queries and importing data from excel spreadsheets and flat files.

Extract the data from various data warehouses and create ad-hoc reports, tables, and graphs per business needs in Excel

Used programming languages like Python with packages like Numpy, Pandas for importing and cleaning data, manipulating dataframes with Pandas and data visualization was done with matplotlib on Spyder IDE and also using some of the advanced excel functions.

Undertook various data pre-processing like taking care of missing values within the data set, taking care of categorical values, dividing that dataset into training and test sets and applying feature scaling to the datasets.

For this project, customer’s recency, frequency and monetary (RFM) analysis a marketing technique was used to determine quantitatively which customers are the best ones by examining how recently a customer has purchased (recency), how often they purchase (frequency), and how much the customer spends (monetary).

From these three derived values, the entire customer base was segmented to generate insights on the data set provided, to do customer segmentation using RFM Model based Clustering Analysis with the help of k-means algorithm, to visualize and interpret the results, and select the number of clusters when it's not known ahead of time.

Provided python programming support and technical assistance in the development and intermediate steps as and when required.

Prepared reports, memos, worksheets, dashboards and storyboards explaining the findings through visuals generated from Tableau to provide recommendations to managers and other decision makers on the effects of various courses of action to take in order to address a problem.

Project #2: Customer Complaints Analysis (May 2011 to June 2012)

(Python (Pandas, Numpy, matplotlib,seaborn,re,math,requests)R(dplyr, ggplot),SQL,Excel)

Source of Data: CRM, DMS, warranty data set, SQL database, containing a few lakh observations with attributes like; Customer ID, Payment Mode, Product Details, Complaint, Location, Status of the complaint, etc.

Project: The objective of this use case was to conduct the customer complaint analysis using Python/R in Spyder/R-studio IDE.

Responsibilities:

Get the number of complaints filed under each product the data was available in excel sheet format where in the data was imported to the IDE using industry-standard pandas library and, build, it to a data frame. Using data

Sharada Tyagi www.linkedin.com/in/sharada-tyagi

14926, North 104th Place, Scottsdale AZ 85255 602-***-**** *******.*****@*****.***

manipulation and transformation techniques like indexing, slicing and filtering was able to convert the data into a form that permitted easy analysis. Matplotlib package was used to visually represent the number of complaints filed under each category of the vehicle like, LCV (Light Commercial Vehicles), M&HCV (Medium and Heavy Commercial Vehicles).Used programming languages like Python with packages like Numpy, Pandas for importing and cleaning data, manipulating dataframes with Pandas and data visualization was done with matplotlib on Spyder IDE and also using some of the advanced excel functions.

Used statistical programming language like R with libraries like dplyr and ggplot for importing, cleaning, tidying and manipulating data, data visualization was done using the package ggplot in RStudio IDE

Examined the information to figure out what is relevant to a problem and what methods might be used to analyze it.

Get the total number of complaints filed from a particular location by doing exploratory data analysis by plotting the data and computing simple summary statistics of the data and using probability theory to predict the occurrence of discrete quantities like number of complaints filed in this case.

Get the list of complaints grouped by location which has no timely response, using statistical tools, simulations and predictive modelling techniques like multiple linear regression model, and further performed dimensionality reduction technique like linear discriminant analysis (LDA) and measured the accuracy of the model.

Prepared dashboards for customer complaint analysis grouped by location and adhoc reports and memos for the marketing and service team to discuss the analysis results and take necessary corrective actions for the same.

Project #3: The evolution of customer behavior and experience (March 2010 to May 2011)

(R(dplyr, ggplot),SQL,Excel)

Source of Data: CRM and DMS Dataset.

Project: The goal of this use case was to explore the CRM-Customer Relationship management and Dealer Management Systems(DMS) dataset, given the parameters like: "model", "year and make", "customer category", "vehicle purchase mode", etc. and to use analytics to device new pricing and marketing strategies.

Responsibilities:

Responsible for the cleaning, reformatting, analysis and loading the data into the database

To find out top ten customer categories (key accounts, institutions, corporates, retail customers) who bought the maximum number of vehicles. The data was available in excel sheet format where in the data was imported to

current working directory of IDE, and tools from dplyr packages was used to convert the data set to a data frame. Data manipulation techniques with dplyr package was used to tidy, rearrange, and restructure the data by pivoting/ melting and stacking/un-stacking dataframes.

Used statistical analysis, simulations, predictive modeling, and other methods to analyze information to help develop practical solutions relating to the business problem.

To plot a graphical representation to show number of vehicles purchased each year directly from dealers and booked directly through the company. -- Statistical plots with base graphics and ggplot2 tools was used for computing and visualizing linear regressions as well as tools for visualizing univariate distributions (e.g. strip, swarm and violin plots).

To understand the value of various consumer segments (for example by frequency of purchase, geographic location, by age, income, etc.) and if they all provide the same value to the company’s sales and growth objectives. -- tools from correlation and regression analysis were used to deal with the labeled data sets for identifying the relationship between a dependent variable and one or more independent variables and using correlation coefficients to study the strength of the linear relationship between a pair of variables.

Prepared dashboard having violin plots, box, whisker plots for visualizing linear regression to explain univariate distributions to show a graphical representation of the number of vehicles purchased directly from the dealers and those purchased directly from the company.

Project #4: Improving Customer Satisfaction Index (Jan 2008 to Feb 2010)

(Problem-solving logic), SQL, Intermediate to Advanced Excel)

Source of Data: CRM and DMS Dataset.

Project: The goal of this use case was to develop a holistic solution to improve customer service and satisfaction levels among dealerships. The solution included: business process reengineering in dealer sales and after-sales process, development of a suite of metrics, systems analysis and design and change management and organization design.

Responsibilities:

Sharada Tyagi www.linkedin.com/in/sharada-tyagi

14926, North 104th Place, Scottsdale AZ 85255 602-***-**** *******.*****@*****.***

Performing data validation, transforming data from SQL to useful datasets.

Responsible for the cleaning, reformatting, analysis and loading the data into the database

Used focused interventions that identified and addressed gaps in customer-centric sales and after-sales processes and methodologies. Also involved in continuous measurement and analysis of trends in dealer CSI performance. Worked

with the business community to define business requirements and analyze the functional requirements and gathered the requirement from stakeholder and SME’s.

Used advanced Excel features like Excel Charts, Excel Formulas, Excel Pivot Charts, Excel Dashboard and Excel Pivot Tables for data analysis and visualization in order to help the end users get a better understanding of the information being communicated.

Responsible for Requirement gathering and Business Process flow.

Worked with the Project Manager on various activities like keeping track of project status, critical milestones.

Performed Gap analysis by identifying existing processes, documenting the enhancements to meet the end state requirements.

Was responsible for collecting relevant data from the field by interview end clients that is the dealers identified and sales managers involved in the business processes being examined.

Examined the information to figure out what is relevant to a problem and what methods might be used to analyze it.

Used statistical analysis, simulations, predictive modeling, and other methods to analyze information and develop practical solutions to business problems

By generating reports, memos of the findings through visualizations like charts, graphs, using Tableau, showed the implications of pursuing different actions and assisted in achieving a consensus on how to proceed.

Project Rainbow (July 2005 to Jan 2008)

Role: Sr.Business Analyst/Product Owner

Worked as Business Analyst/Product Owner in a project entitled ‘RAINBOW” for developing an IT system application using Agile framework, to track all customer leads for government, defense and institutional business from their inception stage till final delivery of the vehicle and capturing the CSI (Customer Satisfaction Index) report for both the commercial vehicle and passenger car business.

Gathered User and Business Requirements through JAD sessions, surveys etc.

Conduct release planning session to explain product portfolio of CV’s, PV’s Government, Defense and Institutional Business.

Facilitated JAD sessions with management, users and other stakeholders to define the project and to reduce the time frame required to complete deliverables.

Responsible for Requirement gathering and Business Process flow.

Worked with the Project Manager on various activities like keeping track of project status, critical milestones and managing UAT defects.

Helped Scrum team by converting business requirements into features and user stories during release planning.

Prioritize the product backlog with the help of Scrum Master and technical architect and creating MVP for release.

Helped Scrum team in breaking large user stories in smaller stories so that it can be completed in same Sprint.

Helped Scrum Master in prioritizing the Sprint backlog depending on team capacity during planning session.

Worked closely with UI team for creating wireframes.

Participate in daily standups to answer all the queries that developers have from Sprint backlog.

Do show and tell sessions to make sure developers are completing user stories as per acceptance criteria mentioned in user story.

Updated the user story status to “Accepted” as per the definition of done at Sprint level.

Used SQL for extracting data from the DB2 database and performed data analysis.

Ensure comprehensive defect tracking and issue resolution using Rally.

Performed regression analysis of the final end product and manually executed the UAT cases before releasing it to the end users.

Worked closely with the UI team to model the screens, which met business requirements

Conducted user walk through sessions for the business users and senior management by end of every 2 to 3 Sprints.

Project: Tracking performance of Auto Fleet Market (July 2003 to June 2005)

Role: Business Analyst/Product Owner

Was involved in a project with the consulting team to improve sales performance in the auto fleet market which included the commercial, corporate and institutional customer segments.

Sharada Tyagi www.linkedin.com/in/sharada-tyagi

14926, North 104th Place, Scottsdale AZ 85255 602-***-**** *******.*****@*****.***

Implemented a customer-centric campaign management approach to generate a steep increase in sales volumes, piloting the program in two markets before national implementation.

The company’s existing customer campaigns, offerings and solutions were aligned to the specific needs of each customer segment.

Facilitated JAD sessions in defining, documenting the business needs and Business Process flows.

Prepared and presented Business Requirement Document (BRD) and involved in sign-off process.

Assisted the development manager in setting realistic project expectations and in evaluating the impact of changes on the organization and plan accordingly.

Aided in the creation of functional, integration and user acceptance test plans.

Performed manual functional testing of the web interface and provided timely inputs to the development on the process flow.

PROFESSIONAL ACCOMPLISHMENTS

I have been qualified as a TBEM-Tata Business Excellence Model Assessor with Performance Grade "A" – Gold Standard, by participating in the 'Business Excellence Leaders Program (BELP-2011)' conducted by TQMS-Tata Quality Management Services. After this certification program, the incumbent is eligible to become an External Assessor, as part of the External Assessment Team in the Tata Group wide the TBEM Assessment Process for Process Audit, ISO Audit CMM Assessment etc.

VOLUNTARY AND COMMUNITY INVOLVEMENT ACTIVITIES

Student Ambassador August-2018 – July-2019 W. P. Carey School of Business at Arizona State University, Tempe, Arizona

Selected as a “Student Ambassador” to represent the W.P. Carey Business Programs to prospective students and employers.

Served on the student council as Secretary Treasurer for two years and volunteered at a local Boys & Girls Clubs during school breaks.

Was also involved with the local temples, Gurudwaras and local community service, old age homes as volunteer youth counselor and advisor in activities which included feeding the poor and the needy in the local communities, visiting the sick and elderly.

Contact this candidate