SUMMARY

• I have Around 7 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) 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 all 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
• 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.
• 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.

PROFESSIONAL EXPERIENCE

Confidential - South Plainfield, New Jersey

Sr. Oracle EBS 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.
• 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 & Gathered business requirements for EBTAX.
• 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
• 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 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, and 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.

Confidential -San Francisco, California

Oracle EBS Consultant

Responsibilities:

• As an Oracle Consultant, 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 & 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.
• Extracted 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.
• Defined policies and procedures for test environments, analyzing the environment requirements and working 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.
• 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.
• Incorporated 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.
• Developed, implemented and maintained 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.
• Validated if the 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.

Confidential - Austin, Texas

Oracle Functional 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.
• 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 & Assigned the work from technical and functional perspective.

Confidential

Business Analyst

Responsibilities:

• Conducted detailed Requirement gathering, Confidential Analysis, Impact Analysis by interacting with internal stake holders, business users in understanding their business processes, in understanding their proposed IT system.
• Acquired a strong understanding of Investment Banking and specific knowledge related to Fixed Income, Corporate Finance, Derivatives (e.g. cash flow analysis, duration, credit risk, Underwriter, Bonds, Debentures, stocks, Exposure at default, credit default swap, Interest rate risk, Exchange Rate Risk, liquidity risk, spot rates, forward rates, Call Options, Put Options, Capital Asset Pricing Model)
• Conduct JAD sessions & produce Confidential Analysis & Data Audit Document, create & implement Data Standards & Naming Conventions & Source-to-Target Data mapping document.
• Created specs for the data extraction, cleansing, validation & population using automated Decision Stream scripts.
• Developed activity flow use case diagrams for a module to make the IT team understand the functionality of various scenarios.
• Designed the detailed Data-Models of Conformed Dimensions in the workers compensation subject areas, corresponding to the agent balances & Journal Detail Fact entities.
• Involved in Design mappings, created data flow diagrams and documented the ETL high level and low-level design approach.
• Designed workflows using Informatica Power Centre to perform ETL on the data from the staging area to the transaction enrichment data store and to the compensation data marts.
• Developed various transformations like expression, joiner, and aggregator as per the requirements and executed the workflows and verified the data on data mart.
• Worked with DBA teams to transitional logical data model to physical database design & Very good understanding of Mortgage transactions.
• Document detailed business and functional requirements and enhancement documents after conducting user interviews and performing Confidential Analysis between existing processes and to-be scenarios.
• Used the guidelines and artifacts of the Agile Methodology to strategize the Implementation effort in different iterations and phases of the Software Development Life Cycle
• Effectively priortized requirements in multiple phases which resulted in better requirement management and control
• Developed business Use Case for new product functionality after conducting requirement elaboration sessions with client teams.
• Conduct analysis and feasibility studies to enhance application functionality and improve user experience.
• Lead weekly project status meetings between the project development team, onsite consultants and clients.
• Worked closely with the QA team to help create manual test cases and maintain test plans.
• Coordinate end to end process business process from posting of an open item, return process, installment process, write off etc.
• Responsible for resolving various multiple issues and converging conflicts between requests from various stakeholders.
• Maintained the requirement Traceability matrices (RTM) to track the coverage of Requirements vs designed test cases.
• Created various UML diagrams including Use case, Sequence, Activity Diagrams etc.