Nuka Narendra Reddy
Hyderabad
Summary
Oracle PL/SQL Developer with 9 years of IT experience - 6 years of deep expertise in Oracle database development, stored procedure engineering, and performance tuning across gaming and banking domains, complemented by 3 years building production-grade Node.js microservices on AWS. Delivered zero-discrepancy audits for 1.4 million users, optimised batch processing with Bulk Collect and FORALL, and pioneered AI integration (Gemini, RAG pipelines) at scale.
Overview
10
10
years of professional experience
Work History
Software Engineer → Module Lead
Head Digital Works
Hyderabad
01.2017 - Current
- PL/SQL Development: Architected and maintained PL/SQL packages for wallet, transaction, and player data modules on the Ace2Three platform, supporting chip distribution, bonus logic, and responsible gaming enforcement for 1.4 million active users.
- Stored Procedures & Functions: Engineered complex stored procedures, functions, and packages encapsulating critical business rules; applied Bulk Collect and FORALL to reduce batch processing runtime by ~60% on high-volume transaction workflows.
- Advanced SQL: Authored advanced SQL leveraging analytical functions, recursive queries, set operators, and pseudo columns to drive reporting, auditing, and regulatory compliance pipelines.
- Performance Tuning: Reduced query execution time across high-volume workflows using EXPLAIN PLAN, index optimisation, and AWR report analysis, achieving consistent sub-second retrieval on multi-million-row tables.
- Exception Handling & Data Integrity: Implemented robust exception handling, cursor management, and collection-based logic ensuring zero runtime failures across transaction-heavy workflows.
- Data Migration: Executed cross-environment data migrations between development, QA, and production, maintaining 100% data consistency across all loads.
- Audit Management: Managed yearly financial and transactional audits for 1.4 million users with zero discrepancies - recognised as the best-performing audit cycle across all operators.
- TDS Compliance: Designed and executed year-end TDS calculation script for 1.4 million users with zero service disruption - ranked best performance among all platform operators.
- Database Design: Designed Oracle database tables, sequences, indexes, and complex validation constraints aligned with evolving product requirements throughout the full development lifecycle.
- Microservices & AWS: Built Redeem and Add Cash microservices (Node.js/AWS); led ECS ARM64 migration achieving ~40% compute cost reduction; tuned Lambda concurrency and DynamoDB TTL/index strategy.
- AI Integration: Pioneered AI adoption: built a Gemini-powered in-app chatbot and a RAG-based pipeline to ingest, chunk, embed, and store insurance documents for intelligent semantic querying.
- Team Leadership: Mentored junior developers on PL/SQL best practices and conducted knowledge-transfer sessions across cross-functional teams.
Software Engineer
Wipro Technologies
Hyderabad
05.2021 - 11.2021
- Oracle PL/SQL: Delivered PL/SQL development for the Bank of America Operational Risk Data Warehouse - built and maintained complex views, packages, and procedures processing daily risk data ingestion.
- ETL & Scheduling: Developed and managed Autosys JIL files for job scheduling across ETL, development, and reporting environments, ensuring reliable daily data loads.
- Query Optimisation: Authored and optimised complex SQL for auditing and operational risk extraction, supporting downstream compliance and reporting teams.
- Data Flow: Collaborated cross-functionally to validate data flow across environments, ensuring accurate and timely operational risk reporting.
Education
B.Tech - Computer Science
Sri Indu College of Engineering and Technology
01.2016
Skills
- SQL
- PL/SQL
- JavaScript
- Basic Linux
- MYSQL
- Stored Procedures
- Functions
- Packages
- Triggers
- Views
- Cursors
- Sequences
- Indexes
- Bash/Shell Scripting
- Linux/Unix Environment
- Command Line Utilities
- Loader
- Bulk Collect
- FORALL
- Collections
- Record Types
- PL/SQL Tables
- Ref Cursors
- Exception Handling
- Analytical Functions
- Recursive Queries
- Subqueries
- Set Operators
- Pseudo Columns
- Joins
- Query Optimisation
- Explain Plan
- Index Optimisation
- Performance Tuning
- Table Design
- Constraints
- Partitioning
- Database Design
- Data Migration
- SQL Developer
- Toad
- Oracle DB
- JIRA
- Git
- Postman
- DBeaver
- AWS
- Docker
- GitHub Actions
- Gemini API Integration
- RAG Pipeline
- Vector Embeddings
- Pgvector
- Gaming
- Banking
Accomplishments
- Executed TDS compliance for 1.4 million users with zero service disruption - ranked best among all platform operators
- Delivered yearly database audits with zero discrepancies across financial and transactional records for 1.4M users
- Reduced batch processing runtime by ~60% through Bulk Collect and FORALL optimisation on high-volume workflows
- Cut AWS infrastructure costs by ~40% via ECS ARM64 migration and comprehensive Lambda/DynamoDB optimisation
- Built production RAG pipeline integrating LLM technology for intelligent insurance document querying
- Developed Gemini-powered AI chatbot that reduced manual support overhead by ~30%
Timeline
Software Engineer
Wipro Technologies
05.2021 - 11.2021
Software Engineer → Module Lead
Head Digital Works
01.2017 - Current
B.Tech - Computer Science
Sri Indu College of Engineering and Technology