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%production incidentsBuilt a proactive monitoring and alerting framework targeting 80+ failure patterns alongside Java optimisations — cut production incidents by 65% across core banking modules. Pattern-based alerting + Java-side defensive fixes.
-
100%recovery automationEngineered an automated SQL/Bash file-processing recovery system that detects, retries, and logs failures end-to-end — eliminating manual intervention for hundreds of monthly transactions across batch pipelines. 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.