Vijaya Kumar Y

Led a team of 3 PL/SQL developers, ensuring 100% on-time delivery of CRs and production releases.

· Designed, developed, and maintained 600+ PL/SQL procedures, functions, and packagesfor game, admin, and web modules.

· Optimized critical SQL queries, improving performance by 30–60% using indexing, execution plan analysis, and query refactoring.

· Extensively used Collections, REF Cursors, Analytical Functions, and Bulk Operations for high-performance data processing.

· Supported high-concurrency transactional systems handling millions of daily gaming transactions.

· Performed data migration and legacy data cleanup with zero impact on live systems.

· Played a key role in migrating Oracle database business logic to Java backend services, reducing database load and improving scalability.

· Provided ad-hoc reporting and analytical data support for internal business teams.

· Conducted code reviews and LLD validations, enforcing coding standards, performance best practices, and security guidelines.

· Actively involved across the full SDLC: requirement analysis, development, testing, deployment, and post-release support.

· Developed event-driven PL/SQL logic to support front-end validations in core banking modules.

· Designed and implemented PL/SQL solutions for parsing and generating MT messages as per banking standards.

· Prepared and executed production data correction scripts with validation and rollback strategies.

· Created and optimized procedures, functions, cursors, and DML operations for critical banking workflows.

· Investigated and resolved issues in Credit Lines, Collateral, and Credit Risk Summarymodules.

· Provided cross-module production support, ensuring data accuracy, consistency, and compliance under strict SLAs.