Data Analyst with less than a year in Excel dashboards, SQL, and Power BI skills.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with hands-on experience in Excel dashboards, SQL Server mini projects, and business trend analysis. Built interactive dashboards using Pivot Tables, KPI cards, charts, and slicers, and completed SQL-based e-commerce sales analysis to derive business insights. Currently pursuing MCA and building Power BI dashboarding skills. Strong foundation in reporting, dashboard building, data storytelling, and business insights.
IMSEC, AKTU University
MASTERS OF COMPUTER APPLICATIONS (MCA) · Computer Applications
August 1, 2024 – June 30, 2026
I.P(PG) COLLEGE, CCS University
BACHELOR OF COMPUTER APPLICATIONS (BCA) · Computer Applications
August 1, 2021 – June 30, 2024
Swiggy Sales Dashboard
January 1, 2023 – June 30, 2024
Developed an interactive sales dashboard using Pivot Tables, slicers, KPI cards, and charts. Analyzed Total Sales, Orders, Average Rating, city and category performance. Added slicers for city and category-level interactivity. Derived insights on monthly sales trends and top-performing categories.
Profit Leakage & Revenue Optimization Dashboard
January 1, 2023 – June 30, 2024
Developed an end-to-end interactive dashboard to identify profit leakage and profitability drivers. Created helper columns including Profit Margin %, Discount Band, Quarter, Leakage Category, and Profitability Band. Built KPI Cards, Pivot Tables, Pivot Charts, Slicers, and Timeline filters. Analyzed regional profitability, product margins, discount impact, and revenue vs profit trends. Generated business recommendations to improve pricing strategies and reduce profit leakage.
E-commerce Sales Trend Analysis
January 1, 2023 – June 30, 2024
Performed year-wise sales trend analysis using GROUP BY, Aggregate Functions, TOP, ORDER BY. Identified best-performing year, weakest month, average order value trend, and order growth. Converted SQL query outputs into business insights for decision-making.
Cultural Fit Analysis
The candidate's projects are diverse within the data analysis domain, covering sales, profit leakage, and e-commerce trends. This breadth, combined with a clear target role as a Data Analyst, suggests a good alignment with roles requiring versatile analytical skills. The academic projects indicate a proactive approach to skill development. However, the lack of professional experience means cultural fit aspects like collaboration in a corporate setting are not yet demonstrated.
Soft Skills & Operational Fit
The candidate demonstrates good communication skills through clear project descriptions and a focus on business insights. The projects indicate an ability to work with structured data and present findings effectively. However, without psychometric test results, it's difficult to assess logical reasoning, work attitude, stress handling, or team collaboration directly.