Lifecycle-based analytics of auto-renewal policies, analysing customer awareness, timing risk, escalation drivers, and preventable complaint patterns.

End-to-end Power BI dashboard for Shield Insurance tracking revenue, customers, DRG/DCG growth, trends, and segmentation by city, sales mode, age group, and policy ID.

Synthetic personal-lines insurance portfolio built as a governed digital twin, with dataset freezing, validation gates, and actuarial realism.

Predicting insurance charges and identifying key risk divers using regression and regularization.

Production-style regression project for predicting insurance claim amounts using advanced modeling techniques, feature analysis, and business-driven insights.

End-to-end BI project simulating and analyzing a car insurance portfolio with 1M+ records to derive insights on claims trends, loss ratio, and business risk using Python, SQL and Power BI.

Production-style ML system for automated insurance claims decisions using a SQL gold dataset, rule + model scoring, FastAPI inference, and explainable outputs.

3-page Power BI insurance report with executive KPIs, drill-through customer details, and feedback sentiment insights using a word cloud.

End-to-end motor insurance analytics project using a two-stage (hurdle) modeling approach to predict claim occurrence and claim severity. Combines business analysis, machine learning, and risk insights to support underwriting, pricing, and claims optimization in General (P&C) Insurance.

SQL + Power BI case study detecting claim severity & leakage: reserve adequacy, vendor IQR outliers, missed subrogation/late FNOL, duplicate payments. End-to-end T-SQL (staged → core → mart) + executive dashboards.

> Shield Insurance Analytics > A data-driven approach to analyzing revenue trends, customer segmentation, and sales mode performance in the insurance sector. This project provides structured insights to optimize engagement strategies, enhance policy targeting, and improve overall business decision-making.

Insurance policy and claims analytics report built with SQL Server integration, DAX lifecycle logic, and automated scheduled refresh.

Interactive Power BI dashboard built during an internship at AtliQ Technologies for Shield Insurance, analyzing ₹989M in revenue across 26K+ customers. Covers sales channel performance, age group segmentation, and monthly trends using a star schema data model, DAX measures, and Power Query transformations.

CAS Workers Compensation Reserving Case Study. Loss Development Factors, Catastrophe/Outlier Analysis, Ultimate Loss Estimates, Frequency-Severity.

Power BI dashboard for PRISM Insurance — tracks ₹5.98M premium, ₹600.55M coverage & ₹16.91M claims across Auto, Health, Life, Travel and Home policies

Insurance risk analytics for 10 Academy. Includes EDA, DVC, A/B testing, and XGBoost modeling for claim severity and pricing, with SHAP analysis.

Insurance Company Analytics is a Power BI and Excel project focused on evaluating customer demographics, total policies, and total claims. Using Excel for data preparation and Power BI for visualization, the project highlights overall company performance and key metrics to support better business decisions.

Quantify 2025 Energy Risk & Insurance Case Modeling high-loss CAT events and developing parametric risk triggers to support renewable energy expansion. Includes ML code, writing report, and Presentation.

Python based insurance analytics model demonstrating claims workflow automation, underwriitng risk segmentation, and pricing adequacy analysis.

A Power BI dashboard analyzing Shield Insurance's customer segmentation, revenue trends, and sales performance across cities, age groups, and sales modes.