SUMMARY:

• Having 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle RDBMS, ETL (DataStage) and Oracle Applications ERP/E - Business Suite (EBS) 11i/R12.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies
• Proficient in Oracle SQL, PL/SQL.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Having experience with ODI.
• Having experience in OBIEE.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions as per the requirements.
• Effectively made use of Table Functions, Indexes, Collections, Analytical functions, Materialized Views.
• Developed new reports using Reports6i/10g, Discoverer10g, SSRS.
• Experience in Oracle Applications 11i/R12 and BI/XML Publisher.
• Developed new and customizing existing forms using Forms6i/10g.
• Experience in Data Modeling(Conceptual, Logical, physical)
• Experience in RDBMS (Normalizing) concepts.
• Created Tables, Views, Constraints, Indexes.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience with Oracle Supplied Packages such as DBMS SQL and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Expertise in Collections and Exception handling.
• Experience in SQL Performance Tuning.
• 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
• Developed conversions and interfaces using PL/SQL.
• Experience in Erwin.
• Proficient in writing stored procedures, packages, functions, API & triggers using PL/SQL.

TECHNICAL SKILLS:

ERP: Oracle Applications (11i/R12)

Languages: Java, JavaScript, C, C++, SQL and PL/SQL

Databases: Oracle, SQL Server

Operating Systems: Windows, Linux, UNIX.

Tools: TOAD, SQL Developer, Data Loader, WINSCP, SVN

Development Tools: Bi/XML Publisher, Reports6i/10g, Forms 6i/10g, Discoverer 10g, SSRSReports, DataStage

Documentation Tools : MS Office 2003/2007/2010

Data Modeling Tools: Erwin7.1, Oracle Designer

PROFESSIONAL EXPERIENCE:

Confidential, Monroeville, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed new Inventory Reports using PlSql Packages and XML.
• Developed a Conceptual model using Erwin based on requirements analysis
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Devloped Edi reports for different Manufacturers.
• Involved in Business Requirements Analysis with the Business users and Analysts.
• Devloped Unix scripts as per requirement.
• Involved in Datawarehouse, processing high volume of data using batch processing.
• Developed New,Modified Reports as per requirement using Reports10g.
• Developed New,ModifiedForms as per requirement using Forms10g.
• Involved in the continuous enhancements and fixing of production problems.
• Created Pl/Sql Packages as per requirement.
• Created PL/SQL scripts for materialized views.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexe s on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Prepared the Technical Design Documents and Lower level Design documents for the technical specs.
• Prepared the Implementation plan for the code migration to QA/Production.
• Preapared the Unit test documents for QA testing.
• Unit tested migrated (imported/exported jobs) and deployed the code in various environments.
• Conduct Code reviews and coordinated with Testing Teams during different phases (DEV/UAT) of Testing.
• Mentored the Offshore Teams in getting development work done in given timelines.

Environment: Data modeling, Oracle ERP, Oracle 11g,Oracle Reports,Forms10g, Erwin

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Business Requirements Analysis with the stake-holders.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Developed Reports as per requirement using SSRS.
• Worked on Oracle ODI to loading and extracting data from different sources.
• Involved in Datawarehouse, processing high volume of data using batch processing.
• Modified Forms as per requirement using Forms10g
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexe s on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Prepared the Technical Design Documents and Lower level Design documents for the technical specs.
• Prepared the Implementation plan for the code migration to QA/Production.
• Developed Parallel jobs using Parallel stages like: Join, Lookup, Transformer, Oracle, Dataset, Funnel, Change Capture, Filter, and Teradata.
• Unit tested migrated (imported/exported jobs) and deployed the code in various environments.
• Created job sequences to handle the load dependency.
• Tuned DataStage jobs for better performance to bring design parallelism.
• Conduct Code reviews and coordinated with Testing Teams during different phases of Testing.
• Mentored the Offshore Teams in getting development work done in given timelines.

Environment: SAP, IBM WebSphere, Oracle 10g/11g,SSRS Reports, Crystal Reports,Reports10g,Forms10g, Asp.net,AS400

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Business Requirements Analysis with the stake-holders.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Developed Reports as per requirement using Reports10g/6i
• Modified Forms as per requirement using Forms10g/6i
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexe s on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Prepared the Technical Design Documents and Lower level Design documents for the technical specs.
• Prepared the Implementation plan for the code migration to QA/Production.
• Developed Parallel jobs using Parallel stages like: Join, Lookup, Transformer, Oracle, Dataset, Funnel, Change Capture, Filter, and Teradata.
• Unit tested migrated (imported/exported jobs) and deployed the code in various environments.
• Created job sequences to handle the load dependency.
• Tuned DataStage jobs for better performance to bring design parallelism.
• Conduct Code reviews and coordinated with Testing Teams during different phases of Testing.
• Mentored the Offshore Teams in getting development work done in given timelines.

Environment: Oracle EBS R12, IBM WebSphere DataStage 8.1, Oracle 10g/11g,Reports10g,Forms10g, Autosys, Web-Services stages

Oracle PL/SQL Developer

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in code reviews and test case reviews.
• To load and extract from multiple sources using Oracle ODI
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developing new reports and customizing existing reports.
• Developed reports using Reports10g and BI/XML Publisher
• Defined value sets, concurrent programs, registering reports and PL/SQL procedures and functions.
• Worked on Discoverer Reports
• Worked on XML Publisher Report.
• Preparation of SQL Loader scripts
• Involved in code reviews and test case reviews.

Environment: Oracle Applications R12.1.3 (AR, AP, GL, PO, FA, OM, INV), SOA, Oracle 11g, Forms10g, Reports10g, Discoverer 10g, PL/SQL, SQL*Loader, Toad, Workflow.

Oracle PL/SQL Developer

Responsibilities:

• Developing Conversion and PL/SQL Functions.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete SDLC.
• Designed and developed Oracle Reports & Forms.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Oracle Applications.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Defined value sets, concurrent programs, registering reports and PL/SQL procedures.
• Worked on Form personalization
• Developed reports using Reports10g and BI/XML Publisher
• Involved in code reviews and test case reviews.
• Developed Reports using Reports 10g, Discoverer 10g and XML publisher.
• Modified Existing Reports using Reports 10g and XML publisher.
• Developed interface scripts using PL/SQL for XML payload files.

Environment: Oracle Applications R12.1.3 (AR, AP, GL, PO, FA, OM,INV,WIP,WMS), SOA, Oracle 11g, Forms10g, Reports 10g, Discoverer 10g, PL/SQL, SQL*Loader, Toad .

Oracle PL/SQL Developer

Responsibilities:

• Handling the support and the enhancements for Raychem RPG.
• Developed interfaces and conversions.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete SDLC.
• Designed and developed Oracle Reports & Forms.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Oracle Applications.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Handling the support and the enhancements for Raychem RPG.
• Developed reports using Reports10g and BI/XML Publisher
• Customized Oracle Seeded Reports.
• Developed the data fixes and other custom programs.
• Developed the Custom reports as per the requirements.
• Gathered the required information from the users and tested the objects in UAT.

Environment: Oracle Applications R12.0.3, Oracle 11g, Forms10g, Reports 10g, Discoverer 10g, PL/SQL, SQL*Loader, Toad .

Oracle PL/SQL Developer

Responsibilities:

• Handling the support and the enhancements for ANTALIS.
• Preparation of SQL Loader, PL/Sql scripts.
• Validation of staging data before insertion into Oracle base tables or Interface tables
• Developed the data fixes and other custom programs.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in code reviews and test case reviews.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

ENVIRON Environment MENT: Oracle Applications11.5.10.2, Oracle 9i, Forms6i, Reports 6i, Discoverer, PL/SQL, SQL*Loader, Toad.

Oracle PL/SQL Developer

Responsibilities:

• Created and modified custom and standard reports of all the financial modules as per the client requirements.
• Customized various financials GL, AR, AP interfaces between people soft, payroll and other third party software.
• Responsible for requirement gathering for new enhancements from clients and providing resolutions to the issues.
• Creating packages, procedures, functions, trigger and other database objects using SQL and PL/SQL
• Worked on AOL objects to registered Custom Programs, Executable, Concurrent Programs and Request Sets, value sets as per the requirement.
• Defined alerts as per the requirements AP,PO Modules
• Also worked on the form Personalization, SQL* Loader, Data loader and SQL scripts.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in code reviews and test case reviews.
• Migration of code using PVCS into Development, QA and Production environments.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and TKPROF.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Environment: Oracle Applications11.5.10.2, Oracle 9i, Forms6i, Reports 6i, PeopleSoft, PL/SQL, SQL*Loader, Toad.