SHMA Dual-Engine Actuarial Platform

SHMA APEXActuarial Processing & Execution Engine

One governed workspace uniting our Guided 5-Stage Linear Engine for quarterly valuations and Visual Workflow Studio for custom multi-source DAG pipelines.

ARCHITECTURETwo Engines. One Governed Core.
5 StagesGuided Linear Valuation
Visual DAGWorkflow Studio IDE
Parquet CASDeduplicated Dataset Library
SHMA / workflow_studio● VISUAL DAG ENGINE
MULTI-SOURCE ACTUARIAL PIPELINEVisual DAG orchestration & live profiling
VERSION v4 · DETERMINISTIC
Stage 01 · Claims & Policy Enrichment · 4 tools grouped✓ Executed · 410ms
IN/OUT▶
Excel InputClaims_Paid_Q4.xlsx
CAS LIB▶
Dataset InputLOB_Taxonomy_v3
JOINLJR
Multi-Anchor JoinPolicy_ID · 100% match
FORMULA▶
Incurred Loss[Paid] + [Case_Rsv]
SUMMARIZE✓
LOB & Accident YrExport + CAS Parquet
128,450 rows processed · 0 schema drift✓ Saved to Workspace & Dataset Library
SHMA / linear_valuation● GUIDED 5-STAGE ENGINE
QUARTERLY PORTFOLIOPremium & loss reconciliation
Q4 2026 · PRIVATE
$1.8B$1.2B$600M$0
202120222023202420252026
Written premium Incurred loss✓ Reconciled to P&L
DUAL-ENGINE ARCHITECTURE

Two engines.
One governed workspace.

Run standardized quarterly valuations on rails, or design custom multi-source pipelines visually in Workflow Studio.

01 · Guided Linear Engine5-STAGE RAILS

Standardized Valuation Pipeline

Built for repeatable quarterly reserving with sequential stage sign-off, LOB mapping, and P&L reconciliation.

01 Raw Intake→02 Clean & Dates→03 LOB Map→04 P&L Recon→05 Compile
  • ✓Exception-first LOB mapping with interactive unmapped key resolution.
  • ✓Automated P&L variance checks reconciled directly against client accounts.
  • ✓Formula-safe master compilation preserving native Excel workbook formulas.
02 · Visual Workflow StudioINFINITE DAG CANVAS

Visual Actuarial ETL & Data Studio

Interactive node-based IDE for multi-sheet joins, custom reserving formulas, quality gates, and reusable Parquet datasets.

Excel / CAS Input→Join · Filter · Union→Formula · Summarize→Stage Containers→Deliverables
  • ✓Multi-anchor visual tools for L/J/R Joins, Filters, Deduplicate, and Validation rules.
  • ✓Collapsible Stage Containers with live timing, branch muting, and safe bypass.
  • ✓Results Studio & CAS Library for instant profiling and cross-workflow dataset reuse.
Unified Client → Valuation Quarter → Portfolio → Stream GovernanceBoth engines share one workspace hierarchy, encrypted CAS datasets, version snapshots, and audit trails.
Conventional · Takaful · LifeEncrypted CAS StorageFull Audit Trail
WHY SHMA APEX

Built for the way SHMA actuaries work.

From standardized Gross Claims valuations to custom multi-sheet reserving pipelines in Workflow Studio, every transformation, reconciliation, and deliverable stays traceable in one workspace.

THE WORKFLOW

Less time preparing.
More time actuarial.

Switch between visual DAG engineering and guided 5-stage valuation execution.

01

Connect Workbooks & CAS Datasets

Ingest multi-sheet Excel files from the workspace or pull versioned Parquet tables directly from the Dataset Library.

↗
02

Join, Filter & Reconcile Streams

Combine policy, premium, and claims extracts with L/J/R Join anchors, Union stacks, Deduplicate keys, and Validation gates.

↗
03

Author Actuarial Formulas & Summaries

Build lossless decimal expressions, multi-row lags, cross-tab triangles, and LOB aggregations with live syntax & sample-row previews.

↗
04

Group into Stage Containers

Organize large graphs into collapsible, color-coded stages with one-click branch mute, safe bypass, and execution timing.

↗
05

Profile, Version & Export

Inspect intermediate tables in Results Studio, snapshot pipeline versions, and publish clean Excel deliverables or reusable CAS datasets.

↗
PLATFORM CAPABILITIES

Built around
the work.

☍

Visual DAG Studio

Drag-and-drop preparation, joins, unions, filters, and sorting on an infinite canvas with live schema propagation.

WORKFLOW STUDIO
▣

Stage Containers & Versioning

Encapsulate pipeline phases into collapsible stages with branch muting, 1-to-1 bypass, and snapshot version control.

ORCHESTRATION
◈

Encrypted Dataset Library

Persist intermediate or final outputs as content-addressed Parquet datasets to share cleanly across workflows.

CAS STORAGE
∑

Actuarial Formulas & Pivots

Compute incurred losses, multi-row lags, running totals, cross-tabs, and grouped summaries with decimal precision.

COMPUTATION
⚖

P&L Variance Reconciliation

Cross-check mapped valuation streams against management accounts and log every manual adjustment reason.

LINEAR ENGINE
⌘

Source-to-Report Lineage

Maintain an auditable trail from raw client uploads through every node and stage to final compiled deliverables.

GOVERNANCE
FOR THE SHMA TEAM

Make actuarial work easier to trust.

Sign in to APEX ↗