We provide IT Staff Augmentation Services!

Oracle Apps Technical & Pl/sql Developer Resume

PROFESSIONAL SUMMARY:

  • Over 10 + years of programming experience as an Oracle Apps Technical &PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
  • Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E - Business Suite.
  • Extensive experience in Oracle Applications (11.X / R12) E-Business Suite Modules in Financial (GL,AP,AR), Oracle Manufacturing & Distribution (PO, OM, INV).
  • Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
  • Strong implementation knowledge of O2C (Order to Cash), P2P (Procure to Pay) end to end Cycles.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
  • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
  • Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Record Types and Dynamic SQL for DML operations for better performance.
  • Good experience with UTL FILE packages.
  • Good working experience with UNIX shell scripting
  • Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
  • Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports.
  • Possess good expertise in developing programs using UTL FILE, SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
  • Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
  • Experience in development of concurrent programs, customization and modifications of reports.
  • Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
  • Good experience in deploying objects from one instance to other instance using HP PPM kintana, CVS, PVCS and AppDB

TECHNICAL SKILLS:

ERP: Oracle Apps 11i, R12.

Modules: OM, PO, INV,HRMS, AP, AR, GL

L anguages: SQL, PL/SQL, SQL Loader, Unix Shell Scripts, JSP, C, C++, JAVA/J2EE, CSS, HTML, XML, ETL.

RDBMS: Oracle 11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2 MS Access.

Tools: TOAD, SQL, Reports6i & 10g and Forms 6i & 10g, XML Publisher, Workflow Builder, OAF.

Operating Systems: Windows XP/NT/2000, HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Technical & PL/SQL Developer

Responsibilities:

  • Providing offshore and managing team from onsite.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts.
  • Worked on migration of data base objects from 11g to 12c
  • Involved in writing Control File for SQL Loader to load sales order details into staging table.
  • Developed Standard Sales Order Open Interface to upload the OM data from legacy system into Oracle Apps Base .
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and worked with exceptions handling.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Created materialized views as per the client requirement
  • Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas
  • Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas

Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, TOAD, UNIX, ETL, Oracle 11g, Apex, Shell, APEX, Oracle ERP R12- OM,AR, INV MS Windows 7,VISIO, CVS, PVCS and App DB

Confidential

Oracle Lead PL/SQL Developer

Responsibilities:

  • Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Designed and developed various custom packages triggers and forms.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with Exception handling..
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Coding and unit testing the external interfaces
  • Involved in writing Control File for SQL Loader to load PO details into staging table.
  • Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.

Environment: Oracle ERP R12- OM,AR, PO, Oracle 9i/10g, SQL Loader, Reports 9i,forms 11g, SQL, PL/SQL, TOAD, SQL*Loader,ETL, UNIX, MS Windows XP/2000, Oracle Development Suite.

Confidential

Technical consultant

Responsibilities:

  • Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
  • Imported new, changed and completed sales orders from legacy system to oracle using order import(order management open interface).
  • Developed Bursting file for sending Item Receipt and Inspection details to suppliers.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Developed and designed dynamic configuration wrapper in perl to generate flat fund reports.
  • Provided backend support for various perl based applications.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..

Environment: Oracle ERP R12- OM,AP, PO,Oracle 9i/10g, Report 6i,SQL, PL/SQL, TOAD, UNIX, MS Windows 7, Apex 4.2, SVN.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Preparation of documentation like MD70 & TE40 etc.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Involved in writing Control File for SQL Loader to load sales order details into staging table.
  • Developed UTL FILE to extract the ASN(Advanced shipping notice ) from oracle apps standard table into text file.
  • Done supplier conversion in AP module for uploading the suppliers to the oracle applications.
  • Created PL/SQL Stored procedures, functions and packages as per the client requirement.
  • Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
  • Done item conversion in INV module for uploading the items to the oracle applications.
  • Customized in Purchasing Document Numbering.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Part of a development team for creation and maintenance of custom apps/reports
  • Implemented logic for add balance on DFF of Contract PO summary screen.

Environment: Oracle 8i, Oracle ERP 11i - PO,AP, INV, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved Migration of various Concurrent Programs From 11i to R12.
  • Involved in compiling the DB Objects from 11i to R12 Instance based on coding standards.
  • Aligned all DB Objects for compilation at one shot based dependencies.
  • Generating LDT files with FNDLOAD utility to migrate the objects to across instances
  • Prepared complete document to client for migrate the project from 11i to R12 instance.
  • Registration of Concurrent programs, attaching concurrent programs to Request Groups
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Developed Involved in Registering XML Templates for Reports in R12.

Environment: Oracle ERP R12- OM, AR, PO, AP, INV, GL,. Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Delivered the components on time with quality.
  • Involved in development of EDI transactions (850,856 and 810).
  • Review of RICE components and testing of the custom functionality
  • Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
  • Implemented the program for Merge Deliveries during packing.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Implemented the sales & budget process as for client requirement.
  • Involved in customizing and developing the Reports.
  • Loading Po's and generating the Sales Orders for that PO's Through Confidential EDI850 Form.
  • Involved in OM transactions Up to generating Invoice and testing the data.
  • Implemented PL/SQL program to validate order details before processes to sales order.

Environment: Oracle ERP R12- OM, AR, AP, INV, Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Confidential

Junior Developer

Responsibilities:

  • Responsible for analyzing business functionality for the back end processes.
  • Created PL/SQL Stored procedures, functions and packages as per the client requirement.
  • Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
  • Handled and managed customer relationship management system.
  • Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
  • Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
  • Involved in creating user interface Forms and adhoc reports using Oracle Forms/Reports 6i.
  • Built and performed user acceptance testing on modified reports.
  • Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle ERP 11i- PO,AP,INV,AR,.Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000

Hire Now