insurance-analytics

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.

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.

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.

Insurance fraud detection case study using exploratory data analysis, machine learning, and business-focused model evaluation.

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

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.

보험설계사들을 위한 영업 에이전트, 기록 서비스

End-to-end motor insurance claim frequency modelling using a Poisson GLM for actuarial pricing, risk analytics and underwriting decision support.

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.

Insurance portfolio analytics project using SQL, Python, and Power BI to evaluate profitability, claims risk, broker performance, payment behavior, and customer retention.

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

End-to-end insurance data platform: extracts from Postgres, JSON/SFTP, CSV, and a weather API into S3, validates with Great Expectations, transforms with pandas, and loads a Snowflake star schema. Orchestrated with Airflow, both locally via Docker and in production on Amazon MWAA.

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.

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.