SUMMARY

• Over 9+ years of IT work experience as Oracle Apps Developer/Programmer in Oracle Applications 11i/R12 ERP implementations and customizations.
• Technical experience in Sales Contracts, Service Contracts, Quote to Order, Procure to Pay, iProcurement, Depot Repair, Order to Cash, OM, Inventory, SCM, TCA modules
• Expertise in custom development of Java based application from scratch using OAF and ADF.
• Experience in Personalization and Extension on OA Framework (OAF) based applications.
• Experience in working on JSF pages, page fragments, task flows, scopes, listeners and managed beans in ADF.
• Experience in web service integration implementation.
• Experience in development and customization of RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components.
• Experience in writing PL/SQL procedures, interface programs using SQL*Loader and Shell scripting.
• Experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports 10g and BI Publisher.
• Experienced in creating notifications and alerts and business process flow using Workflow Builder in ERP system.
• Experience in performing Gap analysis, and have very good understanding of Software Development Life Cycle (SDLC).
• Good understanding of Oracle’s AIM documentation standards and extensively used MD050, MD070 & TE20.

TECHNICAL SKILLS

Oracle Application: Sales Contracts, Service Contract, Depot Repair, iProcurement, AP, Quoting, Customer Online, Oracle Sales Online and Oracle Customer Online, Order Management (OM), Inventory (INV), Supply Chain Management (SCM).

Framework: Oracle Applications Framework (OAF), Application Development Framework (ADF).

OS: UNIX, Linux, Sun Solaris, Windows XP, Vista, NT/2000 Advanced Servers

Languages: SQL, PL/SQL, JAVA, J2EE, JSP, XML, HTML, CSS

Tools: /utilities: JDeveloper 9i/10g/11g/12c, SOAPUI, Reports 10g, BI publisher, Workflow builder, Discoverer 10g, TOAD, SQL Developer, Putty, Win SCP, Kintana, Perforce, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale CA

Oracle OAF/ADF Developer

Responsibilities:

• Designed and developed SSWA based Sales Contracts and OM Console application using OA Framework from scratch.
• Been part of development of 100+ pages and regions in this application.
• Developed dashboard, graphs, dynamic side navigations, search pages with complex logics, Forms, LOV regions, etc.
• Created Tables, sequences, PL/SQL packages to support the application business process.
• Implemented UMX roles, permission set and permissions to have application level and data level security.
• Used AOL objects for messages, functions, menus, responsibility, etc.
• Developed BI publisher report to print summary report.
• Developed web service integration to Apttus application in SFDC.
• Enabled SOA service using Oracle SOA gateway to integrate contracts data to SFDC.
• Used Associations, View Links, Expert classes, Entity validations.
• Worked on task flows, pages & page fragments developments in ADF based quoting application.
• Have good understanding in phases of JSF life cycle.
• Worked on pre - validation rules before quote is converted to order in Order to Cash flow.
• Coordinating with offshore team members with periodic calls addressing questions and clarifications.

Confidential, Phoenix AZ

Technical Lead

Responsibilities:

• Designed and developed SSWA based GTS system using OA Framework from scratch.
• Developed Workflows for order approvals and shipment notifications.
• Created PL/SQL packages to support the application developed.
• Integrated developed components before migrating.
• Worked on trigger extensions to support 11i to R12 upgrade.
• Experienced in IBY bank account structure, tables and APIs in R12.
• Experienced in HR and Payables, have synchronized primary bank accounts from HR to AP.
• Customized and Personalized SSWA pages in iProcurement, iSupplier pages.
• Good understanding on Procure to Pay process.
• Good technical understanding over XML mapping between B2B when a requisition is raised in iProcurement.
• Designed and developed Commercial Invoice Report for GTS system using BI Publisher.

Confidential, Irvine CA

Technical Consultant

Responsibilities:

• Designed and developed workflows for various repair processes from received to repair complete.
• Performed setups to kick off workflow based on the repair order status transition.
• Created PL/SQL packages and procedures to support the workflow process.
• Created custom logging of the process for debugging and for generating error log report.
• Developed functionality to create WIP job based on the service code.
• Compared the BOM and the repair cost of the repair order to check if it is not eligible for repair.
• Developed package to perform sub-inventory transfer and inter-org transfer of a particular item.
• Developed custom application OAF forms and integrated with the oracle functionality to give user one window for all their activities.
• The page incorporates the functionality to create orders in bulk under a given customer reference number and kick off workflows to redirect with the automated actions based on the repair types.
• Developed XML template for WSH Pack Slip RDF report to generate PDF output.
• Designed and developed Consolidated Billing Invoice XML report with PDF output.
• Have worked on automating the flow to transact a repair item based on the warranty on item, contract the customer holds and warranty of vendor.
• Designed and developed workflows to initiate the automated process flow based on the repair type of the order.
• Gathered specifications from user, designed, developed number of reports in Discoverer.
• Experience in working with Discoverer Administrator, Discoverer Desktop and Discoverer Plus.
• Created folders, Sql folders, folders using materialized view, registered functions, created items, defined item classes and created links between folders in Discoverer Administrator.

Confidential, Oakbrook IL

Technical Consultant

Responsibilities:

• Developed PO print PDF output report using BI publisher.
• Changed functionality to show/hide buyer details in PO for a specific buyer through DFF.
• Extended OAF component to allow Non Catalog Approver to change the supplier during Non Catalog process.
• Worked on B2B integration between iProcurement and application outside the organization.
• Personalized Buyer screen to add a tip note for an item.
• Personalized Requester LOV to fix timeout error issue.
• Extended Deliver to location LOV CO to limit the locations with respect to requester.
• Extending workflow to stop sending PO notifications to buyer through profile settings.

Confidential, Minneapolis MN

Technical Consultant

Responsibilities:

• Provided a solution which could in corporate their business functiofnality.
• Designed and developed Calculate and Adjustment page using OA Framework/Jdeveloper.
• Represented data in a hierarchical structure using HGrid.
• Implemented PPR within HGrid.
• Created PLSQL procedures to calculate rollup cost, adjusting amount and updating cost org to child nodes.
• Customized the existing Install Base, Item Instance Details Screen, and Create Item Instance Screen to meet the new business Requirements.
• Created new styles and added them to custom.xss.

Confidential, Durham NC

Technical Consultant

Responsibilities:

• Designing and developed custom application self service pages that perform set of operations in a click.
• Studying underlying forms functionality and implementing the same in OA Framework/Jdeveloper application pages.
• Involved in development of custom interfaces of Delivery Details in to custom table.
• Gathered business logic and Oracle Forms backend functionality to in corporate in OAF pages.
• Implemented Service Contracts various functionality in various different pages developing from scratch.
• View contract, copy contract, change contract, renewal contract, terminate contract are some of the pages that I developed.
• Worked on QA Check API, and when contract goes to a QAHold status.
• Worked on Billing type, Renewal type and Pricing for a given contract.
• Created packages PLSQL procedures for the backend functionality of the OAF pages.
• Implementing business logicin PL/SQL packages.
• Worked on Interfaces using both SQL Loader and Shell scripts type executables.
• Created workflows using Workflow builder to send email notification to the customers who have a change in their subscription.
• Working experience in VSS in version controlling of the code.
• Worked on AIM documents like reviewing MD050 and designing MD070.

Confidential, Torrance CA

Technical Consultant

Responsibilities:

• Gathered requirements and filled gaps in the development of custom report.
• Designing and developed custom report for Peru as per the business requirements.
• Handling Report issues such as XML report, PDF output, parameters and exceptions
• Involving in writing the Detail Design Documents for the Customized Reports
• Created Business Areas, custom folders and generated adhoc reports in end user layer using Discoverer.
• Involved in the development of custom form using OA Framework application.
• The form allows user to create, update and delete dosage key.
• Created custom packages PL/SQL procedures and functions.
• The form resets the time of effective date and end date to beginning and end of the day respectively in contrast to sysdate.

Confidential

Oracle Developer

Responsibilities:

• Designed the ER model and relational database design after gathering the client’s requirements.
• Converted the existing data stored in flat files into Oracle tables using SQL*Loader.
• Developed various form-level and DML triggers to perform validation checks.
• Developed SQL scripts for creating tables, views, indexes and sequences.
• Developed PL/SQL stored procedures, functions and packages for implementing application logic and constraints.