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 Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*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 SQLPerformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Experience in writing Stored Procedures, Triggers and Cursors in DB2.
• Involved in all phases of theSoftware Development Life Cyclefrom analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modellinganddesign techniques.
• In-depth knowledge and experience of working on Crystal Reports, Oracle Reports.
• Experience in developing Java programs, Java beans.

TECHNICAL SKILLS

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, Dallas, TX

Sr. Oracle Lead/ Developer

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 AnalysisDesign, 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.
• UsedSQL LOADERutility for loading flat files into the Oracle DB.
• Wrote complex queries for generating the statistics of Customer data.
• Developed scenarios forUnit,Integration testingto ensure that all the components work correctly when integrated.
• Involved inProduction 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

Confidential, Charlotte, NC

Oracle PL/SQL Developer

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 forUnit,Integration testingto 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 usingad-hoc queriesto 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 EndPerformanceTuningof 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 PL/SQL 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 objectslikeCursor, Ref Cursor, IndexesandTriggers.
• 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.
• Extensivelywrote ad-hoc queriesto support the business and end clients, for trade data analysis, various control reports.
• Involved in performingGAP analysisandData 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

Oracle Developer

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.
• Extensivelywrote ad-hoc queriesto support the business and end clients, for trade data analysis, various control reports.

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

Confidential

Oracle / Java Developer

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.
• Extensivelywrote ad-hoc queriesto 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