Harpreet Kaur Sandhu
QA Analyst
Email: ********.********@*****.***
LinkedIn Profile: https://www.linkedin.com/in/harpreet-kaur-sandhu-qaanalyst/
EXPERIENCE SUMMARY:
●6 years of diversified experience as QA Analyst in agile (scrum) projects testing web based online applications, desktop applications, API testing, mobile testing, and data warehousing applications.
●Proven agile projects delivery and execution expertise supported by Microsoft Certified Azure Fundamentals, Certified Scrum master, CTFL and CTFL-AT certifications.
●Extensive test execution in SIT, UAT, and production environments.
●Release management experience, managing release milestones, creating release documents, reporting daily status, and highlighting risks and execution status.
●Actively participate in Scrum Planning, decomposing Product Backlog Items into tasks and estimating efforts.
●Hands-on in developing Software Test Plans, Business scenario matrix, Test Case Design, and Test Scripts based on System Requirements Document (SRD) and Business Requirements Document (BRD).
●Fundamental experience in automation testing using Selenium WebDriver/TestNG framework/Maven/Java.
●Involved in analyzing business requirement documents and technical specification documents and developing a test plan and test cases for testing the application.
●ETL testing experience with Informatica PowerCenter.
●Performance testing using JMeter and API testing using Postman tools.
●Expert level backend testing knowledge using SSMS-SQL Server.
●Performed mobile testing using Accela Mobile Office and browser stack across different Operating systems and browsers.
●Working experience of defect tracking tools Azure DevOps TFS, JIRA and HP ALM/QC.
●Hands-on experience on DHS Section 508 Compliance Test Processes and accessibility testing using JAWS.
●Backed by strong credentials, master’s in computer and information Sciences (USA) and MBA.
●Independent contributor, team player and possess strong communication skills.
●Seeking an opportunity to bring value added practices to projects and learn new skills to develop professionally.
TECHNICAL SKILLS:
Testing
Functional/Non-Functional Testing, SIT, UAT, Regression Testing, Performance Testing, Stress Testing, Usability Testing, Accessibility Testing
Functional Testing Tools:
POSTMAN, JMeter, Dynamics 365
HP Unified Functional Testing (UFT, formerly QTP), Selenium
Testing & Defect Management Tool
HP Quality Center/ HP ALM 11.5, JIRA, Azure Devops, Test Link, MS Office, SharePoint, Confluence
Testing Methodologies
Agile, Scrum, Waterfall, V-Model
Domain:
Insurance, Govt sector, Finance, Information Security, Licensing
CERTIFICATIONS:
●Microsoft Certified: Azure Fundamentals
●Certified Scrum Master (CSM)
●ISTQB Foundation Level (CTFL)
●ISTQB Agile Testing (CTFL-AT)
WORK EXPERIENCE:
QA Analyst
Cognizant MBG – Dec 2020 to Present
Location- Toronto, Canada
Project: Data Validation and API Testing
Data and Analytics project goal is system and data integration using accessible data and analytics tools. To provide advanced reporting capabilities to users by working on challenges like removing volatility in data sources and data bottlenecks.
Responsibilities:
●Work closely with the System Integrator and the Project Team members to test applications in SIT and UAT environments.
●Facilitated high complexity Agile initiatives from initiation through release, provided oversight to ensure alignment with Agile/Scrum practices, including but not limited to project kick-off, sprint, release, and deployment planning.
●Create Business scenario matrix, test cases based on requirement documents.
●Database and Data validation testing using SQL and Excel using Ablebits tool.
●Release management lead responsible for overall delivery of each iteration testing and entire release.
●Report major release milestones status and any risks causing delays on daily basis.
●Maintenance of Release management documentation including automation feasibility, lessons learned, production issue tracker, defect audits.
●Conducted biweekly demos for clients to incorporate their feedback in the requirements.
●Automate regression test cases after conducting feasibility tests based on reusability and current manual efforts required using Selenium.
●Maintenance of existing automation test scripts incorporating new or changed workflows before every release regression testing.
●Used Azure devops to create, assign and track defects and to create weekly defect status reports.
●Performed API testing using POSTMAN and load testing using JMeter.
●Publish Monthly progress report, Weekly status reports and potential risks report.
●Test upstream and downstream applications based on requirements, interface testing with partner systems.
●Report daily execution status, blockers in daily scrum, part of daily triage, prioritization meeting before end of each release.
●Part of Go/No-Go meetings before deploying in production.
●Communicate risks with partner teams related to incomplete or incorrect requirements, prioritize critical defects to complete testing on time.
●Coordinate with the Operations team, help them execute scenarios critical from operations perspective by conducting walkthrough sessions of requirements.
●Mobile testing on devices Android, iPhone, iPad and blueberry with different browsers using devices and browser stack applications.
QA Analyst
TEKsystems – June 2018 to Aug 2019
Location- Toronto, Canada
Project: Enterprise eLicensing
The government enterprise e-licensing system provides a single gateway for businesses and individuals to apply for and manage their business, professional, alcoholic-beverage, and occupational licenses. Using Accela Automation lowers agency costs and increase productivity by reducing license management and enforcement cycle times, streamlining business processes, and eliminating outdated, legacy systems.
Responsibilities:
●Test Planning and execution of agile project implementing scrum framework.
●Design test scripts, test conditions and test scenarios by mapping to business requirements in the Requirement traceability matrix.
●Guide team members core agile values and principles for continuous improvement.
●Test API services in an agile environment using Postman.
●Perform User Acceptance testing, Functionality testing, Regression testing, Performance testing, End-to-End System integration testing.
●Conduct daily stand-up meetings to track project progress.
●Participate in risk analysis meetings and create risk response strategies.
●Create SQL queries for test data selection and data verification using SQL server.
●Postproduction testing support and testing.
●Handle automated and ad hoc SQL jobs for data synchronization.
●Report and manage defects in JIRA in integration with Confluence.
●Working in an agile environment and attended the project status meetings and discussed project related issues, risks and testing roadblocks with the team.
●Extensive data validation testing for files from vendors as per business requirements for each licensing board.
●Execute mobile testing scenarios using Android, iPhone, iPad, and blueberry with different browsers using devices and browser stack applications.
●Perform Web application performance testing using JMeter.
●Facilitate defect triage meetings to address the defects for quick resolution and workarounds.
QA Analyst
LEAD IT Corporation – Apr 2016 to Dec 2017
Project: Customer Access Control
Used Aveksa’s Compliance Manager (ACM) Tool to automate the efforts to recertify the privileged user access and perform data validation using Able bits and Synchronizer data validation tool. The process involves verification of email workflow of reviews containing privileged user access.
Responsibilities:
●Perform data analysis for reviews with huge user volume and create analysis reports with different parameters.
●Create and execute test cases in QA and PROD environments. Helped business users to test in UAT.
●Design test plan and test strategies to define the different types of testing techniques Functional, Backend, Role based testing, security testing, compatibility testing.
●Interface testing using Interchange platform with different vendors.
●Execute automated jobs to generate reviews in ACM.
●Verified back-end data was correctly loaded into SQL tables through Query Analyzer.
●Test real time updates between frontend and backend applications.
●Demonstrate the use of data analysis tools to business users to reduce the manual efforts and automate their daily tasks.
●Conversion, batch testing and testing functionality of the created interfaces.
●Extensively worked with JAWS tools to perform accessibility testing following WCAG.
●Conduct gap analysis to document all business requirements that have been met by the application and find work around for the discrepancies.
●Defect tracking and reporting using HP Quality Centre and JIRA.
●Crucial time and data sensitive vendor management for the interface testing.
●Perform Section 508 technical requirements testing for Software and Websites
EDUCATION
Master of Computer and Information Sciences (MS-IT)
Southern New Hampshire University, USA
Master of Business Administration (MBA)
Symbiosis University, India
WORK AUTHORIZATION
Canada Citizen