We provide IT Staff Augmentation Services!

Oracle Apps Functional Consultant Resume

4.00/5 (Submit Your Rating)

Houston, TX

EXPERTISE SUMMARY:

  • Over 8 years of experience as an Oracle EBS Functional SME which includes Implementation, upgrades, Testing and Production support on Oracle Apps 11i, R12.
  • Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Purchasing, Cash Management, iProcurement, Inventory, TCA, iSupplier and iExpense .
  • Experienced in Supply chain modules implementing and supporting Order Management, Purchasing and Inventory modules.
  • Expert in core procurement suite of applications including Purchasing, iProcurement, Contracts, iSupplier, Sourcing and others.
  • Extensive working knowledge on OSN (Oracle Supplier Network) integration and EDI Integrations with Oracle Procurement Suite of Applications.
  • Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi - Org.
  • Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
  • Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training sessions.
  • Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
  • Special expertise in implementation of self-service modules including, Internet Expenses, iSupplier, iReceivables and iProcurement.
  • Implemented Financial Analysis Reporting by defining FSG Reports and Oracle Discoverer Business Areas and Workbooks.
  • Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
  • Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports
  • Experience testing Conversions, Interfaces, Data Migration and various custom RICE components.
  • Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.
  • Worked in Onsite and Offshore model projects, coordinating and leading offshore team
  • Maintained configuration documents and compared against Business Requirement and made recommendations as necessary.
  • Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
  • Extensively used AIM methodology for designing standard documents (MD50, BR100, and CV10 & CV40).
  • Thoroughly involved in creating Test Scripts TE040 and end to end testing TE060 cross modules.
  • Good understanding of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PLSQL, TOAD etc.
  • Extensive Knowledge on Version Control, Migration and Ticketing Software.
  • Proficient is documenting Specifications following AIM Methodology. Authored MD50, MD120, BR100, CV40 documents.
  • Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
  • Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.
  • Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics
  • Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques)

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 11i(11.0.3,11.5.9,11.5.10.2), R12(12.0.4, 12.0.6, 12.1.3)Purchasing(PO), Accounts Payable(AP), Account Receivable(AR), Order Management(OM), Inventory (INV), General Ledger, SLA, iExpense, Sourcing, iSupplier, iProcurement, Shipping, Advanced Pricing, Application Object Library(AOL)Approval Management (AME), Workflow Administration.

Languages: SQL, PL/SQL, UNIX

Oracle Development Tools: Toad, SQL Developer, Putty, SQL*PLUS

GUI Tools: Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i, XML(BI) Publisher, Workflow Builder, Discoverer

Operating Systems: Windows (XP,7), Unix, AIX, Sun Solaris, Linux

Oracle Utilities: SQL Loader, UTL FILE, DBMS Utilities, TKPROF etc.,

Version Control and Ticketing Software: HP Rational Clear Case, PVCS, SYSAID, HP Service Center

PROFESSIONAL EXPERIENCE:

Confidential, HOUSTON, TX

ORACLE Apps Functional Consultant

Responsibilities:

  • Engage with the  business users at different levels to understand  business needs, Document the requirements 
  • Interacted with business users in Finance, Accounting to Gather requirement, build new business case studies, requirement mapping, create functional design and solution design and work with the implementation teams to build, test, deploy and support it
  • Work with IT development teams and other cross-track team members in converting the Business Solution into a Technical (system) solution.
  • Ability to understand heterogeneous application footprint and design solution accordingly.
  • Participate in cross-functional process improvement initiatives
  • Possess a sense of vision, ability to motivate and influence others, solve problems, meet deadline and executive presence
  • Ability to work in a fast pace and changing environment
  • Identify and manage metrics required to ensure quality and performance of the Supply Chain team.
  • Save money and contribute to optimizing predictability.
  • Implementation and support of Oracle Applications R12 (PO, iProcurement, Sourcing, Inventory, Accounts Payables, GL)
  • Worked as Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets
  • End to end Oracle Applications (GL, AP, and PO) implementation project from assessment to production support as a functional analyst.
  • Participated in the financial accounting Month-end close process to ensure financial sub-ledgers, Accounts Payable (AP) and Accounts Receivable (AR) close successfully and resolved problems relating to the process of reconciliation of GL with AP and AR
  • The different profiles of the Customers are taken care of and accordingly validations are performed and the mandatory columns are populated in the interface tables via Staging Tables. Receivables Customer Interface program is used.
  • Account Receivables (AR): Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto accounting Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Defined Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles
  • Responsible for setting up the interfaces between legacy Accounts Receivables (AR) systems into Accounts Receivables (AR) invoicing system
  • Setup stores, mapping catalogs to purchasing categories, and defined expense account rules in iProcurement
  • Performed setups for creating requisition for catalog and non-catalog items in iProcurement module
  • Assisted a project team in understanding the integration of Purchasing with iProcurement
  • Conducted Unit testing of Purchasing (P2P) cycle, iProcurement and Inventory modules.
  • Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP ’s related to the split scenario and post production data cleansing.
  • Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
  • Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, documenting and rolling out the deliverables
  • Map client business requirements to Oracle functionality and setup application in the Test, Development and Production environments for new extensions.
  • Setting up of various types of Purchase Orders i.e. Standard purchase order, Blanket purchase agreement, Planned purchase order and Contract agreement.
  • Involved in Procure-to-Pay process (P2P) for resolving various issues related to creating requisitions, PO, confirming the Receipt, creating Invoices, Paying the supplier and Transferring to GL.
  • Supporting of existing RFP’s and working on them.
  • Reporting to Management on the status of the developments and directly interacting with clients to resolve the issues and coordinating with Technical Team on deliverables
  • Supported Procure to pay issues during month end performing additional configurations.
  • Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
  • Resolved issues related to payment processing, payment authorization, and suppliers.
  • Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
  • Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AP invoice Interface.
  • Configured banks, bank accounts and documents for different needs like AP processing.
  • Coordinating with Offshore development and Functional Team to resolve Issues.
  • Built many custom reports to meet the requirements of different clients. 
  • Technical and functional support in implementing Procure to Pay and Finance processes. 
  • Setting up Buyer, Approval Groups, and Approval Assignments in Oracle Purchasing Application
  • Defined Supplier, Supplier sites, Organization, Items, Purchasing Options and Buyers.
  • Defined Approval Hierarchy Set-up and Maintenance for approving PO
  • Worked on auto creation of Purchase orders for catalog items with valid vendor information
  • Assisted client super user in capturing business requirements for iProcurement and Purchasing modules and completed setups for the same
  • Configured custom Approval Groups and configured AME for both requisition/PO approval workflows. Designed custom extensions around account generator workflow to incorporate business needs.
  • Provided with useful training to the users in General Ledger, Account Receivables, Account Payables and Order Management Modules.
  • Involved in requirement gathering and authored MD 50 documents for the various reports and Interfaces which includes AR Invoice and AP invoice Interface.
  • Responsible for the requirement gathering, firming up the scope and mini plan with the working group, solution designing coordinate with the development team, functional testing and documentation .
  • AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets. Worked on receipt class, specifying creation method, payment method, defining collectors and aging buckets. Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
  • Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos
  • Assist Testing Team in validating User Acceptance Testing Test Scripts related to R12 Conversions and involved in Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing.

Environment: Oracle Applications 11i Support/R12 Implementation (PO, iProcurement, AP, GL, Accounts Receivables, OM,GL), SQL, PLSQL, SQL*Developer

Confidential, REDWOOD shores pkwy, CA

Oracle Apps Functional Consultant

Responsibilities:
  • Analyse business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with the users to review, incorporate feedback and obtain approvals for the Functional Specification.
  • I implemented General Ledger, Account Payables, Credit Management, Advanced Collections and Order to Cash (O2C) modules: Order Management, Inventory, Warehouse, Purchasing, Receivables within Oracle EBS.
  • Implemented Commodity Approver approvals and Delegations, iProcurement non-catalogue requisitions, Blanket and Contract Agreements, Bulk loads and Punch outs
  • Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items
  • Worked with R12 implementation team, gathering requirements and authoring business requirement documents and functional specifications.
  • Conduct numerous business meetings to identify and assess the impact of production issues and provide solutions along with functional impact analysis
  • Worked closely with business users to resolve day to day issues with requisitions, order entry, shipping and material transactions, and receiving on the procure to pay cycle.
  • Done the Configuration for GL, AR, modules as per the client needs
  • Account Receivables (AR): Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, Auto accounting Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets. Defined Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer & Sites, Remit to Address, System profiles
  • Helped the technical team in the customer conversion, Open AR invoices and receipts conversion
  • Involved in direct interaction with the business users and collecting information required for resolving support incidents.
  • Developed Training Material for AP and AR modules and prepared impact analysis.
  • Extensively worked on Month end and Year end reconciliations for closure of sub ledger modules - AR and AP.
  • Worked on Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
  • Involved in the Bridge Calls during Cut-over/ Go-live phase.
  • Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules and involved in Quality Testing (QT).
  • Analyzed the support incidents logged in the remedy system and suggested as well implemented solutions.
  • Conducted knowledge sharing sessions for the team members in the functional areas of known modules.
  • Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
  • Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
  • I-Procurement - Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogues and Categories, Account Generator, etc.
  • Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the Purchase Order is created for a Back to Back process .
  • Creating Job, Position, and Position Hierarchy in Oracle Purchasing Module
  • Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.
  • Defect resolution and End-to-End Functional testing of the Standard and customized processes in the Order Management module (Order to Cash Cycle).
  • Lead & participate in P2P project initiatives (iProcurement, Commodity Code, Global Supplier Data Management, Invoice Automation, etc.). 
  • Produced different types of testing like Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing.
  • Presentation of Financial Consolidation system to the Management and Involved in Month-end support for close and reconciliation for AP, Fixed Assets and AR modules.
  • Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
  • Identified global business processes, created & demonstrated Business Process Document (Visio flow) diagram 
  • Created Proof of Concept (POC) & High level concept document (BF045) and demonstrated to Business Subject Matter Expert (SME).  
  • Completed Oracle Application Configuration / Setup documents, identified standard business Test scenarios, created Test Scripts, Built the R12 Global single instance, worked on generic interfaces with Legacy systems and conducted CRP testing for procurement and Payables as per client requirements. 
  • Managed service request from deployment sites (GAP), provided Solutions and designed customization of Requisition Account Generator workflow.
  • Configured Oracle Payables by setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes, etc.,
  • Created ASL sourcing setup to automatically source the documents to default the price in purchasing documents like Requisition, Purchase Orders etc., 
  • Implemented Oracle Fixed Assets module using AIM methodology, which included configuring Asset categories, asset locations, book controls, depreciation methods, security profile, asset calendar, fiscal year, quick codes and system controls.
  • Implemented Approval Management (AME) for Purchase requisition, Change order and Purchase order approval to streamline purchasing approval process
  • Designed One-time address customization in iProcurement similar to Vendor model in TCA (Trading Community Architecture), Smart Form for non-Catalog requisition to guide requester for appropriate category selection, Setup Direct & Transparent punch-out to Supplier Catalog, OAF personalization of iProcurement pages.
  • Help Supplier on-boarding in iSupplier Portal & customized pages using OAF Personalization. 
  • Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.
  • Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
  • Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
  • Involved in the analysis and design phases of various iProcurement initiatives. Configured external punch outs and OSN.
  • Defined and Customized iProcurement and Purchasing related Responsibilities, Functions, Menus and Sub-Menus as per BRD documents.
  • Responsible for setup, design and testing the purchasing Position Hierarchy for routing PO Approvals as required for the business.
  • Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
  • Prepared setup documents for Accounts Payable, Purchasing and iSupplier modules.
  • Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
  • Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
  • Participated in user testing and helped in migration to production for BAU activities.
  • Provided extensive production support of Oracle financials, including following up SR’s with Oracle meta-link.
  • Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
  • Implemented Order to Cash (O2C) modules: Order Management, Inventory, Purchasing, Receivables within Oracle EBS

ENVIRONMENT: Oracle Applications R12 12.1.3 SCM (AP, AR, GL, PO, INV, OM, iExpense, iProcurement, FAH/SLA), SQL, PL/SQL, TOAD, EIS Reporting, Workflow Administrator, SVN.

Confidential, Scotts Valley, CA

Oracle Apps Functional Consultant

Responsibilities:
  • Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpense, iProcurement and iSupplier.
  • Confirm the detailed UAT plan and scope including the number of UAT and end-to-end scripts required. 
  • Leverage System Integration test documentation where possible to expedite the delivery of Unit, SIT, and UAT End-to-End testing. 
  • Conducted orientation training, CRP, UAT and Rollouts strategies for System up-gradation.
  • Designed and created new CHART OF ACCOUNTS and set of books.
  • Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
  • Authored high quality end user training documentation for Oracle Financials (GL.AP,PO, iProcurement, AR and BI) and delivered end-user training session via Web using Oracle UPK 12.1 w/ Knowledge Center 
  • Resolved various issues related to Procurement Catalog Up loader Process and Global Blanket Purchase Agreement creation for R12 Catalog Maintenance.
  • Performed post Upgrade Payments Setup and configured various out bound interfaces.
  • Analyzed CEMELIS and with the help of Technical resource resolved various compatibility issues and migrated objects to the new R12 instance.
  • Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
  • Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.
  • Worked as support to the  functional analyst on day to day issues across modules and functionalities which includes material transactions, PO's, Receipts and invoice issues .
  • Viewed Approval Status in Oracle Purchasing automatically displaying the approval status of transaction and informs whether it is Approved, Cancelled, In Process, Incomplete, Pre-Approved, Rejected, or Returned. Used to know where the transaction is within this flow at all times.
  • Troubleshooting and fixing the issues in Order management application - Customer Credit Check, Backordering, Return Material Authorization issues.
  • Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.
  • Created/supported end-to-end processes for: Order to Cash (O2C) reporting improvements.

ENVIRONMENT: Oracle Applications 11i/R12 (AP, AR, GL, PO, INV, OM, AOL), SQL, PL/SQL, TOAD, BI Publisher, Clear Case, Quality Center, AIM Methodology, UPK Knowledge Center .

Confidential, Marlborough, MA

Oracle APPS FUNCTIONAL CONSULTANT

Responsibilities:
  • Resolved all the functional and technical issues for AR, AP, CM, FA, GL, and PO Modules.
  • Preparation and modification of documents like MD050, BR100 as part of project Deliverables for the change requests for functional and technical configuration changes.
  • Post production support and maintenance of the Application and resolved user queries.
  • Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Revaluations, and consolidation.
  • Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
  • Created users and modified the privileges for users, rollup group and summary accounts.
  • Created suspense accounts for automatic balancing journal entries from particular sources and categories.
  • Set-up supplier and supplier sites for suppliers in payables.
  • In iProcurement: Designed workflow customizations and punch-out catalogs; Defined requisition templates and assigned system profile options; Extracted catalog and item data; Performed setups of approval hierarchy, approval groups and approver assignments.
  • Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.
  • Prepared end user training material with specific business cases and conducted end-user training.
  • Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.
  • Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader.
  • Involved in the month end closure and reconciliation activities to close the periods on respective financial modules.
  • Provided production support for day to day business issues and worked on SRs with Oracle.
  • Provided daily user support for Fianancial modules and applied patches as and when required to resolve the Application issues.
  • Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.
  • Involved in   P2P cycle components

Environment : Oracle Applications R12 (12.0.5 /12.1.3 ) (UMX, AOL, GL, FA, AP, iExpense, XLA, CM, PO, iProcurement, iSupplier, Sourcing, Contracts, AR, Inventory, FAH), Oracle 11g Database, HP Quality Center, TOAD.

Confidential, Bedford, MA

ORACLE APPS Functional Consultant

Responsibilities:
  • Worked as member of Support Team for modules GL, AP, AR and CM
  • Reviewed daily support SR’s, co-coordinated with users and resolved issues
  • Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
  • Developed functional documents for technical customizations in OM, INV, PO and AR modules.
  • Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
  • Trained users and Created test scripts for new functionalities
  • Provided User training on one to one basis and also in group mode
  • Updated Value sets’ values for COA. Defined cross validation rules & security rules
  • Set up of Parent & Child relations, Rollup Groups and summary templates
  • Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines .
  • PO matching options, invoice tolerances, distribution options, terms, holds, etc.
  • PO setup and matching options with invoices.
  • Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
  • Helped in Inventory management module for costing problem. Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right
  • Provided production support for day to day business issues and worked on SRs with Oracle.

Environment: Oracle Applications (R12) (AR, AP, PO, GL, OM), SQL, PLSQL.

Confidential, PALMYRA, NJ

ORACLE APPS Functional Consultant

Responsibilities:
  • Gathering business requirements from the process owners and getting it documented and delivered
  • Analyze requirements, perform Gap analysis, produce functional specifications, document existing and new processes, undertake impact analysis
  • Created/supported end-to-end processes for: Order to Cash (O2C) reporting improvements.
  • Tested end to end flow of Order to Cash cycle (O2C).
  • Created organizations, inventory items, catalog RFQ, got approval from supplier in procure to pay cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.
  • Updated BR100 documents for the changes and got them approved by business before moving them to production
  • Responsible for setting up the interfaces between legacy AR systems into AR invoicing system.
  • AR Setups are such as Transaction Types (Invoice Types), Auto Accounting Setups, and Configured Invoice Types with Order types, AR Batch sources, remit to addresses, Receipt Classes and Payment Methods.
  • Viewed Approval Status in Oracle Purchasing automatically displaying the approval status of transaction and informs whether it is Approved, Cancelled, In Process, Incomplete, Pre-Approved, Rejected, or Returned. Used to know where the transaction is within this flow at all times.
  • Setups included Defined Invoice attributes- Payment Terms, Approve, Hold & Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes- Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
  • Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report.
  • Implementation of AR , involved in requirements gathering sessions with the client and Preparation of Functional Test Scenarios & Test cases for AR.
  • Identified the associated primary ledger for any legal entity, ledger, operating unit, and reporting currency.
  • Involved in testing process like Unit Testing, System Integration Testing, User Acceptance Testing, Regressive Testing and Quality Testing
  • Responsible for defining Order Management setup for Picking Rules, Inventory Organization Shipping Parameters, shipping networks, and inter organization transfers, RMA for credit.
  • Responsible for resolving issues around Internal Sales Orders, Order Entry, shipping, AR invoicing and billing for standard and return orders.
  • Configured the business process in the Test Instance and testing of various business scenarios.
  • Worked with Oracle Technical Support to resolve the critical issues through SR/TAR.
  • Supporting the functional testing of the solutions
  • Supporting the solution during integration testing

ENVIRONMENT: Oracle Applications 11i/R12 (AP, AR, PO, INV, OM, GL), Reports Builder 10g, SQL, PLSQL, TOAD, AIM, JIRA, OAF Personalization’s.

Confidential, BOSTON, MA

ORACLE APPS Functional Consultant

Responsibilities:
  • Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
  • Interacted with Oracle to get the issues addresses by logging SRs.
  • Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
  • Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
  • Responsible for preparation of test scripts and monitoring UAT.
  • Prepare the  upgrade plan for the Purchasing and Finance modules
  • Supported extended Procure to pay process ( including PO, AP ) in Production both in 11i and upgraded R12 instance and resolved various issues working in collaboration with  Oracle Support. 
  •   Participated in all phases of  upgrade - Analysis, Design, Coding & Development, Testing.
  • Prepared fit-gap analysis for the  upgrade and re-evaluate the customizations against the new features provided by the upgraded.
  • Extensively worked on Month end and Year end reconciliations for closure of sub ledger modules - AR and AP.
  • Responsible for Retrofitting and re-building custom components post execution of standard features testing.
  • Involved in the Bridge Calls during Cut-over/ Go-live phase.
  • Provided pre-upgrade and post-upgrade support for financial modules.
  • Involved in the production support of modules like General Ledger, Accounts Payables, Accounts
  • Coordinated with Oracle Support, creating SRs, attending OWC sessions, providing 24X7 support for quick resolution of high prioritized issues

ENVIRONMENT: Oracle Applications R12 (AP, AR, GL, PO, INV, OM), TOAD, SQL Developer

Confidential

ORACLE APPS Functional Consultant

Responsibilities:
  • Worked as member of Support Team for modules GL, AP, AR and CM
  • Reviewed daily support SR’s, co-coordinated with users and resolved issues
  • Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
  • Developed functional documents for technical customizations in OM, INV, PO and AR modules.
  • Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
  • Trained users and Created test scripts for new functionalities
  • Provided User training on one to one basis and also in group mode
  • Updated Value sets’ values for COA. Defined cross validation rules & security rules
  • Designed Financial Reports using Financial Statement Generator (FSG) tool
  • Set up of Parent & Child relations, Rollup Groups and summary templates
  • Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines .
  • Proficient with Procure to Pay cycles, including modules Inventory Management, Payables, Purchasing, Receivables

ENVIRONMENT: Oracle Applications 11.5.10.2 (AP, AR, PO, OM, INV, GL), SQL*Developer, Reports 6i, Forms 6i, SQL, PLSQL, Workflow Builder, Discoverer

Confidential

ORACLE APPS Functional Consultant

Responsibilities:
  • Created comprehensive test cases and performed end-to-end functional testing of CRs 
  • Co-ordinated the changed functionality with the Technical team for development and performed extensive functional testing before performing UAT with business users.
  • Involved in functional analysis and resolution of complex tickets on a daily basis with strict adherence to SLAs.
  • Was part of the Post Production Support phase for the European region; was involved in cost management, inventory, order management, purchasing, and AR and AP modules.
  • Perform detailed root-cause-analysis of production issues and coordinate with business users explaining & educating them on issues and functionalities.
  • Provided production support for 11i SCM (Inventory, Purchasing, Sourcing, iProcurement) 
  • Created, monitored, followed up and closed the Service Request (SR) with Oracle Support.

ENVIRONMENT: Oracle Applications 11.5.10.2 (INV, PO, iProcurement, AR, GL, AOL), TOAD, SQL, PLSQL, Service Now

We'd love your feedback!