Muskan Dhawan
ANALYST & STRATEGIST
9810188138
Email:
Find me
Phone:
Worked with
EXPERIENCE
2022-Present
Zenoti
Data Analyst & Strategist
Hyderabad
-
Driving growth in the beauty and wellness industry by examining historical customer data to formulate effective guest retention and acquisition strategies with an emphasis on customer segmentation and industry benchmarks to improve revenue, utilization and footfall.
-
Led customer churn analysis initiative, evaluating multiple parameters associated with a customer base of 22,000 clients to alert CSMs regarding churn risk.
-
Responsible for publishing AWS Quicksight dashboards to analyze trends in revenue, feature value attribution, and guest experience. These dashboards were utilized by product managers, executives, and the payments team to make informed decisions and assessments.
-
Published benchmarking report 2023 and 2024 for the beauty and wellness industry. Conducted comprehensive evaluations of key business performance metrics related to revenue, growth features, and customer acquisition.
April 2021- April 2022
Polstrat
Political Data Consultant
Noida
• Preprocessed and analyzed multilingual electoral documents using Python libraries, ensuring data accuracy and reliability.
• Developed Tableau dashboards to visualize voting trends, enabling stakeholders to make informed decisions.
• Conducted geospatial analysis using geopandas and Folium maps to identify regions of high political activity, analyzing voter distribution, party winners, caste segmentation, and other demographic classifications.
• Led Twitter sentiment analysis projects, comparing the social media presence of politicians from different parties and tracking shifts in public sentiment during electoral periods.
• Extracted and analyzed over 500,000 tweets related to various political figures, employing data mining techniques and natural language processing to discern context.
• Performed electoral swing analysis for the past three state assembly elections in Uttar Pradesh, providing critical insights into voter preferences between candidates and political parties.
May 2020- Aug 2020
CamCann
Internship, E-cell,
Vellore Institute of Technology
-
Objective is to make online education much more interactive and engaging.
-
Developed an online education portal to teach or train students, customers or partners.
-
Worked with technologies like React JS, HTML and CSS.
Dec 2017- April 2019
Institution of Engineering and Technology (IET)
Voluntary,
Vellore Institute of Technology
-
Executed various flagship initiatives of the IET, including conferences, Model United Nations (MUNs), and hackathons.
-
I became part of a program with my team to conduct workshops for high school students in nearby schools. In a significant milestone, I conducted a workshop for over 40 students, focusing on web technologies.
SKILLS
Technical Skills
-
Languages: Python(Advance): Summarizing and visualizing large datasets using numpy, pandas, matplotlib libraries, SQL
-
Data visualization: Tableau, PowerBi, AWS Quicksight
-
Data management: Excel, Powerpoint
-
Statistical Modelling
Business Analysis
-
Market Research
-
Data cleaning
-
Business modelling to avoid churn
-
Data Analysis
-
Data mining and cleaning
EDUCATION
2017-2021
Bachelor in Information Technology
Vellore Institute of Technology(VIT)
Specialization in Information Technology,
My work..
Twitter sentiment analysis concerning politicians representing different parties, to compare their social media presence and track shifts in public sentiment during electoral periods.
Describe your service here. What makes it great? Use short catchy text to tell people what you offer, and the benefits they will receive. A great description gets readers in the mood, and makes them more likely to go ahead and book.
Using the latitude and longitude coordinates of the Jalalpur constituency in Uttar Pradesh, I created a classification map that indicates the predominant caste in each area. When you hover over the map, a bar chart displays the top five castes based on population distribution.