We provide IT Staff Augmentation Services!

Oracle Ebs Business Analyst Resume

SUMMARY

  • 13+ years of experience with Full Life Cycle Implementations Modules General Ledger (GL), Accounts Receivables (AR), Accounts Payable (AP), Advanced Collection (ICX), Cash Management (CE), Oracle Lease and Finance Management (OLFM), Contract life cycle Management ( OLFM), Fixed Assets (FA), Inventory (INV), Purchasing (PO), Order Management (OM), Advanced Pricing(QP), Channel and revenue Management (Claim and Deduction) Sub ledger Accounting(SLA) in 11i and R12 and Fusion Cloud Financials.
  • Perform Requirement gathering, Analysis, Solution Design, development, Implementation, Trouble Shooting (Root cause analysis) in production Support and Rollout and Implementation projects relating to O2C and P2P.
  • Well versed with all phases of Software Development Life Cycle (SDLC) methodology (such as Requirement, analysis, design, data modelling, business process modelling, implementation and Deployment), Waterfall and Agile Methodologies and Oracle Methodologies (AIM, OUM).
  • Having experience in managing and lead the projects and production support engagement from onsite - offshore model.
  • Understand the AS-IS situation document the TO-BE in an appropriate form, e.g. process flow, use case diagrams Conduct the requirements elicitation activities
  • Produce the conceptual design, a detail-level design document which captures all requirements.
  • Experienced in preparing Use Cases, diagrams (Activity, Class, Sequence), Business Requirements Document (BRD), Functional Requirement Document (FRD), Requirements Traceability Matrix (RTM). Experience in conducting SWOT Analysis, Cost Benefit and ROI Analysis.
  • Hands-on experience in working with Agile-Scrum development process. Worked closely with Product Owner, Scrum master and technical team to meet the objective of the project timelines.
  • Excellent oral and written communication skills with a demonstrated capability for dealing with all levels of client management personnel and staff.
  • Good understanding and Knowledge and exposure to ERP solutions - SAAS solutions and PAAS Solutions environment.
  • Executed the project life cycle, including requirements gathering, design, testing, implementation and documentation, as required.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specification for the product.
  • Understanding of ITIL concepts - handling incident, service request, change management and problem management.
  • Proficiency with SQL queries to perform Data Validation and Back end testing of databases to check the integrity of data.
  • Worked with cross-functional teams CEMLI (Conversion, Extensions, Migration, Interfaces, and Localization) analysis and remediation.
  • Proficiency with SQL queries to perform Data Validation and Back end testing of databases to check the integrity of data.
  • Good knowledge on Application Security. Ability to map Business processes in EBS Application.
  • In-depth understanding of Oracle database structure, table dependencies, and data elements. A good working knowledge of system architecture expected.
  • Experience on EBS SOA web Services testing Using SOAP UI/REST (POSTMAN) Tools in Fusion middleware.
  • Strong experience in preparing the cut over plan and conversion strategy during production go-lives.
  • Develop custom queries on need basics and provide extract to Global business users (US, Europe and APAC)
  • Proven ability to effectively prioritize workload and meet SLAs.
  • Extensively worked on TAR (SR) Creations using Oracle Metal ink and Coordinating with Oracle Duty mangers.
  • Experience in working in ASM Projects- Managing Multi Stakeholders, Multi IT Set Up, Processes and Procedures.
  • Expertise in organizing Conference Room Pilots (CRP) and User Acceptance Test (UAT).

TECHNICAL SKILLS

OS: Windows, UNIX.

GUI: Ms Excel, MS Word, MS Projects, Ms Visio, PVCS, Jira, Clarity, Service Now, Field Glass.

Tools: Toad, HP Mercury quality centre 9.0, SOAP UI, and QTP, REST Client (Web service testing).

Other: SQL, PLSQL, BI Publisher, ADFdi, FBdi, Oracle Business Intelligence, OTBI Reporting.

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Business Analyst

Responsibilities:

  • Configure R12 Environment and Functional setups and involved in Data Conversions and resolving issues after Post production support in Functional business areas In Procure to pay.
  • Setting up Ledgers and legal entity and operating untis s, and User management, creating responsibility and assign responsibility profiles including MO operating unit and MO security profiles(MOAC). Creating user roles using user management Assign the roles to the user to perform AME and Force approval roles to perform business functions.
  • Designed Functional solutions for CEMLI objects (Conversion, Extensions, Migration, Interfaces, and Localization) objects relating to Payable conversion and Purchase order conversion and Oracle Assets ( Acquisition assets Via Mass addition Web ADI)
  • Setups related to Inventory Org, Purchasing and payables, and Receivables Direct Debit payment process and Lockbox payment process and Receipts class and Receipt sources. Banks and branches and Purchasing and Payable modules.
  • Extensively worked on TAR (SR) Creations using Metal ink and Coordinating with Oracle on-demand Hosting teams on patch testing, diagnose and debug problems, work with Oracle support to resolve issues.
  • Attend code review meetings with development with off-shore teams and weekend support for Monthly end closing.
  • Documentation and review of test scripts (TE30) (TE20), testing and facilitating UAT for user approvals.
  • Prepared and continue updates (new changes) all necessary documentation including - BR100 (Configuration), MD50 (Functional Design), TE30 (Link Test Script), TE40 (CRP Test Script). Defining the detailed test approach. Updating the Requirements Test Traceability Matrix (RTM) Defining level of test activity via the Software Test Description for Individual Component Validation (ICV) and Component Integration Test (CIT). Establishing test environments and Staging test data if required and Validating compliance with test entrance and exit criteria and Managing defects.

Environment: Oracle E-Business Suite 12.2.7

Modules: General Ledger, Receivables, Payables, Inventory, supplier, Purchasing, Procurement, Order Management, Fixed assets, EB-Tax, Oracle TCA, and HFM (Sales Force Integration with EBS and SOA integration with EBS).

Tools: Remedy, HP ALM, SQL Developer, Desktop Integrator. APIWizard.

Confidential

Oracle Cloud Financial Consultant

Responsibilities:

  • Perform Requirement gathering with the business users and prepared the necessary BP documents. Perform As-is analysis current version of EBS system.
  • Perform business process mapping, fit/gap Analysis, finance business processes re-engineering and solution designing
  • Configure Fusion Functional Setup Manager and applications Configurations RBAC Roles(Users and Employee roles assignment for implementation role assignment).
  • Setting up the Fusion environment for Financial modules GL, AR,AP,CM,FA - Application implementation role.
  • Ledgers and legal entity and business units, and User management, Assign the roles to the user users to perform business functions.
  • Setting up the application setups by using ADFDi utility and converting data by using the FBDi (File based data integrator).
  • Familiar FBDI templates data loading using UCM and Enterprise Scheduler services (ESS)and. validate the relating configuration to support end to end.
  • Using Oracle cloud integration (OCI) approach to process the data file loads into the application.
  • Generating custom OTBI reports and Business intelligence reports.
  • Tested various integration between Cloud with external systems (SFDC, Workday) integrations.
  • Configuring GL - Value sets, COA Structure and Instance, Accounting Hierarchy, Create Account Combination, Define Cross-validation Rules, Calendar, Currencies, Conversion Rates Type, Daily Rates, Ledger, Ledger Options, Legal Entities and Balancing Segments Assignments, Complete the Ledger Configuration, Data Access Set Security, Allocation Rule an Account Group.
  • Configuring Business Units and Reference Data Sets. Configuring Fusion Payables - Suppliers, Create Payment Term, manage invoice options and payment options Configuring fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request and custom check printing.
  • Configuring Fusion Receivables - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class.
  • Configuring Fusion payments - Receivables - Payments for funds Capture Activities, Setting Up Funds Capture for Receivables.
  • Converting Master data for Payable invoices and AR Transactions and receipts processing using FBDI templates and. validate the relating configuration to support end to end Integration.
  • Familiar FBDI templates data loading using UCM and Enterprise Scheduler services(ESS)and. validate the relating configuration to support end to end.
  • Implement EPBCS Model OOTB For Financials cycle Gathering requirement understating how to generate income statement and expenses and revenue and enabling all enterprise cloud implementation Features for Financials.
  • Prepared BR100, MD50 and TE40 documents.
  • Prepared process flow training document to the users with step by step process.
  • Performed CRP1, CRP2 and UAT testing with business and get the signoff.

Environment: Oracle Cloud Financial r13(SaaS).

Modules: General Ledger, Receivables, Payables, Assets, Cash Management, Fixed Assets, Financial Reporting.

Tools: ADFdi,Rapid Implementation(RI), FBDI(ICS), OTBI, EPBCS, Business Intelligence, Remed y, HP ALM.Service Now, Jira.

Confidential

Lead EBS Functional Consultant

Responsibilities:

  • Design solution for data conversion from SAGE X3 ERP to EBS R12. Modules involved are AP, AR, GL and Fixed Assets interfaces (3 Outbound & 3 Inbound), which would run on automatic basis to import data from Legacy.
  • Designing the Data Conversion approach and procedures
  • Inbound Interfaces - GL (All non-AP/AR batches from Legacy), AP and AR Interfaces - Supplier, Customer and Customer Balances (Consisting of transfer on Enact Receipts & Receipt Application Data to Legacy for Credit Check purpose)
  • Writing functional design documents(MD050) and Test scripts
  • Interact with business and technical team for requirements & analysis respectively and Managing & guiding offshore support team for development and support activities. prepare UPK training documents and involved in User training in R12 Financials.

Confidential

Lead EBS Functional Consultant

Responsibilities:

  • Rollout to multiple countries and support project for new organizations deployment in Multi org environment with multiple OU.
  • Worked with Global business users (US, Europe and APAC) Business users understanding their business process and prepared Requirement gathering Documents and work closely work with regional's BSA and User requirements. Addressed all Change requests as requested by the business.
  • Involved of the R12 Upgrade version from 12.2.3 to 12.2.5 and post production support by doing Hyper care and Monitoring the Remedy Ticket based production issues on OTC Work stream...
  • Perform fit gap analysis, solution design, prepare process flows, conduct pilot sessions, configuration, create functional specifications, testing, user training, deployment and support
  • Designing Interfaces, Reports, Workflows for various business requirements designing the Data Conversion approach and procedures.
  • Writing functional design documents(MD050) and Test scripts and Interact with business and technical team for requirements & analysis respectively and Managing & guiding offshore support team for development and support activities.
  • Primary point of contact for operations for various Regional business analysts for various work streams for implemented countries IT Business team coordination on the requirements and enhancements changes and production related issues.
  • Setups for AR module related setups including customer setups and Auto invoice, Lockbox. Banks and branches and worked on custom customer statement related setups.
  • Good exposure on Open interface on AR Auto invoices issues and fixing them and troubleshoot the issues.
  • Good experience on Credit card payment processing and AR payments in compliance with PCI and credit card encryption and decryption and coordinate with Chase payment gateway testing.
  • Responsible for providing a global solution on 'Negative yield credit memos’ and Golden tax adapter(GTA) for China for tax invoices localizations through functional designs (MD50) for Caterpillar specific customizations, custom reports, interfaces and integrations for business operations and Accounting.
  • Identify and document the requirements working with users and Develop process designs and adds new system configurations to enable designs
  • Standard Operation Procedures and Reporting Requirements by performing Best Practices envelop Application Accounting Definitions (AAD), Journal Line Types (JLT), and Journal Line Definitions (JLD) to build proper accounting rules across all sub-ledgers
  • Provide expertise to review existing account generators and rules and recommend improvements based upon "best practices" and R12 functionality for the Sub-Ledger Accounting (SLA) rules
  • Provide expertise to review and recommend customer fit and improvements based upon "best practices" and R12 functionality for at least one of the following business process flow areas Procure to Pay and Financial Reporting and Month and Year End Closing
  • Extensively worked on TAR (SR) Creations using ORACLE Metal ink and Coordinating with Oracle on-demand Hosting teams on patch testing, diagnose and debug problems, work with Oracle support to resolve issues.
  • Conducted project review on daily basis to meet the project plan as scheduled and CCB and SWAT meetings.
  • Attend code review meetings with development with off-shore teams and weekend support for Monthly releases.

Environment: Oracle E-Business Suite R12.0.1.3 upgraded to 12.2.5

Modules: Service contracts, inventory, Order Management, procurement, General Ledger, Receivables, Oracle Treasury, Payables, Fixed assets, EB-Tax, SOA Gateway, Oracle TCA, and Sales Force Integration with EBS

Tools: Toad, UNIX, SOAP UI, Remedy, HP ALM, SQL Developer.

Confidential

EBS Functional Consultant

Responsibilities:

  • Support key business owners and users of IT applications to understand the requirements and address in IT Governance.
  • Responsibilities include setup and testing all of GL encumbrance Accrual, Contracts, and Accounts Receivable as setups and Integration and validate the GL integration with BRM process end to end and support and testing integration with Chase Payment and ACH payment processing and workday Integration.
  • Knowledge on revenue reorganization core principles on 'Revenue from Contracts with Customers’ for generating statutory reports ASC 606.
  • Testing various integration using FWM on EBS SOA web Services testing Using SOAP UI Tools for customer accounts and GL conversion, BRM GL integration and other integration.
  • Support issues related Mark view - AP invoice automation of invoice processing to reduce cycle times, eliminate lost and misfiled.
  • Responsible for providing Support Golden tax adapter(GTA) for China for tax invoices localizations and coordinate with Oralce on various patch issues.
  • Cloud Usage billing testing for - Cloud accounts and dedicated accounts by EBS Monthly Billing.
  • Designing the system landscape while trying to remove existing legacy applications by using Oracle Standard functionalities
  • Requirement gathering and discussing fit/gap with client approval
  • Doing configurations, documentation of setups, and conducting CRPs/SITs/UAT during testing activity.
  • Integration testing for the Field Glass testing for external resources for Expenses.
  • Requirement gathering and solution design for customizing the Financial Analytics OBIA reports.
  • Setup Cash application process for - Lockbox’s and bank statements for direct debit payments.
  • Work with the offsite and Offshore based teams to coordinate Incident management, development and issue or problem resolution and Coordinate with business users and prioritizing the incidents and assign to offshore teams.
  • Functional requirement gathering Integration between BRM GL to EBS (Process Journals using PIP)
  • Vertex implementation for Oracle payables Test and validate the business requirements and worked with vertex team for Use tax.
  • Hosting teams on patch testing, diagnose and debug problems, work with Oracle support to resolve issues
  • Support Functional testing and Patch testing create test scripts and testing the fixes.

Environment: Oracle E-Business Suite R12.0.1.3

Modules: Oracle Receivables, Receivables, Oracle Payables, procurement, supplier, Oracle General Ledger, Service contracts, Oracle TCA, Workday Integration, BOM, WIP, Oracle BRM-EBS (GL Integrations), FAH, Vertex (Integration O Series Payables), AME, SOA 11G (Web services Using SOAP UI), Product Data Hub (PIM)

Tools: Toad, UNIX, SOAP UI, QTP, and Service Now.

Confidential

Functional Consultant

Responsibilities:

  • Work with the offsite and Offshore based teams to coordinate Incident management, development and issue or problem resolution.
  • Responsibilities include setup Payables and testing and Integration and validate the conversion process end to end and support Auto lockbox process.
  • Tracking Defects or incidents in Jira and assign incidents to resources on each P2P - Payment collect process.
  • Coordinate with business users and prioritizing the incidents and assign to teams.
  • Extensively worked on TAR (SR) Creations using ORACLE Metal ink and Coordinating with Oracle on-demand Hosting teams on patch testing, diagnose and debug problems, work with Oracle support to resolve issues
  • Support Regression Functional testing activity and create test scripts in Jira and track the tickets and testing the fixes.

Environment: Oracle E-Business Suite R12.0.1.3

Modules: Oracle Receivables, Oracle Payables, Cash Management, Order Management, Oracle TCA.

Hire Now