Srinivas Annam

Looking forward for an opportunity in a challenging environment, where I can utilize my experience in contributing effectively to the success of the organization.

Having hands on experience as Oracle SQL, PLSQL Developer, which includes Analysis, Application Programming, and implementation. Understanding the business requirement and worked as a part of team and individual as well. Having Good Experience in Oracle 11g, 21c (SQL, PL/SQL). Proficient in writing of Stored Procedures, Functions, Packages , Cursors, views using Oracle PL/SQL Having knowledge in SQL Functions, Constraints, Ranking Functions. Experience in creation of Tables, Synonyms, Views, Sequences and Indexes. Good Exposure in using SET Operators, Joins, Sub Queries. Extensive knowledge in Oracle cursor management, Exception Handling. Having experience in converting flat file data into tables. Having Good Knowledge of DDL, DML, DCL, TCL Commands. Having experience in developing stored procedures using dynamic SQL. Good interpersonal skills, committed, result oriented, Hard working with a quest and Zeal to learn new technologies. Proficient in analyzing client's business process and delivering the accurate solution to incorporate the same business logic in software product. Having rich experience in product Customization right from requirement analysis to Documentation, & Testing. Having proficient knowledge in understanding new technologies accomplishing projects goals successfully.

Project:

Project Name : CITI BANK PROJECT.
Duration :  1 Year
Client : CITI.
Environment : Oracle 19c.
Tool : SQL Developer. 

Description:
Citigroup was formed on October 8, 1998, following the $140   billion   merger of Citicorp and Travelers Group to create the world's largest financial services organization. The history of the company is divided into several firms that eventually amalgamated into Citicorp, a multinational banking corporation operating in more than 100 countries.

Creating packages, procedures, functions using advanced PL/SQL coding to implement the complex business logic as per client requirement.
Understanding the business requirement and worked as a part of team and individual as well.
Developed the code as per Functional Specification Document.
Writing complex queries using multiple tables.
Having good knowledge on Dynamic SQL.
Debugged and Monitors the performance of the queries developed in procedures.
Created Constraints, Indexes on Table columns.
Interacted with the clients directly and understood their requirement and developed the new CR’s as per the client requirement.
Analyzed, developed Packages, Procedures and Functions as per the requirement.
Analysis, design, develop, coding, Implementation and documentation for the requirements.
Involved in writing unit test cases.
Performed unit testing by writing wrappers