Qa Analyst Sql Server

TITLE

Khairul A. Khan

E-mail:************@*******.***

Phone: 202-***-****

US Citizen, Public Trust Clearance

OBJECTIVE:

Eleven years of QA Analyst / Automation Tester seeking a contract/ permanent position with a promising, growing, stable, prestigious, high-tech organization to contribute my diverse technical and professional experience in designing, developing, implementing, and executing Test Design Specifications, Test Case Specifications, Test procedures. Using both Manual procedures and Automated testing tools in a Web based and Client/Server while experiencing challenging opportunities and growth.

CAREER SUMMARY:

Full Life Cycle experience, involved in requirement analysis, design, development, testing and support.

Experienced in Agile and Waterfall environment and Advance technology organizations with emphasis in Software Test Engineering and QA Software Analysis

Strong analytical skills for evaluating User Requirements, Business Process and System design and architecture

Expertise in designing and developing Test Strategy, Test plan, Test Cases, and generating Test Analysis Reports, Defect Reports and product quality assurance documentation.

Proficient in Oracle Relational Database Management System (RDBMS)and SQL Server, Access database

Good working experience in RDBMS like Oracle11i/10g/9i/8i/8.0, SQL Server, and DB2

Extensively created SQL and PL/SQL scripts and executed it to verify test conditions.

Proficient in both Manual and Automation testing using UFT (formerly QTP) and Selenium Tools

Expert in writing test cases using Element locators, Web Driver methods, Java programming features, TestNG annotations, and Cucumber for BDD framework using Gherkin language.

Writing code with Java, JavaScript and Selenium

Experienced in Data driven Testing, Cross browser Testing, and Parallel Test execution using Selenium WebDriver, TestNG, JUnit and Selenium Grid.

Extensive hands-on training in how to use Protractor: End-to-end test framework for Angular and Angular JS applications.

Used Jenkins to schedule jobs and send email for build status

Expert in conscientiously managing and follow up on multiple concurrent tasks and requests on set deadlines

Proficient in organizing and facilitating release planning, grooming, daily scrum, sprint reviews, retrospectives meetings

Experienced in getting the job done under pressure and in stressful environments

Experienced in web service testing, SOAP and REST, using SoapUI, Postman and REST Assure.

Writing code with Groovy language with Selenium to automate API testing.

API automation with Ready API

Experienced in designing UAT, Functional, Integration, and Regression Tests.

Expert in enhancing, writing, executing, and analyzing UAT, Database Checkpoints, and Data Driven Test Scripts for all projects using Selenium and Quick Test Professional (QTP/ UFT)

Expertise in the Defect Life Circle for Designing, Developing, Tracking, and Deliverables

Certified (DHS) 508 compliance Tester, following section 508 standards and WCAG 2.1 guidelines.

Extensively worked on UNIX, WIN 2000/NT/XP Platforms.

Tracked, identified, and logged bugs using JIRA, VersionOne and QC (ALM).

Experienced in authoring test reports at the end of testing. TECHNICAL SKILLS:

Testing Tools ALM, Quality Center, JIRA, UFT, Selenium IDE, Selenium Webdriver TestNG, JUnit, SoapUI, Groovy Script, Postman

Languages VB, C++, Java, JSON, Gherkin, PL/SQL, SQL

Web languages HTML, XML

Scripting Languages Java script, VB script, Web Driver,

Operating System Windows and UNIX

Microsoft Suite MS Office, Outlook, Excel, PowerPoint.

Database Oracle, SQL Server, MS Access

EXPERIENCE:

U. S. Department of Agriculture (USDA), Fairfax, VA. Q A Automation Tester

October 2020 – To Date

Conservation Desktop (CD) is the core Conservation Delivery Streamlining Initiative (CDSI) application that integrates NRCS's technical and financial information and processes into a common user interface. U. S. Department of Agriculture (USDA) would like to make it essay to the land user to apply for grant through this application online. To enhance application development process, it needs to automate their testing afford. Using Gauge (Selenium) for UI automation and using ReadyAPI to automate API testing.

Responsibilities:

Analyzed the Business requirement, Functional Requirement Document (FRD), and Design documents standard procedures to develop Test Plan, Test procedures, and Test cases.

Do the manual testing and document in Jira integrated Xray test case.

Part of UI automation team to automate the testing process using Gauge (Selenium).

Use aXe web accessibility evaluation tool, for 508 and WCAG 2.1 compliance

And 508 automations afford using Selenium and axe library.

Part of the performance testing afford using JMeter Social Security Administration (SSA), Baltimore, Maryland. Q A Automation Tester

March 2019 – August 2020

Social Security Administration (SSA) is modernizing the technology that supports disability case processing nationwide. SSA is building a modern system, the Disability Case Processing System (DCPS), to replace 54 independently operated, outdated systems across the Disability Determination Services (DDS), which are the State agencies that make disability determinations for SSA.

Responsibilities:

Analyzed the Business requirement, User Stories, and Design documents standard procedures to develop Test Plan, Test procedures, and Test cases.

Conducted daily regression test runs using Jenkins. If there were any failures in the regression test, find the reason for the failures and fix them daily.

Wrote smoke tests for the application (AUT) with Java, Gherkin, and Selenium.

Wrote JSON for PDF files to validate the content of letters, templates, and invoices.

Used SharePoint for sharing all documentation across stakeholders and users.

Used Version One as a project management tool. Created stories and tasks and followed the progress of the testing process.

Git /Git-hub was the version-control system used in the project

Also used Confluence as our content collaboration tool used to help teams collaborate and share knowledge efficiently, as developed by Atlassian.

Effectively tracked the team’s progress by implementing AGILE (Kanban) methodology in the environment

Attended Walkthroughs and Peer Review meetings with Business Operations, Analysts, and Design & Development teams

Analyzed requirements for SMS application developed in .Net and SharePoint

Wrote test cases using Element locators, Web Driver methods, Java programming features, TestNG / JUnit annotations, and Cucumber for BDD framework using Gherkin language.

Worked with team members to provide test objectives to verify Data warehouse testing

Identified and recommended changes to established practices and policies

Wrote and executed SQL scripts to verify backend test conditions

Continuously escalated potential issues, roadblocks, and risks, and openly discussed all potential issues with management.

Used Gherkin languages to write features and scenarios

Used Data driven Testing, Cross browser testing, and Parallel Test execution, with Selenium WebDriver, TestNG, Selenium Grid, and Sand Box

Tracked, identified, and logged bugs using Version One.

Used Jenkins to schedule jobs and send email for builds status. Washington Metropolitan Area Transit Authority (WMATA), Washington, D.C QA Tester

Jan 2017– Feb 2019

WMATA implemented a Safety Measurement System (SMS) in 2010 that enabled the Department of System Safety and Environment Management (SAFE) to measure the overall system safety of WMATA. SMS provides both WMATA and SAFE with a means to track and manage safety incidents, safety hotline reports, and hazards.

Responsibilities:

Analyzed the Business requirement, Functional Requirement Document (FRD), and Design documents standard procedures to develop Test Plan, Test procedures, and Test cases

Managed designed Functional and Integration testing by interviewing End User

Worked on multiple QA project tasks, timelines, and reporting and drove the projects to completion

Effectively tracked team’s progress implemented AGILE (scrum) methodology in the environment

Attended Walkthroughs and Peer Review meetings with Business Operations, Analysts, and Design & Development teams

Represented QA team in daily Scrum meeting for different projects

Interviewed end users to come up with proper requirements and designed the Test plan and Test cases

Analyzed requirements for SMS application developed in .Net and SharePoint

Wrote test cases using Element locators, Web Driver methods, Java programming features, TestNG annotations, and Cucumber for BDD framework using Gherkin language.

Worked with team members to provide test objectives to verify Data warehouse testing

Wrote SQL scripts to verify data mapping and accuracy in Data Warehousing testing

Automate web service testing, SOAP and REST, using SoapUI, Selenium with Groovy scripting language and Postman.

Identified and recommended changes to established practices and policies

Wrote and executed SQL scripts to verify backend test conditions

Monitored a system's compliance with established IT security requirements

Continuously escalated potential issues, road blocks, and risks and openly discussed all potential issues with the management team to enable early risk management and resource adjustment

Used Gherkin languages to write features and scenarios

Used Data driven Testing, Cross browser testing and Parallel Test execution, with Selenium WebDriver, TestNG, Selenium Grid.

Tracked, identified and logged bugs using JIRA.

Jenkins used to schedule jobs and send emails for build status.

Involved in gathering requirements from the Business people and from the Client.

Use aXe web accessibility evaluation tool, JAWS and NVDA for 508 and WCAG 2.0 compliance

Environment: Java, Java Script, Selenium, .Net, SharePoint, LDAP, IAM, HPALM, JAWS, UNIX, HTML, DHTML, XML, SOAP UI, Oracle 10g/9i.

Department of Labor, Washington, D.C.

QA Tester

Oct 2013 – Jan 2017

The current H-1B HUB InfoSPACE system supports analytical reporting based on the grantee file submissions. The Data warehouse also supports the current H-1B HUB Grantee Report System which grantees use to upload data, submit and retrieve their QPR data to the national office. The current SCSEP/ InfoSPACE System is accessed by users based on a tabular structure. The users navigate through the various H-1B HUB reports.

Responsibilities:

Analyzed Business Requirements, Functional Requirements, and Design Documents to develop Test Plan and wrote Test Cases.

Worked with the Business Analysts to determine Business Requirements and come up with test strategies, test plans, and test cases

Successfully implemented AGILE (scrum) methodology in the environment

Effectively tracked the team’s progress, including burn down, velocity and release forecasting

Creating Test Procedure document, which specifies step-by-step action for actual testing

Performed initial Smoke testing to determine if the product was stable enough to withstand a major testing effort like system, integration, and regression testing

Performed usability testing and Interface testing to test the user-friendliness of the website

Responsible for functional, regression, system, integration, back end, and end-to-end testing.

Developing Test Cases matching requirements with the help from business analysts using ALM/Quality center.

Tracking bugs using ALM/Quality Center and performed regression testing of the entire application once the bugs are fixed

Responsible for writing SQL queries for Backend testing

Performing Count Validation, Statistical Analysis and Data Quality Validation in Data Migration.

Used aXe web accessibility evaluation tool, JAWS and NVDA for 508 and WCAG 2.0 compliance

Developing ETL test scripts based on technical specifications/Data design documents and Source to target mappings using Informatica

Involved in creating automation test scripts using selenium, cucumber built on Eclipse

Involved in mentoring and assigning tasks to team members.

Created test reports at the of release

Environment: ALM, QTP, J2EE, VB, .Net, Oracle, HTML, XML, SQL, Jenkins, MS Office, Windows, CERTIFICATION:

508 COMPLIANCE TESTER CERTIFICAT (DHS)

CLEARANCE:

Public Trust Clearance.

EDUCATION/CERTIFICATIONS:

• Master of Social Science

• Bachelor of Social Science

Contact this candidate