SUMMARY:

• Over 6 years of Functional & Business experience in Oracle ERP in a variety of large Projects with Full Life Cycle Implementations, Up gradation and Post Production Support of Oracle Applications.
• Handling Month - end close activities and reconciliation for GL, AP, PO and FA modules.
• Resolving Finance issues that occurred during production and provide Month end support to the above financial modules along with delivering the reports of the close.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Conducted CRP1, CRP2 and tested the customized components.
• Configured the Sub Ledger Accounting (SLA) setups.
• Resolved Problem Tickets (PT) and Service Requests (SR) issued by Business Users for various Finance issues using Remedy System.
• Strong Oracle Applications Functional experience in multiple implementations, and Post Production Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Created the MD50 documents for each RICE components.

WORK EXPERIENCE:

Oracle Financial Functional Analyst

Confidential, UT

Responsibilities:

• Involved in supporting Super Users and End users in period end closing.
• R12 (12.0.6) AR, CM, FA/PA -Implementation & (12.1.3) Upgrade
• Confidential Cable, Nation's largest and fastest Internet, Cable and Voice service provider to the end consumers. It has more than 25000 centers across the country and having more than 50 custom, Client\Server and web applications running on different platform. Establish external Data Source Provider platform, gather supporting information from various third-party vendors to provide innovative solutions and alternatives to company's customers.
• Involved in Confidential 's Oracle EBS Implementations and its Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, I Expense, Project Costing, Billing and Cash Management.
• Performed meeting within Business stack holders, Developers, DBAs, Quality Assurances and End users of Business high level requirements and its updates.
• Used IR Tools and OBIEE for customized reports and Reconciliation Reports and Prepared Data sheets for Reports for updates and to present in Meetings.
• Used other major Oracle's such as IPM and Other outside applications such as KOFAX, AppLoad, Formscap for Images Management and uploading bunch of data using Excel Sheets into the Oracle Database.
• Defined, Created and Tested Flex field structure, Cross Validation rules, Accounting Calendars, Functional currencies, foreign currencies and budget for QA testing.
• Defined, Created and Tested Primary Ledger, sub ledgers and Operating Units Ledgers.
• Created Journal and its Batches (with STAT), Recurring Journals, Mass allocations, Consolidations, Conversions, Journal line Reconciliation, Generated reversal and scheduled automatic reversal journals for QA Testing.
• FSG Reports, Financial Reports, Account summary reports, Income and Expense Reports and other Oracle standard reports.
• American Commercial Lines Inc. (ACL) is a leader in the transportation and manufacturing industry. I worked with ACL as an Oracle Financial Functional Analyst from phase CRP1 through to UAT and I was responsible with AP, AR and CE.
• Assisted in implementation of Oracle Financials (AP, AR and CE) across the organization.
• Managed a team of consultants for the up gradation and configuration of AP, AR and CE modules.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup of tax rules.
• Setting up of fiscal calendar in FA that map to the new GL calendar.
• Configure new prorate conventions based on the fiscal calendars.
• Create new corp. books and tax books that are associated with new calendars and prorate conventions.
• Assign asset categories to corresponding new corp. and tax books.
• Reviewed business processes initiated setups, developed and executed test scripts.
• Setting up of PO matching options, invoice tolerance, term holds, and expense report templates.
• Setting up of banks, bank branches and bank accounts.
• Configured the financials and payables options.
• Involved in end user and user acceptance testing.
• Implementation (R12.0.6) - (GL, AP, PO, I Expense and P2P)
• Leapfrog is a leading designer, developer and marketer of innovative, technology-based al products and related proprietary content. Worked as an Oracle Financials Functional Consultant before CRP1 through user and was responsible for GL, AP, PO, I Expense and P2P.
• Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials General Ledger, Accounts Payables, Purchasing, I Expense and P2P.
• Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup and TE.040 -System Test Script).
• General Ledger, Account Payables, and Purchasing Modules setups.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Created Auto Invoicing and Auto lockbox (Source of Auto Invoice was Project Billing) processes.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Assigning Ledger to a
• Setting up Responsibility, Standard Journals, Statistical Journals, Recurring Journals, Suspense Accounts and Mass Allocations.
• Defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.