Developer Data

SATHYA GIRIDHAR .G : ******************@*****.***

ORACLE PL/SQL DEVELOPER 861*******

PROFESSIONAL SUMMARY

Over 3 years of programming experience as an Oracle SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

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.

Expertise in Client-Server application development using Oracle 10g/11g/12c, SQL *PLUS, TOAD and SQL*LOADER.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Query Re-Write and Transportable table spaces.

Good knowledge on logical and physical Data Modeling. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages and

Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments. Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique and list partition technique. Experience with Oracle Supplied Packages such as DBMS_Profiler,DBMS_JOB and XML_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections. Expertise in Dynamic SQL, Collections and Exception handling. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TOOLS :

Oracle developer: oracle 10g/11g/12c,Toad

SQL Developer

SQL *plus

RESPONSIBILITIES:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. Worked on SQL*Loader to load data from flat files obtained from various facilities every day..

Involved in the continuous enhancements and fixing of production problems. Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys. Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus. Partitioned the fact tables and materialized views to enhance the performance. Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger. Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

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

PROFESSIONAL EXPERIENCE

Oracle PL/Sql Developer

Plotel solutions,Chennai

Jun 2017- Apr 2020

Client: Bank of Queensland, Australia

Project/Application: BOQ Trading

Project Description :

BOQ’s new online share trading service has officially gone live today following a recent partnership agreement with independent online broker CMC Markets Stock broking. The new user-friendly online share trading platform, BOQ Trading, offers CMC’s comprehensive range of stock broking services direct to BOQ customers via BOQ’s website and also over the phone through the CMC Markets/ BOQ Trading client services team. Services now available to BOQ customers include shares, options, warrants and managed funds, from a competitive $17.95 a trade.

ACHIEVEMENT

Participated in National level conference and Symposium in college. Received “Platina Team Award” for timely delivery and customer delight Various awards and recognitions awarded at plotel solutions, Yellow Topper award for Individual excellence and Team player, Rising Star. EDUCATION

Bachelors in Electrical and Electronics Engineering – Veltech / Anna university – 2017

– First class

PERSONAL DETAILS

Name : SATHYA GIRIDHAR

Father name : NARENDRA BABU .G

Date of birth : 22.01.1996

Gender : Male

Languages Known : Tamil, English & Telugu

DECLARATION

I hereby declare that the above furnished details are true to the best of my Knowledge.

Yours Sincerely,

(SATHYA GIRIDHAR.G)

Contact this candidate