Claims, premium collections, renewals and underwriting across health, motor and commercial (P&C) insurance.
The retail health claims ratio jumped from about 73% to over 90% in six months. Find out why — new product, suspicious hospitals, claims leakage or the monsoon — and what it is costing.
Suraksha General Insurance Ltd · SQL, Python (pandas, seaborn)
A commercial insurer's overdue premium has piled up and fewer clients are renewing. Reconcile bank receipts to invoices, find the VAT errors, age the debt by broker and show how unpaid premium is costing renewals.
Dunecrest General Insurance PJSC · SQL, Python (pandas, seaborn)
Build the Head of Motor Claims' monthly Power BI dashboard from raw claim extracts: clean the data in Power Query, model six tables, write DAX for TAT, SLA and leakage, and find why the North is slowing down and which garages look like fraud.
Kaveri General Insurance Ltd · Power BI Desktop, Power Query, DAX
Claims, premium collections, renewals and underwriting across health, motor and commercial (P&C) insurance.
The retail health claims ratio jumped from about 73% to over 90% in six months. Find out why — new product, suspicious hospitals, claims leakage or the monsoon — and what it is costing.
Suraksha General Insurance Ltd · SQL, Python (pandas, seaborn)
A commercial insurer's overdue premium has piled up and fewer clients are renewing. Reconcile bank receipts to invoices, find the VAT errors, age the debt by broker and show how unpaid premium is costing renewals.
Dunecrest General Insurance PJSC · SQL, Python (pandas, seaborn)
Build the Head of Motor Claims' monthly Power BI dashboard from raw claim extracts: clean the data in Power Query, model six tables, write DAX for TAT, SLA and leakage, and find why the North is slowing down and which garages look like fraud.
Kaveri General Insurance Ltd · Power BI Desktop, Power Query, DAX