SUMMARY:

• Over 10 Years of experience in IT including Oracle E business suite. - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation.
• Experience in upgrade 11i To Oracle E-Business Suite Release 12.1. 12.2.4. and 12.2.5
• Full cycle implementation In AP, Payments, FA, AR and EB-TAX
• AP, AR Month End process
• Configurations in AP, AR, FA, Payments
• Extensive testing in R12 upgraded environment.
• Hands on experience in upgrading Discoverer reports to OBIEE reports, Repository build up, deployment and analytics
• Hands-on experience in Oracle Cloud/Fusion Financials(GL, AP, AR, FA ) which includes assessment of migration from legacy on-premises ERP to Oracle Cloud Fusion Financials, requirement gathering, coordination oracle support, understand user security requirements, configuration of security setups (user roles & data access), data migration, integration and extensibility, design of data conversion strategy, extracting data from legacy ERP, validate and load to cloud using cloud tools.
• Apply patches to prepare for the 12.2.4, 12.2.5 upgrade/implementations.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces, user training.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Good Experience in implementing Procure-to-Pay Business Process flows.
• Over 7 years of experience in Implementation and RICE Customization of Oracle Applications 11.5.10 and Release 12 modules such as AP, Payments, AR, GL, PO, Fixed Assets and 2 years of experience in E-Tax.
• Very good working Experience in India, Europe and Latin American Localizations
• Experience in setting up MOAC (Multi-Org Structure), SLA in R12 environment
• Setting up new Payment Formats in r12 environment
• Handling Multiple Countries in single instance
• Multiple Country Rollouts
• Order Management (Payments, Receipts)
• Experience in customizing existing forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Experience in database programming using Oracle 10g databases.
• Experience in various development tools like SQL Developer, and TOAD.
• Experience in developing and loading data into staging tables.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Excellent communication skills, adapt in client interaction and understanding business applications.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS:

Databases: Oracle Applications Modules

CE, PO, Fixed Assets (FA), Project Costing, OM and OBIEE reports: Oracle Application Releases

11.5 and R12, Fusion Financials R13: Languages

SQL: Operating Systems

Unix and Windows: Databases

Oracle 10g, MS AccessOracle Tools: Toad, SQL Developer OBIEE

Methodologies: SDLC, waterfall, Agile.

Productivity Applications: MS Office, MS Visio and MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Process Lead

• 12.2.4 implementation and Rollout for EU Countries and Brazil
• Latin America Implementation
• Mexico CFDI (Tax Requirement Implementation)
• India GST implementation
• Handled Modules AP, Payments, EB Tax Project Costing Fixed Assets and GL
• Implemented AP, Payments, FA and AR
• Implemented SLA /Changes in the COA structure
• Process improvements by implementing new solutions (CR) in all Financial Modules including Project Costing.
• Resolved issues during implementations, including third party integrations (BPEL, OCR, Concur, SAP/Tally/EDI/OMS/DMS/Warranty/Red Perarie/JDE)
• MOAC, PAYMENT FORMATS, SLA in R12 Environment
• ETB (Mexico CFD1)
• Extensive user training in Finance Modules including Project Costing
• Participated in Cloud Implementation (DB)
• Participated in cloud migration project for non-USA ledgers and I was part of end to end cloud migration project including assessment of cloud migration, requirement gathering, data migration from legacy ERP to Oracle Cloud Fusion Financials

Confidential

Lead Consultant

• Upgrade Project from 11.5 to 12.2.4. and 12.25
• Handled Modules AP, Payments, EB Tax and Fixed Assets
• Part of the Team for India Tax Localization (GST)
• Participated in all the Phases of Upgrade, Boot Camp, CRP, SIT,UAT
• Resolved issues during upgrade, including third party integrations (OCR, Concur, SAP/Tally/EDI/OMS/DMS/Warranty/Red Perarie/JDE)
• MOAC, PAYMENT FORMATS, SLA in R12 Environment
• One Source Tax and Vertex Integration with EBS
• EDI 810, Invoices, Customization required for the processes
• Re-implement Payments, build Custom Payment Formats
• Work flow management and issues
• Member of team handling India tax localization (GST).
• Defined tax definition India Localization.
• AR setups including auto Invoice, auto accounting and auto lock box
• Customer setups/ mergers
• Ability to impart Functional training to the End users
• Trouble shooting issues related to Payments sending to Banks
• Trouble shooting Issue related to AR auto invoice
• Document sequences setup related issues
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access
• Chart of Account - Implementation
• Intercompany/intracompany Rules
• POC for Fusion Financials R13 for different Clients

Confidential, Brinckerhoff PA

Oracle Finance Functional Consultant

Responsibilities:

• Support for Oracle upgrade process form 11i to R12 in AP, AR, FA & EB TAX and PROJECT ACCOUNTING
• New Reports for Tax, 1099
• New Custom programs for separating operating units
• Customer merger, separation programs involving 1099 Reporting
• Issues related to Intracompany/Intercompany setups
• Interacted presented with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement
• Provide solutions to functional issues and involve in testing of the application releases
• Worked closely with business users to understand the business processes and prepare the business requirements definition documents
• Work flow management and issues
• Ability to impart Functional training in Oracle General Ledger, Account Payables and Purchasing
• Trouble shooting issues related to Payments sending to JPMC Pay source
• Supported Oracle R12 Applications, Payables, iExpense, E-Tax, General Ledger, Web ADI.

Confidential

Oracle Finance Functional Consultant

Responsibilities:

• Oracle Re-Implementation form 11i to R12 in Finance Modules AP, Payments & OBIEE.
• Interacted presented with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement
• Worked on converting discoverer reports to OBIEE
• Implemented new solutions required for R12 upgrade
• Extensive testing in upgraded R12 environment
• Participating in CRP phases. Train the team members in Sub Ledger Accounting (SLA), Multi Org Access Control (MOAC).
• Documentation / presentation of every implementation steps.
• Gathering requirement and find the source tables for the development of report. Assist in ETL procedures
• Support and resolve issues in implementation of R12 (fresh implementation)
• Validate and customize OBIEE reporting
• Create and validate RPD’s for OBIEE
• Oracle and Non oracle reports

Confidential, Tampa, FL

BA Analyst

Responsibilities:

• Involved in multi-country rollouts including country specific localization for Modules AP, Payments GL and EB TAX
• Implementation of SEPA Payment methods
• Country rollouts LATAM (Argentina, Panama) European (Belgium, Lux, France, Italy etc)
• Implemented new payment methods for Multiple Countries
• Implemented tax automation using EB-Tax for country specific requirements
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Involved in requirement gathering and analysis and design of the application.
• Developed test plans and conducted testing for quality assurance.
• Determined business requirements for Asset summary by category report, Asset register report Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report.
• Working on post upgrade support and interacting with Business users on Issue resolutions.
• Fixed assets setting up of Asset Categories, Asset Keys, Locations, Fiscal Years, Book Controls, Calendars, Prorate Conventions, Depreciation Methods, Bonus rules, Ceilings and Security.
• Involved in setups for Ledgers, Responsibilities Multi org, financial options, Payable Options, Suppliers, Tolerances, and Banks.
• Work with Onsite and Offshore development teams for application development and delivery.
• Provide solutions to functional issues and involve in testing of the application releases
• Worked closely with business users to understand the business processes and prepare the business requirements definition documents
• Ability to impart Functional training in Oracle General Ledger, Account Payables and Purchasing
• Trouble shooting issues related to Payments sending to JPMC Pay source
• Supported Oracle R12 Applications -, Payables, E-Tax, General Ledger, Web ADI and timesheets..

Environment: Oracle Apps EBS, AP, FA, PO, and E-TAX modules in R12.

Confidential

Oracle EBS Functional Consultant

Responsibilities:

• Review the R12 setups with the CFO, Manager and users of respective modules/systems and updated the setup as per requirements.
• Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
• Responsible for gathering Business Requirements (RD 020), Identifying Gaps & Fit Gap analysis (BR 010).
• Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Participated in setting up of Multi-Org for managing multi-org setups.
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• Defined Sub Ledger Accounting Methods.
• Responsible for full cycle accounts payable; review of internal travel and expense reports.
• New functional like Sub Ledger Accounting (SLA) and functionality changes in various modules are reviewed by CFO, Super users and Users of various business areas.
• System integration and regression test has been carried out to meet various functional scenarios.
• System tested to meet Order to Cash with matching and payment batch process in receivables system.
• System tested to meet invoice to cash process applying manual and Auto Lockbox receipts in Receivables. Configured location based and VAT tax setups to meet the requirement.
• Cash Management system has been tested to the bank file reconciliation process.
• Developed test cases on various functional scenarios and provided to user and user training has been provided new system.
• Involved in Cutover Panning and Performed Validations after Cut-over.

Environment: Oracle Apps EBS AP, AR, FA in 11i (11.5.10) version have been upgraded to new system R12.

Confidential

Oracle EBS Functional Consultant

Responsibilities:

• Involved in current system analysis and GAP analysis system configuration and testing in GL module implementation. I have organized work shop with the end users for requirement gathering, limitations of existing system and proposed the solutions.
• Designed Key Accounting Flex field structure with Multi Org and Multi Currency setup. Defined rollup groups, security rules, journal sources, journal categories, budgets and budget organization, intercompany accounts, cross validation rules, summary accounts, account aliases, currency translation, conversion, and revaluation to meet the requirements in GL modules.
• Determined business requirements for Asset summary by category report, Asset register report Customized Asset addition by cost summary report, Asset category report, Asset retirement report, Asset additions report, Annual additions report.
• Configure setups for Global consolidation, Multi reporting currency and FSG reports.
• Configured the setup for batch invoices and batch payments, multi-currency invoices and multi-currency payments to meet the requirements in AP.
• Demonstrating iExpenses standard functionality to gathering requirements for implementation.
• Implementing iExpenses for recording Employee travelling expenses, including Company paid expenses, Saturday stay alert messages, approval limits, audit and audit queues, capturing additional expenses and etc
• Developed AIM documentation BR-20, BR-100, CV-60, MD-50, and TE-40 for business requirements, system setups, conversions, customizations and functional testing respectively.
• Manage conversion and cut-over activities for rolling Oracle Financial 12i to other divisions

Environment: Oracle Apps R12 (GL, AP, AR, PO, FA, INV), PL/SQL, Linux

Confidential, Houston, TX

Oracle Financial Functional Analyst

Responsibilities:

• Worked closely with business users and accounting (AR, AP) to understand the business processes and prepare the business requirements definition documents.
• Performed end to end testing for the entire process flow for AP, AR and GL modules and documented the test results.
• Preparation of user training documents - prepared the training document for the users, specific to the clients’ business and covering their critical business process flows.
• Defining Fiscal years, depreciation methods, Prorate conversions, Asset Categories, Asset Warranties
• Performed transferring invoices and payments to General Ledger and tested period end balances.
• Define Sales tax location key flex field, Order import sources, Sales persons, System Options, Customers
• Setup payment terms apart from the default ones
• Auto Accounting Setups, Transaction types, Credit Memo and Invoice, transaction Source
• Define Collectors, Approval limits, Receivable activities, internal Bank accounts
• Setup Receipt classes and Payment Methods and Setup Sources
• Define custom designed Statement Cycles, Customer Profile classes

Environment: Oracle Apps EBS Fixed Assets, GL, AP, AR, PO, and CM modules in 11i (11.5.10)

Confidential, LA

Oracle Functional Consultant

Responsibilities:

• Worked as Functional Analyst for Oracle Payables, Receivables, General Ledger,
• Planned the implementation strategies with the clients and the other team members.
• Reviewed and refined the Common Apps setup steps shared across modules like Oracle SYSADMIN, GL, AR, AP, PO, INV, and PO (such as Set of Books, Currency (enabled), Locations, Organizations, Customers, Suppliers, Tax- Codes, Key and Descriptive Flexfields and UOM).
• Reviewed the setup steps for a Multi-Org and Multiple Reporting Currencies- USD, CAD & FFR. Setup the MO: Operating Units, and defined additional transaction currencies and daily rates etc. Reviewed the reporting set of books. Reviewed other applications implementation and functionalities of Multi-Org and MRC.
• Gathered requirement data, mapped data elements to Oracle functionalities, reviewed gaps, defined work-around solutions to proactively reflect company’s business future outlook. Used descriptive flex fields to cover additional data and to reference historical data during transaction processing.
• Used systems options, profile options, financial, payables, purchasing options to control data usage and integrity, to default list of values into forms and windows, and restrict access to functions when users were unauthorized to view or access data.

Confidential

Oracle Functional Junior Consultant

Responsibilities:

• Worked junior Consultant for Oracle Finance
• Handling Modules AP, AR FA GL in release 11.5
• Working with Senior consultants to implement support Oracle Financial Modules at Client
• Training in ERP software Release 11I
• Training in Oracle Finance Modules AP AR GL FA and Projects
• Basic Training in Oracle EBS, Menus Responsibilities etc
• Training is the basic configuration required for Oracle Finance Modules