SUMMARY

• Extensive 10+ Year experience as Oracle EBS/Fusion Functional Consultant in full life cycle implementation of Oracle 11i/R12 applications, business process analysis, evaluation and integration of internal systems, postproduction support and training to the users.
• Performing functional work within the Financial, Manufacturing, and Self - Service modules of Oracle Applications (Oracle Financials/Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP).
• 2 Full Life Cycle Implementation of Release 12 Financials including General Ledger (GL), Receivables (AR), Payables (AP), Purchase Order (PO), iProcurement and Cash Management (CE), Fixed Assets, iExpense and iSupplier, EB-Tax.
• 2 full life cycle implementation of Oracle Fusion Financials including General Ledger, Accounts Receivable, and Accounts Payable including hands on Configuration of these applications.
• Good Command Over Procure to pay (P2P) and Order to Cash (O2C) lifecycle.
• Providing application requirements gathering, designing, development, functional documentation, and debugging.
• Performing business process mapping, Gap analysis and user training.
• Knowledge of financial accounting and financial business processes, not limited to, but including: basic financial accounting process through period closing; revenue and Expense cash/accrual concepts; adjustments and financial statements.
• Extensive working knowledge on Sub Ledger Accounting (SLA), for managing accounting across Sub ledger transactions to generate accounting entries.
• Proven expertise in implementing and roll out of GL, AP, AR, PO with concepts of Flex fields, Chart of Accounts(COA),FSG, Multiple Reporting Currencies(MRC), Revaluation and Translation.
• Solid understanding of integration of Oracle Applications modules, Multi Org, FSG, Budgets and Flex fields.
• Special expertise in integration of self-service or Internet extensions (Internet Expenses, iSupplier and iProcurement) and the impact that changes in one area have on the rest of the system
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Extensive knowledge in using Oracle AIM of project implementation methodologies.

TECHNICAL SKILLS

Oracle Modules: Oracle Application Release 11i, 12 (R12),Fusion(GL, AP, FA, CM, PO, AR, iExpense, iProcurement, iSupplier, Advanced Collections, OM, EB-Tax).

Language: C, SQL, PL/SQL

Front End Tools: Discoverer

Relational Database: Oracle 8i/9/10/11g, My SQL, SQL server

Operating System: Unix/Windows

Other Tools: Toad, SQL Developer

Documentation tools: MS Office

PROFESSIONAL EXPERIENCE

Confidential, East Greenville, PA

Oracle Applications Functional Lead

Environment: Functional Analyst (Fusion) Confidential Inc is currently using JDE Edwards for their enterprise resource planning, Major Emphasis in this project is designing and implementing all the desired functionality in Oracle Fusion as per business requirements

Responsibilities:

• Designed Conversion Strategy from JDE to Oracle Fusion
• Conducted workshops with controllers and business users for new COA Design
• Handling of Functional and Technical Support issues across financial modules (AR, Advance Collections, AP, GL, Purchasing, FA, Trade Management and ‘I’ modules) for the business units that are already live on oracle.
• Developer FSG reports to cater income statements, Balances sheets and helped users in reconciling historical conversion data.
• Trained users on new oracle applications and prepared how to guides and training documents for day to day user tasks
• Actively involved in customer data cleanup and master data management.
• Managing a team for functional implementation of Oracle Financials (GL, AP, CM & FA modules) with Europe Localization across the organization.
• Setup and maintain the Tax, Codes, precedence and Thresholds in Localization.
• Segregation of transactions into a Separate legal entity, operating unit and inventory organization.
• Increased customer/end-user satisfaction by developing programs which helped in automation of Business processes.
• Provided End User trainings and transition on newly implemented business processes
• Also provided assistance in helping user to understand standard ERP business definitions.

Confidential, Boca Raton, FL

Oracle Applications Functional Lead

Environment: Functional Analyst (R12.1.3) Tyco is currently using oracle R12 for their P2P Cycle and the scope of my work here is to design business process for O2C modules in Oracle

Responsibilities:

• Study the Current State Functionality for AP, AR, FA and GL Modules.
• Present the Changed Architecture and new Features that R12 offers.
• Conduct discussion on Conversion Strategies for O2C Modules
• Preparation of Functional design documents for new Customizations.
• Prepare the Future State Design Document across Financial Module
• Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation (including BRD and BR100s) for financial modules AR and AP.

Confidential, Sterling, VA

Oracle Applications Functional Lead

Environment: Functional Analyst (Fusion) NRUCFC is currently using oracle R12, Major Emphasis in this project is upgrading system to oracle Fusion

Responsibilities:

• Defined Functional requirements and responsible for implementation of interface between Oracle General Ledger and Blackline (A third party tool used for account reconciliation).
• Designed and gathered functional requirements for custom Positive pay file between oracle EBS and PNC Bank.
• Worked on integrating Bolt on apps like MORE4APPS for loading Invoices, Suppliers, and Banks.
• Carrying out requirement gathering, requirement analysis, high level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing.
• Configuration and set up all aspects of the payment process including vendors, internal and external banks, branches, bank accounts, use of Positive pay and remittance advice as part of the payment process.
• Worked on Oracle e-Commerce Gateway to build inbound/outbound interfaces between PNC Bank and CFC oracle EBS
• Gathered functional requirements for developing a custom interface between PNC Bank and CFC for development of custom transmission of electronic payment files
• Designed EDI process for electronic payments of CFC through PNC Bank.
• Performed analysis and mapping between third party systems and oracle to import invoices and resolved several open issues.
• Provided support to users and assist with troubleshooting issues and provide training
• Re-engineered complex RICE elements b/w oracle ERP and client’s Legacy system to ensure smooth business process.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
• Assisted the client with the functional aspects in AR, AP, FA and GL from end to end process cycle, month end close and reconciliation activities.
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups and MOAC security
• Defined Segment security for accounts and User access controls over segments and oracle responsibilities
• Involved in designing, setup and configuration of Organization structure with chart of accounts, calendar and currency, SLA
• Created MRC (Multi Currencies) having Multi Organization, Running FSG Reports and Sub-Ledger Level reporting
• Customizing FSG Financial Reports as per client’s requirements and Creating and Setup with SLA and Reporting and prepared financial reconciliation reports
• Designed and created reports for client using the Financial Statement Generator (FSG).
• Generation and analysis of Consolidation reports like Consolidation Exception reports, Journals report, Consolidation rules report, Summary Trial balance reports, etc.
• Involved in setting up the cross validation and security rules.
• Support Business Users in Month End Close Process
• Resolve the Reconciliation issues with Sub ledgers to GL
• Actively involved in the conversion activities of ERP data to Oracle Cloud.
• Defined the conversion process for Suppliers/employee and invoice Data.
• Streamlined the process for consolidation and elimination, Client was manually consolidating their elimination entries and they are not booking elimination entries in oracle EBS.
• Designed and implemented project plan for creating elimination entries in oracle EBS and the conversion process of these entries into oracle cloud.
• Assisted in the conversion of historical data and inflight invoices and purchase orders.
• Functional consultant for Fixed Assets, Payables, ADI and Purchasing
• Prepared setup and test documents
• Performed a comprehensive unit and system integration testing
• Assisted with the design and configuration of Oracle Fixed Assets including flex fields for asset category and location. Oversaw functional tasks for conversion of legacy asset data to Oracle Fixed Assets.
• Defined Key Flex Field Structures: Key, Category, and Location
• Configured Asset categories, calendar periods, System Controls, Book Controls (corporate books), Prorate Convention and Fiscal years and calendar
• Defined ADI (excel) template to create mass additions.
• Reengineered the process of fixed assets for the client.
• Assisted client in creating 2000+ assets which were bundled as 2 assets.
• Designed and implemented a project plan for unbundling the bulk assets setup in the system

Confidential, Philadelphia, PA

Oracle Applications Functional Lead

Responsibilities:

• This project is an implementation of oracle R12 for finance modules.
• Worked as functional Analyst for oracle EBS Procure to Pay (P2P) modules during two-year implementation
• Conduct workshops to validate commodity mapping that would in turn be used by business users/partners and/or by CIGNA operation purposes.
• Worked on Production support and helped in resolving many critical issues.
• Closely interacted and assisted with users during UAT sessions in executing process documents.
• Trained users with all the new features of R12.
• Created MD-50’s for several requirements ranging from customizations, and several inbound/outbound interfaces with third party/legacy systems.
• Business Requirements Mapping for AP, AR, GL, E-Biz Tax and Cash Management modules.
• Participated in planning and set-up of accounting Flex field structure and chart of accounts.
• Defined and Created and Tested Primary Ledger, sub ledgers and Operating Units for 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
• (BR.100); establishing the set-up of the Oracle General Ledger, Oracle Payable, Oracle Fixed Asset and Cash Management with India Localization.
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables and for implementation of GL
• Defined Period Types, Accounting Calendar, Special Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Particular interest in this project is designing Custom Invoice approval workflow for AP invoices.
• Designed in Custom Invoice workflow for Non-PO invoices and invoice batches.
• Gathered business requirements for many Interfaces b/w AP and Third-party systems.
• Lead CRP sessions during implementation, Design and Testing.
• During the course of project several MD-50’s is delivered for different RICE elements.
• Assisted team in developing Process Documents and Test Scripts.
• Involved in requirement gathering during to kick off workshops and performed End-End configuration of R12 AP system options, financial options, Banks, Multi org setup, Withholding taxes etc.
• Re-engineered the AMEX Credit Card Interface and interfaces between AP and legacy treasury system.
• Designed and coordinated with business and development team in successful implementation of conversion process of open invoices/Vendors/Banks from 11i to R12.
• Re-engineered complex RICE elements b/w oracle ERP and client’s Legacy system to ensure smooth transition from 11i to R12.
• Major forms personalization and OAF personalization are delivered as per business requirements.
• Implemented parent child roll ups and updated Mass Allocation Setups.

Confidential, St.Paul, MN

Oracle Functional Consultant Lead

Environment: Functional Upgrade Analyst (R11.5.9 to R12.1.3) The Department of Natural Resources is currently on version 11.5.9 and they are upgrading their oracle system to R12.1.3 with modules AR, GL, Advanced Collections, Eb-tax, CE

Responsibilities:

• Functional Lead for oracle EBS Procure to Pay (P2P) modules
• Lead CRP sessions in GL, Receivables, Collections and E-Business tax applications
• Resolving Interfacing issues of WIRES with SWIFT People soft system on day to day basis.
• Multi Org and COA structure development, Calendars, DFF, Data Access set, Security rules, Cross Validation rules, Consolidation and Elimination setups, Mass Allocation functionality to distribute cost across different cost centers, Period end processing.
• Designing the Functional Document MD-50 for the landed Costing Custom Module and interface with Inventory, Purchase, Order Management, Account Payable and Landed Costing Report as per AIM methodology.
• Involved in the entire Project management Activity right from the Project planning to Project closure, Project-Inventory-Purchase Integration and as well Module Set up for purchasing, Inventory and Order Management.
• Design and development of Test Cases for Landed Costing and participated in Test cycle.
• Handled Leading Issues in the COA Flex Field Values issues to interface it with PeopleSoft SWIFT Implementation at state level.
• Completed full Setups in Oracle GL, AR, and E-Business Tax.
• Test Scripts and Training of Receivables Staff.
• Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Setting up UWQ in Advanced Collections to improve the collection process to identify delinquent invoices and using dunning Plans to execute different Work items.
• Used seeded Scoring components, Custom Scoring Engines, Customer handling, configuring tasks & work items, Handling of disputes, Promise-to-Pay, Strategies, Aging Buckets
• Worked on Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Implemented New AR 12.1 functionality of Late Charges, Bank Setups, and Tax Calculation functionality in AR.
• Implemented Property Management module with integration modules AP and AR
• Creating Test Scripts TE040 for General Ledger, AR, Collections, Eb-Tax.
• Resolved any month end related issues involving and data fixes or configuration changes.
• Participated in planning and set-up of accounting Flex field structure and chart of accounts.
• Defined and Created and Tested Primary Ledger, sub ledgers and Operating Units for 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
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables and for implementation of GL

Confidential, Boca Raton, FL

Oracle Financials Functional Consultant/Business Analyst

Environment: Business Analyst (R11.5.10.2) ADT SECURITY SERVICES, INC was split into two separate companies ADT LLC and Tyco IS. The EBS Suite was cloned to create two separate environments. Major Emphasis in this project is based on this Clone of EBS application for two different Companies

Responsibilities:

• Responsible for the requirement gathering of deployment activity and data cleansing requirement gathering as a Functional Analyst for the modules AP, GL, FA, PO, iProcurement, iExpense.
• Major interest in this project is the company split, provided functional review & impact analysis on proposed changes with the existing functionality and prepared MD-50 for the proposed modifications related to this company split scenario.
• Carrying out requirement gathering, requirement analysis, prominent level and granular level mapping, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP’s related to the split scenario and post production data cleansing.
• Particular interest in this project is on MARK VIEW, an imaging tool which has been tightly integrated with Accounts Payable which makes the invoice entry process more automated.
• Extensively worked on the Upgrade from Mark view5.0 to Mark view 7.0
• Gathered business requirements and successfully implemented the AP Check Printing Outsourcing to Bank of America to change the existing payment business process.
• Extensively worked with ACOM Check Printing Process.
• Successfully Re-engineered the AMEX Credit Card Interface and P-Card Interfaces with I-expense and Accounts Payable.
• Successfully handled all the in-flight transactions when we split into two companies.
• Successfully Implemented phantom pay process during the EBS Split to accommodate the resolution of duplication of invoices respectively in the both the companies which got split.
• Coordinated with legacy system to test different interfaces and data flow related to projects and customers.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Created accounting flex field segment values, creating new / updating the existing cross validation rules and security rule
• Customized the ADI template to be Compatible with new Environment to upload Journal Entries.
• Implemented parent child roll ups and updated Mass Allocation Setups.
• Extensively with data loader Classic and pro for enabling and disabling GL code combinations, and inactivating the credit card holders in I expense.
• Assistedbusiness team to Zero out the balance sheet and P&L accountsfor new company.
• Setup the purchasing hierarchies for all the units.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Involved in the analysis and design phases of an I Procurement Initiative
• Responsible for the Inventory integration with Purchase and General Ledger Modules was extensively tested, verified.
• Worked as a AR Module Expert Resource at Client site to Review and Define Functional Setups, Development and Enhancements various customizations of Oracle Receivables Module.
• Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Setting up UWQ in Advanced Collections to improve the collection process to identify delinquent invoices and using dunning Plans to execute different Work items.
• Used seeded Scoring components, Custom Scoring Engines, Customer handling, configuring tasks & work items, Handling of disputes, Promise-to-Pay, Strategies, Aging Buckets
• Worked on Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Implemented New AR 12.1 functionality of Late Charges, Bank Setups, and Tax Calculation functionality in AR.
• Implemented Property Management module with integration modules AP and AR
• Creating Test Scripts TE040 for General Ledger, AR, Collections, Eb-Tax.
• Resolved any month end related issues involving and data fixes or configuration changes.