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 the 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 the 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 the 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 the Gap Analysis.
• Provided support for CRP, SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experience in the 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, Sourcing, Supplier 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 that catered the 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 the configuration workbooks and validated the same with clients in terms of design and data of the new Fusion Cloud Application.
• Used the Sandbox to customize the Application look and feel as per the client's requirement and Updated the Company logo as per the 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 the issues raised by End user.
• Understanding the 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 the 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 the 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 the 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 the technical tasks such as customizing/trouble shooting the 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 the requirements/process issues and designed a business process to meet the 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 the functional requirements to the technical team for developing various reports and financial statement.
• Managing Finance track Month End Closing.
• As per Oracle AIM methodology review the 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 the On-Hand Quantity.
• 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.
• 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 the mapping and requirements for the interfaces and conversions between the source and Oracle Applications.
• Preparing the 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 the 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 the end users to check the details and errors.
• Executed the Payables Transfer to GL program and resolved the issues during the process.
• Technical and user documentation of the customizations.
• Mapping the Client Requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, and reengineering and form personalization.
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
• Configuring the Oracle Accelerators, which can do the setups automatically in client’s targeted instance.
• Preparing TE040 Documents, which can helpful to test the application functions.
• Interacting with Oracle development team regarding issues resolutions.
• Participate in Analysis, Design and Testing of the 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 the order submission process from different customers for different items and groups.
• Worked with the 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 the financials and payables options and created different bank accounts for Payables.
• Involved with study of existing system, preparing the 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 the business requirements.
• Created test scripts for UAT in TE40 documentation with detailed testing of the modules involved in development of RICE components.
• Responsible for the day-to-day operations and direction of the project planning and status reporting, scope management, documentation and facilitation between the technical and functional team.
• Supporting day to day production issues, gathering requirements, configuring and testing system to meet the 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 the GL system to meet the 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 the As-Is business flows document.
• Performed GAP Analysis and proposed the feasible solutions to fill the identified GAP’s.
• Prepared To-Be (i.e. BP80- Future state model) business flows and Map the business requirement with available standard functionality.
• Prepared Functional Specification for customization to achieve the 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.