Aegis: The Insurance Reserving Solution Built by Appointed Actuaries

One insurance reserving solution carries you from claims data to board-ready IBNR in hours, with every judgment recorded.

Professional insurance reserving solution interface displayed on a laptop featuring the Aegis platform login screen in a modern corporate workspace with a realistic actuarial software environment.

Prima Consulting provides reserving and valuation for insurers across the GCC, Asia and Europe

Aegis is the platform our own actuaries built to run that work: an insurance reserving consultancy with its own software, not the other way around.

Why Insurers Need an Insurance Reserving Solution

Most insurers do not have a real insurance reserving solution. They have spreadsheets, and the cracks show every quarter end.

  • Manual data checks eat up to a day before analysis even starts
  • Triangles get rebuilt by hand in Excel or a separate tool each cycle
  • Excluded link ratios and loss development factors go unrecorded
  • SAMA reserving templates are populated manually, quarter after quarter
  • Reserve movement gets explained from memory, not from a system
Comparison graphic highlighting manual spreadsheet processes versus an automated insurance reserving solution with an actuarial dashboard, claims triangle, and reserve analytics.
Watch Aegis Run Your Lines of Business

The Actuarial Reserving Solution That Replaces the Spreadsheet Chain

Aegis turns reserving calculations into a guided workflow, from raw claims data to a signed reserve.

  • Claims triangles build automatically, with a triangle heat map that flags outliers on sight.
  • Chain ladder, Bornhuetter-Ferguson and expected loss ratio methods run together for instant comparison.
  • Loss development factors and CDFs stay visible and overridable, with every change logged for audit.
  • The SAMA reserving template generates in one click, covering gross, salvage and reinsurance triangles.
  • An automated reserve movement waterfall explains every change in language your board understands.
  • Reinsurance, salvage, subrogation and UPR are handled inside the same valuation, not a side file.
The problems Aegis solves

Quarter-End Should Not Run on Fragile Files

Six failures that Excel-based reserving repeats every cycle, and how Aegis closes each one.

Quarter-end runs on fragile files

What teams need: Data checked and triangles built without losing a day to pivots and linked workbooks.

How Aegis solves it: Data arrives by upload or API, the validation layer checks it on arrival, and triangles generate inside the platform.

  • A full day of manual checks removed
  • History stored once, not rebuilt
  • Heat map colors outliers on sight

No record of which link ratios were excluded

What teams need: Judgment calls recorded, not reconstructed from memory when the auditor asks.

How Aegis solves it: LDFs appear period by period; toggle link ratios, pick an average, override any CDF with the change recorded.

  • Every override and exclusion logged
  • Full LDF and CDF control per period
  • Chain ladder, BF and ELR side by side

Reserve movement explained from memory

What teams need: A CFO answer in minutes, with drivers the board can read.

How Aegis solves it: An automated waterfall decomposes each period's change into named drivers.

  • Drivers ready for the board pack
  • Click a cell to open the claims
  • Explain a number, not defend it

The SAMA return takes days by hand

What teams need: Quarterly triangle submissions in fixed format without week-three delays.

How Aegis solves it: The SAMA template generates in one click; Prima maintains the logic in-house.

  • One click per quarter
  • Gross, salvage-adjusted, reinsurance-net
  • Format changes absorbed in days

The process depends on one actuary

What teams need: A process the whole team can run, not one locked in a senior's laptop.

How Aegis solves it: A guided wizard lets a junior produce a defensible first cut; the actuary reviews.

  • Structured, recorded steps throughout
  • Role-based access for entry and review
  • Appointed actuary reviews, not rebuilds

Actuarial and accounting numbers in separate files

What teams need: An IBNR figure split by segment and accident period, ready for IFRS 17.

How Aegis solves it: Aegis hands IFRS 17 a segmented figure, with a direct hand-off to Delta.

  • Outputs structured for IFRS 17
  • Direct hand-off to Delta
  • Multi-region Solvency II support

The Aegis Reserving Process

Build triangles, review loss development factors, project ultimates, select reserves by accident period. Aegis turns the sequence into a guided workflow so the mechanics run themselves and the judgment stays visible.

Step 1:
Configure
Define reserving segments once, by line, product or payor, each on the basis you choose (paid or incurred), the cohort (accident or underwriting year), and quarterly or annual lags. OUTPUT: Reusable segment architecture, set up once and reused every quarter.
>>>
Step 2:
Build Triangles
Triangles generate automatically from transactional claims data, with a heat map that colors the largest values so outliers stand out on sight. OUTPUT: Cumulative, incremental, frequency and average-claim triangles from raw data.
>>>
Step 3:
Select Factors
Large claim analysis splits attritional and large claims by percentile, threshold or multiple. LDFs appear period by period; toggle link ratios, pick an average, override any CDF with the change recorded. OUTPUT: Documented LDF and CDF selections, every change logged.
>>>
Step 4:
Run Methods
Chain ladder, Bornhuetter-Ferguson and expected loss ratio run together, so method disagreement is visible immediately. Trend and premium on-level adjustments sit in the same screen. OUTPUT: Ultimate claims from all methods, side by side.
>>>
Step 5:
Select and Report
Blend method weights by accident period or set a manual ultimate, each selection carrying an audit record. One valuation produces the report, Excel packs, the SAMA template, a board deck and IFRS 17 inputs. OUTPUT: Regulator-ready and board-ready reporting from a single valuation.
Step 1
Discovery & Process Mapping
Structured interviews with key staff capture how work is actually done. A process map identifies what needs to be documented and in what order.
Step 2
Gap Analysis & Prioritisation
For review engagements: existing documentation is assessed against current practice and compliance requirements. For creation engagements: scope is defined and prioritised by operational risk.
Step 3
SOP Drafting & Formatting
Procedures are written in plain operational language and formatted for daily use. Each document is structured with clear ownership, version control, and review dates.
Step 4
Review & Staff Validation
Draft procedures are reviewed by the staff who will use them. This step identifies anything that does not reflect operational reality before final approval.
Step 5
Handover, Training & Review Cycle Setup
Final documentation is handed over with an implementation guide, a training briefing for managers, and a scheduled review calendar so the documents stay current.

What Aegis Includes

Feature What It Means for Your Reserving Process
Segment Architecture Define reserving segments once, by line, product or payor, and reuse them every quarter without rework.
Automatic Triangle Generation Cumulative, incremental, frequency and average-claim views build from raw data, which removes the slowest step of the quarter.
Triangle Heat Map Color-graded cells make outliers visible in seconds rather than after review.
Claim-Level Drill-Down Every triangle cell opens to its claims, so audit queries end in clicks instead of meetings.
Attritional and Large Claim Split Thresholds by percentile, value or multiple keep shock losses from distorting development patterns.
Full LDF and CDF Control Toggle, average, and override link ratios per period, with each change recorded for review.
Three Methods Together Chain ladder, BF and ELR run in parallel, which shortens selection and exposes method disagreement early.
Blended Ultimate Selection Weight methods per accident period or enter a manual ultimate, and keep the reasoning on file.
Trend and On-Level Adjustments Claim trend, premium on-level and efficiency factors apply inside the workflow.
Reserve Movement Waterfall Period-on-period drivers produce themselves, ready for the board pack.
UPR in the Valuation Summary Unearned premium reserve sits beside IBNR, replacing an error-prone finance-system pull.
Salvage, Subrogation and Reinsurance Handling Separate triangles or net-to-gross ratios, configured per segment.
Validation Layer with Bespoke Rules Standard checks plus client-specific tests, for example duplicate detection or premium reasonableness by risk.
Multi-Format Reporting Word, PDF, Excel, SAMA template and board presentation from a single valuation.
Multi-User Roles Separate permissions let claims and premium staff load files in parallel while review stays with the actuary.
Built for the region

Reserving Software for Saudi Arabia, the GCC and Beyond

Global platforms are scoped for global carriers and none of them mention SAMA. Aegis was built with KSA reporting in the core design, then extended for European markets.

Motor and Medical

IBNR calculation for motor and medical insurance is the most common GCC configuration, with quarterly triangles and large-claim thresholds per line.

Property, Marine, Engineering

These segments run in the same structure, with granularity down to product and payor level, a request from our European partners.

Takaful

Takaful segments configure alongside conventional lines, using the same triangle, method and reporting workflow.

IFRS 17 and Europe

Aegis hands IFRS 17 an IBNR figure split by segment and accident period, with multi-region reporting for Solvency II environments.

Reinsurance and Recoveries

Reinsurance runs through net-to-gross ratios or separate triangles; salvage and subrogation run as their own triangle within a segment.

French-Speaking Markets

A French-language variant of the product interface is planned, where demand for logiciel actuariel reserving is steady.

Proof

Measured on Real Reserving Work

Process Results

  • The validation layer absorbs the day of manual checking each cycle demanded
  • SAMA templates that took days generate in one click
  • First-cut reserves move from multi-week assembly to hours of review
Days → Hours
First-cut reserving cycle

Methodology and Standards

Aegis applies standard actuarial reserving methodology, chain ladder, Bornhuetter-Ferguson and expected loss ratio, with documented factor selection at every step. Outputs are structured for external actuarial review, IFRS 17 measurement and SAMA return formats, reviewed by Prima's practicing actuaries against regional expectations.

Replace Excel Actuarial Reserving: The Before and After

The reserving transformation is easiest to see side by side.

The Excel-based quarter The Aegis quarter
Up to a day of manual data checksValidation layer flags issues at upload
Triangles rebuilt in spreadsheets or a separate Alteryx stepTriangles generate inside the platform
History re-uploaded and re-reconciled each cycleHistory stored once; only the new period loads
SAMA template populated by hand over daysOne click per quarter
Reserve movement reconstructed from memoryAutomated waterfall with named drivers
UPR pulled from a finance system with known errorsUPR calculated within the valuation summary
Appointed actuary rebuilds everythingInternal team runs the first cut; the actuary reviews and signs
No record of judgment callsEvery override and exclusion logged

An Insurance Reserving Consultancy That Built Its Own Tool

Actuaries sometimes say that reserving tools from consulting firms treat software as a side business. At Prima, the relationship runs the other way: Aegis is the platform our own actuaries use on reserving engagements, so a neglected release would break our own work first. It has a dedicated product team and a public roadmap reviewed each quarter. Appointed actuary reserving support is part of the offer: our actuaries help with method questions, assumption reviews and regulator conversations, not just login resets.

Machine Learning Reserving: What Is Real Today

Today, the platform runs deterministic methods with full actuarial control. In development: AI-assisted selection that studies your historical patterns and suggests method weights and LDF exclusions, so a junior actuary starts from a sensible first cut. The actuary always decides; the model only proposes. For stochastic work, triangles export cleanly to R and Python today, with native stochastic methods on the published roadmap.

Reserving in Insurance Is Not Getting Simpler

Aegis is the actuarial reserving solution built by the same actuaries who sign the reserve reports it produces. Reserving in insurance decides how much an insurer holds for claims that have already happened, which is why the number carries weight with regulators, auditors and the board.

IFRS 17 reserving pulled that number onto the financial close calendar, and SAMA turned it into a quarterly submission. Reserving software built for global carriers rarely accounts for either. Aegis was designed as reserving software for Saudi Arabia, the GCC and the Middle East from day one, then extended for European markets, and it comes from an insurance reserving consultancy: Prima’s own actuaries provide appointed actuary reserving support whenever it is wanted, not just a login and a manual.

Corporate insurance reserving solution dashboard illustrating IFRS 17 reserving, SAMA reporting, reserve movement analysis, and actuarial workflows within the Aegis platform.

Put an Insurance Reserving Solution Behind Your Next Quarter

Aegis exists because our own actuaries were tired of fragile files, manual SAMA returns and reserve movements explained from memory. The result is an insurance reserving solution your team can run, your appointed actuary can sign, and your board can actually read. The demo takes 15 minutes with an actuary, not a salesperson.

Frequently Asked Questions

Reserving in insurance estimates the funds an insurer must hold for claims that have already occurred, reported or not. The main components are case reserves, IBNR, IBNER and the unearned premium reserve, estimated from loss development triangles using methods such as chain ladder and Bornhuetter-Ferguson.

IBNR reserving estimates liabilities for claims incurred but not reported, plus further development expected on known claims. It is typically the largest judgment-driven reserve on a general insurer's balance sheet. Aegis calculates IBNR by segment and accident period, with every method choice and override recorded.

Build development triangles, review loss development factors, project ultimate claims with one or more methods, then select final reserves by accident period. Aegis runs this as a guided wizard so the mechanics happen automatically and every judgment stays visible.

Triangles generate inside the platform instead of a spreadsheet chain. History loads once instead of being rebuilt every cycle, the SAMA template generates in one click instead of manual population, and every override is logged instead of living in someone's memory.

Yes. The guided wizard structures each step, from triangles to ultimate selection, so a junior actuary can produce a defensible first cut. Senior actuaries and the appointed actuary then review rather than rebuild.

Aegis outputs, full triangles, documented factors and claim-level drill-down, are built for external review. Prima's own actuaries also offer appointed actuary reserving support for method questions and regulator conversations, if wanted.

Data moves encrypted by secure upload or API, with role-based access separating claims entry, premium entry and actuarial review. Historical data is stored once, under version control, and never re-imported, and every change carries an audit record. Hosting and certifications are agreed during scoping.

One-time setup, loading history, defining segments and configuring validation, takes a few weeks. After that, each quarter adds only the new period.

Yes. Reinsurance runs on a net-to-gross ratio or separate triangles, and salvage and subrogation can be modeled as their own triangle, configured once at setup.

Yes. IBNR calculation for motor and medical insurance is the most common GCC configuration, alongside property, marine, engineering, health SME and takaful segments.

Claims reserving in general insurance arranges historical claims into development triangles, projects each accident or underwriting year to ultimate cost, and holds the gap above paid-plus-case as IBNR. Aegis automates the arrangement and projection.

Yes. Aegis runs as cloud actuarial reserving software, with data arriving by secure upload or API. Hosting region and on-premise options are agreed during scoping.

Yes, in one click per valuation, covering gross, salvage-adjusted and reinsurance-net triangles. Prima maintains the template logic in-house, so SAMA IBNR submission changes are absorbed in days.

Chain ladder, Bornhuetter-Ferguson and expected loss ratio ship today. Stochastic methods are on the roadmap, and triangles export cleanly to R and Python for teams running bootstrap or Mack analysis now.

Machine learning reserving covers AI-assisted method and factor selection. Aegis runs deterministic methods today with full actuarial control. AI-assisted selection that suggests weights and LDF exclusions is in development, with the actuary always deciding. Machine-led reserving is a direction, not a current claim.

IBNR covers claims that have occurred but have not yet been reported. IBNER covers further development expected on claims that are already known and reported. Aegis reports both as part of the same insurance reserving process.

Chain ladder projects purely from observed development, so it reacts fast but swings on immature accident years. Bornhuetter-Ferguson blends observed development with an expected loss ratio, which stabilizes early periods. Aegis runs both together, so you compare rather than commit upfront.

Not at Aegis. Reserving tools built by consulting firms sometimes are, which is a fair concern. Aegis is the platform Prima's own actuaries use on reserving engagements, so it has a dedicated product team and a roadmap reviewed every quarter, not a side project.

Aegis provides a one-page business case pack: current Excel-cycle cost against Aegis, built for the internal approval conversation. Tool selections often stall at budget approval rather than at technical fit. If you have already chosen a reserving tool once and watched the budget stall, this pack is built for whoever stalled it.

A French-language variant of the product interface is planned for French-speaking European markets, where searches for "logiciel actuariel reserving" show steady demand. Aegis already supports multi-region reporting for Solvency II environments in the meantime.

Three things. The close calendar slips, because finance waits on reserves that arrive in week three instead of week one. Audit hours and findings increase, because every figure needs manual reconstruction to defend. And senior actuaries spend their time assembling data instead of exercising judgment, while junior actuaries cannot produce a first cut, which leaves the whole process dependent on one or two people.

Every triangle cell opens to the underlying claims, with counts, averages and development periods. An auditor's question about a specific number is answered by clicking the cell it came from, not by reconstructing the calculation from scratch.

Segments can be defined at line of business, product, or payor level. Payor-level granularity was added at the direct request of our European partners, and the same structure works for GCC and Asian portfolios.

Aegis produces IBNR by segment and accident period in a structure that maps directly to the liability for incurred claims. Insurers using Delta, the IFRS Tech IFRS 17 engine, get a direct hand-off from Aegis reserving output into IFRS 17 measurement and disclosure, so the actuarial number and the accounting number come from the same data.

Bespoke agentic AI is a purpose-built AI agent scoped to one narrow task for a specific client, separate from the platform's built-in AI-assisted selection. An example already in use: an agent that monitors medical claims for new development patterns after a government portal integration changed notification speed. These are client-specific builds, not a general-purpose feature.

Fifteen minutes with a practicing actuary on a portfolio like yours, then an optional scoping call on segments, data and price. No obligation either way.

Prima Consulting

Actuarial Advisory With Its Own Technology

Contact Us

Ready to elevate your business with Prima Consulting? Fill out the form below to discuss your needs with our experts and discover how we can help you achieve your business goals.

Your benefits:
What happens next?
1

We Schedule a call at your convenience 

2

We do a discovery and consulting meeting 

3

We prepare a proposal 

Schedule a Free Consultation