Manprit Singh

Ahmedabad

Summary

Business Analyst with hands-on experience in data analysis, reporting, and process improvement within the insurance domain. Proficient in SQL, Excel, and Power BI to extract insights, build dashboards, and support data-driven decision-making. Strong ability to gather requirements, analyze business processes, and collaborate with stakeholders to deliver measurable business outcomes.

Overview

years of professional experience

Work History

Business Analyst

ICICI LOMBARD GENERAL INSURANCE

AHMEDABAD

12.2023 - Current

Analyzed sales and partner performance data using Excel to identify trends and improvement areas.
Created reports and dashboards to track KPIs and business growth metrics.
Gathered business requirements from stakeholders to improve partner engagement strategies.
Conducted risk analysis on client portfolios and provided data-driven insights.
Streamlined reporting processes, improving data accuracy and efficiency.

Associate Business Analyst

Tata Aig General Insurance

Ahmedabad

08.2022 - Current

Collected and analyzed business data to support strategic initiatives.
Collaborated with cross-functional teams to identify process gaps.
Created performance reports and presented insights to stakeholders.
Monitored KPIs and recommended optimization strategies.
Supported solution development aligned with business requirements.

Education

Bachelor of Engineering - Automotive Engineering

Marwadi Education Foundation Group of Institution

Rajkot

Skills

Analytics Tools: SQL, Advanced Excel, Power BI, Data Visualization
Business Analysis: Requirement Gathering, BRD/FRD, Stakeholder Management, Process Mapping, Gap Analysis

Data Proficiency: KPI Tracking, Data Cleaning, Trend Analysis, Reporting
Methodologies: Agile Basics, SDLC, Root Cause Analysis

Projects

Sales Performance Dashboard (Power Bi)

Built an interactive dashboard to track revenue, partner performance, and conversion rates.
Used Power BI to visualize KPIs and identify underperforming segments.
Improved decision-making speed by providing real-time insights to stakeholders.

Customer Rentention Analysis (Excel+SQL)

Analyzed customer data to identify churn patterns and retention opportunities.
Wrote SQL queries to extract and transform large datasets.
Provided actionable recommendations that could improve retention strategies.

Business Process Improvement (Insurance Sales)

Mapped current (AS-IS) sales processes and identified inefficiencies.
Designed optimized (TO-BE) workflows to reduce turnaround time.
Helped improve operational efficiency and reporting accuracy.

Timeline