SUMMARY:

• Eight plus years of experience in Information Technology as Senior Oracle Certified Financial Functional Consultant in Oracle applications for Americas, EMEA, APJ countries. Role included the expertise in client interaction, functional setups of Oracle Financials Applications.
• Sr.Oracle Consultant for implementing financial modules Accounts Receivable, Accounts Payable, iReceivables,iExpenses, General Ledger and Cash Management
• Expertise in Global Roll - out in Requirement gathering, GAP analysis, design and development and Implementation of various business applications and support of the Oracle Financials AP, AR, GL, CE, OM, iReceivables and iExpense.
• Expert in AS-IS Fit Gap analysis, CRP, UAT and Post-Implementation maintenance.
• Facilitated project meetings, identified issues, potential problems, and tracked action items.
• Strong Understanding of the Business processes, Procure to Pay (PP) and Order to Cash (O2C)
• Prepared and delivered Functional/ Design documents, User guides & Presentations.
• Leadership qualities, Experience in AIM documents such as MD50, RD20, BR100 and TE40.
• Managed Projects for up gradation, support. Development and customization of Release 12.1.3 and Oracle Financials 11i in 11.5.10.2, 11.5.9.
• AP/AR Netting, MRC and AGIS functionality for Global Roll - outs in EMEA.

SPECIALIZATION:

Oracle 11i - E-Business Suite- Release 12.1.3, 11.5.10.2. , 11.5.9

Oracle ERP including AP, AR, iReceivables, GL, CE, Payments and iExpense

Oracle AIM Methodology

Business Analysis

Process Re-design

SQL, SQL Loader, SQL* Plus, Toad, WebADI,DataLoader.

Oracle 9i

EXPERIENCE:

Confidential

Oracle Business Systems Analyst

Responsibilities:

• Defined Payment terms, Auto-accounting, Collectors and Balance Forward Billing, Billing Cycles.
• Defined transaction types and Sources to interface Invoices.
• Conduct CRP sessions. Successfully conduct UAT sessions.
• Working on Supply Chain Financing Initiative with integration with PrimeRevenue.
• Creation to booking, fulfillment, shipment, Auto invoice, Autoinvoice exceptions, revenue recognition and GL transfer.
• Conducted the corporate training for GL, AP, AR and CE for new and changed features in 11.5.10
• Integration of AR with Sabrix to calculate sales tax.

Confidential

Sr.Oracle Analyst

Responsibilities:

• Was involved in implementation of iReceivables with integration to Receivables.
• Configure application and Functional Specs BR30, BR100 and TE40.
• Gathered business requirement for Credit Memo Approval, iRecievables Workflow Setup.
• Updated the Receivables lookup codes based on business needs.
• Personalized the iReceivables homepage and defined bank for new payment methods.
• Granted external customers with function security for respective bill-to sites.
• Setup collectors, approval limits, discounts and service charges.
• Setup the dispute and pay invoice option.

Confidential

Application Analyst

Responsibilities:

• Worked with business leads of NL and EMEA for process design, design finalization, configuration of Oracle
• Applications, RICEW object functional specification, testing, assisting with data conversion design and testing, assisting with training, design review, status reporting, implementation and post-go-live support for OTC modules- AR, CE and BPA modules.
• Implementation of setups and configuration of Oracle Financials R12 AR, BPA, Cash Management and APRO Banking.
• Global Roll-outs for EMEA countries in AR /AP Netting for Wholesale OU.
• Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document (AIM).
• Defined BPA Item Templates and Mappings of NL and English templates based on Business requirements.
• Activated some descriptive flexfields to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP/AR use.
• Defined Determining Factor Sets, Rules and Tax regimes in E-Tax.
• Authored some AIM documents for the Accounts Payable Module including: business Requirement Mapping Document, Security profile Document, Conversion Strategy, and Setup Document.

Confidential

Sr.Oracle Analyst

Responsibilities:

• Worked on Confidential ’s Q2C- APAC and Japan roll-out/upgrade to Oracle R12.
• Resolved issues relating to Customer credit check rules and CC holds.
• Creation to booking, fulfillment, shipment, Auto invoice, Autoinvoice exceptions, revenue recognition
• Defined setup steps of the AR module. These included System Options,
• Receipts classes, Banks, Setup Customer Profile class, Remit to Address.
• Defined mappings for Auto lockbox/iLoader for Banks ACH payment gateway.
• Defined Payment terms, Autoaccounting, Collectors and Balance Forward Billing, Billing Cycles.
• Defined transaction types and Sources to interface Invoices.
• Conduct CRP sessions. Successfully conduct UAT sessions.
• Setup EBT (E-business tax for APJ and EMEA countries).Setups in Sabrix.
• Define the COA, Ledgers (Sob’s) and Journal Types & Recurring Journals.

Confidential, Long Island, NY

Sr.Oracle Analyst

Responsibilities:

• Implemented Auto Lock box Functionality in AR for Confidential.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into bank Confidential .
• Implemented Oracle tax software integration.
• Experience with the following features in Release 12
• Sub ledger Accounting
• Advance Global Intercompany
• Global Consolidation system
• E-Tax Engine
• Legal Entity Configurator
• Other AR setups included System Options, Receipts, and Bank.
• Gathering requirements for lockbox interface, designing the lockbox bank file format, setting up the functional setup for lockbox, designing the Confidential interface validations for the lockbox load.
• Identified and setup GL legal entities using Legal Entity Configurator, Jurisdictions, Legal Authorities, Sequencing, Operating units, Ledger Books, Cross Validation Rules, and Accounting Setups.
• Document business specification for customization of Florist Statements in Detail and Summary format, create FSG specific business custom reports.
• Setup late fees and interest charges new functionality in Release 12 AR and Advance Collections.
• Documented RD20, BP080, BR100, TE20, TE40 and TE50 documents for all CEMLI”s.

Confidential, New York City, NY

Finance Functional Consultant

Responsibilities:

• Sr.Consultant for 11.5.10.2 implementation of AR and GL modules within the scope of RFP (Request for proposal).
• Conducted business meetings to study the “AS-IS” and “TO-BE” process flows through Microsoft Visio.
• Analyzed Inventory of requirements and prioritize Gap/Fit matrix with oracle applications. Mapping requirements with Oracle standard features.
• Prepared RD20, MD50, TE40 and BR100 setup documents for AR and GL.
• Design Chart of the Accounts, Calendar, Currency and Set of Books.
• Design MD 50 for Inbound and Outbound Interface document for AR Invoice Billing and Customers from BOSS and MBD systems.
• Prepare Change Request (CR) for revision of project proposal.
• Defined setup steps of the AR module. These included System Options, Receipts classes, Banks, Setup Customer Profile class, Remit to Address.
• Defined mappings for Auto lockbox for Confidential ACH payment gateway.
• Defined Payment terms, Autoaccounting, Collectors and Auto Cash Rule Sets.
• Defined transaction types and Sources to interface Quarterly Invoices.
• Conduct CRP sessions. Successfully conduct UAT sessions.
• Set up Public Sector appropriations and Budgets and resolved issues/problems.
• Setup and configured web ADI to process opening GL balances after cut off period.

Confidential, Olathe, KS

Finance Functional Consultant

Environment: 11.5.9 to 11.5.10.2 (Upgrade and production support)

Responsibilities:

• Was involved in 11.5.9 to 11.5.10 upgradation. Was involved in overall coordination, interaction with Confidential ’s global group in US, UK and Taiwan team management and responsible for finance modules functionality changes.
• Functional support on Credit Card gateway, credit card encryption (VeriSign), voice authorization processing using iPayment.
• Resolved issues relating to Customer credit check rules and credit card holds. .
• Creation to booking, fulfillment, shipment, Auto invoice, Autoinvoice exceptions, revenue recognition and GL transfer.
• Conducted the corporate training for GL, AP, AR and CE for new and changed features in 11.5.10
• Integration of AR with vertex to calculate sales tax.
• Project preparation/specification on Price protection plan to dealers.
• Gathering/modification of functional spec for tracking and shipment # on Invoices/Credit Memos.
• Set up Confidential Credit Card load functionality, Audit Functionality, expense templates with perdium in iExpense.
• Defined Internal and external users.
• Setup external self-user and anonymous registration.
• Setup Euro Bank and iExpense module (perdium) for Confidential GE operating unit.
• Setup Payment Format and Distribution sets.
• Prepared end user manuals & guidelines for Monthly, Year-End finance closing activities.
• Reduced the month end closing cycle by several working days by using Oracle ADI and setting up Mass Allocations for several manual journal entries
• Setup legal entity, operating Unit, Inventory Org, Organization location, defined security rules, account combinations for Confidential operating unit.
• Involved in the Design and Structure of the Accounts and GL Code combinations for Confidential operating unit.
• Consolidation of subsidiary SOB with parent SOB with currency translation.
• Troubleshoot using Oracle Diagnostics.