Engineered the end-to-end Treasury Module covering the full business lifecycle - Bank Facility creation, loan disbursement, markup/accrual calculation, loan payments, finance forward booking, loan tagging, and GL posting on Oracle Fusion serving as the sole developer and technical owner of the module.
Built and maintained Oracle APEX applications for Treasury and RMG modules, developing interactive forms, business logic, and validations entirely through SQL, PL/SQL, procedures, and packages, translating complex client requirements into functional workflows.
Refactored the core accrual calculation procedure from scratch, cutting code length by 56% while eliminating edge case gaps in the original logic - resulting in a more maintainable, accurate, and debuggable procedure across all accrual-dependent workflows.
Resolved database concurrency issues by implementing row-level locking strategies within PL/SQL procedures, preventing data conflicts in high-volume, multi-user transaction environments.
Designed and optimized custom Oracle EBS reports from scratch and enhanced existing reports for clients including Bank Alfalah, Chase Up, and PBIT - leveraging advanced SQL and query tuning to meet performance and business requirements.
Integrated SOAP and REST APIs directly into PL/SQL procedures and packages, enabling automated data exchange between Oracle EBS and external systems while maintaining data integrity and security.
Integrated Oracle EBS with Oracle Cloud via Oracle APEX, enabling real-time data synchronization across platforms and reducing manual reconciliation overhead.
Collaborated with cross-functional teams across requirement gathering, solution delivery, and post-deployment support, maintaining system stability and minimizing operational downtime.
