One governed workspace uniting our Guided 5-Stage Linear Engine for quarterly valuations and Visual Workflow Studio for custom multi-source DAG pipelines.
✓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.