Experience Summary:

• Over 7 years of experience as PL/SQL developer in banking domain Involves Retail & Corporate Banking, Covering Islamic and Conventional Banking.
• Profound noledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experienced in developing stored packages, procedures, functions, Partitions, triggers, and views.
• Ability to understand Business Requirement, Interacted with Client and Development team and translate the Requirements into Functional Specification.
• Possessing comprehensive product noledge (Flex cube Core Banking product), Business requirements analysis, Design, Development, Implementation, Testing & Maintenance.
• Extensive experience in Oracle Forms 6i and worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions.
• Hands on experience in Product walk through, Implementation, Product Testing and UAT Support and Training Documents.
• Creation of High level Test plan, Business case and System Test plan.
• Hands on experience in Core, Casa Deposits, Retail Teller, Fund Transfer, Payment & Collection, Term Deposit, Loans, Islamic Modules ELCM, Messages, SWIFT and generic interfaces.
• Experience in Data Warehouse concepts like Data Migration, ETL & Content Management, implemented various Extraction, Transformation and Loading architectures involving tools and technologies such as Informatica Power centre, XML, XML Schema, SQL*Loader, PL/SQL, Materialized views.
• Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server and Flat files.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Experience in creating external tables to manage data which is store at the OS level.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in Advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), explain plan, auto trace.
• Experience in creating Test scripts and Test cases to perform Unit testing and integrated testing.
• Experience in migrating the code from development to testing and UAT.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Experience in Automating works using Shell Scripting.
• Excellent planning, analytical, written Communication and Interpersonal skills.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries theirby optimizing query execution plan.
• Ability to learn Domain Knowledge, related technology within a short span.

TECHNICAL SKILLS

• Web/Application Server
• Web Sphere
• Database
• Oracle 10g/11g
• Mark - up Language
• HTML, XML
• Tools
• PL/SQL Developer
• PUTTY
• Oracle Forms 6i(D2K)
• ETL Tool (Informatica)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle PL/SQL Developer

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 noledge to quality assurance analysts regarding the model.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Procedures, Functions and Packages in PL/SQL, Materialized Views, Dynamic SQL, Database Triggers and involved in creating and updating Packages to meet business requirements.
• Extensively used Dynamic SQL, REF Cursors, Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Involved with UI change.
• Used Oracle Forms 10g to design and develop the inerface for system.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environment.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Created partitioning and indexes for Query Optimization.
• Used EXPLAIN PLAN for query optimiation.
• Developed SQL scripts for object transfer from one schema to another.
• Worked on Code Reviews for the code developed by other developers.
• Involved in writing test cases, unit analysis and intergration testing for the development.
• Prepared technical and release documentation.

Confidential, El Segundo, CA

Oracle PL/SQL Developer

Responsibilities

• Prepared program specification for the development.
• Created new UI for requirement.
• Developed new Tables, views, triggers, cursors, procedure, functions, packages and SQL scripts.
• Modified existing code and developed procedures to perform certain function.
• Created partitioning, indexes and Explain plan for Query Optimization.
• Created test scripts and test cases to perform Unit and integrated testing.
• Migrated the code from development to testing and UAT.
• Fixing the bugs and issues reported in the QA, ITR and UAT phase.
• Worked on Code Reviews for the code developed by other developers.
• Prepared technical and release documentation.

Confidential

Oracle PL/SQL Developer

Responsibilities

• To understand the client requirement and interaction with client for any clarification. Involved in creation of Functional Specifications and Data Specifications as per requirement.
• Meeting the users and business to establish requirements for new systems or modifications.
• Analysis and evaluation of various implementation approaches.
• Implemented the requirement for Flexcube host, interfaces and Flexbranch System.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst
• Fixing the bugs and issues reported in the QA, ITR and UAT phase.
• Tested the Forms, debugged and fixed it after the testing.
• Conducting noledge transfer sessions for other teams to help them understand the new enhancements and the changes done in various modules.
• Providing Daily and Weekly status report to the management and application owner.

Confidential

PL/SQL Developer

Responsibilities

• To understand the client requirement and interaction with client for any clarification. Involved in creation of FS and DS, as per requirement.
• Meeting the users and business to establish requirements for new systems or modifications.
• Analysis and evaluation of various implementation approaches.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
• Estimating the effort for the requirements.
• Fixing the bugs and issues reported in the QA, ITR and UAT phase.
• Conducting noledge transfer sessions for other teams to help them understand the new enhancements and the changes done in various modules.
• Providing Daily and Weekly status report to the management and application owner.

Confidential

Oracle PL/SQL Developer

Responsibilities

• To understand the client requirement and interaction with client for any clarification. Involved in creation of FS and DS, as per requirement.
• Meeting the users and business to establish requirements for new systems or modifications.
• Analysis and evaluation of various implementation approaches.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
• Estimating the effort for the requirements.
• Fixing the bugs and issues reported in the QA, ITR and UAT phase.
• Conducting noledge transfer sessions for other teams to help them understand the new enhancements and the changes done in various modules.

Confidential

Oracle PL/SQL developer

Responsibilities

• Involved in Gathering the Requirements for creating data models for data analysis and reporting.
• Designing Tables, Constraints, Views, and Indexes in coordination with the application development team.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in writing Test plans for PL/ SQL Stored Procedures and Functions.
• Involved in Unit Testing and System integration.