Oracle plsql

Balasubramanian. G Email: *********@*****.***

Oracle - PLSQL Mobile: 720*******

Objective

Seeking for a challenging role where my 1.4 years PL SQL Development, L2/L3 Support and knowledge can be utilized and enhance.

Profile Summary

•Strong RDBMS concepts including expertise in PL/SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.

•Developed/coded in Oracle Forms/Reports.

•Involved in writing Stored Procedures / Functions / Packages / Triggers/advanced objects like V-arrays, Nested Tables, Records and PL/SQL tables in Oracle.

•Extensive experience in SQL Optimization, performance monitoring and tuning of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.

•Used Bulk Collect feature to improve performance.

•Tuned SQL queries and performed code debugging using TOAD.

•Involved in unit testing and writing test cases.

•Prepared test cases and performed unit testing.

•Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader – for different cases)

•Data Migration / Loading / Export / Import/SQL*Loader.

•Load the data from Excel file to oracle database.

•Created Oracle Materialized Views.

•Used the inner join, outer join, cross join while writing the complex SQL Queries.

•Developed complex queries including Sub queries, Unions, Intersects and Aliases.

•Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.

TECHNICAL SKILLS

Oracle Developer SQLPLUS, TOAD, SQL Developer

TOOLS Putty,JIRA,CVS,Remedy

UNIX F-secure SSH client

Version control svn,vss

Database Oracle 11g,12c

MS office MS-word,MS-power point,MS-excel

Roles and Responsibilities

Clients : Bank Mandiri (Dec2019-present)

•Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.

•Worked on developing a financial application system to handle all the bank transactions.

•Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

•Created database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database Links as well as Custom Packages tailored to business requirements.

•Developed and modified PL/SQL code to make new enhancement or resolve problem as per customer requirements.

•Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.

•Extensive experience in writing and tuning complex sub queries, correlated queries and Nested queries, Union, Intersect, Aliases.

•Used Analytic functions, Decode, Case statement while writing complex SQL Queries.

•Used the Inner join, Outer Join, Cross Join while writing complex SQL Queries.

•Used Collection objects, ref cursor, bulk collect, aggregate functions while writing SQL Queries.

Overall IT Experiences

Working in Oofix Infotech as Associate Software Engineer from Dec 2019 – till date.

Education

Course

College

Department

B. Tech

SRM institute of science and technology

(Chennai)

Computer science engineering

PERSONAL DETAILS:

•Father Name : Gunasekaran .S

•Date of Birth : 11-07-1998

•Nationality : Indian

•Languages Known : English,Tamil

•Address : No:22,3rd cross,Radha Krishnan Nagar, Moolakulam,

Pondicherry- 605010

Contact this candidate