About
Highly analytical and results-driven Data Analyst with expertise in SQL, Python, Excel, and Power BI, adept at transforming complex datasets into actionable business intelligence. Proven ability to design and implement end-to-end analytics solutions, including ETL pipelines, data cleaning, and dashboard development, to drive strategic decision-making. Skilled in customer sentiment analysis, AI automation, and transportation analytics, passionate about optimizing workflows and delivering data-driven solutions.
Work
Restaurant Feedback System Project
|Machine Learning Engineer & Developer
Dehradun, Uttarakhand, India
→
Summary
Developed a multimodal feedback system utilizing AI for real-time customer sentiment analysis to enhance service quality.
Highlights
Developed a multimodal feedback system integrating facial emotion recognition (CNN-based FER model) and speech sentiment analysis for real-time customer insights.
Implemented Google Speech-to-Text API with a custom sentiment analyzer, enabling accurate voice-based feedback classification.
Designed a user-friendly Tkinter GUI for live feedback capture and automated CSV logging, reducing manual survey dependency and improving data collection efficiency.
MCA Project Leadership
|Team Lead
Dehradun, Uttarakhand, India
→
Summary
Led and coordinated a team of 3 students through a Master of Computer Applications project, ensuring successful development and delivery.
Highlights
Led a team of 3 students during a major MCA project, coordinating development tasks and ensuring timely delivery of project milestones.
Successfully handled complex project presentations, effectively showcasing technical solutions and project outcomes to stakeholders.
Cultivated strong communication and public speaking skills through regular team meetings and formal project reviews, enhancing overall project visibility.
Ola Ride Analytics Dashboard Project
|Data Analyst & Developer
Dehradun, Uttarakhand, India
→
Summary
Designed and implemented an end-to-end analytics solution for Ola Ride data, focusing on booking, revenue, and cancellation trends to enhance operational efficiency.
Highlights
Designed an end-to-end analytics solution, integrating booking, revenue, and cancellation data using SQL queries and Power BI for comprehensive insights.
Created dynamic DAX measures to analyze booking status distribution, cancellation trends, and revenue breakdown by payment method, providing granular performance visibility.
Generated actionable insights that led to strategies for reducing cancellations and optimizing ride allocation, resulting in improved operational efficiency.
Electric Vehicle Analysis Dashboard Project
|Data Analyst & Developer
Dehradun, Uttarakhand, India
→
Summary
Developed a comprehensive Power BI dashboard to analyze Electric Vehicle (EV) adoption trends and inform strategic business expansion.
Highlights
Developed robust DAX measures to accurately track and forecast BEV vs PHEV adoption trends, enhancing predictive model reliability.
Identified top-performing cities for EV adoption, providing critical data to support and guide data-driven business expansion strategies.
Visualized detailed vehicle distribution by make, effectively highlighting Tesla as the market leader with 69,000 registrations, significantly outperforming Nissan and Chevrolet.
Education
Graphic Era Hill University
→
Master
Computer Applications
Grade: 8.1/10 CGPA
Graphic Era Hill University
→
Bachelor
Computer Applications
Grade: 8.5/10 CGPA
Awards
Top 5 Position in Arm Wrestling
Awarded By
University Sports Council
Achieved a Top 5 position in the Under 80kg Category for Arm Wrestling, demonstrating competitive spirit and physical prowess.
Languages
English
Certificates
Google Data Analytics Certificate
Issued By
Coursera
Skills
Programming & Databases
SQL (MySQL, PostgreSQL), Python (Pandas, NumPy, Matplotlib, Seaborn).
Data Visualization
Power BI (DAX, Power Query), Advanced Excel (Pivot Tables, Power Query, VBA).
Data Handling
Data Cleaning, Exploratory Data Analysis (EDA), Data Modeling, ETL Pipelines, Data Warehousing.
Analytics & Statistics
Descriptive Statistics, Regression, Predictive Analysis, KPI Tracking, Reporting Automation, Customer Sentiment Analysis, Transportation Analytics.
Machine Learning & AI
Facial Emotion Recognition (CNN-based FER Model), Speech Sentiment Analysis, Custom Sentiment Analyzer, AI Automation.
Tools & Technologies
Tkinter, OpenCV, Google Speech-to-Text API.
Problem Solving & Development
Algorithm & Data Structure Problems (700+ solved), Workflow Optimization, Data-Driven Solutions.
Soft Skills
Communication, Public Speaking, Team Leadership, Project Coordination, Analytical Mindset.