SUMMARY:

• Around 8 years of experience as an Oracle Applications Techno Functional Consultant (E - Business Suite 11i & R12) with expertise in Oracle SCM Modules (PO, OM, INV, iProcurement and iSupplier), Oracle Financials modules (AP, AR and GL)
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Experience in Design, Development of OA Framework, OA Page Personalization, OA Extensions, XML/BI Publisher Reports, Forms, Reports, Workflows and Forms Personalization.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Very good Experience in Order to Cash (O2C), Procure to Pay (P2P) business flows.
• Worked on developing and customizing reports as per client requirement using XML/BI Publisher and Reports Builder.
• Integrated Approval Management Engine (AME) in Expense Reports.
• Strong Experience in System Administration and Application Object Library(AOL)
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Substantial development experience in creating stored procedures, Packages, Functions, Indexes, Triggers and Views.
• Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70,MD200 and MD120).
• Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD.
• Good Knowledge on ALERTS.
• Exposure on R12 New Features and up gradation activities.
• Worked on UTL PACKAGE and SQL* LOADER for loading data from flat files into Oracle tables.
• Having awareness in shell scripting.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12.
• Flexibility and Adaptability in regards with new technologies.
• Excellent Written, Verbal Communication Skills and Analytical Skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i and R12

Operating System: Windows and Unix

RDBMS: Oracle

Modules: Purchasing (PO), iSupplier, iProcurement (ICX), Inventory (INV), Order Management (OM), Accounts Receivables (AR), Accounts Payables (AP), Electronic Data Interchange (EDI), General Ledger (GL), Oracle Approvals Management (AME)

Languages: SQL, PL/SQL, UNIX Shell Scripting and JAVA

Tools: Toad, SQL*Plus, SQL*Loader, SQL Developer and OAF, Workflow Builder

Reporting Tools: Reports6i/10g, Forms, XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Techno-Functional Consultant

• Design and develop Oracle RICEW components, OA Framework components, UNIX shell-scripting, BI Publisher Reports, Interfaces and conversion components.
• Preparing Design and Unit Test documents with the AIM standards.
• Responsible as a primary Technical Lead/owner for Requisition &Purchasing, Inventory(INV) and Payables Modules
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Purchasing - Change PO Program (Create PO Workflow), Loading Requisitions and POs from legacy systems, created Custom PO PDF Notification as part of approval Notification
• Payables - Customized Invoice Creation Pages to add Accounting fields and enable other customizations as per user requirements iSupplier - Customized Supplier Registration pages to enable additional validations
• Responsible as primary owner of all workflow customizations and customized various workflows like Requisition Approval Workflow, PO Approval Workflow, Create PO workflow, and PO Requisition Account Generator as per user requirements.
• Created Oracle Alerts as per user requirements
• Communicated with the offshore team and maintained daily status meetings with offshore team and Onsite technical team.
• Involved in development of various Interfaces and conversions
• Assisted users in Month end Closing procedures
• Working on Saudi Localization (SANAD) as per Nabors Standards.
• Worked on EDI invoice import process
• Working on Developing BI Publisher Reports and EIS Reports as per Client needs.
• Workflow customizations to support AME approval process
• Study of the current Business Process and GAP Analysis using AIM documents
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents
• Gathered application requirements and provided design recommendations
• Assist in functional design with respect to custom data models that integrated with Oracle Applications
• Worked on the setups of i-Supplier module setting up the Supplier responsibilities, supplier invitation lists, supplier registration process etc
• Providing the production support on all aspects of the Oracle Financials Applications Environment.
• Performed Project conversion from Legacy system and implemented interface to create and update project related data from third party systems.
• Customized Project and Budget related approval workflows.
• Delivering the end-to- end solution for support problems and development tasks
• Including Identifying the issue, configuration, and development and testing.
• Effectively providing the Oracle Support to resolve Service Request (SR) issues.
• Ability to switch to agile and waterfall Methodologies based on Client demand.
• Processes and integration around the custom applications with Oracle Financials Applications to take ownership of solutions.

Confidential

Oracle Applications Techno Functional Consultant

• Supported Post-Implementation phase for all Oracle Financials Modules
• Production support, interfaces maintenance, change management, month end closing
• Prepared and modified MD50’s for different reports like Product profitability report, PO received but not invoiced report, etc…
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Involved in development of GEWE SR Task Estimates Outbound Integration Program
• Involved in development of SR Task Integration Report.
• Involved in development of GEWE Resource Sub Inventories Outbound.
• Processing struck SRs from oracle to Legacy (Service MAX).
• Figured out recurring issues and implemented permanent fixes for them.
• Provided 24/7 support including night shifts.
• Supported Sales order creation program to fix the issues involved (monitor the program to avoid any recurring issues etc..).
• Created database objects tables and views.
• Wrote complex SQL queries as per client’s requirements.
• Worked on PLSQL queries, stored procedures, packages, functions.
• Involved in technical document design Document ( MD070 ) and functional document ( MD050 ).

Confidential

Oracle Applications Technical Analyst

• Involved in upgrade of 11i reports to R12. Reports like ‘Account Analysis with Sub Ledger Detail (132 char)’,’Account Analysis-Sub Ledger Details (180 char)’ and ’Account Analysis-Payables Detail (132 char)’.
• Involved in Development XML Reports for standard reports like ‘Packing Slip Report’,’ Commercial Invoice’,’ Sales Order Acknowledgement’,’ Invoice Print Selected Invoices’,’ Print Purchase Order Report (Landscape)’ and ‘Discrete Job Routing Sheet New’.
• Customized Payables Account Analysis Report using data template process as per the client requirement.
• Implemented Barcode for the report ‘Discrete Job Routing Sheet New’ using XML Publisher.
• Used FND LOAD to transfer the AOL objects like Concurrent programs and Value sets from one instance to another instance.
• Created Control Files for SQL Loader to load from Text Files.
• Developed Interface program to upload the Purchase order Details.
• Developed Service Request Page using Oracle Application Framework (OAF).
• Production Support and Maintenance.
• Tracking all issues logged by end user and provided Technical solutions.