Resume

Sign in

Developer Sql

Location:
Chennai, Tamil Nadu, India
Posted:
October 07, 2019

Contact this candidate

Resume:

THIRUMURUGAN S

Mobile:+91-883******* adai7v@r.postjobfree.com

EXPERIENCE SUMMARY

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.

TECHNICAL SKILLS

Operating System Windows 7, UNIX

Programming Language SQL, PLSQL

Versions Oracle 10g/11g

Tools SQLPLUS, TOAD, SQL DEVELOPER

PROFESSIONAL EXPERIENCE

Working for Aspire Systems(India) Pvt.Ltd., Chennai from may 2017 to till date.

EDUCATION QUALIFICATION

B.E in Electronics and Communication Engineering from Sri Krishna College Of Engineering and Technology, Coimbatore.

PROJECT

Project name : OTS

Clients : DBS Bank, Singapore

Role : Oracle PL/SQL Developer

Duration : May 2017 to till date

Description:

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.

Personal details:

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)



Contact this candidate