SUMMARY

• Over 8 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, OC4J & BC4J, AOL (UI/Backend/Security).
• Hands-on experience in Oracle Order Management (OM), Manufacturing, Purchasing (PO), Bills of Materials (BOM), Work in Process (WIP), Inventory (INV), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL).
• 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 - Order Management (OM), Inventory (INV), Purchasing (PO), Bills of Materials (BOM), Work in Process (WIP), Account Payables, Account Receivables, General Ledger.

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, 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.
• Created custom report for pricelist catalog for Oracle Financials Receivables (AR) module.
• 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.
• Created dependent LOVs for finance modules like Accounts Receivables (AR) and Accounts Payables (AP).
• 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
• Created concurrent program to Annually update Depreciation Methods in fixed Asset module
• Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.
• Customized various reports in AR related to aging, invoice printing and customer balances.
• 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
• Customized the existing General Ledger report to show customer requested details depending on the transaction type.
• 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.
• Entered and processed various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information in Payables and Receivables
• 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, Calhoun, GA

Responsibilities:

• Senior Programmer Analyst responsible for customization of and creating new custom Self service pages using Oracle Application Framework (OAF) in Oracle ApplicationsR12, PL/SQL and AOL.
• Customized Self Service page to be used as an Item Overview.
• Developed a PL/SQL package procedure to validate the multiple ship-to location of a customer during the process of sales order entry thru shipment.
• Designed and customized OAF (Oracle Application Framework) pages using JDeveloper. Multiple Search Criteria Page where the user can enter multiple criteria for one particular field, extended the Controller (CO) and Application Module (AM).
• Created Existing Quote Search Page to search existing quotes. Filter Page to apply filter on Search results, extended the CO and AM to implement the logic based on the requirements, etc... And integrated the pages as per the requirements.
• Designed and developed various inbound and outbound interfaces that make the data flow in and out of the Oracle Applications to other subsystems.
• Responsible for development and delivery of Conversion/Interface programs for Items, Item Costs, BOMs and POs including SQL and XML publisher reports
• Developed conversion programs for Items, Item Category, Item Class using Oracle PL/SQL and Standard APIs
• Designed and customized OAF (Oracle Application Framework) pages using JDeveloper. Multiple Search Criteria Page, where the user can enter multiple criteria for one particular field, extended the Controller (CO) and Application Module (AM).
• Created Existing Quote Search Page to search existing quotes. Filter Page to apply filter on Search results, extended the CO and AM to implement the logic based on the requirements, etc.. And integrated the pages as per the requirements.
• Created PL/SQL procedure to update design information when a concurrent program is executed.
• Created a Wrapper on the standard quoting to take additional information.
• Created technical document (MD070) for the components worked on.

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

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
• 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)
• 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.