Saurabh Pandey
Business Analyst | 7+ Years Experience in Banking & Insurance
Malad east
Summary
Results-driven Business Analyst with 7+ years of experience in insurance & Banking Industry, specializing in business process analysis, digital transformation, and stakeholder engagement. Skilled in leading and mentoring team members, driving cross-functional collaboration, and delivering data-driven insights to optimize performance and support strategic growth.
Overview
7
7
years of professional experience
40
40
years of post-secondary education
3
3
Languages
Work History
Senior Manager
Kotak Mahindra Life Insurance Company
12.2024 - Current
- Design, develop, and manage comprehensive MIS dashboards and reports to support strategic and operational decision-making.
- Manage, lead, and mentor a team of 12 members, ensuring productivity, skill development, and delivery excellence.
- Support top management with customized analytical reports for strategy formulation, budgeting, and forecasting.
- Ensure timely and accurate preparation of daily, weekly, monthly, and ad-hoc reports for senior management, regulatory authorities (IRDAI), and other stakeholders.
- Automate and optimize reporting processes through advanced Excel, SQL, and BI tools (Power BI/VBA), reducing manual effort, and improving accuracy.
- Analyze business data to identify trends, variances, and potential risks or opportunities in sales, claims, underwriting, and renewals.
- Collaborate with cross-functional teams (external stakeholders, Sales, Operations, IT, Finance, Compliance, Product) to align MIS with organizational goals, and act as a bridge between business teams and cross-functional teams for systems enhancements, data quality, and process automation.
- Partner with product, actuarial, and underwriting teams to design and launch new life insurance products.
- Lead digital transformation initiatives, such as AI-driven underwriting, RPA in claims, and the Policy Issuance Process.
- Collaborate with legal and compliance teams on product approvals and process changes.
Manager - Business Analyst
TATA-AIG General Insurance Company Limited
07.2018 - 12.2024
- Collaborate with cross-functional teams to identify business needs, and develop solutions.
- Conducted detailed business analysis and provided actionable insights to improve business processes, increase business, and enhance efficiency.
- Worked with the client (Axis Bank) to understand business requirements and develop tailored solutions.
- Conduct data analysis and create FTD, MTD, and YTD reports to inform business decisions.
- Coordinate with Sales and other departments of the head office, and prepare meaningful MIS/reports on logins, issuance, and also highlight improvement areas on a daily basis.
- Identifying key areas of non-performance by analyzing the historical data on a regular basis.
- Prepare monthly, quarterly, and yearly review data and presentations for the business head, organize team reviews, and execute the actionable.
- Prepare business campaign reports of partner and managed R&R.
- Preparing channel targets and sales team KPI targets for the business head.
- Preparing an analysis of the business GWP data, retention data, and penetration trends pertaining to the channel business.
- Prepare MIS based on projects, and establish the accuracy, continuity, and availability of information to the management.
- Managed Compliance and Grievance Team complains and coordinates with respective stakeholders for the resolution.
- Prepare and publish state/region-wise dashboards to the internal and external stakeholders regarding policy issuance.
- Managing the PAN India EDI Policy Issuance Process of the Channel Bancassurance pertains to the Axis Bank project.
- Developed and maintained comprehensive documentation, including business requirements, process flows, and user guides.
- Preparing monthly KPI reports for the Retail Assets Sales Team for sales incentives.
- Tracking of business and timely completion of training/refresher trainings on a regular basis for all verticals in the Assets Division (Mortgage, Wheels, CBG, AGRI, SBB, and Axis Finance).
- Managed Policyholders' Payouts Processing and Vendor Payment Management.
Education
MBA - Finance
Atharva Institute of Management Studies
Mumbai, India 04.2001 - 07.2024
BBA - Financial Management
Mumbai University
Mumbai, India 04.2001 - 03.2018
Skills
- Skilled in complex Excel data analysis
- Interactive dashboard development
- VBA automation
- Power BI data visualization
- PowerPoint design
- Project Management
- Collaboration skills
- Process improvement
- Stakeholder engagement
Personal Information
- Hobbies: Playing Cricket, Traveling to Mountains
- Father's Name: Birendra C. Pandey
- Date of Birth: 03/09/97
- Nationality: Indian
- Marital Status: Married
Timeline
Senior Manager
Kotak Mahindra Life Insurance Company
12.2024 - Current
Manager - Business Analyst
TATA-AIG General Insurance Company Limited
07.2018 - 12.2024
MBA - Finance
Atharva Institute of Management Studies
04.2001 - 07.2024
BBA - Financial Management
Mumbai University
04.2001 - 03.2018
Similar Profiles
LALIT VIJAY YADAVLALIT VIJAY YADAV
Senior Manager at Kotak Mahindra Life Insurance Company LimitedSenior Manager at Kotak Mahindra Life Insurance Company Limited
Soni ShuklaSoni Shukla
Senior Manager at Kotak Mahindra Life Insurance CompanySenior Manager at Kotak Mahindra Life Insurance Company
Varun KadamVarun Kadam
Business Development Manager at Kotak Mahindra Life Insurance CompanyBusiness Development Manager at Kotak Mahindra Life Insurance Company
RAJVI M PATELRAJVI M PATEL
Senior Fashion Consultant at LITTLE TAGS LUXURY SPARSH INDIASenior Fashion Consultant at LITTLE TAGS LUXURY SPARSH INDIA
Dr. Shweta Todankar SalunkeDr. Shweta Todankar Salunke
Senior Manager at Tata AIGSenior Manager at Tata AIG