Around 2 years of programming experience as an Oracle PLSQL Developer in software
Analysis, design, development, testing and implementation of full life cycle web based software applications
. Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Strong programming experience in creating Procedures, Packages, Functions, Triggers, views, Materialized views, Synonyms and other database objects using SQL and PL/SQL.
Loaded Data into Oracle Tables using SQL Loader.
Worked extensively on Cursors, Ref Cursor, External Tables and Collections.
Experience in Oracle supplied packages, Records and PL/SQL Tables.
Experience in advanced PL/SQL concepts like Bulk collect and for all.
Experience with Performance Tuning for Oracle RDBMS using Indexes, Hints and Explain Plan.
Working with UNIX commands.
Working experience in rotational shifts 24/7 Production support.
Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
Possess excellent oral / written communication and interpersonal skills.
Good ability to quickly grasp and master new concepts and technologies.
Operating System Windows 7, UNIX
Programming Language SQL, PLSQL
Versions Oracle 10g/11g
Tools SQLPLUS, TOAD, SQL DEVELOPER
Working for Aspire Systems(India) Pvt.Ltd., Chennai from may 2017 to till date.
B.E in Electronics and Communication Engineering from Sri Krishna College Of Engineering and Technology, Coimbatore.
Project name : OTS
Clients : DBS Bank, Singapore
Role : Oracle PL/SQL Developer
Duration : May 2017 to till date
The main objective of every trade is to get executed at the best price and settled at the least risk and less cost. Some may say trade life cycle is divided into 2 parts pre-trade activities and post trade activities, well, pre-trade activities consists of all those steps that take place before order gets executed, post trade activities are all those steps that involve order matching, order conversion to trade and entire clearing and settlement activity.
Roles & Responsibility:
Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
Involved in the continuous enhancements and fixing of production problems.
Responsible for Analyzing and Implementing the Change Requests.
Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
Migrated data from flat files to tables using Sql*loader.
Good understanding of database objects and ability to triage issues.
Designed/Modified various database objects like stored procedures, packages, triggers and functions.
Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
Resolving the issues on priority basis.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Performed SQL and PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN and DBMS_PROFILER.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
Performing Unit testing and Code review for developed Components.
Environment: Oracle 10g/11g, PL/SQL, SQL* PLUS, SQL Developer, UNIX Shell Scripting, TOAD.
Father’s Name : C.Subramaniyan
Date of Birth : 05-06-1995
Sex : Male
Nationality : Indian
Languages known : English & Tamil
Address : 16/B,R.E.nagar extn,Thoraipakkam,Chennai-97
Place : Chennai Your’s Truly
Date : (S.THIRUMURUGAN)