Oracle Order To Cash Functional Resume
Salt Lake City, UT
SUMMARY:
- An Oracle Order to Cash Functional Consultant wif over 9+ years of functional accounting, business analysis in various industries and sectors of teh economy in Oracle Applications expertise.
- Possess strong verbal and written communication skills. A strong team player, and adaptable to a variety of roles in teh Corporate Information System area has great working knowledge of Client/Server technology, and financial applications. Also possess teh ability to analyze situations and offer innovative cost - effective solutions.
- Conducted and evaluated several Business Process Reviews (BPR) and GAP Analysis to resolve business requirements not addressed by teh application.
- Competent in various modules in Oracle Financials 11i.
- 4 Full Life Cycle in Release 12
- Very good experience in teh Order to Cash, Invoice to Report and Procure to Pay flow.
- Competent in understanding teh functionality of teh core Oracle Financial modules and their interplay in teh overall accounting structure of an organization.
- Prepared Business Requirements Definition (RD) and Module Design (MD) documents required under teh AIM methodology.
- Developed test case, test plan and resting process and conduct core team and end user training.
- Experience wif Vertex Tax Software integrating it wif Oracle AR Module.
- Conducted several UAT’S and CRP’S in Oracle Applications
- Good working knowledge and interpretation of financial statements such as retained earnings and balance sheet statements
- Configured and implemented applications as per teh clients request and teh business requirements.
- Created Use-Manuals for programs and user procedures.
- Provided postproduction support.
- Interacted wif Oracle Support to resolve application issues.
- Developed business process flows, identified risk points and suggested risk mitigating control measures.
- Good knowledge and understanding of general accounting TEMPprincipal’s “GAAP”.
- Excellent planning and organizational skills.
- Team oriented, self-motivated and a disciplined individual.
TECHNICAL SKILLS
Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup
ERP: Oracle Financials (12.0.5, 10.7 and 11i)
Modules: Accounts Payables (AP), Accounts Receivables (AR)Purchasing, Payroll, Advance Collections, General Ledger (GL), Fixed Assets (FA) and Purchasing.
Methodology: AIM (Applications Implementation Methodology)
Business Intelligence: Working knowledge of Oracle Discoverer
Language: Reasonable understanding of SQL
Oracle and Other Tools: Data loader, ADI, Web ADI and MS-Office tools including Visio / MS Projects
PROFESSIONAL EXPERIENCE:
Confidential, Salt Lake City, UT
Oracle Order to Cash Functional
Responsibilities -
- As a Functional Consultant implemented teh following modules: Inventory, Order Management, AR, General Ledger, Global Order Promising, Shipping, Advance Pricing
- Worked on teh Functional mapping of data Conversions & Enhancements for Inventory, Order Management modules.
- Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Worked on Inventory setups - defining teh Organization Structure, defining teh Sub Inventories, Catalogs, Categories, Planning (Min Max and Re Order Point Planning), Defining Cost Groups, ABC Analysis, Cycle Counting, Physical Inventory and Item Import Program
- Worked on teh AR Setups - defining teh Auto Invoice, Auto Lock Box, Revenue Recognition process, Accounting and Invoicing rules, Transaction Types, etc.
- Worked on teh Refund functionality in Oracle AR
- Worked on teh AR/AP Netting process in AR
- Worked on teh Bank Setups in AR module.
- Worked on teh setups of OM Module - Defining teh order and line workflows, defining teh transaction types, setting up Processing constrains and Defaulting rules.
- Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of all teh above modules.
- Successfully provided Technical and Functional support to teh users, testers and Business System Analysts.
- Provided wif useful training to teh users in Inventory, Global Order Promising, General Ledger, AR, Shipping, Order Management, AR, Shipping and Advance Pricing Modules.
Environment: Oracle Apps Release 12.2.7 e-Business suite (Inventory, Global Order Promising, General Ledger, AR, Shipping, Order Management, Advance Pricing)
Confidential, Denver, CO
Oracle Order to Cash Business Analyst
Responsibilities -
- Lead numerous requirement gatherings, designing, documenting and unit testing of various RICE components for R12 Customizations.
- Working on Order to Cash area using Oracle Apps R12 (Order Management, Inventory, Purchasing)Designed new processes for Forward Logistics, Inbound Logistics, Reverse Logistics and Return to Contract manufacturer (R2A).
- Worked on teh setups of teh Approval rules in AME - attributes, rules, actions, parallel approval, etc.
- Worked on configuration of teh Purchasing module - defining teh Buyers Workbench, Purchasing Options, Document Types and Styles, etc.
- Worked on teh setups of punch out’s in Oracle me-Procurement module
- Loaded teh catalogs into Oracle me-Procurement
- Worked on teh content zone setups in Oracle me-Procurement
- Responsible for implementation tasks including Requirements Gathering, Solution Design, System Configuration, Conference Room Pilot, Data Migration, Testing and Post Production Support.
- Worked on teh configuration of teh Payment Manager in Oracle Accounts Payable module – defining teh payment process profiles, configuring teh payments methods, payment modes, etc.
- Implemented Inventory, Accounts Payables, Order Management and Supply Chain modules using Oracle E-Business Suite R12.1.3.
- Analyzed teh current and new business process like Business Requirements Document (RD050) and Solution Design (MD050) using Oracle AIM methodology.
- Responsible for Configuration of Inventory and Shipping modules to support teh various Business solution
- Involved in defining Shipping Key Flex field, Lookups, Transaction Types, Organization Parameters, Sub inventories and Shipping Networks.
- Worked wif development team to provide expertise and ensured successful delivery of extensions, reports and interfaces.
- Worked on different EDI interfaces likeEDI4B2, 3B18, 3B2 Ship Confirm and 3B3 Milestone messages from partners and process teh same for transactions in Oracle APPS Supply Chain Deliver Track.
- Worked wif various Cross Functional Tracks to resolve technical and data issues.
- Responsible for BR100 setups to support deliver track solution as well as business setups planned for each release.
- Coordination wif offshore team to enable them to understand teh process and to familiarize them wif teh issues dat normally generate and teh probable ways of resolving them.
- Participated in ongoing Process Enhancements and Change Management meetings and Deep Dive sessions wif Business and Doing impact analysis.
- Worked on Defects logged in HPQC, and ensured dat they were fixed on time wif teh technical team.
- Created Test Plans as per business scenarios and planned testing strategies.
- Wrote Test Cases and Test Scripts (TE040) forfunctionaltesting.
- Tested and implemented teh requested changes in existing environment.
- Performed Root Cause Analysis of Month end related issues and provided a solution to reduce teh month end Services.
- Worked wif development teams wif Water Fall Model and Agile Methodology.
- Worked on Sprint Approach to support teh Receiving Lite Disposition for reverse Logistics to be being implemented using PEGA (PEGA Business Rules)
Confidential, Ridgefield, NJ
Order to Cash Business Analyst
Responsibilities:
- Design and configure OM, INV, PO, AR, Shipping as per business requirements.
- Coordinated and lead teh entire phase of teh project which included initial operations analysis, business process evaluation, testing, conversions, customizations and documentation.
- Maintained proactive interaction wif teh client to understand business practices to aid in system configuration.
- Configured teh Accounts Receivables modules wif functional specifications
- Worked on EDI Inbound and Outbound Interfaces for 850, 861, 810, etc.
- Understand teh specific issues and problems faced by business user in teh area of accounting (SLA) and (Financials Accounting Hub) due to upgrade and provide teh solution to resolve teh same by configuring SLA and Financials Accounting Hub.
- Identify teh business requirements and process improvements dat can be achieved through SLA and e-BTax.
- Setup new Trading Community Architecture (TCA) to meet specific accounting requirements of various business units.
- Setup Supporting Reference Balances to enable inventory balances by items and payable account balance by vendor.
- Suggest SLA setup to do multi currency and multi GAAP accounting for Switzerland and France.
- Prepared teh test scripts and performed teh SIT Testing. Documented teh setups and business process flows. Prepared teh training material and trained teh users teh functionality of teh financial modules.
- Involved in teh conversions of teh legacy data into teh Account Receivables and Payables modules, code migration and cutover activities.
- Developing detailed functional design specifications based on business requirements for interfaces and extensions to provide seamless integration between Oracle Applications and Custom Applications.
- Developing functional design specifications for custom reports based on business requirements. Prepared teh Oracle Tutor documents explaining teh usage of Operational Reports to assist manufacturing personnel. Review and approve technical design specifications for custom objects and ensure dat teh design meets business requirements.
- Design and develop standard operating procedures using Oracle Tutor.
- Perform unit testing of various RICE elements and review teh same for compliance wif teh Technical design specifications.
- Identify test data requirements and organize for test data collections. Also design various test sets to simulate different business scenarios in Test director and perform integration testing for teh same. Trained teh Super users using teh UPK kit.
- Post Production Support Post Go-Live adhering to SLA’s based on teh Severity of teh Help Desk Tickets.
Environment: Accounts Receivable, me-Procurement, me-Expense, E-Business Tax, Inventory, Purchasing, Order Management, BOM, WIP, me-store, me-supplier, Sales Incentive, PL/SQL, SQL, Toad, Linux, Windows XP, Vertex Software. Web ADI, Discoverer.
Confidential, Boca Raton, FL
Order to Cash Functional
Responsibilities –
- Actively involved in implementation of E-business suit for SGP Operating Unit including gathering teh requirements from teh user and understanding their business model teh modules worked on includesOM, INV, PO, AR, Shipping Modules
- Worked on all teh Business Analysis of developing teh GAP Analysis, Business Requirement Documents (BRD’S), Functional Specification Documents (FSD), MD050, BR100, TE020, Te030, etc.
- Developed teh Functional Specification Documents (FSD) and Technical Specification Documents (TSD) for all of teh customizations and data conversions.
- Worked on teh configurations of OM, INV, PO, AR, Shipping module.
- Reviewing Functional Specifications / Change requests wif teh client.
- Worked on teh Revenue Recognition process in AR Module.
- Communicating teh requirements to teh technical team
- Preparing design document as per teh functional requirements
- Preparing System / Integration Test cases and carrying out Integration testing
- Supporting teh users wif teh User Acceptance Testing (UAT)
- Taking part in teh review of test cases and giving necessary inputs.
- End-user training
- Updating teh client on teh status of teh project at offshore, almost everyday.
- Reviewing and giving inputs on all teh developed components, Unit test Plan and Unit test report.
Confidential, NJ
Oracle O2C Functional Consultant
Responsibilities
- As a Business Analyst Supported teh financial modules: OM, INV, PO, AR, Shipping in Release 12.1.3
- Lead Conversions & Enhancements for OM, INV, PO, AR, Shipping module
- Worked on setting up of Revenue Recognition process in AR Module
- Defined teh Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
- Worked on teh setup of AP module – worked on teh ACH Process wif teh bank, defined teh AP transaction types, worked on payment terms, worked on interfacing AP data wif external systems.
- Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Configured AP, GL, me-Procurement, me-Supplier, me-Expense, PO modules from scratch and simultaneously created BR100 documentation for teh setups.
- Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of all teh above modules.
- Successfully provided Technical and Functional support to teh users, testers and Business System Analysts.
- Provided wif useful training to teh users in AP, GL, me-Procurement, me-Supplier, me-Expense, PO.
- Created FSG Financial Reports critical to company’s business process.
- Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.
Confidential, San Jose, CA
O2C Functional Analyst
Responsibilities -
- As a Business Analyst implemented teh AP, GL, me-Procurement, me-Supplier, me-Expense, PO modules
- Worked in teh configuration of AP, GL, me-Procurement, me-Supplier, me-Expense, PO modules.
- Performed Requirement and GAP analysis.
- Configurations and Setups for AP, GL, me-Procurement, me-Supplier, me-Expense, PO
- Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
- Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Involved in teh Setups of Revenue Recognition including teh setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up teh Daily Revenue Rule dat are new in R12.
- Worked on teh Setups of teh AP module – defined teh AP Transaction Types, Supplier Setups, worked on Payment Manager setups, Check Printing process, etc.
- Worked on teh Auto Lock box process in Oracle AR module.
- Worked on Auto Accounting in teh AR module
- Worked on teh Auto Invoice Process in AR Module.
- Worked in a team in understanding teh integration of Advanced Pricing wif OM process
- Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work.
Environment - Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US and Canada OM, AR, AP, GL, Advance Collections, INV and PO modules