SUMMARY

• Oracle Finance Functional consultant with over 7 years of focused expertise in Financials modules of Oracle Applications. Worked on Release 11i, Release 12.1.1, 12.1.3 & Release 12.2.4
• Strong experience as a Functional/ Business Analyst in fresh implementation and provide Production support of Oracle ERP financial suite including Oracle General Ledger, Payables, Receivables, Assets, Purchasing, Cash Management, iExpenses, EB Tax and SLA.
• Experience in implementation, customization and testing of Oracle Applications for Financials 11i/R12 modules.
• Act as a Business Analyst for Oracle Cloud implementation.
• Provided support for ERP Cloud Applications for the organization.
• Support Analyze, evaluate and develop existing or proposed systems changes from business personnel.
• This position will also coordinate activities with other IT organizations (e.g., database, telecommunications, operations, technical support, etc.) to ensure that system improvements are successfully implemented.
• Worked on full life cycle implementation & have good knowledge on Oracle Financials Modules: GL, AP, FA, CM, iExpense, EB Tax, Sys Admin (11i / R12).
• Worked in 4 full life cycle implementations and 1 Post Go - live enhancement project in Order to Cash and Procure to Pay Modules.
• Oracle Distribution/Supply Chain/Manufacturing (INV, PO, OM, BOM, WIP, iStores, Advanced Pricing).
• Consistent track record in cost reduction and supply chain projects, closely working in partnership with business areas. Senior interaction and negotiations with C-levels.
• Have good understanding on Financials Cloud for GL and Payables modules.
• Competent in understanding the functionality of the Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Extensive experience in full Implementation Lifecycles of complete suite of Oracle EBS and covering Definition, Elaboration, Build, Test, Transition and Support.
• Experience in setting FSG, Multi Organization structure, Multiple Reporting Currencies, Key and Descriptive flex fields and System Administrator functionalities.
• Good working knowledge and interpretation of financial statements such as retained earnings and balance sheet statements.
• Assisted client with the formation of a business case to migrate from legacy system to Oracle 11i & R12 systems.
• Created mapping for interfaces to existing systems and also data migration and conversion of legacy data into Oracle.
• Possess a firm understanding of supply chain, distribution, warehouse, transportation, and inventory principles.
• Have knowledge on the Functional mapping of data Conversions & Enhancements for Accounts Receivables, Accounts Payable, General Ledger, Sub Ledger Accounting, E-Business Tax, I-Procurement, AGIS, Fixed Assets, Inventory modules
• Conducted and evaluated Business Process review, Map and Gap analysis to resolve business requirements not addressed by the applications,
• Designed and developed test scripts (TE-40s).
• Created training materials and also conducted several UATs and CRPs in Oracle ERP.
• Conducted end user training through instructor led sessions and virtual classes.
• Strong analytical, diagnostic and troubleshooting skills with the ability to work in a fast-paced and team oriented environment

TECHNICAL SKILLS

Methodologies used: include Oracle AIM, Rapid Return on Investment (R2i)

Oracle Applications: Oracle Applications 11i/11.x/10.7, GL, AR, AP, FA, Cash, Project Billing, PO, OM, INV, Federal Financials and Systems Administration

Software: Oracle 9i/8i/8.x, Reports 6i/3.0/2.5, PL/SQL, SQL*LOADER, SQL*PLUS

Programming Languages: SQL, and PL/SQL

RDBMS: Oracle 10g/9i/8i/8.x

Operating Systems: Sun Solaris, Win XP, NT, Windows 95/98

PROFESSIONAL EXPERIENCE

Confidential - Boulder, CO

Oracle Finance Functional Consultant

Responsibilities:

• Worked on the end to end implementation and support of Oracle Financials Modules of AR, AP, GL, SLA, EBTAX, FA and. Cash Management.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Migrated financial data of a health insurance company to Oracle's optimized and automated ERP system
• Worked on AR Deductions Settlement module including the setups for Implementing Claims like setting up system parameter defaults, setting up Trade Profiles, setting up Supplier Trade Profiles, Implementing Org Stripping on Claims.
• Configuring the Oracle Cloud Applications to meet requirements along with documenting application set-ups.
• Testing any changes in Oracle, NOETIX, Vertex, and E- Biz tax.
• Oversaw day-to-day operations of CDM team, including setup and maintenance of customers' accounts in Oracle and CRM databases.
• Design Advanced Analytic Solutions for clients using Oracle Autonomous Analytic Cloud
• Proficient in SCM, i-procurement, Order to Cash, Oracle Manufacturing, Order Management, Shipping Execution, Purchasing, Inventory, Bills of Material, Work in Process etc.
• Designing and developing recognition process for the Customer Data management.
• Worked on AR Module - Defined the Auto Invoice, Auto Lock Box, Revenue Recognition and Collection Process.
• Worked on the setups of Sub Ledger Accounting module - defining the Journal Line Sources, Events, SLA Rules, Account Derivation rules, etc.
• Worked on the e-Business Tax module setups - defining the tax codes, tax rates, exemptions, exceptions, regimes, rate to regime flows, etc.
• Configured Oracle AR - Including the setups of Revenue Recognition process, defining of Accounting and Invoicing rules.
• Worked on Oracle Payables - worked on the setups of the Payment Manager, defined the payment process profiles, defined various payment process requests
• Worked on the ACH Process in Oracle Payables.
• Modifying the Existing objects like OBIEE reports, Oracle PL/SQL Packages, RDF reports which are affected with the changes in the GL Accounting program.
• Worked on configuring General Ledger Module - defined primary and secondary ledgers, worked on defining ledger sets, data access sets, worked on the chart of account design, worked on translation, revaluation, consolidation, etc.
• Worked on Cash Management module - defined the options for manual and auto reconciliation of bank statement.
• Implemented various enhancements and configured Tax Codes related to AP/AR Italian VAT reporting.
• Implemented a complex refund process involving interfaces to Oracle AR and various external billing systems
• Functional lead for FA conversion of corporate/tax book assets due to merger between two STT companies
• Working as Oracle apps Finance functional lead consultant responsible retro fitment and Fit Gap analysis of various Financials modules like Accounts Payable, Accounts Receivables, General Ledger, modules between 11.5.10 and R12.2.4 version of Oracle Apps.
• Proposing new business solutions and designs changes required in ERP SCM and Manufacturing Domain. Reviewing the technical design documents and helping technical team in every phases of work.
• Requirements gathering, fit gap analysis with Standard Oracle apps functionality.
• Designing a complete re-architecture of inventory items and bill of materials (BOM) to support all product and service sales, billing, and renewal from the Oracle system.
• Create and manage various reports by gathering supply chain data and conduct analysis with the goal of improving the organization's operations for on time and in full deliveries.
• Designed and developed Custom advancing pricing module including OAF pages, custom business rules engine, and integrated with Oracle Order Management.
• Provided custom solution to integrate third party Tax API (ADP), to Oracle EBS.
• Wrote SQL scripts to assist in the identification of Projects revenue issues such as to verify the information contained in the PA- AR invoice interface.
• Managed implementation and enhancements to Business users for Oracle Financial Application Modules, AR, FA, AP and Cash Management.
• Responsible for all functional testing Order Management and Advanced Pricing Modules.
• Understand the requirements of the client in functional scenario and analyzed, tested the standard functionality in Oracle EBS to meet the specific requirement of the client.
• Upgradation from Oracle EBS11.5.10.2 to 12.2.4 version and implementing new modules as per customer requirements.

Confidential - Indianapolish, IN

Oracle Finance Functional Consultant

Responsibilities:

• Major activities consist of development of R12.2.4 Business process test cases on new functionality-based document for various modules AR, AP, GL, FA, CM, OM, PO, Customizations with using of CEMLI's etc.
• Worked on functionality of various modules as mentioned above by drafting test cases & reporting the same on word document, and excel documents to client.
• Manual testing by way of execution of all test cases for the above-mentioned modules with status as (Pass /Fail) & updating the same to Testing team with important screen shots which is a part of validation.
• Performed production support activity after GO live in R12 upgrade project (offshore).
• Provide solutions to end user for UAT testing of R12 Functionality in oracle new instance.
• Impact analysis in current business process due upgrade changes/enhancements. Assisting in development and testing software applications.
• Preparation of R12 Upgrade documentation - Functional Configurations for Accounting cycle (GL, FA, CM), Revenue Cycle (AR, OM, BP), Expenditure cycle (INV, PO, AP) modules etc.
• Part of activities like Pre-Cutover plan, Post Cutover, Verification etc. For the above-mentioned modules.
• Development/Execution of test case for Vendor, Employee, Invoice, and Remittance related interface etc, also capturing important evidence in form of screen shots for interfaces.
• Worked on documentation activity which consists of SRS, design document, test plan, test cases, etc. Performed production support activity after go-live for AP concur interfaces (offshore).
• New entities Application Functionality testing i.e Supplier, Customer, Banks creation process testing flow, Business process testing P2P, O2C, Reports, Forms, Regression etc.
• Functional Test scripts writing and execution on various instances maintain result oriented document for Super User, End User UAT.
• Configured Regime to Rate Flow in E-biz Tax Module.
• Analyze the expansion Requirements and strategize the migration of customizations. Identification of GAPs & proposal of Solution. Drawing Functional specification and design upgrade for functional process enhancement.
• UAT testing for the above through test scripts based on Change requests. Capturing key Metrics data for Quality and reporting to Top management on periodic basis.
• Experience in reviewing test scripts based on the business requirements. Plan, Execute and Monitor the CRP Cycles in Development instances in Oracle ERP Experienced in Reporting and Tracking Defects by using Bug Tracking tool such as Quality Center.

Confidential - Seattle, WA

Oracle Finance Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: Accounts Receivables, Accounts Payable, General Ledger, E-Business Tax, I-Procurement, AGIS, Sub Ledger Accounting, Fixed Assets, Inventory modules.
• Worked on the Functional mapping of data Conversions & Enhancements for Accounts Receivables, Accounts Payable, General Ledger, Sub Ledger Accounting, E-Business Tax, I-Procurement, AGIS, Fixed Assets, Inventory modules
• Worked on the setups for AME including the AME Rules, Actions, Attributes, Conditions, etc.
• Worked on the setups of the Sub Ledger Accounting - defining journal line types, journal line definitions, mapping sets, account derivation rules, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Provided with useful training to the users in Accounts Receivables, Accounts Payable, General Ledger.
• Worked with Account Receivables team to develop Auto Invoice Interface to upload invoices coming from legacy systems. Developed Several PL/SQL and SQL Scripts to perform validations on the legacy data.
• Worked with development team to build an Interface using Oracle Advanced Pricing APIs to Uplift Price List Rates on existing Service Contracts annually.
• Developed Validation Programs for Purchase orders and Conversion Programs for Purchase Orders, Receipts and Invoices for both Received & Invoiced as well as for only Received Purchase Orders.
• Extensively worked in testing conversion programs and involved in Unit Testing and Performance Testing of all conversion programs.

Confidential - San Francisco, CA

Business Analyst

Responsibilities:

• Provided analysis, design, installation, setup and rollout of Oracle 11i Order Management Logistics, Manufacturing module and established proof-of-concept.
• Setups included Multi Language, Multi Reporting Currency, Multi Organization
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
• Developed interfaces and data conversion programs for applications
• Addressed operational problems, concerns, and questions posed by users
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Setting up profile options values (standard and custom), set up for OM, AR and PO.
• Involved in Inventory org setups.
• Was involved in the 4-D methodology (Discover, Design, Develop and Deploy).
• Preparing technical specifications for the sub modules like (Customers, OM, Shipping, Interfaces, etc.).
• Implementation methodology documentation including technical specs and functional specs.
• Liaising with client key users and technical team, conducting CRP/testing
• Ensuring order Processing/Booking (OM) during month/quarter/year end and resolving inter-company accounting issues.
• Responsible for transfer of data from External systems like Web, EDI, PO to OM.
• Responsible for transfer of data from OM to AR and ensuring no records are stuck in the interface.
• Resolving issues related to flex fields and sysadmin setups.
• Design of custom forms and extensions for OM and PO module.