SUMMARY

• Having around 9+ years of experience in the IT Industry in implementation, upgrade and customization ofOracle e - Business Suite Applications.
• Functional experience in configuration, setup, unit and integration testing of various Oracle Application Modules and customizations for meeting gaps in client requirement and application.
• Expertise in RICEW component design, development and having good functional and technical exposure on different modules of Oracle Application like General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets(FA), Order Management (OM), Purchasing (PO), Inventory (INV), EB tax, Advance Pricing, BOM, I-Procurement, I-store, E-Commerce Gateway, Oracle Mobile Applications Framework, Service Contracts, Depot Repair, Field Services, Install Base, Web ADI and Oracle Alerts.
• Functionally proficient in SCM (OM, INV, PO), Finance (AP, AR, GL, FA) BOM, WIP, CRM (Service Contracts, CRM Foundation, Install Base, Depot Repair) and TCA modules business process Setups.
• Pleasant experience customizing and personalizing approvals using Oracle Approval Management (AME).
• Hands-on involvement in business process flow development, and configuration of test instances, demonstration, unit and integration testing, documentation, end-user training, go-live and post-implementation support.
• Strong in UNIX shell scripting and performance tuning of several objects using hints and several other processes, analyzing TK-Prof files and Explain Plan
• Experienced in Implementation, version upgrade, support & maintenance projects.
• Experience in developing ORACLE APEX applications.
• Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like BRD100, MD.50, MD.70and TE.20.
• Expertise in Advanced level of PL/SQL concepts.
• Configured Primary Ledger, Secondary Ledger, Business Group, Operating Units, Legal Entities, Inventory Org and Sub-Inventory Org in application as per MOAC (Multi-Org) in Oracle EBS.
• Extensive experience in conversion of legacy data into Oracle Applications developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.
• Involved in Revenue Recognition setups and process.
• Experience in development and customization of Oracle Work Flow (WF), Approval Management Engine(AME), Oracle Application Framework (OAF), Application Development Framework (ADF), Oracle APEX, Oracle Alerts & Oracle Business Events according to business needs.
• Work with business users to resolve all the issues in Oracle Applications. Research the issues on Metalink and Open the SR with Oracle for critical issues.
• Exposure to data support on Multiple Environments like UAT, SIT, CAT, Training, and production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.
• Experience on Implementation of end to end functional setups required for P2P and O2C business process Setups, New inventory org creation and related setups.
• Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming, and performs testing and debugging of applications
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management, team building and adopting new technologies. Very flexible and perform tasks are ad-hoc basis
• Experience of Development and Customization Oracle Apps Reports/Forms and BI/XML Publisher using report builder6i/10g/11g.
• Expertise in preparing Packages, Procedures, Functions, Triggers and Cursors.

TECHNICAL SKILLS

OS/Environment: Windows, Linux and UNIX.

RDBMS (Database): Oracle 9i, 10g, 11g & 12c.

Oracle E-Biz Suite (EBS): Oracle Applications R12 & R11i.Oracle Fusion Cloud

Manufacturing, DistributionSupply Chain Management (SCM): Inventory (INV), Work In Progress (WIP), Bills of Materials (BOM), Purchasing (PO), Order Quote, Order Management (OM/OE/ONT), iStore, Shipping Execution (WSH), Project Accounting (PA), Advanced Pricing, iProcurement, iSuppliers, Human Resource (HRMS), Sys. Admin & Appl. Dev (AOL).

Financials: Accounts Payables (AP), Accounts Receivables (AR), iReceivables, Cash Management (CM), Fixed Assets (FA), General Ledger (GL) & Oracle E-Business Tax (ZX).

CRM Modules: Installbase (CSI), Service Contracts/Contracts Core (OKS/OKC), Service Requests (Field Service (CSF/CFS), Depot Repair (CSD) and Billing, CRM Foundation (JTF), Trading Community Architecture (TCA/HZ).

Languages, Scripts & Frameworks: SQL, PL/SQL, SQL*LOADER, Data Loader, JAVA, OAF, ADF, SOA, HTML,, XML, XSD, XSLT, XPath, WSDL, Oracle APEX, Shell Script, Java.

Middleware: Oracle Fusion 11g (ADF & SOA (BPEL, WSM & OSB))

Front-end Tools (GUI): Forms 6i, 9i,10g,11g. Reports 6i, 9i, 10g& 11g, Jdeveloper10g, Work Flow Builder.

Business Intelligence (BI): Oracle Discoverer 10g, XML Publisher and OBIEE.

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, WinSCP, Putty, FTP, JIRA, Lotus Notes, STATS, HP PPM, FileZilla, MS-Office, Open Office, SQL Mgmt Studio & RStudio. Version Controls: SVN, GIT & PVCS.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Interfacing with management on all Oracle EBS project related issues, changes, reporting and impacts ensuring that comprehensive information is provided to all stakeholders in a timely manner.
• Leading team of offshore and onshore model and owning the monthly release deliverables.
• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Responsible for Complete test cycle in Unit Testing, User Acceptance Testing
• Preparing Implementation Notes and coordinating with migration teams for successful code release.
• Involved in the CRP1/CRP2/UAT Functional testing.
• Experience with Source version control tools like VSS, PVCS, SVN, Quest Stat and Kintana.
• Attend meetings and follow up on resolution in all phases of SDLC process.
• Review development design for customer code and applications, approve development requests for production issue resolution (custom issues)
• Manage change control process, approval of code migration from Development, Test and Production environments and present changes at weekly status meeting.
• Creation of technical, functional and requirement documentation.
• Responsible for Post production activities of projects which are implemented in production.
• Development of custom components based on business requirements.
• Work with business users to resolve all the issues in Oracle Applications. Research the issues on Metalink and Open the SR with Oracle for critical issues

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Presently working on Oracle R12 Financials module as a techno functional analyst
• Prepared Proof of Concept document for implementation of Oracle APEX and set up development instance from scratch.
• Prepared Design flow for processing orders, cancellation and refunds business process which is integrated with third party systems.
• Worked on Custom API’s in PL/SQL (Business Logic)
• Worked in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 11g.
• Worked on Setups required for AR Auto Invoice, AR Lockbox process.
• Developed Oracle APEX application for Error Handling Report which makes business user to rectify the error records using APEX application for updating and deleting the existing records.
• Worked on design requirement for revenue recognition process.
• Developed SOA Web Service for integration between AQ tables of Oracle System push the data to third party system.
• Developed API for implementing the design functionality of revenue recognition process.
• Working in an Agile Scrum way, comprising of 2 weeks of each sprint. Each sprint features completion of development, analysis, unit testing, technical design document and overall flow document for the scope of the sprint followed by the Demo at the end.
• Interpreting customer business needs and translating them into application and operational requirements.
• Working with cross-functional teams to gather requirements design the process and implement effectively.
• Developing new reports and modifying existing accounting reports in Discoverer.
• Functional work includes oracle application setups such as lookup, accounting rule, receipt class, payment methods.
• Assisted in period closing and also daily production support by resolving system & user issues. Following up with Oracle Support on service requests.
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and UTL file in PL/SQL.
• Reviewed and submitted performance test results & Production Support to users globally
• Development work in PL SQL core programming, Oracle applications concurrent programs, DDL and DML scripts for new and existing objects such as tables, views, packages, procedures, form personalization.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Worked on implementation of Mock instance of Oracle Fusion Procurement Cloud for Procure to Pay business process and some part of Oracle financial Cloud.
• Procure to Pay (P2P) and Order to Cash (O2C) Validations.
• Involved in configuration of Setups required for Service Contracts and integration between SC and Inventory, order Management and Account Receivables.
• Customization of Terminating and creation of New Service Contracts for Return and replacement items.
• Customized Oracle workflow to add warranty line for service item based on customer and site configured in lookup.
• Involved in Implementation of end to end functional setups required for O2C business process Setups, New inventory org creation and related setups.
• Reconfiguration of Legal Entity, Operating Unit and Inventory Setup related to specific Organization.
• Worked on Setup of Pricing Flow, Formulas, Modifiers, Qualifiers and Custom Solution for Pricing for EDI processed Orders.
• Developed package for Item Attributes Interface which updates missing attributes for items.
• Interact with business users regularly on ongoing issues and provide accurate solutions.
• Worked on gathering requirements and mapped it to system requirements for receiving and shipping for OTC, Internal Order (IR/ISO), Assemble to Order, Back to Back, Work Order, PTP business processes in multiple global organizations.
• Analyzing the Clients requirements and implement the same in ERP system.
• Implementation of function and technical design and setups for Electronic Data Interchange (EDI) 850 E-commerce gateway process.
• Developed the XMLP reports using xml publisher reporting for multiple EBS modules like OM, Purchasing, Shipping, Accounts receivables, Accounts Payables, project Accounting etc
• Manage change control process, approval of code migration from Development, Test and Production environments and present changes at weekly status meeting.
• Extensively worked on preparing end 2 end test scenarios, test scripts on different applications to help the users for better understanding the application.
• Involved in System testing for Order Management seeded functionalities
• Expertise in preparing Packages, Procedures, Functions, Triggers and Cursors
• Created Materialized View for GL Account Analysis Report.
• Worked on OAF Personalization of Supplier, Customer, and Bank and Branches OAF pages.
• Prepared PL/SQL package for to generate payment format file for Confidential bank.
• Worked on CUSTOM.pll to make all forms read only which are accessed from Inquiry responsibility.
• Good Exposure on process and setups related to Intercompany Transactions.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Development of Inbound interfaces to create Service Request data extracted from Main Frames systems to Oracle System using SQL * Loader and send the new/modified customers data to credit systems.
• Personalization of Service Request and Task pages forms to meet the business functionality.
• Understand the user requirement and implement the Business processes to manage the Service to Resolution and Dispatch to Debrief Business flows.
• Involved in the setup of Oracle OM, Advanced Pricing, WIP, BOM, Service, Contracts, Depot Repair, Installed Base and CRM Foundation.
• Designed and set up different business processes for field service operations that included spares management, assignment manager and territory management.
• Integration of Oracle EBS with third party application which deals with field service business process.
• Created category sets, category codes, default category sets for the distinct items in Inventory application.
• Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups.
• Creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
• Item Upload conversion from legacy to Oracle ERP system.
• Worked on the different Purchase Order setups, generated the invoices, and resolved the pending transactions.
• Created setups to import Freight Costs entered at shipping into Account Receivables module
• Involved in functional support of production issues in oracle AP and AR modules wherever required.
• Reprice the order line price by customizing standard order lines workflow.
• Worked on AR receipts, Employee and Supplier Conversions.
• Developed the PL/SQL package for AP/AR/PO Attachment Conversions.
• Worked on fixing the defects raised during CRP2 and UAT.
• Debug the issues related to Oracle service contracts.
• Development of Interface for loading GL Daily Rates
• Support post production timelines and issues
• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per the requirements.
• Analysis of Function Design Document and preparing Technical Design Document.
• Involved in AR Setups like Auto Accounting Rules.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Configuration of Field Service setups like defining the SR types, Notes, Reason codes, resolution codes and reason and resolution mappings, lookups and profiles defining to meet the business requirement.
• Excellent understanding of Service to Resolution, Dispatch to Debrief business process.
• Integration of CRM foundation into Field Service like resource and user mappings, Territory and user allocation.
• Development of Inbound/Outbound Interfaces using oracle API’s to extract and send the Service Request, Contracts and Install base data from non-Oracle (boundary systems) systems and downstream systems.
• Contracts data conversion from legacy systems into Oracle system using SQL * Loader and Oracle Contracts API’s.
• Responsible for technical specification design, development of the code, unit testing the program based on six-sigma analysis and project execution.
• Working on supply chain management ERP modules
• Involved in designing, executing test cases and defect reporting
• Involved in preparation of test cases for RICEW components related to Order to Cash flow.
• Good Exposure on process flow of Intercompany Transactions.
• Test cases uploading using Quality Center.
• Involved in test cases Review (Audit).
• This Project includes both Support and Enhancements (Incident and Problem Management Activities).

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Development of XML Publisher Reports as per client requirement.
• Preparation of procedures, functions, packages as per the requirements.
• Involved in AR setups such as Transaction Source, Transaction Types, Receipt Classes, Auto Accounting Rules, Receipt Sources, Payment Methods, Customer Profile, Payment Terms, Auto Invoice. Successfully created all kinds of Transactions and transferred transaction to GL.
• Preparation of migration and shell scripts.
• Testing - Unit testing & Documentation.
• Developed Cost of Sales GL report.
• Developed Generate AR Billing Detail package.
• Developed Multiselect Parameter form.
• Developed custom program to interface all custom data to AR Interface table.
• Developed Item Conversion to import item details from legacy system to Oracle System.
• Gathering business requirements.
• Developing the RDF files with the requirements suggested by the user.
• Developing the RTF template for the XML report.
• Development of Lydall US Sales Order Acknowledgment report.
• Development of Lydall US AR Invoice Report.