I turn data into actionable business intelligence. With a B.Com in Accounting & Finance and expertise in Power BI and SQL, I specialize in building data-driven narratives that stakeholders can act on.

• 🎓 Final-year B.Com (Accounting & Finance) student at KNIT Sultanpur
• 📊 4 end-to-end analytics projects deployed across e-commerce, retail, ride-hailing, and streaming industries
• 💼 Finance-native — I understand P&L, margins, and cost structures, not just create dashboards
• 🔍 Expertise in transforming 100K+ records into decision-ready dashboards
• 🚀 Proven ability to communicate insights to non-technical stakeholders
• 🌱 Currently expanding into Python (Pandas) and advanced SQL
• 💡 Open to: Data Analyst roles (Full-time/Internship) & Freelance projects
• 📍 Location: Noida, Uttar Pradesh, India

Proficiency: ⭐⭐⭐⭐⭐ | 5+ dashboards, interactive filters, DAX formulas

Proficiency: ⭐⭐⭐⭐☆ | Joins, Window Functions, CTEs, Aggregations

Proficiency: ⭐⭐⭐☆☆ | Currently expanding — Data cleaning, EDA

• 📈 Data Storytelling — Translating insights into business narratives
• 🤝 Stakeholder Communication — Presenting to both technical and non-technical audiences
• 📋 Project Management — End-to-end analytics workflow execution
• 🎨 UX/UI Sense — Building intuitive, user-friendly dashboards

Power BI | 5 Pages | 103K+ Bookings | ₹35M Revenue Analyzed

Engineered a comprehensive operational dashboard analyzing OLA's July 2024 booking ecosystem. The dashboard provides real-time insights into:

• Booking Performance: Trend analysis, peak hours, and demand forecasting
• Vehicle Analytics: Fleet utilization, vehicle-wise revenue breakdown
• Revenue Metrics: Daily/weekly trends with 15% variance analysis
• Quality Metrics: Cancellation root causes, driver & customer satisfaction ratings

Key Achievement: Identified high-cancellation time windows, suggesting operational bottlenecks

🔗 View Repository | 📊 Interactive Dashboard

Power BI | Custom Netflix Branding | 85.3K Views | 10 Countries

Built a visually branded entertainment analytics dashboard tracking viewing behavior across multiple regions. Features include:

• User Engagement: View counts by genre, time-of-day patterns, device preferences
• Geographic Insights: Country-wise subscription and streaming trends
• Content Performance: Top shows, stream quality metrics, completion rates
• Interactive Filters: Genre, region, and device slicers for dynamic exploration
• Engagement Trends: Peak streaming hours and seasonal patterns

Key Achievement: Discovered that 60% of views happen after 8 PM, informing content release strategies

🔗 View Repository | 📊 Interactive Dashboard

Power BI | 4 US Regions | YoY Analysis | Profit Optimization

Developed a region-filtered dashboard enabling store leadership to monitor performance across geographies. Includes:

• Sales Performance: Regional breakdown, product category trends, segment analysis
• Profitability: Profit margins by region and category, discount impact analysis
• Shipping Efficiency: Mode-wise performance, delivery time metrics
• YoY Comparison: 2019 vs 2020 trend analysis with growth rates
• Drill-Down Capability: State-level and city-level granularity

Key Achievement: Identified that West region underperformed by 12%, enabling targeted intervention

🔗 View Repository | 📊 Interactive Dashboard

Microsoft Excel | 103K+ Orders | 6 E-Commerce Platforms | Dynamic Reporting

Created a comprehensive Excel-based analytics suite for Vrinda Store's 2022 performance across India's major e-commerce platforms (Amazon, Flipkart, Myntra, Meesho, Ajio). Deliverables:

• Sales Performance: Revenue trends, order volume by platform, seasonal patterns
• Customer Insights: Gender demographics, age group analysis, purchasing behavior
• Geographic Coverage: State-wise sales distribution, regional performance
• Fulfillment Metrics: Order status tracking, return rates, customer feedback
• Interactive Slicers: Dynamic filtering by platform, month, region, and product type

Key Achievement: Revealed that female customers drive 65% of revenue, reshaping marketing strategy

🔗 View Repository | 📥 Download Excel File

🔨 Building Projects
   ├─ Python + Pandas data cleaning pipelines
   ├─ Advanced Excel (XLOOKUP, LET functions)
   └─ Real-time dashboarding experiments

📚 Skill Development
   ├─ Intermediate SQL (Window functions, CTEs, performance tuning)
   ├─ Data storytelling with Tableau
   └─ Statistical analysis fundamentals

🎓 Certifications in Progress
   └─ Microsoft PL-300 Power BI Certification (Q3 2024)

I'm always open to discussing data projects, collaborations, or career opportunities. Here are the best ways to reach me:

💡 "Data is a story waiting to be told. I help tell it right." — Always open to opportunities, feedback, and collaboration.