The transaction data is extracted from the various branches across the country, which uses a system called GDAS and developed Reports for the project, which is the most comprehensive, intranet powered information management system ever available to the ATM Transactions financial Services, and isable to efficiently manage and integrate all of Their financial, and administrative data Services. FTP component was developed internally. Providing secure, Intranet based ATM Transaction management system. Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 11g/12c, Developer 2000 and PL/SQL. This system consists of the various functional modules: Loan approvals, Deposition of Cash/ Withdrawal of Cash, Change of personnel Information, Bank Details, balance Sheet, Customer Information Database Excellent technical and analytical skills with clear understanding of design goals of ERP , SCM , POSTGRESQL modeling for OLTP and dimension modeling for OLAP , PPM Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements. Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions Used Toad and extensively. Created tables, indexes, sequences, constraints and snapshots. Developing packages and stored procedures using PL/SQL. Extensively used stored procedures, functions and database triggers. Used import / export data Tune PL/SQL programs using TKPROF and accelerated performance of refreshing data warehouses Performed code reviews as well as optimized code for better performance. Responsible for understanding, changes in business functionalities, add new elements in tables and accordingly enhancing PL/SQL stored procedures and triggers Remained on call for 24x7 to support scheduled jobs in production data warehouses , Commvault

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 Informatica & 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 and 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, function sand 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 , ERP , SCM , POSTGRESQL , PPM 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, SQL*TRACE, TKPROF and AUTOTRACE. 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. Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus , ERP SQL SERVER , PPM Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving the performing. 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.

Description: The transaction data is extracted from the various branches across the country, which uses a system called GDAS and developed Reports for the project, which is the most comprehensive, intranet powered information management system ever available to the ATM Transactions financial Services, and isable to efficiently manage and integrate all of Their financial, and administrative data Services. FTP component was developed internally. Providing secure, Intranet based ATM Transaction management system.

Worked in an application which is a corporate customer transaction facility created for the RBS customers to do payments. The Project covered addition of new enhancements to the application like financial transfers, Inter Account Transfers (IAT) and development of the same.

Worked in an application which is a corporate customer transaction facility created for the RBS customers to do payments. The Project covered addition of new enhancements to the application like financial transfers, Inter Account Transfers (IAT) and development of the same. Worked in Production Support Environment as well as QA/Test environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc. Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database. Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures. Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g. Involved in Logical & Physical Database Layout Design. Set-up and Design of Backup and Recovery Strategy for various databases. Performance tuning of Oracle Databases and User applications. Used SQL*Loader as an ETL tool to load data into the staging tables Provided user training and production support. Improved the performance of the application by rewriting theWrote packages to fetch complex data from different tables in remote databases using joins, subquery database link

PROFESSIONAL EXPERIENCE:

Current Employee : Senior Pl/SQL Developer (JAN 2013 - TILL DATE)

Designation : Senior Oracle Developer

Domain : Oracle PL/SQL

Environment: Oracle 11g, SQL * Plus, Toad, SQL*Loader, SQL Developer, Windows XP

PROJECT NAME : BANK OF AMERICA

JAN 2013 – TILL DATE