SUMMARY

• Functional support to SOA team to automate and integrate 3rd party applications with Oracle Fusion cloud.
• Financial Accounting Hub and Fusion FAH integration and implementation (ADR, AAD, SLAM, Mapping sets, Ledgers, Event Model, Accounting Events - Journal Pass through and event creations process.
• Used Agile Sprints project methodology to implement Oracle Fusion Cloud Financials/ P2P. JIRA is used to handle issues and user stories to track project work.
• Project Financial Management (Project Foundation, Costing, Billing, Contracts, Performance Reporting)
• Project Execution Management (Project Management, Task Management, Resource Management)
• OUM Methodology - AN100, MC050, TE40 and DS-140
• Extensive familiarity with Application Implementation Methodology (AIM- BP040, BP080, BR010, TA010, BR100, RD20, MD50, TE20, TE40, CV10, CV40 etc.) in different phases i.e. Requirement gathering, Operation analysis, Solution Design, Build, Test, Training, Data Migration and Production.
• Oracle R12 Procure to Pay (P2P): i-Procurement, i-Supplier Portal, i-Expense, Markview 170, AP, PO, INV, Advance Pricing
• Functional Architect Integration with Legacy System and Reporting
• Kofax Markview170 Upgrade from 7.0 to 8.0, Kofax Email server, Kofax Server, Kofax bar Code Server
• Integration of Kofax Markview 170 with i-Expense and Accounts Payables modules
• GAAP, IFRS accounting standards
• Worked for EMEA, APAC and NA regions
• Brazil, Mexico, Chinese and Japanese Localizations and Languages
• Oracle GRC - Application Access Control Governor (AACG), Transaction Control Governor (TCG), Configuration Control Governor (CCG), Preventive Control Governor (PCG)
• AR Deferred revenue and receipts conversions, Event Based Revenue Management & Revenue Contingencies
• Workflow/AME rules/ Transaction account builder/BPM (AMX).

PROFESSIONAL EXPERIENCE

Confidential

Oracle Fusion Financial (FAH), PPM and Procurement Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Leading Contract to Cash track that involves project contract to project billing for Canada and Mexico countries. It involves Project billing, project costing and Financial module along with fusion tax.
• Attended brainstorming and war room sessions to design enterprise structure - Enterprise structure, LE, COA, BU and lay out the business processes.
• Integrations - Cloud to EBS and EBS to Cloud to move expenditure cost as employees in Cloud charge time and book expenses to projects for entities that are not moved to ERP. It involves intercompany billing cross charge transactions
• Designed project hierarchy, account hierarchies (Department, natural account etc.).
• PaaS to SaaS UI pages - to design the online billing process (advance billing, project write off) and project request form (to modify project classification, add/ remove team members using REST API.
• Integrations - Project Task Master, Project Cost and Bill Rates, Project Expenditures - timecard and expense reports, Lockbox, Auto-invoice, Bank Integration - ACH/WIRE, Auto-invoice, etc.
• Data Conversions - Project Task Master Data, Bill Rates, Customer Master, Supplier Conversion, Project Contract Conversion, Assets, Project Billing Event conversion, Open AP supplier invoices, AR Customer Invoices,
• Documented month end procedures for Contract to Cash track, Record to Report, and Procure to Pay tracks
• Designed Fusion Security for PPM and Procurement along with financial applications.
• Implemented expense management and expense management approvals.
• Created test scenario for Contract to cash tracks.
• Conducted CRP workshops and training workshops along with preparing documentation.
• Project Portfolio Management - Implemented and configured project Financial Management (Project Foundation, Budget, Budgetary control, Forecast, Project control, Costing, Billing, Contracts, Burden Schedules, Project Performance Reporting) and Project execution management (Project schedules).
• Project Costing and Billing: Define Bill rate schedule, burden rate schedule, Project Resource Breakdown structure. Used enterprise contract to define project contract billing along with bill plan and revenue plans.
• Enable Cross charging, inter-project, intercompany billing options in projects.
• Implement custom SLA rules for project costing to pick COA segments based on task service type, DFF and expenditure types.
• Configure balance forward billing and automatic receipts.
• Designed approval process for Journal, Expense Management, Payables using AMX/ BPM.
• FAH - source event-based data from source applications EPIC and Eclipse for insurance payments. Enabled multiperiod accounting to generate accruals and revenue recognition.
• Rapid implementation to create source system and source columns.
• OIC to automate the integration - created AN100 functional design document. Configure the SLA rules including SLAM with Multiperiod accounting feature enabled.
• OIC integration to automate the end to end FAH process.
• Implement Asset module - Corporate and tax books.
• Configure intercompany (AGIS) system for Canada and Mexico countries.
• Well versed with Agile methodology processes, JIRA Ticketing cycles.
• Implemented Advance collection – aging methods, customer scoring, strategies, Dunning letters, statement cycle, write test scenario for Advance collections and assist business team in testing the functionality.
• Reporting: SmartView, Financial Reporting Studio (FRS), Oracle Analytical Cloud (OAC), BI & OTBI

Confidential

Oracle Fusion Financial, PPM and Procurement Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Integrating PPM, Financial and Procurement into Confidential Fusion Financial system due to acquisition between Confidential US and Virence. Virence applications integrated with Athenahealth US.
• War room sessions to design enterprise structure – Enterprise structure, LE, COA, BU.
• Data Conversion sessions (FBDI) and requirement gathering session for employee conversion, Project/ tasks conversion, Trial Balance Conversion, Procurement Categories conversion for indirect Purchase and design charge accounting based on Procurement categories using TAB.
• Designed account hierarchy for the financial reports.
• Very good knowledge of REST/ SOAP API web services (JSON format) to develop integration for loading project data, Journal Import, Payable import, Customer Invoices. Used Advanced Rest client (APC) to test REST API.
• Designed project organization hierarchy to secure the project costing expenditure organization and transactions.
• Implemented AR Billing and AR receivables offerings in fusion.
• Functional design for lockbox to create automatic receipts.
• Implemented TCA architecture for CDM (Customer data management).
• Data Conversion – Customer accounts, AR open invoices, Customer receipts, etc.
• Functional design for consolidating billing, BPR (Bill presentment template) AR Aging report based on invoice due date (Bucket 1-30 to 181+ days), Bad Debt Summary Report, Billing correction report, DSO (Days Sales Outstanding) report.
• Month end AR reconciliation process and month end closing period process.
• Configured SLA entries for procurements (TAD, TAB) and project costing module.
• Configure Sourcing for procurements.
• Implementing Punch out functionality for Staples.
• FBDI to upload suppliers, purchase orders, requisitions data as part of the data migrations.
• Configure inventory setups data to define master inventory and inventory organizations.
• Define configuration item models.
• Worked with informatica/ ETL team to design reports for data warehousing and help technical team to design integrations.
• Implemented supplier portal for their external suppliers.
• Lead Project costing, Billing and GL/ AP/ AR/ Expense Management applications.
• Created and designed TO BE processes (RD011) for PPM and financial applications.
• Designed Fusion Security for PPM and Procurement along with financial applications.
• Lead PaaS and SaaS integration with integration team to load data into SaaS cloud.
• Develop BI publisher templates for PO, Check printing and Separate remittance advices.
• Payment reconciliation process (Bank reconciliation) with Bank to ensure timely month end.
• Create business test scenarios for expense management and configure expense policies, expense types, expense categories and integration Projects applications.
• Lay out the month end standard procedure to ensure business users close period on time.
• Data conversion for open transaction, Project/ tasks and historical/ open GL balances using FBDI / ADFDI templates.
• Implemented Bank statement reconciliation process using BAI2 format.
• Design functional speciation document (AN100) for PO document,
• Implemented expense management and expense management approvals.
• (Project Portfolio Management) - Implemented and configured project Financial Management (Project Foundation, Budget, Budgetary control, Forecast, Project control, Costing, Billing, Contracts, Burden Schedules, Project Performance Reporting) and Project execution management (Project schedules).
• Project Contract Billing and revenue management.
• Implemented project grants (sponsored project) – to create award using award template, multiple awards and funding sources, Award project validations, enable burdening for internal funding sources.
• Project Costing: Define Bill rate schedule, burden rate schedule, Project Resource Breakdown structure. Used enterprise contract to define project contract billing along with bill plan and revenue plans.
• Cross charging, inter-project, intercompany billing.
• Implement custom SLA rules for project costing to pick COA segments based on task service type, DFF and expenditure types.
• Create and Design Checks/ PO reports using BI publisher tool. Knows underneath tables for Financials, PPM and Procurements.
• Created and designed OTBI dashboards (create infolets) and provided training to business users to run these reports.
• Develop BI Publisher reports to create Bank format templates, DSO/ Customer Aging/ GL Balances reports. Also worked as an architect for BI Data warehousing solution from Fusion cloud using BI connector tool. Design OTBI reports based on Financial subject areas like Journal Details, Journal Balances etc.
• Created GL, AR, AP Dashboards. For example, AR Dashboard has AR Summary Report, Customer Aging, DSO Summary Report, Bad Debt Report, Cash Activity Report.
• Used FRS and Smart-view tools to define P&L and balance sheets reports for the management reporting.
• Designed approval process for Journal, Expense Management, Payables using AMX/ BPM.

Confidential

Oracle Fusion Financial, PPM and FAH Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Designing of enterprise structure – LE, COA, BU, HCM enterprise information.
• Financials track for Cloud Financials (AP/AR/GL/FA/CM) implementation
• Conducting CRP sessions with key business stakeholders to map the business processes.
• Creating and designing TO BE processes (RD011) for Financials modules and financial accounting hub
• Designed Fusion Security for financial and FAH applications.
• PaaS and SaaS integration to load data into SaaS cloud.
• Good knowledge of REST/ SOAP API web services (JSON format) to develop integration journal details data, FAH, Upload data into UCM server.
• Develop BI publisher templates for Checks, ACH/WIRE payments, positive pay file.
• Payment reconciliation process (Bank reconciliation) with Bank to ensure timely month end.
• Supplier imaging process and invoice routing for AP coding process.
• Lay out the month end standard procedure to ensure business users close period on time.
• Designed OTBI dashboards reports for Financial and fusion accounting cloud.
• Data conversion for open transaction and historical/ open GL balances using FBDi / ADFDI templates.
• Bank statement reconciliation process using BAI2 format.
• Working with technical team to store data to On-prem using BI connector application.
• Design functional speciation document (AN100) for journal import, bank statement loader, supplier invoices etc.
• Implement intercompany process (AGIS) including approval process and revaluation process.
• Used calculation manager to define mass allocation and recurring of journals.
• Designed Supplier portal for external parties to see their payments/ invoices statuses.
• Implemented expense management and expense management approvals.
• Implementing revenue management and collection for customers.
• Implemented Advance collection – aging methods, customer scoring, strategies, Dunning letters, statement cycle.
• (Project Portfolio Management) - Implemented and configured project Financial Management (Project Foundation, Budget, Forecast, Project control, Costing, Billing, Contracts, Burden Schedules, Performance Reporting) and Project execution management (Project schedules).
• Define Bill rate schedule, burden rate schedule, Project Resource Breakdown structure. Used enterprise contract to define project billing contracts along with bill plan and revenue plans.
• Cross charging, inter-project, intercompany billing.
• Implement custom SLA rules for project costing to pick COA segments based on task service type, work type and expenditure types.
• Implement and design COA structure for Primary and Secondary ledgers. Reporting ledger currency feature is used for translation.
• Upload customer master data and auto-invoice to bring customer invoices into Fusion receivables.
• AR bills in arrears and in advance. Auto-lockbox to automate customer receipts.
• Used FRS and Smart-view tools to define P&L and balance sheets reports for the management reporting.
• Designed approval process for Journal, Expense Management, Payables using AMX/ BPM.

Confidential

Oracle Fusion Financial-PPM/ Procurement Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Financials track for Cloud Financials (AP/AR/GL/FA/CM) implementation/ support.
• Worked with GxP, Quality and SOX teams to ensure processes comply with these standards.
• Business support for procurement to pay cycle to business users.
• Created custom roles for procurement users.
• Worked with integration tam to develop integration for loading project data, Journal Import, Payable import, Customer Invoices using REST API.
• Designed procurement Catalog and managed procurement accruals process.
• Support upstream and downstream integrations with third party and bank systems.
• Configured requisition and purchasing document approval rules (AMX).
• Control approvals by amount, business unit, account segment, item, category and location
• Configure procurement business functions and requisition business functions.
• Manage common options for payables and procurements.
• Define inventory organizations.
• Implement advance collection for AR.
• Implemented AGIS and SLA rules.
• Configured Smart form and content zones.
• Configured TAB to derive charge and accrual accounts based on expenditure type.
• Configured SLA rules for invoices to pay invoices having amount greater than 26 cents and project costing rule to derive geography columns based on task service type.
• (Project Portfolio Management) - Implemented and configured project Financial Management (Project Foundation, Costing, Billing, Contracts, Performance Reporting).
• Configured BPM GL approval rules and invoice approval rules
• Standard operating procedures for month end closing process for financials and procurement.
• Managed security roles for financials and procurement module.
• Business flows of financials to business stakeholders.
• Created custom roles in Fusion Security.
• Implemented supplier portal.
• Implemented project grants (sponsored project) – to create award using award template, multiple awards and funding sources, Award project validations, enable burdening for internal funding sources. Project financial management for grants project.
• Worked with QSoftware to implement SOD conflicts.
• Expert in building SLA rules to derive accounting entries on business needs for financials and procurement.
• Implemented and configured enterprise structure, COA Structure Instance, business units.
• FBDi templates to upload data to financial master data like segment values, customer, project budget, GL budget etc.
• Issues are managed through Service Now.
• Migration of FRS reports across environment.
• Chart of account (COA) instance and enterprise structure, Legal Entity, business units etc.

Confidential

Oracle Fusion Financial-PPM/ Procurement Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Conducted CRP1, CRP2, CRP3 and UAT sessions.
• Financials track for Cloud Financials (AP/AR/GL/FA/CM) implementation and upgrade project.
• Implemented and configured P2P cycle.
• Implemented and configured procurement to pay process including sourcing (RFI/RFP/RFQ) of goods/ services including negotiation style.
• Implemented and configured Inventory warehouse management system.
• Implemented and configured intercompany transactions (AGIS) process.
• Implemented and Configured intercompany transactions using SLA rules along with intercompany approvals.
• Implemented and configured revenue recognition process.
• Implemented and configured Journal approval process.
• Implemented fusion tax for P2P.
• Implemented payment and AP invoice approval process in R12.
• Implement and Configured Revenue Management.
• Develop R11 to R12 upgrade strategy.
• (Project Portfolio Management) - Implemented and configured project Financial Management (Project Foundation, Costing, Billing, Contracts, Performance Reporting).
• (Project Portfolio Management) - Implemented and configured project Execution Management (Project Management, Task Management, Resource Management).
• Project allocations on GL account and within projects.
• Implemented and configured SLA rules project allocations and project accounting.
• Implemented and configured Project Costing and Project Billing cycles.
• Implemented and configured capital projects cycles, project performance reporting and project controls.
• Delta training of new processes for example payment approval process.
• Project billing cycle (Contract management, Billing and revenue plan, Contract Lines, Generate invoices and transfer to AR, Generate events and revenues).
• Implemented project grants (sponsored project) – to create award using award template, multiple awards and funding sources, Award project validations, enable burdening for internal funding sources.
• Configured capital projects and integration with fusion FA.
• Configure reference set data for Project Type, Expenditure type.
• Modified Contract workflow using BPM.
• Configure organization hierarchy, Burden schedule and Rate Schedules.
• Multi-currency Translation and Revaluation process.
• Good understanding of security console and developed delta training for business users
• Implemented and configured enterprise structure, COA Structure Instance, business units.
• FBDi templates to upload data to Oracle Fusion Financials cloud like COA segment values, COA Hierarchies, Journal Transactions, Supplier invoices, Asset Transactions, Customer Data, Auto-invoice Import.
• Developed financials reports using FR Studio Reports, Smart view Analysis for Financial Reporting
• BI Publishers reports for check printing.
• Chart of account (COA) instance and enterprise structure, Legal Entity, business units etc.
• Agile project methodology using sprints along with JIRA.

Confidential

Oracle Fusion Financial (PPM) and SCM Cloud Consultant

Responsibilities:

• Work directly with business stakeholders to capture business requirements and provide Fit Gap Analysis and workarounds.
• Conducted CRP and UAT sessions.
• Used Agile Sprints project methodology to implement Oracle Fusion Cloud Financials/ P2P. JIRA is used to handle issues and user stories to track project work.
• Financials track for Cloud Financials and P2P Implementation – MC050
• Implemented and Configured intercompany transactions using SLA rules.
• Ledger Design for Corporate, Statutory and Tax reporting with reporting currency and secondary adjustment only ledgers.
• Implemented Procurement to pay process for service PO.
• Configure procurement categories for service PO.
• Sourcing setup and maintenance.
• Configure PO approval process using BPM/ AMX,
• Integration of Legacy applications to Oracle fusion Cloud.
• Mass Allocation using Calculation manager, Translation – Foreign currency and Revaluation in Oracle GL Cloud.
• Issues are managed through Service Now.
• Configuration of complex Allocation Rules for Facilities, Benefits and IT Cost allocations
• Implemented AMEX Corporate Card Integration with expenses
• Configuration of Approval Management Extension (AMX) Rules for Journal Approvals
• Configured Sub-Ledger accounting rules for Fixed Assets and Accounts Payables
• Design and Configurations of Journal Approval, supplier invoice, and Purchase approval Rules.
• Implemented and Configured Advance collections.
• Responsible for requirements gathering, design, configuration, conducting various test events, issue resolutions and offshore–onsite coordination.
• FBDi templates to upload data to Oracle Fusion Financials cloud.
• Worked with technical team to integrate 3rd party systems upload data (Supplier invoices, customer invoices, Journal import, Customer data, employee data, supplier data etc.) to Oracle cloud using Web services SOA/BPEL.
• Developed financials reports using FR Studio Reports, Smart view Analysis for Financial Reporting
• Design data migration strategy for GL balance, AP Open invoices and Fixed Assets conversion.
• ADFDI to upload value sets, invoices, budget data and other data.
• (Project Portfolio Management) Implemented and configured project Financial Management (Project Foundation, Costing, Billing, Contracts, Performance Reporting).
• (Project Portfolio Management) Implemented and configured project Execution Management (Project Management, Task Management, Resource Management).
• Implemented and configured SLA rules project allocations and project accounting.
• Implemented and configured Project Costing and Project Billing cycles.
• Implemented and configured capital projects cycles, project performance reporting and project controls.
• Project billing cycle (Contract management, Billing and revenue plan, Contract Lines, Generate invoices and transfer to AR, Generate events and revenues).
• Configured capital projects and integration with fusion FA.
• Configure reference set data for Project Type, Expenditure type.
• Configure organization hierarchy, Burden schedule and Rate Schedules.
• Used OTBI and BI Publishers reports for bank EFT/ ACH interfaces and for check printing.
• Chart of account (COA) instance and enterprise structure, Legal Entity, business units etc.
• Accounting Hub Reporting for Cloud Services - Fusion FAH, Fusion Security using OIM/APM, Business Unit, COA, Calendar, ESS Cubes, Account Hierarchies, Smarview, Account Inspector, Hyperion Financial Reporting Studio, (ADR, AAD, SLAM, Mapping sets, Ledgers, Event Model
• AN100 and TE40 for Chase bank printing, Positive Pay file and credit card transactions.
• AN100 for PO print program, Customer Invoice Print

Confidential

Oracle Applications Functional Consultant

Responsibilities:

• Discovery sessions with finance team to know their finance functions- mainly in GL/FA/CM/AR/AP/i-Expense
• Implemented and configured intercompany transactions process.
• Implemented and Configured intercompany transactions using SLA rules.
• Distribute Gap fit analysis with workarounds to fill the gaps.
• Implemented and configured procurement to pay process including sourcing (RFI/RFP/RFQ) of goods/ services.
• Develop standard operating procedure for month end closing to make month end efficient and close on time to produce bottom line reports
• Well versed with AIMS methodology and PM standards to meet project deliverables
• Extensive knowledge of upstream and downstream systems to reconcile and synching of systems
• Conduct CRP sessions with finance business stakeholders and users to map their business processes in Oracle
• Discuss conversion strategy with finance team and laid out a conversion strategy document
• Design Chart of account segments after discussing their business functions and reporting needs
• Setup AME rules for i-Expense approvals based on supervisor hierarchy of TPR organization
• Setup AR/FA/GL modules
• Define cross validations and security rules for users to enter correct code combination rules
• Analyse and design Convert open balances (CV10, CV40) for GL/AP/AR and asset balances for FA
• Load trail balances and asset balances through WEB ADI
• Functional design for ACH/EFT and Positive Pay file
• Functional design for legacy supplier invoices to port to Oracle AP
• Functional design for journal history transactions to port to Oracle GL
• Functional design for BI Publishers reports for customer invoice Print and Customer aging reports
• Conversion for suppliers, customers, Banks, Items, BOM
• WEB ADI to load trial balance and asset balances
• FSG reports for P&L, Balance Sheet and consolidation
• Define contract manufacturer and its related setups like Inventory org, organization parameters and receiving organization
• Conduct UAT and SIT testing cycle to ensure business processes are working as per the business requirements.
• Produce production migration methodology to migrate code from UAT to PROD environments
• Define cost rollups
• Worked with Confidential auditors to comply reporting with GAAP accounting standards
• Modules – AP/AR/CM/FA/GL/AGIS/PO 3PL interfaces
• SLA - Define ADR, Journal Line definition, Define AAD, Sub-ledger accounting method
• Define new ADR rules, Journal; definitions, AAD and SLAM to derive accounting entries from asset category
• Worked with Confidential auditors to comply reporting with GAAP accounting standards
• Modules – AP/AR/CM/FA/GL/AGIS/Subcontracting Module/ BOM/WIP/NVOM, 3PL interfaces