INTERACTIVE DEMOS

Financial Services

Solana DEX Real-time AnalyticsInsurance Underwriting Risk ScoringIntraday Portfolio Risk (VaR)AML Transaction Screening

A P&C insurance carrier processes 15,000 new applications per day. Each application must be scored for fraud risk in real time — before the policy is bound — by cross-referencing the applicant against claims history, prior policy cancellations, and known fraud rings.

⚠The legacy batch scoring runs overnight. Agents bind policies during the day without fraud scores, leading to $12M in preventable fraudulent claims last year.
LIVEpolicy_applications
app_idapplicant_namessn_last4statecoverage_typepremiumvehicle_vindeclared_valuets
APP-20240315-7821Marcus D. Reeves4478FLAUTO_COMPREHENSIVE28401HGCM...4390385002024-03-15T09:14:22.000Z
APP-20240315-7822Jennifer Kowalski9213TXHOME_HO34100NULL4250002024-03-15T09:15:03.000Z
APP-20240315-7823Robert Tanaka6051CAAUTO_LIABILITY12905YJSA...7104520002024-03-15T09:15:47.000Z
APP-20240315-7824Aisha Patel3387NYRENTERS_HO4840NULL152002024-03-15T09:16:31.000Z
APP-20240315-7825Charles Beaumont7745ILAUTO_COMPREHENSIVE36703VWDX...8812449002024-03-15T09:17:08.000Z
APP-20240315-7826Diana M. Reeves4478CAAUTO_COMPREHENSIVE29502T1BU...6290310002024-03-15T09:18:14.000Z
Streaming SQLRunning
▶Cross-reference claims history✓
CREATE MATERIALIZED VIEW claims_crossref AS
SELECT
  a.app_id,
  a.applicant_name,
  a.ssn_last4,
  a.state,
  COUNT(c.claim_id) AS prior_claims_24mo,
  COUNT(DISTINCT c.loss_address_zip) AS distinct_loss_addresses,
  SUM(c.payout_amount) AS total_prior_payouts,
  MAX(c.claim_date) AS most_recent_claim
FROM policy_applications a
LEFT JOIN historical_claims c
  ON a.ssn_last4 = c.ssn_last4
  AND c.claim_date > a.ts - INTERVAL '24 MONTHS'
GROUP BY a.app_id, a.applicant_name, a.ssn_last4, a.state
HAVING
  COUNT(c.claim_id) > 2
  OR COUNT(DISTINCT c.loss_address_zip) > 1;
▶Score underwriting risk✓
underwriting_risk_scoresauto-updating
app_idapplicant_namerisk_levelrisk_scoreflagsscored_at
APP-20240315-7821Marcus D. ReevesCRITICAL1553 claims in 24mo,Claims from 2 addresses,VIN previously reported total loss2024-03-15T09:14:22.804Z
APP-20240315-7826Diana M. ReevesHIGH903 claims in 24mo,Claims from 2 addresses2024-03-15T09:18:14.612Z
APP-20240315-7824Aisha PatelLOW02024-03-15T09:16:31.203Z
✓RisingWave scores application APP-20240315-7821 at risk_level CRITICAL within 800ms: the applicant's SSN last-4 matches 3 prior claims in 18 months across different addresses, and the declared vehicle VIN was previously reported as a total loss.
Streaming
Try it live on RisingWave Cloud
Talk to Sales
Best-in-Class Event Streaming
for Agents, Apps, and Analytics
Start Free
SlackJoin our Slack
GitHubXLinkedInSlackYouTube
Sign up for our to stay updated.