Gaurav Mahar
New Delhi
Summary
Results-driven Business Analyst with over 2 years of experience in data interpretation and process optimization. Proven ability to convert complex data into actionable insights, enhancing business decision-making. Effective collaborator skilled in working with cross-functional teams to achieve organizational objectives and deliver measurable outcomes.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Business Analyst Intern
Eduminds learning
New Delhi
03.2024 - Current
- Identified opportunities for cost savings through process improvements and automation initiatives.
- Tracked key performance indicators across multiple departments over time.
- Created project plans outlining timelines, goals, milestones, deliverables, and resource allocations.
Sales Analyst
coding ninjas
Gurugram
04.2023 - 11.2023
- Designed and analyzed reports and dashboards to provide actionable insights for lead generation and process optimization.
- Streamlined data management processes using SQL and advanced Excel tools, improving data accuracy and reporting efficiency.
- Automated repetitive tasks to enhance team productivity and drive data-driven decision-making.
Senior Sales Consultant
hero vired
New Delhi
01.2023 - 04.2023
- Delivered presentations and conducted meetings with C-Suite executives to enhance profitability.
- Built relationships with key clients through regular meetings and follow-up calls.
Education
Bachelor of Science - Electrical and Electronics Engineering
Delhi Technological University
Delhi08-2019
High School Diploma -
The Banayan Tree School
New Delhi 06-2013
Skills
- Data Analysis Tools: SQL, Power BI, Excel (advanced formulas, PivotTables, dashboards)
- Data Modeling: Process Flowcharts, Use Cases, SWOT Analysis
- CRM Tools: Leadsquared, Pipedrive
- Business Analysis: Requirements Gathering, Market Analysis, Predictive Modeling
- Soft skills: interpersonal skills, stakeholder engagement, presentation skills
Project
- Amazon Sales Dashboard Project:
Designed a comprehensive Power BI dashboard for an Amazon sales dataset.
The dashboard included sales trends, product performance metrics, and regional analysis, enabling data-driven decision-making and identifying key growth opportunities. - Data Automation Project:
Designed and implemented automated data pipelines, resulting in 30% faster data processing. - Client Insights Report:
Delivered comprehensive competitor benchmarking reports, driving strategic decisions. - Predictive Modeling:
Built predictive models to forecast sales trends, achieving a 20% increase in accuracy.
Certification
Microsoft Business Analyst Professional Certificate Business Analysis Modeling Skills & Techniques
08/2024 - 10/2024
- Data for Business Analysts Using Microsoft Excel
- Requirements Gathering in Business Analysis
- Power Platform in Business Analysis
The BA Guide | Jeremy Aschenbrenner (01/2024 - 05/2024)
- Process Flowcharts, RACI Matrices, Org Charts, User Stories
Timeline
Business Analyst Intern
Eduminds learning
03.2024 - Current
Sales Analyst
coding ninjas
04.2023 - 11.2023
Senior Sales Consultant
hero vired
01.2023 - 04.2023
Bachelor of Science - Electrical and Electronics Engineering
Delhi Technological University
High School Diploma -
The Banayan Tree School