RAHUL PATEL
New Delhi
Summary
Business Analyst with hands-on experience in data analysis, reporting, dashboarding, and business insights. Skilled in transforming raw data into actionable insights using Power BI, Excel, SQL, and Python. Experienced in working with cross-functional stakeholders to define requirements, track KPIs, and support data-driven decision-making. Strong foundation in market analysis, process optimization, and performance reporting.
Overview
6
6
years of professional experience
Work History
Account Executive – Founder’s Office
Eazybe
New Delhi
07.2024 - 10.2025
- Analyzed sales pipeline and CRM data to identify conversion gaps and performance trends.
- Built and maintained CRM-based reports and dashboards to track KPIs, such as lead-to-close ratio, deal velocity, and sales cycle time.
- Contributed to a 20% reduction in sales cycle time through data-backed process improvements.
- Collaborated with finance, operations, legal, and marketing teams to define business metrics and reporting requirements.
- Prepared weekly performance summaries and insights for leadership to support strategic decisions.
Business Analyst Intern
Outlook India Private Limited
New Delhi
04.2023 - 07.2025
- Analyzed data from multiple internal and external sources to support business and operational insights.
- Created Power BI and Tableau dashboards to visualize trends, performance metrics, and market data.
- Conducted market and competitor analysis to identify growth opportunities and industry trends.
- Translated analytical findings into clear reports and presentations for stakeholders.
Sales Associate
Bajaj Housing Finance
New Delhi
02.2020 - 05.2020
- Analyzed customer and competitor data to support sales strategy and scheme evaluation.
- Tracked performance metrics contributing to over ₹12 lakh in revenue.
- Supported process improvement by reviewing sales workflows and customer patterns.
Education
MBA - Research And Business Analytics
Lal Bahadur Shastri Institute of Management
New Delhi04-2024
B.Tech - Computer Science
ABES Engineering College
Ghaziabad06-2019
Skills
- Power BI (DAX basics, dashboards, data modeling)
- Excel (Pivot Tables, VLOOKUP, IF, charts)
- Python (Pandas, NumPy, Matplotlib, Seaborn)
- SQL (select, where, group by, join, order by)
- Data analysis and reporting
- Market and competitive analysis
- Stakeholder communication
- KPI tracking and trend analysis
Projects
Sales Performance & Customer Behavior Analysis
- Analyzed large retail sales datasets using Python (Pandas, NumPy) to identify revenue trends and customer behavior.
- Performed feature engineering and EDA to uncover high-performing products and regions.
- Built visualizations using Matplotlib and Seaborn to present business insights.
- Delivered actionable recommendations that improved understanding of customer segmentation.
Customer revenue and order analysis
- Designed complex SQL queries using JOINs, GROUP BY, and aggregate functions to analyze customer revenue.
- Calculated order-level and customer-level revenue using business logic
- Optimized queries to extract high-value customer insights.
- Delivered clean, sorted datasets for downstream reporting and dashboards.
Executive Sales Dashboard
- Built an interactive Power BI dashboard to track sales, revenue, and customer performance.
- Created DAX measures for KPIs such as YoY growth and average order value.
- Designed optimized data models using star schema principles.
- Delivered executive-level insights through visually compelling dashboards.
Timeline
Account Executive – Founder’s Office
Eazybe
07.2024 - 10.2025
Business Analyst Intern
Outlook India Private Limited
04.2023 - 07.2025
Sales Associate
Bajaj Housing Finance
02.2020 - 05.2020
MBA - Research And Business Analytics
Lal Bahadur Shastri Institute of Management
B.Tech - Computer Science
ABES Engineering College