Nihal Sai

As a Senior QA Test Automation Lead at Southwest Airlines since January 2022, I have played a pivotal role in ensuring the quality and reliability of our software systems. Here's an overview of my responsibilities and achievements during this period:

Company and Team: Southwest Airlines is a prominent American airline and aviation services provider headquartered in Texas.

Role and Responsibilities:

• Collaborated extensively with clients, product owners, and the development team to gain a comprehensive understanding of user stories and acceptance criteria. This involved gathering both functional and non-functional requirements for project releases.
• Mentored and guided new team members, facilitating their onboarding through training sessions. I also provided ongoing support and guidance to offshore testers in their daily activities.
• Developed comprehensive tester's guide materials for the Size Profile Analysis project, contributing to improved testing processes.
• Conducted training sessions for offshore QA Tester Engineers, ensuring their proficiency in testing practices, and effectively coordinated testing efforts across teams.
• Proficiently created Test Plans, Test Strategies, Test Data, Test Cases, Test Results, and Traceability Matrices using the qTest platform.
• Played a crucial role in requirements gathering, reviewed Business Requirement Specification documentation, and actively participated in the preparation of test cases based on Product Backlogs.
• Demonstrated expertise in using a range of Test Automation tools, including Cypress, Selenium, TestNG, Jmeter, and Junit, streamlining the testing process.
• Successfully tested numerous complex ETL mappings, mapplets, and reusable transformations for daily data loads, ensuring data integrity and accuracy.
• Contributed to Regression testing efforts using Selenium and excelled in the creation of automation scripts for web pages.
• Worked proficiently with all modules of TOSCA, encompassing Modules, Test Cases, Requirements, Test Case Design, and Execution Lists.
• Executed various types of testing, including Functional Testing, Integration Testing, System Testing, Positive Testing, Negative Testing, GUI Testing, and UAT Testing.
• Designed, developed, and executed automated tests using Selenium WebDriver, with a focus on handling special mouse events and selecting options from drop-down menus. Employed Actionsbuilder, mouse hover, and synchronization techniques.
• Took charge of defect tracking, reporting, and reproducing in JIRA, while also creating traceability matrices, test reports, and other relevant test-related documents.
• Demonstrated proficiency in data mapping and data validation through the execution of SQL Server queries.
• Implemented Test-Driven Development (TDD) frameworks, including ATDD and BDD, using the Cucumber tool with Gherkins Language.
• Conducted Behavior-Driven Development (BDD) using Cucumber Features, Scenarios, and Step Definitions in Gherkins format.
• Developed and implemented test automation scripts for mobile testing, catering to both Android and iOS applications using Appium and Java.
• Specialized in manual and automated testing of IOS and Android mobile applications, utilizing Appium for IOS and Android-based native applications.
• Successfully managed ETL runs through AutoSYS jobs, ensuring the validation of runs upon completion.
• Proficiently set up test environments for automated script execution, leveraging Java, Appium, and TestNG.
• Expertly identified mobile elements using Appium Inspector and UI Automator Viewer, further enhancing test accuracy.
• Developed automation scripts for Mobile Native applications (IOS and Android) using Appium and Java, alongside configuring Appium for Mobile IOS using Selenium.
• Verified the integration of various components in applications and executed end-to-end testing, ensuring system stability and functionality.
• Maintained data dictionaries and SQL repositories for streamlined data management.

Environment and Tools:

• Utilized a diverse set of tools and technologies, including Selenium WebDriver, Eclipse, Maven, TestNG, qTest, Cypress, TOSCA, JIRA, CSS, Oracle, SQL, HTML, MS Excel, SOAP UI, BDD Framework, Jenkins, POM (Page Object Model), and Appium Java.

In my role as Senior QA Test Automation Lead at Southwest Airlines, I have consistently demonstrated my commitment to quality assurance, ensuring the delivery of reliable and efficient software solutions. My contributions have been instrumental in enhancing the testing processes and overall software quality within the organization.

As an Automation Lead at McKesson from September 2021 to January 2022, here are my responsibilities.

Responsibilities:

• I was responsible for crafting and executing test cases and played a pivotal role in automating tests for customer billing, order entry, and security management.
• I implemented and executed test cases simultaneously on different browsers by integrating the Junit Framework with Selenium WebDriver.
• My role encompassed various manual testing types, including Functional testing, Adhoc testing, Smoke testing, Positive & Negative testing, Regression testing, Integration testing, GUI testing, and Browser Compatibility testing.
• I wrote complex SQL queries to validate the integrity of the database and tested the data within database tables.
• SQL statements were employed to extract data from tables and validate test results in SQL Server.
• Collaborating with ETL groups, Acquisition teams, and business analysts, I gained a comprehensive understanding of mappings for dimensions and facts.
• Mobile testing was facilitated using Appium, where I created a mobile Driver class with the required mobile capabilities.
• I served as an Onsite Coordinator, responsible for managing and coordinating QA onsite and offshore resources for project testing.
• Detailed test cases were meticulously created, complete with step-by-step procedures and expected results. I also maintained test logs, test reports, and tracked defects using qTest and Confluence.
• UI and API testing were performed using Cypress, and I had the opportunity to build a framework from scratch.
• For functionality testing, I documented all pass-fail reports, generated modification requests, assigned them to respective developers, and verified bug fixes using the JIRA test management tool.

Environment:

• Tools and technologies used in this role included QTP, JIRA, UNIX, Oracle, MS-Office, XML, SQL Server, HTML, Cypress, Firebug, Eclipse, Junit, SOAPUI, RESTAPI, WSDL, and WADL.

This is an American multinational investment bank and financial services holding company headquartered in Charlotte, North Carolina.

Within this project, I collaborated with the Release Testing (RELT) team, tasked with conducting weekly and bi-weekly tests on two distinct environments before deploying the enhanced application. My primary responsibilities included performing Integration and Regression testing to ensure that the new enhancements didn't result in any defect issues. Additionally, I took charge of managing releases within my team and participated in triage meetings.

Specific responsibilities in this role encompassed the following:

• In an Agile methodology environment, I reviewed Product Backlogs, User Stories, Acceptance Criteria, and Technical Design Specifications documents.
• I developed comprehensive testing plans, designed test scenarios, and created test cases and scripts based on data mapping documents and Functional Specification documents. These test cases were closely aligned with the project requirements, contributing to the generation of the Requirement Traceability Matrix (RTM).
• Automation testing was conducted using Selenium WebDriver and HP Quality Center, with a focus on web and client-server applications.
• I crafted test cases for ETL mappings and produced design documents for production support.
• I built an automation framework from scratch using Cypress for UI automation. This involved the use of JavaScript, NodeJS, and NPM for Angular-based user interfaces.
• My role included hands-on experience in manual testing, encompassing emulators, iOS simulators, and Mobile Application Testing using automation tools like Appium.
• I provided training to offshore team members and acted as a mentor for addressing complex issues, fostering knowledge growth within the team.
• Implementation of Appium Scripts was carried out for testing iOS and Android platforms.
• I assumed responsibility for reviewing deliverables produced by offshore team members.
• Appium Inspector was employed for element inspection and identification.
• Test Plans were executed on both web and mobile platforms as per the defined requirements, utilizing the Appium tool.
• Diverse testing types were performed, including User Acceptance Testing, Functional Testing, Integration Testing, Regression Testing, System Testing, Usability Testing, GUI Testing, Smoke Testing, and Backend Testing.
• I made use of various Teradata utilities, including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ, and TRUMP.
• Element identification was facilitated using Firebug and Firepath, particularly when creating the Page Object Repository.
• Test reports generated through TestNG were used to capture error screenshots.
• Interaction with the Development team and Environment team was essential for prioritizing defect lists and validating bug fixes, accomplished through tools like JIRA and Rally.
• Back-End testing was carried out manually by crafting SQL queries using SQL Joins.
• During User Acceptance Testing (UAT), I collaborated with Business Analysts to ensure that the application met user-friendly and functional requirements.
• I conducted testing on complex ETL SSIS and SSRS Packages and Sessions, aligning them with business user requirements and rules to facilitate data loading from various sources.

Environment:

• The project utilized Selenium WebDriver, Eclipse, Appium, Java, XCODE, TestNG, HP ALM/Quality Center 10, Cucumber, Oracle, SQL, XML, SOAP, HTML, and SOAP UI.

Capital One Financial Corporation is a US-based bank holding company specializing in credit cards, auto loans, banking, and savings accounts, with its headquarters located in McLean.

My involvement in the role included tasks such as preparing daily and weekly status reports. I was also responsible for creating Defect Summary Metrics and overseeing the planning and execution of knowledge management activities within the team. Additionally, I played a key role in coordinating Defect Prevention Activities and automating certain GUI-based test cases from the sanity pack, which was framework-driven.

My responsibilities encompassed the following:

• Acting as a liaison between stakeholders, financial system users, clients, managers with business challenges, and the software development team to gather requirements.
• Recommending and implementing Control-M Scheduling software to manage job scheduling and address job failures.
• Scheduling and rectifying failed jobs using the Control-M scheduling package.
• Extensive experience in scheduling jobs and batch processing.
• Creating test cases for GUI validation and conducting backend database validation.
• Developing complex SQL queries to validate data and verify ETL Mapping Rules.
• Maintaining documentation related to challenges, complexities, and anomalies that may arise during the ETL process.
• Involvement in Defect Reporting, Defect Tracking, and the preparation of Defect Reports using Quality Center.
• Contributing to the writing and implementation of Test Plans, Test Scenarios, and Test Cases using the Waterfall Methodology.
• Utilizing Cypress for end-to-end testing of angular applications.
• Applying documentation practices across all aspects of content management and documentation.
• Preparing for and actively participating in weekly status meetings, conducting walkthroughs, and documenting meeting proceedings.
• Collaborating with developers and the test lead to validate Test Cases.
• Testing SSIS packages designed to transfer data from diverse sources such as Oracle, Db2, MS Access, Excel, and flat files.
• Testing complex ETL SSIS Packages and Sessions in accordance with business user requirements and rules for data loading from various sources.
• Submitting, modifying, and tracking change requests using MS Excel.
• Possessing strong knowledge of Core Java, with a focus on messaging protocols.

Environment:

• The work environment included tools and technologies such as Selenium RC, HTML, Load Runner, Bugzilla, SQL, Windows 8, Oracle 8, Java, Internet Explorer, Mozilla Firefox, Google Chrome, XML, and Java.