SUMMARY:

• A result driven professional with around 9years of IT experience in financial domain (Oracle Implementation, Customization, Development, Reporting, Data Conversion, Interfacing, Upgrade and Maintenance) in Oracle Applications (EBS) R12/11i and Oracle Fusion R9/R10/R11/R12 . Experience in major EBS/Fusion R12 Implementations, R12 Upgrade and 11i / R12 Production Support.
• Commendable Implementation of three full cycles in Designing, Implementing and supporting various Financial Modules including 11i & R12 versions of Oracle Financials: Purchasing (PO), Payables (AP), Receivables (AR), General Ledger (GL), Oracle Transportation Planning(MST), i - Procurement, EBTAX, MFG, HR, Demantra, ASCP, GRP, Cash Management (CM), Fixed Assets, i-Supplier and Supply Chain Management (SCM): including Order Management (OM), Inventory (INV) Advanced Pricing and Shipping.
• Extensive experience in implementing Multi-currency, Multi-org/country solutions within Shared Services environments in numerous types of industries.
• Extensive experience on design documents for Oracle interfaces like Fixed Asset, Auto Invoice, Customer interface, Lockbox, Supplier Interface, Payable Import, Journal Import, Project interfaces, project extensions, and Employee load data.
• Worked as a Senior Business Analyst & Application Tester gathering information from business users for setting up various modules in Oracle applications mainly concentrating on P2P, R2R, OPM and O2C cycles.
• Extensive experience in registering Concurrent Programs, Form, Functions, Menus, Tables, developing Key and Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL) and System Administration in Oracle Applications.
• Expertise in Client Interaction, Requirement Gathering, Process walk through, Mapping, GAP Analysis and Technical Design documentation and Full lifecycle implementations, Upgrades and Production Support.
• Developed Test Plan and Test cases based on the user stories (Functional requirements) uploaded Business requirements, test scenarios, test cases and defects.
• Experience in testing various types of Invoices in like Standard Invoice, Debit Memo, Credit Memo, prepayment, Expense Reports.
• Extensive experience in OBIEE Administration including Migration, Debugging, Optimizing, Performance Tuning and Production Support.
• Worked on BI publisher reports like Overtime, Higher skills in HR/Payroll .
• Proficient with Discoverer & XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experience in Discoverer Administration and User Edition for generating number of complex reports in Oracle Financials.
• Perform application tuning and performance monitoring.
• Experienced in FSM, BPM, IDM, FBDI, and FRS along with Fusion Financials Applications.
• Experience in using and maintaining documentation of Application Implementations Methodology (AIM), SDLC which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE (Report, Interface, Conversion, Extension) components as a part of fit gap analysis, System configuration and testing (BR100, BP 80, BR30, BR 150, MD 50, CV 40 &TE 40), good understanding in various Oracle related products like SQL, PL/SQL, ADFDI and FBDI.
• Worked extensively with development team members in resolving issues while using METALINK (Oracle Support).
• Good understanding in various Oracle related products involving SQL, PL/SQL, Oracle data integration, WEB ADI, OA Framework, Oracle Workflow BPW, Form Builder, Report Builder, XML Reports/XSL Style sheets, Oracle Business Intelligence (OBIEE ) and Oracle Workflow Builder.
• Experienced in communicating effectively with clients to handle business problems, and excellent Organizational skills.
• Having strong experience in Support Life Cycle, SLA management and working with Oracle Product and Cloud Infra support group.

TECHNICAL SKILLS:

Oracle Apps 11.5.9/11.5.10.2/ R12, Fusion Cloud (GL, AP, AR, FA, CM, MFG, HR, Demantra, ASCP, GRP, Payment, SLA, OM, INV, Advance Pricing, HRMS (CRM), E-B Tax); Oracle (11g, 10g, 9i & 8i), Toad, Data Loader, QTP, Visual Basic 6.0, Windows, SharePoint, MS-office, Lotus Notes, Visio, MS Project, MS Team Foundation Server (TFS), Flex Deploy, Metaling.

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Environment: Oracle Fusion Cloud Financials

Functional Consultant

Environment: Oracle Financial Applications Fusion Cloud R12 (Purchasing, Procurement, i-Expenses, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management, R2R)

Roles and Responsibilities:

• Preparing BR100, MD050, TE40, TE50, CRP execution and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps applications.
• Completed Multi-Org configuration by creating a new Organization Structure new Business Group, Legal Entity, Set of Books and Operating Unit.
• Worked on the Configurations of AP, GL, AR, Purchasing and Cash Management.
• Setting up the Ledger i.e. Chart of Account, Calendar, Currency.
• Defining multi reporting Currency, Consolidation, Revolution and Translation.
• Requirement analysis & Solution design for the Consignment Inventory.
• AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources. Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account.
• Setup Oracle Payables includes Payment Terms, Banks and Bank Accounts, Define Quick codes, Define Financial Options and Payable Options.
• AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets. Worked on receipt class, specifying creation method, payment method, clearing method, defining collectors. Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
• Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos.
• I was part of preparing BR100 documents.
• Performing monthly closing process for the financial modules.
• Documented Functional Design, Applications Setups & User Manuals.
• Provided with useful training to the users in GL, AR, OM, INV and PO Modules.
• Worked on Production Support Quarter End / Month End AP Close Issues, which included accounting issues, trial balances Issues, data corruption issues.

Confidential, Des Moines, IA

Environment: Oracle Fusion Cloud Financials

Functional Consultant

Environment: Oracle Financial Applications Fusion Cloud R12 (Purchasing, i-Expenses, Procurement, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management)

Responsibilities:

• Setup custom financial reports in Hyperion using Financial Reporting Studio.
• Setup Interfaces, Reports and Web Services for the synchronization of absence data from Workday into Oracle Fusion.
• Configured Punchout’s with the suppliers and worked on setups in Production.
• Worked on Item Mapping and created Catalogs internally for the business.
• Worked on Setup and configurations of Smart forms in Procurement.
• Configured Contacts and Blankets with the Vendors for CXML- Punchout.
• Trained super users the Whole Requisition and approval process in Self - Service Procurement.
• Setup custom packages, procedures, functions, sequences, triggers, tables and views in Fusion.
• Setup custom job roles and duty roles and assigned to user accounts.
• Managed user security and web services across Oracle Fusion for integration to third party applications.
• Data Conversion by using FBDI & ADFDI templates.
• Customized the applications UI appearance to differentiate the instance and customized the default application logo.
• Setup and load Budgets into Oracle Fusion and built Hyperion reports against budgets data using FRS.
• Setup Balance Sheet report, Overhead report, Management accounts, and P&L reports using Financial Reporting Studio.
• Setup reports with multiple parameters and dependent parameters to update dynamically based on the user logged into the application.
• Setup custom reports in Excel template to fix the Excel merge cell issue and provide the default features of Excel.
• Setup Matrix style cross-tab reports and multi tab custom reports using BI Publisher and Interactive layouts.
• Setup Project Team Member allocation integration to dynamically allocate or revoke Project Team member roles based on the setups maintained in FND Lookups.
• Migration of BPM rules and UI personalization.
• Setup CIP Asset analysis report.
• Setup Delegated approvals report to display Override approvals for purchasing approvals.
• Setup custom report to analyze system performance by listing long running processes in the background.
• Involved in Payment terms, Distribution sets, Tolerances and Expense Templates.
• Involved in configuration web services, custom reports setup in GL, FA and PPM modules using BI Publisher and OTBI.
• Worked on the setups of Oracle General Ledger Cloud - defining ledger configuration, defining ledger sets, data access sets, journal approval rules, mass allocations, revaluation, financial reporting center configuration.
• Performed the task of Uploading Chart of Accounts to load the chart of accounts structure, including segments and value sets from spreadsheet, worked on deploying the chart of accounts, worked on Uploading the ledger, legal entities, and business units, etc.
• Worked on Configure tax setup according to local and international tax requirements in Oracle Cloud Financials.
• Worked in Oracle Fusion Cash Management to create banks, branches, and accounts in a spreadsheet and upload them.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• System has been tested to meet invoice to cash process applying manual and Auto Lockbox receipts, revenue reorganization in Receivables. Reviewed and confirmed location-based tax setups to meet the requirement.
• Analyze and fix the performance issues for large amounts of data in OTBI.
• Unit testing and documentation of custom objects setup, version control into Oracle Developer Cloud and migration of custom objects into other instances respectively.
• Supporting the business users to reconcile and upload the data by using standard Fusion - FBDI and ADFDI templates.

Confidential, New York, NY

Environment: Oracle Fusion Cloud Financials

Oracle Functional Consultant Analyst (AP,AR)

Environment: Oracle Financial Applications Fusion Cloud R12 (Purchasing, Procurement, i-Expenses, Payables, Receivables, Fixed Assets, General Ledger, E-Biz Tax and Cash Management, R2R)

Responsibilities:

• Involved in requirements gathering.
• Involved in conversion of customers, Suppliers, Purchase Orders and Open Invoices data from legacy system to Oracle Fusion applications.
• Involved in the Business Gathering Requirements of Catalog setup and Contacts.
• Prepared (BR100) documents as a Functional Consultant.
• Prepared proof of concepts for inbound and outbound integrations for the client.
• Automated inbound integrations to Fusion applications for General Ledger data for daily sales and inventory stock ledgers using web services.
• Automated the integration of expenses from third party application Concur to Fusion applications using web services.
• Automated integration of Purchase Orders data from Retail Management System and generated Purchase Orders from Fusion using web services.
• Create user accounts and manage user roles assigned and developed custom reports for audit purpose.
• Setup post clone activities after refresh from PROD to staging instances.
• Configured and customized Requisition and Purchase Order approvals and Journal approval processes.
• Setting up the Instance for all financial modules viz. General Ledger, Accounts Payable, Accounts Receivable, Cash management and Fixed Asset.
• Involved in end to end testing of the project centric Procure to Pay and Order to Cash applications.
• Developed user account notification templates in Fusion.
• Developed custom roles according to business requirements.
• Created new AP Check template for US and Canada Bank formats.
• Developed the User Training Documentation in UAT.
• Designed and configured to automatically create Positive Pay and ACH file payment process.
• Involved in automation of outbound integrations from Oracle Fusion for Chart of Accounts, Suppliers, Payment Terms and Customer Credit for credit checking purposes.
• Setup of SFTP server on Fusion to transfer files from Fusion to client server location.
• Setup Sub-Ledger Accounting (SLA) and Fusion Taxes.
• Developed multiple custom BI reports, Dashboards and Analytics in Oracle Fusion.
• Created custom roles and assigned privileges to the user.
• Created (MD050) for functional requirements and (CV040) for conversions and field level mappings documents.
• Defined new scheduled processes and Job sets to run multiple jobs.
• Involved in providing super user training and performed system testing for upgrade from R9 to R10 and R10 to R11.
• Involved in the documentation of R12 updates like Ledger Sets & Accounting Setup Manager, Data Access Sets in GL, MOAC in Sub-Ledgers, Payment Administrator & Suppliers in AP, AP/AR netting in AR, Bank Model, TCA, SLA and so on…
• Release of payments using templets to various suppliers on verification of invoice, purchase orders etc.
• Customized the application with logo and theme for the instance.

Confidential, Miami, FL

Environment: Oracle Fusion Cloud Financials

Oracle Fusion Techno Functional

Environment: Oracle Applications 11.1.3 (AP, AR, GL, AOL, SYSADMIN), BPW Workflow Builder 2.6.3.0.1, SourceSafe, BI Publisher, Oracle 12R, Forms 10g, Reports 10g, OAF, ADF, Putty, FileZilla, Windows XP.

Responsibilities:•

• Understanding the existing business processes including GL, AP, AR, FA, Oracle Fusion OCR process, Streamlining Invoice Approval workflows, BI Publisher reports, Invoice processing, PPR processing, streamlining PPR templates.
• Giving demonstration of standard functionalities of AP, GL, AR, FA to the Business Users.
• Responsible for doing the setups and configurations of the functional areas in Oracle Fusion Financials Management (General Ledger, Accounts Payable, Accounts Receivables, Asset Management).
• Creation of Data Access sets, custom job and duty roles in Security Console.
• FBDI template Load for Suppliers and invoice data.
• ADF DI Spreadsheet loads for Journal, invoices, Daily rates.
• BPM module to setup the Invoice approval and PO approval Groups.
• Invoice Imaging Process to upload the scan invoices to fusion payables.
• Trained end users and internal on fusion AP, GL.
• Worked on BI publisher reports.
• Worked on Project Creation, Financials Offering configuration.
• Involve in Conducting CRP, UAT for business and taking sign - off.
• Involved in Data conversion using FBDI Templates.
• Preparing Configuration documents for Financials.
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing and re-testing while meeting project deadlines.

Confidential, FL

Environment: Oracle EBS

Functional Consultant

Environment: Oracle Applications R12 (AP, AR, GL, FA, BOM, PO, WIP, INV, ONT, OE, WSH,

Responsibilities:

• Involved in the Conversion of Vendors from legacy system into Oracle Applications.
• Customized AR Invoice Report.
• Setup the new instance using create the Responsibilities, Menus, Concurrent Programs, Requests sets and Custom All, Custom Forms and Report Changes.
• Customized reports for Commercial invoice, packing list and PO print standard and release reports, Inventory Item out of stock report, large order, Back order summary and details of (MD050) reports.
• Extensive Experience in OM API's for BPA Price break update, order creation and order-updating.
• Developed Generic Matrix form for order management and Clarifications form for customer support to send emails and faxes with attachments using Java mail to customers.
• Developed film positive process to print custom film imprints on the pens and job traveler report with the order details, components, operations and resources associated to the discrete job for printing the films.
• Implemented MOAC to access data from multiple organizations within the same responsibility.
• Form Personalization done to seeded and custom forms as per client requirements.
• Created Sales orders using CTO items, Pick released and shipped the orders. Generated Invoice for the configured orders by submitting the Jobs.
• Worked on Journal Import Interface, Receivables auto invoice Interface, Customer Interface and Payables Open Interface and customized several other reports.
• Provided user training to the End Users on each component to be used at End user.
• Perform application tuning and performance monitoring.
• Worked on Order management, shipping and Discrete manufacturing modules.
• Developed alerts and distribution lists to monitor process activities.
• Created tar files to promote the CEMLI to other instances for Oracle on Demand.

Confidential, RI

Environment: Oracle EBS

Functional Consultant

Environment: Oracle Applications R12 (AP, GL), Oracle R12, SQL, Forms, Reports 10g, OAFADF, Workflow Builder 2.6.3.0.1, Windows XP.

Responsibilities:

• For purchasing, setup the assigned approval assignments, approval groups and approval hierarchy.
• Setup of AP, Mapped GL Accounts and setup Purchase Requisition form routed in Work Flow for approval, on material procurement set vendor invoice in AP for payment approval.
• Setup the Planning and replenishment tasks for Inventory management on Cycle Counting, Physical Inventory ABC Analysis, and Max-Min Planning.
• Oracle - Customized the existing Auto Lockbox interface and added a new payment type to the already existing two payment types during the Validation steps.
• Interacting with business process owners and steering committee members to expedite the decision on crucial issues and build the consensus on conflicting issues.
• Workflow - Customized the PO approval workflow based on the cost center validation rule setup for client additional requirement.
• Pre-upgrade testing and Post upgrade production live support.
• Involved in upgradation for Purchasing, E-Business Tax, I-Procurement, AP, Inventory, and Procurement Contracts.
• For the organizations, setup of inventory items, got the catalog RFQ, retrieved approval from supplier in R2R cycle and customized the Purchase requisition and auto creation of a standard purchase order by quote to generate receipt.
• Support Production issues on a day to day basis including month end closure p1 issues.
• Define the standard test cases for PO, receipts, invoices, invoice validation/approval, invoice payment and transfer to GL.