OBJECTIVE:

To secure a permanent/contract position as Oracle Financials Functional Consultant with a strong background in Accounting, Auditing and ERP Application Consulting.

SUMMARY:

• Over 20 years of Oracle Financials experience serving as Oracle Financials Functional Consultant. Primary modules includes General Ledger, Payables, Purchasing, Receivables, iReceivables, Order Management, Fixed Assets, Cash Management, iExpense, Advanced Collections, EB - Tax, AGIS and SLA
• Worked as Lead/Principal consultant in full life cycle implementation of Financial Modules release 10.7SC, 11.03, 11i and R12, Oracle Cloud Fusion using AIM, OBA (Oracle Business Accelerator) methodology.
• Worked on Functional Planning, System Design, Chart of Account Design, Gathering Requirements, Gap Analysis, Configurations, and Interfaces design, Conversion, Data Migration, Chart of Accounts Mapping, GL Consolidation, Intercompany, Taxation, Sub Ledger Accounting, Localizations, Calendar Change, Mass Allocations, Multi Org, Multi Currency, Grants and Fund accounting, Encumbrance Accounting, CRP, UAT and User Training.

COMPUTER SKILLS:

Applications: Oracle Financials 10.7SC, 11.03, 11i and R12

Modules: GL, AP, AR, FA, CE, iReceivables, iExpense, Advance CollectionE-Business Tax AGIS, & SLA

Environment: Windows NT, UNIX

Others: MS word, Excel, PowerPoint, Visio, Data Loader, Toad and ADI

Methodology: AIM, FFRPM (Fast Forward Rapid Implementation), R2i Methodology

PROFESSIONAL HISTORY:

Confidential, Austin, TX

Senior Financials Functional Analyst

Responsibilities:

• Act as the SME, provide guidance, to IT Support, development and integration teams for GL, AR, AP, FA, OM, CE and EB-Tax in Cloud environment
• Design, develop, unit test and deploy new business functionality
• Work with business users and IT colleagues to provide solutions to match business needs
• Manage the delivery of application features and functions workload and tasks
• Coordinate and perform in-depth tests, including end-user reviews
• Provide guidance on how solutions could help solve business problems, evolve existing business capabilities, and enable new business capabilities
• Develop and execute system testing and test plans as required as well as coordinate and conduct internal user support and training
• Act as a liaison between the business user groups and the technical systems groups
• Ensure stability and data accuracy in the Oracle Applications production instance post release in addition to meeting customer needs in line with compliance and audit policies
• Create and manage Oracle Support Service Requests as and when required

Confidential, Dallas, TX

Financials Lead

Responsibilities:

• Engaged in resolving issues and day to day challenges using Agile, Jira software.
• Engaged in the clean-up of the Customer and Suppliers using DQM of TCA model.
• Identified duplicates parties and merged them using Merge functionality.
• Experience in working on web services integrating with Oracle for Real Time data.
• Document Inbound/Outbound integrations from legacy systems into EBS R12.2.5.
• Design Interface document for Contract Cash Application from legacy system.
• Engaged in Canada Bank setup and Payments
• Provide solution for customized 1099 payments
• Configuration of Internet Expenses, Defined Expense Policies and Rules, managed approvals.
• Engaged in the training and support of end user.

Confidential

Financials Lead

Responsibilities:

• Lead a team for General Ledger, Receivables, Payables, and Fixed Assets for the implementation of Oracle Fusion Financials.
• Responsibilities include requirements gathering, design and configuration.
• General Ledger: Design Chart of Accounts, Security Rules, Cross Validation Rules, Consolidations.
• Payables: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor from legacy systems.
• Internet Expenses: Configuration of Internet Expenses, Defined Expense Policies and Rules, Credit Card Payments, Expense Report Audit, Expense Reimbursements, managed approvals.
• Receivables: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing and Revenue Recognition.
• Engaged in the configuration of Sub Ledger Accounting (SLA) for Fixed Assets and Projects.
• Fixed Assets: Configuration and Conversion
• Engaged in the workshops, CRP, SIT, UAT and training of end users

Confidential, Dallas, TX

Financials Business Analyst

Responsibilities:

• Demonstrate & influence business partners to leverage industry standard processes & out-of-the-box configuration capabilities in Oracle EBS R12 to satisfy business needs.
• Provide recommendations to address and resolve business issues for a specific business group.
• Support Finance team in closing month end, year end of the books.
• Stream line the process of Journal entry, Payable Invoices, Billing and Revenue recognition.
• Developed reports and training documents.
• Assisted in data integration from Inventory, Project Costing/Billing to General Ledger.
• Modified/corrected Manufacturing Accounting (Inventory, Costing and Billing).
• Develop FSG reports with maximum number of columns, Row Orders and Content Sets.
• Use Oracle Support to search for solutions and open service requests when needed. Coordinate functional activities with Oracle Support.

Confidential, Rockville, MD

Financials Functional Lead

Responsibilities:

• Lead a team for General Ledger, Receivables, iReceivables, Order Management, Internet Expenses, Collections and Payables for a Global implementation of R12
• Responsibilities include requirements gathering, design and configuration using BRD and BR100
• Engaged in functional design of interfaces, conversion, Chart of Accounts Mapping using CV10, MD50 and BR100
• GL Configuration: Configured 10 Ledgers with 10 Legal entities, Localizations in EMEA and LATAM, setup Cross Validation Rules, Mass Allocation, Recurring Journals, Auto Reversal, Document Sequencing, Data Security and Intercompany Transactions. Performed Consolidation including Revaluation and Translation
• Configuration of AGIS (Advanced Global Intercompany System).
• Payables configuration: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
• Internet Expenses configuration: Setup of i-Expense, Configuring the Expenses Spreadsheet, Process of Credit Cards, and Reporting.
• Receivables configuration: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition and Advance Collections iReceivables configuration: Responsible for performing the end to end testing of iReceivables integration with Receivables, Payments and other related modules; Design/created Functional Specs BR30, BR100 and TE40 for iReceivables; Configured disputes and created credit memo and customer cross payments.
• Fixed Assets Configuration: Responsibilities include requirements gathering, design and configuration. Performed Revaluations/Impairments as per IFRS requirements (IAS 36 & 16). Transfer of Assets books to new Corporate books.
• Conduct Workshops, Demo, CRP, SIT, UAT and User training

Confidential

GL Functional Lead

Responsibilities:

• Lead a team for General Ledger for a Global implementation of R12
• Responsibilities include requirements gathering, design and configuration using BRD and BR100
• Engaged in functional design of interfaces and conversion from using CV10, MD50 and BR100
• Configured 4 Ledgers with 40 Legal entities, setup Cross Validation Rules, Mass Allocation, Recurring Journals, Auto Reversal, Document Sequencing, Data Security and Intercompany Transactions
• Configure AGIS (Advance Global Intercompany System)
• Configured and performed Consolidation multi-currency setup including Revaluation and Translation
• Conduct Workshops, Demo, CRP, SIT, UAT and User training
• Responsibilities include requirements gathering, design and configuration of R12.03 Fixed Assets
• Engaged in functional design of the using BRD, BR100
• Conduct workshop, prototype to show the functionality of R12 Fixed Asset
• Conduct CRP, SIT, UAT and training of users
• Engaged in Conversion and reconciliations of 15K assets from legacy system into Oracle.
• Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification, Tax Recovery Rates, Tax Determining Factor Sets and Tax Condition Sets
• Engaged in the project of integration of Power Plan (Assets legacy system) into Oracle General Ledger.
• Prepared MD-50 functional design document.
• Completed FERC (Federal Energy Regulatory Commission) training during the assignment.

Confidential

Functional Financials Lead

Responsibilities:

• Responsible for designing chart of accounts, Multi currency and Currency translation, cross validation rules, SLA configuration for Payables, Receivables, iReceivables, consolidation and reporting using ADI, FSG and Report Manager tool.
• Engaged in designing, gathering requirements, gap analysis using AIM documentation BR30/BR100.
• Engaged in conversion/interfaces of GL data, Customers and Suppliers. Prepared functional design document MD-50 and CV-40
• Performed CRP and prepared test script for testing and design training document.
• Involved in go-live support and closing process.
• Payables configuration: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
• Internet Expenses configuration: Setup of i-Expense, Configuring the Expenses Spreadsheet, Workflow Processes, Configuring Audit, Process of Corporate Credit Cards, and Reporting.
• Receivables configuration: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition, handling of disputes and payments with iReceivables; deductions and adjustments.
• Develop Test Scripts, performed CRP testing, end user training
• Resolved open SR’s and support Post go live issues, month end closing and user training
• Engaged in the implementation of Account Receivable and Revenue Recognition
• Responsible for setup of Customers, Customer conversion, Transaction types, Receipts, Lockbox
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Engaged in the compliance with the SOP 97 (revenue recognition for software companies)
• Responsible for CRP, UAT and user training
• Implementation of TCA, assisted client in cleansing customer data, analyzed current Business Process, resolving customer duplication issues and application of discounts.
• Created Match Rules for Customer Search and for Identifying and Preventing Customers Duplications using DQM (Data Quality Management).
• Financials implementations using Oracle Business Accelerator. Involved in Designing, Planning, Data Conversion, CRP, UAT, SIT and end user training.
• Worked on the setups ofOM- Profile options, Freight and Special Charge Types, Document sequences, Shipping, Customers, Quick codes, Rules, Holds, Price Lists, Modifiers.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Defining Standard, Internal, RMA and Drop Shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Configured Revenue Recognition.
• Responsible for Receivables, iReceivables configurations, customer setup and conversion; customization for cash application, collections and rebates.
• Developed user’s security using MOAC functionality
• Configuring EB-Tax: Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification and Tax Recovery Rates
• Resolved open SR’s and post-go live issues
• Engaged in month end close process, reporting, reconciliations using Report Manager and FSG reporting tools
• Engaged in the assessment of R12 upgrade from 11i
• Reviewed business process of Grants accounting and Disbursement of Funds.
• Analyzed existing Assets systems, gathered information, and performed Gap analysis.
• Design, plan, proposed, and made recommendations based on the R12 features of Fixed Assets. Assist technical team in the process of conversion.
• Engaged in implementing Financial Accounting Hub (FAH) for a major International Bank.
• Responsibilities include designing business processes, defining user requirements, conducting fit-gap analysis, designing functional specifications for interfaces/conversions from legacy into Oracle application, CRP and end-user training.
• Engaged in setup of Fixed Assets, successfully resolved issues on Conversion of assets, Corporate and Tax Depreciation, Group Asset, Group Depreciation, Mass Addition, Tax upload and closing Corporate and Tax books. Reviewed Business process and recommended changes to resolve the issues.
• EB-Tax: Setup Tax Authority, Tax Regimes, Tax Status, Tax Jurisdiction, Tax Rules Engine, Product Classifications, Party Classification, Tax Recovery Rates, Tax Determining Factor Sets and Tax Condition Sets
• Receivables: Customer/Party relationship, Invoice and Customer conversion, customization of billing, cash application rebates and deductions.
• Lead a team to plan and design General Ledger interfaces with multiple third party partner and non-partner products and reports. Responsible for business process review, GAP analysis, and configuration of General Ledger, AGIS (Advance Global Intercompany System), Localizations of EMEA, configuration for Global Implementation using AIM methodology.
• Conducted 5 day workshop on Release 12 for a major transportation industry and addressed following areas:
• Reviewed Business process and recommended changes to resolve the issues.
• Responsible for setting up Customers, Bank, Auto Accounting, Intercompany Transactions, Multiple Currencies, Auto lockbox processing, Cash Applications, Discounts, Claims, Revenue Recognition and Collections.
• Setting up Scoring, Strategies, Dunning Plans, Delinquencies and Workflow for Promise Approval, Reconciling payments/promises and Automate communication, actions and timing for Advanced Collections.
• Engaged in configuration of Order Management including setup of Transaction Types, Applying & Releasing Holds, and Credit Checking.
• Defined Shipping Parameters and document sets for Pick Release and Ship Confirm.
• Defining Standard, Internal, RMA and Drop Shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Financials lead, responsible for full life cycle implementation, planning, system design, Gap analysis and requirement gathering.
• Involved in functional design of interface and configuration of General Ledger, designing Chart of Accounts, made recommendations on new segments for financial reporting.
• Updated Client accounting policies and procedures to support compliance with the IFRS standards, as well as ensure consistency throughout the operations.
• Involved in Intercompany transactions and reconciliation.
• Performed Consolidations, documented Functional design of conversion of GL balances, Receivables and Payables from legacy (third Party) system using AIM documents.
• Involved in data conversion from legacy system to Oracle application of customers, vendors and General Ledger balances.
• Responsible for CRP; creating/developing Test Scripts and Training Materials.
• Conducted Testing, End User training, developed month end closing process for the client and resolved post go-live issues.