PROFESSIONAL SUMMARY:

• Over 11 years of total experience as an Oracle PL/SQL developer with design, development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server architectures.
• Worked extensively on various technologies like Oracle 8i/9i, 10g/11g, PL/SQL, T - SQL.
• Expert in writing SQL, PL/SQL modules like functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers, indexes, collections(Nested tables and Varrays) and materialized views.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer, SQL Server Management Studio.
• Expert in Oracle Import/Export utilities, Oracle SQL* Loader, SQL Navigator, SQL Developer, SQL*Plus, TOAD, PL/SQL Developer, Teradata SQL Assistant, ETL Process and Data Migration.
• Worked on export/import commands to move the structure and the data from development to production.
• Having Good experience working with large kind of databases up to 10 terabytes of data.
• Extensive experience in performance monitoring and tuning in Oracle/MS SQL Server. Expertise in creating stored procedures, functions packages, collections and bulk collections using PL/SQL. Worked on Oracle 10g Enterprise manager and Configured Listener and Network configuration.
• Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
• Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.
• Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
• Having Good knowledge of Pearl, Python, UNIX, and Shell Scripting.
• Strong understanding of Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL).
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.

TECHNICAL SKILLS:

Databases: Oracle 8,8i, 9i, 10g, 11g, SQL Server 2000/2005/2008, MySQL, Microsoft Access

Oracle Software: TOAD, SQL *PLUS, SQL Navigator, SQL Server Management Studio, Teradata SQL Assistant, Reports & Forms developer suite, TKPROF, EXPLAIN PLANSQL*Loader, SQL Developer

Software's: MS Visio, MS Project, MS Office, Informatica

Scripting: HTML, XML, DOS, Korn & Bourne Shell Scripting

Operating System: Windows NT/2000/2003/XP/VISTA, Linux, UNIX.

Programming Languages: PL/SQL, SQL, T-SQL and Core Java

Version Control Tools: CVS, Clear Quest, Clear Case

WORK EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle PL/ SQL Developer

Responsibilities:

• Understand the legacy Data Model and migrate data into PLM using Back Office tool to migrate the data.
• Drilled deep into the existing data model, understood the business requirements, data relationship and data flows to gain insight of the business model and suggest better ways to implement newer functionality.
• Involved 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 knowledge to quality assurance analysts regarding the model.
• Performed normalization of the OLTP database to eliminate redundant data.
• Developed PL/SQL Procedures, Functions, Cursors, and Packages using SQL Developer, TOAD and Oracle 10g.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates using Oracle TOAD.
• Migrated data from MY SQL to Oracle.
• Worked on PL/SQL Implicit, Explicit, and REF Cursors and created Triggers for tables using SQL Developer.
• Performed DBA activities such as creation of roles, granting privileges to the role, creating database link to connect to users under different instance.
• Created dynamic sql queries using Execute Immediate statements.
• Extensively used SQL Loader and import/export toolbar to load the data from excel files into oracle.
• Extensively used REF cursors to pass out the required data set to the front end team working on JAVA
• Extensively worked on cursors, SQL joins (inner join, outer join, anti-join), views, packages, procedures, functions.
• Worked with Collections to reduce overhead involved with cursor looping. Bulk fetched the data from sql engine into collection. Handled exceptions using SAVE EXCEPTIONS and %bulk exception.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Extensively used materialized views, pragma autonomous transactions, object types, table functions, and pipelined functions to implement business logic effectively.
• Involved in several discussions with the client team to discuss the modification and deliver updates of the project.
• Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Error handling using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Resolved Priority Production Support Issues and Defect Fixes in PL/SQL code.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database.
• Unit testing the PL/SQL code. Made necessary database structure changes for OLTP as per business requirements.
• Created batch files for automation of SQL script files and scheduled those using windows scheduler.
• Automated executing script files through UNIX using Autosys. Worked on basic UNIX commands for FTP data from one location to another.

Environment: Oracle 11g, Oracle Forms 10g, SQL, PL/SQL, MYSQL, SQL Developer 3.0.03, UNIX, TOAD, Back Office Tool, MS SQL Server 2008 and Shell scripting (Bourne and Korn).

Confidential, Greenville, SC

Oracle PL/ SQL Developer

Responsibilities:

• Involved in development of ETL Jobs using SQL Developer for data migration between different maintenance systems.
• Extensively involved in ETL code using SQL in order to meet requirements for Extract, transformation, cleansing, and loading of data from source to target data structures.
• Enhance the old Logical Query Design to fit new business requirement, and implemented new design into SQL Server2008 and Oracle SQL Developer.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Creation of database objects like tables, views and procedures using oracle tools like SQL Developer.
• Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created Batch files using DOS scripting language for automation process.
• Involved in the continuous enhancements and fixing of production problems.
• Tuned SQL statements using Explain Plan, SQL Trace to improve the performance.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Preparing UTP (Unit Test Plans) as per the RS (Requirement Specification), FS (Functional Specification) provided by the Business Analysts.
• Extensively worked with BA team to fix the defects that are logged.
• Involved in the continuous enhancements and fixing of problems.
• Performed ETL tasks like Extract Transform and Load Process when loading data into tables using Datastage.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Preparing UTP (Unit Test Plans) as per the RS (Requirement Specification), FS (Functional Specification) provided by the Business Analysts.
• Extensively worked with BA team to fix the defects that are logged.
• Involved in the continuous enhancements and fixing of problems.
• Performed ETL tasks like Extract Transform and Load Process when loading data into tables using Datastage.
• Involved in developing Microsoft Access applications for front end applications.

Environment: Oracle 11g, SQL Developer, MS SQL Server 2008, Microsoft Access, DOS scripting, CVS.

Confidential, Bridgewater, NJ

Oracle PL/ SQL Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions, packages and bulk collections.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Developed complex SQL queries for reports. SQL Programs, Tables, Views, and PL/SQL 9i program units for possible changes in connection with the column expansion project.
• Developed complex triggers in reports before/after for validation of user input.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Performed unit testing and supported integration testing and end user testing. Extensively worked on production issues with effective defect management.
• Analyzed the business logic with DSO(Data Strategy & Operations) team and identified bugs in the existing code and efficiently fixed them
• Developed Informatica Mappings, Sessions and Workflows using transformations (reusable & standalone)
• Modified the existing ETL mappings to load the data from the core to target database and data warehouse and from Staging to Reporting databases
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER etc.
• Involved in creating and generating Oracle Reports for the application.

ENVIRONMENT: Oracle 10g, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD, Reports10g

Confidential

Oracle PL/ SQL Developer

Responsibilities:

• Participated in analysis, design, development, and testing of the application.
• Developed PL/SQL batch processing jobs using UNIX Shell scripting.
• Participated in writing PL/SQL, stored procedures/packages, triggers, bulk collections, constraints, cursors (Implicit, Explicit, REF), views and indexes using SQL Developer and TOAD.
• Created Informatica mappings for loading the data from flat files and 3rd party Data providers into Staging
• Worked extensively on tuning of mappings/sessions using session partitioning and lookup strategies to address bottlenecks.
• Performed multi-source Extraction Transformation and loading (ETL) into the Repository using Informatica.
• Worked on Data Backup and Data Recovery using RMAN.
• Hands on experience in using database designing tools like Erwin and PowerBuilder.
• Strong knowledge in using views, Materialized views, Export and Import Utilities provided in Oracle TOAD.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Experienced in using Oracle Utility programs like SQL*Loader, SQL Developer and External Tables.
• Extensively participated in performance tuning for various oracle based application using various methods like SQL Trace, EXPLAIN PLAN, TKPROF etc.

Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, ERWIN, Informatica, SQL*Loader, CVS, TOAD, Dynamic SQL, Eclipse, EXPLAIN PLAN, TKPROF, UNIX.

Confidential, NY

Oracle PL/ SQL Developer

Responsibilities:

• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts.
• Created and Modified PL/SQL Triggers, Procedures, Functions, packages and bulk collections using PL/SQL.
• Performed data loading/ unloading from both CSV and flat files with the help of Utilities provided in and TOAD.
• Participated in importing and migrating Source/Target Tables from the Oracle databases and created reusable components to optimize the process.
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus.
• Participated in migration of the databases from Oracle 8i to Oracle 9i. Exported reports into formats such as PDF, Excel, and CSV.
• PL/SQL Programming participated in designing and developing various complex stored procedures, Functions, materialized views, cursors (Implicit, Explicit, REF), Packages using TOAD and Oracle developer suite.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Worked efficiently with Informatica client tools and several transformations including Source Qualifier, Lookup, Aggregator, Expression, Filter, and Update Strategy.
• Developed SQL*Loader scripts to load data in the custom tables. Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Implemented the Referential Integrity constraints through different Check Constraints and Triggers.
• Implemented security by creating different Users and assigning Roles to Users.
• Performed Integration, Functional and Unit Testing on code.
• Participated in improving the performance of the Queries using TKPROF and EXPLAIN PLAN.

Environment: Oracle 9i/10g, Oracle Reports & Forms 9i/10g, J2EE, PL/SQL, SQL *Loader, TOAD.

Confidential

Oracle PL/ SQL Developer and DBA

Responsibilities:

• Responsible for designing schema using Erwin data modeler and generate the DB scripts using the tool
• Worked with Sql*Loader to import and export data from the flat files in and out of the legacy database.
• Participated in the development of new PL /SQL procedures, functions, and triggers and also updating the old ones based on the change requests.
• Created various DML and DDL statements using Oracle Pl/SQL and SQL.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.
• Assist Java development team for writing SQL Queries for the application

Environment: Oracle 8i, SQL, PL/SQL, HTML, XML, J2EE, TKPROF, HTML, SQL*Loader.

Confidential

Oracle PL/ SQL Developer and DBA

Responsibilities:

• Responsible for designing schema using Erwin data modeler and generate the DB scripts using the tool
• Assist Java development team for writing SQL Queries for the application.
• Worked with Sql*Loader to import and export data from the flat files in and out of the legacy database.
• Scheduling Job using Oracle DBMS JOB packages
• Participated in the development of new PL /SQL procedures, functions, packages and triggers and also updating the old ones based on the change requests.
• Created various DML and DDL statements using Oracle Pl/SQL and SQL.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.

Environment: Oracle 8i, SQL, PL/SQL, J2EE, TKPROF, HTML, SQL*Loader.