SUMMARY

• Over 10 Years of experience in IT, out of which 6 years as an Oracle Functional Consultant in E-business Suite.
• 6 years of experience in implementation, process re-engineering, extensive experience in implementation, upgrade, requirement, gap analysis, project management, System and user testing, integration and user training of Oracle Applications R12/11i on financial modules in a multi-org environment.
• Experience in GL, AP, PO, AR, FA, QP, IB, OKS, CM, OM, INV.
• Experience in Data Migration from the legacy system to oracle Application.
• Experience in estimating and project planning for the customizations and enhancements.
• Experience in integrating and uploading data from the desktop excel spreadsheets using ADI
• Prepared the following FSG reports Budget Analysis, Analysis Report, Company Income Statement, Comparative Income Statement, Cumulative Balance Sheet
• Prepared Functional Specifications, UAT, Process Design Scripts
• Customization and personalization according to business requirements.
• Worked with the user groups to identify requirements, documented and provided alternatives
• Analyzed identified gaps carried out the setup of the Accounts Payable module.
• Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document AIM .
• Worked in multi-organization implementation that involved gathering requirements, defining solutions, and recommending best business practices and completing system set-up.
• Gathered requirement, documented setups, designed process workflow, prepared functional specs, Coordinated UAT.
• Performing well under intense pressure, multitask and manage multiple projects simultaneously
• Exceptional communicator - can effectively present ideas and concepts to upper management in a clear and concise manner
• Conducted both virtual classes and instructor led training for the end users and administered application training materials using Oracle UPK.

TECHNICAL SKIILS

PROFESSIONAL EXPERIENCE

Confidential

Role: Oracle Financial Functional Lead R12 , Technical Consultant and Project Manager

Module Worked on: GL, SLA, PO, AP, AR, FA, OKS Service contracts , IB Install base ,

QP Advance Pricing , CE, AGIS, I-Expenses, AME, OM, INV, UPK

Projects: Oracle EBS 11.5.10.2 production support US , roll out in India, Mauritius, AGIS, Consolidation, I-Expenses, Enhancement of Procure to Pay cycle, Enhancement of AP and FA functionalities, Enhancing reconciliation in CE, Created custom billing programs in AR to calculate pricing for customer based on usage of items on their contracts, created custom report for invoices, created several Discoverer reports to meet end users requirement, created several other custom objects for AR and AP.

Worked heavily with Oracle Support using Metalink and recently awarded a certificate Explorer in Oracle Community forum by Oracle.

Designed Oracle Workflows for end to end custom billing in AR.

Worked on AME for PO, AP, and service contracts.

Upgraded from 11.5.10.2 to R12.1.3 Global Implementation.

Followed AIM, created various requirement, functional, technical documents and as well as conducted CRP1 and CRP1.

Extensively worked on UPK to create end user training material, test scripts and interactive videos with audio recordings.

Converted all existing Discoverer reports into XML and made it available as a request in the corresponding responsibility across all financial and supply chain modules in Oracle EBS

I was also involved in applying patches, deploying forms and reports on test environments, bouncing apache server and other miscellaneous activities of APPS DBA.

Confidential

Role: Oracle Financial consultant R12

GL, E-Business Tax, SLA, PO, AP, AR, FA,CM.

Responsibilities

• Prepared Gap analysis document based on the study and preparation of the set up documents

BR100 for Release 12.

• Documented As Is current business process BP.040 and designed TO BE process

BP080

• Develop or designed a structure.
• Define Location, Business group, accounting structure, maintaining flex field value sets, defining flex field hierarchies.
• Created legal entities using Accounting set up manager or legal entity manager in R12.
• Created operating units using accounting set up manager.
• Good working knowledge and understanding on the brand new features of R12 Managerial segment, Ledger, Sub ledger accounting .
• Extensive knowledge on the differences between oracle 11i and R12.
• Comprehensive understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.
• Very good understanding or Profile options in R12 global security profile, MO: Security Profile, GL: Ledger name etc
• Configured the set ups for PO and AP Purchasing options , Financial options , Payables options
• Good understanding on 2 way, 3 way and 4 way matching, receipt routing.
• Purchase approval document assignment, assigning document total, approval limit.
• Defaulting banking details on Invoice work bench.
• Creating PO Default invoices, debit, credit, mixed invoices and Expense reports .
• Accounting period control, Maintain withholding tax calendar, creating special calendar for payment term, Bank account set up .Maintain payment terms.
• Enter standard supplier invoices when there is no PO.
• Enter and Match supplier invoices with existing PO.
• Enter employee advance prepayment .
• Enter Petty cash, debit and credit memos.
• Releasing holds , cancelling invoice or prepayment employee advance
• Applying prepayments to invoices, un applying prepayments.
• Record standard payments, record refunds.
• Stop or voiding payments.
• Month end process Create Accounting entries, print month end reports, Transfer accounting to General Ledger.
• Reconcile payables, Close accounting periods.
• Invoice reports, Supplier reports, payment reports, posted reports.
• Hands on experience on generating FSG's, Aging reports in AR...
• Defined mass allocation, recurring journals, cross validation rules, security rules, calendar, key flex fields, descriptive flex fields, set of books, sequence in GL
• Requirements Gathering ,Conducting work sessions with client, training, conduct system

testing ,conduct Conference Room Pilot CRP and User Acceptance Testing UAT ,Preparation of deliverable documentation using Oracle AIM templates for GL like accounting setup, global consolidation system, inter company ,accounting structure, multi currency, FSG, accounting for multiple companies ,month end closing.

• Developed and reviewed functional designs MD050
• Worked with the end users and business owners to map Oracle Application BR -100 standard processes to business requirements
• Prepared test scripts and conducted unit testing, integration testing and UAT
• Conducting end user and production support staff training for the financial modules.
• Led the testing effort and coordinated changes using Mercury Interactive testing tools.
• Did configuration, testing and solution design for R12 modules.
• Involved in conversion process during parallel run and cutover.
• FSG reports for Finance Statement Generator, Company Income Statement.
• Configured all the three work benches in AR. Transaction work bench, Receipt work bench and collection work bench.
• Configured Auto receipts in AR.
• Set up Auto Accounting in AR.
• Configured recurring invoices.
• Defined Taxes.
• Assigned the sequence to payment methods.
• Invalid Transaction number handling.
• Good working knowledge and hands on experience on all the aspects AR.
• Defining all 3 flex fields in Assets.
• Tracking Assets by implementing different flex fields and making them mandatory.
• Asset Accounting.
• Asset Book regions Calendar, Accounting rules, Natural Accounts, Journal Categories.
• Category flex field, Location flex field, Asset key flex field.
• Defined Flex field Values, system controls, Fiscal years.
• Defining corporate book, Budget book, Tax Book.
• Depreciation Calendar, Prorate conventions, Same month convention, previous month, half yearly conventions and Following month conventions.
• Defined Books Control, Asset Categories.
• Reconciliation in FA, Setting up Depreciation.
• Implemented Various Asset Addition processes like Quick Addition, Detailed Addition, and Asset addition source payables.
• Preparing Mass addition, split multi unit mass addition, Merge several mass additions, Add mass addition to an existing asset.
• Posting Mass addition, Clean up Mass addition.
• Adding Construction in Process assets CIP .
• Capitalizing CIP assets, reversing capitalize asset.
• Reclassifying assets, single assets, reclassify group assets.
• Transferring assets, single asset and group of assets.
• Fully retiring an asset, Partial retirement, Reinstate an asset.
• Running depreciation, roll back depreciation..
• What if Analysis.
• Creating Assets using ADI
• Depreciation Reports.