SQL Security Alerts

This project delivered a fraud-detection system that scanned card transactions for anomalous patterns such as excessive frequency, multi-location usage without odometer changes, and unusual transaction values.

The solution combined SQL-based rule sets with Spring Boot APIs for alerting and reporting. Liquibase was used for managing schema changes, and Jenkins pipelines automated testing and deployment.

The system successfully prevented unauthorized transactions by surfacing high-risk activity before it reached downstream systems, providing real-time protection for clients.

• Developed SQL queries to detect fraudulent card activity based on configurable rules
• Integrated fraud alerts into Spring Boot backend for reporting and escalation
• Implemented Liquibase for controlled schema updates to alerting tables
• Automated builds and deployments through Jenkins CI/CD pipelines
• Validated alerting accuracy in SIT/DIT before UAT deployment
• Prevented financial losses by identifying and blocking suspicious transactions