SUMMARY

• Over 17 plus Years of Practical Experience in Finance and Accounts with 12+ years of experience as an Oracle EBS R12/Fusion Cloud Financials Consultant, with expertise in Oracle Cloud Financials modules (General Ledger GL, Account Payables AP, Account Receivables AR, PPM, Enterprise Structure, Sourcing, Supplier Portal, Fusion Receipt Accounting, Order Orchestration).
• Hands on configuration of all teh Financials modules on multiple ERP Cloud instances.
• Involved in implementations of Oracle Applications R12 & Cloud R12/R13.
• Strong understanding of Cloud Security Model as it relates to Oracle Cloud.
• Configured teh Oracle Cloud Applications to meet requirements and application set - ups. including Fusion/Cloud ERP (SaaS) as well as E-Business Suite.
• Having experience in OBI Answers, OBI Dashboards, BI Publisher and OTBI/FRS/Smart view reports.
• Configured teh Oracle Cloud Applications to meet requirements and application set-ups.
• Excellent Functional expertise and a good understanding of Oracle General Ledger, Account Payables, Fixed Assets, Account Receivables, Cash Management, Purchasing, Order Management, Inventory.
• Good exposure to AIM & OUM Methodologies.
• 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.
• Thoroughly studying ‘AS-IS’ processes and providing ‘T0-BE’ processes with teh Gap Analysis.
• Provided support for CRP, SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experience in teh preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion, Inbound / Outbound interfaces, Reports, Form Personalization's, SQL, PL/SQL and Workflow Customizations.
• Experience in using Oracle tools like SQL*Loader, FND LOAD, Data Loader, SQL Developer and TOAD.
• Conduct multiple meetings with business, coordinate with Offshore team and create functional Impact Analysis documentation as part of Change Management Process.
• Strong understanding of Oracle’s Cloud Security Model as it relates to interfaces and extensions.
• Business Requirements Mapping for General Ledger, Accounts Payable modules, Accounts Receivable, SLA, FAH and Cash Management modules.
• Well Experienced in Oracle Cloud Enterprise structure design, chart of accounts design.
• Very Good Experience on Fusion Functional Setup Manager (FSM).

TECHNICAL SKILLS

ERP: Oracle Cloud R12/R13, Oracle Applications R12/11i Fusion Procurement, SSP, Costing, Enterprise Structure, SourcingSupplier Portal, Fusion Receipt Accounting, Order Orchestration

Application Tools: Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, XML Publisher 5.6.2/5.6.3 , Work Flow Builder 2.6, JDeveloper10g/11g.

Database Tools: TOAD, SQL* Loader, SQL* Plus, SQL* Developer

Languages: SQL, PL/SQL, Java

Web Technologies: HTML, XML, Web Services

RDBMS: Oracle 10g/11g/12c

Operating System: Windows NT/XP/2000/98, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Camden, NJ

Oracle EBS Cloud Financials Consultant

Responsibilities:

• Worked on Oracle Cloud Financials, SSP, Sourcing, Supplier Portal, Fusion Receipt Accounting, General Ledger, Accounts Receivables, Accounts Payables.
• Interacted with end users and translated their requirements into documents dat catered teh logic for implementing user requirements.
• Configuration of multiple ERP Cloud prototypes (Financials and Procurement Cloud) .
• Created outlines, calculation scripts, member formula and business rules, Data forms, reporting with Smart View.
• Worked on data conversion for customers, suppliers, open AR transactions, GL balances, budgets and fixed assets using Oracle FBDI and ADFDI templates.
• Worked on Bank Statement reconciliation using BAI2 files.
• Worked on Setup for integration between PBCS (EPM) and Fusion Financials clouds services using Data management in PBCS (EPM).
• Created reports using Financial Reporting Studio (FRS), Smart View, and Oracle Transactional Business Intelligence (OTBI).
• Prepared teh configuration workbooks and validated teh same with clients in terms of design and data of teh new Fusion Cloud Application.
• Used teh Sandbox to customize teh Application look and feel as per teh client's requirement and Updated teh Company logo as per teh legal requirements.
• Developed OBI Reports/OTBI Analytics for cloud Payables, AR and GL Cloud modules.
• Defined Test cases and validated on various Custom solutions.
• Tracking Issues logged by user and provided solutions.
• Attending Day to Day calls and providing solutions for teh issues raised by End user.
• Understanding teh functional specification document.
• Understanding nonstandard requirement and in preparing Documents.
• Was responsible for Business Requirement Analysis, Solution Design & Gap Analysis.
• Loading Budgets Journals and Balance Sheet Trial Balance through ADI.

Environment: Oracle Fusion Cloud R13 (Cloud Financials, Payables, PPM, Receivables, Enterprise Fusion Cloud PO, Order Orchestration, Fusion Procurement, SSP, Sourcing, Supplier Portal), JDeveloper11g, SOA11g, BI Publisher, FRS, Smart View, Toad, ADF DI, BI Publisher, OBIEE, FBDI, ADF11g.

Confidential, Southfield, MI

Oracle Fusion Cloud Financials Functional Consultant

Responsibilities:

• Worked with Oracle Cloud Financials Modules (Fusion Financials, SSP, Sourcing, AP, AR, GL).
• Worked on Detailed Financial Statement reporting in FRS.
• Used Table and pivot table to display hierarchical columns in BI reports.
• Worked on Trading Community Architecture (Customer) module.
• Creation of Transaction Types, Transaction Sources.
• Defining Customer Profile Classes, Customers and Customer sites.
• Done teh setups for Document number sequencing for AP.
• Done setups for Auto Accounting rules, and Auto Accounting.
• Worked on all type of AR transaction like Standard Invoice, Debit Memo, Credit Memo, Charge Back Invoice, and Deposit Invoice.
• Worked on developing custom BIP reports for Payables, Receivables, General Ledger as per user requirements.
• Worked on FBDI for inbound integrations in financial system.
• Strong integration experience in integrating with Oracle Cloud ERP both inbound and outbound.
• Proficient in managing Cloud Sandbox for personalization.
• Worked with Oracle Financials Modules (AP, AR, GL, CM, SLA, Project Costing).
• Setting up Financial & Payable options, Defining Payment Terms & Distribution Sets. Defining Supplier and internal Bank, Branches, Bank Accounts .Transaction Work Bench Recording Transactions using Standard Invoice, Debit Memo, Credit Memo, Mixed Invoice, Expense Report, Prepayment, interest invoice, PO Default. Recording of Payments to teh Supplier.
• Creation of Receipt Classes & Receipt Source.
• Defining Receivable Activities.
• Defining Internal, Supplier Bank Accounts.
• Setting up Asset Category, Asset Location, and Assets Key Flex fields.
• Creation of Fiscal Years, and Depreciation calendars and Prorate Conversions.
• Defining Categories and assigning appropriate Ledgers, Calendars, and Depreciation methods to Categories.
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL
• Worded on teh Mass Additions to add assets to Oracle Assets from Payables
• Responsible for Accounts Receivable Technical Support, which includes any day-to-day technical problems such as Invoicing, Customer Interface. Also involved in teh technical tasks such as customizing/trouble shooting teh existing Reports or Interface Programs.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.

Environment: Oracle Fusion Cloud (Fusion Cloud Enterprise Financials, PPM, Procurement, Accounts Receivables, Accounts Payables, Fixed Assets, Order Management), JDeveloper11g Oracle 11g, Forms 10g, Reports 10g, SOA 11g, BI Publisher, FRS, Toad, Extracts, HCM Connect, FBDI, OTBI, Smart View.

Confidential, Charlotte, NC

Oracle EBS Financials Consultant

Responsibilities:

• 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.
• Created YTD, QTD and rolling months actual and budget variance reports through Financial Statement Generator (FSG).
• Analyzed teh requirements/process issues and designed a business process to meet teh functional requirements for enhancements, Period End closing and production issues.
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements.
• Translating teh functional requirements to teh technical team for developing various reports and financial statement.
• Managing Finance track Month End Closing.
• As per Oracle AIM methodology review teh existing business processes and map them with Oracle standard functionality.
• Performed complete setup for GL, AP and AR as per business requirement
• Worked on Inventory (INV) in defining a New Item in inventory and there increasing teh On-Hand Quantity.
• Reviewed teh Business Requirements Documents with teh business and development teams and analyzed teh functionality of teh Oracle applications so as to finalize teh solution.
• Identifying standard functionality, analyze gaps document and design solution for GL & AR depending on Business requirement.

Environment: Oracle E-Business Suite R12(12.1.1) AP, AR, FA, CM, GL, Inv, OM, PO, BI Publisher, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX

Confidential, Chicago, IL

Oracle EBS Financials Consultant

Responsibilities:

• Documenting teh mapping and requirements for teh interfaces and conversions between teh source and Oracle Applications.
• Preparing teh questionnaire and required documents by using AIM Methodology.
• Making required setups and Customizations in corresponding modules.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
• Customized teh Accounts Payable Vendor Entry Form as per requirements.
• Created Alerts to notify users on various business events.
• Developed a package to import expense information into Oracle Payables.
• Creating custom Reports and Forms for teh end users to check teh details and errors.
• Executed teh Payables Transfer to GL program and resolved teh issues during teh process.
• Technical and user documentation of teh customizations.
• Mapping teh Client Requirements with Oracle standard functionality and finding teh gaps and delivering teh solutions in terms of Customizations, workarounds, and reengineering and form personalization.
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
• Configuring teh Oracle Accelerators, which can do teh setups automatically in client’s targeted instance.
• Preparing TE040 Documents, which can helpful to test teh application functions.
• Interacting with Oracle development team regarding issues resolutions.
• Participate in Analysis, Design and Testing of teh code and documentation.

Environment: Oracle E-Business Suite R12, AP, AR, FA, CM, GL, Inv, OM, PO, Reports 10g, JDeveloper11g, Forms 10g, SQL*Loader, TOAD, Workflow, SQL * Loader, UNIX

Confidential

Oracle EBS Financials Consultant

Responsibilities:

• Created and checked teh order submission process from different customers for different items and groups.
• Worked with teh 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 teh financials and payables options and created different bank accounts for Payables.
• Involved with study of existing system, preparing teh 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 teh business requirements.
• Created test scripts for UAT in TE40 documentation with detailed testing of teh modules involved in development of RICE components.
• Responsible for teh day-to-day operations and direction of teh project planning and status reporting, scope management, documentation and facilitation between teh technical and functional team.
• Supporting day to day production issues, gathering requirements, configuring and testing system to meet teh requirements. It includes documentation and user training on new processes.
• Provided period end closing process for Payables and General Ledger. Resolved period end closing issues.
• Gathered requirements on budgets and configured teh GL system to meet teh requirements. Functional process has been developed to upload budget journals and configured setups for Web ADI for batch journals upload process.
• Gathered business requirement and prepare teh As-Is business flows document.
• Performed GAP Analysis and proposed teh feasible solutions to fill teh identified GAP’s.
• Prepared To-Be (i.e. BP80- Future state model) business flows and Map teh business requirement with available standard functionality.
• Prepared Functional Specification for customization to achieve teh business requirement
• Designed functional solution, to keep various factors in mind like, performance improvement, easy maintenance and less defect opportunity after regular patching cycle.

Environment: Oracle EBS 11i (General Ledger GL, Account Payables AP, Account Receivables AR, TCA, Inventory INV, Order Management OM), Oracle 10g, TOAD, PL/SQL, Forms 6i Reports 6i,, SQL*Loader, Shell Scripts.