SUMMARY

• 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.

TECHNICAL SKILLS

• Oracle SQL
• PL/SQL
• Forms
• Reports

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 Confidential 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 Confidential 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 Confidential 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