SUMMARY:

• Techno functional Analyst having over 9 years of professional experience on various Oracle EBS Modules and data management concepts.
• Two full life cycle Implementations experience with 11i and R12 versions of Oracle Applications with exposure to AIM implementation methodologies.
• Good understanding on the Techno - functional aspects of various EBS modules (Inventory, BOM, Order Management(OM), Configurator, AP, PO and GL)
• Good Technical skills in developing RICE components (Reports, Interfaces, Conversions, Extensions) in Oracle Applications E- Business Suite using SQL, PL/SQL, Forms and Reports (6i & 10g) and XML Publisher.
• Good understanding on the Supply chain planning and management processes and functionalities.
• Experience and good knowledge on Workflow customizations.
• Expertise in writing Functions, Procedures, Packages and Database Triggers that handle complex business logics and data validations using PL/SQL.
• Experience on Data Bus and Golden Gate architectures of Oracle to replicate real time data across downstream databases.
• Expertise in maintenance of tables, indexes, views and optimizing queries.
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using UTL FILE packages and SQL*Loader.
• Expertise in implementation of Purge and Archive mechanisms for historical data existing in the system for performance improvement.
• Extensive knowledge on Application Object Library (AOL) and implementation standards.
• Experience in registration of Concurrent Programs and Request Sets into Oracle Apps through AOL, Registration of forms, Reports, Menu Creation and Creating Value Sets.
• Experienced on Unix and Windows operating environment
• Good team skills and communication skills.
• Excellent learning curve.
• Thorough understanding on ITIL process (Incident, Problem and Change Management)
• Involved in end to end life cycle starting from initiating the kick-off meetings, Requirements gathering, handling client approvals, Solution design, Configuration and release planning, coordination with the development team & testing team to ensure quality deliverables. Approving test plans, Coordinating UAT with the client. Taking a sign-off and ensuring project is successfully implemented as per the timelines.
• Have Knowledge of SDLC, change control management, Incident Management, Problem Management Process.

TECHNICAL SKILLS:

Operating Systems : Windows, UNIX

Languages: SQL, PL/SQL, HTML

Databases : Oracle 11g/10g/9i/8i

Tools/Utilities: XML Publisher, Forms & Reports 6i/10g, Toad, SQL*PLUS, SQL*LOADER, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, RTP, NC

Sr Oracle Apps Technical Consultant

Responsibilities:

• Requirement gathering, proto typing, development and deployment of Order Orchestration mechanism and RICE components which are used to validate the orders data that are placed through different web tools before importing to ERP instance and Sales Order number creation and booking.
• Develop Orders Copy Program which is used to copy Legacy Orders data to the R12 instance Operating unit wise.
• Develop Un-Booked Orders XML Publisher report to fetch the data of the orders pending Customer Support action Operating Unit wise.
• Development of Expedite Tool to help place expedite requests on the orders to enable Supply Chain Planning activities.
• Developed INCIPS concurrent Program verify if there are any open orders for a product before the orderability of it is changed and send a consolidated email to the BU with such orders details.
• Develop Cloning Tool which is used to copy different types of Production Orders data from base tables of 11i instances to staging tables in R12 instance and further fed to OE ORDER PUB API to check the failures and do the coding accordingly for SO generation and booking.
• Develop APIs to apply holds on the order processing in the system based on different business criterea.
• Develop Orders Version Tool that is being used by the bookings team to validate the Pricing Changes that happened on the orders against the PO before booking.
• Design and develop Purge and Archive of the Sales Orders based on the business Team approved filters.
• Develop monitor and alert mechanism to check on the scheduled concurrent requests.
• Involve in creation of Unit test case plans for new components developed.
• Documentation and version management of any code changes that were done to the existing objects and new ones that are added.

Environment: E-business suite R12.1.3, Oracle Inventory, BOM, Configurator, Order Management, XML/BI Publisher, Toad, Oracle 11g, Unix

Confidential, Fremont, CA

Oracle Apps Technical Consultant

Responsibilities:

• Development of New Product Introduction (NPI) Workspace environment which is an web interface for the Product Life Cycle Management(Inventory) module.
• Creation of different approval workflows from the Business Unit Program Managers to the Data Ops teams down to the BPO team for creation of Products, Price Lists assignment and Product structure set up in the system.
• Develop Commerce Workspace which is a web interface where user needs to log in only once and can configure, quote, order and check status or modify the order details at one place using RICE componenets.
• Develop Egenie tool through which orderability, warehouse assignment, Price List Availability, Base Price and other Item related information can be accessed. The data for this is fetched from 4 different modules of E-Business Suite like Inventory, BOM, Advanced Pricing and Order Management.
• Development of Stocker tool to manage the stock eligibility of the products and other functionalities for the Supply chain Management of the items.
• Create SR with Oracle and follow up on the identified bugs in the standard Application APIs and forms.
• Co-ordinate with business and support teams on the open Problem tickets and prioritize the ones that are to be deployed in the immediate monthly release.
• Develop databus replications for real time data integration between different reporting and analytical systems like Siebel, BI and Salesforce systems.
• Work on the Test Defects and Problem Tickets that are raised by the support and business teams for the extended functionalities that are needed. Such tickets are managed through Remedy Incident Management system.
• Worked on form customization to enable a pop up on the BOM define screen warning the users on an existing issue and possible work around for it.
• Conducting Knowledge Transfer sessions with the support teams to share the changes that are done to the existing code to fix an issue or a new code deployed to enhance the system.

Environment: E-business suite 11.5.10.2, Oracle Inventory, BOM, Configurator, Order Management, XML/BI Publisher, Toad, Oracle 9i/10g, Unix, Data Bus set up.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Developed Purchase Order outbound interface using UTL FILE package to transfer the data into global system.
• Developed Payment outbound interface using UTL FILE package to transfer the data into global system.
• Design and developed new forms using TEMPLATE.fmb and registering them in oracle applications.
• Developed Customer Import process to transfer and validate Customer data from legacy system into Accounts Receivable.
• Work on the incidents that are raised by end users if they face any issue with the system as a member of support team.
• Do the root cause analysis of the issue with the RICE implelentations and suggest the user with the best possible solution of it. Such incidents are managed through Remedy Incident Management system.
• If the issue is due to data discrepancy, we take the necessary action of either replicating the missing data from the source of truth or do a PDF (Production Data Fix) as a short term fix as per the necessity.
• Creating a problem ticket with the monthly release team if the long term fixes for the issue needs any code changes to avoid the issue from happening again and suggest them where the changes are to be made.
• We create TDs(test defects) for the changes that are made by the release team and test them to see if they handle the needed functionality and provide signoff to the so that the changes can be pushed to the production environment.
• Co-ordinate with deployment teams during the deployment windows and verify the fixes for the issues before giving sign off.
• Handle on call responsibilities during the critical times like quarter ends and month ends when the orders volume will be huge and fix any issues immediately when reported to avoid revenue loss.

Environment: Oracle Apps 11.5.0, Oracle 10g, PL/SQL, Windows XP

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Involved in development of Journal Interface program.
• Customized Print Purchase order Report.
• Customizing existing reports and Forms 6i to meet the Functional and technical design based on the business/client requirements.
• Development of packages and add new procedures using PLSQL wherever required to enhance the existing functionality of the applications.
• Documentation of any code changes that were done to the existing objects and new ones that are added.
• Assisting the developer working on the front end. Adobe Flex is being used to develop the front end and user enterable screens. To display list of products and internet link capacity for example as a dropdown, a new procedure is required with a ref cursor returning all the possible values to display to the customer.
• Registering and creation of new Concurrent programs, PL/SQL APIs and RICE components as per the requirement.
• Conducting Knowledge Transfer sessions with the support teams to share the changes that are done to the existing code to fix an issue or a new code deployed to enhance the system.
• Contributed to write test cases and review test cases written by testing team based on the functional documentation. 

Confidential

Oracle Apps Technical Analyst

Responsibilities:

• Worked on GL Interface to transfer Historical legacy Journals into ERP systems.
• Developed an interface to upload the Purchase Order details into Oracle Base Tables.
• Developed AP Invoice Details, Item Min Max Report.
• Developed Shipped Purchase Order Report.
• Developed AR Aging Report
• Defining Concurrent Programs, Executables.
• PL/SQL method of submitting Concurrent programs.
• Creation of Value sets in various Modules of the application.
• Concurrent programs, PL/SQL API’s.
• Registering reports in Oracle 11i applications.
• RICE development and Customization for Oracle Apps 11i & other systems, where necessary.
• Created design documents (MD070) and test scripts for all the conversions.

Environment: E-business suite 11.5.10, PO, AP, GL, XML/BI Publisher, Toad, Oracle 9i/10g, Unix

Confidential, Irvin, TX

Oracle EBS Developer

Responsibilities:

• Developed interface program to Upload PO Requisition details from Legacy System into base tables.
• Developed Supplier specific Receipt Report.
• Customized Cancelled Requisition Report in PO module.
• Involved in creation of Executable, Concurrent Program and Request sets.
• Involved in fixing the bugs in testing phase.
• Participated in Unit testing activities.
• PL/SQL method of submitting Concurrent programs.
• Creation of Value sets in various Modules of the application.
• Registering reports in Oracle 11i applications.
• Reports development and Customization for Oracle Apps 11i & other systems, where necessary.

Environment: E-business suite 11.5.10, PO, AP, GL, XML/BI Publisher, Toad, Oracle 9i/10g, Unix