Sr QA Analyst
Simarpreet Singh Sandhu
Technical Skills:
Testing Tools: HP Quality Center, HP ALM, QuickTest Professional, HP UFT, JIRA, Zephyr, SOAP UI
Operating systems: Windows, UNIX/Linux
Programming Language: VB.NET, Visual Basic, SQL, PL/SQL, VBScript, JavaScript,
Web & App Servers: Web logic Server, IIS, Java Web Server, Apache Tomcat
Database: Oracle, SQL Server, MS Access, SOQL
Web Technologies: HTML, XML, .NET Framework, JavaScript, Java
Applications: MS Office, Crystal Reports, MS Excel, Marketo, ICIMS
Cloud Application: Salesforce
Professional Experience:
Charles Koch Institute/ Freedom Partner Shared Service August 2017-Current
Salesforce QA Analyst (SME)
• Established well-defined QA Processes that promotes transparency and standardization.
• Created templates for various test documentation (Test Plans, Test Cases, Defects, Reports, etc.).
• Responsible for defining Testing Scope and Objectives of various level of testing.
• Develop, maintain, and execute test plans for requirement/user story validation, integration, regression, data migration and usability testing
• Define End-To-End testing process and methods in a Salesforce environment including cross system integrations across multiple work streams.
• Create and maintain reusable test data for Functional Testing and UAT
• Research and find opportunities to utilize SFDC QA best practices, guidelines to improve system productivity, scaling and monitoring
• Ensure proper tracking, oversight, and communication of QA efforts on each project
• Maintain progress of testing and coordinate testing efforts with development sprints
• Manage testing status in our Issue and Project planning software, e.g. Jira
• Trace test cases and results back to specific user stories/requirements/quality risks
• Participate in road-map planning to provide recommendations and concerns in meetings with Business Owners, Tech Managers and other Stakeholders
• Define QA metrics and report daily, weekly and as needed by the SFDC team.
• Establish Quality Gates that determine when and if Functional Testing can begin, and when and if UAT can begin once Functional Testing has been completed.
• Determine a Standard of Care for defects found during QA Functional Testing (Root Cause Analysis)
Nextgen Healthcare March 2017 – July 2017
Test Lead
• Established the QA Environment and formulated various QA Best Practices
• Led a team of 6-8 manual and automation test engineers while ensuring the team followed established guidelines and practices
• Responsible for creating Test Plans and Test Strategies based on Requirement Analysis
• Reviewed Test Scenarios and Test Cases generated by the Testing Team
• Determined Testing LOE for each Sprint in a collaboration with the Testing Team
• Accountable for communicating testing roadblocks to the Scrum Team and resolving the roadblocks in collaboration with the Product Owner and Scrum Master
• Managed the Defect Lifecycle and held Defect Triage meetings daily to efficiently resolve open defects
• Held regular Process Review Meetings with the Testing Team to ensure that the best QA practices were in place and to provide a forum for suggestions from the team to help with continuous improvements
• Leveraged ALM for Test Management and Defect Management tasks
• Generated various reports including Requirement Traceability Matrix (RTM) to ensure Test Coverage
• Provided regular QA Status updates to the team
• Leveraged HP UFT for Test Automation of the regression suite
• Led the creation of Automation Frameworks using UFT including Keyword-Driven Framework to help with Regression Testing
Kaiser Permanente September 2015 – March 2017
Sr. QA Engineer
• Established processes and procedures to implement repeatable quality testing process by introducing metrics, test documentation, and reassigning responsibilities.
• Enhanced bug triage practices to be more efficient and effective by introducing regular Bug Scrub Meetings during Regression Testing Cycles and Functional Testing Cycles
• Assured that all features of a software program were thoroughly tested, detected problems were properly reported and assigned and brought to resolution.
• Defined the Test Strategy and worked on improving it and correlating the strategy to total cost of application.
• Created Release-Level Test Strategy, Project-Level Master Test Plans and Worked Break Down Structures by effectively conducting capacity planning for test teams
• Worked in a Scrum Methodology by participating in Scrum Meetings including Daily Scrum, Sprint Planning, Sprint Review, and Sprint Retrospective Meetings
• Performed Functional Testing, Browser Compatibility Testing, Integration Testing, and Automation Testing.
• Executed Test Cases and reported defects to Product Owners and developers using HP ALM
• Used HP ALM for tracking, reporting and managing of defects.
• Conducted Back End testing by writing complex SQL queries and testing triggers and PL/SQL procedures.
• Developed Data Driven Test Scripts using HP Unified Functional Testing
• Planned the Automation Testing efforts for the project
• Prepared Test Traceability Matrix to confirm the test coverage
• Developed automated Test Scripts to perform Functional Testing, Integration Testing, System Testing and Regression Testing of the application using UFT.
• Developed Automation Test Scripts using VBScript and Descriptive Programming in UFT.
• Spearheaded the designing and development of a Hybrid Automation Framework using UFT.
• Coordinated with multiple different teams including remote groups.
• Led User Acceptance Testing for various projects
• Documented and summarized test results and report findings.
• Organized and recorded detailed test results, provided reports of results and project status.
• Coordinated meetings with the Development teams for appropriate handling of the bugs and their timely resolution.
• Determined LOE for Manual and Automation Testing Strategies
• Communicated directly with internal clients about release status and scheduled releases with internal clients.
• Environment: HP ALM, UFT, Java Script, VB Script, PHP, Windows, Java, SQL, HTML, XML, MS Office, MS Excel, MS Visio, UNIX/Linux.
J. Crew October 2012 - August 2015
Test Automation Engineer
• Performed testing in both long and short term timelines and with local and remote teams and also tried to innovate on how to best automate testing processes.
• Helped to set up Test data and Test environment for running Test cases.
• Developed Test Plans and executed Test cases based on requirements gathered from product owners and stakeholders.
• Took an active part in all stages of Software Development Life Cycle.
• Responsibility for Manual, Functional, Migration and Regression Testing of features scheduled for release.
• Planned for and executed GUI, usability, functionality and regression testing on QA Servers.
• Used Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.
• Used Quality Center to perform defect tracking and reporting.
• Involved in defect tracking, defect reporting, analyzing results and documenting using Quality center.
• Wrote SQL queries and executed procedures to perform back end testing for the expected results.
• Developed the Test Plans, Test Cases, Test Scenarios and executed them using QTP.
• Performed Data Driven Testing for multiple sets of data using QTP.
• Created QTP regression automation scripts.
• Developed automated QTP scripts using Keyword Driven Framework and Hybrid frameworks.
• Identified all windows, Pages, Objects, Methods and Properties and created Custom code Script with Parameterization, programming logic and data driven types using VB Script in QTP.
• Developed script and performed Web Services Testing & API Testing using Soap UI
• Created Data Driven Automation Framework and Hybrid Framework using Descriptive Programming via QTP
• Worked with Onsite/Offshore teams and coordinated Test activities.
• Coordinated User Acceptance Test (UAT) processes and documented and addressed all the issues during the process
• Participated in bug triage meetings with developers to validate the severity of the bug.
• Environment: QTP, HP Quality Center, Java, Java Script, Oracle, MS Visio, HTML, SQL Server, VB Script, MS Excel, MS Office, Windows, UNIX.
Wells Fargo July 2010 - September 2012
Software Tester
• Generated and communicated Test execution reports, performed failure investigation and Test script adjustments.
• Wrote/ Modified Test plans, Test cases and Test Scripts.
• Designed Test Cases according to the Functional Specifications.
• Executed Test Cases to validate product compliance with requirement.
• Executed Functional, Regression and Integration Test cases while effectively communicating Test results.
• Performed Test Reporting and Analysis of Test Results.
• Performed Black Box, Smoke, System, and User Acceptance Testing.
• Executed automated and manual testing using HP Quality Center.
• Provided appropriate reporting and metrics utilizing Quality Center and other tools.
• Conducted Back-end testing using Oracle.
• Prepared reports by developing and executing SQL queries.
• Planned QTP testing process by Analyzing the AUT
• Created a Key Word Driven Framework using QTP.
• Involved in data driven test by using Quick Test Pro.
• Integrated QTP scripts with Quality Center to manage the entire Automation testing process.
• Performed Functional and Regression testing by developing and executing automated test scripts using QTP.
• Updated QTP scripts after delivery as required by the new version.
• Trained new joiners in QTP as well as the ongoing project.
• Assisted in training the UAT users at client location upon system implementation of the developed to familiarize them.
• Provided software validation, design controls, and risk management training.
• Attended review meetings and walkthroughs to discuss the status of the project.
• Environment: .NET, HTML, Java, Oracle, Windows, Java Script, VB Script, Web Services, QTP, C, Quality Center, UNIX.
Education:
Central Queensland University Sydney, Australia
Bachelors, Hospitality Management
Simarpreet Singh Sandhu
Technical Skills:
Testing Tools: HP Quality Center, HP ALM, QuickTest Professional, HP UFT, JIRA, Zephyr, SOAP UI
Operating systems: Windows, UNIX/Linux
Programming Language: VB.NET, Visual Basic, SQL, PL/SQL, VBScript, JavaScript,
Web & App Servers: Web logic Server, IIS, Java Web Server, Apache Tomcat
Database: Oracle, SQL Server, MS Access, SOQL
Web Technologies: HTML, XML, .NET Framework, JavaScript, Java
Applications: MS Office, Crystal Reports, MS Excel, Marketo, ICIMS
Cloud Application: Salesforce
Professional Experience:
Charles Koch Institute/ Freedom Partner Shared Service August 2017-Current
Salesforce QA Analyst (SME)
• Established well-defined QA Processes that promotes transparency and standardization.
• Created templates for various test documentation (Test Plans, Test Cases, Defects, Reports, etc.).
• Responsible for defining Testing Scope and Objectives of various level of testing.
• Develop, maintain, and execute test plans for requirement/user story validation, integration, regression, data migration and usability testing
• Define End-To-End testing process and methods in a Salesforce environment including cross system integrations across multiple work streams.
• Create and maintain reusable test data for Functional Testing and UAT
• Research and find opportunities to utilize SFDC QA best practices, guidelines to improve system productivity, scaling and monitoring
• Ensure proper tracking, oversight, and communication of QA efforts on each project
• Maintain progress of testing and coordinate testing efforts with development sprints
• Manage testing status in our Issue and Project planning software, e.g. Jira
• Trace test cases and results back to specific user stories/requirements/quality risks
• Participate in road-map planning to provide recommendations and concerns in meetings with Business Owners, Tech Managers and other Stakeholders
• Define QA metrics and report daily, weekly and as needed by the SFDC team.
• Establish Quality Gates that determine when and if Functional Testing can begin, and when and if UAT can begin once Functional Testing has been completed.
• Determine a Standard of Care for defects found during QA Functional Testing (Root Cause Analysis)
Nextgen Healthcare March 2017 – July 2017
Test Lead
• Established the QA Environment and formulated various QA Best Practices
• Led a team of 6-8 manual and automation test engineers while ensuring the team followed established guidelines and practices
• Responsible for creating Test Plans and Test Strategies based on Requirement Analysis
• Reviewed Test Scenarios and Test Cases generated by the Testing Team
• Determined Testing LOE for each Sprint in a collaboration with the Testing Team
• Accountable for communicating testing roadblocks to the Scrum Team and resolving the roadblocks in collaboration with the Product Owner and Scrum Master
• Managed the Defect Lifecycle and held Defect Triage meetings daily to efficiently resolve open defects
• Held regular Process Review Meetings with the Testing Team to ensure that the best QA practices were in place and to provide a forum for suggestions from the team to help with continuous improvements
• Leveraged ALM for Test Management and Defect Management tasks
• Generated various reports including Requirement Traceability Matrix (RTM) to ensure Test Coverage
• Provided regular QA Status updates to the team
• Leveraged HP UFT for Test Automation of the regression suite
• Led the creation of Automation Frameworks using UFT including Keyword-Driven Framework to help with Regression Testing
Kaiser Permanente September 2015 – March 2017
Sr. QA Engineer
• Established processes and procedures to implement repeatable quality testing process by introducing metrics, test documentation, and reassigning responsibilities.
• Enhanced bug triage practices to be more efficient and effective by introducing regular Bug Scrub Meetings during Regression Testing Cycles and Functional Testing Cycles
• Assured that all features of a software program were thoroughly tested, detected problems were properly reported and assigned and brought to resolution.
• Defined the Test Strategy and worked on improving it and correlating the strategy to total cost of application.
• Created Release-Level Test Strategy, Project-Level Master Test Plans and Worked Break Down Structures by effectively conducting capacity planning for test teams
• Worked in a Scrum Methodology by participating in Scrum Meetings including Daily Scrum, Sprint Planning, Sprint Review, and Sprint Retrospective Meetings
• Performed Functional Testing, Browser Compatibility Testing, Integration Testing, and Automation Testing.
• Executed Test Cases and reported defects to Product Owners and developers using HP ALM
• Used HP ALM for tracking, reporting and managing of defects.
• Conducted Back End testing by writing complex SQL queries and testing triggers and PL/SQL procedures.
• Developed Data Driven Test Scripts using HP Unified Functional Testing
• Planned the Automation Testing efforts for the project
• Prepared Test Traceability Matrix to confirm the test coverage
• Developed automated Test Scripts to perform Functional Testing, Integration Testing, System Testing and Regression Testing of the application using UFT.
• Developed Automation Test Scripts using VBScript and Descriptive Programming in UFT.
• Spearheaded the designing and development of a Hybrid Automation Framework using UFT.
• Coordinated with multiple different teams including remote groups.
• Led User Acceptance Testing for various projects
• Documented and summarized test results and report findings.
• Organized and recorded detailed test results, provided reports of results and project status.
• Coordinated meetings with the Development teams for appropriate handling of the bugs and their timely resolution.
• Determined LOE for Manual and Automation Testing Strategies
• Communicated directly with internal clients about release status and scheduled releases with internal clients.
• Environment: HP ALM, UFT, Java Script, VB Script, PHP, Windows, Java, SQL, HTML, XML, MS Office, MS Excel, MS Visio, UNIX/Linux.
J. Crew October 2012 - August 2015
Test Automation Engineer
• Performed testing in both long and short term timelines and with local and remote teams and also tried to innovate on how to best automate testing processes.
• Helped to set up Test data and Test environment for running Test cases.
• Developed Test Plans and executed Test cases based on requirements gathered from product owners and stakeholders.
• Took an active part in all stages of Software Development Life Cycle.
• Responsibility for Manual, Functional, Migration and Regression Testing of features scheduled for release.
• Planned for and executed GUI, usability, functionality and regression testing on QA Servers.
• Used Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.
• Used Quality Center to perform defect tracking and reporting.
• Involved in defect tracking, defect reporting, analyzing results and documenting using Quality center.
• Wrote SQL queries and executed procedures to perform back end testing for the expected results.
• Developed the Test Plans, Test Cases, Test Scenarios and executed them using QTP.
• Performed Data Driven Testing for multiple sets of data using QTP.
• Created QTP regression automation scripts.
• Developed automated QTP scripts using Keyword Driven Framework and Hybrid frameworks.
• Identified all windows, Pages, Objects, Methods and Properties and created Custom code Script with Parameterization, programming logic and data driven types using VB Script in QTP.
• Developed script and performed Web Services Testing & API Testing using Soap UI
• Created Data Driven Automation Framework and Hybrid Framework using Descriptive Programming via QTP
• Worked with Onsite/Offshore teams and coordinated Test activities.
• Coordinated User Acceptance Test (UAT) processes and documented and addressed all the issues during the process
• Participated in bug triage meetings with developers to validate the severity of the bug.
• Environment: QTP, HP Quality Center, Java, Java Script, Oracle, MS Visio, HTML, SQL Server, VB Script, MS Excel, MS Office, Windows, UNIX.
Wells Fargo July 2010 - September 2012
Software Tester
• Generated and communicated Test execution reports, performed failure investigation and Test script adjustments.
• Wrote/ Modified Test plans, Test cases and Test Scripts.
• Designed Test Cases according to the Functional Specifications.
• Executed Test Cases to validate product compliance with requirement.
• Executed Functional, Regression and Integration Test cases while effectively communicating Test results.
• Performed Test Reporting and Analysis of Test Results.
• Performed Black Box, Smoke, System, and User Acceptance Testing.
• Executed automated and manual testing using HP Quality Center.
• Provided appropriate reporting and metrics utilizing Quality Center and other tools.
• Conducted Back-end testing using Oracle.
• Prepared reports by developing and executing SQL queries.
• Planned QTP testing process by Analyzing the AUT
• Created a Key Word Driven Framework using QTP.
• Involved in data driven test by using Quick Test Pro.
• Integrated QTP scripts with Quality Center to manage the entire Automation testing process.
• Performed Functional and Regression testing by developing and executing automated test scripts using QTP.
• Updated QTP scripts after delivery as required by the new version.
• Trained new joiners in QTP as well as the ongoing project.
• Assisted in training the UAT users at client location upon system implementation of the developed to familiarize them.
• Provided software validation, design controls, and risk management training.
• Attended review meetings and walkthroughs to discuss the status of the project.
• Environment: .NET, HTML, Java, Oracle, Windows, Java Script, VB Script, Web Services, QTP, C, Quality Center, UNIX.
Education:
Central Queensland University Sydney, Australia
Bachelors, Hospitality Management