Rajarajan Umapathy

• Having around 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• I have 3+ years of experience in Informatica PowerCenter(ETL) development.
• Experience in the Agile methodologies.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against the deadlines.
• Work experience in Banking & Financial Domain.
• Effectively made use of Tables, Indexes, Collections, Analytical functions, Views and Materialized Views.
• I have hands on experience in Data Modelling and Schema Design.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Triggers, Stored Procedures, Functions and Packages with proper Exception handling. 
• Have very good exposure in Collection Concepts in Oracle (Specifically with the nested table).
• Good experience in Oracle apps DBA.
• Good exposure in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables, Cursor.
• Have knowledge in XML handling by using PL/SQL codes.
• Good experience in tuning the performance in SQL and PL/SQL code.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Refinitiv (London Stock Exchange Group) – Cognizant Technology Solutions.

Description: London Stock Exchange Group plc (LSEG) is a UK-based stock exchange and financial information company headquartered in the City of London, England. Refinitiv is an American-British global provider of financial market data and infrastructure. It is a subsidiary of London Stock Exchange Group. Refinitiv runs analytics, Trading, and risk assessment, FXall, Eikon, etc., Refinitiv also maintains a database features to covering corporate finance transactions and investment banking league tables across equity markets, debt, loans, bonds, etc.,

Environment: Oracle 12c, SQL, PLSQL, Performance Tuning, Shell scripting SAP BO.

Roles & Responsibilities:

• Involved in Requirement Gathering, Analysis, Design and Understanding the FRS then Preparing Low Level documents.
• Communicated with Onsite co-ordinators and clients for understanding business requirements.
• Working and exposure in the Trading domain.
• Conducting the scrum meeting for every day.
• Experience in lead a team and also I am a good team Player.
• Experience in creating and assigning JIRA. 
• Experience in Oracle PLSQL, SQL, Unix-Shell scripting, and SAP BO.
• Working experience in the performance tuning, Stored Procedures, Functions, Triggers, Packages, Bulk Collect and Cursors.