PROFESSIONAL HIGHLIGHTS

• Over 9 years of IT experience primarily in Oracle. Extensive experience in deploying enterprise applications and analyzing the business requirements, design, development, customization, extensions, implementation/ support of various business applications using Oracle e - business Suite.
• Extensively worked on OA Framework (OAF), PL/SQL, SQL, Oracle-AOL, Concurrent Programs, Oracle e-Business Suite (EBS) 11i (11.5.x), R12.1.2, R12.2.3 OC4J & BC4J, AOL (UI/Backend/Security).
• Hands-on experience in Oracle Order Management (OM), Manufacturing, Finance (GL/AGIS), Purchasing (PO), Bills of Materials (BOM), Work in Process (WIP), Inventory (INV), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL),Supply chain Module(SCM),Shipping, EAM.iExpense, iProcurement,custom.pll
• Responsibilities handled include business requirement analysis, system design, and support, and development, end-to-end testing and offshore co-ordination.
• Good experience of analyzing the business requirements, developing technical design documents and coordinating the development with developers.
• Expert in Development, Personalization and Extension of Oracle Applications using OA Framework (OAF).
• Expert in EBS Webadi technology for importing and exporting data with validations.
• Expert in developing reports using BI/XML Publisher.
• Expertise in developing customizations, extensions using Oracle Standards, Tools and APIs.
• Involved in the design of custom self service pages in OM, PO, Payables and Receivables modules using OA Framework, JDeveloper, Toad, Java, and PL/SQL.
• Excellent APPS work experience includes wide areas of abilities ranging from Client requirement analysis, technical design(MD70,TE40,MD120), architect development (JDeveloper, PL/SQL Developer), Impact analysis, Personalization, Extension, Testing and Deployment (Quest Stat Migration Tool)
• Facilitation of business and IT groups to lead organizational change required for issue resolution.
• Extensively used Metalink to debug technical issues and raise SR and Used PVCS (Version Manager), Quest Stat Migration Tool.

TECHNICAL SKILLS

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

IDE/ Tools: JDeveloper, Toad, SQL Navigator, SQL Loader, PL/SQL Developer

Design Patterns: MVC Design Pattern, Java and J2EE Design Patterns

ERP: APPS 11i / R12(X) - Order Management (OM), General Ledger(GL), AGIS, Inventory (INV), Purchasing (PO), Bills of Materials (BOM), Work in Process (WIP), Account Payables (AP), Account Receivables (AR), iExpense, iProcurement.

RDBMS: Oracle 9i / 10g, MYSQL

Operating Systems: Windows NT, Windows 2000/XP, Unix, Linux

Code Migration Tools/Utilities: Quest Stat, IT Governance Tool, FNDLOAD, JPXImporter, XMLImporter, JDR UTILS

PROFESSIONAL EXPERIENCE

Confidential, Calhoun, GA

Responsibilities:

• Working as senior production support Oracle APPS/OAF Developer
• Worked extensively on oracle E-Business suite R12.1.1
• Worked with modules SCM, OM, INV, Shipping, GL
• Developed custom OAF page application
• Provide Search page for quoting, Update page, create quote for order page, delete the existing quote.
• Created new processing constraints, defaulting rules, concurrent programs, PL/SQL packages.
• Analyzed all the custom triggers on tables related to Quote to Cash(Q2C) cycle
• Implemented RICEW components as per client requirement
• Had several meetings with all the owners of the Business Units to understand their actual requirements and the need for the custom trigger.
• Analyzed the trigger functionality and standard ways to achieve the similar functionality.
• Worked with Oracle team closely and found many new patches that can fulfil the business requirements.
• Documentation according to Oracle AIM standards
• Quote creation using Oracle Quoting module
• Analyse, design and develop the new enhancement.
• Configuring the selected product using Oracle Configurator and Order Management(OM)
• Customize the XML publisher report to print report for existing inventory (INV)and current order status using oracle shipping table status
• Created views based on the custom requirement
• Developed a new interface process to import the Orders from different sources.
• Worked with the load test team to develop the testing scripts so that they will hit the triggers.
• Worked with Load test team, Compuware Team to measure the performance improvement.
• Worked with DBA team to take the traces and analyzed the traces to eliminate the costly SQL’s.
• Co-ordinated with multiple ongoing projects, so that no one is effected by the trigger changes.
• Modified the Order Line workflow process by adding an additional process.
• Responsible for production issue resolution and worked with sales users
• Responsible for technical issues related to BI/XML Publisher reports
• Extensively working on issues related on OAF pages
• Worked on quote to cash cycle with whole quoting process.
• Created issue documents and maintain the issue logs
• Building the views and PL/SQL package to support the customized OAF Pages requirement.
• Created EO, VO, AM, Controllers, Region, pages and LOV as per the business requirement.
• Worked extensively with DBA team for system issues.
• Created Oracle SR and closely worked with oracle team to resolve issues
• Responsible for creation of migration script and harvest package for different instances.
• Responsible for developing custom reports.
• Created/Modified Technical document (MD070) for the components worked on.
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Confidential,Rolta, Memphis, TN

Responsibilities:

• Working as Oracle Application Framework and oracle apps developer on Oracle E- business Suite R12.1.3
• Worked with business process Procure to Pay(P2P) cycle
• Worked extensively with the finance modules Iexpense, Iprocurement, EAM, GL, AP, AR
• Working extensively on oracle E-Business suite R12.1.3
• Implemented RICEW components as per client requirement
• customization and Extension using Oracle Application Framework (OAF), Jdeveloper
• Implementation of Oracle Standards / Customized packages to meet functional / business requirements
• Active involvement in data gathering and processes study with functional team
• Documentation according to Oracle AIM standards
• Registration of customized tables, forms and reports with oracle e-Business SuiteWriting Procedures, Functions and Database Triggers
• Customization of Oracle Apps modules ( CUSTOM.pll) according to client requirements
• Working on Internet Expense (iExpense) oaf extension for creating expense report.
• Worked on iProcument shopping cart extension with EAM module.
• WrotePL/SQL packagesfor different validations, for processing data in order to create Valid POs and Receipts and for populating thePO interface tablesand called the Seeded import programs to populate the base tables.
• Worked ondata fixesfor invoice holds in Accounts Payables (AP).
• Tested and debugged inbound outbound interfaces for GL
• Developed custom reports for weekly posted purchasing data.
• Worked on AP PROJECT and TASK scenarios
• Developed PL/SQL API to support OAF requirements.
• Developed DFFs and Valuesets for oracle iExpense workflow
• Responsible for technical issues related to BI/XML Publisher reports
• Extensively working on issues related on OAF pages
• Building the views and PL/SQL package to support the customized OAF Pages requirement.
• Created EO, VO, AM, Controllers, Region, pages and LOV as per the business requirement
• Created Oracle SR and closely worked with oracle team to resolve issues
• Responsible for creation of UNIX, FNDLOAD migration script and harvest package for different instances.
• Responsible for developing custom reports.
• Created/Modified Technical document (MD070) for the components worked on.
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Confidential, Calhoun, GA

Responsibilities:

• Working as senior production support Oracle APPS/OAF Developer
• Worked extensively on oracle E-Business suite R12.1.1
• Responsible for production issue resolution and worked with sales users
• Responsible for technical issues related to BI/CML Publisher reports
• Extensively working on issues related on OAF pages
• Worked on quote to cash cycle with whole quoting process.
• Created issue documents and maintain the issue logs
• Building the views and PL/SQL package to support the customized OAF Pages requirement.
• Created EO, VO, AM, Controllers, Region, pages and LOV as per the business requirement.
• Worked extensively with DBA team for system issues.
• Created Oracle SR and closely worked with oracle team to resolve issues
• Responsible for creation of migration script and harvest package for different instances.
• Responsible for developing custom reports.
• Created/Modified Technical document (MD070) for the components worked on.
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Confidential, Phoenix, AZ

Responsibilities:

• Working as OAF Developer and Oracle APPS responsible for developing a custom OAF Application, Oracle Application PL/SQL package and views.
• Worked with business process Order to cash (O2C) and Make to Order (M2O)cycle
• Worked extensively on oracle E-Business suite R12.1.2 and became a part of R12.2.3 upgrade for Finance module.
• Worked on creation of BI/XML Publisher reports to create customized layout reports for SRS
• Extensively working on customizing OAF pages for Scrap Reclaim Center and XXON GL Interface for R12.1.2 and R12.2.3
• Building the views and PL/SQL package to support the customized OAF Pages requirement.
• Created EO, VO, AM, Controllers, Region, pages and LOV as per the business requirement.
• Developed customized pages like Import data from data warehouse system Page, Edit AGIS Batch Page, View Error Page, Call the Oracle concurrent request log from EBS PG for XXON GL Interface.
• Developed PL/SQL blocks for validating JE and AGIS to created journal entry.
• Created a XXON GL Property setup page to allow custom setups for creation of journal entries for JE and AGIS.
• Provide custom validation based on the OU setup for specific user to allow access of batch transaction to help treasury department to prevent access of user.
• Extensively became part in full project development life cycle for Scrap Reclaim System project.
• For SRS been a part in analysis the internal business by visiting the site and communication with the site user about the system and created business requirement document based on the user requirements.
• Worked extensively with offshore team of about 15 people for SRS system.
• Developed Document Creation Page, Document Update page, Job Ticket creation Page, Job ticket update page, Container Creation Page, Container update page, Attach multiple document in the Document creation page, Shipping page and settlement page.
• Use XXON GL Interface to created SRS GL entries for that developed communicating package between to system and added staging table
• Worked on conversions and customizations (Reports) of different modules extensively worked on GL and AGIS(Oracle Advanced Global Intercompany System)
• Responsible for creation of migration script and harvest package for different instances.
• Responsible for developing custom reports.
• Involved with Testing Team in testing the Application and fixing all the issues that came up while testing.
• Created Functional document (MD 050) by gathering the entire business requirement.
• Created Technical document (MD070) for the components worked on.
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Confidential, Jasper, IN

Responsibilities:

• Senior OAF Developer responsible for developing OAF pages, reports and importing and exporting data as per the business requirement.
• Created new custom pages using Oracle Application Framework (OAF) in Oracle Applications R12.1.3, PL/SQL.
• Designed and customized OAF (Oracle Application Framework) pages using JDeveloper
• Developed custom Web adi Integrator with providing different validation to Import and export the data as well as created reports in payables and receivables.
• Developed a custom OAF pages for Mass warehouse override application in WMS module.
• Created a custom order filter page and added custom item attributes in the search results in Order Management module.
• Created the Update page which take the new warehouse detail for the selected sales orders and update it at the header level for BOOKED and ENTERED status in Order Management module.
• Created a custom PL/SQL package to launch the Configurator, and other OM customized requirement as a custom post config process which reflect the warehouse change at the line level
• Created OAF page to show the result with order number, old warehouse, new warehouse and status.
• Created custom report in Supply Chain and Manufacturing modules using BI Publisher.
• Use regions like page layout region, header, switcher region, train region, query region, message component region, table region, Advanced Table region and many more.
• Involved in Design, Development and Customization of OA Framework Pages (JDeveloper). Extensively worked on BC4J and UIX components.
• Created and Customized UIX components such as Pages, Regions and items.
• Implemented Simple and Results based search on certain pages in inventory and order management.
• Created and extended various AMs, VOs and EOs as per the requirement in manufacturing and supply chain modules.Added Descriptive and Key Flex fields on various Pages.
• Created a PL/SQL package to create and handle procedure and function which perform required actions in the backend
• Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.
• eveloped a custom report to download price list and customer quotation using BI/ XML publisher.
• Interacted with business analysts to develop modeling techniques and re-structuring strategies
• Created SR with Oracle for resolving one of the technical issues.
• Created Tar files and shell scripts for migrations of objects developed.
• Created Technical Document (MD 070) for the technical specification
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Environment: Oracle Applications R12.1.3, JDeveloper 10g, Toad 10.1, Java, Java Scripts, BI/XML Publisher, WinSCP, Putty.

Confidential, Dallas, TX

Responsibilities:

• Senior OAF Developer responsible for developing OAF pages and reports as per the business requirement.
• Created new custom Self service pages using Oracle Application Framework (OAF) in Oracle Applications R12, PL/SQL.
• Designed and customized OAF (Oracle Application Framework) pages using Jdeveloper
• Created a custom search page for Items and added custom item attributes in the search results.
• Created custom dash board for sales representative.
• Created many OAF pages for HR application called EXIT interview so the company can analysis the employee’s feedback
• Developed an Interface from Legacy System to Oracle General Ledger
• Create a custom wrapper for Quoting process and embedded in quote details page based on the business requirements.
• Inter linked quoting with Order management - Sales order form.
• Created custom report in supply chain modules using BI Publisher.
• Involved in Design, Development and Customization of OA Framework Pages (Jdeveloper). Extensively worked on BC4J and UIX components.
• Created and Customized UIX components such as Pages, Regions and items.
• Use regions like page layout region, switcher region, train region, query region, message component region, table region and many more.
• Implemented Simple and Results based search on certain pages.
• Created and extended various AMs, VOs and EOs as per the requirement.
• Created dependent LOVs.
• Customized various pages like create questionnaires page, search questionnaires page, update questionnaires page, delete questionnaires page, questionnaires detail page, confirm message page.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and good expertise on WF, OAF using JDeveloper 9i
• Created custom forms with vendor specific information to aid Payables department secure information by department
• Worked on form personalization (i) User cannot change AP invoice Workbench if the data moved from AP to legacy system(ii) Enabling Attribute1 in AP Payment Window (iii) Customized Invoice Form (iv)Call PO Window from PO Receipt Window.
• Designed and developedcustomformsand changed the forms based on requirement.
• Added Descriptive and Key Flex fields on various Pages.
• Created multiple pages with advanced table regions and export to excel functionality so users can export all the data in the excel file.
• Created a PL/SQL package to create and handle procedure and function which perform required actions in the backend
• Created custom tables, Value Sets and Lookups for HR Exit Interview Process application.
• Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.
• Developed a custom report to download price list and customer quotation using BI/ XML publisher.
• Interacted with business analysts to develop modeling techniques and re-structuring strategies
• Created Testing and Migration document (TE 20 / MD 120) for the testing components worked on.

Environment: Oracle Applications R12/11i, JDeveloper 10g, Toad 10.1, Java, Java Scripts, BI/XML Publisher, WinSCP, Putty.

Confidential, Wayne, PA

Responsibilities:

• Senior OAF Developer responsible for developing a custom OAF Application. Created new custom Self service pages using Oracle Application Framework (OAF) in Oracle Applications 11.5.10 and PL/SQL.
• Worked on conversions and customizations (Reports) of different modules extensively worked on GL, AR, AP The forms involved Procedures, Record Groups, LOV, Alerts, Parameters, Global Variables, Multiple Canvases, Multiple Windows, Multiple Blocks, Control Block and triggers at various levels
• Designed and customized OAF (Oracle Application Framework) pages using JDeveloper. Created many OAF pages to complete the Offer Creation Process in quoting module.
• Created Offer Home Page, Offer Lines Page, Offer Lines Detail Page, Offer Review Page and Offer Update Page for the process of creating an Offer in Oracle.
• Created Customer Pages in which the user can enter the customer details and Customer Update Page to update the details of Customer.
• Created Dependent LOVs and dependent Message Choice PickList on multiple pages to meet the business requirements.
• Created Mass update pages to update the information of the entire customer on one screen itself.
• Created Drop down PPRs. Created new Pages to add rows and update rows for Custom tables and customizedall icons, buttons other images such as logos, arrows, etc.
• Created Review Page where customer can review all the details of the offer. Used HTML coding to get a better view of the Review Page.
• Created and Personalized Short, Long and Page Tips. Handled various Exceptions in the pages for various functions involved in transactions.
• Created a process to import data from excel file directly into the oracle table.
• Created a PL/SQL package to handle all the notifications and procedure and function to perform all the actions behind the scene.
• Responsible for migration script of code to different instances.
• Responsible for developing custom reports.
• Responsible to design report template for new reports and solved issues for existing reports.
• Developed reports for Quotation, Invoice, contracts and checks using BI/XML Publisher.
• Involved with Testing Team in testing the Application and fixing all the issues that came up while testing.
• Created Functional document (MD 050) by gathering the entire business requirement.
• Created Technical document (MD070) for the components worked on.
• Created Testing document (TE 20) for the testing components worked on.
• Created Migration document (MD 120) for the components worked on.

Environment: Oracle Applications 11i, Jdeveloper 10g, PLSQL Developer, Java, Java Scripts, PL/SQL, SQL* Plus, SQL *Loader, WinSCP, BI Publisher, FileZilla.

Confidential, Chicago, IL

Responsibilities:

• Involved in a developing custom application using OA Framework (Jdeveloper), which includes all the basic search and advance search options, Dashboard.
• Worked on designing, development and customization of OA Framework Pages each of custom modules and worked extensively on BC4J and UIX components.
• Attached LOVs to the plain text-fields.
• Converted Standard LOVs to dependent LOVs
• Customized Sales Order Audit Report from standard RDF report into a BI Publisher Report
• Involved in data mapping of legacy data to Oracle Applications.
• Wrote AP Open Interfaces for the Data Conversion and data validation using PL/SQL.
• Created temp tables in Oracle to load the data and wrote control file for the transfer of the data through Sql*Loader.
• Attached additional parameters for the Sales Order Report
• Extensive personalization of Shipping Transaction Form
• Defaulting values
• Add Menu items
• Execute the backend packages for form validations.
• Dynamic behavior of the form
• Added FND Messages, FND profile options, FND Lookups as and when required.
• Created custom packages to perform different operations on ASO QUOTE PUB.
• Created Concurrent programs to meet requirements like Delete ASO Quote Lines concurrent program that uses custom package to delete quotes.
• Worked on Shopping Cart Pricing Display Enhancement
• Removed PL End date/ Cart expiration validation when “checkout” button is clicked on shopping cart page
• Customized Shipping method section
• Customized ship to section of shipping page
• Prepared documentation for meeting the project deliverables as per AIM Methodology (MD70s, MD120s and TE20 s)

Environment: Oracle Applications 11.5.10, Oracle Application Framework (OAF),iStore, INV, Order Management, TCA, Java, XML Publisher, PL/SQL, SQL* Plus.

Confidential, Philadelphia, PA

Responsibilities:

• Consultant and responsible for customization of and creating new custom Self service pages using Oracle Application Framework (OAF) in Oracle Applications 11.5.10.
• Worked on Designing, Development and Customization of OA Framework Pages each of the custom modules and worked extensively on BC4J and UIX components.
• Developed and Customized Pages, LOV’s, Poplist, Regions and items. Implemented Simple search, Advance search, Smart search and Results based search on certain pages. Created Quick Select and Multi select LOV’s.
• Created and extended various AMs, VOs and EOs as per the requirement. Created Drop down PPRs. Created new Pages to add rows and update rows for Custom tables and customizedall icons, buttons other images such as logos, arrows, etc.
• Created and Personalized Short, Long and Page Tips. Handled various Exceptions in the pages for various functions involved in transactions. Importing and Exporting various pages and Regions to and from MDS Repository.
• Personalized various pages to enable various items and regions to render depending on the context. Involved in fixing bug on Order Entry, Order maintenance, Notes & Attachments, Subscriptions. Created new Custom Styles and added them to Custom.xss.
• Created technical document (MD070) for the components worked on.
• Responsible for Patch Impact analysis on customized components.
• Responsible for migration of code to different instances

Environment: Oracle Applications 11i, Jdeveloper 10g, Toad, Java, Java Scripts, PL/SQL, SQL* Plus, SQL *Loader, WinSCP, BI Publisher, Kintana.

Confidential, Lake Forest, CA

Responsibilities:

• Involved in Design, Development and Customization of OA Framework Pages (Jdeveloper). Extensively worked on BC4J and UIX components.
• Created and Customized UIX components such as Pages, Regions and items.
• Implemented Simple and Results based search on certain pages.
• Created and extended various AMs, VOs and EOs as per the requirement.
• Customized various pages on Oracle sales Dashboard Page, Update Order Page, Customer Detail Page, and Update Customer Detail Page.
• Involved in Process Mapping, Gap Analysis and Module design and implementation for OM, Inventory modules.
• Customized Shared Shortcut Region to add a new Custom JSP link and modified existing links. Created Drop down PPRs to render regions for Kintana OBTs and Orders on Customer Detail page.Created Quick Select and Multi select LOV’s. Involved in creating business areas using Discoverer. Added Descriptive and Key Flex fields on various Pages.
• Creation, Updating and deletion of rows in the table. Created and Personalized Short, Long and Page Tips.
• Handled various Exceptions in the pages for various functions involved in transactions.
• Importing and Exporting various pages and Regions to and from MDS Repository.
• Personalized various pages to enable various items and regions to render depending on the context.
• Created and Customized PL/SQL APIs to import data into custom tables from various base tables.
• Imported data into Oracle Applications using the Payables Open Interface Import program and populated the Base Tables, which involved releasing invoices from hold, approval of invoices and creation of new invoices.
• Designed application components based on MVC framework.
• Involved in creation of Presentation Layer.
• Developed Authentication for Users based on their Roles.
• Involved in the process of Database Design.
• Responsible for end-to-end testing of various components

Environment: MVC Framework, core Java, JSP, Tomcat Web Server, and SQL *Plus.