PROFESSIONAL SUMMARY:

• Over 8 years' experience in Oracle PL/SQL development in Banking domain.
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 11g/10g/9i/8i and also SQL queries and scripts.
• Experience in Requirements Gathering, Software Design, Development, Testing, Implementation, Migration of Oracle Databases and supporting applications
• Expert in developing procedures, functions, packages, database triggers and troubleshooting using PL/SQL and SQL.
• Extensively involved in developing programs to import/export data from legacy systems into Oracle database using SQL Loader and PL/SQL.
• Proficient in using Oracle ETL Utilities such as SQL Loader, Export/Import, Data Pump, External Tables and tools like TOAD, SQL Developer and RAPID.
• Experienced in migrating Oracle Databases 8, 9i .
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning PL/SQL using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the oracle reports.
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, and UTL FILE to read and write the files.
• Experience in SQL Performance tuning using Cost-Based Optimization CBO .
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in writing Stored Procedures, Triggers and Cursors in DB2.
• Involved in all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• In-depth knowledge and experience of working on Crystal Reports, Oracle Reports.
• Experience in developing Java programs, Java beans.

TECHNICAL EXPERTISE:

• RDBMS : Oracle 11g/10g/9i, DB2.
• Languages : PL/SQL, C, C , Java, JDBC, Java Beans, XML, HTML.
• Operating Systems : Windows XP, LINUX
• DB Tools : SQL Developer, Toad, Query Tool
• GUI : Oracle Forms 10g/ 9i/6i and Reports 10g/6i/9i, Erwin.
• Reporting Tools : Crystal Reports 10.0, 11.0

PROFESSIONAL EXPERIENCE:

Confidential

apital One: Dallas, TX Mar 2014 Present

Sr. Oracle PL/SQL Developer / Lead

Responsibilities:

• Designed report and datasets using ad-hoc queries to support business requirement and to capture the end result prototypes for requirement discussion.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Coding in PL/SQL and creation of relevant quality documents like Analysis,
• Design, Test cases.
• Performance tuning, Optimized the queries to improve the performance of the application.
• Designed report and datasets using ad-hoc queries to support business requirement and to capture the end result prototypes for requirement discussion.
• Created database objects like Cursor, Ref Cursor, Indexes and Triggers.
• Creating Oracle objects like Tables, Views, Procedures, Functions, Triggers, Packages.
• Wrote various Triggers using TOAD.
• Created database objects like Cursor, Ref Cursor, Indexes and Triggers.
• Used SQL LOADER utility for loading flat files into the Oracle DB.
• Wrote complex queries for generating the statistics of Customer data.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Involved in Production Support and troubleshooting data quality and integrity issues
• Involved in partitioning of very large tables. Used list and range partitioning.
• Created various reports using Crystal Reports.

Environment: Oracle, Crystal Reports 11.0, Linux

Bank of America: Charlotte, NC Oct 2009 Feb 2014

Oracle PL/SQL Developer

Description: COS is Customer Origination System that caters to the application processing for the credit cards, personal and mortgage loans. It captures all the customer data and sends all the data to NBSM New Business Strategy Manager the decision agent.

Responsibilities:

• Analysed of customer specifications and custom design of applications successfully and implementing designs in new/existing application using PL/SQL.
• Worked with GUI Development team and created many PL/SQL Packages, Procedures, and Functions to support application.
• Extensively wrote ad-hoc queries to support the business and end clients, for trade data analysis, various control reports.
• Extensively wrote SQL queries to debug various breaks and provided support to various testing environments.
• Performed application tuning using Oracle HINTS, DBMS PROFILER.
• Used DBMS STATS, DBMS XPLAN Oracle supplied packages to gather object statistics and fine tune the application.
• Created data migration scripts, release scripts and rollback scripts using SQL queries.
• Re-defined existing queries to include WITH Clause, EXISTS clause, HINTS, Analytical functions, MERGE statements, PL/SQL Collections and Bulk Collect/Inserts to improve performance.
• Used SQL LOADER utility for loading flat files into the oracle DB
• Designed/developed tables, views, stored procedures, function and complex PL/SQL packages for data processing.
• Created database objects like Cursor, Ref Cursor, Indexes and Triggers.
• Implemented WITH Clause, EXISTS clause, HINTS, Analytical functions, MERGE statements, Materialized Views and Bulk Collect/Inserts to improve performance.
• Performance tuning, Optimized the queries to improve the performance of the application.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle, JSP, Crystal Reports 11.0, Jasper Reports, Linux

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirements Analysis for Data Migration.
• Design the migration process flow.
• Involved in Design, creating Logical Data Models.
• Designed report and datasets using ad-hoc queries to support business requirement.
• Involved in capturing the end result prototypes for requirement discussion.
• Data migrations from spreadsheets using SQL Loader, External tables.
• Performed SQL and PL/SQL tuning, analyzing queries using EXPLAIN PLAN, SQL TRACE, TKPROF.
• Migrate data to the production database.
• Written conversion programs in core Java to generate the text file in destination system specified format.
• Generated summary and exception report data using a Java program for RLS.
• Generated reports using Crystal Reports for end user analysis.
• Involved in End 2 End Performance Tuning of the application.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle, Crystal Reports 11.0, Linux

Confidential

Oracle Developer

Responsibilities:

• Worked closely with business user to understand and document the scope and requirement for the project.
• Analyzing the Design and functionality.
• Designed/developed tables, views, stored procedures.
• Designed and developed function and complex PL/SQL packages for data processing.
• Created database objects like Cursor, Ref Cursor, Indexes and Triggers.
• Written programs in Core Java this does the data massaging.
• Involved in generating the CACS format and it will be stored as a text file. This file gets passed to CACS system through ISIS.
• Involved in Creating the Oracle table spaces, tables, indexes, constraints, triggers etc.
• Written complex queries and generated reports for end user analysis using Crystal Reports 10.
• Extensively wrote ad-hoc queries to support the business and end clients, for trade data analysis, various control reports.
• Involved in performing GAP analysis and Data modeling
• Involved in code review, developed the reusable component.
• Preparation of daily and weekly status reports.

Environment: Oracle, Crystal Reports 10.0, ISIS, Linux

Confidential

Responsibilities:

• Involved in Requirements Analysis for Data Migration.
• Written conversion programs in core Java to load the data from the text file to the database.
• Generated summary and exception report using Crystal Reports for end user analysis.
• Written complex queries to generate the ad-hoc reports for user analysis.
• Performed the risk data analysis i.e. non-performing loans and reported to users for corrective actions.
• Analyzed the issues by writing various queries and enabled the team to work on the solutions.
• Worked extensively on Crystal reports and generated various reports.
• Involved in production system support post implementation.
• Extensively wrote ad-hoc queries to support the business and end clients, for trade data analysis, various control reports.

Environment: Oracle, Crystal Reports 10.0, Applets, JDBC, ISIS, Linux

Confidential

Senior System Analyst

Responsibilities:

Involved in Coding, Data conversion, Development and Implementation.

Written conversion programs in core Java to load the data from the text file to the database.

Generated summary and exception report using Crystal Reports for end user analysis.

Written complex queries to generate the ad-hoc reports for user analysis.

Extensively wrote ad-hoc queries to support the business and end clients, for trade data analysis, various control reports.

Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.

Performed the risk data analysis i.e. non-performing loans and reported to users for corrective actions.

Analyzed the issues by writing various queries and enabled the team to work on the solutions.

• Worked extensively on Crystal reports and generated various reports.
• Involved in production system support post implementation.

Environment: Oracle, Java, J2EE, JSP, Crystal Reports 10.0, Applets, JDBC, ISIS, Linux