Rambabu Nandavarapu

Client 1 - Bank of America since 2013 to 2021.

Role: Oracle PL/SQL Developer

• Designed and created database objects—tables, views, indexes, triggers, MVs etc.. based on user requirements.
• Created technical design documents for Oracle stored procedures and functions
• Developed complex PL and SQL packages, procedures, functions, and triggers for application support.
• End-to-end exposure on the DevOps lifecycle using Bitbucket, Jenkins, and ServiceNow changes.

Client 2 - CitiBank N.A., from 2022 - Continue.

Role: Database architect, design and modeling, data analyst and SQL Development

• Worked as a data modeler and architecting the database for new applications, starting from creating the schemas, roles, designing the relational data models, and creating tables.
• Developed multiple real-time searches from the SQL front for Retail, Cards, and CRS lines of business, which are very crucial for the customer hub project.
• Tuned multiple searches that are experiencing performance issues.
• Migrated data from legacy systems into Oracle Database using SQL and PL SQL.
• Conducted code reviews, debugging, and optimization of SQL queries and PL SQL programs.
• Provided technical expertise to enhance daily operations in Oracle applications.
• Collaborated with end-users and analysts to execute unit, system, and regression testing.