SUMMARY:

• Around 10+ years of experience as Oracle ERP Applications Functional & Automation QA Lead Consultant/Functional Consultant.
• Good Functional knowledge in Purchasing (PO), iProcurement, Inventory, General Ledger (GL), Account Payables (AP), Time &Labor (OTL), Account Receivables (AR), iSupplier, iExpenses, Projects (PA), Inventory, OM, Cash Management (CE) in R12, R11.5.9 and R 11.5.10.2., Peoplesoft.
• Involved in Integration Testing, Regression Testing, UAT, Production Support involving Agile and Waterfall SDLC methodologies.
• Hands - on experience with SOAP UI for API testing of web-based applications and related Web Services.
• Support of production and test instances for upgrade/regression/integration/User acceptance testing (UAT).
• Trained users and developed material.
• Involved in identification of test scripts for automation and setting them for execution using Eclipse Test Factory, Selenium Web Driver 2.0 and HP UFT 11.5, TOSCA.
• Experience with testing mobile apps and Retail Loyalty Rewards program integrated with POS for smartphones.
• Good understanding of Cloud Computing and Webservices including Amazon Web Services (AWS)
• Hands-on Experience in the upgrade of Oracle Applications from 11.5.10 to Release 12.0.6 (R12) to the current Oracle Fusion Cloud 12c and testing of Java-based applications.
• Good working knowledge and well-versed with testing CRM applications using SFDC (SalesForce.com) involving SaaS and PaaS
• Worked in diverse industries involving banking, healthcare, Government, Pharmaceuticals, Media and Communications, Automotive etc.
• Experience includes wide areas of responsibilities ranging from Client Interaction, Requirement Gathering, Process walkthrough, Functional Mapping, GAP analysis and Functional design documentation.
• Good understanding of integration between Oracle Financials applications within eBusiness suite and with Legacy and third party systems.
• Excellent knowledge in concepts of Multi Org Access Control (MOAC), Sub Ledger Account (SLA), Multiple Reporting Currencies and Flex field setups.
• Good understanding of OBIEE Reports for Finance.
• Good Understanding of System Administrator, Application Object library concepts, Project Scope and the Implementation methods to be followed.
• Used TFS/MTM tool for storing and archiving test artifacts, Projects documentations at Confidential .
• Completed End-to-End Implementations Testing on Oracle applications R12 and 11i
• Worked on non-Oracle ERP system AMS Advantage FMS/2 and FMS/3 for Budgeting and Accounting.
• Involved in EDI testing related to Paper bill generation for large volume Commercial customer accounts.
• Involved in indirect EDI testing using VAN partnering with Kofax
• Performed ecommerce and Web Content Management (WCM) and Bering Media B2B testing for real-time updates on customer accounts and location (geography-based) advertisements' display respectively.
• Involved in ETL testing using Informatica.
• Strong track record for developing innovative solutions and exceeding client expectations.
• Involved in customizations, project management, requirement analysis, flow designs and testing.
• Extensive understanding of business and accounting in the context of information systems.
• Strong presentation skills and the ability to communicate at different levels within the organization with exceptional problem solving and analytical skills and ability to work in a fast-paced and team-oriented environment.
• Functional understanding of the workflows and its underlying code.

TECHNICAL SKILLS:

Oracle Applications Experience: PTP, OTC, PO, OTL, OM, INV, FA, AP, AR, GL and CM

Oracle iModules: iProcurement, iExpenses and iSupplier, Oracle Time and Labor

Process Areas: Order to Cash, Finance Processes, Procure to Pay, B2B validations

Oracle Tools Experience: PL/SQL, SQL*Plus, FNDLOAD, ADI, Workflow Monitor

Operating System Experience: Windows 7/XP/2000/NT/98, MS-DOS

Other Tools Experience: TOSCA, Mercury Test Director, HP Quality Center, Application Lifecycle Management (ALM), IBM Rational ClearQuest, JIRA, BMC Remedy, Toad, SQL*Loader, Data Loader, Informatica, Parasoft SOA 6.2 for Webservices, Voice Manager, Oracle SQL Developer, AMS Advantage FMS/2 and FMS/3, MS Office, MS Projects, MS Sharepoint, MS Visio Professional, MS Access and various Legacy and proprietary tools.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Sr. Automation QA Lead

Responsibilities:

• Involved in Designing and testing of Oracle 12c Fusion for PO, AP, PA, FA, GL, OM, INV and AME Workflow.
• Reviewed Functional Documents, Test Schedules, Estimation, Test Strategy, Test Plans and Test Summary Documents.
• Involved in Agile API testing using SOAP UI for various web-based applications and interfaces related to manual and automation test scenarios.
• Triage any business issues related toOracleSOA, Order Entry, Order Fulfillment, Invoicing, Customer and tax issues.
• Work on identifying root causes and temporary fixes for post-go live support scenarios.
• Assist users with UAT/Pre-Go-Live/Post-Go-Live support for new functionality introduced.
• Interaction with clients, customers, 3rd party vendors, functional teams, development teams, code deployment teams.
• Designed SQL queries to validate key database table values in Oracle TOAD 12.6.0.53 related to earning and Redemption of Rewards Points, Airmiles, Cashback, Account Statuses, Past-Due, Collection Flags generated as a result of Automated testing to the Credit Card Rewards redemption portal and secure CRM repository.
• Performed Tests and Defects Management using Tricentis TOSCA and for publishing test results and progressions.
• Identifying functional process scenarios to be automated in Test Environment using Eclipse Test Factory.
• Involved in allocation of Test case design assignments, periodic reviews of QA Analysts performance and Auditing of test results and test deliverables.
• Reporting daily onsite QA activity logs, task assignment, reporting, and issue-analysis triage with offshore Development teams using JIRA in Agile setup
• Provided functional and process know-how to QA Analysts in order to assist in Test Cases creation as per the Test Plan to ensure full coverage of possible test scenarios.
• Involved in suggesting and staging Negative test scenarios for credit cards processing.
• Designed and tested all Reports, Interfaces, Conversion, Customizations and Workflow functionality (RICEW) related to Credit Cards Rewards Processing for a major bank with operations in US and Canada.
• Handled monthly releases related to Order Management functionality such as Enter/Book the Blanket Sales Order, Hold/Release Sales Order, Cancel Full order or Line, Verify On hand/Reserve quantity, Pick Release, Perform Ship Confirm, Perform Receipt Process, Receiving, Sales Order Freight Carriers, Cost Types, Document Sequence Number, Document Categories, Shipping Parameters, Items, Items Categories, and Pricing setups.
• Testing of Item creation, Item categories and catalogs, cycle counting, in Oracle Inventory module.
• Testing of Order Management setups, to include Sales Order (Reservations, Pick Release, Pick Confirm, Receipt, Exceptions: Unreserved, Backordering, etc.)
• Tested core AR setups and helped customize Standard Invoice and receipts to streamline the Order to Cash invoicing and receipt processes.
• Configuration testing of transaction types, sources, receipt classes, banks and bank accounts.
• Involved in Interface and Conversion testing using front-end web application and back-end SQL validation using Oracle Toad.
• Involved in designing various SQL queries to pull data with regard to invoices, customers, order source and validated data integrity by conducting back-end table validations.

Confidential, Portland, OR

Sr. CSS QA Lead

Responsibilities:

• Involved in data collection, and supporting API testing using SOAP UI (request and response verification), UAT testing, including creation of material for smooth testing involving new business users, current and future.
• Used TFS/MTM tool for storing and archiving test artifacts, Projects documentations and updating revised test documentation with correct versioning.
• Managed a team of testers for writing area-wise Test Plans outlining detailed scenarios from Requirements and Design use cases for an in-house CRM application development and deployment used by Customer Service agents real-time and website changes related to secure utility accounts for consumer and commercial accounts across 6 States.
• Responsible for managing and reporting test execution, test artifacts maintenance, defect logging, tracking, follow-up, updates, retest and closure (Defect management) in web-based ALM 12.2 (SaaS provided over HP cloud)
• Oversaw Testing of paper bill generation verification with Xerox for EDI customers post completion of batch job billing cycle close process.
• Test Planning, creating and executing test cases for current and new design changes to a critical Payment portal area linked to customer accounts deployed over Amazon Web Services (AWS).
• Core member of the Web testing team involved in data mining, data validation, functional, regression, UI and Load test execution within secure customer accounts for critical online billing and statement generation components.
• Involved in writing complex SQL queries for database validation of values to be in-sync with on-screen customer interface.
• Creating and executing test cases for current and new design changes to a critical Payment portal area linked to customer accounts.
• Test Planning, creating and executing test cases for new design for billing statements provided as email attachment to customers
• Quick learner of legacy and proprietary IT systems and able to train and mentor new hires on various components of the applications to bring them up to speed to meet testing deliverables.
• Involved in identifying and outlining functional and regression test scenarios and setting them for automation using Selenium Web Driver 2.0
• Performed automation test execution in HP UFT 11.5
• Responsible for validation and reporting of test results with QA team and project management.
• Performing critical Regression and Back-end testing on CSS databases: IBM DB2 using SQL and IBM Mainframe application CSS.
• Testing of Agent portal for the CRM application functionalities with CTI phones in Lab to simulate real-time production scenarios and obtain results and validation of field-level data values for Contact History.
• Performed various regression and stress testing as a part TIBCO web server failover and Exception Handling.
• Strong involvement in System Integration testing, Load testing, Batch Jobs testing, User Acceptance Testing.

Confidential, Boca Raton, FL

Oracle ERP Financials & SCM Functional QA Lead

Responsibilities:

• Working as an Oracle Financials Functional QA Lead and implemented Oracle ERP up-gradation from 11.5.10.2 to R12.0.3 and was responsible for GL, AP, PA, FA, iProc, iExpenses and modules from just after CRP1 Phase, SIT, UAT
• , Go-Live and production support.
• Working closely with the Performance testing team in scenarios identification and data collection and acting as a co-ordinator with various support teams such as functional, business users, Development and Infrastructure teams
• Testing of EDI indirectly using VAN (Value added Network) provided by Kofax.
• Core member of Projects team involved in detailed requirements analysis, test planning, test cases creation and execution for ADT’s CRM application supported by SFDC (Salesforce.com) involving SaaS & Mobile App testing involving PaaS.
• SaaS testing revolved around Customer and Dealer network maintenance for the Sales team supported by Salesforce and accessed using their Sales cloud platform.
• PaaS testing involved working closely on Requirements & Design analysis, Unit Testing and Mobile testing for ADT’s newly launched services developed in-house and provided to (Residential & Small Business) customers using ADT app for Apple and Android devices involving: Voice control, Remote Light and Temperature control (NEST Thermostats only), Remote Burglary, CO, Fire & Smoke monitoring and Remote Home Alarm locking for doors and garages.
• Assisting in UAT testing for Supply Chain and Financials modules.
• Working on the Kofax MarkView 8.2 for Oracle R12 Upgrade.
• Performing System setup audit to ensure the system setups in R12.0.3 to meet the requirements in GL, AP modules.
• Reviewed the R12.0.3 setups with the Manager and users of respective modules/systems and updated the setup as per Business requirements.
• Involved in identifying and outlining functional and regression test scenarios and setting them for automation using Selenium Web Driver 2.0
• Review of New functionalities like Sub Ledger Accounting (SLA), FAH, and functionality changes in various modules with CFO, Super users and Users of various Business areas.
• Coordinating issue-tracking and closure in OBIEE Reports for Finance & Supply Chain modules as a part new functionality of R12 upgrade.
• Responsible for preparing upgrade Test plan for Finance modules.
• Review and Maintenance documents BR-100 and MD-50, for requirement gathering, process design, system configurations, custom reports, discoverer reports and test scripts in AIM methodology as part of project implementation task using Sharepoint.
• Responsible for complete functional testing, System Integration testing, User Acceptance testing and resolving issues
• Preparing Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration. Coordinated with Oracle support and tracked SR for critical issues
• Resolving process issues, period end closing and interface issues in GL, AP, AR and PO.
• Co-ordinating and follow-up on multiple issues based on priority including identifying bugs and follow-up with Oracle Development, Functional, Infrastructure teams, External partners/ vendors.
• Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.

Confidential . Chicago, IL

Oracle ERP Financials & SCM QA Lead

Responsibilities:

• One of the initial member of the manual testing team responsible for overseeing testing of Oracle EBS modules related to Oracle Payables (AP) and Procurement (PO) processes, Chart of Accounts (CoA) structures (GL) for all ERP test releases.
• Intensive testing on B2B web component between Walgreens-Theranos where customers lab tests data collected by Theranos was transferred to Walgreens R&D teams for analysis.
• Executing regression scenarios to identify, track and manage defects in HP ALM 11.0.
• Archiving QA artifacts and uploading execution status and closure on Sharepoint.
• Performed mobile testing for smartphone app involving purchase history and Balance Rewards card scanner.
• Responsible for conducting Defect Triage calls twice a day in order to assess Critical and High level defects and work closely across teams towards bringing a swift and effective closure.
• Core member of the manual testing team responsible for analyzing business requirement, creating test cases for Oracle EBS modules related to Oracle Payables (AP) and Procurement (PO) processes, Chart of Accounts (CoA) structures (GL).
• Executing standard, non-standard and regression scenarios to identify, track and manage defects in HP ALM 11.0.
• Performing end-to-end testing of the Procurement process involving multiple Organizations where goods are sourced indirectly using an external company.
• Performing end-to-end testing of the Procurement process involving parent company where essential goods are sourced directly from vendors and suppliers.
• Assigned responsibility for identification of pain-areas in the overall testing process and suggest possible resolutions for review by business teams and their successful implementation.
• Successfully tested the Sub-Ledger Accounting for Projects and non-Projects related Purchase Orders.
• Responsible for leading the overall execution of Pollenware process to increase working capital by a bidding process with Oracle EBS.
• Led the effort to oversee invoice imports from more than 30 different sources into Oracle EBS and their successful processing and payments by Oracle AP and bank reconciliation and accounting.
• Involved in consistent follow-up, review and analysis with the different source systems located across geographies in order to obtain invoices and data in a format acceptable by Oracle EBS.
• Managed the Daily Defect Triage status call sharing progress on the testing efforts and roadblocks across teams and business in order to work towards a timely closure of business Critical and High-level issues.
• Single point of contact for all offshore teams and assigned with sharing of business requirements, code changes and daily follow-up of test execution and status reporting and task allocation.
• Provided end user production support and post successful Go-Live of all releases as per schedule.
• Responsible for assigning defects in ALM to respective action-owners and follow-up on the actions completed for resolution.
• Dealing with the Service Requests (SR) escalations raised in BMC Remedy during Production Support related to issues with Functionalities and Patch updates.

Confidential, NY

System Integration Tester and Functional QA consultant

Responsibilities:

• Core member of the manual testing team responsible for testing of Oracle EBS modules related to Order Management (AR) and Procurement (PO) processes, Budget structures, Chart of Accounts (CoA) structures (GL).
• Executing regression scenarios to identify, track and manage defects in IBM Clear Quest.
• Dealing with the Service Requests (SR) escalations raised in BMC Remedy during Production Support related to issues with Functionalities and Patch updates.
• Re-creating scenarios, performing regression testing based on solutions updated by the Oracle team for production-related issues in BMC Remedy.
• Responsible for developing high level test case design by interacting with business group to identify gaps in existing process.
• Performing end to end testing consisting of Order to Cash cycle (AR) and Procure to Pay (AP) cycle analysis, data setup and execution.
• Involved in identifying and outlining functional and regression test scenarios and setting them for automation using Selenium Web Driver 2.0
• Designing and executing regression tests in AMS Advantage Financial Application FMS/3 and FMS/2 related to Budgeting & Forecasting (including Roll and Lapse process in Budgeting).
• Involved in designing and executing test scenarios for the pilot project for Supplier Catalog Vendor Punchout in AMS Advantage.
• Testing requisitions, purchase agreements, contract orders, reports, interfaces for the City of New York Government.
• Designing test scenarios, preparing test scripts and performing Regression testing by executing test cases in Oracle EBS for Order Management (Order to Cash process), Chart of Accounts, Contract Management (Procure to Pay process)

Confidential, Atlanta, GA

Oracle EBS Functional QA Consultant

Responsibilities:

• Integral member of the manual testing process to ensure a quality product is delivered to production.
• Interacting with Functional, Developmental and Performance staff to isolate and resolve defects; re-testing to confirm defects have been resolved without any impact on the application's desired performance under testing purview.
• Involved in the eCommerce and Web Content Management (WCM) and Bering Media testings for real-time updates on customer accounts and location-based advertisements respectively. (B2B offering to residential customer base)
• Designing and executing of Test cases related to Oracle Time & Labor (OTL), formerly Peoplesoft in Oracle R12 platform for Manheim Auctions.
• Assisting end-users by designing modules from Oracle UPK (User Productivity Kit) for using Oracle Time & Labor (OTL)
• Executing test cases in HP Quality Center 10.0 involving regression, system integration and end-to-end testing of ERP applications on Oracle 11i platforms.
• Designing test scenarios and preparing test scripts for Functional Unit Testing, System Integration Testing (SIT), Regression Testing and User Acceptance Testing (UAT) based on the functional requirement specifications and design documents.
• Analyzing business requirements and mapping them to test cases.
• Assisting team lead in preparing and updating Test Plan and on-time execution of the Test Strategy and providing regular status updates.
• Dealing with the Service Requests (SR) escalations raised in BMC Remedy during Production Support related to issues with Functionalities and Patch updates.
• Successfully executing test cases for Oracle Financial module iExpenses, Account Receivables (AR) with Smart General Ledger mapping for tracking employee expenses for official business purposes.
• Successfully executing test cases for Oracle Supply Chain modules:
• Performing database testing with Parasoft SOAtest 6.2 and Oracle SQL Developer 2.1.1.64 & Microsoft SQL Server 2005 for Internet Performance Management (IPM) and Internet Voice Manager as a part of Cox Communications’ Webservices initiatives.
• Querying the SQL database for data accuracy verification. Involved in testing split functionality using ETL tool Informatica.
• Identifying and tracking defects, Documenting clear and comprehensive description of defects raised.
• Interacting with offshore teams and bringing them up to speed on on-site business needs and sharing offshore progress with senior management.
• Ensuring software applications meets functional and performance requirements in-line with the needs of the business scope.
• Providing timely status updates to the management so as to maintain strict adherence to project timelines and budget constraints.

Confidential, White Plains, PA

Oracle EBS Functional Consultant

Responsibilities:

• Completed the Gap Analysis between Confidential .’s business process in 11.5.10 and 12.0.6.
• Performed end-to-end Regression testing related to Payroll, Employee Attendance and other HR-related functions in Peoplesoft.
• Supporting the upgrade to 12.0.6 for Account Payables (AP), Account Receivables (AR), General Ledger (GL), Purchasing (PO), iProcurement, iSupplier, iExpenses, PA, INV, OM and Cash Management (CE)
• Hands-on experience with MS Projects for verify daily updates from various teams to track project status and deliverables.
• Created work assignments based on project master schedules using MS Projects.
• Requirement Gathering from the Users for the new functionality.
• Documentation of MD50 and BR 100 needed for the changes required for the upgrade.
• Involved in End to End testing of BOT project changes.
• Executed test cases in HP Quality Center 10.0 involving regression, system integration and end-to-end testing of ERP applications on Oracle 11i platforms.
• Involved in DFF validation for Requisition, PO and Invoices.
• Involved in Workflow validation for Requisitions, PO, Invoices and Expenses.
• Involved in supplier conversion testing.
• Involved in Custom Reports testing in PO and AP.
• Involved testing setups and CCR changes.
• Reviewed functional documents and prepared the test cases. Written step by step test cases in Quality Center.
• Executed test cases and reported the QA status.
• Involved in preparing QA Artifacts.
• Coordinate with offshore and onsite team members to monitor and track the daily status.
• Dealing with the Service Requests (SR) raised to the Oracle team to resolve issues using BMS Remedy.
• Monitoring the end-to-end testing of the system after the 12.0.6 upgrade.
• Preparation of documents for the end users and giving them initial support.

Confidential, Phoenix, AZ

Oracle EBS Functional Consultant

Responsibilities:

• Implementation of Account Receivables (AR) and Cash Management (CE) in Oracle Applications v11.5.10.2 using SDLC.
• Requirement gathering from the Users.
• Solution designing to mitigate the gaps
• Preparing BR 100 Documents, needed for implementation and customization, using the Application Implementation Methodology (AIM v3.0).
• Implemented the Multiple reporting currency (MRC) functionality
• Understanding the requirements from the users and prepare data migration functional documents for AR customers and AR invoices.
• Set up of System parameters for Cash Management (CE) to enable automatic and manual reconciliation of the bank statement.
• Preparation of testing and documents for the end users and giving them initial support.
• Participating in the post production check out and giving immediate solutions to the issues faced during the check out.
• Data Migration of the items, banks, suppliers, Purchase orders, receipts, invoices and payments into Oracle Applications.
• Trouble shooting the errors that come up during the Data Migration.
• Involved in Integration and functional testing (SIT).
• Prepared UAT documents using UPK.
• Posting the accounting entries into the General Ledger.
• Trouble shooting the issues that come up during the month / period end closing process.

Confidential, Chicago, IL

Oracle EBS Functional Consultant

Responsibilities:

• Studied, analyzed, designed and implemented PO, OM, INV, PA, AP, AR, GL and CM modules.
• Prepared MD50 Functional specifications documents.
• Analysis of business needs and requirements, identifying the gaps and issue for accounts Payable, Cash Management, General Ledger & Accounts Receivable’s modules.
• Updated project and deliverable status on MS Sharepoint
• Designed and implemented bank statement import from external bank systems.
• Designed and implemented bank statement reconciliation with Accounts Payable and Accounts Receivable transaction as part of Cash Management Implemented.
• Designed and implemented customized AP/AR Cash Management Reconciliation report.
• Implemented Reports interfaces, conversion and extension (RICE)
• Designed and developed a testing strategy including CRP test scenarios to test the set up of AP, GL, PA, OM, INV, CM & AR modules
• Resolved issue tickets and support updates using JIRA
• Preparing Flow Charts & Suggesting Customizations
• Provided post implementation support to the client.
• Trained Business User Group in using ADI tool to upload day-to-day adjustment journal entries and budgeting journal entries.
• Prepared the documents for PO, AP, GL, OM, INV and AR modules and was involved in the of the end users.
• Reviewed as-is (existing) business process and prepared to-be (new) process flows for multiple business scenarios.
• Follows ups of TAR and Applications of Patches as and when required.

Confidential, Richmond, VA

Oracle EBS Functional Consultant

Responsibilities:

• Performing Business Requirement Study in Financials and modeling Future Process Model.
• Setups for GL, AP, PO, AR and OM mapping processes.
• Support for functional issues and Functional Testing
• Updated project and deliverable status on MS Sharepoint
• Arriving at the Future Process Model, which includes GAP Analysis for ‘Procure to Pay’ and ‘Order to Cash’. Identify areas of news business requirements and advice on upgrades.
• Coordinating with Technical Team on delivery and support for customization developments.
• Map client business requirements to Oracle functionality and identify gaps and setup application in the Test, Development and Production environments.
• Conducting Orientation, CRP, UAT and Roll out Strategies for implementations.
• Data Conversion fit and gap analysis, interacting with both management and users to come up with functional and technical design.
• Monitor progress on Remedy tickets/dev tracks within the team and ensure SLA compliance on tickets worked on by themselves and team members.
• Interaction with users and seeking information as required for resolving the issue.
• Suggest solutions/Provide resolution for issues and communicating with Business
• Periodic communication to users regarding the progress on the ticket being worked on.
• Unit/integration testing and review of deliverables
• Ensuring Knowledge Building sessions at regular intervals for the team members.