Nahar Eshita

• Developed and optimized complex PL/SQL stored procedures, functions, packages, and triggers for high-availability enterprise applications, improving
performance by 60%.
• Collaborated with business analysts and stakeholders to analyze system requirements, perform gap analysis, and translate business needs into
technical solutions throughout the full SDLC.
• Designed and implemented efficient relational database schemas and data models supporting scalable enterprise application architectures.
• Enhanced query performance via advanced indexing, query optimization, and PL/SQL code tuning; diagnosed and resolved performance issues
across Oracle environments.
• Developed 250+ PL/SQL scripts; implemented batch jobs using Oracle 12c, reducing manual processing by 70%.
• Integrated Oracle Forms and Oracle Reports with PL/SQL backend to ensure data integrity and improve performance by 20%.
• Prepared and maintained technical documentation including system workflows, data models, and architecture specs; provided project status reports to
stakeholders.
• Managed source code versioning using Git, supporting smooth deployment and post-production maintenance across environments.
• Streamlined ETL workflows using advanced data transformation techniques, substantially improving processing efficiency across large-scale
environments.

• Designed, developed, and maintained Oracle APEX applications and Task Flows for Core Banking, Agent Banking, and NBFI solutions (Bank Asia,
Jamuna Bank, City Bank etc.).
• Centralized the Transaction Module Engine, achieving an 80% reduction in repetitive SQL query requests through query optimization and advanced
indexing.
• Integrated 50+ transactional APIs and published 30+ banking APIs using Oracle REST Data Services (ORDS), enabling seamless integration with
external systems.
• Strengthened system security by implementing JWT, OAuth2, and 2FA authentication protocols across multiple banking platforms.
• Designed relational database schemas and performed data modeling for high-volume transactional banking systems.
• Mitigated fraud by 30% through enhanced validation and verification mechanisms for Agent users.
• Conducted debugging, troubleshooting, and post-deployment maintenance to ensure application stability across Oracle environments.
• Documented technical specifications, system workflows, and data models; performed gap analysis to identify and implement system enhancements.