Chandana Venkata

• Developed complex PL/SQL packages, procedures, functions, triggers, and views supporting enterprise retail applications.
• Designed high-performance SQL queries processing millions of transactional records daily.
• Optimized SQL statements using execution plans, indexing strategies, partitioning, and query tuning techniques.
• Developed reusable PL/SQL packages for inventory, pricing, customer, and order processing modules.
• Worked with Oracle 19c databases supporting high-volume OLTP systems.
• Improved batch job performance by implementing Bulk Collect and FORALL operations.
• Created materialized views and summary tables to improve reporting performance.
• Worked closely with application developers to integrate PL/SQL components with Java-based applications.
• Performed production support, root cause analysis, and performance tuning for critical database issues.
• Participated in Agile development, code reviews, deployment activities, and production releases.

Clients: Citibank | State of Kansas | State of Georgia

Official designation at TCS was Java Developer.

Assigned to Oracle PL/SQL development projects from the beginning supporting banking and government clients.

Citibank – Enterprise banking applications supporting customer, account, payment, and transaction management.

State of Kansas – Government applications supporting citizen services, reporting, and database modernization.

State of Georgia – Financial and administrative systems supporting state government operations.

• Hired by TCS as a Java Developer and assigned to Oracle PL/SQL development projects from the beginning.
• Developed Oracle PL/SQL packages, procedures, functions, triggers, views, sequences, and materialized views.
• Designed high-performance SQL queries and optimized complex database operations.
• Tuned SQL using Explain Plans, SQL Trace, AWR reports, indexing, and partitioning.
• Developed ETL validation scripts and reconciliation reports.
• Used Bulk Collect, FORALL, cursors, collections, and dynamic SQL.
• Worked on Oracle 12c/19c databases supporting banking and government applications.
• Developed reusable PL/SQL components for customer, financial, and administrative modules.
• Collaborated with Java developers by exposing business logic through PL/SQL packages.
• Supported production deployments, release management, defect fixes, and performance tuning.
• Used Oracle SQL Developer, TOAD, Git, Jira, SQL*Plus, and Unix/Linux.
• Followed Agile/Scrum methodologies throughout the SDLC.

• Developed Oracle PL/SQL objects supporting automotive dealership applications.
• Created packages, procedures, functions, triggers, and views.
• Optimized SQL queries improving report execution times.
• Worked with SQL Developer, TOAD, and Oracle databases.
• Supported defect fixes and production deployments.
• Performed database testing and code reviews.

• Developed SQL queries and PL/SQL procedures supporting retail reporting applications.
• Created views, functions, and stored procedures.
• Assisted in performance tuning and database optimization.
• Worked with Oracle SQL Developer and SQL*Plus.
• Supported production issues and database maintenance.
• Participated in Agile development processes.