Reimbursement Analytics Service

Backend service that computes and serves aggregate expense metrics by combining nightly-materialized snapshots with a real-time current-day delta. Executes parameterized drill-down queries using composite indexes on submitter_id, expense_type, and created_at, and evaluates statistical anomaly thresholds per organization.

Feature: Reimbursement Overview

reimbursement-analytics-service

• Serve pre-materialized nightly aggregate metrics (total claims, approved amount, avg processing time, rejection rate) per organization and time period
• Compute real-time delta aggregation for the current day and merge with snapshot figures
• Execute parameterized drill-down queries filtered by peer mentor, expense type, or date range with index-aware query planning
• Detect anomalies by comparing claim counts and expense type concentrations against the organization rolling baseline (two standard deviations threshold)
• Enforce organization scoping so each admin accesses only their own tenant data