We provide IT Staff Augmentation Services!

Oracle Ebs Functional Consultant Resume

SUMMARY:

  • Around 6 years of experience as an Oracle applications (E - Business Suite) Functional Consultant with expertise in Account Receivables (AR), Account Payables(AP),General Ledger, Advanced Global Intercompany Systems(AGIS), iPayments, Cash management(CM), EBTAX and Advanced Collections .
  • Hands on experience in 11i & R12 implementation and roll-out of financial modules like AR,AP,CM, EBTAX and Advanced Collections Modules(Dunning Letter Setup), General Ledger, AGIS and iPayments module.
  • Experience with configuring Account Receivables, Account Payables(AP),General Ledger, iPayments,Cash management(CM), EBTAX, AGIS and Advanced Collections.
  • Worked in 4 end to end implementation projects involving Requirements Gathering, Feasibility Analysis, Development and Configuration, Unit Testing, SIT, UAT and Production Deployment.
  • Designing, developing, customizing and supporting the Outbound Interfaces in Oracle Applications which includes AP and AR modules.
  • Instrumental in mapping/structuring CoA, creating CVR for implementations, Creating SLA rules to meet Business requirements.
  • Have worked in Month End Close and Year End closing process for Account Receivables and Cash Management modules.
  • Worked on Procure to Pay flow, and Order to Cash Flow
  • Complete Life cycle experience of ERP implementations, and custom application development projects.
  • Have working experience on procure to pay and Order to cash cycle flow.
  • Worked on Oracle Forms and Workflow Builder, and XML Publisher.
  • Worked on Oracle Forms Personalization for some custom message pop up as per the client requirement.
  • Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
  • Experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.
  • Experience in Application Object Library (AOL) for registration of Forms, Concurrent
  • Programs and oracle API’s and Menus.
  • Very good understanding of Trading Community Architecture (TCA), P2P and O2C cycle.
  • Worked on Kronos Tool for Time and Attendance Management for different kinds of employees.
  • A self-motivated Team Leader/Member with excellent inter-personal, presentation and technical documentation skills with concern for maintaining quality at all levels.
  • Involved in preparing the Functional Requirement Specification Document depending on the Business Requirements and Components across several releases.
  • Strong understanding of the business requirements and the technical issues.
  • Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to HP Quality Center and HP ALM.
  • Actively involved in testing several components in Unit Testing, System Integration Testing phase and providing support during UAT and post-production.
  • Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
  • Onsite/Offshore co-ordination and ensuring on-time Deliveries.
  • Imparted training to Project Support Team for the understanding of the components across each release.
  • Analyzing Software Defects and performing root cause analysis. Also worked on the fixing of the defects.
  • Worked on the Project Management Tools etc and attended various PL related trainings.
  • Defined policies and procedures for test environments analyzed the environment requirements and worked on getting the same available to the concerned teams.
  • Defined the requirements for the build of Test Environments, keeping in consideration the system functionality and the access security concerns.
  • Managed the QA Configuration and setups and also the Configuration change Process.
  • Reviewed the setups mentioned in Functional Setup documents and audit the configuration and setups done in the test environment and thus performing quality reviews on configuration/ test documentation.
  • Coordinated with the Development and Testing Teams for the cloning/patching/code change requirement in the Test Environments.
  • Was involved in Developing, implementing and maintaining environment schedules for code/patch/cloning and data updates.
  • Tested the environments if all are in synchronization as per the requirement and are secured as per the specification of the Environment. Data are in synch with the Production data and the access is restricted to just the designated associates.
  • Developed queries to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules.
  • Performing the Data Synchronization .Synchronizing The Setup Document with the latest Production data by automating the pull of data extract through queries and linking the document to a hyperlink in the Shared folders where these extracts have been kept.
  • Working on the defects logged by Testing team to setup the configurations in the Test Environments.
  • Creating the PPM( Project and Portfolio Management) Requests to facilitate the code migration across instances.
  • Validating the post clone checklist to ensure the cloning has been done with the update scripts run post cloning activity.

TECHNICAL SKILLS:

Software: PL/SQL Developer, Oracle Forms 6i,Oracle Development Suite,XML Publisher, Microsoft Excel,Oracle Workflow Builder, Oracle Reports 10g, Oracle BI Publisher

Operating System: Windows XP Professional Version 2002, Unix

Tools: PL/SQL Developer,HPSD,TSG Service Now,Starteam,HP Quality Center, HP ALM, Winscp,PS Pad,Application Lifecycle Management, HP Project and Portfolio Management,, BMC Remedy Mid-Tier,Oracle Applications 11i,Starteam

Methods: Software Development Life Cycle(SDLC)

ERP: Oracle Applications 11.5.10, Oracle R12.1.0

RDBMS: Oracle 10g

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Functional Consultant

Responsibilities:

  • Preparing Test Cases for different countries rollout, as per the requirements in BRD.
  • Understanding the Business requirements and testing the functionality for different kinds of Employees (Hourly, Salaried, Time Admin, Manager etc.)
  • Executing the Test cases in SIT phase.
  • Finding Test data using Hyperfind queries in Kronos.
  • Working directly with the users and the clients.
  • Planning and coordinating amongst Team members to distribute the count of Test cases.
  • Doing end to end Testing in the Test Environment.
  • Finding Defects and logging JIRA for those defects.
  • Following up with the Development Team to resolve the Defects.
  • Retesting once the Defect gets fixed by the Development team.
  • Sending the daily report to the clients for status update.
  • Assisting users with the User Acceptance Testing scenarios.

Confidential

Oracle EBS Functional Consultant

Responsibilities:

  • Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
  • Prepared BR-100 for EBTAX, AR, CM, AP, iPayments and GL as per the Setups /Configurations required to separate the business entity from the existing application.
  • Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
  • Documenting the Functional Requirement Specification Document MD50 based on the Business Requirements and Solution Design
  • Worked on ACH Payment Setup, Auto Lockbox, Auto Invoice Setups.
  • Also Worked on setup of Receipt Class, Receipt Methods, Receipt Source, Transaction Type, Transaction Source.
  • Worked on the setup of Withholding Tax, Invoice Match Options, Supplier Setup, Supplier Site creation and creating invoices.
  • Worked on Data Access Set Setup, Definition Access Set, Translation and Revaluation, Subledger setup at different data conversion levels, GL reconciliation.
  • Instrumental in mapping/structuring CoA, creating CVR for the implementations, Creating SLA to meet Business requirements.
  • Worked on doing setup of Ledger, Legal Entity, Security Profiles, Accounting Setup Manager.
  • Defined client requirements in regards to reasons for the change and areas that benefit from new functionality, functionality that is temporarily disabled or has been made obsolete.
  • Worked on the Customer and Receipt and Transaction Conversion for the separated Entity.
  • Worked on Positive Pay File format, Supplier creation, Payment Setups, Invoices creation and payments.
  • Worked on Month End Close Activities for AR and CM modules.
  • Defined and configured E-Business Tax parameters including creation of Regime, Tax, Status, Rate, Rules and enabling and validation of Tax
  • Testing with the unit test cases to validate the setups/configurations and the code changes done in the system .
  • Gathered business requirements for EBTAX
  • Prepared invoices and made payments, ensured that invoice currency and payment currency are the same at Supplier, Invoice and Bank Account levels
  • Created new Bank, Bank accounts and Bank Branches for the Business entity which needs to be separated.
  • Defined Transaction Codes in Account Receivables for the new Business Entity, and the cashflow mappings for the newly created bank accounts.
  • Created Responsibility, Application Users, Security Rules, set up system processing defaults and defined Cross Validation Rules.
  • Worked on creating scoring engine,scoring components, writing template queries, dunning letter templates creation as per business requirements, dunning plan, and collection strategies.
  • Worked on setup of Collector workbench.
  • Worked on migrating the codes and AOL components to different environments.
  • Worked on the defects assigned in Unit Testing, SIT and UAT phase, and get the issues fixed for the components.
  • Trained users the functional changes that they see and work with after the Upgrade which allow them to maximize information processing efficiencies
  • Setting up of Collections process for new Business entity by doing configurations for Dunning Letters, Collection Strategies, Scoring Component, Scoring Engine.
  • Took care of consolidation issues like unmapped and duplicate-mapping of values
  • Created SRs with Oracle and interacted through OWC to let them look at our screens.

Environment: AR, AP, CM, E-Business Tax, Advanced Collections, GL, iPayments

Confidential

Oracle EBS Functional Consultant/Configuration and Environment Manager

Responsibilities:

  • Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
  • Documenting the Functional Requirement Specification Document MD50 based on the Business Requirements and Solution Design.
  • Did Setups in Advanced Collections Module, Account Receivables, Account payables,, Cash Management as per the requirements.
  • Did the setup for Organizations, Transaction Type, Receivable Assignments, Intercompany Accounting, Customer Supplier Relationships, Legal Entity Relationships for intercompany transactions, AGIS system options in Advanced Global Intercompany Systems.
  • Worked on disabling setups of one entity into other environment for data security.
  • Worked on ACH Payment Setup, Auto Lockbox, Auto Invoice Setups.
  • Also Worked on setup of Receipt Class, Receipt Methods, Receipt Source, Transaction Type, Transaction Source.
  • Worked on Data Access Set Setup, Translation and Revaluation.
  • Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
  • Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
  • Worked on creating Score component, score engine, dunning plans, collection strategy, manage template queries and collector workbench.
  • Defining policies and procedures for test environments, analyzing the environment requirements and working on getting the same available to the concerned teams.
  • Defining the requirements for the build of Test Environments, keeping in consideration the system functionality and the access security concerns.
  • Managing the QA Configuration and setups and also the Configuration change Process.
  • Performed the setups mentioned in BR100 documents for physically separating two Businesses which have been using the same ERP implementation. Also, audit the configuration and setups done in the development, test environments and Production environment across the Project phases and thus performing quality reviews on configuration/ test documentation.
  • Worked on the setup of Withholding Tax, Invoice Match Options, Supplier Setup, Supplier Site creation and creating invoices.
  • Worked on creating Receivables activity Refunds, Receipt Write Off and Adjustments.
  • Developed queries in PL/SQL developer to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules (AP, AR, PA, AGIS, Inventory, PO, GL, CM) implemented in the system.
  • Incorporating these queries in a Macro for generating the data records setup in the system.
  • Coordinating with the Development and Testing Teams for the cloning/patching/code change requirement in the Test Environments.
  • Developing, implementing and maintaining environment schedules for code/patch/cloning and data updates.
  • Testing the environments if all are in synchronization as per the requirement and are secured as per the specification of the Environment. Data are in synch with the Production data and the access is restricted to just the designated associates.
  • Validating if the code and Configurations are accurate across all environments as per environment management processes and checklist.
  • Performing Internal Quality Assurance (IQA) of the Technical Design Documents (TD) and Conversion Development Codes prepared by Peers and correspondingly documenting the points not satisfying the Quality norms.
  • Working on the defects logged by Testing team to setup the configurations in the Test Environments.
  • Carried out the following activities:
  • Defining policies and procedures for test environments
  • Managing configuration change process.
  • Performing quality reviews on configuration/ test documentation
  • Testing environment synchronization
  • Validating code and Configurations are accurate across all environments as per environment management processes and checklist.
  • Developed queries to extract the data from several tables pertaining to the Setups / configurations across all ERP Modules.
  • Performing the Data Synchronization .Synchronizing The Setup Document with the latest Production data by automating the pull of data extract through queries and linking the document to a hyperlink in the Shared folders where these extracts have been kept.

Environment: Oracle Applications R12.1.0, HP Project and Portfolio Management, HP Quality Center, Oracle Applications 11i, BMC Remedy Mid-Tier, Oracle BI Publisher, PL/SQL Developer

Confidential

Oracle Technofunctional Analyst- Also a Project Leader

Responsibilities:

  • Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
  • Documenting the Functional Requirement Specification Document based on the Business Requirements and Solution Design.
  • Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
  • Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
  • Did the Conversion of existing Customers in AR as Refund Vendors in the Payables Workbench, allowing the Refunds to be made to them. Conversion activity included development of code in PL/SQL Packages, procedures, functions and creation of Concurrent Programs whose run will ensure the conversion and interface of Customers as Suppliers(Refund Vendors).
  • Automating The Standard Refund Payment Process to call the PAyment Workbench for the Refund Vendors, which had been Setup in AP. Receipts generation and Credit Memo Adjustment in AR was also in scope, thereby integrating both Payables and Receivables Workbench
  • Worked on changes in Oracle Forms. Implemented some logics and triggers in the Form, so as the Form behaves as per the Business Requirements.
  • Have worked on Workflow Builder and triggers.
  • Have implemented Forms Personalization to pop-up an error message to the user on proper validation.
  • Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
  • Documenting the technical changes that would help any person in understanding the technical design end to end.
  • Performed Unit testing on all the developed components before start of SIT and traced out the defects at the earliest phase.
  • Performed SIT Testing for the test of the various components developed in the Release.
  • Provided support to the users during UAT and fixed the defects which they raised in Application Lifecycle Management tool as soon as those were traced.
  • Have worked on the Functional setups required for the functionalities using the implementation of Oracle Applications AP and AR modules.
  • Interacting with client and all stakeholders and providing strategic and tactical directions.
  • Keeping track on Custom Object deliverables, change request, defects and the documentation.
  • Identifying the problem areas in advance and delivers a solution in time to prevent the user getting impacted by the problems.
  • Co-ordination with various teams for resolving Issues and understanding the Root Cause.
  • Ensure deliver of Solution against the defined requirements
  • Assigning the work from technical and functional perspective.

Environment: Oracle Forms, Pl/SQL Developer, XML Publisher, Oracle Applications 11i, Application Lifecycle Management, Starteam

Confidential

Oracle Technofunctional Analyst

Responsibilities:

  • Gathering the user Requirements and analyzing the same by holding regular meetings with the Business Users and the Onsite Team.
  • Documenting the Functional Requirement Specification Document based on the Business Requirements and Solution Design.
  • Extracting test cases from the understanding of the Business Requirement and the components. During implementation of test plan, test scenarios are identified & accordingly test cases are generated with the help of Testify tool. Prepare Test Documents and upload the same to Quality Center.
  • Building up the new setups and functional changes or to align the gaps in the existing setups as per the business requirements.
  • Develop the codes in Pl/Sql packages, procedures, functions, Forms, Reports.
  • Worked on Data Access Set Setup, Definition Access Set, Translation and Revaluation, Subledger setup at different data conversion levels, GL reconciliation.
  • Also Worked on setup of Receipt Class, Receipt Methods, Receipt Source, Transaction Type, Transaction Source.
  • Worked on the setup of Withholding Tax, Invoice Match Options, Supplier Setup, Supplier Site creation and creating invoices.
  • Keeping flexibility in the code so that it can in corporate any change that the Business might ask for.
  • Documenting the technical changes that would help any person in understanding the technical design end to end.
  • Performed Unit testing on all the developed components before start of SIT and traced out the defects at the earliest phase.
  • Performed System Integration Testing of the components and analyze the functionality of the components.
  • Provide Support to the Users during UAT.
  • Provide Support to the users after Go-Live of the Releases till the Post-Production Support period.
  • Providing cutover support before every SIT and Production Go-Live(Raising tickets, supporting DBA for code movement, doing functional setups and performing sanity checks) to ensure a smooth and hassle free cutover.
  • Integrating with other Teams for some components within the Enhancement involving the integration with third party systems like Documentum, IBS, GECARS etc.
  • Imparting Training to the Support Team regarding the understanding of the Functionality and Technical Design of the enhancement as per the releases.
  • Conducting training for users
  • Involved in gathering the business requirements specification, documenting the Functional Specification.
  • Actively involved in testing several components in Unit Testing, System Integration Testing phase and providing support during UAT and post-production.
  • Involved in onsite/offshore co-ordination, deliveries
  • Significant Contribution in tough times to maintain quality and to ensure On Time Delivery

Environment: Oracle Forms,Pl/SQL Developer, Oracle Applications 11i, HP Quality Center, HP Service Desk

Hire Now