Performance & test infrastructure · Client platform
Global Mass Pay FX
Modernised Java/Oracle payment services and built tests to compare their behaviour with recorded payment runs
- Optimised SQL and HEXTORAW processing, batched requests, removed redundant loops and configured shared Java thread pools, contributing to the team’s throughput increase from approximately 0.7 to 23 transactions per second
- Built a process-audit harness and JSON specification tests to replay recorded payments and verify their outputs and database changes
- Helped build services that generated JSON specification tests from recorded production payments
- Java
- Oracle SQL
- JDBC
- Concurrency
- Specification testing
Performance and specification tests
I worked across validation, enrichment, AML checks and debit/credit generation, replacing fixed file-system waits with heartbeat checks, upgrading JDBC for performance and testing, and fixing SQL race conditions
The audit harness recorded run IDs, inputs, outputs and Oracle reads and writes through start/end service calls; tests recreated the initial database state, replayed payment inputs and checked the results against the original run
Scenarios varied by currency, destination, location, contract, customer and bank; as they grew more complex, we moved from drafting individual tests with AI to generating them through services that read recorded payment information