SUMMARY:

• 13 years of overall experience which includes over 8 years of consulting in IT sector & 5.6+ years in Accounts & Finance domain.
• Around 8 years of IT experience consists of Implementation, Upgrade, Enhancement, Analysis, Design, Development, Testing and Support in Oracle E - Business Suite and Oracle Fusion Cloud
• Has implemented and supported Oracle Fusion Cloud Financial/procurement modules & Oracle Financials-EBS Suite Release 12 modules for clients that address critical business needs with intuitive and accessible user experiences across corporate financial environments.
• Successfully Implemented and provided production GO live support for Oracle Fusion Cloud financials & procurement module for client in shipping industry - Dubai, UAE
• Successfully Implemented and provided production GO live support for Oracle E-business suite financials & procurement module for client in BNFS industry - Mumbai, India
• Knowledge in modules such as General Ledger(GL), Account Payables(AP), Account Receivables (AR), Cash Management (CM), Fixed Assets (FA), India local Tax (EB Tax), Purchasing (PO),
• Conducted requirements gathering workshops, prepared AS-IS(BP-040), TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP, UAT sessions and user for accounting professions and users using AIM methodology.
• Experience on Procure to Pay, Order to Cash, Record to Report and Assets to GL Cycle’s Using Multi-Org. Worked on R12 Financial Modules and MOAC, TCA, Trained teh client’s super users and users on teh application and conducting Pilot testing, integrated testing, design validations and setups of teh Distributed ERP applications
• Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports (RICE).
• Experience on Data Conversion and Migrations life cycle. Worked in Onsite and Offshore model projects Knowledge in Financial concepts and related business processes with very good understanding of teh various process cycles of software development including Analysis, Design, and Testing.

TECHNICAL SKILLS:

Functional Expertise: Fusion Financial Offerings Implementation and Oracle E- Business Suite financial modules General Ledger, Accounts Payable, Accounts Receivables, Fixed Assets, Cash Management, Procurement - Purchasing etc.

Industry Expertise: Construction, Manufacturing, Media, Entertainment, Banking & Finance, Broking, Shipping, Information Technology, NBFC - Non-Banking financial organization

Oracle Fusion/Cloud: Applications R10, R11 & R12 and Oracle Financials-E Business Suite Release 12 applications

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Functional consultant

Responsibilities:

• General Ledger Configuration - Ledger, Legal Entities, Currency, Calendar, SLA, COA Mapping
• Accounts payable Configuration - Financials option, system options, payable options, payable calendar, payment terms, Aging report definition, bank setup, Payment Process Request - PPR payment templates
• Bank Format understanding and preparing MD50 document, sharing teh understanding with Development team for development
• Accounts Receivable Configuration - Transaction type, Transaction source, System options, Auto - Accounting, Receipt class, Receipt methods
• Cash Management Configuration - Automatic bank statement generation from bank and uploaded in Oracle system’s
• Fixed Asset Configuration - Define Key Flex field, Asset Classification, Asset categories, Asset Book
• Conversion of Sub ledger closing balance for new legal entity - Roll out project
• Setup configuration for new Enhancement, customization & Personalization which includes, PO & NON-PO workflow, Bank Formats, VAT Tax Report - Italy etc.
• Prepared MD-50 for interface development for source system’s which includes IBS, WSS, Sun etc
• Configuring teh Dev, Test & Prod instance as per teh solution design and supporting various test phases such, QA, UA & FSR
• Gathering requirement from teh client for customization, enhancement and change request.
• Evaluating teh Reports and testing them for teh desired outputs after development as Per teh Business requirements.
• Assist business user’s in UAT for teh customized report designed & developed
• Played significant role in system Integration testing.
• Tested teh entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Developed and executed test scripts and drove resolution of fixes to teh system prior To User Acceptance Test.
• Preparing BR100’s as per solution design and MD50 as per regulatory requirement for various countries.
• Part of India localization tax configuration for GST implementation for India Roll entity
• Prepare documentation of R12 Upgrade for testing activities which includes - Master Test Plan, Test cases with scenario’s etc.
• Assist Business user in UAT phase for testing teh functionality of Oracle E-business suite Release 12 and its Features

Environment: Oracle EBS - R12.1.3

Confidential

Consultant - Oracle Financials Cloud Consultant

Responsibilities:

• Setup configuration for Enterprise structure, COA, GL, AP, AR, FA, CM etc. modules as a part of fusion implementation
• Common & General Ledger setup configurations includes - Uploading of COA values such as business unit, cost centre, Natural accounts & other segments via Rapid implementation methology of Oracle fusion cloud module
• Solution design for structure of Chart of Accounts segment & Intercompany setup configuration in contexts with existing business structure
• Worked on Accounts payable setup configuration consists of Common Options for Payables and Procuremen t, Manage Invoice option, Manage Payable calendar, Manage Distribution set, Manage Payment options, Manage Payment Terms, Manage Invoice Tolerance, and Manage Payable Document Sequence etc.
• Explored ADF spreadsheet template for uploading open invoice of Accounts payable module and upload of Closing Trial balance in General ledger module
• Worked on Accounts Receivable setup configuration consists of Define Common Accounts Receivable Configuration, Manage Receivable’s Document Sequence, Manage Transaction Type, Manage Transaction Source, Manage Auto-Accounting Rules, Define Receivable Activity, Define Customer, Manage standard Memo lines, etc
• Used FBDI Journal Import template for bulk upload of Oracle Receivable transaction & Receivable customers for closing balance
• Worked on Fixed Asset module setup configuration consists which consists of Asset Category Key Flex field, Manage Fiscal Years, Manage Asset Key Flex field, Manage Asset Categories, Manage Creating an Asset Category, Manage Location Flex field, Manage Asset Book, etc
• Worked on Cash Management module setup configuration which consists of Manage Bank, Branch, and Account, Manage Reconciliation Matching Rules, Bank Statement Transaction etc
• Explored to business user standard operating process which includes - Accounts payable - ADF spreadsheet, Recurring invoice, Booking of invoice - Standard, prepayment with accounting, Accounts Receivable - FBDI template for bulk AR transaction, Booking of Transaction, Credit memo, Debit memo with transaction type and memo line usage.
• Explored Month end process for reconciliation of GL to subldger - Accounts payable/Receivable
• Worked on documentation of BR100 - Setup configuration, MD50 - Functional Specification Design, MD70 - Technical Specification design
• Explored Reporting feature to business which consists of OTBI work area, Smart View reporting, KPI’s & Dashboard etc.

Environment: Oracle Fusion R12 - On cloud SaaS product

Confidential

Oracle Financials/Procurement Cloud Consultant

Responsibilities:

• Worked as Oracle Lead consultant and solution architect role for Requirement gathering phase for requirement understanding and map those requirements to Oracle Fusion
• Preparing Documentation for teh requirement gathering i.e. Requirement document, Solution design document etc.
• System setup configuration for Fusion financial/Procurement for - Enterprise structure, COA, GL, AP, AR, CM, PO, FA etc. modules as a part of fusion implementation
• For bulk data upload like values of COA, Ledger, Business unit etc. used Rapid implementation feature of Oracle Fusion
• Worked with teh client to complete FBDI Journal Import template, then loaded beginning balances back to FY Ending 2015
• Worked on Account Payable module which includes Common Options for Payables and Procuremen t, Manage Invoice option, Manage Payable calendar, Manage Distribution set, Manage Payment options, Manage Payment Terms, Manage Invoice Tolerance, and Manage Payable Document Sequence etc.
• Worked on Accounts Receivable module which includes Define Common Accounts Receivable Configuration, Manage Receivable’s Document Sequence, Manage Transaction Type, Manage Transaction Source, Manage Auto-Accounting Rules, Define Receivable Activity, Define Customer, Manage standard Memo lines, etc
• Worked on Fixed Asset module by Setting up Asset Key Flex fields, Asset Categories, Asset Locations, Asset Calendar and Asset Books.
• Worked on Purchasing module Define Common Purchasing Configuration, Define Approval Management, Define Procurement Agents, Define Supplier Configuration, Define Requisition, Define Receiving option etc.
• Worked on Application Security setup configuration like Creating Implementation Users, Enabling Abstract Roles, Assigning Roles to Implementation Users, Creating Application Users etc
• Worked with teh client to complete ADF Import Account Combination spreadsheet, then loaded Account Combinations. Client did not want to allow dynamic insertion turned on.
• Explored teh Oracle Fusion functionalities like ADF Desktop integrator, External Source - FBDI - (File based Data import) for data migration from legacy to Oracle Fusion
• Assisted mapping Primary to Secondary (Cash) ledger
• Configured Cross currency setup for payments in accounts payable module i.e. payment of various currencies from single ledger
• Requirement gatheird to prepare balance sheet/ Profile and loss account - FRS - Financial Reporting
• Provided CRP & UAT to end user & data migration. Successful GO live 8 LE's with financial modules onsite.
• Performed setup configuration for India entity for TDS & service tax configuration as fusion tax setup
• Structured Implementation of VAT tax for UAE entities - with Oracle Fusion tax feature for future planning
• Provided GO live Support to business user after implementation for day to day transaction. Provided /Overview to business user on OTBI tool, Smart view, FRS - Financial Reporting studio, KPI’s - Key Performance Indicator, Dashboard etc.

Environment: Oracle Fusion SAAS - 10.1.7, 11.1.8 and 11.1.9

Confidential

Oracle Financials Functional consultant

Responsibilities:

• Requirement understanding with business user and pass on teh same to technical development team for custom report development
• Preparation of BR100 - Application Setup, MD50 - Functional Design, MD70 - technical Design for new Custom report development
• Helping business user in UAT phase for teh new developed report as part of change management
• Verification of Financial module setup configuration based on existing documentation with system configuration for AP, AR module
• Guiding teh business by providing reconciliation approach between General Ledger and sub ledger modules
• Integration of purchasing module with accounts payable which includes Purchase Order Matching, Two-, Three-, and Four-way Matching, Payment on Receipt, Defining Accrual and Variance Accounts, Variance Accounts, Receipt Accrual etc.
• Configuration of Tax setup for VAT and Service tax - Validation of tax Reporting which includes - input/output set off
• Prepared Kick off presentation on project plan & schedule. Presentation for Project planning & initiation to client
• Preparing GANTT chart with project start & end date details. Major activities - Requirement Understanding for report development & documentation on teh same – (MD -50)

Environment: Oracle EBS R12.1.3

Confidential

Oracle Functional Lead – Finance/SCM

Responsibilities:

• Understanding “AS IS” operations and map with “TO BE” processes with Oracle Standard features customization and Personalization.
• Requirement gathering from client (Functional/Technical) for teh various pain areas & providing solution with best practice in teh market
• Translate teh customer requirement into a scenario to show to teh customer, and develop these prototypes
• Accounts Receivables for restructuring teh instance setup configuration includes - Transaction types, Sources, Receipt classes, Sources, Banks and Bank Accounts, Memo Lines, Auto-Accounting Rules etc
• Accounts Payable setup configuration includes - Set-up of invoices, debit and credit memos, guarantees, deposit transaction types, Explore Standard process of Reconlication from sub ledger to General Ledger to business
• Implementation of AP/AR netting process in case customer and supplier are same
• Involved in Analysis, Design, Business Process mappings for Integration project.
• Prepared MD – 50 functional design documents for custom reports. Issues, form Customization & personalization etc.
• Provide guidelines to technical team on report development, form Customization & personalization developed
• Configuration of Sub Ledger accounting feature with sweeping of account code combination for Accounts receivable module as per client requirement
• Explored new features of Oracle E-business suite Release 12 and configure those in system as part of solution design
• Testing for SCM Modules (AR, AP, OM, INV, PO) to make sure flow is working without any issues.

Environment: Oracle R12.1.3

Confidential

Oracle Financials Functional consultant

Responsibilities:

• Attended CRP,, UAT session at client’s location provided by implementation partner & finding gaps in teh process of implementation by analyzing teh issue
• Reviewed documents of OUM (Oracle Unified Method) RD011- Future Process Flow, TA040 - Application Architecture Organization Structure, TA040 – Application Architecture COA, DS-020- Personalization Strategy, DS-140 - v Design Specification (Functional/Technical), Production setup configuration documents module wise, COA Segment Values and providing recommendation to client for teh gaps (if Any)
• DevelopedFSG Reports in GLlike (Income statement, Dept Expenses, Inter Company Summary
• Setup configuration for Accounts payable includes Defined Payment Options, Payment terms, Distribution Set, Payment Format, Internal Banks, Recurring Invoices, Prepayments, Expense Report Templates, Interest on Invoice report, Matching options, Adjustment of Prepayments inPayables, Setup for Batch invoices and Batch payments, Multi-currency invoices and payments.
• Provide client with solution & recommendation for COA values, Period Closure process, Setup configuration, Pain areas – Recommendation, New R12 Functionality to explore oracle Application
• Implemented those area’s which are partially been implemented by teh implementation partner i.e. configuration of AP/AR Netting, Identification in system for Duplicate supplier process
• Data migration activity for legal entities activity with open items listing & tally teh same with legacy system balance’s
• Providing approach to client for conversion of data migration i.e. Transaction & Master data
• Documentation of BRD100, MD050, and MD070 etc.
• Functional design and design review of Oracle Applications data conversions, interfaces, custom reports and custom applications.

Environment: Oracle R12.1.3

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Major activities consist of development of R12.1.3 test cases new functionality on word Document for Various modules viz. Accounts Receivable, Accounts Payable, General Ledger, Order Management, Purchase Order, Inventory, Fixed Assets, Cash management, Blood pricing, CEMLI’s etc.
• Worked on functionality of various modules as mentioned above by drafting test cases & reporting teh same on word document to client. Bulk uploading of teh above test cases in HPQC Quality center.
• Manual testing by way of execution of teh test cases for teh above-mentioned modules with status as (Pass /Fail) & updating teh same in HPQC Quality Center with important screen shots which is a part of validation.
• Booked defects in HPQC Quality center& getting it resolved with Technical team or functional team & Re testing teh same by providing pass/fail results.
• 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.
• Planning and testing of upgrades, including offshore support of UAT.
• Impact analysis in current business process due upgrade changes/enhancements. Assisting in development and testing software applications
• Preparation documentation of R12 Upgrade – 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 teh 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)

Environment: Oracle R12.1.3

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Work with a team of business user for new enhancement implementation and support of Central Corporate Ledger
• Provide direction and subject matter expertise for Oracle Financials
• Supporting and resolving issues arising in Oracle EBS for GL, AP, AR, FA, India localization Tax
• Defining new master as per request from business – supplier, customer, Bank & branches and COA segment values
• Prepare AS-IS of current system, find and recommend work around of GAPS.
• Prepared BR100, MD050 documents for each financial module
• Supporting solving Day-to-Day End–User problems.
• Performing Week/Month end Reconciliation.
• Direct interactions with users and seeking information as required for resolving issues.
• Periodic Communication to Users Regarding teh process on teh issues being worked on.
• Analysis of teh Problem/Issue Reported on Remedy Toll and Suggesting Solutions.

Environment: Oracle R12.1.3

Confidential

Oracle Financials Functional consultant

Responsibilities:

• Mapping of ledger accounts from legacy systems with Oracle CoA for migration and interface purposes. Configuring of entities – Legal Entity Setups, GL Setups, AP Setups and AR Setups
• Created and maintained masters like Chart of Accounts, TDS Master, Lookups, DFFs, and Employee etc. Working Exposure in TCA (Trading Community Architecture)
• Migration of legacy Trial balances to Oracle Trial Balances and AP Migration. Gathering functional requirements for reports and getting it developed and testing of developed reports including FSG Reports
• Reconciling Oracle Trial Balances with Tally Trial Balances during parallel run. Functional support to users by resolving queries pertaining to GL, AP, AR, FA, CM and reports and them and auditors
• Designed solutions to enhance standard Oracle flows for procure to pay, and GL accounting processes for this rapidly growing specialty retailer that handles over bulk transactions per day. Implemented automatic bank reconciliation functionality in CM
• Common Setup’s & GL setup configuration consists of,Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields
• Accounts payable setup consists of – Financials option, system options, payable options, payable calendar, payment terms, Aging report definition, bank setup, Payment Process Request - PPR payment templates
• Accounts Receivables setup consists of - Transaction type, Transaction source, System options, Auto – Accounting, Receipt class, Receipt methods
• Worked on Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC
• Extracting various report Data from Discoverer software & Oracle application for Finance team on daily basis
• Monthly Opening / closing of period’s ie in GL/AP/AR modules. Working on Consolidation for Entities lived in oracle Application with Elimination part from KPMG guidelines
• Providing session to New User & Auditors of Oracle Application to help them to Use Oracle Application & Helps Auditor to Audit a Financial of a Particular Entity.
• In all 35 roll outs which consist (end to end Implementation). Helping User in preparing Financial of their respective entities month on month basis with output from Oracle Application.
• Resolving Auditor Query’s which pertains to Migration part ie from Closing Trial Balance from Old Software to New Software (Oracle Application). Working on Oracle Apps 12.1.2 version/Discoverer 11g.
• Checking out for Data from backend by fetching teh data by running SQL queries on TOAD as per user requirement (Finance user needs data dump for accounting purpose providing teh same from backend by running various SQL Quires)