MD Geshan
347-***-**** adjq1h@r.postjobfree.com
New York, NY 10017
Status: US Citizen
Software QA Analyst / QA Tester / QA Engineer / Quality Assurance Analyst/ Manual Tester/SQA
Objective:
Over seven years of experience in the Information Technology field specializing in Software Testing, including testing client/server and web-based applications running on Windows platform. Have a strong analytical background, experience in software requirements analysis, manual testing, test automation, and QA methodologies. Experienced on well-organized and highly capable of meeting deadlines, staying focused on tasks, and satisfying goals and objectives.
Key Expertise:
Manual Testing HP Application Lifecycle Management (ALM) / Waterfall Agile (Scrum) Methodology
Automated Testing HP Quality Center (QC) Test Scenario Design
Black box Testing HP Quick Test Pro (QTP) / UFT VB Script Test Plan Test Case
Functional & Regression Testing Jira TestRail Azure DevOps TFS & MTM, Rally Requirement Analysis
Integration & Smoke Testing Oracle, MS SQL Server Azure SQL Defect Logging
UAT & System Testing API Testing with Postman and SoapUI Report Analysis
Exploratory & UI/UX Testing Salesforce Sales, Marketing, Service Cloud
Education:
Bachelor’s in Computer Information Systems (CIS)
City University of New York, Baruch College
New York, NY
Associate’s in Business Administration
City University of New York, LAGCC
New York, NY
Professional Summary:
6+ years directly related experience, plus the ability to demonstrate the required knowledge, skills & abilities.
Experience in developing software Test plans, Test scenarios, Test cases and Test results documents.
Solid understanding in Software Development & Testing Life Cycle (SDLC & STLC) and various QA Methodologies.
Expert in overall Quality Assurance and software testing activities and process in various domain.
Worked closely with the BA to understand the business processes and developed various Test documents & testing process.
Experience analysis of various requirement documents such as Software Requirement specification (SRS)/ Functional Requirement specification (FRS), Business requirement specification (BRS), Use case, User stories and so on.
Have a good exposure of various software development life cycle such as Waterfall, Agile methodology (Scrum), Hybrid.
Expert in various Black Box testing such as Smoke, Functional (Positive, Negative), Integration, System, Regression, End to End, Ad-hoc, User Acceptance Testing (UAT), and Automation Testing.
Possess excellent skills in Manual Testing using manual testing tool like HP Application Lifecycle management (ALM)/ HP Quality Center (QC), TestRail, Microsoft Test manager (MTM).
Experience with defect tracking tools such as JIRA, Azure DevOps/VSTS/TFS in Agile project management process.
Automated Testing Experience in developing Automation Test scripts for regression testing including dynamic.
Parameterization using datasheets, database tables and external excel spreadsheets, virtual objects, checkpoints, file system object, virtual objects, VBScript classes/objects and descriptive programming.
Overall Experience in developing Test Automation Frameworks in Keyword driven, data-driven, and hybrid Methods.
Good knowledge of Salesforce configuration, Data migration, System integration Testing and familiarity with Visualforce (Pages, Components, Controllers) MVC architecture.
Expertise in Relational Database Management System (RDBMS), and working experience in writing complex SQL queries as well as basic SQL queries using various Joining’s.
Have strong knowledge of complex SQL, developing database queries for Backend Testing, in-depth Knowledge of Oracle and SQL Server, resolved Database Performance issues.
Ability to collaborate with diverse team members in projects also coordinate with offshore team members.
Performed Webservice/ API testing using Postman by writing various XML request and verifies response in JSON file.
Performed User Acceptance Testing (UAT) and interacted with client/ end-users to support UAT sessions.
Experience in Data Analysis, Developing Source to Target Mappings and ensure data integrity.
Professional Experiences:
Bloomingdale’s
New York, NY.
QA Analyst
Dec 2017 to Current
Interact extensively with the Product Owner and Business Area Subject Matter Experts (SME’s) to understand the Business Processes thoroughly. Identified opportunities for business process improvement through various meeting with business users and developers and initiated efforts to make improvements.
Provides input to staff involved in writing and updating technical documentation such as user manuals, system documentation, and training materials.
Follow Agile (Scrum) methodology to develop the application. Attend User story gathering meeting, Release planning and Sprint planning, Daily scrum, Demo and Retrospective meeting regularly. Work with various Epic, Features, User stories and acceptance criteria
Developed and implemented all kinds of documents (Test plan, test scenarios, test cases, test scripts, defect analysis report, RTM).
Perform Back-End Tests, Regression Tests, Ad-Hoc Tests, End to End Tests, Boundary Tests, GUI Tests, Functional testing with Positive and Negative Tests for the Application under Test (AUT).
Create and execute Test Cases for some of the modules of the application under test (AUT) using ALM.
Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using Application life cycle management (ALM) also Generate Test Analysis Reports and Graphs using ALM.
Also used Jira as a project management tool to log and track defects. Also, used Confluence as a Team Collaborating Tool.
Expertise in using Zephyr (JIRA plugin) to create and execute test cases.
Responsible for automation testing and create automation script using Descriptive programming using UFT/QTP tool followed by various automated framework such as Modular, Data Driven, Hybrid Frameworks.
Develop test scripts for Functional testing, System testing, Regression testing and Integration testing using Quick Test Pro (QTP)/ UFT.
Enhance the scripts by creating Actions, Checkpoints, Synchronization points, and data driven test and modular test in QTP.
Involve developing VB Scripts User-defined function to perform the Data Driven Testing using Quick Test Pro (QTP).
Expert In writing complex SQL queries using various joining and operators for Backend testing purpose using Oracle database and SQL Server.
Automated database validation in DB2, SQL Server, Oracle and utilized SoapUI/Ready API for automated API test cases.
Hands on experience on API tool Postman for manual validation, build Json/XML as per requirements for API testing.
Perform User Acceptance Testing and provide training to the end users about the new application.
Involve in the team meetings with representatives from Development, Database Management, Configuration Management, and Requirements gathering to identify and correct defects.
HSBC Bank USA
New York, NY
QA Test Engineer
Aug 2015 to Nov 2017
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.
Experience using different Frameworks like Hybrid, Keyword and Data Driven frame works in UFT, and extensively worked on Scripting using Shared Object repository and Descriptive Programming.
Experience in UFT–VB Script programming standards, developing reusable functional libraries used in different scripts.
Developing test cases/scripts for Regression tests in UFT, and Data Driven tests using automated test tools. Working experience with on site and offshore teams based on schedules.
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.
Wrote SQL queries in MS SQL Server RDBMS to verify the data with Backend to maintain Data Consistency, Integrity and Accuracy
Worked with a team of Project Managers, Business Analysts, Testing Analysts, Developers, DBAs, and Operations
Attended Release, Sprint planning, 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 been included through the RTM.
Sprint
Reston, VA
Software Test Specialist
Oct 2013 to Aug 2015
Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
Used Quality Center to track and report system defects
Involved in testing the XML files and checked whether data is passed and loaded to staging tables
Created and tested Salesforce CRM Workflows, Approval Processes, Validation Rules and Sharing & Security rules
Provided ongoing Salesforce.com maintenance and administration services including periodic data cleansing, custom objects, workflows.
Involved in testing functionalities in all stages of Salesforce Sales cloud, Marketing cloud as well as Service cloud
Tested with Front-End functionality for the entire application
Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity
Developed and maintained custom library, error handling, recovery scenarios, reporting methods and descriptive programming (DP) using VBScript in HP Quick Test Professional (QTP)
Maintained automation hybrid test framework and created scripts in Quick Test Professional (QTP) by VBScript on Web Portals of Provider Search, Benefits & Claims
Worked with Data Conversion projects for testing data quality after migration
Experienced using database query tools for Oracle, SQL and SQL Plus.
Experienced in data analysis using SQL, PL/SQL and many other queries-based applications
Involved in extensive DATA validation using SQL queries and back-end testing
Validated business reporting requirements with internal and external customers
Used workflow manager for session management, database connection management and scheduling of jobs
Technical Environment & Tools
Test Management Tools
JIRA, VSTS, Azure DevOps, Postman, SoapUI, ALM, Unified Functional Testing (UFT), HP Application Lifecycle Management (ALM).
Application Languages
Java, Visual Basic, C++, J2EE, DHTML, HTML, Macromedia Dream weaver, VB Script, .NET
Operating Systems
UNIX, MS DOS, Windows Vista, Windows XP, Windows NT
Database Tools
MS SQL Server 2005/08, Oracle11g, 10g, TOAD, MS Access
Microsoft Tools
MS Word, MS Excel, Power Point, Visual SourceSafe, MS Visio, and Outlook.
Application Server
Web Logic, IIS, and Apache.