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.

Production-ready analytics portfolio for Saif Essam, featuring CRM, sales, insurance, statistical modelling and R Shiny projects.

An end-to-end data analytics project analyzing policy lapsation and customer retention for an Indian insurance company — ShieldLife Insurance — built to simulate a real-world BFSI analytics workflow.

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

End-to-end Databricks/AWS lakehouse project with Bronze/Silver/Gold layers, GDPR-aware data quality, dashboard views and AI-ready fraud analytics.

Insurance analytics project comparing flat vs risk-based pricing under catastrophe risk using A/B testing, Monte Carlo simulation, VaR/TVaR, and Streamlit.

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 regression project for predicting insurance claim amounts using advanced modeling techniques, feature analysis, and business-driven insights.

Data management project building an Insurance Analytics Base Table (ABT) in MySQL + R, with data quality checks, winsorisation, and channel/product insights.

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

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.

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.

Analytics project delivering real‑time visibility of premium limits across complex portfolios. Transforms raw submissions into forward‑looking risk intelligence with early‑warning thresholds and capacity insights, enabling controlled growth, revenue protection, and governance‑ready decision‑making.

> 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.

Power BI dashboard analyzing insurance premiums, policy distribution, and business insights using interactive visualizations.

Automated MDV reporting pipeline using Synapse, Power BI Paginated Reports, and Power Automate for compliant vehicle insurance data delivery.

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

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

Collection of end-to-end financial analytics and machine learning projects including credit risk modeling, customer segmentation, and insurance premium prediction.