We provide IT Staff Augmentation Services!

Oracle Scm Functional Analyst Resume

Portland, OR

SUMMARY:

  • Member of the functional focus team and about 8.7 years of IT experience, with primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
  • Functional Consultant specializing in Oracle Application implementations, specifically Oracle Financials and Supply Chain modules of Quoting, Advance Pricing, Shipping, INV, PO, AR, AP, GL, FA and Cash Management. Also worked on i-Expense and i-Receivables modules.
  • Extensive engagement work and project implementation experience and a good insight into the interactions between Oracle’s modules and project implementation methodologies.
  • Very good business experience and background and understanding of the detailed knowledge of best practices regarding the accounting and finance functions.
  • Extensive experience with EDI Standards, XML Standards, Rosettanet and e-Commerce Gateway
  • Extremely skilled on Procure to Pay as well as Order to Cash business flows.
  • Experience with Approval Manager Engine (AME)
  • Experience with European and Latin American Localizations.
  • Strong experience in Functional Specification design and writing clear Business specifications, understanding of project life cycles and methodologies, Analytical skills and problem-solving abilities, including the ability to troubleshoot effectively, make applications run very efficiently and/or with excellent real time response and ability to work in a professional manner, be flexible, and handle interactions with all levels of the organization and with external clients.
  • Very strong on Oracle’s Application Implementation Methodology (AIM)

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Oracle SCM Functional Analyst

Responsibilities:

  • As a Functional Consultant implemented the Quote to Cash Business flows including OM, Quoting, Advance Pricing, AR, GL and INV modules.
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for OM, Quoting, Advance Pricing, AR, GL, INV
  • Worked on the European Localizations for NL and UK
  • Worked on the 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 with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Approval Hierarchies in Purchasing Module.
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Worked on the Auto Lock Box process in AR.
  • Worked on the Inbound Purchase Order EDI 850
  • Worked on the Inbound Purchase Order Change EDI 860
  • Worked on the Inbound Invoice EDI 810
  • Worked on the Inbound Shipping Notice/Manifest EDI 856/857
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
  • E-Business Tax - Worked on the setup of the Rates, Regimes, Rate to Regime flows, exceptions, exemptions, Tax codes, tax rules in oracle e-Business tax module
  • E-Business Tax - Worked on the integration of Oracle e-Business Tax with Vertex Tax software.
  • I-Expense - Configured i-Expense module including setting up of Payables Lookup Types for i-Expense, Setting up Credit Card expense types, Expense check reimbursement address, Expense reporting template for Connected and Disconnected expense reporting, Defining the expense clearing account, establishing the multi currency setup, setting up itemization in iExpense, Setting of i-Expense P-Card functionality, mapping of credit card expense types, entering employees as suppliers in order to facilitate iExpense access, assigning signing Limits, etc
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of OM, Quoting, Advance Pricing, AR, GL, INV modules
  • Provide support/enhancements for the existing Oracle and Discoverer Reports (across OM, Quoting, Advance Pricing, AR, GL, INV) and create new ones based on business requirements.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle Applications Release 12.1.1 Upgrade from Release 11.5.10.2 Rollout for US, Canada, EMEA and Middle East OM, Quoting, Advance Pricing, EDI, AR, GL, INV, AOL, System Administrator, European Localizations

Confidential, Santa Clara, CA

Oracle Business Analyst - Quote to Cash

Responsibilities:

  • As a Quote to Cash Business Analyst Supported the financial modules: OM, Quoting, Advance Pricing, AR, GL, INV Release 12.1.3
  • Lead Conversions & Enhancements for OM, Quoting, Advance Pricing, AR, GL, INV module
  • Worked on setting up of Revenue Recognition process in AR Module
  • Worked on Latin American and European Localizations.
  • E-Business Tax - Worked on the setup of the Rates, Regimes, Rate to Regime flows, exceptions, exemptions, Tax codes, tax rules in oracle e-Business tax module
  • Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
  • Worked on the setup of Advance Collections module by setting up the Collection Engine, Collection Rules, Collectors and Dunning Plans.
  • Worked on Rosettanet PIP Documents of 3A4, 3A14, 3B2, 3B12, 3C1, 3C3, 3A13, 3B3
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Configured OM, Advance Collections, AR, INV and GL modules from scratch and simultaneously created BR100 documentation for the setups.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Completed Multi-Org configuration by creating a new Organization Structure for WVI (World Vision International) by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
  • Conducted Regression testing to examine the effects of a new Org on the previous Org.
  • Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Provided with useful training to the users in Order to Cash, OM, AR, GL, AP, CM, FA.
  • 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, Malta, NY

Quote to Cash Business Analyst

Responsibilities:

  • As a Business Analyst implemented the OM, Quoting, Advance Pricing, AR, GL, INV modules
  • Worked in the configuration of OM, WMS, INV, PO and AR modules.
  • Performed Requirement and GAP analysis.
  • Configurations and Setups for OM, Quoting, Advance Pricing, AR, GL, INV
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • E-Business Tax - Worked on the setup of the Rates, Regimes, Rate to Regime flows, exceptions, exemptions, Tax codes, tax rules in oracle e-Business tax module
  • Worked on Rosettanet PIP Documents - 3A4, 3A8, 3B11, 3B13, 3C1, 3C6, 3C5
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Involved in the Setups of Revenue Recognition including the setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up the Daily Revenue Rule that are new in R12.
  • Worked on the Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
  • Worked on the Auto Lock box process in Oracle AR module.
  • Worked on Auto Accounting in the AR module
  • Worked on the Auto Invoice Process in AR Module.
  • Worked in a team in understanding the integration of Advanced Pricing with OM process
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the 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

Confidential, LA, CA

Oracle Apps Functional consultant

Responsibilities:

  • As a Functional Consultant implemented the Order to Cash Business flows including OM, AR, AP, GL, INV and Pricing
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for AR, OM, Advance Collections, GL and AP modules
  • Worked on the setup of Revenue Recognition in AR module.
  • Setup of Accounting and Invoicing rules in AR module
  • Defined the Auto Lock Box process in AR module
  • Defined the Auto invoice process in AR module
  • Worked on the 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 with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Accounts Receivables and Account Payable Module
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Kansas City, MO

P2P Functional Consultant

Responsibilities:

  • Worked on the entire Procure to Pay business process.
  • Performed all of the setups for i-Procurement, PO, AP and GL
  • Developed several enhancements to the Business Processes on the Procure to Pay side.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
  • Implemented the e-Business Tax module including configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
  • Performed all of the setups for Sub Ledger Accounting and the Payments module.
  • I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
  • Automation of Search Receipt Automation (Lockbox) through Account Receivables module
  • Pre upgrade testing and Post upgrade production live support. Yahoo Inc successfully had 3 upgrades (Linux Operating migration, Oracle 10G database and Oracle Apps Version 11.5.9 to 11.5.10.2 upgrade).
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Cash Management and Account Payable Module
  • Functional Support for SOX and PWC Audit
  • Integration and Implementation of Foreign exposure through Fire Apps external software with Oracle GL
  • Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
  • Setup and Support of Markview170 System

Environment: Oracle Applications Release 12 and 11.5.10, AIM Methodology, MS Access, Excel, Edit plus, MS Visio 2000, Oracle 9i, SQL Loader, Sun Solaris, SQL, PL/SQL, ADI, OBIEE, Oracle Work Flow Builder, XML Publisher and TOAD.

Hire Now