Shamli Bisht

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

• Actively participated in Basketball for 4 consecutive years in school.

• Supervised team of 18 staff members.

BI Tool Setup 

• Creating flat tables for Looker via ETLs in python
• Structuring of data using LookML (Looker proprietary language)
• Creating interactive dashboards on Looker for stakeholders Integration of Marketing metrics with database
• Setting up user level tracking from Google Analytics
• Integrating user tracking on website
• Creating pipeline for data extraction via Google Analytics API

ETL Tool Setup(HEVO) 

• Created and managing overall pipelines.
• Ingested data from various platforms eg: Google Analytics, Google Ads, MySQL, Facebook, MongoDB, DynamoDB, Freshdesk etc.
• Created and managing various Models(derived tables)
• Own data security and hashed all crucial information of the user from our whorehouse with transformation.

Zoho CRM Management 

• Backend Management of CRM and Process designing for Sales Team.
• Working on Deluge for automation of processes.
• Working with the Sales team to make the sales process more efficient and time saving.

Inhouse CRM Building 

• Worked very closely with the Product team in designing CRM on internal platform.
• Defining process logics and process designs
• Assisting in enhancing the dashboarding, reporting and analysis process

Marketing Automation 

• Built facebook auto posting bot on selenium on python.

Marketing Dashboards & Analytics 

• Identifying KPIs of campaigns and setting targets with the business team for marketing.
• Creating interactive dashboards for representation of Zoho Analytics and Inhouse Tools powered by Python.

Data Availability and Accessibility 

• Getting Data from external tools like google ads, google analytics, Facebook etc via APIs and making it readily available in MySQL database for better analytics
• Improvising communication between Zoho and MySQL database for better uniformity of data. Providing Key Insights for lead management
• Managing Capacity and creating a capacity planning model for the Call Sales Team.

Facilitating trainings for new users 

• Providing Training on all CRM related processes and products.

 Impact of support on User Retention 

• In depth analysis of major factors impacting user growth.
• Correlation between cost spent on retention of users and revenue generated from those users.
• Studying impact of support system on user retention based on overall experience.
• Drilling down from the basic understanding of order support to each sub issue generating support.
• Redesigning policies with the operations team to make them more user friendly and analyzing the cost impact of those policies.
• Working with the product team in implementing the policies.

User Experience Improvement (Increasing the number of perfect orders)

• Understanding user behavior on support and categorizing users on the basis of different support matrices.
• Dividing imperfect orders into two categories, i.e., system related issue and non-system related issue.
• Reporting system related issues to respective stakeholders and helping them identify key areas to work on.

SLA (Service Level Agreement) designing for external vendors based on historical performance and introducing new matrices to improve their efficiency and performance. 

Capacity planning and analysis for a team of ~1800 people Planning Structure Remodeling 

Impact of support on User Retention 

• In depth analysis of major factors impacting user growth.
• Correlation between cost spent on retention of users and revenue generated from those users.
• Studying impact of support system on user retention based on overall experience.
• Drilling down from the basic understanding of order support to each sub issue generating support.
• Redesigning policies with the operations team to make them more user friendly and analyzing the cost impact of those policies.
• Working with the product team in implementing the policies.

User Experience Improvement (Increasing the number of perfect orders)

• Understanding user behavior on support and categorizing users on the basis of different support matrices.
• Dividing imperfect orders into two categories, i.e., system related issue and non-system related issue.
• Reporting system related issues to respective stakeholders and helping them identify key areas to work on

Impact of support on User Retention 

• In depth analysis of major factors impacting user growth.
• Correlation between cost spent on retention of users and revenue generated from those users.
• Studying impact of support system on user retention based on overall experience.
• Drilling down from the basic understanding of order support to each sub issue generating support.
• Redesigning policies with the operations team to make them more user friendly and analyzing the cost impact of those policies.
• Working with the product team in implementing the policies.

User Experience Improvement (Increasing the number of perfect orders)

• Understanding user behavior on support and categorizing users on the basis of different support matrices.
• Dividing imperfect orders into two categories, i.e., system related issue and non-system related issue.
• Reporting system related issues to respective stakeholders and helping them identify key areas to work on