SUMMARY

• Having 8+ years of strong IT experience in financial domain working as an Oracle EBS Financial Functional Consultant in multiple Implementations, Upgradations and Post Production Support of Financials Modules in Oracle E - Business Suite R12/11i & Fusion Cloud versions.
• Professional expertise in Designing, Implementation, Customization and Testing of Oracle Financials including General Ledger (GL) including AGIS, AME, iSupplier, IProcurement, Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax), Oracle Lease and Finance Management (OLFM), Purchase order(PO), System Administration (Sys Admin).
• Multiple project life cycles experience Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering, Facilitated Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, cut off, Go-live, and post-implementation support.
• Experience in working with global implementations and implemented AGIS (Advance Global Intercompany System), Involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), Designed and developed Financial Statements (FSG’s) as per requirement.
• Extension knowledge and expertise of business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R), and Sub-Ledger Accounting (SLA).
• 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.
• Worked on RICE, Workflow, SQL, PL/SQL and Customization Forms.
• Experience in using and maintaining documentation of 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 (BR100, BP 80, BR30, BR 150, MD 50, CV 40 &TE 40).
• Conducted CRP’s, provide wide range of functional training to multiple business user groups and Co-ordinate UAT.
• Create SR’s with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development.
• Having good experience in integrating with 3rd party lease applications.
• Conduct multiple meetings with business, coordinate with Offshore team and create functional Impact Analysis documentation as part of Change Management Process.
• Good Exposure to Oracle Fusion Cloud Modules.
• Excellent communication skills and leadership qualities with analytical problem-solving abilities.

TECHNICAL SKILLS

Oracle ERP: Oracle EBS Financials R12, 11i, - GL, AGIS, AP, AR, CE, FA, OLFM, EBusiness Tax, PO, AME, IExpenses, Lease Management, Sys Admin, P2P, O2C, A2R and R2R.

Other Tools: Web ADI, ADI, Toad, Data Loader, Reports10g, Forms10g, Workflow, MS Office, SQL*Loader.

Operating Systems: UNIX, Windows 7/XP/2000/98/95, OS/400.

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Senior Oracle EBS Functional Consultant

Responsibilities:

• System setup audit has been done to ensure the system setups in R12.2.4 to meet the requirements in GL, AR, FA, CM, SLA, PO, OLFM (Oracle Lease and Finance Management) & AP modules.
• Implemented functionalities like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed with Super users and Users of various Business areas.
• Interacted with end users and translated their requirements into documents that catered the logic for implementing user requirements.
• Written Payroll calculation, element skip rules, Compensation default override values.
• Implemented Multi Org - design, configuration the multi-org set up with multiple operating units.
• Configured Work structures, Payroll Costing, Payroll components like elements, balances, etc.
• Configured Benefits such as Life Events, Eligibility Profiles, Programs, Plan Types, Options, Plans, Rates, Elements, Extracts, etc. for multiple vendors.
• Implemented Accounts Receivable to process Auto Invoices from Project Billing, Receipts(Payments) in Multi-currency transactions.
• Worked on ISupplier and AME Setups.
• Worked on application integration with lease management.
• Punch out configuration, iProcurement/PO approval routing through AME Rules and workflow.
• Helped to prepare functional design Document for different functional requirements.
• Customized SLA (Subledger Accounting) functionality in R12 to provide better matching of Liability and Expense accounting transactions on Payables invoices. For AR subledger to provide better matching of Receivables and Cash Receipt accounting.
• Was responsible for Business Requirement Analysis, Solution Design & Gap Analysis.
• Built workarounds for Gaps identified.
• Prepared Flow Charts & Suggesting Customizations.
• Finalized set-up parameters based on above study.
• Prepared & tested CRP, SIT & UAT, PROD’ Test scripts to get client's approval.
• Worked on Customizing Oracle Reports to Cash Cycle touching various modules such asGL, AP, PO, CM, AR, INV, OM.
• Defined MOAC setups and assigned Ledgers, Operating Units and Legal Entities to profile Options.
• Prepared all custom components and migrated in to the respective new Operating Unit.
• Loading Budgets Journals and Balance Sheet Trial Balance through ADI.

Confidential, Barrington IL

Oracle EBS Functional Consultant

Responsibilities:

• Prepared business documents such as business validations documents, reviewed TE 40.
• Reviewing the created Test scenarios and Test Steps with the Business Team and Development Team and modifying the same if necessary based on the Review comments or additional requirements.
• Understanding the Data Integrations and Data flow from Oracle to Other Legacy Systems or vice versa and reviewing business scenarios and scripts for the same.
• Configured the setup for AGIS (Advance Global Inter-company Systems) and transit the entries at sub-ledger (AR & AP) and OLFM level.
• Working with Business Team in analyzing the data requirement and change requirement.
• Working with the Development Team in helping them to understand business change requirement.
• Conducting business validations session of converted data for UAT 1, following up with business and development team for the clean-up.
• Defect Management Raising Defects and discussing the issue with Business and Development Team and retesting the same once the defect is resolved.
• Conducting and participating in several meetings with Project Team, Development Team and Business regarding the Design Changes and performing issues for the new design.
• Designed Chart of Account (COA) to provide Flexibility for Recording and Reporting Accounting Information.
• Configured Accounting Flexfield, Account Maintenance, Calendars, Currencies, Ledger and Legal Entity Setups, Data Access Sets, Document Sequences, Mass Allocations, GL Profile options and Transactions Processing.
• Configured the FSG to Create Balance Sheet and Profit Loss/Income Statements.

Confidential, O'Fallon, MO.

Oracle EBS Functional Consultant

Responsibilities:

• Worked on Implementation of R12.1.3 for GL, AP, OLFM, FA, and P2P cycle right after CRP1 phase through to GO-LIVE and provided post production support on all financial modules.
• Designed chart of accounts to meet the client’s business requirements.
• Set up Fixed Assets including defining category, location, and asset key flex fields.
• Defined the prorate convention, prorate calendar, depreciation rate and calendar, fiscal calendar, book controls and system controls.
• Designed and configured Location and Fixed Assets Key Flex Fields, Asset Books, Asset Categories, Asset Sub-Categories, Asset Depreciation, Fiscal Calendar, Prorate Calendar, Security by Book.
• Defined Asset TAX Book Performed Quick Additions, CIP Additions, Mass Additions and Capitalized CIP Assets.
• Performed Asset Transfer, Mass retirement, Reinstate the retirement and Mass Changes in Assets.
• Worked on Construction in Process (CIP) assets, adjustments, and classification of assets.
• Grouped assets associated with a specific project, department, and location to track CIP assets in the organization.
• Worked with the client team in understanding their business process and prepared various requirement gathering and functional design documents.
• Participated in planning and set-up of accounting flex-field structure and chart of accounts.
• Developed cross-validation rules.
• Setup Oracle Payments for Check, ACH, and Credit Card Payment Methods.
• Set up the financials and payables options and created different bank accounts for Payables.
• Involved with study of existing system, preparing the Functional (MD50) with Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Involved with migration of historical data for Account Payables.
• Created newer FSG reports depending on the business requirements.
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components.
• Configuration of CRP2, CRP3, and UAT instances.
• Preparing test scripts and performing smoke testing prior to user testing.
• Keeping track of and updating issues with proposing resolution in Bugzilla issue tracker.
• Involved in month-end closings, interfaces maintenance, and change management.
• Providing post production support to the business users.

Confidential

Oracle EBS Functional Consultant

Responsibilities:

• Worked as a Financials Functional Business Analyst for implementation of R12.1.1 and was responsible for GL, OLFM, and AR, Advanced Collections from just after CRP1 Phase through to Go-Live.
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications to finalize the solution.
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirement
• Coordinated with project Manager, Business team for system updates and deadlines for the implementation.
• Set-up Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies.
• Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, and Open and Close Accounting Periods.
• Setting up Consolidation Ledgers, AGIS for intercompany Transactions
• Setup AR System option, payment term and Auto accounting.
• Create and setup customers and its profile class.
• Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting.
• Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition.
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Prepared Cut- over Plan, listing down all Pre-& Post Go- live tasks. Involved in Post-Production support.
• Created/Maintained Business process documents BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.