We provide IT Staff Augmentation Services!

Sr. Oracle Financial Functional Analyst Resume

Jacksonville, FL

SUMMARY

  • Over 10 plus years of experience as implementing Oracle EBS Financial Functional Analyst, Solution Architect and Lead using Oracle Financial Applications Procure to Pay (P2P), Order to Cash (O2C), Record to Report (R2R), Fixed Assets (FA). Related technologies including Business Process Analysis, ERP Implementation, Business Process Re - engineering, Enhancements, Global Rollouts, Upgrade, Data Conversions Design, Integration, Reporting Design, Extensive User Training and Project Management.
  • Have been involved in multiple implementations from conceptual stage, Rollouts, Production Support, Enhancements and upgrade. Experience in multi org and multi currency implementations of Financial modules in multiple geographies for Confidential Appliances, Confidential, Confidential & Univision communication in Oracle release 11i, R12 & Oracle Fusion Cloud (12.2.6/12.2.5/12.2.3/11.5.10.2/11.5.10/ Cloud R12).
  • Extensive experience and knowledge of Business Processes across the E-Business Suite Financials & Supply Chain modules General Ledger (GL), Subledger Accounting (SLA), Accounts Receivables (AR), Accounts Payables (AP), Financial/Fusion Accounting Hub (FAH), Cash Management (CM), Fixed Assets (FA), E-Business Tax (with 3rd party tax integrations like Sabrix), Revenue Management, Approval Management Engine (AME), Cost Management/Costing (CST), Purchasing (PO), Inventory (INV), Order Management (OM), Trading Community Architecture (TCA), Virtual Trader (VT) & CyberSource Integration.
  • Good understanding of functional flow and Oracle apps architecture of Financial, Distribution, Manufacturing modules, iExpenses, iReceivables, iSuppliers, iProcurement, Advanced Collections, Credit Management, Channel Revenue Management (CHRM/Trade Management), Electronic Data Interchange (EDI), Oracle Business Intelligence (OBIEE), Oracle Transactional Business Intelligence (OTBI) & Localizations.
  • Extensive experience in all stages of the project life cycle of Oracle Financials EBS implementation.
  • Very good exposure to application Implementation Methodology (AIM) prepared various AIM documents including RD050, BP040, BP080, BR.030, BR.100, TE.040, BR150, MD.050, CV.040 and Oracle Unified Methodology (OUM).
  • Possess good working knowledge of SQL, PL/SQL, TOAD, Forms, XML Publisher & Web ADI.
  • Expertise in RICE-W (Reports, Interfaces, Customizations, Extensions and Workflows).
  • Expertise in analyzing current business processes, determining system requirements, reporting needs, GAP analysis, developing customizations and configuring applications to match those needs while incorporating the oracle best business practices.
  • Extensive experience with testing, conducting Conference Room Piloting sessions (CRPs), User Acceptance Testing (UATs), status tracking and production go-live cutover.
  • Extensive experience on MSA projects and resolving issues as per Service Level Agreement (SLA).
  • Very good knowledge on Oracle Standard Reports in Financials and Supply Chain.
  • Very good experience on Consignment, Dropship, and IR-ISO intercompany process.
  • Extensive experience in month end closing of Financial Modules and Reconciliation between Subledgers and General Ledger.
  • Lead the Team, as well as a team player, extensive experience in coordinating and managing with offshore teams.
  • Experience organizing meetings with business and follow-up on pending items with business and other team members to the deliverables within the specified timelines, have done aggressive follow-up with Oracle Technical support for all open service requests to get it resolved within stipulated time to reach timelines.
  • Extensive experience in mapping and integration of Oracle Applications with legacy and Service Oriented Architecture (SOA) and preparation of specifications for development of the required interfaces.

TECHNICAL SKILLS

ERP Versions: Oracle Apps R12, 11i (12.2.6, 12.2.5, 12.2.3, 11.5.10.2, 11.5.10) and Oracle Fusion Cloud R12.

Modules: GL, AP, AR, FA, CM, SLA, AME, FAH, EB Tax, TCA, PO, INV, OM, CST, INV, MOAC, Revenue Management, Advanced Collections, Credit Management, CHRM, iExpenses, iReceivables, iSuppliers & iProcurement

Technology: MS Visio, MS Office, Data Loader, AIM, OUM, Toad, XML Publisher, SQL, Test Strategies (HPQC/JIRA), Web ADI, WINSCP, BI Publisher & OTBI.

PROFESSIONAL EXPERIENCE

Confidential Jacksonville, FL

Sr. Oracle Financial Functional Analyst

Responsibilities:

  • Driving map-gap discussions with business users and document the solution alternatives (7-Ways) to help conclude on the optimum choice, with a goal of minimizing customizations and of long-term sustenance.
  • Preparation of all the Oracle AIM documents in the project life cycle like BP0.040 As-Is process, BP.080 To-Be process, BR.150 Fit & GAP analysis document, MD.050 functional specification & BR.100 Setup documents.
  • Preparation of business test scripts using TE.040 template and testing all business cases in Development instance.
  • Ensure all the accounting and reconciliation checks that are part of the design and period close process are smooth.
  • Developed new reports in Oracle OBIEE for reconciliation, reporting and dashboards for quick view of control accounts balances.
  • Responsible for all Oracle Subledger Accounting (SLA) changes and customization to meet the business requirement.
  • Responsible for end-to-end flow of accounting in all the Oracle Subledger modules.
  • Built alerts in Oracle Alert Management to make sure transactions are recorded to correct account combinations.
  • Involved in resolving any critical issues and helping the customer support team and knowledge transfer.
  • Development of oracle inbound and outbound interfaces to process Legacy invoices to AR, AR open transactions to banks for factoring and Web ADI to create bulk transaction adjustments.
  • Development of oracle AP invoice inbound to create Fedex, service maintenance care, Assurant invoices.
  • Customization of payables EFT and Check payment formats.
  • Automation of manual journal processing using Oracle Financial Accounting Hub (FAH) solution to generate accounting using subledger accounting (SLA).
  • Customized Oracle revenue management process to meet business requirements.
  • Payroll integration to book accruals in oracle EBS General Ledger (GL)
  • Cost of Goods Sold booking based on cost sub-elements and liquidations/reserve booking using Virtual Trader (VT).
  • Customizing the Oracle consignment process between two consignment organizations and AP invoicing.
  • CyberSource integration to enable credit card authorization to process sales orders, AR Invoices and collections.
  • Configuration of Payment Setups related to CyberSource and adding form personalization’s.
  • Testing CyberSource credit card funds capture authorization to make sure setups and integration working as expected and AR receipts creating for the authorized amount.
  • Developed AR invoice print PDF report using different RTF templates based on customer sales channel code and sending to web center through SOA.
  • Integration of oracle payables to make Adhoc payments using oracle APEX module and customization of approval workflow.
  • Integration of oracle order management credit check hold release using oracle APEX module.
  • Worked on EDI 845 (Inventory Finance) & 810 (AR Invoicing), Resolution of incidents by coordinating with integration team in case of failures in EDI file process and mapping.
  • Implementation of GRC controls to restrict AP invoices for freight charges and manual invoice errors.

Confidential | Teaneck, NJ

Oracle Cloud Financials Consultant

Responsibilities:

  • Worked as a primary resource in the Implementation of Oracle Fusion Financials Cloud Applications of Procure to Pay business process.
  • Onsite team lead at the client and coordination with offshore Technical, functional and testing team including woring as liaison between business users, offshore team, helping offshore team to understand Cloud data conversions, customizations, Cloud integrations, execution of test cases across GL, AP, AR, PO, Procure to Pay and Order to Cash modules,
  • Extensively worked on the data security features by configuring Profile Options, CV Rules, Security rules, Data Access Sets, Definition Access Sets and Responsibilities.
  • Worked on End Users Support resolving issues on reconciliations, periodic reversals, Period end procedures and Journal reclassifications.
  • Defined the 1099 suppliers and testing the tax payment extractions for reporting purpose Developing AP, AR,FA and CE Training Guides Setup the Auto Cash rule set according to client requirements Prepared Static and dynamic data template for collecting all the information about the Banks, Vendors, Customers, Tax Codes etc.
  • Performed end to End Configurations of Oracle Payables and Payments modules from BU setups to defining Payables and Financial options, configuring approval hierarchies, Discount terms, Payment Methods, Profiles and others as per the business requirements.
  • Define Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules
  • Involved in setup for Auto Accounting Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Aging Buckets, etc.,
  • Worked on configuring Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Customer &, Sites, Remit to Address, System profiles
  • Involved in understanding of Cloud Financials data conversion requirements for new adding ledgers and Operating units, gathered test requirements, created test plan, test cases, test release cycles, supporting CRP, SIT, UAT, and production cut over planning.
  • Worked on EDI’s 856,753,754,850,855 experienced in verifying the XML CLOB.
  • Prepared training documents and assisted in user training for respective process.
  • Interacted and worked with the development team to solve various code bugs and development of new functionality enhancements required as part of the go-live.

Confidential | Boston, MA

Oracle EBS R12 Functional SME

Responsibilities:

  • Involved in understanding of EBS Financials and SCM data conversion requirements for new adding ledgers and Operating units, gathered test requirements, created test plan, test cases, test release cycles, supporting UAT, SIT and production cut over planning.
  • Solutioned Vendor purchasing process, configured, tested, trained users and delivered the application meeting the business requirements, Working on Setups of Prospective supplier registration, Supplier Life cycle management, iSupplier configuration, Supplier delegated Catalog management in iSupplier
  • Worked on requirement analysis and configuration of P-Card and built custom reconciliation engine.
  • Worked on customizations of Sub Ledger Accounting (SLA) rules - defining sources, events, journal types customizing SLA Rules etc.
  • Analyzed the requirements, performing risk analysis and mapping the business processes. Understanding the gaps, recommended the necessary customizations.
  • Defining intra-company rules Setup International Tax Calculation and defining VAT for multiple countries, Defining System Option Parameters in AR Completed setup and demonstration of handling Refunds Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users Prepare and Configure Setups in Production Instance and Production Support Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module.
  • Performed an end-to-end solution for Procure to Pay by leveraging iProcurement and iSupplier functionalities.
  • Implemented strategies on catalog management. Setup Local content zones and Punchouts in iProcurement.
  • Involved in implantation of Adv Pricing including bulk import of price list, testing Orders with customer specific modifiers/qualifiers and testing end to end Order processing with Adv Pricing formulas
  • Coordination with Sprint releases, UAT, SIT and production cut over planning.
  • Analyzed and decomposed the business requirements to design the test scenarios.
  • Involved in various review meetings with Business, to discuss the scope of testing.
  • Designed requirements traceability metrics to ensure the test coverage.
  • Extensively used HP ALM and created test requirements, traceability matrix, test case repository, release cycles and defect tracking

Confidential, Louisville, KY

Oracle EBS/Cloud Financials Functional Consultant

Responsibilities:

  • Responsible for all setups and configurations of the functional areas in Oracle Fusion Financials Management (General Ledger, Accounts Payable, Asset Management, Cash Management.
  • Designed and developed the Conversion strategy for the client. Worked on the Conversion for AP Suppliers, AP Invoices, Banks and Bank Accounts. Conducted detailed discussion Meetings with Technical Teams.
  • Created Ledger design for Corporate, Statutory & Tax reporting using reporting currency and secondary adjustment only ledgers.
  • Configured and validated E2E (End-to-end) scenarios to demonstrate Payables business flows including Supplier and Supplier site setups, Invoice creation, Payments, Accounting, Cash Reconciliation, Journals Creation, Approvals, Posting to Ledger, AP to GL Reconciliations & defined Period close components.
  • Set-up & tested the Integrated Invoice Imaging functionality to automate AP Invoice processing using OCR & OFR functionality. Configured the Default Business Unit Profile option for a user through DEFAULT ORG ID in the Profile Options.
  • Identified and gathered test requirements to test reconciliation of sub ledgers with GL which includes testing of sub ledger accounting entries and flow, SLA flow, period closing each sub ledgers and GL
  • Modified the Invoice Routing Rule using the Approval Management Extensions (AMX) based on Supplier, Business Unit & Invoice Amount. Defined Distribution Sets for Suppliers.
  • Designed and developed Reports using FRS, BI Publisher and OTBI Analytics, training users.
  • Converted data using FBDI, ADFdi, and UCM controlling extracts and mappings.
  • Established processes for Approval BPM Worklist, Personalization, and Extensions.
  • Managed Inbound and Outbound Integrations using SOA Connectors for bulk loads.
  • Setup Procurement Purchasing, Receiving, and Inventory in line withFinancials. Trained end users and internal on fusion AP, CM.
  • Provided extended support during period closings every month. Proactively monitored and provided the solutions/workarounds to time.
  • Involved in conversion of customers, Suppliers, Purchase Orders and Open Invoices data from legacy system to Oracle Fusion applications.
  • Develop Test Plan based on the test strategy and the requirements.
  • Design, write, review and execute the test cases as per the business requirements.
  • Extensively used HP ALM and created test requirements, traceability matrix, test case repository, release cycles and defect tracking
  • Designed automation test scripts suitable for automation from the manual test cases.
  • Performed Integration, Smoke, Regression, Functional, End to End and system testing on the applications.
  • Attended status review meetings, interacted with developers, architects to resolve the issues.

Confidential, Richfield, MN

Oracle EBS functional consultant

Responsibilities:

  • Worked as ERP analyst and supported Oracle ERP users by resolving day to day transactional issues including helping users to create new suppliers, customers, lock box performance issues, AR auto invoices, Project billing auto invoices to AR and GL period closing issues
  • As part of oracle upgrade team worked and assisted with team to upgrade the Oracle financial modules and Support for AP, AR, FA, CM and GL modules.
  • Identified functional requirements as an input to application design.
  • Performed user support analysis like research solutions to problems, answering client questions, providing consulting and training as required, tracking software and documentation issues.
  • In-depth analysis of the proposed business process changes in the Finance and Procurement areas and clearly define the outstanding changes/work activities the local implementation team lead need to plan and manage 11. .2.x Upgrade
  • Manage technical and functional Pre/Post Upgrade functional steps as recommended by Oracle 11. .x Upgrades.
  • Evaluating the Upgrade process (including development of a comprehensive business case), prepared the Upgrade project plan.
  • Performed the technical upgrade and performed functional Testing (including conference room pilots/test rounds).
  • 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.
  • Identified standard system functionality, analyzed GAP document and designed solutions for GL & AP, PO depending on Business requirement.
  • Resolved many accounting related Recon issues which are included like encumbrance accounting and accrual accounting.
  • Designed test strategy by analyzing MD050/MD070 for all RICE objects across financials modules
  • Managed offshore test resources coordinated with off shore team to execute test cases
  • Worked with business users to gather true business test cases in AP, AR, PO, OM, iExpenses and GL
  • Developed Prenote supplier and supplier bank account validation process as part payables payment process
  • Designed test cases to test complete payment process including Check, Wire, ACH, remittance, positive pay and check reconciliation
  • Extensively used HP ALM and created test requirements, traceability matrix, test case repository, release cycles and defect tracking
  • The application was tested manually (very form, page and suite) and automated.
  • Backend testing was done to verify and validate the data using SQL queries.
  • Attended status review meetings, interacted with developers, Architects to resolve the issues.

Confidential, RTP, NC

Oracle EBS SCM Analyst

Responsibilities:

  • Analyzed and decomposed the business requirements to design the test scenarios.
  • Involved in various review meetings with Business, to discuss the scope of testing.
  • Designed requirements traceability metrics to ensure the test coverage.
  • Extensively worked on testing of implementation of service contracts including warranties, sub scrimptions and third part warranties, including creation of service contract lines, third part contracts, order reconciliation and integration with Oracle iSupplier/AR.
  • Designed test plans/test cases for complete end to end implementation of Procure to Pay and Order to Cash.
  • Created serious test cases and executed to test OM to Project Billing interface to create agreements/funding in billing
  • Worked in an Agile/Scrum methodologies including using JIRA scrum management tool
  • Designed test strategy to test GL and sub ledger reconciliation and period closing process
  • Involved in testing of AR Lockbox interfaces and created UAT test cases for end to end Lockbox processing including data mapping, execution file and receipt matching.
  • The end to end testing includes testing order import interface, OM workflow customization, return order management flow, OM integration with web Order processing, invoice interface to AR, inventory issue/receiving, PO processing based on the order and processing PO
  • Created/ Maintained test documents (Test Scenarios, Cases, Scripts, Plans, and Metrics).
  • Designed a global test strategy to test AR lockbox processing for all operating units
  • Developed test cases for complete SCM process for each ledger
  • Experience in Creation of Test Cases to test the Subsystems connected to eCommerce Storefront.
  • Conducted test case reviews to ensure scenarios accurately captured business functionalities.

Confidential

Oracle SCM BA/QA

Responsibilities:

  • Analyzed and decomposed the business requirements to design the test scenarios.
  • Involved in various review meetings with Business, to discuss the scope of testing.
  • Designed requirements traceability metrics to ensure the test coverage.
  • Designed test plans/test cases for complete end to end implementation of Procure to Pay and Order to Cash which includes Project costing and billing integration with Procure to Pay and Order to Cash
  • Created serious test cases and executed to test OM to Project Billing interface to create agreements/funding in billing
  • Designed test strategy to test Primary Ledger and reporting ledger mapping and period closing process at period end
  • Worked on Drop/ship, ATO, CTO order types and related integrations including Adv pricing modifiers/qualifiers
  • Extensively used HP ALM and created test requirements, traceability matrix, test case repository, release cycles and defect tracking
  • The end to end testing includes testing order import interface, OM workflow customization, return order management flow, OM integration with Opnet, Order processing, invoice interface to AR, inventory issue/receiving, PO processing based on the order and processing PO
  • Worked in an Agile/Scrum methodologies including using JIRA scrum management tool
  • Created/ Maintained test documents (Test Scenarios, Cases, Scripts, Plans, and Metrics).
  • Designed a global test strategy to test AR lockbox processing for all operating units
  • Developed test cases for complete SCM process for each ledger
  • Experience in Creation of Test Cases to test the Subsystems connected to eCommerce Storefront.
  • Conducted test case reviews to ensure scenarios accurately captured business functionalities.

Confidential

Responsibilities:

  • Identified and gathered test requirements to test reconciliation of sub ledgers with GL which includes testing of sub ledger accounting entries and flow, SLA flow, period closing each sub ledgers and GL
  • Develop Test Plan based on the test strategy and the requirements.
  • Design, write, review and execute the test cases as per the business requirements.
  • Designed test strategy to test GL FSG reports
  • Successfully tested complete process flow in Oracle Financials and SCM including Inventory costing process and transferring to GL
  • Extensively used HP ALM and created test requirements, traceability matrix, test case repository, release cycles and defect tracking
  • Worked in an Agile/Scrum methodologies including using JIRA scrum management tool
  • Collaborate with Developers, Program Managers, Testers and Production Support Engineers
  • Designed a test data templates and created test data in HRMS to test day totransactions which includes hiring employee, running new hire interface, running re-hire job, termination, work location change, payroll tax calculation and costing to GL
  • Worked with Development team as part of RICE objects test requirements gatheringand test plans predation
  • Well versed with Oracle Applications AIM methodologies (BR 30, MD 050, MD070 and TE 10 to TE 30)
  • Developed a test case using BR 30, MD 050 and AN 100 as part of RICE objects testing process.
  • Created and tested the testcases for modules such as Oracle Advanced benefits(OAB)including the life events testing, plans and programs, certifications, Enrollments, Rates, suspended and interim coverage Plans, EOI
  • Reported bugs using Quality Center and generated the defect reports for review.
  • Retested the defects fixed and updated the status accordingly.
  • Performed back-end testing on the Oracle database by writing SQL queries.
  • Designed automation test scripts suitable for automation from the manual test cases.
  • Performed Integration, Smoke, Regression, Functional, End to End and system testing on the applications.
  • Performed Regression Testing on weekly builds.
  • Attended status review meetings, interacted with developers, Architects to resolve the issues.
  • Provided a solution to add custom rows in Horizontal plan view of BOM.
  • Provided a custom solution to honor Sales order- WO linkage in BOM Pegging.
  • Provided a solution to run BOM Plans in parallel in different Lower Instances.

Hire Now