SUMMARY:

• Techno - Functional Financials and Distribution Consultant with 9+ years experience on core ERP Applications.
• Experience includes execution of 3 full lifecycle Oracle Applications implementations including the exposure to e-Business Suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Over 8 years of extensive experience on Oracle Supply Chain Manufacturing Applications consulting including Quote to Cash and Procure to Pay Executed critical projects as Business Analyst, Functional roles. Extensive business area experience & have received great commendations at Client site for excellent interpersonal & Client interaction skills.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Financials (AR, e-Business Tax, AP, GL, i-Receivables, i-Expense, Sub Ledger Accounting) also worked on OM, Advance Pricing (QP), PO, and INV modules.
• Experience with Oracle SQL, PL/SQL, Forms, Reports, Workflow Builder, Interfaces (inbound and outbound)
• Extensive experience in CRM Modules of Service Contracts and Install Base.
• Extensive experience with the Order to Cash and Procure to Report business flows.
• Experience working with Sabrix Tax Engine
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle Financials Functional Consultant

Responsibilities:

• Worked on 11i and oracle R12 instance for P2P and O2C Process.
• Worked on Drop Ship where Orders will be sent to Contract Manufacturing from there it will Logistic department.
• Worked on 7 entity US, Canada, RSA, NLP(European)Germany, UK and Israel for O2C Process and 30 Entity for P2P Process for calculation for tax process Pre-Cal and Post Cal and One Source Tax Determination for calculation tax.
• Taxes will be calculated based on Tax Regime.
• Worked on Quotage for calculating quote to customer.
• Worked on Pre-Cal and Post-Cal tax calculation in Sabrix One Source
• Update the Post-Cal Package while upgrading One source cloud.
• Worked on In direct tax Determination where tax calculated by Jurisdiction and Authorities. worked on customization process different channels like B2B, PTO, CTO orders, BPA,CPA,PO.
• Worked on extracted data with SQL in OM side and AR Side.
• Configured the Accounts Payable, Accounts Receivables, Sub Ledger Accounting, HRMS, AME, General Ledger, Fixed Assets, i-Expense modules.
• Performed all the setups for AR, Revenue Recognition, Sub Ledger Accounting, i-Expense modules.
• Worked on the Auto Invoice configurations for 5 Legacy sources
• Worked on the Auto Lock Box process setups for Bank Of America and Bank of New York
• Worked on the Revenue Recognition setups in oracle AR module
• Worked on the Collection process in Oracle AR module
• Worked on the setups of the Refund Process in AR Module
• Worked on the setups of the AR/AP Netting process in AR Module
• Worked on the setups of e-Business Tax for AR Module
• Configured all the Banks for the Receivables transactions
• Worked on the Functional mapping of the Customer Conversion process in AR Module
• Created New Item Creation tool for automated item creation and updates.
• Worked on the CRM Modules of Service Contracts, Depot Repair and Install Base.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Created Views and Reports using Oracle Discoverer Tools.
• Created interface for custom account creation process with DocuSign.
• Daily support work for Oracle issues in Purchasing, AP, Inventory.

Confidential, Louisville, KY

Oracle Financial Functional Consultant

Responsibilities:

• Extensive experience and exposure with complete Order to Cash Cycle with core focus on Credit Card and AR Payments.
• Oracle AR payment integration with Cyber source and FDMS (First Data Merchant Services), Client line systems for credit card processing.
• Worked on Oracle 12.2.6, Oracle 12.2.5 and oracle 12.2.4 versions
• Coordinated with Oracle for resolving issues like Receipts with incorrect and corrupted status, Submit offline Transaction Program Errors
• Coordinated with Cyber source for settlement issues and for payment resolution.
• Developed Report to extract the data from Client line report for clearing the receipts in Cash Management.
• Worked on Production support: Trouble shooting and Root cause analysis.
• Worked with Sabrix solution for no manual tax decisions during transaction processing.
• Involved in Pay Pal Integration Payment System tool with Oracle EBS.
• Worked on Cyber source integration with EBS
• Implemented Credit card systems and Bank Systems
• Deep understanding of AR reversal transactions like Charge back, Credit Memo, Debit Memo etc.
• Worked on Revenue Recognition side Bill in Advance, Bill in Arrears.
• Worked on the Reversal process, Refund Process and Chargeback in AR
• Coordinated with offshore team for Enhancements and Production Support issues.
• Gathering Requirement from Business and Transition to offshore team.
• Worked on SQL Database TOAD, SQL Developer, Data Loader, FND Loader.
• Worked on the forms and reports changes
• Worked on the XML Publisher report development
• Worked on Discoverer report development
• Worked on Prepayment types, payments terms like Net30, Net40 etc.
• Worked on OM end to end flow and AR complete process.
• Working knowledge on MD20, MD60, BR100, BP80, BR30/80(Unit testing/ASIS and TOBE process)

Confidential, Bothell, WA

Oracle Techno Functional Consultant

Responsibilities:

• Configured the Accounts Payable, Accounts Receivables, Sub Ledger Accounting, HRMS, AME, General Ledger, Fixed Assets, i-Expense modules.
• Performed all the setups for AR, Revenue Recognition, Sub Ledger Accounting, i-Expense modules.
• Worked on the Auto Invoice configurations for 5 Legacy sources
• Worked on the Auto Lock Box process setups for Bank Of America and Bank of New York
• Worked on the Revenue Recognition setups in oracle AR module
• Worked on the Collection process in Oracle AR module
• Worked on the setups of the Refund Process in AR Module
• Worked on the setups of the AR/AP Netting process in AR Module
• Worked on the setups of e-Business Tax for AR Module
• Configured all the Banks for the Receivables transactions
• Worked on the Functional mapping of the Customer Conversion process in AR Module
• Created New Item Creation tool for automated item creation and updates.
• Worked on Credit Card Integration using Payment gateway Payment Tech for Order Management and Accounts Receivables
• Worked on the Credit Card Payment Gateway to integrate with a custom I-Store process.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Worked on SQL Database TOAD, SQL Developer, Data Loader, FND Loader.
• Worked on the forms and reports changes
• Worked on the XML Publisher report development
• Worked on Discoverer report development
• Created Views and Reports using Oracle Discoverer Tools.
• Created interface for custom account creation process with DocuSign.
• Daily support work for Oracle issues in Purchasing, AP, Inventory.

Confidential, Billerica, MA

Techno-Functional Consultant

Responsibilities:

• Worked on the AR, AP, GL, Sub Ledger Accounting and e-Business Tax modules
• Worked for Oracle R12 in end-to-end implementation and integrated this with oracle e-Business Tax
• Lead software team to develop customizations for Taxware Enterprise applications.
• Worked on the setups and configurations of Auto Lock Box process in AR module for Bank of America Bank
• Worked on the Revenue Recognition process in Oracle AR module
• Worked on the Auto Invoice Process in AR Module
• Worked on setting up the Receivables and Payables Banks in Oracle Cash Management
• Worked on the setup of the Refund Functionality in AR module
• Defined the setups for AR/AP netting in Oracle AR
• Worked on the setups of Ledgers, Ledger Sets, Data Access Sets in Oracle GL
• Configured the Key Flex Field, Calendar and setup the currencies in Oracle GL
• Worked on the setups of Cross Validation rules and Security rules in Oracle GL
• Worked on Translation and Revaluation in Oracle GL
• Worked on the Mass Allocation process in Oracle GL
• Worked on the Consolidation process in Oracle GL
• Worked on the setups of Sub Ledger Accounting - Setting up the Events, Custom sources, Customizing the SLA Rules, SLA Options, Event Classes etc.
• Designed and produced reports in Business Objects for monthly tax reporting.
• Implemented “Single European Payments Area” enhancements in Oracle Accounts Payable and HRMS to allow Oracle applications to produce Payment XML messages compliant to European Union legislation.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.

Confidential, Los Angeles, CA

Oracle Finance Techno-Functional Consultant

Responsibilities:

• Worked on the setups and configurations of AR, AP, GL, SLA and e-Business Tax module.
• Worked on setting up the account derivation rules, events, custom sources in oracle Sub Ledger accounting.
• Developed several MD050, Functional Specification Documents (FSD) and Technical Specification Documents (TSD)
• Worked on the setups of Oracle e-Business Tax modules - setting up tax for CST, Sales Tax, VAT and Use Tax
• Defined the Rates, Regimes, Rate to Regime Flow, Tax Rules, Tax Sets, Tax Rates and Tax Codes on Oracle e-Business Tax.
• Worked on the AR Module to setup the Auto Invoice Process
• Worked on the AR Module to setup the Auto Lock Box process
• Worked on the Revenue Recognition process in AR module to set up rule for both deferred revenue and revenue for service items.
• Worked on the Translation and Revaluation process in Oracle GL
• Worked on the Setting up of the Ledgers and Ledger Sets in Oracle GL
• Worked on the setup of the Accounting Key Flex Field, Calendar, Currencies in Oracle GL
• Defined the Auto Allocation process in Oracle GL
• Worked on setting up the Mass Allocation Process in Oracle GL
• Worked on the setup of Cross Validation Rules and Security rules in Oracle GL

Confidential, Miami, FL

Oracle Finance Techno-Functional Consultant

Responsibilities:

• Interaction with business users as a part of As - Is Study for client’s legacy application D3 Pick for AR, AP, GL, Sub Ledger Accounting, e-Business Tax modules.
• Worked on the configurations of the Sub Ledger Accounting and e-Business Tax Modules.
• Worked on the Revenue Recognition process in Oracle AR including setting up the deferred revenue rules.
• Performed all the setups for GL modules - Ledger, COA, Calendar, Cross Validation Rules, Security Rules, Segment Qualification, Translation, Revaluation, Mass Allocation, etc.
• Setup Auto Invoice, Auto Lock Box, Auto Accounting, Accounting and Invoicing rules, Collection Process, Tax, etc. in Oracle AR module.
• Business Requirement, Scope Management Documents Preparation
• To Be High Level & Detail Documents Preparation
• User Training as a part of CRP1, CRP2, CRP3
• Data Migration requirement gathering for (Invoices, Receipts, Payments and Balances)
• Data Migration functional specification documents creation
• Design Creation & Validations
• Issues Tracking & Customer Sign off

Confidential

Oracle Finance Techno-Functional Consultant

Responsibilities:

• Worked as a functional Consultant to implement Oracle Application 11.5.10.2 involving PO, i-Expense, i-Procurement, AP, AR, GL Modules
• Meet with customers to understand their system and service requirements and then Writing Functional Test Scripts for the end to end testing, coordinating with the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, i-Procurement, AR, GL