EXPERIENCESUMMARY

• Working as Oracle Developer with 8 years of IT experience in analysis, design, development, testing, Production support and deployment of custom reports, forms, and workflow.
• Experience with all phases of the Software Development Life Cycle(SDLC) including analysis, Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Proficient in creating PL/SQL Packages, Procedures, Functions, Exceptions, Views, Triggers, Grants and Synonyms.
• Experience in query level performance tuning using Explain Plan.
• Experience in loading high volume data and Performance Tuning using Partitioning and Indexes for fine tuning and optimizing SQL and PL/SQL queries.
• Experience indeveloping formsbased onviews, tables and proceduresin tabular and form layout.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
• Good knowledge in front end development usingoracle forms/reports6i/9i/10g.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object - Oriented programming, collections, records, index-by tables, object types and methods.
• Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc.
• Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Experience in Query optimization&Performance tuning using Explain Plan, Performance Monitor.
• Experience in developing user interface for database applications using the Oracle Apex.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism.
• Extensive experience of Oracle tools like TOAD, SQL*PLUS, and PL/SQL Developer.
• Experience in data loading from other databases and text files into Oracle database using SQL*Loader, Import/Export, Bulk Collect.
• Strong working experience in Data Analysis, Modeling, Logical and Physical database design.
• Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Proficient in ETL Processes using Oracle PL/SQL, Unix Scripts and SQL*Loader for data migration to Enterprise Data Warehouse with large data volume.
• Developed UNIX Shell scripts to run various utilities.
• Expertise in creating shell scripts andused Crontab in UNIX environment for scheduling routine tasks.
• Experience in UNIX Shell Scripting and Knowledge of Crontab in UNIX environment for scheduling routine tasks
• Experience in releasing the enhancements and code fixes into various environments through the process of Release Deployment.
• Knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, and Data Marts used in relational and dimensional modeling.
• Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Knowledge of DBMS SCHEDULER, DBMS JOB, DBMS DATAPUMP, and UTL FILE packages.
• Good understanding of the concept of Normalization.
• Worked with the technical teams and DBAs for issues related to code changes, data fixes, and testing .
• Possess excellent communication, interpersonal and presentation skills.
• Excellent team player with the ability to work independently and interact with people at all level.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i, MS-Access XP, SQL Server

Environment: UNIX (Sun Solaris 5.8/5.9, HP-UX 11/11i, IBM AIX 5.2/5.3), Red Hat Enterprise Linux 3, Windows 2003/2000/XP/98

Languages: SQL, PL/SQL, Shell Programming, C, C++

Tools: TOAD 9.0/9.6, SQL*Plus, PL/SQL Developer 7.1.5, Oracle Enterprise Manager, Vi Editor, Putty, MS VISIO 2000/2007, SQL*Loader, TKPROF, SQL*Navigator v.4.5, ClearCase, MS Virtual SourceSafe, Oracle Forms/Reports 10g/6i

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle PL/SQL Developer

Responsibilities:

• Involved in different phases of SDLC for all the new modules including Physical and Logical Design, Code Development, Testing, Implementing and Maintenance
• Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables
• Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG& ROW NUMBER Functions for sorting data.
• Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
• Handle the Stability/Improvement project - Analyze the Oracle AWR/ADDM report and suggest for performance improvement for slow running reports or jobs, review the database tablespace with DBA and add space to the tablespace, Investigate Major job failure and come up with solution.
• Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Proficiently developed new Packages, Functions, and Stored Procedures using PL/SQL as well as modified the existing ones as per the user requirement
• Used Bulk collect and Forallin 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
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
• Developed PL/SQL Procedures, Functions and Packages for Business Intelligence.
• Involved in Data Extraction, Transformation and Loading (ETL process) from source to target and worked on scheduling jobs and monitoring logs.
• Extensively created Tables, Indexes, Views, and Sequences for the new modules
• Experience in Exception handling
• Developed and maintained the system using Oracle Forms, Oracle Reports.
• Created synonyms and granted privileges on schema objects for other users to be able to share and access content
• Experience in deploying forms and reports on the web
• Worked extensively with advanced features of PL/SQL like record and table types
• Experience in using Explain Plan for query level performance tuning
• Involved in periodic Performance Tuning and Unit Testing of the PL/SQL code by using appropriate joins, indexes, and partitions
• Coordinated with the offshore support team in resolving critical issues during the Production Run
• Worked with DBAs to analyze performance as well as during table space and schema lock issues
• Performed Data Migration between different environments using DB Links
• Used other features like PL/SQL Wrapper, Hints, Materialized Views, and ERR$ Tables
• Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database
• Extensive experience of promoting the new initiatives, enhancements and code fixes to various DEV and QA environments through the Deployment Process using UNIX platform
• Extensively used TOAD for development and administration of various relational databases objects
• Proficiently used, created, and maintained various codes and scripts on different branches of ClearCase (Version Control)
• Created and maintained documents and log reports for various modules including Release History on SharePoint
• Actively participated in periodic status meetings and conference calls

Environment: Oracle 12c/11g/10g, TOAD 10.2, Oracle Forms and Reports 10g, UNIX Shell Scripting, Control-M and Sub-Version (Version Control).

Confidential, NY

Sr. Oracle PL/SQL Developer

Responsibilities

• Involved in getting the User Requirements, Data Modeling & Development of the system
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Created PL/SQL Packages for easier application design and improved Performance.
• CreatedRecords, Tables, Objects, Collections, Views,Materialized viewsand Global temporary tables(Nested Tables and Arrays), and performed Error Handling.
• Extensively usedCursors, Ref Cursors, Dynamic SQL and Functions.
• Participated inPerformance TuningusingExplain Plan.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Developed UNIX Shell Script as required.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• 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 Forallin stored procedures to improve the performance and make the application to run faster.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Involved in trouble-shooting production database problems and report problems.
• Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.

Environment: Oracle 11g, Toad, Windows 7, HPUX, Pl/SQL, SQL, SVN, HP Service Manager, D-series.Discoverer Desktop, Discoverer Administrator, XML/BI Publisher, Oracle Applications E-Business Suite - R12.

Confidential, Providence, RI

Sr. Oracle Developer

Responsibilities

• Actively Participated in different phases of SDLC
• Designed and Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Extensively involved in writing SQL queries and sub-queries using TOAD 9.6
• Involved in creating Logical and Physical Models using ERWIN 4.0
• Developed Packages, Functions, and Stored Procedures using PL/SQL and maintained the scripts for various data feeds
• Created Indexes and Sequences for faster retrieval of the product information and enhance the database performance
• Used Bulk collect and Forallin stored procedures to improve the performance and make the application to run faster.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG& ROW NUMBER Functions for sorting data.
• Wrote extensive Exception handling procedures to handle exceptions
• Data loading from other databases and text files into Oracle database using SQL*Loader
• Participated inPerformance TuningusingExplain Plan.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Developed UNIX Shell Script as required.
• 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 Forallin stored procedures to improve the performance and make the application to run faster.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Involved in Periodical backups of Databases
• Developed Oracle Forms and Oracle Reports using 10g depending on the functional requirement document.
• Involved in database Restoration and Recovery.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Applicable knowledge of granting privileges on schema objects for other users to be able to share content
• Worked with advanced features of PL/SQL like record types and Dynamic SQL
• Used overloading feature of procedures, functions inside package
• Did query performance using joins, indexes, partitions and hints appropriately
• Wrote UNIX shell scripts to transfer and manage data within the database
• Involved in debugging, Tuning and Unit Testing of the PL/SQL code

Environment: Oracle11g, HP-UX 11/11i, ERWIN 4.0, TOAD 9.6, ClearCase, Oracle Forms 6i and 10g

Confidential, RI

Oracle Developer

Responsibilities

• Was involved in design, development, test and maintenance of Credit Scoring Application
• Involved with all phases of SDLC for creating Credit Report Application
• Created Logical and Physical Models using ER/STUDIO 7.5
• Involved in Data Analysis and requirements gathering to develop and design documents
• Created DDL scripts to create, alter tables, views, synonyms and sequences
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed new and modified existing Packages, Procedures and Functions as per the user requirements
• Created Triggers to implement business requirements
• Worked on trouble shooting of PL/SQL code using Exception handling
• Developed standalone procedures for specific tasks using Dynamic SQL and Cursors
• Experience with handling huge volumes of data
• Involved in improving query response time by creating partitioning on tables
• Shared content with fellow developers by granting them privileges on schema objects as well as creating synonyms for objects on different schemas
• Involved in the implementation of Database Backup before code release and Recovery
• Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Extensively used TOAD and SQL Developer tool for effective application development.
• Extensive experience in using Oracle Utilities like export/import utility and SQL Loader
• Extensively worked onformsproduction support.
• Extensively usedSQL*Loaderto load the data from the flat files to the database and validated the data with thePL/SQL procedures.
• Developing back-endPL/SQL packages, building UNIX shell scriptsfor data migration and batch processing.
• Defined database requirements and designed data model.
• Experience with using Explain Plan for tuning complex queries
• Wrote SQL queries to perform Data Validation and Data Integrity testing
• Used TOAD 9.0.1 for the development of stored program units for Oracle databases
• Created and maintained documents and log sheets related to the database requirement, accessible to the whole team
• Participated in weekly status meetings and presentations
• Actively participated through the whole life cycle of the project

Environment: Oracle 10g, Windows XP, IBM-AIX 5.2/5.3, TOAD 9.0, ER/STUDIO 7.5, MS Visual SourceSafe 2005

Confidential, Memphis, TN

Oracle Apps/PLSQL Developer

Responsibilities

• Active participation in the System Study, Physical Designing and Development of database
• Involved in creating technical documentation and Data Models using MS VISIO 2000
• Wrote DDL Scripts to create new database objects like tables, indexes, views, and synonyms
• Created and modified stored programs in the form of Packages, Procedures, and Functions for implementing the database intensive business rules
• Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
• Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.
• Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
• Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
• Wrote SQL scripts to create temporary tables and developed SQL*LoaderControl files to load the data into the temporary tables.
• Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
• Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
• Develop SQL* Loader scripts for data extraction and transformation.
• Used database trigger for making history of insertion, updating, deletion and all kind of audit routines
• Worked on complex SQL queries and sub queries on the testing servers for performance tuning
• Worked on User-defined and System defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS
• Used SQL* LOADER to load data from CSV files into the database
• Wrote small Linux Shell Scripts for automated jobs
• Generated various reports using MS Excel XP
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs Extensively involved in usingPL/SQLto build Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports10g and views for processing data, enforcing referential integrity and needed business rules.
• Code optimization/Performance tuning -Involved in performance management of variousPL/SQL reports & queries.
• Developing various reports using OraclePL/SQL. Also fine-tuned the reports queries to help save redundant database queries and thus save report execution time.
• Working directly with & reporting to Customers to understand the requirements.
• Production support for Allocations Processing system.
• Developed database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes and Views, which are different among the source and target systems, thus saving considerable time.
• Did Unit testing, System testing for the Data Integrity and the functionality of the newly created business requirements.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX Shell Scripts per the changing needs of the project and client requirements.
• 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.
• Involved in developing and scheduling using corn jobs to load the data into the database and export/import mechanism for data migration for bulk upload
• Monitored Alert Log Report and System Error Logs
• Assisted in code reviewing and testing
• Participated in the ongoing process enhancements and modification requests
• Responsible for maintaining the documents for business analysts

Environment: Oracle 10g, Red Hat Enterprise Linux 3, Developer/2000 (Forms 6i, Reports 6i), Windows NT/XP, SQL*PLUS, MS VISIO 2000, MS Visual SourceSafe 6.

Confidential

Oracle Developer

Responsibilities

• Involved in the design and development of the database design.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
• Responsible writing UNIX Shell scripts.

Environment: Oracle 9i, Sql*Loader, Pl/Sql, Toad, UNIX Shell Scripting.