SUMMARY:

• M.S. in Business Administration with four years of experience on Oracle Applications.
• Expert in gathering and defining business requirements, GAP analysis, Process Mapping, implementation and configuration of oracle financial modules with emphasis in GL and AP.
• Worked with oracle AIM methodology including preparing documentation of BR30, BR100, MD50, CV040, TE040.
• Interacted with project stake holders for successful design and implementation of oracle applications.
• Responsible for resolving critical Functional Issues related to financial module like (AP, GL, FA and Sys Admin. Setups in PROD Instance. E.g. Calendars, Currency Rates, Chart of Account (COA), Cross Validation Rule and Security Rule Maintenance.
• Assisted clients in implementing Sub ledger Accounting (SLA) in Release 12.
• Performed fundamental administrative tasks including defining new users, responsibilities, profiles, menus, and setup value sets in the application.
• Direct interaction with end users for requirement gathering, architecting, To - Be process mapping and Implementing solutions in Oracle Applications.
• Actively involved in learning new modules and taking initiatives proactively.
• Expert in Procure to Pay & Order to Cash life cycles.
• Excellent communication, interpersonal and analytical skills and a good team player with potential to work independently.

TECHNICAL SKILLS:

Oracle Applications: R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA,CE, e-B.Tax, iExpenses, Perfomace 11i (11.5.8, 11.5.9, 11.5.10 and 11.5.10.2)

Knowledge T: SQL or P/L SQL: complex select statements, views, stored procedures, functions, triggers, etc.

Languages and Tools: PL/SQL, SQL, Data Loader

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Financials Support Analyst

• Worked on Complex design issues of Chart of Accounts and Set of Books for various subsidiaries.
• Resolved Complex issues related with Key Flex fields and Value Sets.
• Involved in setting up security using features such as cross validation rules, security rules, and Menu Definition.
• Extensive knowledge of Release 12 features such as Ledger Set, Data Access Set and Definition Access Set.
• Involved in issue related to MRC, Translation, Revaluation, Advance journals etc
• Designed and Implemented electronic funds disbursement in close collaboration with the client banking partners.
• Have worked extensively in troubleshooting issue related to GL interface, xla tables, importing Journals from sub ledgers etc.
• Involved in issue related to payables setup like Supplier setup, Payables option, financial option, Bank and Bank Branch setup etc
• Assisting in creating many types of recurring invoices which are used for various periodic activities such as paying utilities, rent payment etc.
• Worked in iExpenses to facilitate the creation, approval and payment of the expense reports submitted by the employees of the organization.

Confidential

Oracle Financial Functional Analyst

• Configured Payables System Options, Payable and Financial options
• Defined Payment Terms, Payment Set ups and Distribution Sets
• Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents
• Setup book controls, corporate book and tax book.
• Provide custom solution and test tracking the depreciation by project through to FA and GL.
• Implementation of standard Procure to Pay (P2P) Functionality.
• Setup purchasing for standard functionalities like converting purchase requisitions into standard purchase orders and blanket releases.
• Involved in documentation of Future business (BP-800), present business requirements (RD-20), conversion (CV-40), and Function extension design document (MD-50), Test scripts (TE-40) and System Set up Document (BR-100) as per AIM Methodology.
• Training Super users & power users before start of CRP
• Conducted Training to User and super User for AP
• Conducted CRP’s and trained end users for, AP and FA
• Extensive unit and integrated testing done before CRP

Confidential

Oracle Programmer Analyst

• Part of implementation team that upgraded Oracle Financials
• Participated in overall support plans and coordination of functional / technical team (development, system test, interfaces, training) teams during enhancements.
• Coordinated with SME’s (subject matter experts) to gather and validate additional business requirements.
• Created and updated documentation as required using Oracle AIM Methodology.
• Assisted with testing scenarios and developing test scripts.
• Provided status updates and issued reports to the Project Manager on a regular basis
• Delivered end-user training.
• Performed additional functional support tasks as needed.

Confidential

Accountant

• Supported and reported prior/current period adjustments and maintained bank reconciliations.
• Lead the day-to-day accounting functions including AP, AR and GL and month-end closings and reconciliations.
• Experience managing all facets of Accounting and Finance operations, including the General Ledger, accounts receivable, accounts payable, and payroll
• Responsible for the timely and accurate preparation and distribution of monthly, quarterly & annual internal financial statements and reports to management.
• Review and analyze various accounts for accuracy including but not limited to professional fees, fixed assets, accrual and prepaid accounts, miscellaneous income & expenses, travel & entertainment, marketing expenses, bank fees, etc.
• Monitoring and Vouching Cash and bank accounts and transactions.
• Verification of Bank Reconciliation statement.
• Monitoring the day to day accounts payable and accounts receivable.
• Maintenance of accounts (manually and through tally) and Cash books.
• Ensure compliance with relevant legislation.