ORACLE Apps Functional Consultant Resume HOUSTON, TX - Hire IT People

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