Default profile banner
VK

Vyom Kharbanda

@vyomkharbanda

Senior Business Analyst at Exl Service

Muzaffarnagar, Uttar Pradesh

www.linkedin.com/in/vyom-kharbanda/

Exl ServiceUniversity of Delhi

Analytics and consulting professional with more than two years of industry experience in interpreting and analyzing data to drive successful business solutions. Recognized consistently for performance excellence and contributions in building actionable strategies, have a strong understanding of statistical concepts, proficient in SQL, Python and Power BI.

Experience

Senior Business Analyst / Consultant

Exl Service

Apr 2022 - PresentGurugram

Worked on customer data for a UK based Utility company to produce various reports, highlighted customer pain points, and recommended steps to improve customer experience. Developed regression analysis model for call centre performance to determine drivers of customer satisfaction when they contact via telephone. Analysed large volume of customer verbatim comments to find key trends across categories and provide actionable insights to the business. Implemented NLP models using Python for sentiment analysis of customer verbatim and subsequently prepared a dashboard to be used by the stakeholders. Spearheaded various marketing campaigns and promotions to identify customer response and their perception of ‘Brand’. Devised a ‘Connectivity Dashboard’ in Power BI that helps to assess the effects of changing customer experience in a segment on Customer Lifetime Value (CLV) and its financial impact on the business.

Business Analyst

Exl Service

Oct 2020 - Mar 2022Gurugram

Calculated Net Promoter Score (NPS) across customer journeys and touchpoints, continually delivered recommendations to address operational inefficiencies using data-based insights. Automated and optimized existing processes to reduce the bottlenecks and effective completion time by 30% using Hive QL. Collaborated with multiple stakeholders to find key factors that are driving growth and independently presented the findings to clients on various occasions. Used Exploratory Data Analysis (EDA) and business intelligence reports to identify factors influencing customer churn. Designed a consolidated scorecard by compiling data from multiple sources to track business performance which removed multiple dependencies, thereby helping the process owners to self-serve.

Statistics Project Intern

Abacus Management Consultants Pvt. Ltd

Jun 2019 - Jul 2019New Delhi

Designed a scale for calculating 'Adversity Score' which takes into account socio-economic factors that can be used by organizations for better screening of candidates. Performed analysis of various psychometric tests. Worked with large data sets related to projects focused on human behaviour.

Education

University of Delhi

M. Sc Operational Research

Operational Research

Jan 2018 - Jan 2020Grade: 74.6%

University of Delhi

B. Sc (Hons) Statistics

Statistics

Jan 2015 - Jan 2018Grade: 7.405 CGPA

Skills

My SQL
Hive QL
Python
Power BI
MS Excel
Linear Regression
Logistic Regression
Data Visualization
Sentiment Analysis
Natural Language Processing
Business Analysis
Business Intelligence