A collection of SQL queries designed to detect common fraud patterns in financial transactions, account activity, and claims data.
This repository contains SQL queries I've developed based on my experience in Medicare compliance and risk assessment. These queries can be adapted for various fraud detection scenarios including:
- Transaction monitoring
- Account takeover detection
- Claims fraud identification
- Duplicate payment detection
- Velocity checks
Identifies potential duplicate transactions that may indicate fraud or system errors.
Flags transactions that deviate significantly from normal behavior patterns.
Detects accounts with unusually high activity rates that may indicate fraud.
Identifies suspicious patterns across multiple accounts.
- SQL query optimization
- Pattern recognition and anomaly detection
- Data aggregation and statistical analysis
- Fraud prevention logic
These queries are designed for:
- Financial institutions
- Healthcare/insurance companies
- E-commerce platforms
- Any organization processing high-volume transactions
K.A. Spears - Fraud & Risk Analyst | LinkedIn