SUMMARY

• Around 9 years of experience in various phases of Software Development Life Cycle and Agile methodologies involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors, etc).
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL Developer, and PL/SQL Developer
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers for Oracle Relational Databases.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc.).
• Extensive development experience in data designing, mapping, Loading data, Testing and Tuning databases.
• Hands on experience in working with advanced PL/SQL concepts such as Collections, Objects, records, Native dynamic SQL.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan.
• Extensive experience in working with standard Microsoft software applications like Word, Excel, Microsoft Project, PowerPoint and Visio.
• Good Knowledge in data extraction, transmission and loading.
• Strong analytical skills with ability to quickly understand clients’ business needs and identify available data sources and the relationships that exist within them.
• Experience in creating Forms and Reports using Oracle tools like Oracle Forms (10g/6i/5.0/4.5) and Oracle Reports (10g/6i/3.0/2.5).
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, Explain plan.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Experience in Oracle Apps 11i GL, AP, AR, OM modules.
• Experience in Production Support and the ability to provide time - bound and quality driven solutions have cultivated decision-making and analytical ability
• Worked with Toad Data Modeler 3.4 as a data modeling and design tool.
• Ability to learn and adapt quickly in a dynamic environment and Ability to work on multiple projects against aggressive deadlines.
• Good Communication, Writing, Presentation, Workforce Management, Interpersonal and Analytical skills, along with the ability to work on multiple projects and prioritize workload
• Self-starter can work independently as well as a good team player.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i, SQL Server 2008

DB Utilities: SQL*Plus, SQL*Loader

RAD tools: Oracle Reports 6i, WinScp, and FTP etc

Languages: SQL, PL/SQL, C, Java.

Version Control tools: Tortoise SVN 1.8, Git 2.10.3, PVCS, IBM Rational Synergy 7.1

Operating Systems: Windows7/Vista/XP/,UNIX (Sun Solaris, HP-UX)

Developer Tools: Reports 10g, TOAD 12.8,10.6, 10.1, 9.6.1, 8.5, 8.1, Eclipse IDE

Web Technologies: HTML, XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Oracle Developer

Responsibilities:

• Reviewed the business requirement, functional specification document(FSD) for various modules so as to have good understanding of the application.
• Worked on the existing Oracle framework tables to make changes according to the business requirements.
• Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
• Created the tables and sequences for the experimental data load capture.
• Created Stored Procedures, Packages, Functions to massage data, validate data and to implement complex business rules.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
• Built physical data structures like tables, views, indexesand constraints.
• Implemented Sub partitions, CTAS (Create Table as Select), Exchange partition to load data into target tables.
• Used techniques like direct path load, for loading the data faster and created filters in Control files to pre-process data, as part of performance tuning.
• Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries.
• Rebuilt large indexes and index partitions using parallel nologging mode.
• Designed and developed several complex database procedures, packages.
• Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Gathered the business requirement from clients and translated the business details into technical requirements.
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG & ROW NUMBER Functions for sorting data.
• Implemented CTAS (Create Table As Select) approach to optimize an update process reducing runtime
• Played an important role in performance tuning most complex SQL queries using Hints, Indexes.
• Involved in optimization ofSQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Extensive documentation of the source and target tables and the description of the objects in the Excel document and developed Excel Report using the procedural code.
• Worked onSQL*Loader and External Tables for Export/Import of data.
• Worked on Table structures along with the Triggers, Indexes like Bitmap and Function based Indexes.
• Worked on test driven database(TDD) development environment, used DbFit an open source tool for automated database testing. Identifying test cases and preparing test plans.
• Resolving the Tickets and pulling the data from the Transactional database and Archive database for the reports.

Environment: Oracle 11g/12c, PL/ SQL,SQL *Plus,SQLdeveloper, TOAD, Eclipse IDE.

Confidential, NY

Sr. Oracle Developer

Responsibilities:

• Generated DDL scripts and created and modified database objects like Tables, Views, Sequences, Functions, Procedures, Indexes, Packages, Records and Collections using TOAD.
• Involved in performance tuning using Oracle Hints and Explain Plan for existing Views and Queries.
• Improved the performance of Materialized View Refresh from 4 hrs to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Gathered the business requirement from clients and translated the business details into technical requirements.
• Enhanced a module's performance in a preexisting product by 2800% faster (reducing runtime from 16 hours to 40 mins) adopting a more efficient data accessing path than the old one.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
• Tuned sql queries based on recommendations from OEM. Sql tuning performed with the help of AWR reports.
• Monitored the Applications and database using OEM and OAM.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Involved in writing complex SQL Queries to implement the business requirements.
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.
• Developed technical design documents by reviewing functional requirement documents in an agile environment.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts

Environment: Oracle 10g/11g, TOAD 12.6, SQL*Loader, Windows Server 2008/Windows 7, UNIX, IBM Rational Synergy 7.1, Eclipse IDE

Confidential, MD

Sr. Oracle Developer

Responsibilities:

• Develop SQL* Loader scripts for data extraction and transformation.
• Extensive use of Collections like Index By Tables and nested tables.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data.
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Validating extracted data from Legacy system.
• Developed stored procedures / packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Experience in creating Forms and Reports using Oracle tools like Oracle Forms (10g/6i/5.0/4.5) and Oracle Reports (10g/6i/3.0/2.5).
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Tuned sql queries based on recommendations from OEM.
• Implemented Data ingestion process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Implemented various UNIX scripts to generate the data in CSV and txt format
• Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts
• Worked on logical and physical data modeling and created Materialized views.

Environment: Oracle 10g/11gTOAD 10.1, TOAD DATA MODELER 3.4, SQL*Loader, Windows Server 2008/Windows 7, HP-UX

Confidential, PA

Sr. Oracle Developer

Responsibilities:

• Used SQL*Loader and PL/SQL programs to Convert data from many legacy systems to Oracle 10g and to store data in the Oracle database from different types of flat files.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Designed, developed and enhanced custom Oracle Reports 9i according to the functional specification.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, Records and Collections using TOAD tool.
• Extensive use of Collections like Varrays, nested tables and Sub-queries and joins in stored procedures.
• Support and modify existing PL/SQL code (Flow Through’s) in various legacy systems.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Used Bulk Collect, PL/SQL tables, arrays and other collection to improve the performance of the system.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed various Mappings to load data from various sources using different Transformations.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.

Environment: Oracle 9i/10g, PL/SQL Developer, SQL*Plus, TOAD 9.6, SQL*Loader, Windows Server 2003, Sun Solaris, UNIX Sun Solaris

Confidential

SQL Developer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, and Packages
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic
• Written a number of Cursors to select various types of records
• Worked with Bulk Collects to improve the performance of multi-row queries
• Used the Pragma Exception INIT to name the system exceptions that are raised by the program
• Extensively involved in Export (exp) and Import (imp) utilities to move data between different databases and schemas
• Created various PL/SQL Scripts involving Insert, Sequences, Constraint and Index scripts
• Worked with Bulk Collects to improve the performance of multi-row queries
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays)
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using SQL*Plus, TOAD

Environment: Windows XP, Oracle 9i, PL/SQL, HTML, Java, Unix, Linux