SUMMARY

• Highly experienced in Financials domain with 10 Years as Oracle EBS and Cloud functional consultant with extensive experience in full life cycle implementations, Support, upgrades, and extensions of Oracle EBS 11i/R12 and Oracle Cloud ERP R12/R13 applications.
• Extensively worked on business process analysis, fit gap analysis, evaluation and integration of internal systems, configuration, testing, and training &on boarding users, production planning and support.
• Multiple project life cycles experience with Business Analysis, Requirements Gathering including facilitate 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 creating users, defining roles & responsibilities, value sets, Key Flex fields.
• Experience in Multi-Org and Multi-Currency, Re-valuation, Translations per Business Requirements.
• Maintained configuration documents and compared against Business Requirements and made recommendations as necessary.
• Experienced team player with good communication, interpersonal, analytical and problem-solving skills to take over any phase of the project.
• Expertise in Oracle Applications performing multiple implementations, Upgrade and Postproduction Support of Financials Modules in both R12&11i versions of Oracle E-Business Suite.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, cut off, Go-live and Post-Implementation Support.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), Sub Ledger Accounting (SLA(FAH)) E-Business Tax (E-B Tax), Purchasing (PO), Cost Management and Sys Admin.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
• Experience in implementing 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 Business Requirement.
• 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 end-to-end Oracle Fusion EPM implementation Project mainly focusing on EPBCS, ARCS, FCCS, OACS.
• Experience in the Oracle File Based Data Import (FBDi) and Desktop Integration (ADFDi) feature to load the data.
• Experience in maintaining documentation and using the 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 (BP 80, RD20, BR30, BR 100, BR 150, MD 50, CV 40 &TE 40)
• Expert in creating SRs with Oracle Technical Support, coordinating, and following on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Conducted CRP’s and provided wide range of functional training to multiple business user groups and co-ordinate UAT sessions.
• Excellent communication skills and leadership qualities with analytical problem-solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

TECHNICAL SKILLS

Oracle ERP: Oracle Fusion Cloud R12/ R13, Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, OM, I-Receivables, I-Expense, Sys Admin, SLA, Adv Pricing, P2P and O2C.

Other Tools: Web ADI, ADI, Toad, Data Loader, Hyperion, Discoverer, Hyperion, OBIE, SQL*Loader, SQL*Plus and MS Office.

PROFESSIONAL EXPERIENCE

Confidential, GA

Oracle EBS Finance Functional SME

Environment: Oracle EBS R12

Responsibilities:

• Identified standard system functionality, analyzed GAP document, and designed solutions for GL, AP, AR, and CM Business requirement.
• Assisted the business in reviewing the business process in relation to system functionality conducting financial modules business architecture workshops and solution designed and developed the project to enhance the utilization and performance of the system. Enhancing and delivered value of the system to the business.
• Gathered requirement for new enhancements communicated and guided technical team for development.
• Created test documents, performed unit, End to End User Acceptance Tests for financial modules.
• Provided support to fix day to day EBS issues and oracle to EBS integration issue
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Gathered business requirements for many Interfaces between AR, AP, and Third-party systems.
• Lead CRP sessions during implementation, Design and Testing.
• Assisted team in developing Process Documents and Test Scripts.
• Extensively worked on various product specific bugs in Oracle applications, during the various rollouts by extensively testing the core functionality and work in collaboration with Oracle support for issue resolution to reduce the overall impact on the implementation deadlines.
• Involve in the various Testing Phases including and not limited to Unit Testing, Functional Testing, System Integration Testing of various business processes in Oracle financials.
• Closely interacted and assisted with users during UAT sessions in executing process documents.
• Worked on problem fixing with third party integrations when the data not flown to EBS as expected.
• Solid understanding of Oracle table structure able to write sql/plsql statements.
• Verified AP trial balance and suggested possible adjustments related to Suppliers.
• Migrated new customers and invoices when new acquisitions take place.
• Loaded open balances and master data for newly acquired companies.
• Worked on Sub Ledger Accounting and Payments. Involved in solving various functional issues related to GL.

Environment: Oracle EBS R12 (GL, AP, AR, SLA, FAH, CM, FA, INV, PO, Service Contracts, Install Base) SQL, TOAD

Confidential, TX

Oracle EBS Functional Analyst

Environment: Oracle Fusion Cloud R13

Responsibilities:

• Supervised the process and functional design activities.
• Interacted with Business stakeholders to get full understanding of business processes, design and implement Oracle Cloud Financial Applications including GL, Payables and Receivables.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Responsible for utilizing a formalized project management lifecycle-Interacting with business users, involved in activities like requirement gathering, identifying functional and technical gaps, application design, functional specifications, scheduling, documentations, test script generation, end users and production deployment.
• Lead all aspects of the design, development and deployment of the Oracle cloud and related components. Designed custom solutions for client specific. Responsible for setting the timelines, assigning project resources, and determining and managing the scope of the project.
• Worked with the security to implement required Job roles through the Oracle security Console.
• Created implementation project by adding necessary financial offerings and options and perform configurations based on the business requirements.
• Design complete end to end test cycles in Oracle Fusion Application Implementation Project mainly focusing on General Ledger (GL), Account Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), Cash Management (CM).
• Supplier Configuration, Payable and Financial Options, Disbursements, Payment System Connectivity, Payments Security, Subledger Accounting Rules, Banking Configuration etc.
• Extensively worked on various product specific bugs in Oracle cloud ERP applications, during the various rollouts by extensively testing the core functionality and work in collaboration with Oracle support for issue resolution to reduce the overall impact on the implementation deadlines.
• Involve in the various Testing Phases including and not limited to Unit Testing, Functional Testing, System Integration Testing of various business processes in Oracle Fusion Cloud financials.
• Worked with the Oracle File Based Data Import (FBDi) and Desktop Integration (ADFDi) feature to load the data.
• Worked on Concur Expense transactions Integration.
• Experienced on OTBI reports along with data mapping and Data migration.
• Prepared the training material to train the trainers and end users and conducted classroom/web sessions to train them.

Environment: Oracle Cloud R13 (Securities, AP, AR, GL, FA, Tax, PO, INV, BI, OTBI) Oracle EBS R12 (GL, AP, AR, PO, SLA, FAH, CM, FA, INV, PO) SQL, TOAD

Confidential, KY

Oracle Cloud Senior Business Analyst

Environment: Oracle Fusion Cloud R13

Responsibilities:

• Interacted with Business stakeholders to get full understanding of business processes, design and implement Oracle Cloud Financial Applications including GL, Payables and EPM.
• Assisted the business in reviewing the business process in relation to system functionality conducting financial modules business architecture workshops and solution designed and developed the project to enhance the utilization and performance of the system. Enhancing and delivered value of the system to the business.
• Worked on Cash Management module setup configuration which consists of Manage Bank, Branch, and Account.
• Uploading of COA values such as business unit, cost center, Natural accounts & other segments via Rapid implementation methodology.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Verified Financial module setup configuration based on existing documentation with system configuration for AP, AR module
• Developed BI and OTBI reports along with data mapping and Data migration
• Responsible for utilizing a formalized project management lifecycle-Interacting with business users, involved in activities like requirement gathering, identifying functional, application design, functional specifications, scheduling, documentations, test script generation, end users and production deployment.
• Chart of Accounts, Calendars, Ledgers, Entities, Journal Sources, Journal Approvals, CVRs, Security Rules, Auto Post Criteria Set, etc.
• Defined Tax Rates and Rules for each state and maintained Tax set up.
• System Options, Transaction Types, Sources, Receipt Classes and methods, Auto Accounting Rules, Auto Cash Rules, Remit -to Addresses, Approval Limits, Statement Cycles, Auto Match Rule Set, Receivables Specialist Assignment Rules etc.
• Worked with the security to implement required Job roles through the Oracle security Console.
• Prepared the training material to train the trainers and end users and conducted classroom/web sessions to train them.

Environment: Cloud R13 (Securities, AP, AR, GL, FA, Tax, PO, OM, INV, BI, OTBI) and R12 (GL, AP, PO, SLA, CM, FA, INV) SQL, TOAD.

Confidential, Raleigh, NC

Finance Lead Functional Consultant

Environment: EBS R12.1.3 to R12.2.7 and Oracle Fusion Cloud R13

Responsibilities:

• Responsible for supporting GL, P2P, O2C, FA, I-procurement, I-Expenses with all module integrations customizations and form personalization.
• Identified standard system functionality, analyzed GAP document, and designed solutions for GL, AP, AR, CM and FA depending on Business requirement.
• Integrated various third-party applications into Oracle GL by integrating through Financial Accounting Hub (FAH) for maintain thin GL.
• Involved in daily bug fixing of complete OLM contract creation Asset split, contract split, full and partial termination of contract.
• Worked on AR, AP, GL integrations and verified all the processes are appropriate and involved in bug fixing.
• Involved in Month-end support for close and reconciliation for AP, AR, and FA modules.
• Gathered business requirements for Interfaces between AP, AR, GL, and Third-party systems.
• Involved in Oracle FAH to process and account interfaces from multiple external systems.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Prepared TE120 documents while testing the application.
• Involved in Month-end support for close and reconciliation for AP, AR, and FA modules.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Worked on Discoverer report with technical team.
• Created test documents, performed unit, End to End User Acceptance Tests for financial modules.
• Prepared Application configuration setup BR100 and MD50 Application Extensions Functional Design documents.
• Interacted and worked with the development team to solve the problems faced in the test scenario run and issues faced in project upgrade.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Integrated various third-party applications into Oracle GL by integrating through Financial Accounting Hub (FAH) for maintain thin GL.
• Configuration of key areas in Project Costing and Project Billing and suggested suitable Business flow setups to client.
• Creating cross validation and security rules.
• Involved in all EB TAX setups for INPUT and OUTPUT taxes for Payables and Receivables Modules.
• Log, view, access, monitor the Service Request raised with the Oracle support for the issues raised by the user and close of the Service Request after successful resolution of the reported issues and problem.
• Worked with Taylor communication for changes in AR invoice format testing.
• Verified AP trial balance and suggested possible adjustments related to Suppliers.

Environment: R12 (GL, AP, AR, FA, iProcurement, I Expense, SLA, CM, FA, INV, Installable) SQL, TOAD.

Confidential, Parsippany, NJ

Oracle EBS/Cloud Functional Analyst

Environment: Oracle Fusion Cloud R12/ R13and EBS R12.1.3

Responsibilities:

• Worked with Desktop Integration (ADFDi) feature to create AP Invoices in spreadsheet using multiple distributions, creating spreadsheet journals etc.
• Worked on Cash Management module setup configuration which consists of Manage Bank, Branch, and Account, Manage Reconciliation Matching Rules, Bank Statement Transaction etc.
• Solution design for structure of Chart of Accounts segment & Intercompany setup configuration in contexts with existing business structure
• CRP and user acceptance test (UAT) were carried out for the above modules. Trained the end users and resolve problems during UAT.
• Worked on Oracle transactional business intelligence (OTBI) in Oracle Fusion Cloud.
• Developed Integration strategy to integrate different system data to Oracle Cloud.
• Explored Month end process for reconciliation of GL to sub ledger - Accounts payable/Receivable
• Prepared whole data conversion approach and cutover strategy for balances from their legacy system toOracleApplication.
• Worked with the Oracle File Based Data Import (FBDi) feature to load the data from the legacy system to Oracle receivables for AR Transactions.
• Gathered business requirements for Interfaces between AP, AR, GL, and Third-party systems.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Supervised the process and functional design activities.
• Interacted with Business stakeholders to get full understanding of business processes, design and implement Oracle Cloud Financial Applications including GL, Payables and Receivables.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Responsible for utilizing a formalized project management lifecycle-Interacting with business users, involved in activities like requirement gathering, identifying functional and technical gaps, application design, functional specifications, scheduling, documentations, test script generation, end users and production deployment.
• Lead all aspects of the design, development and deployment of the Oracle cloud and related components. Designed custom solutions for client specific. Responsible for setting the timelines, assigning project resources, and determining and managing the scope of the project.
• Worked on Concur Expense transactions Integration.
• Prepared the training material to train the trainers and end users and conducted classroom/web sessions to train them.
• Prepared integrated test cases for each setup and End User training material on Project Accounting module.
• Prepared TE120 documents while testing the application.
• Involved in Month-end support for close and reconciliation for AP, AR, OM, and FA modules.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Involved in Oracle FAH to process and account interfaces from multiple external systems.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Worked on Sub Ledger Accounting (SLA) and Payments. Involved in solving various functional issues related to GL.
• Created test documents, performed unit, End to End User Acceptance Tests for financial modules.
• Prepared Application configuration setup BR100 and MD50 Application Extensions Functional Design documents.
• Developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Integrated various third-party applications into Oracle GL by integrating through Financial Accounting Hub (FAH) for maintain thin GL.
• Configuration of key areas in Project Costing and Project Billing and suggested suitable Business flow setups to client.
• Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow.
• Creating cross validation and security rules.
• Worked with Taylor communication for changes in AR invoice format testing.
• Verified AP trial balance and suggested possible adjustments related to Suppliers.

Environment: Cloud R13(AP, AR, GL) and R12 (GL, AP, PO, iProcurement, I Expense, SLA, CM, FA, INV) SQL, TOAD.

Confidential, Torrance, CA

Oracle E-Business Suite Functional SME

Responsibilities:

• Supervising the process and functional design activities
• Creating functional requirements as an input to application design
• User Support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
• Identify, diagnose and document system issues.
• Assess how well a product adheres to its design.
• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3
• Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
• Identified standard system functionality, analyzed GAP document and designed solutions for GL & AP, PO depending on Business requirement.
• Integrated Order Management with Depot Repair to create RMA and Sales Orders, validate customer accounts and invoice customer repairs.
• Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.
• Define DFF, Payment Terms, Signing Limits, Special Calendars and Expense Report Templates
• Define AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options
• Presentation of Financial Consolidation system to the Management.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
• Provide functional review & impact analysis on proposed changes with the existing functionality.
• Conducted several user-training sessions on the system upgrade tasks- Trained in Sub Ledger Accounting, Budgets, Encumbrances and terminology changes from 11i to R12.
• Responsible for preparing upgrade plan for GL, P2P, AR, I-receivables and I-procurement with all customizations and form personalization.
• Prepared impact analysis document for the upgrade of financial module.
• Investigated the current system (11i) and provided the better solutions as per the business requirements.
• Facilitating end-user training and developing the various users training manuals and conducted the UAT sessions.

Environment: 11i/R12 (GL, AP, AR, OM PO, iProcurement, I Receivables, iExpense, e - payments, SLA, CM, FA, INV, OM) SQL, TOAD, Windows 7, HP Service Center, HP Quality Center.

Confidential, Long Island, NY

Oracle Financial Functional Analyst

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP, and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Identify & Document Gap Business Requirements for Oracle GL, Purchasing & Oracle Payables and Applications.
• Drafted extensive set of requirements, questionnaire, and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Developed Functional design documents to support to-be business processes.
• Create & updating BR100 / setup documents for GL, AP, PO, I-receivables and iProc.
• Setup of Account Receivables, Inventory, Advanced Pricing, Order Management, Shipping and Scheduling, and eBusiness tax.
• Designed and Implemented End-End process of I supplier module for client.
• 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.
• Defined set up for shipping and controlling.
• During project several MD-50’s is delivered for different RICE elements.
• Involved in design and configuration of chart of accounts, calendar, and currency.
• Set up Suppliers, created Purchase requisitions, purchase orders in Oracle Purchasing.
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Developed new FSG reports and customized various standard FSG reports.

Environment: R12.1.3 (GL, AP, PO, iProcurement, iSupplier, EBTax, iExpense, iReceivables, CM, XLA) SQL, SQL Developer, Windows 7, SysAID.

Confidential, Seattle WA

Oracle Business Analyst

Responsibilities:

• Interacted with business and analyzed existing business practices, Prepared, and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 and identified GAPS.
• Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL (General Ledger) AP (Accounts Payable), AR (Account Receivable) and Iproc
• Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured, and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Training Super users & power users before start of CRP2.
• Involved in Period Closing & Reconciliation with GL
• Setting up Global consolidation & multi reporting currency &developed FSG Reports for customized Financial Statements.
• Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.

Environment: R12 (GL, AP, PO, CM, FA, AR, Inventory, Workflow Administrator, XML, AOL, XLA, EB-Tax), SQL, Windows XP, VSS, Smile Ticketing System.

Confidential, Salt Lake City, UT

Business Analyst

Responsibilities:

• Worked on development of new FSG reports and customized various standard FSG reports.
• Setup PO module and matching options with AP invoices.
• Configured intercompany (AGIS) setups
• Involved on Month end activities for all the financial Modules.
• Worked on Reconciliation process to close the accounts as per month end.
• Tested end to end flow of Order to Cash cycle (O2C).
• Created Job aids as per users’ request.
• Raised SRs with Oracle Support to resolve the issues which were part of Oracle Bug and provided necessary information as required
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Setup the Iproc and iExpense Module for the Operating Units.
• Setup the approval hierarchy for the expense reports and created signing limits for iExpense users in Payables.
• Involved in documentation of Frequent Mistakes and Error made by end-user in application based on issue log register.

Environment: R12.0.5 (GL, AP, AR, AGIS, OM, INV, AME, Advanced Pricing, CE, iExpense), Bugzilla, SQL, TOAD

Confidential, Los Angeles, CA

Business Analyst

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Mapped the future state process requirements in AP, IProc and iExpense
• Setup the iExpense Module for different Operating Units
• Set up the approval hierarchy for expense reports and created signing limits for iExpense users in Payables
• Involved in the project scoping of the iExpense implementation
• Setup of Policy schedules such as Accommodations, Airfare, Car Rental, and Mileage
• Worked closely with the users to define Daily limits, roles, and locations in Expense reports
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, customers Accounting rules and Receivable’s transaction source& types
• Define system options, Accounting Option, Lookups, Payment and Billing term templates
• Worked with the business users, technical team to enable conversion of the lease from legacy system

Environment: R12 (AP, iExpense, GL, AME), Windows XP, MS Office, Quality Center, Forms, Reports, Workflow, XML Publisher.