Data Analyst with 2+ years in Business Intelligence & Reporting
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 2+ years of experience in Business Intelligence, Dashboarding, Stakeholder Reporting and Analytics using SQL, SQL Server, Power BI, Python, and Excel. Strong expertise in Advanced SQL Development, ETL Processes, Query Optimization, Data Modeling and EDA to transform complex datasets into actionable business insights.
B N College of Engineering and Technology, Lucknow
B.Tech · Information Technology
August 1, 2019 – June 30, 2023
Exela Technologies Pvt Ltd
Software Engineer
August 1, 2023 – Present
Pune, Maharashtra, India
Uber-Ride-Analytics-Dataset-2025
January 1, 2025 – January 1, 2026
• Cleaned and analyzed 1.5M+ transaction record of Uber using Pandas and NumPy to find customer behavior and sales driver. • Visualized trends using Matplotlib - including category-wise revenue, order frequency, and weekday vs. weekend sales. • Discovered that 65% of bookings occurred during weekends, helping reshape marketing focus and improve targeting. • Demand peaks during rush hours (9-11 AM, 7-9 PM).
View ProjectFood Delivery & Business Analytics Dashboard
January 1, 2025 – October 1, 2025
• Cleaned and Queried a database of 1M+ customer transactions using joins, CTE's, and window functions of orders across 3 years (2022-2024) • Segmented customers based on LFO (Loyal, Frequent, Occasional) scoring; Cancellations are highest in Mumbai (8.7%) • Developed Power BI dashboards with pages for: Executive Overview, Customer Insights and Restaurant Insights. • Chinese cuisine generated the fastest YoY growth (+12.5%): • Generated insights on product performance, Top 10 items contribution, MoM growth, and city-wise demand in 3 years.
View ProjectCRM Analytics System (Client: Confidential – US-based Education)
August 1, 2023 – June 1, 2026
• Designed and developed an end-to-end Hostel CRM Analytics System using Power BI, analyzing Students, Admissions, Payments, Complaints, and Room Allocation activity. • Designed clean Star Schema model with well-defined, Fact & Dimension tables, improving data refresh and DAX performance. • Performed data transformation using Power Query. column standardization, merging, extraction, data type correction, and missing value treatment. • Published report to Power BI Service and configured scheduled refresh, enabled automated daily insights delivery for client. • Reduced operational costs by 15% and improved complaint resolution time by 28% through CRM analytics, KPI tracking, and Power BI dashboard-driven insights
Data Analytics
Coding Ninjas
January 1, 2024 – Present
Cultural Fit Analysis
The candidate shows a strong inclination towards practical application of data analytics skills through a variety of personal and professional projects. The diversity of projects (transportation, food delivery, education CRM) suggests a broad interest in different business domains, which can contribute positively to team dynamics and problem-solving approaches. The continuous learning indicated by the Data Analytics certification also points to a growth-oriented mindset.
Soft Skills & Operational Fit
The candidate's project descriptions highlight problem-solving, attention to detail, and data storytelling, which are crucial for a Data Analyst role. The ability to work on diverse projects (Uber, Food Delivery, CRM) indicates adaptability and a proactive approach to learning and applying skills. The professional experience at Exela Technologies further solidifies their operational fit by demonstrating experience in production deployments and workflow automation.