Md Yeasir Arafat

Software Quality Assurance Analyst

Phone: 917-***-****

Address: Bronx, NY 10467

Email: adjy87@r.postjobfree.com

linkedin.com/in/md-yeasir-arafat-690b578b

Objective

Solutions-focused, multifaceted IT professional offering 7+ years of hands-on experience in Quality Assurance Testing (manual, automation) coordinating creation of complex enterprise applications including enterprise testing on Web and Window based applications. Possess a strong understanding of application and system capabilities to provide customized solutions that meet business requirements. Additionally, eager to learn new methodologies and processes as well as positively contribute to team and organization goals.

Core Competencies

Waterfall and Agile (Scrum, Kanban) Methodology

Test management with QC/ALM/JIRA/RALLY/Azure DevOps

Requirement and design Gathering & Analysis.

Design Test Plan, Test scenarios, Test cases

Manual Testing & Automation Testing in QTP/ UFT

Core team meeting and weekly status update

Risk analysis, Defect analysis, and Test Reporting

Black Box, UAT, and Backend Testing, Integration

Software Development Life Cycle (SDLC) & STLC

Descriptive programming, VB script, Regression

API Testing using Postman

Summary of Experiences

Over 7 years of experience in Information Technology with emphasis on Software Quality Assurance and Testing as a manual and automation tester in web based and client server-based application.

Experienced in all stages of the Software Development Life Cycle (SDLC) beginning from initiation and definition to deployment and support.

Collaborated with development team to understand new product features for the purpose of designing and developing test scenarios and cases.

Experienced working in various methodologies specially waterfall and Agile Scrum development environment.

Extensive knowledge of testing concepts, verification and validation techniques, defect management, quantitative methods, risk management and measurement programs.

Analyzed user stories to create manual & automated test cases that cover a broad profile of the application.

Proficient in preparing the test plans, test scripts and test cases by analyzing Business Requirements and various other ARTIFACTS with a strong ability to Work closely with Dev team and Business Analysts to analyze the test scenarios.

Proficient in different phases of Testing including Black Box, Functional, Integration, System, Back-end, Regression, smoke, End to end, Ad-hoc, Exploratory, UX/UI, Usability and User Acceptance testing (UAT).

Extensive experienced with writing and utilizing SQL queries using Oracle Developer, TOAD against RDBMS databases such as Oracle and MS SQL Server.

Extensive experience in Test Management tools like HP Application Life Cycle Management (HP ALM), Jira, Zephyr, Test Rail).

Proficient in using HP Unified Functional Testing (HP UFT) for automated testing of functional & regression testing.

Experienced in Automation Testing including creating test scripts, various enhancements- Parameterizing, Optional Step, Regular Expression and Synchronization techniques.

Testing with API with Postman.

Proficient in multiplatform (Windows) and cross browser testing (IE, Firefox, Chrome, Safari)

Work Experience

Senior QA Analyst

Ralph Lauren, New York, NY Dec 2018 - Current

Analyze the User Stories and Design specifications documents to ensure that the system met all the technical and business requirements and Involve in User story analysis and estimation.

Responsible in assisting the QA Manager by defining and developing from test strategy to test plans and creating test scenarios/cases by analyzing business/technical requirements and system designs to provide all types of testing.

Write manual test scenarios and test cases based on the user stories, change requests and functional design doc.

Perform story Analysis by gathering both functional and non-functional requirements based on interactions with the process owners, document analysis and represented them in Requirements Traceability Matrix (RTM).

Design all manual test cases step by step into HP Application Life Cycle Management (ALM) in the Test Plan section.

Performing Web-based Testing including GUI Testing, Black-Box Testing, Smoke Testing, Functional Testing, Backend Testing, Regression Testing, Integration Testing, System Testing, Functional Testing, Exploratory Testing, UX/UI Testing, Usability, and User Acceptance Testing.

Execute various kinds of manual testing and update the results in HP ALM in the Test Lab section.

Manually test all the modules by inserting various data to perform data validation with positive and negative data.

Log defects and tracked them using JIRA till its closure following company defect life cycle.

Assisting the DEV team in Defect analysis with the Client to decide what Defects should be assigned, fixed, rejected or deferred to be dealt with later.

Executing Regression Testing as required to ensure that the latest delivery has not ruined anything, and that the software product is still working correctly.

Perfumed API testing using Postman.

Conduct Backend Testing using SQL queries with select, insert, update statements to validate, manipulate and retrieving data from Oracle database for executing user specific test cases.

Write complex SQL queries using various kinds of joining to retrieve complex data from the RDBMS.

Developed Test scripts to worked with automation team following Data driven framework using VB script, Descriptive Programming, script enhancement of Check Points utilizing HP UFT (Unified Functional Testing) for Regression and Functional testing.

Completing Exit Criteria to store all key outputs, lessons learned, results, logs, documents related to the project to use them as a reference for future projects.

Attending Sprint Planning, Grooming, Daily Stand-up, Demo and Retrospective meetings as required.

Experienced in mobile testing to test the application in different mobile platforms IOS & Android with real devices.

Actively used Rally test management tool to design manual test cases, update test cases, update execution result, manage test scenarios, log defect, and retest defect as well as various reporting.

Working with clients and customers to assess their needs, provide information or assistance, resolve their problems, and/or satisfy their expectations.

Sr. Software QA Tester

Amica Mutual Insurance, Lincoln, RI Jun 2017- Dec 2018

Extensively involved in analyzing the User Stories and Design specifications documents to ensure that the system met all the technical and business requirements also involved in sprint test estimation.

Followed Agile Scrum methodology attended various meeting such as Release Planning, Sprint Planning, Daily Scrum, Demo and Retrospective meeting with the scrum team.

Developed detailed Test plan based on software requirements specifications and updated RTM document.

Wrote & executed Test cases for each functionality based on the product functional specifications.

Performed Smoke, Functional, Integration, System, Backend, Usability and Regression Testing on the updated application. Performed Web testing of the functionalities of the web application. Performed Regression Testing for fixes and modifications and closed the defects.

Wrote SQL queries in MS SQL Server RDBMS to verify the data with Back-End to maintain Data Consistency, Integrity and Accuracy

Worked with a team of Project Managers, Business Analysts, Testing Analysts, Developers, DBAs, and Operations

Attended Product Backlog, Release backlog, Sprint backlog, Daily Stand-up, Peer Review, and Defect Report meetings periodically.

Participated in all the meetings related to Sprint planning, daily stand-up Developed Test cases based upon template, executed test cases and logged the defect using Jira and Test Rail.

Mapped test cases back to the functional requirements for ensuring all the requirements are being included through the RTM.

Used Automation tool like HP Quick test pro (QTP) for creating automation test script along with debugging to enhancing the script for execution purpose.

Reviewed and updated existing automation script using check point, wait statement, parameterization followed by VB script and used descriptive programming time to time as per team demand.

Quality Assurance Analyst/QA Analyst

Key Bank, Cleveland, OH May 2015 - May 2017

Analyze Business Requirement document and develop Test Plan for System testing.

Write Test Plans and Test Cases into Quality Center for Functional and Regression Testing.

Involved in Data Preparation and Execute Tests for the project, and manually tested the application.

Responsible for the creation of the Test Plan, generating of various Test Scenarios and Test Cases.

Perform Functional Testing, Integration Testing, Sanity testing and Regression testing on the application.

Perform System, Integration, Regression, Functional and UAT testing.

Develop and updated Requirement Traceability matrix (RTM) to trace the requirements and corresponding developments through the Software Development Life Cycle

Create and enhanced automation test scripts in Quick Test Pro to perform the regression testing.

Enhance QTP script using checkpoints, parameterization, regular expressions and optional steps.

Create scripts, inserted different types of Check Points and created regular expression.

Extensively use VB Scripts to perform descriptive programming in QTP.

Write SQL query to perform data validation and verification and execute them in Query analyzer.

Jira and Test rail is used to store all the documentation, release management, bug tracking, test management purpose.

Work as a team or project leader providing direction to team activities and facilitates information validation and team decision making process.

Provide management with status, impact analysis and recommendations necessary to make decisions to resolve issues and meet commitments regarding Test deliverables.

Providing testing status to the project manager on daily basis.

Associate QA Tester

EmblemHealth, New York, NY Oct 2013 - Apr 2015

Interacted with Business Analysts and Software Developers to find out exact functionality of application. Prepared test cases based on the business requirement document and design document, followed waterfall methodology.

Assisted in developing Test Plans for testing the functionality, GUI, and usability of the application.

Performed manual testing, considering the base line of developed Test Plan and Test Cases considering both positive and negative scenarios also boundary scenarios.

Executed Test Case developed by self or peers. Compared and analyzed actual to expected results and reported all deviations for resolution.

I was responsible for designing and documenting repeatable test. Performed Smoke, Integration, Functional, Regression, GUI and UAT testing.

Used HP Quality Center (QC) bug tracking tool to report application bugs and enhancements request and discussed with developers to resolve technical issues.

Interacted with developers to resolve defects, and I was responsible to create Test Data for functional testing and User Acceptance Testing (UAT).

Performed functional testing for new release enhancements, also Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on Oracle.

Participated actively in the team meetings with the developers for bug reviews.

Responsible for writing SQL queries to retrieve data from Oracle database, also Responsible for updating and deleting data in database.

Technical Environment and Skills

Testing Tool

HP UFT/QTP, HP QC/ALM, Jira, Zephyr, Test Rail, RALLY, Postman

Operating System

Windows Server, Windows 10/7/XP/Vista/98

Web Technologies

HTML, XML, VB.NET, ASP.NET, C#, VB Script, CSS, Java

Database

Oracle, MS SQL Server, Toad, DB2, MS Access

Methodology

SDLC, Agile, Waterfall, Iterative

Testing

Functional, Smoke, Integration, Regression, Backend, End to end, System, Ad hoc, System, Exploratory, UI/UX, Usability, UAT testing, Api testing

Communication Tool

MS Outlook, Slack, Skype Business, Lync, Office communicator

Contact this candidate