SUMMARY:

• Having over 8 Years of Experience in Oracle EBS R12 Financials/SCM Modules with experience in Oracle Application Framework (OAF), BI Publisher Reports & RICEW (Reports, Interfaces, Conversions, Workflow's).
• Extensive experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Involved in Complex SQL Queries and writing PL/SQL programs (Packages, Functions, Triggers, procedures).
• Experience in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper10g and 11g environment.
• Expertise in implementing RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) components in the area of technical design, development, Integration testing and deployment.
• Experience in design, analysis, development, testing and implementation of applications in Oracle E - Business Suite R12/11i, Oracle 11g/10g, Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML Publisher 5.6, Work Flow Builder 2.6, JDeveloper10g/11g OA Framework.
• Experience in SQL* Loader, Oracle API’s and UTL FILE Packages for data conversion and interfaces.
• Good knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40 AND CV70).
• Experience in Application System Administration activities like managing concurrent managers, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Developed Interface/Conversion (inbound and outbound) Programs using Open Interfaces and API's. Also developed Extensions to add additional validations and functionality to seeded oracle processes to meet the client's requirements.
• Worked on Design and Development of Interfaces and Data migration using SQL Loader, Oracle open interfaces.
• Creation of users, responsibilities, menus and request groups.
• Experience in working with T hird party tools.
• Expertise with using Oracle database and writing and tuning SQL and PL/SQL queries.
• Used Putty, SSH, Telnet for UNIX login to check the server logs.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve client requirements .
• Ability to learn new technologies quickly.
• Possess excellent analytical and leadership skills and Strong ability to multi task and prioritize work load.
• Excellent verbal and communication skills with ability to work in a team and as well as individually.

SOFTWARE SKILLS:

Languages: SQL, PL/SQL, Java, Java Script, HTML

Oracle Applications: AP,PO,INV,GL, AR, HR, PA, OIC, OFD, Service Contracts and OM

Tools: and Utilities PLSQL DEVELOPER,SQL DEVELOPER,PUTTY,SQL*Loader, SQL*Plus, Work Flow, XML Publisher, JDEVELOPER,PUTTY,WINSCP, XML, BI Publisher, Oracle Reports Builder, Form Builder, OAF, Oracle 9i/10g/11g.

GUI: Oracle Developer 2000, Forms 6i/10g, Reports 6i/10g, Java

Operating Systems: Linux, UNIX, Solaris, Windows NT/98/2000/XP/Vista/Windows 7/MAC OS.

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Senior Oracle EBS Developer

Responsibilities:

• Production application services - The services include maintenance to production applications to correct faults (fix when broken), performance monitoring, and problem support.
• Production database services - The services include database administration, maintenance to production databases to correct faults (fix when broken), performance and data growth monitoring, and purging and archiving of data. Provide ERP Application support by handling day-to-day issues
• Provide bug fixes to resolve these issues.
• Consolidation of user requirements to technical documents.
• Create custom tables, views and materialized views.
• Develop PL/SQL packages, procedures and functions.
• View Object extension for several OAF pages to display a new custom attribute column in the LOV.
• Developed new OAF pages through JDeveloper10G/11G.
• Worked on Customizations of OAF Pages.
• Write UNIX Shell scripts for coping and moving files to and from the server.
• Attending Review calls, team meetings and knowledge sharing meetings.
• Involved in Procure to Pay (P2P) & Order to Cash (O2C) business flow.
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into oracle purchasing (PO) using SQL*Loader and PL/SQL validations
• Design and Developed Budget Over Head report which shows each account and summary account level what is the Budget amount and Actual Amount in Oracle GL.
• Design and Developed Custom Check format for the new operating unit.
• Design and developed Supplier Remittance Advice Email in Payables.
• Design and Developed Inventory Monthly Transaction report and Inventory Monthly Balances report MD050, MD070 using BI Publisher.
• Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.
• Designed and Developed the Item Import, Item Assignment and used the Standard Interface Program to import.
• Design and Developed Contract’s Expiration Report to send to email of Resource Managers using XML Bursting technique in BI Publisher
• Developed new programs to integrate the data from Oracle to BO system to generate reports.
• Customized Reports in Account Receivables using XML/BI Publisher.
• Working with the users and fixing the issues related to SIT testing.
• Worked on Resolving Tickets, databases to fix issues and data growth monitoring.
• Used Putty, SSH, Telnet for UNIX login to check the server logs.
• Customization of forms, reports, xml publisher reports.

Environment: Oracle E-Business Suite R12 (12.2.5), Unix, JDevloper11g, Reports 10g, Forms 10g, Discoverer 11g, SQL*Loader, TOAD, Unix Shell Script, XML/BI Publisher, OA Framework(OAF).

Confidential

Senior Oracle EBS Developer

Responsibilities:

• Worked on OAF reports. Worked on OAF forms.
• Interaction with client/end users & updating the status.
• Training the end users and preparing end user training material.
• Attending Review calls, team meetings and knowledge sharing meetings.
• Worked on UNIX to upload the data into database tables.
• Worked BRSD rejection reason Interface to upload all the rejected orders.
• Developed PLSQL code for OAF forms.
• Worked on developing Customer Account update, Customer Profile updates Conversion in AR.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Worked on Technical Document and development of Sales Contract Conversion.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables AR, Chart of Account Detail Listing Report using XML/BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Report Builder.
• Developed Receivable label report which included barcode designing in it using XML/BI Publisher.
• Order Details screen - Created an Order detail report in XML Publisher and integrated the Report in OAF. Worked on objects of OAF extension based on the small changes required by the client.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Developed OAF forms to view the manager details, user details.
• Preparing End user manuals to all the developed pages.
• Create custom tables, views and materialized views.
• Develop PL/SQL packages, procedures and functions.
• Worked on Monthly calculation run, and Quarterly calculation run for EBU Reseller.

Environment: Oracle E-Business Suite R12(12.2.2), XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, OA Framework(OAF).

Confidential

ERP Oracle Apps Developer

Responsibilities:

• Requirement Study in detail interaction with other modules consultants.
• Testing P2P and O2C cycles.
• Worked on Query find Forms.
• Customized Invoice History Report.
• Design and Developed a Sales Order Report - XML Report.
• Created a report on Projects, AR, OM, PO, INV and GL modules, using Reports 10 g, XML/BI Publisher and Custom Packages.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked on Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Reports 10g.
• Created complex templates and dynamic parameters to produce the output in EXCEL formats.
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Modified Functional Specification (MD050), Created Technical design document (MD070) and created Installation document (MD120).
• Worked on Item Interface to upload items including Categories and revisions.
• Worked on Daily Rates Interface to upload exchange rate dates from legacy systems to GL Base Tables.
• Worked on Forms Personalization.

Environment: Oracle EBS 11i/R12, Inventory (INV), Purchasing (PO), Order Management (OM), Account Payables (AP), General Ledger (GL), XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX.

Confidential

Oracle EBS Developer

Responsibilities:

• Building the SQL Queries. Worked on custom and customization of forms.
• Requirement Study in detail.Interaction with client/end users & updating the status.
• Training the end users and preparing end user training material.
• Attending Review calls, team meetings and knowledge sharing meetings.
• Working with third party tools for integrations.
• Worked on Customization of forms, reports, xml publisher reports.
• Worked on Interfaces & Conversions.
• Customized Incomplete Invoice Report.
• Developed Prepayment Receipt Report using XML Publisher.
• Worked on PO Interface to upload the Headers, Lines and Distributions Details from the legacy to PO.
• Imported the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's in General Ledger (GL) using Journal import.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Developed Sales Order conversion in Order Management (OM) to import Sales Orders from Legacy system using SQL * Loader.
• Worked on Shipping APIs for updating base tables when shipping is done by third party shipping.
• Imported the data from legacy systems into the temporary tables in Account Receivables (AR).
• Designed and developed the Account Receivables (AR) extension called Balance Forward Billing process for preferred customers wishing consolidated bills at site level based on the predefined payment terms on the Bill to Locations.
• Worked on Supplier Interface.
• Developed Outbound interface to extract data from Base tables to Flat file using the UTL FILE utility in HRMS/Financials module.
• Customized GL Search Form by enabling existing DFF to store tax details.
• Customized PO Workflow to populate the Charge account in PO distributions.

Environment: Oracle EBS R12 modules: SCM, Inventory (INV), Purchasing (PO), Account Payables (AP), General Ledger (GL), Fixed Assets (FA), HRMS, PA, CM, XML/BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX.

Confidential

Oracle Apps Developer

Responsibilities:

• Designed and developed customized reports.
• Involved in unit testing and performance testing for reports.
• Interaction with the client to analyse the business requirements and perform fit gap analysis.
• Involved in Implementation of complete solution at client and providing post production support.
• Creation of purchase requisitions into oracle applications using PO interface.
• Handling version control system for maintaining the versions.
• Testing all the components and P2P cycles.
• Developed forms using ZOOM functionality that pops up appropriate form.
• Built custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the calendar feature, WHO columns, defining DFFs etc.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various developed custom PL/SQL Packages.
• Design of custom flex fields to map the business requirements.
• Customization of oracle forms and development of new custom forms.
• Customization of oracle Applications reports.
• Preparation of test cases.
• Created Tables to store Levelling Field Survey Book Information
• Designed Forms to enter Levelling Field Survey Book Information
• Design the Data modal and creation of tables, views, indexes
• Developing and Debugging of Forms and Reports.
• Developing and Debugging of Triggers and Packages.
• Preparation of Unit and Integration Test Cases.

Environment: Oracle Applications R11.5.10, Oracle 10g, Sun Solaris 5.8, Windows 2000/XP/NT, Forms 6i, Reports 6i, TOAD, SQL *Loader.