Software Engineer
-
23 → 5minutes · 78% fasterReduced critical financial reporting time by rewriting long-running SQL with parallel-execution hints and optimised data-source selection — eliminating business-of-day delays for downstream banking ops. Java + PL/SQL refactor across the reporting batch chain.
-
145Mrecords processed · +43% throughputArchitected partition-wise data processing using 64-way hash partitioning and parallel DML across 8+ source tables — improved batch performance by 43% on the highest-volume jobs. Oracle DB tuning, partition keys, parallel hints.
-
33.7Mrows / batch · audit 2 wk → 3 daysDesigned a PL/SQL reporting engine processing 33.7M records across multiple banking channels — cutting audit cycle time from two weeks to three days for compliance reviews. PL/SQL packages, materialised views, channel-aware aggregations.
-
−65%fewer prod incidentsIdentified 80+ recurring failure patterns across core banking modules — null-path crashes, edge-case transaction handling, silent data corruption — and resolved each through targeted Java fixes and defensive refactors. No new tooling; just fixing the code. Java bug fixes · defensive guards · root-cause analysis.
-
80%manual intervention eliminatedEngineered an automated SQL/Bash file-processing recovery system that detects, retries, and logs failures end-to-end — every failure path previously requiring manual intervention now handled automatically across hundreds of monthly batch transactions. Bash orchestration + SQL transaction recovery + structured logging.
-
60+java fixes shippedShipped 60+ Java code fixes and architectural improvements across core banking modules used by tens of thousands of branches — spread across multiple production releases. Bug fixes, refactors, defensive guards, performance patches.