SUMMARY

• Over 7+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade, and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Implemented and supported various Oracle application modules such as Financials such Account Payables, Account Receivables, General Ledger, Oracle SCM and Oracle E - Business Suite.
• Extensive experience in all phases of complete Life cycle (SDLC) Implementation of Oracle SCM including Definition, Operation Analysis, Solution Design, Build, Transition and Production support.
• Proficient in Requirement Gathering and Understanding theAS-ISbusiness process and providing TO-BE business process.
• Expertise in analyzing business requirements as a part of implementation or Upgrade project and provide extensive functional support for Post-Production Support projects inSCMModules of Oracle ApplicationsR12.
• Extensive experience in functional flow ofProcure to Pay (P2P) and good knowledge in Order to Cash O2C cycles
• Excellent understanding of data flow in the different modules of Oracle Applications. Involved in Implementation, customization of several Oracle SCM Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces, and customizations.
• Expert in registeringConcurrent Programs, Form, Functions, Tables, developingDescriptive Flex-fields in CustomApplications and defining Profile values by usingApplication Object Library (AOL),System Administrationand Documentation in Oracle Applications.
• Proficient in Creating responsibilities and assign them to users and set profile option
• Proficient in Oracle Applications implementation with PL/SQL, SQL Developer, TOAD, SQL Loader, Database, Triggers, Procedures, Functions, Oracle Reports 10g/6i Oracle.
• Extensive experience in development and Customization ofRICE components-Reports,Interfaces, Conversions, Extensions, and packages related toOracleApps Modules PO, AP, OM, INV, Oracle EDI Ecommerce Gatewayin OracleApplication R11i
• Worked on PLSQL Stored procedures development to validate and migrate transactional data from Oracle system to external systems for PO, AP modules.
• Involved in Data Conversions through Interfaces and APIs and Custom Development using Oracle Applications Coding and GUI Design Standards, Concurrent manager, flex field’s setup, Integration Testing, documentation (AIM) etc.
• Extensive experience in developing RDF Reports and XML Publisher Reports using XML BI Publisher responsibility.
• Involved in all phases of Testing includes Unit testing, SIT (System Integration Testing), functionality testing and User acceptance testing (UAT).
• Strong familiarity withAIM methodologyand creatingBRD, MD-50, MD-70, MD-120and alsotestingdocuments throughout multiple Projects
• Gaining knowledge and getting familiar withOracle Fusion SCM and Procurement.
• Hands on experience in OAF pages and OAF personalization.
• Excellent Working experience on Integration from Oracle ERP to SAP Ariba network applications (Ariba buyer, Ariba supplier, Ariba P2O) with CGI, Boomi middle ware for Oracle ERP for Purchasing module.
• Proficient in onboarding the supplier's process (SLP) in supplier management like Supplier Requests, Registration Questionnaire, and supplier Enablement in Ariba Buyer Network.
• Expert in troubleshooting integration issues between Oracle ERP and SAP Ariba systems.
• Worked with Ariba Support services to validate changes and to analyze critical issues.
• Responsible to coordinate with technical team for resolving the defects and/or for enhancing the functionality
• Experience on changing the Vendors to different groups (ASN not required, or Receipts not required) in Ariba supplier network.
• Excellent knowledge on creation of Purchase Requisitions (PR), Purchase Order (PO), Goods Receipts (GR), Advance Shipment Notice (ASN) and Invoices in SAP Ariba P2O/P2P and Ariba network.
• Created several reports in Ariba Network to get transactional details like Pos or invoices based on user requirements.
• Extensive experience in troubleshooting and fixing SAP Ariba production issues within tight deadlines.
• Very good exposure to writing and working with batch files and Unix Shell scripting.
• Good exposure to java oops concepts.

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12/11i including Purchasing (PO), Inventory (INV), Order management (OM), Payables (AP), Application Object Library (AOL), SYSADMIN

Database/RDBMS: SQL, PL/SQL, ORACLE 9i/10g/11g

Tools: TOAD, SQL Developer, SQL*Loader, Forms & Reports 10g/6i, XML Publisher, Workflow Builder.

Operating System: Windows 98/2000//XP/7/8/10, UNIX, Linux.

Other Tools: WinSCP, Putty.

Middleware: SOA, Boomi, CGI

Supplier Collaboration Tool: ARIBA Buyer, Ariba Supplier, Ariba P2O

Ticketing Tool: Service Now

Reporting: XML BI Publisher, RDF Reports

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Techno Functional consultant

Responsibilities:

• Participated in workshops about the design phase of the project, Requirement gathering, functional analysis, and Process design, Configuration, implementation, and Production Support.
• Interacted with Business users about the GAP and identified TO BE Process, and Business workbook requirements.
• Involved in gathering the information from the business for the business requirements workbook.
• Worked on Integration between ORACLE ERP system and Ariba through SOA.
• Created concurrent programs to send enabled supplier from ERP to Ariba network based on transmit code updated by buyer in oracle.
• Prepared functional specification document (MD050), Technical specification Document (MD70) for Customizations using AIM methodology.
• Created multiple Concurrent Programs, Executables, value sets and lookups usingApplication Object Library (AOL) and System Administration.
• Developed concurrent programs to reconcile purchasing transactional data like Purchase orders, receipts and invoices in Oracle.
• Worked on development of PL/SQL Packages and Procedures to validate and migrate PO, receipts, invoices, and supplier data from ERP/Oracle system to Ariba Network.
• Developed custom reports based on the user requirements in PO, AP Modules using XML Publisher Administrator responsibility.
• Created various data base objects line tables, cursors, indexes, views, sequences, triggers, stored procedures, and functions.
• End-to-end testing of the application with variable user inputs and wide scenarios to ensure the changes reflected at all levels.
• Involved in all phases of Testing includes Unit testing, SIT (System Integration Testing), functionality testing and User acceptance testing (UAT).
• Responsible for deployment of Change /Enhancement Requests as per the process.
• Provided user training on custom programs to end users.
• Customized concurrent programs based on the change requests.
• Worked on reports Customization based on user requirements.
• Involved in development of the XML/BI Publisher reports based on the existing RDF Reports.
• Registered the Templates and Data Definitions usingXML/BI Publisher Administratorresponsibility.

Confidential

Oracle Apps Techno Functional consultant

Responsibilities:

• Involved in extensive PROD support for the Zeal instance integration to SAP Ariba system through SOA Middleware.
• Analyse and find root cause of failed transactions in day-to-day business of Confidential Hungary Business Unit and Ariba Network integration for Purchasing module.
• Created descriptive flex fields to differentiate Confidential Hungary business related suppliers.
• Worked on resolving various issues occurred in integration data between Oracle and Ariba.
• Resolving user issues depending on Service now requests and providing appropriate resolution to users within timelines.
• Enhanced PL SQL procedures for fixing identified issues as part of production support activity for the integration project.
• Created multiple Ad hoc SQL queries according to business user requirements.
• As part of PROD support, created alert which will send e mail to support team whenever there is any transaction(PO, Receipt or Invoice) failure found in the integration process.
• Creating the Purchase requisitions, POs, good receipts, shipment notice and Invoices in Ariba to find the root cause of failure transaction in integration (Creating, editing, submitting the requisitions).
• Monitoring the Integration failures between SAP ERP and Ariba Sourcing and clearing the failures (PO, GR, invoice failures).
• Created multiple reports to fetch transaction details like PO, receipt and invoices for a particular supplier to reconcile data between ERP and Ariba Supplier network.
• Working with Ariba Connect/Support team through SR to fix the new issues/critical issues.
• Clearing the Ariba invoice failures by reprocessing the failed invoices after fixing the errors in ERP system (SAP or Oracle).
• Providing assistance to Supplier for Order Confirmation, Shipment creation, Invoice Submission.
• Reassigning requisitions to new preparer and requester.
• Pulling reports based on the requirement in Ariba network for reconciliation activity.

Confidential

Oracle apps technical consultant

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions based on business requirements.
• Created various data base objects line tables, cursors, indexes, views, triggers, stored procedures and functions.
• Worked onTuning of queriesof the CustomReportsto improve the performance utilizing diagnostic tool (Explain Plan).
• Worked withP2P(Procure to pay) business flow including modulesPO(purchase order),AP(accounts payable) andGL(general ledger).
• Creation of value-sets, registering the reports and running the reports using the System Administrator Module.
• Involved in development of Interface/conversions to migrate legacy data to ERP.
• Design & Customization of reports.
• Worked on OAF Form personalization in oracle apps r12.
• Worked on customization of reports to convert into XML Publisher reports.
• Defined Concurrent Programs, Executables, and value sets and lookups.
• Migrating the Components Using FND Loader from one instance to another instance.
• Prepared technical documents like MD70 and TE20 for the components.
• Worked withP2P(Procure to pay) business flow including modulesPO(purchase order),AP(accounts payable) andGL(general ledger)
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Worked on RICE components.
• Involved in Preparation ofTest Casesand Test Plans and System Testing.