Data Analyst with 4+ years in Data Analysis, Visualization & Machine Learning
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Highly analytical and results-oriented Content Analyst with 4.5 years of experience leveraging SQL and Excel to enhance data accuracy and drive marketing performance. Proven ability to develop interactive Power BI dashboards, analyze complex datasets, and contribute to significant improvements in organic traffic and campaign efficiency. Skilled in Python and various data science libraries, with a strong background in data cleaning, preprocessing, and exploratory data analysis across diverse projects.
National Institute Of Technology, Raipur
Bachelor of Technology
August 1, 2021 – June 30, 2025
A. N. College, Patna
12Th Class · BSEB
June 1, 2019 – May 31, 2020
Bal Kalyan Public School Pali, Darbhanga
10Th Class · CBSE
June 1, 2017 – May 31, 2018
Collegedunia
Content Analyst
January 1, 2021 – Present
Gurgaon, Haryana, India
Lok Sabha Election Result 2024 Data Analysis
November 1, 2025 – June 30, 2026
Analyzed 2024 Lok Sabha election results using Python and Pandas to evaluate party-wise performance, constituency outcomes, vote margins, and candidate statistics across 543 parliamentary seats. Performed data cleaning, preprocessing, and exploratory data analysis (EDA) on election datasets to identify voting patterns, winning margins, and electoral trends. Created visualizations using Matplotlib and Seaborn to analyze party performance, vote share trends, candidate statistics, and constituency-wise election outcomes.
Credit Card Financial Dashboard
August 1, 2025 – June 30, 2026
Developed an interactive dashboard using transaction and customer data from a SQL database, to provide real-time insights. Streamlined data processing and analysis to monitor key performance metrics and trends. Developed dynamic visualizations, including bar graphs, line charts, slicers, and donut charts, to present key metrics and support data-driven decision making. Shared actionable insights with stakeholders based on dashboard findings to support decision-making processes.
Music Store Data Analysis
January 1, 2025 – June 30, 2026
Developed complex SQL queries to analyze music playlist database and answer key business questions around customer behavior, revenue, and genre trends. Identified top customers, high-revenue cities, and senior employees by applying advanced SQL operations including joins, aggregations, CTEs and window functions. Analyzed global music preferences by country and discovered most popular genres and top-spending customers per region. Optimized query performance and delivered insights on churn patterns, best customers, and artist sales contributions to support data-driven decision making.
Achieved 5-star ratings in SQL
HackerRank
June 1, 2026 – Present
Certified in SQL Basic and Intermediate
HackerRank
June 1, 2026 – Present
Programming in Python Certification
Simplilearn
June 1, 2026 – Present
Introduction to Data Analytics Certification
Simplilearn
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from election data analysis to music store insights and financial dashboards, indicates a broad interest in applying data analysis across different domains. The current role as a Content Analyst, while not a pure data analyst role, involves significant data analysis tasks, showing adaptability. The certifications and ongoing education suggest a proactive learning attitude, which aligns well with a growth-oriented culture. The personal projects demonstrate initiative and self-driven learning.
Soft Skills & Operational Fit
The candidate's experience as a Content Analyst at Collegedunia, where they collaborated with SEO and content teams, suggests an ability to work cross-functionally and communicate data-driven insights. The project descriptions indicate a focus on delivering actionable insights, which is crucial for operational fit in a data analyst role. However, specific soft skills like problem-solving under pressure or leadership are not explicitly detailed.