
Data Analyst with less than a year in Power BI & Python
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Data Analyst and CSE graduate (Chandigarh University, 2024) with hands-on experience in EDA, data cleaning, KPI engineering, and dashboard development using Python, SQL, and Power BI. Seeking an entry-level Data Analyst role to drive data-informed decisions and deliver measurable organizational value.
Chandigarh University
B.E in Computer Science and Engineering · Computer Science and Engineering
September 1, 2020 – June 1, 2024
Social Media Performance Dashboard
June 1, 2026 – Present
Built a 3-layer executive BI dashboard tracking multi-platform social media KPIs (YouTube, TikTok, Instagram, LinkedIn, Facebook, X) with custom DAX measures and Star Schema data modeling. Derived content strategy insights via EDA, showing educational posts achieved a 19.9% engagement rate (2.7× higher than entertainment) while image formats outperformed video by 3.4%. Optimized publishing strategy by identifying Wednesday 4 PM as the peak engagement window generating 89.7M engagements, and discovering #CustomerStory as the highest-performing hashtag with 201M interactions.
View ProjectSwift Route Logistic Dashboard
June 1, 2026 – Present
Engineered a Power BI dashboard using DAX to track logistics KPIs, identifying hub bottlenecks that reduced delayed orders by 2.0% (500+ annually). Modeled a Star Schema dataset and applied Python analytics, uncovering a 3× higher breakdown rate in legacy vehicles to optimize asset lifecycle efficiency. Diagnosed a 10% YoY drop in delivery SLAs across 3,663 shipments, proposing a tiered pricing strategy to boost retention and improve operational margins.
View ProjectAUSTISIGHT Housing Market Insights Dashboard
June 1, 2026 – Present
Built a Power BI dashboard with a Star Schema and DAX to analyze 15,171 property records, revealing a 35% market price surge over 3 years. Performed correlation analysis on 47 features, identifying bathroom count (r = 0.505) as the strongest price driver and a 12% ($36K) premium in top school zones. Analyzed inventory distribution, finding 63% of listings in the $200K-$500K range and identifying properties with 25-40% ROI potential.
View ProjectAirbnb Booking Analysis
June 1, 2026 – Present
Processed and analyzed a comprehensive Airbnb dataset containing 40,000+ records and 15+ features, utilizing Python (Pandas, NumPy) to handle missing values and perform rigorous Exploratory Data Analysis (EDA). Engineered 10+ dynamic data visualizations using Matplotlib and Seaborn to map geospatial pricing trends, identifying a 25% price premium in top-tier neighborhoods to optimize room-type revenue.
View ProjectData Analyst in Python
DataCamp
June 1, 2026 – Present
E-Voting based upon Blockchain System
Unknown
June 1, 2026 – Present
MAKEATHON5 and GDSE IdeasUnite
Unknown
June 1, 2026 – Present
GATE
Unknown
June 1, 2026 – Present
CAT
Unknown
June 1, 2026 – Present
JEE Mains
Unknown
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's academic projects showcase a breadth of analytical applications across social media, logistics, and real estate, indicating adaptability and a diverse interest in data challenges. The focus on deriving actionable insights and optimizing strategies aligns well with a data-driven organizational culture. However, the lack of professional experience or team-based project descriptions makes it difficult to fully assess collaboration and broader cultural fit beyond academic settings.
Soft Skills & Operational Fit
The candidate's project descriptions indicate a results-driven approach, focusing on quantifiable outcomes (e.g., 'reduced delayed orders by 2.0%', '19.9% engagement rate'). Participation in MAKEATHON5 and GDSE IdeasUnite suggests an ability to work under time constraints and collaborate on technology solutions. The academic projects demonstrate problem-solving skills and an understanding of business impact.