SUMMARY:

• Overall 10 years in IT Industry including 10 Years in Oracle E - Business Suite in Implementation, Quality Assurance, and Production support.
• Worked on Oracle EBS 11i, R12 Setups and Implementation of Financial and Project accounting modules.
• Extensive familiarity with Application Implementation Methodology (AIM) / Oracle Unified Methodology (OUM) in different phases i.e. Requirement gathering, Operation analysis, Solution Design, Build, Test, Training, Data Migration and Production.
• Excellent knowledge in Oracle E-Business Suite Business Flows (Procure to Pay, Quote to Cash, Order to Cash, Record to Report)
• Good experience in SDLC, AIM, OUM, Agile methodologies.
• Developed Seeded and Custom Test cases, End to End Test scenarios and performed Unit/Systems integration/Regression, Performance/Stress/Volume testing to perform verification and Validation of the functionality.

TECHNICAL SKILLS:

Oracle EBS Modules: General Ledger, Account Payables, Account Receivables, iProcurement, Purchasing, Fixed Assets, Cash Management, Time and Labor, Project Accounting- Costing, Billing and Project Management, iSupplier, iExpense, Payment Processor, HRMS, EBTax, AME, System Administrator.

Oracle Applications Versions: R 12.2.3/11.5.10/11.5.9

Methodologies: AIM, OUM, SDLC, Agile/Scrum.

Reports: Oracle Discoverer 10g, Financial Statement Generator, OBIEE 10.1.3.4.1

Languages: C, SQL, PLSQL.

QA Tools: HPQC, ALM 11.0, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Business Analyst

Environment: Oracle General Ledger, Project Accounting - Costing and Billing, Accounts Payable, iProcurement, iSupplier, Purchasing, Payment Processor, EBTax, ALM

Responsibilities:

• Participated in Oracle workshops and delivered the upgrade knowledge to the business.
• Involved in gathering business requirements and performed Gap-Fit analysis.
• Developed BP80 and BR100 Documents.
• Setup and configured the GL and AP Modules as per the business requirements.
• Developed MD50 documents for CEMLI objects.
• Assisted the technical team in customization.
• Developed the Test Strategy and Testplans.
• Developed the TE40 Documents and performed functional testing of seeded and custom functionalities.
• Executed the Functional and Custom Objects Test cases for Integration testing.
• Run the Triage meeting
• Developed the user and training documents.
• Provided GO-Live Support.

Confidential, New Jersey

Oracle R12 Financials Functional Analyst

Environment: Oracle General Ledger, Accounts Payable, Account Receivables, iProcurement, Fixed Assets, EBTax, Payment Processor, Cash Management, System Administrator, OBIEE, ALM 10.5

Responsibilities:

• Involved in gathering business requirements
• Performed Gap-Fit analysis to replace the 11i customization with Seeded R12 functionality.
• Developed BP80 and BR100 Documents.
• Configured GL, AP, AR Modules.
• Developed custom MD50 documents.
• Developed end to end test scenarios for validating the seeded and custom functionalities.
• Assisted end user training and supported the post production issues.

Confidential, Miami

Oracle R12 Functional Test Manager and User Provisioning Analyst

Environment: Oracle General Ledger, Accounts Payable, Account Receivables, Purchasing, Inventory, iExpenses, OATS, HCM, Oracle Time and Labor, Work Day, Payroll, System Administration, ITSM (IT Software Management)

Responsibilities:

• Participate in Oracle R12 Workshops
• Review of the Oracle 11i pain points with the Business and Gap fit analysis
• Review of the CEMLIs with the business
• Knowledge transfer to the offshore team.
• Capture all the requirements from the requirement docs
• Write the Master Test Strategy and Test plan documents
• Review of the project plan, Project charter and create testing tasks and schedule document for the Management.
• Created and developed Standard Operating Procedures SOPs
• Review of the existing testcases with the Business SMEs and capture any new test cases per CEMLIs
• Develop testcases and test scenarios
• Prioritize the testcases with the business
• Business Sign off on the Test Stategy, Test plan and Test cases.
• Performed Functional, System Integration testing
• Log the defects in the Sharepoint
• Triage the defects with the business, Technical and functional team.
• Onsite and offshore coordination and gather the testing status.
• Coordinate Code deployments to the test instances.
• Conduct CRP and UAT sessions.
• Daily QA Status calls with the onsite and offshore teams
• Review of SOD Conflicts to assign R12 responsibilities to the users
• User Provisioning in UAT and Production instance setting up the user creation and assigning the responsibilities
• Review of all the CEMLIs with the assignment to the right request groups and Menus.
• Review of the roles and responsibilities matrix to assign the standard and Custom Functions to the responsibilities including the Menu exclusions.
• Creating the change request in ITSM for migrating the responsibilities, menus and request groups to UAT and PROD instances.

Confidential, Dallas, TX

Oracle Functional Analyst

Environment: Oracle General Ledger, Sub Ledger Accounting, Accounts Payables, Accounts Receivables, iProcurment, Purchasing, Payment Processor, EBTAX, Fixed Assets, Cash Management

Responsibilities:

• Participate in Oracle R12 Workshops
• Review of CEMLIs with the Business and Technical Team.
• Gather business requirements and performed Gap-Fit Analysis.
• Developed BR100 and MD50 documents of GL, SLA, AP, EBTax Modules.
• Implemented E-Business Sales Tax for US - Regime to Rate flow with Rules and Exceptions and Self assessment Tax
• Developed TE40 documents and performed Functional, System Integration testing
• Participated in daily triage meetings
• Raised SR for several issues and resolved them
• Participate in CRP and UAT.
• Created and developed Standard Operating Procedures SOPs.

Confidential, Philadelphia, PA

Oracle Functional - QA Analyst

Environment: R12 Configurator, iProcurement, Purchasing, AME, Account payables, Receivables, Fixed Assets, General Ledger, CARES, Order Management, Inventory, Advanced Pricing, SalesFocec(SFDC), HRMS, HP-Quality Center 9.2, HP-Mercury QTP 9.5 and LoadRunner 9.2, Toad, Oracle Discoverer, Lotus Notes.

Responsibilities:

• Review and suggest edits and Approval of MD50, BR30, BR100 documents with Functional Analysts and Technical Leads.
• Implementation and Setup from BR100s.
• Create Test plan and Test strategy.
• Creating TE10 Docs.
• Creating project folder structure in Quality Center.
• Requirement extraction from MD50 and BR30 in Quality Center
• Scripts creation/modification and requirements assignments from MD50, BR30 in Quality Center.
• Prioritize the scripts with Functional Leads.
• Created and executed End to End Scripts in Test, UAT and Pre-Production Instance (Perf) instances.
• Scripts execution in Quality Center.
• Manual execution of Configurator and Finance scripts and Discoverer Reports.
• Creating regression and functional automated scripts in QTP
• Setup and Configure Quick test professional and Loarunner.
• Creation of Load and Performance testing in Loadrunner.
• Backend testing by Querying the database tables using Toad.
• Data mining for script execution.
• Running automated scripts from Quality Center using QTP and Loadrunner.
• Logging and tracking defects and assign defects to appropriate Functional Analysts/Leads.
• Working closely with Developers, Testers and functional analysts in discussing and tracking the resolution of the bugs.
• Create execution status reports in Quality Center.
• Retesting the resolved Technical Defects(TDs)
• Maintaining the defects log and parking lot issues.
• Training and assisting the offshore team.
• Attending and answering offshore calls and resolving their issues.
• Attending Daily status calls with Team leads/Managers.
• Pre and Post Production Support for resolving the Urgent TDs and manual updates to Quotes.

Confidential, Philadelphia, PA

Oracle 11i Functional QA lead

Environment: Oracle time and Labor, Project Costing and Billing, iExpence, Purchasing, Accounts payables, Receivables, Fixed Assets and General Ledger, AME, Order Management, HRMS, HP- Quality Center 9.2, QTP 9.5,Toad, Lotus Notes.

Responsibilities:

• Review of MD50 customization documents.
• Implementation and setup based on BR100.
• Developed test cases like System Administration, Sub ledger Journals to Post, Supplier Invoice to Payment, Assets to Depreciation, Period End close to reporting, Receipts to Assets, and Procure to Pay.
• Develop Test plans and build Test Scenarios, Test Cases.
• Developed Automated scripts using QTP 9.1
• Worked closely with developers and the business team to fully understand the scope and functionality of the Application.
• Prioritize the Test cases with Clients.
• Review and Signoff on the Inventory of the Test cases.
• Importing and maintaining the scripts in Quality Center.
• Query Oracle tables with SQL using TOAD for Data Mining of the Test Cases.
• Execute the test cases in Quality Center’s Test lab.
• Track and Report the daily status on the executed Test cases.
• Discuss the defects with the Clients and assign the bugs to the Developers.
• Daily execution status meeting with the clients.
• Retest the failed Test cases based on the priority.
• Involved in User Acceptance Testing (UAT) and tracking the Parking Lot issues.
• Involved in weekend and Month end reporting.
• Closing month end GL periods.

Confidential, San Jose, CA

Oracle Apps Functional - QA Lead

Environment: Oracle Supply chain Management, iProcurement, Purchasing, AME, Account payables, Receivables, SVO Tool, General Ledger, HP- Quality Center 9.2, Toad

Responsibilities:

• Develop Test plans, Test Scenarios and Test Cases based on Functional Documents.
• Worked closely with developers and the business team to fully understand the scope and functionality of the Application.
• Development of Test cases and End to End test scenarios.
• Review and Signoff on the Inventory of the Test cases.
• Prioritize the Test cases with Clients
• Maintaining the scripts in Mercury Quality Center.
• Query Oracle tables with SQL using TOAD for Data Mining of the Test Cases.
• Preformed white box testing like Unit Testing, System Integration
• Execute the test cases in Quality Center’s Test lab.
• Assign the Test Cases to the offshore team.
• Train, Support and Knowledge Transfer on the Customization of the Oracle Application.
• Track and Report the daily status on the executed Test cases.
• Discuss the issues with the offshore team and Clients and assign the bugs to the Developers.
• Daily execution status meeting with the clients and go through the P1 and P2 issues.
• Retest the failed Test cases based on the priority.
• Identify the Smoke test cases and execute the Identified testcases in Smoke Testing window.
• Involved in Integration, End-to-End testing and User Acceptance testing phases and corresponding process of migration.

Confidential, Houston, TX

Data Integration QA

Responsibilities:

• BRB, FSD and ADD reviews
• Create Test Scenarios, Test Cases and Test plans based on BRDs and ADDs
• Manual Testing on Test Scenarios
• Create automation Scripts for the Test scenarios
• Maintains the scripts to Mercury Quality Center
• Tract defects using Quality Center and discuss on the issue with the developers and Business people
• Raise the defects to TAR (Technical Assistant Request) and update the TAR for global defects tracking and resolving the issue with global team
• Interact with onsite and offshore team
• Created and executed manual/automated test scripts using Load Runner
• Reviewed test assignments, developed test plans and scripts, and conducted test as assigned, developed test procedures and test cases
• Performed negative and positive testing for the application
• Data Driven Testing by extracting data from an Oracle Database
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues Load and upload the data to the database tables
• Query database tables with SQL using TOAD 9.0.1 for verification and validation of the data uploads
• Worked closely with developers and the Business team to fully understand the scope and functionality of the proposed systems requirements.
• Discussed and Derived Test Plans with the Manager.
• Confirm the results into the True Comp Application
• Check the final reports to reflect the data changes
• Documenting the Runbook file for future verification.
• Hosting the meetings with Onsite and Offshore team
• Train the testing team
• Processed feedback from users in order to analyze and reproduce software problems. Communicated with offshore development team to resolve various issues.

Confidential, Plymouth, MN

Oracle Apps Performance/ QA Analyst

Environment: Oracle Purchasing, Accounts payables, Oracle Receivables, Fixed Assets and General Ledger, HRMS, Toad, Lotus Notes, Hyperion, Mercury Loadrunner 8.0, Mercury Quality Center 8.2

Responsibilities:

• Setup and Configure Loadrunner
• Designing, recorded and coded the automated scripts for Hyperion and Oracle using the web(HTTP Protocol) and Oracle NCA protocols in Mercury Loadrunner
• Created and executed lifecycle scenarios in Procure to Pay
• Replaying the scripts into remote controller for multiple users.
• Debugging the issues with the infrastructure and creation of scripts
• Analyzing the Logs and Run results. building the analysis reports
• Administrating the Quality center
• Creates Test plans for Oracle ERP modules(GL,AP,AR,FA)
• Manually executing the Oracle Test scripts. train the testing team for the better understanding of the testing process
• Managing the testing teams and including them in various works streams.
• Extensively worked in testing Databases and API
• Conducted Regression test before and after bug fixing
• Developed templates for test script, test cases and test matrix.
• Performance testing to check the time taken to add or retrieve the data from the database.
• Tested both front-end GUI and back-end servers of the application.
• Creating Test procedures and Test scripts for Regression Testing.