Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jahan Zib John

Rockville,MD

Summary

Over 5+ years of experience in the field of Software testing with good exposure in Quality Assurance and Testing processes along with Manual tools expertise. Experience in developing Test scenarios, Test cases, Test data, Test procedures, Test reports and documenting Manual and Automation Testing. Ability to work independently and within groups to meet deliverables within an action and result oriented approach to work; ability to build and maintain strong working relationship with all levels of management along with cross-functional team of Business Customers, Financial Specialists, Technical Subject Matter Experts (SMEs) and Developers. Facilitated daily scrum sessions, biweekly sprint planning, weekly backlog grooming. In depth knowledge of all phases of SDLC and agile methodologies (SCRUM) Software Development Lifecycle experience includes Requirement Analysis, Detail design, Business models, system integration, and team building. Strong Testing skills using HP ALM, QTP, Jira. Experience working in important phases of Software Testing Life Cycle (STLC) like Smoke Testing, Functional Testing, Integration Testing, Regression testing, and was involved in Load Testing, Performance Testing, End to End Testing and User Acceptance Testing (UAT). Ability to manage simultaneous projects effectively and efficiently. Expertise in Developing Requirements Traceability Matrix (RTM), Metadata Repository (MDR) Capturing Data Flow from multiple Sources. Develop User Guides, Documenting Business Systems, and procedures. Excellent skill in creating SQL Objects like Tables, Stored Procedures, Views, Indexes, Triggers, and user defined data types and functions. Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases. Proficient in bug Reporting and Tracking throughout the entire defect life cycle using JIRA. Worked as a Primary Contact for Leading and Coordinating User Acceptance Testing (UAT) for multiple Projects. Involved in requirements for interfaces for integration with multiple systems, defined how/what data would be passed in xml, how data mapping would be done for source to target systems integration, how source system would process the data from xml and map it on UI screens. Experience in managing complex issues and risks, including appropriate verbal and written communication at all levels.

Overview

5
5
years of professional experience

Work History

QA Manual Tester

Maryland Dept. of Information Technology
Crownsville, MD
06.2022 - Current
  • Analyzed business requirements, use cases and technical specifications for scripting comprehensive test cases
  • Participated in weekly meetings to discuss business and testing requirements with developers and Bas
  • Analyzed the Business Requirement Documents and developed test plans and cases on its basis
  • Involved in the execution of the manual test cases, analysis of the test results and maintenance of Test metrics
  • Created Requirement Traceability Matrix to map the test cases to the requirements
  • Extensively involved in regression, integration, functional testing, Smoke Testing, positive and negative testing
  • Automated web services tests cases in HP QTP
  • Extensively Used Inner Join, Outer join while creating SQL Queries from multiple tables
  • Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent
  • Involved in identifying risks to testing goals and escalating/planning accordingly
  • Wrote SQL targeting performance and recommended to define indexes on the tables as per the need
  • Wrote SQL queries to test the Oracle database and make validations
  • Extensively used SQL scripts/queries for data verification at the backend
  • Analyzed the response time graphs over multiple iterations thus generated in Load Analysis
  • Carried out the performance and stress testing with Load Runner
  • Developed the reports using Quality Center
  • Regularly generated the defect tracking document and defect progress graphs for a clear and detailed view on the defect resolution work being done
  • Created test strategies and conditions for load, stress, concurrent users, and network bandwidth scenarios in HP Performance Center
  • Presented weekly bugs to the team in weekly status meetings for reviewing progress and future testing efforts
  • Prepared test cases for User Acceptance Testing (UAT)
  • Involved in developing test plans, test strategies, test scenarios, test scripts and test steps based on Business and System Use Cases
  • Worked with Zephyr as test management tool and integrated with Jira as well for the bug tracking and test cases and acceptance criteria tracking
  • Oversaw quality assurance practices for all phases of the development and included front-end functionality, relational database management, and data conversion requirements.

Manual Tester

Texas Dept. of Education
Austin, TX
04.2019 - 06.2022
  • Analyzed Business Requirements and Functional Specifications and developed Test Plan detailed Test Scenarios, Test Strategies and Test cases
  • Involved as a representative from the QA team in creating Sprint/ iteration (of Scrum/ Agile Process) with closely defined and agreed output
  • Created, prepared, and conducted quality assurance review meetings, developed test plans, test cases, user scenarios, check lists and other QA documentation
  • Performed testing and maintained documentation on different types of Testing viz., Positive, Negative, Regression, Integration, smoke, System, User-acceptance, White Box and Black Box
  • Developed detailed test plans from Test cases; detailed specifications etc
  • Develop test cases for functional, Integration, System Testing and User Acceptance Testing
  • Developed Test Cases in test plan, executed in test lab using Quality Center
  • Assessed project requirements, development and test status, changes, coverage, and risks using QC (ALM)
  • Used SQL commands to insert, update, delete and modify the data
  • Participated in product design review meetings utilizing the AGILE process methodology
  • Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required signoffs
  • Involved in performance modeling, testing and analysis using Load Runner
  • Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL statements on SQL Database
  • Performed load testing for checking the application’s performance under various capacities using various strategies such as, Burst, and linear using SOAPUI
  • Verified and Validated the Test scripts
  • Documented defects, performed defect tracking, and defect resolution management using Jira
  • Extensively used QTP integrated environment like Data Table, Actions, Recovery scenarios
  • Performed Manual Functional testing with QC and Regression Testing
  • Retrieved files using SQL statements and UNIX commands
  • Coordinated between the automated testers, manual testers, and system administrator for the precise scheduling of the test runs
  • Interacted with Database Administrator and Network Administrator to resolve application issues
  • Interacted with developers to explain the software bugs and re-evaluated the fixed issues.

Education

Bachelor’s Degree in science -

01.2007

Skills

  • Manual tools expertise
  • Test scenarios
  • Test cases
  • Test data
  • Test procedures
  • Test reports
  • Quality Assurance
  • Automation Testing
  • SDLC
  • Agile methodologies (SCRUM)
  • HP ALM
  • QTP
  • Jira
  • Smoke Testing
  • Functional Testing
  • Integration Testing
  • Regression testing
  • Load Testing
  • Performance Testing
  • End to End Testing
  • User Acceptance Testing (UAT)
  • Requirements Traceability Matrix (RTM)
  • Metadata Repository (MDR)
  • SQL Objects
  • Back-End Testing/Database Testing
  • SQL queries
  • Bug Reporting and Tracking
  • XML
  • Complex issues and risks management
  • SQL Server
  • Teradata
  • DB2
  • MS Access
  • C
  • C#
  • SQL
  • Java
  • JavaScript
  • Windows
  • Unix
  • Linux
  • MS Suites (Word, Excel, Access, PowerPoint, SharePoint)

Timeline

QA Manual Tester

Maryland Dept. of Information Technology
06.2022 - Current

Manual Tester

Texas Dept. of Education
04.2019 - 06.2022

Bachelor’s Degree in science -

Jahan Zib John