SUMMARY:

• Expert in test management tools like QC ALM, Test Director, Rally, JIRA, Silk Test, and Rational Test Manager
• Extensive experience in defining Test Plans, Test Scenarios, Test Cases, Test Reports and Documentation for both Manual and Automated Tests
• Proficient in Data Warehouse testing like Control Mechanism of batch loads, error/ rejected records processing, testing of SCD implementations and process dependencies
• Strong skills in executing Black Box, White Box, Grey Box Testing, Unit Testing, Integration Testing and Acceptance Testing.
• Expertise in Selenium Automation using Selenium RC, WebDriver, Selenium Grid, Java, JUnit & TestNg.
• Automation expertise in Framework design, Effort estimation, POC, Test Scripts reviews, establishing coding standards, updating automation framework based on client requirements, test scripts design.
• Involved in all phases of SDLC and good knowledge in testing applications developed using RUP & Agile Methodologies like SCRUM and Test - Driven development (TDD) etc.
• Experienced in complete project life cycle development including Requirements Analysis, Design, Coding, Unit, Integration, System Testing,UAT and Maintenance
• Highly proficient in using the defect-tracking tools like Test Director/Quality Center, Rational ClearQuest, Jira, StarTeam and Bugzilla
• Involved in creating Project Software Process Handbook, Risk Plan, Task Tracking, Project Status reports (Daily, Weekly and Monthly), Training Plan, Resource Plan, MPP and Project Metrics
• Good understanding of Business Intelligence (ETL) Test Processes and Test Methodologies
• Excellent knowledge of Software Development Lifecycle including Functional & Non-Functional Test Phases
• Excellent management, interpersonal, written and verbal communication, and organizational skills, attention to detail
• Involved in Requirements, Test Scenarios, Test Cases, Test Results and Defect reviews
• Expert in testing Oracle EBS apps, Transportation (TMS) and Warehouse (Oracle WMS & Red Prairie) Management System applications, JDA
• Key expertise includes testing and debugging Oracle EBS apps like Order Management, Shipping, Inventory, Financials, Oracle OTM
• Involved in release planning, test estimations, test project plan, and test metrics
• Ability to manage time well, organize and prioritize
• Ability to understand Functional Requirements and Design Documents
• Flexibility to adjust to multiple demands, shifting priorities, ambiguity and rapid change
• Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies
• Ability to understand and integrate cultural differences and lead virtual cross-cultural, cross-border teams
• Ability to build good relationships both within the QA & Test team and with other teams
• Able to provide leadership, participate and be a productive member of the team

TECHNICAL SKILLS:

Automation Tools: QTP, Selenium, Load Runner and Rational Functional Tester

Defect Tracking Tools: Mercury Test Director, HP QC ALM, Rally, Rational Clear Quest, StarTeam, Jira and Bugzilla, TFS

Databases: Oracle, MS SQL Server, DB2, Sybase and MS Access

Programming Languages: PL/SQL, SQL, Java, HTML, XML, VB Script, and TSQL

BI (ETL) Tools: Informatica, Autosys, Control-M, BigData Hadoop, Hive, Impala

Agile Tools: Rally, Jira, TDP, Team Foundation Server (TFS)

Testing Methods: Black Box, White Box, Unit, Smoke Testing, Regression, Integration, System Testing, UAT, End to End Testing, DB testing, ETL testing and ERP Testing

PROFESSIONAL EXPERIENCE:

Confidential

SIT/UAT QA Test Lead / Test Manager

Environment: Oracle EBS R12 (Order Management, Shipping, Inventory, Financials), OTM, ETL, Linux, QC ALM, Rally (CA Agile Studio), TDP, SoapUI, XML, PL/SQL, Toad, Selenium, Java, GIT, Big Data, Hadoop, HIVE, Impala, Oozie, Tableau

Responsibilities

• Worked within a high performing Agile environment, Participated in User Story discussions, grooming sessions to make sure User Stories are testable and measurable
• Participated in Scrum planning, Release/Iteration planning and assisted others in estimating task effort and dependencies
• Responsible for test deliverables within the sprints
• Responsible for communicating (verbal and written) with Business, Development, senior management and partner systems on the progress of the Release goals, objectives and testing efforts
• Responsible for prepare and manage QA project plan, prepare test estimates, test timelines (Functional, SIT, UAT and Performance Testing)
• Provided the Automation Test Strategy, Test Plan and Automation Estimation for automating web application using selenium.
• Development of Automation Scripts for web application using Selenium WebDriver with Java.
• Designed and developed Selenium test scripts using Hybrid Framework.
• Executed automated test scripts for Sanity, Functional and regression testing using Selenium WebDriver on different browsers/environments and provided Results.
• Identify and communicate risks & issues and mitigation plans
• Prepare and review test plans, test cases, scenarios and test data requirements
• Executing the oozie workflows and validate the back end data
• Developing complex HIVE/Impala queries to evaluate the Tableau reports
• Tracked Test Instances readiness and connectivity. Keep a close eye on code migrations, understand the migrations requested for the project, the impacts to the testing and verify the QA environment is available for testing
• Report QA findings, generate metrics & reports and QA Project Closeout Report
• Worked with upstream and downstream application teams to create and execute tests
• Supported the development, maintenance and end user training on testing procedures
• Worked closely with multiple small to medium sized onshore and offshore teams, 3rd party vendors to deliver projects on time, cost and with quality
• Have strong working relationships with other IT teams, business and customers to speed up delivery of IT Solution
• POC for UAT, data creation & coordination with UAT team, Track and Report UAT issues
• POC for PVT, understand the need of PVT, work with program sponsor, IT Lead and schedule PVT after code migration to PROD, update all stake holders with PVT status and issues
• POC for project after Go-Live, maintain issue list and fixes, communicate with the stake holders and update leadership frequently on issues

Sr. QA Lead / QA Manager

Environment: UNIX, HP ALM (QC ALM), Jira, Excel Reporting (QC OTA API), Java, Web based testing, Selenium, Java, SOA BPEL, AIA, SQL, Toad, REST, API, Soap UI, Oracle EBS, ETL, Oracle BRM (7.4), Oracle (Siebel) CRM

Responsibilities

• Test Planning & Management, Estimation, Defect Management, Testing Execution management, Automation
• The projects that my team provides QA services to are - Confidential.
• Developing and managing all aspects of the testing effort, including plans, interdependencies, schedule, budget, tools, and required personnel including documenting and communicating the status of testing progress against plans, taking corrective action as necessary Participating in Sprint planning sessions and representing QA in these planning calls
• Creating proactive proposals for testing strategy or automation framework decisions
• Provided the Automation Test Strategy, Test Plan and Automation Estimation for automating web application using selenium.
• Development of Automation Scripts for web application using Selenium WebDriver with Java.
• Designed and developed Selenium test scripts using Hybrid Framework.
• Executed Sanity test scripts using Selenium WebDriver on different browsers/environments and provided Results.
• Performing API testing using SOAP UI for the Nissan Enrollment project which would replicate the functionality provided by the AMP portal (bypassing all web portals but calling the web services directly)
• Providing technical leadership to project resources and the client to meet testing deadlines and objectives
• Test cases developed strictly based on acceptance criteria found in user stories
• Ensure test case creation, execution and revalidation of fixed issues happens within the 4 week scrum sprint schedule
• Be part of the verification for the multiple code drops that happen every sprint and raise issues as observations on Quality Center ALM (QC/Test Director)
• Be part of daily scrum calls - where all status/issues are discussed between scrum master, QA lead and Product owner
• Ensure all critical and high defects are closed during same sprint and that medium/low defects are planned during subsequent sprints if not during current sprint
• Observations were converted to defects on the last day of the sprint after DEMO of user story is accepted by product owner. Similarly Issues discovered post sprint during SIT/Regression/Performance testing will directly be raised as defects (not observations)
• Reviewing project deliverables for completeness, quality, and compliance with established project standards
• On-time, on-budget and high quality testing delivery
• Creating the Test Strategy document, the Test plan document, creating test scenarios, creating test cases, test execution, raising defects in QC, running defect calls, creating test data via SQL queries from user databases

Oracle ERP Sr. QA Testing Consultant / QA Manager

Environment: HP QC ALM, PLSQL Developer, OTM, Oracle EBS, ETL (OBIEE), Oracle WMS, JDA, Web Sphere, Salesforce, REST, API, SOAPUI, VSS, XML, Linux, Red Prairie

Responsibilities

• Test Planning & Management, Estimation, Defect Management, Testing Execution management
• Developing and managing all aspects of the testing effort, including plans, interdependencies, schedule, budget, tools, and required personnel including documenting and communicating the status of testing progress against plans, taking corrective action as necessary.Participating in Sprint planning sessions and representing QA in these planning calls
• Providing technical leadership to project resources and the client to meet testing deadlines and objectives
• Generated test plans and test cases for system, integration and performance testing
• Identified test conditions, reviewed test scripts and test plans for Oracle EBS, WMS-Red Prairie, JDA (Planning & Requisitions) applications
• Generated test scripts which reflect the step-by-step instructions on how to execute a test conditions and setting up the test data for specific data transactions
• Responsible for executing and validating test scripts
• Involved in testing Salesforce portal for Leads & Opportunity Creation
• Coordinated testing efforts for Oracle EBS apps and results with development team
• Involved in API, web services testing using Soap UI
• Worked in Agile environment, involved in Scrum meetings
• Interacted with the development teams and client teams with regards to requirement clarifications and defects encountered during testing

Sr. QA Testing Consultant / QA Manager

Environment: HP QC ALM, SQL, PL/SQL, Informatica, OBIEE, Oracle EBS, Flat Files, Tidal, UNIX

Responsibilities

• Contributed in developing test plan and test cases based on the high-level and detailed design
• Performed Security testing of the basic security levels in the Client Link application security mechanism
• Have good knowledge in HL7 standards and ICD-10 codes
• Worked with the bug fix team to solve the report & ETL issues
• Contributed in regular status meetings to state any bugs, problems and risks
• Ran and monitored the ETL loads to load data into QA environment
• Logged defects and followed up on issue resolution ensuring timely customer reporting needs were being met

Sr. QA Testing Consultant/QA Lead

Environment: Rational Test Manager, RFT, Manual Tester, Load Runner, ClearQuest, RequisitePro, AS400, DB2, SQL, PL/SQL, Informatica, Peoplesoft (HCM,ESA) Hyperion, Flat Files, Autosys, UNIX.

Responsibilities

• Designed Test Plans and Test Cases according to Business Requirements documents and Technical Specifications
• Documented test plan and test cases using Rational Test Manager and Rational Manual Tester
• Carried out Business Intelligence (ETL) Testing using Informatica
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Write SQL queries to validate that actual test results match with expected results
• Responsible for monitoring data for porting to current versions
• Analyzed and tested various Hyperion reports for Hierarchies, Aggregation, Conditions and Filters
• Checked the reports for any naming inconsistencies and to improve user readability
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source
• Used Rational Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs
• Have experience with Professional, Institutional and Medicaid claims processing
• Have fair knowledge in HL7, ICD-9, EDI X12 transactions and tested EDI 4010 & 5010 transactions
• Worked with appropriate team leaders to ensure quality of test deliverables & timely completion of individual test plans
• Developed documentation for User Acceptance Testing and trained the users about the system

QA Lead / QA Manager

Environment: Silk Test, AS400, DB2, FileNet, SQL Server, TOAD, UNIX, XML, SOAP UI, ETL, Peoplesoft (HCM, ESA), Web Methods, StarTeam, PlanView and .Net

Responsibilities

• Coordinating with both onsite & offshore team
• Involved in project planning, coordination and implementation of QA methodology based on the Business requirement and Design documents
• Interacted with System Analysts and the Development team on system to investigate requirements and in resolving issues
• Wrote complex SQL queries to validate target data based on the business requirements
• Used PL/SQL programs for performance testing & backend database testing
• Implemented data verification procedures for Business Intelligence ETL processes in load testing
• Used Quality Center for bug tracking and reporting, followed up with development team to verify bug fixes and update bug status
• Involved in coordinating the White, Black and Grey box testing for the data warehouse by checking ETL procedures/mappings
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project
• Involved in Integration testing, Functional testing and Regression testing
• Checked for any inconsistent joins and resolved loops in the catalog
• Involved in SOA integration testing using SOAP UI, validating XML, XSD and XPath’s
• Involved in the System Testing of the OLAP Report Functionality and data displayed in the reports
• Validating fields present in the reports are as agreed in the specifications
• Validated drill down features of reports
• Arranged meetings with business customers in better understanding the reports by using business naming conventions
• Analyze system issues and prepare business and technical requirements documents using established standards
• Worked with appropriate team leaders to ensure quality of test deliverables & timely completion of individual test plans
• Involved in Data Comparison of data in flat files
• Documented Test Plans and Test Cases using Mercury Quality Center for the application according to Business Requirements Specification, Use Cases and Design Documents

QA Lead / QA Manager

Environment: UNIX, Mercury ITG, and Clear case

Responsibilities

• Mastered the OKC switch in a short span of time.
• Handled issues in OKC switch effectively.
• Gained extensive knowledge in OKC Volume Testing with little KT.
• Handled OKC Volume Testing effectively for Professional and Medicaid claims.
• Gained extensive knowledge in EDI as well as Clearinghouse concepts.
• Have good experience with HL7 standards.
• Prepared OKC Volume Testing result reports, OKC Volume Testing activity logs, and status reports effectively.
• Prepared OKC Volume Testing SOP.
• Involved in test estimations, prepared test preparation documents, test plans and system test scripts.
• Successfully trained the Offshore Team on OKC Volume Testing.

QA lead / Senior QA Analyst

Environment: QTP, Mercury Test Director, Load Runner, PLSQL Developer, Peoplesoft ERP (HCM, ESA), Web Sphere, VSS, XML, UML, Control-M and ETL Share Points

Responsibilities

• Coordinating with both onsite & offshore teams
• Participated in Business requirements and test document review & walk thru meetings
• Identified and designed the Integration, System & Regression Test scenarios
• Worked as a Cross-Application test lead for Integration Testing effort
• Involved in QA Project Estimations and Resource scheduling activities
• Analyzed the Test plan, which detailed the testing scope, strategy, test requirements and necessary resources
• Involved in preparing QA Status reports, Issues, Action Item reports, Project closure reports, SOX compliance documents etc.
• Worked in FDA Validated Environment
• Monitored the team activities, schedules and assigning the tasks to the team members
• Performed Regression testing for every modification in the application & new builds using QTP
• Performed functionality, Integration and regression test
• Developed test related documents including Test Plans, Test Procedures, Test Cases and Test Scripts
• Worked closely with developers to resolve the defects and close them
• Coordinated with Project manager and other point of contacts to gather necessary information
• Performed regression, functionality, integration, positive-negative, grey and black box tests
• Coordinated with Change management to resolve issues with the test builds
• Executed the scripts and modified the scripts as per the enhancements and bug fixes of the application
• Met estimates and timelines for the completion of the project
• Involved in Web Services Functional Testing
• Involved in Performance Testing of the ETL Batch jobs and comparison of data in flat files
• Involved in UAT of the applications by providing users with test cases and scenarios, and guiding them during the testing process
• Used Test Director as defect tracking management tool
• Coordinate with developers and the testers for resolution of the problems reported
• Maintenance and update of scripts on release basis
• Prepared RTM documents and Involved in SOX compliance documentation

QA Lead / Sr. QA Analyst / QA Tester

Environment: Test Director, Oracle 9i, Windows, CVS, Win Runner and Jira

Responsibilities

• Performed web testing for secure messaging. Exercised and tracked test cases to verify new client releases and JAVA development
• Performed System testing, Regression testing, functional Testing using WinRunner
• Written the Test plan, Test Cases, Test Scripts and Test Steps for all the modules
• Executed all Test scripts, Test cases and validated data
• Executed test cases for both inbound and outbound WMS transactions
• Co-ordinate with developers in reviews and solving the problems encountered in the application
• Created Test Data to test different scenarios after a thorough requirements analysis of the applications
• Used Rational Clear Case for version control
• Documented the test cases, test results, test procedures and reported to team lead
• Engaged in assessment of Software Development Methodology and implement a modified RUP approach to complete SDLC
• Document, analyze, prioritize and maintain defect logs in Jira
• Executed test scripts and reported defects in terms of Major, Minor & Critical
• Involved in Smoke testing, Integration testing, System testing
• Responsible for full SDLC (REQ, CODE, ALPHA TEST, BETA TEST) including 4 test phases
• Developed checklist (test plan) and verified content with developers
• Exercise component checklists verifying correctness for each build.
• Performed database testing using queries from SQL
• Applying the SQL scripts to test the database and execution of scripts on the database
• Tested the application on IE 5.0/5.5/6.0, Netscape 4.73/4.74/6.0 as part of Portability Testing to maintain cross-browser functionality
• Used TestDirector for Test Planning, Test Designing, Test Execution, Jira for Defect Reporting and Test Evaluation
• Involved in setting up the environment (installation, configuration)
• Performed Integration Testing and Acceptance Testing along with Users