Tech: Java, Spring Boot, Oracle SQL/PLSQL, IBM MQ, REST APIs (Swagger/OpenAPI), Autosys, Splunk, Excel
- Built and supported a global accounting control platform processing trade/settlement/valuation events across legal entities; applied accounting rules to generate debit/credit postings and deliver SAP GL regulatory feeds.
- Enhanced production data hygiene through implementation of Oracle CRs to purge stale balances, mitigating operational risk associated with obsolete balance records.
- Diagnosed and optimized IBM MQ adapter performance by replaying stored messages via Swagger APIs and benchmarking end-to-end latency using timestamp-driven measurements to isolate bottlenecks.
- Increased EOD batch reliability by triaging Autosys job chains, tracing failures to Spring beans and Oracle SQL, and delivering fixes to restore chained processing and downstream feed generation.
- Optimized operational monitoring by developing Splunk dashboards for region-wise EOD runs and automating job status and runtime metadata reporting for stakeholders.
- Managed go-live migration configuration by translating BA requirements into Oracle policy inserts across regions.
- Minimized deployment risk by preparing rollback-ready CR scripts and creating SQL validation checks to ensure integrity of config insertions, addressing duplicates and missing mappings.
- Eliminated posting defects by identifying configuration mismatches vs legacy setups, correcting policy rules/mappings, and retesting until expected debit/credit postings were consistently generated.