We provide IT Staff Augmentation Services!

Senior Oracle Applications Functional Analyst Resume

Jersey City, NJ

SUMMARY

  • More than 7 years of experience in financial domain including oracle applications ERP (11i & R12).
  • Expertise in Oracle Applications in multiple implementations, Upgrade and Post Production Support of Financials Modules in both R12&11i versions of Oracle E - Business Suite.
  • Extensive knowledge in implementing and supporting finance module including General ledger (GL), Account Payables (AP), Account Receivables (AR), Sub Ledger Accounting (SLA), Cash management (CM), Fixed assets (FA), EBTAX, and Purchasing (PO).
  • Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, Re-valuation, Translation and GCS (Global Consolidation System).
  • Expert knowledge on Sub-Ledger Accounting (SLA) for managing accounts across Sub ledger accounting transactions to generate accounting entries and customization of derivation rules as per the requirements.
  • Experience in Flex fields (Key Flex fields, Descriptive Flex fields), cross validations rules, and security rules.
  • Experience with various i-modules such as i-Expenses and i-Procurement.
  • Expert in reconciling bank statements, reconciliation tolerances, posting amount differences within tolerances, changing the reconciliation status, entering reversal entries.
  • Knowledge of Tax withholdings, Withholding Taxes with account’s range and Zero Payment Invoice in AP module.
  • Expertise in Consolidation, Intercompany Journals and Mass Allocation Journals.
  • Designed and developed Financial Statements (FSG’s) as per Business Requirement.
  • Expert in Multi-Org, MRC (Multi Reporting Currency), Consolidation, Translation, Revaluation and Intercompany accounting.
  • Functional Knowledge and implementation experience in various industries like Banking, Insurance and Risk Management, Finance, Manufacturing and Distribution, etc.
  • Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
  • Involved in full cycle implementation starting from requirement gathering to Go-Live and production support for Oracle Financials modules.
  • Proficient in post implementation support and maintenance. Performed month end and period close activities for finance team after GO-Live.
  • Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, cut off, Go-live and Post-Implementation Support.
  • Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
  • Good architecture knowledge, can write complex SQL queries for debugging during support.
  • Experience in Data mapping from the external source files with Oracle EBS columns across the financial modules during interface development and conversions.
  • Experience in maintaining documentation and using the Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80,RD20, BR30, BR 100, BR 150, MD 50, CV 40 &TE 40).
  • Experienced in Conducting CRP’s, providing wide range of functional training to multiple business user groups and coordinating UAT sessions.
  • Created SR’s with Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
  • Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
  • Excellent communication skills and leadership qualities. Played vital role in coordinating multiple business meeting and following up.
  • High Analytical skills with strong problem-solving ability and excellent organization skills.
  • Ability to work in a time constrained and team-oriented environment.
  • Ready to take on challenges by exhibiting high levels of integrity, honesty, ethics, and commitment.

TECHNICAL SKILLS

Oracle application EBS (11i/R12): General Ledger (GL)Account PayablesOracle Payments ManagerAccount ReceivablesTCACash ManagementInventoryFixed AssetsOrder ManagementPurchasingSub-ledger accounting (SLA)EB-TaxiProcurementiExpense.

Oracle Business Flows: Record to ReportOrder to Cash/CompensationOrder to Drop ShipProcure to PayEmployee SupportPurchase asset to DepreciationSR to Resolution.

Oracle Application Development Tools: SQL PL/SQL

RDBMS: Oracle 11g/10g/9i/8i

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

Senior Oracle Applications Functional Analyst

Responsibilities:

  • Participated in implementation of Oracle EBS R12 for general ledger (GL), Payables (AP), Receivables (AR), Fixed assets (FA), Sub-ledger accounting (SLA) modules. Provided support post implementation of R12.
  • Implemented & supported Approvals Management Engine (AME) for payables requisition approval workflow and, hold resolution workflow.
  • Involved in setting up third party payments for suppliers in Oracle EBS R12.
  • Involved in supporting payables users regarding invoicing, payments issues related to payments process request failures, and bank reconciliation in Oracle EBS R12 on a day-to-day basis.
  • Supported Receivable users regarding billing issues related to collections and bank reconciliations in Oracle EBS R12 on a day-to-day basis.
  • Collected business requirements for setting up the fixed assets system, asset categories, depreciation methods, prorate, ceilings, locations, and retirement conventions.
  • Gathered business process requirements for setting up Corporate, Federal, state, and alternative minimum tax (AMT) books.
  • Assisted in designing and configuring Oracle Fixed assets including flex fields for asset category and location. Overlooked functional tasks for conversion of legacy asset data to oracle fixed assets.
  • Worked on creating chart of accounts, currency and calendar. Defined value sets, codes, value set values, KFF, DFF etc.
  • Defined ADI (excel) template to create mass additions.
  • Developed TE40 Test scripts for functional testing of AP, AR, GL & FA and provided guided navigations for the users.
  • Played a key role in IT Support Team for the client.
  • Resolved Reconciliation issues with Sub Ledgers to General ledger. Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client’s requirement.
  • Liaised for the roadmap to Oracle Fusion cloud transformation.
  • Provided support for the period opening/closing activities in Oracle AR and GL. Assisted issues related to reconciliation.
  • Implemented the accounting transaction business Flows through Oracle Business Flow Accelerator. Some of those business flows are:
  • Supplier’s Invoice to Payments Customer’s Invoice to Receipts Cash to Bank Reconciliation Sub Ledger Journals to Post Period End to Close Financial Reports
  • Updated SLA Rules for Tax Accounting as per client’s requirement.
  • Responsible for Change Control of MD50 and functional design documents and Cross-functional testing.
  • Defined formulas for mass allocation and recurring journal entries. Created setup of options required to perform mass allocations.
  • Supported refund requests on credit card payments for Receivables Treasury department and solved pre-payment issues related to AR invoices.
  • Supported users with month end accounts close procedure by validating GL Income Statements, Balance Sheets, and Expense Controls.
  • Provided GL consolidation and reconciliation support. Validating reports, assisted users for FP&A month-end close.
  • Worked on translation, revaluation and consolidation in GL Oracle EBS.
  • Lead Finance Report requirement by gathering and developing reports using Oracle FSG (Financial Statement Generator).
  • Supported Users in Reconciliations various sub ledger transactions with GL Balances.
  • Worked on Oracle related products involving SQL, PL/SQL, Oracle data integration, WEB ADI, OA Framework, and Oracle Workflow.
  • Involved in GL Ledger setups using ASM, LE configuration, Cross validation rules, security rules, and COA segments, Currencies, Accounting Calendar and Operating Units.
  • Performed Functional Testing of all newly developed AR and GL interfaces for Finance side. Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.
  • Updated/assigned User responsibilities in EBS by updating Responsibility definitions, functions and menus as required. Worked on several SR’s for Payables and Receivables.

Confidential, Detroit, MI

Sr. Oracle EBS Functional Consultant

Responsibilities:

  • Documented business processes for General Ledger, Purchasing, Cash Management, Fixed Assets, Oracle Projects, Account Receivables, EB-Tax, Account Payables, Sub Ledger Accounting, iSupplier and iExpense using User Productivity Kit (UPK).
  • Designed and configured EB-Tax for all new entities in P2P tax determination for various countries like USA, Canada, and Mexico.
  • Worked on designing and documenting requirements for EB-TAX integration for the Procure to Pay (P2P) stream as per client needs.
  • Streamlined procure-to-pay processes to improve working capital, and drive compliance to optimize asset usage.
  • Involved in gathering requirements for integration of a Vendor Help Desk into Oracle Application Account Payables.
  • Performed various setups including setup of key flex fields, depreciation methods and book controls of Fixed Assets module.
  • Converted all Fixed Assets data into Oracle application from legacy systems through web ADI.
  • Customized Sub Ledger Accounting (SLA) rules such as defining sources, events, journal types, etc.
  • Performed bank reconciliation statements in Cash Management.
  • Worked on setup User accounts and maintained them using Role Provision and de-provision in Oracle Identity Management portal page.
  • Worked on iExpense module, changed field names and added more fields in expenses review screen as per client requirements.
  • Worked on implementing supplier user registration for isupplier.
  • Rectified and validated bugs in Custom ER (Expected Receipt) interface by creating and publishing data from Oracle modules: Purchasing (Purchase Orders and Agreements) and Order Management (RMA, Sales orders) to 3PL systems.
  • Involved in account reconciliation process by reconciling accounts payable to general ledger, and accounts receivable to general ledger.
  • Worked with cross functional teams while testing Procure to Pay process; to understand the upstream and downstream impacts.
  • Worked on preparation of test cases, test scripts and testing of standard features and customizations in Fixed Assets, General Ledger and Cash Management modules during SIT and UAT.
  • Provided Functional support for Fixed Assets, Purchasing and Account Payables modules in stabilization and post implementation phases.

Confidential, Camp Hill, PA

Sr. Oracle EBS Functional Consultant

Responsibilities:

  • Prepared R12 GAP analysis doc for the RICE objects in the R12 upgradation projects.
  • Analyzed impact analysis of upgrade on RICE objects related to Account Receivables, Account Payables, Purchasing, WMS and Order Management modules from 11i to R12.
  • Perform fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping and related documentation (including BR100 and MD50) for Purchasing, Account Receivables, Order Management, MCSA, Inventory and Account Payables.
  • Discussed with the Client to understand their business needs.
  • Worked on Implementation and supported of AGIS module.
  • Developed reports like Sub Ledger Accounting Report (SLA) using XML Publisher.
  • worked on Multi Currency conversion setup in Purchasing and Order Management Applications.
  • Worked on AP/AR Netting, ERS Transactions Setups and related issues.
  • Designed test scripts of all sub-process identified in assessment phase.
  • Unit testing execution for each business process.
  • Analyze and test integration with 3rd Parties and legacy systems.
  • Successfully executed CRP1, CRP2, and UAT. Provided post production support for the end users after go-live.
  • Provided Training & Conducted Practice & Additional Business Requirements sessions.

Confidential, Houston, TX

Oracle Financial Functional Consultant

Responsibilities:

  • Involved in creating setups of Oracle Financials modules 11i/R12.1.1 General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, and CE for Accounts Receivable Lockbox, Inter-Agency funds transfer, cash/funds position and forecasting processes.
  • End to End Configuration of GL Setups of Legal Entity, Primary Ledger, Secondary Ledger, Operating Unit and Reporting Currency
  • Raising SR'S and worked to solve the issues; ensured that it does not block the user testing.
  • Worked on bug fixing with Oracle Support.
  • Provided support for implementation and post implementation of the Oracle EBS R12.1.1
  • Migrated AR collection functionality into Advanced Collections.
  • Used Accounting Rules to determine the revenue to be recognized (Revenue Recognition) in each accounting period.
  • Streamlined procure-to-pay processes to improve working capital, and drive compliance to optimize asset usage.
  • Documented invoices for inter-company transactions using Advances Global Intercompany System (AGIS).
  • Trained and guided users through the testing phrase.
  • Reconciled expense reports in Oracle payables.
  • Worked on Bank statement reconciliation; posted the amount difference with tolerance, posted reversal entries.
  • Defined Oracle Assets Parameters and performed Oracle Install Base Setup Tasks
  • Worked on integration of CE module with AR and AP module for reconciliation.
  • Participated in KAP sessions.

Confidential

Oracle Financial Functional Consultant

Responsibilities:

  • Designed and created new CHART OF ACCOUNTS and set of books.
  • Reviewed and approved detailed Solution Design Documents and verified that they provide the required clarity and explanation of the solutions to requirements.
  • Developed several custom reports and customized oracle reports for payables.
  • Worked with business users to gather requirements.
  • Worked on migration of historical data for Accounts Payables and Accounts Receivables.
  • Worked on customizations of Sub Ledger Accounting (SLA) rules - defining sources, events, journal types customizing SLA Rules etc.
  • Analyzed Fixed Assets system to find cost differences between General Ledger and Fixed assets system.
  • Defined banks, customers, receipt classes, collectors.
  • Setup customer profile class, profile attributes, customer relationships, statement cycles and accounting rules.
  • Defined Recurring and Allocations Formulas.
  • Defined Profile Options to specify certain implementation parameters.
  • Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets.
  • Performed System Integration testing on Fixed Assets, General Ledger, Cash Management and other financial modules.

Confidential

Accounts Executive

Responsibilities:

  • Prepared financial statements; assessed their accuracy and compliance to company standards.
  • Determined taxes applicable to the company; prepared tax returns in accordance with tax laws.
  • Mentored and led a two-member team of junior accountants.
  • Maintained books of accounts and computerized accounting system as well as documentation.
  • Employed tax benefit strategies for the company; advised employees on long-term tax saving financial models.
  • Managed accounts payable, accounts receivable, and payroll departments.
  • Prepared company's annual reports.
  • Liaised with bankers, insurers and solicitors regarding financial transactions.
  • Prepared and reviewed journal entries, General ledgers and account reconciliations in timely manner.
  • Prepared monthly bank reconciliation statements.
  • Assist with financial statement audits.
  • Monitored company's internal control system.
  • Participated in budget preparation.

Hire Now