Plsql developer

RESUME

BALASUBRAMANIAN G

***********@*****.***

904-***-****

OBJECTIVE:

Aspirant for a position in an organization where I can contribute my skills for organization’s success and synchronize with new technologies while being resourceful, innovative and flexible. PROFESSIOINAL SUMMARY:

• Nearly 3+ years of experience in the Oracle PL/SQL Developer/Support in Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).

• Created Schema, Users, Tables, Constraints, Indexes, Privileges, Roles, Cursors, Sequences, Synonyms.

• Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Analytical Function, Set Operators.

• Experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.

• Experience in change request and work request.

• Experienced in Query Optimization, Debugging, and Tuning and Improvising performance of the applications.

• Automated SQL* Loader to load the data from the flat files.

• Involved in release activities for the deployment of new code and ensure availability of application at right time.

• Very Good Knowledge about the Oracle tools like Oracle 11g/12c, TOAD and SQL PLUS.

• Knowledge in UNIX, and Shell Scripting.

PROFFESSIONAL EXPERIENCE:

• Working as a PLSQL DEVELOPER for “ITC Ltd” from June‘17 to till date. ACHIVEMENTS:

Title Category Recived

On

Star Award Awards for Excellence 28/11/2017

Best Team Award Awards for Excellence 27/11/2018

Special Initiative

Award

Awards for Excellence 27/03/2019

PROFESSIONAL CERTIFICATION:

• Oracle Certified Associate (OCA).

EDUCATIONAL QUALIFICATION:

• Completed B.E (Electronics and Communication Engineering) from Rajalakshmi Institute of Technology (2013- 2017).

Project Details:

Client Name: U.S. Bancorp.

Project Name : U.S. Bank.

Role: Oracle PL/SQL Developer.

Duration: Jun 2017 - Till Date.

Description:

U.S. Bancorp is an American bank holding company based in Minneapolis, Minnesota, and incorporated in Delaware. It is the parent company of U.S. Bank National Association, and is on the list of largest banks in the United States. The company provides banking, investment, mortgage, trust, and payment services products to individuals, businesses, governmental entities, and other financial institutions. Responsibilities:

• Interacted with architects and business analysts to understand business requirement, to reflect them into data model and involved with project development teams to convert the model into technical specifications and also provide knowledge to quality assurance analysts regarding the model.

• Written complex SQL (Sub queries and Join conditions) in PL/SQL. Experience in trace errors from Stored procedures/functions, Packages and fixed.

• Created custom PL/SQL procedures to read data from flat files to dump into Oracle database using SQL * Loader.

• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.

• Experience working with Oracle Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc

• Involved in solving day-to-day problems, giving support to the users.

• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.

• Worked on generating different formats file outputs like CSV, XML, EXCEL, TXT using UTL_File package

• Extensively used Dynamic SQL, Bulk binding/Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.

• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

• USED Pragma Exception_INIT and RAISE_APPLICATION_ERROR to handle exceptions

• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

• Developed scripts for checking oracle errors in alert log and trace files

• Create Indexes (Bitmap, Btree), DB Links, Snapshots/Materialize Views and add table spaces (temporary TS, undo TS).

• Developed Unix Shell scripts to automate repetitive database tasks. TECHNICAL SKILLS:

• Languages : Oracle SQL, PLSQL

• Database : Oracle 11G,12C

• Tools : SQL Developer, Toad, SQL*Plus

• Operating System : Windows, Linux

DECLARATION:

I hereby declare that all the details furnished above are true to the best of my knowledge. DATE :

PLACE :

(BALASUBRAMANIAN G)

Contact this candidate