Sridhar Selvaraj

Having 4 years of experience in Oracle PL/SQL Development and L1 Production Support. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Strong RDBMS concepts including expertise in using DDL, DML, DCL, TCL Statements in Oracle SQL.

Designed, developed and maintained Oracle database object such as tables, views, synonyms, materialized views, sequences and indexes. Strong experience in writing complex queries which includes joins, sub query, group functions, set operators and analytical functions. Extensive knowledge in data migration techniques using PL/SQL procedures, data pump, SQL*LOADER.

Developed

Complex database objects like Stored Procedure, Functions, Packages and Triggers using SQL and PL/SQL. Extensively used Cursor to fetch multiple records from table inside the PL/SQL block and Exceptions to handle the error.

Experience in application development using various advanced features of Oracle like Collections, Autonomous transactions and Exception handling. Having good knowledge in bulk collections (FORALL, LIMIT, BULK EXCEPTION HANDLING) for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Having good knowledge in PL/SQL Performance Tuning (Explain Plan, Index, Hints and Table Partition).

Having

Experience in Debugging by using Error Log.

PL/SQL Developer - Collabera (Ascendion) Technologies Private Ltd. - Chennai

(2022-06 - 2023-06)

Working on BNP Paribas project. Colibri is the web application developed in Chennai using IT BP2S standards to create and maintain all securities automatically within the multifonds FA environment. Colibri is able to provide internal and external clients with specific reporting using automatic mailing.

• Creating DB Tables required for the business based on the client setup
• Understanding the Business logic then developing the code from infrastructural level
• Exporting the excel statistical data into DB by writing query in SQL
• Converting the XML query into SQL query based on the Jar application for liquid base deployment
• Taking export data from the financial data providers then implementing those query's in DB through SQL and doing Prod data refresh in our lower environment databases

Software Engineer - Thinclesoft Technologies Private Ltd. - Chennai

(2019-04 - 2022-05)

Ricoh produces electronic products, primarily cameras and office equipment such as printers, photocopiers, fax machines, offers Software as a Service document management applications such as DocumentMall, RicohDocs, GlobalScan, Print&Share and also offers Projectors.

• Analyzed and overviewed about the business requirement of the project and worked according to the WR/CR which is raised from the end user
• Convert the functional requirements into technical document as per the business standards
• Modifying various existing Packages, Procedures, functions according to the new business needs and carrying out the impact analysis too
• Have written scripts involving table level triggers to monitor table transactions and maintain history
• Tuning the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time
• Involved in code review and unit testing of code functionality using testing environment to ensure the code that its bug free
• Involved in the continuous enhancements and fixing of production problems
• Partially involved in debugging process by using error log files
• Experienced using FOR ALL and BULK COLLECT to load large volumes of data from table
• Created collections (nested tables and arrays) for improving Query performance

Bachelor of Engineering - Electrical and Electronics Engineering (2017)