Himanshuu V Sethi
Arlington
Summary
Dynamic Software Quality Engineer with a proven track record at Airlines Reporting Corporation, excelling in automation using Selenium and Cypress. Adept at defect management and cloud services, I thrive in collaborative environments, driving efficiency and quality in software testing. Passionate about delivering impactful solutions that enhance user experience and streamline processes.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Software Quality Engineer
Airlines Reporting Corporation
Arlington
06.2021 - Current
- Analyzed business requirements and functional documents, created test strategy document detailing test environment, phases of testing, entrance and exit criteria, and resources required for execution.
- Creating and running SQL queries based on the Data Mapping rules to validate the transformation of data from the raw zone with the processed zone in the snowflake.
- Managed defect tracking, conducted regular defect meetings to update statuses, and published consolidated defect reports weekly.
- Developing framework using cucumber feature from the scratch using Cypress to automate UI with Javascript, NodeJS and NPM for Angular based user interface.
- Created data-driven automation scripts using Cypress and Postman for testing API Web Services and Tested RESTFUL API using Rest Assured.
- Developed test cases and database queries to validate records in AWS DynamoDB and Snowflake by executing queries.
- Involvement in CI/CD pipelines and version controls to push the code on the Gitlab repos.
- Environment: Snowflake, Cypress, Amazon Web Services (AWS), Cucumber, Postman, Dynamo DB, Test rail
Business Data Analyst
ThermoFisher Scientific
Frederick
01.2020 - 06.2021
- The objective of IES Advance Planning project is to significantly improve planning, ordering, forecasting & optimization of the IES inventory globally and achieve financial savings and efficiency with advance planning and forecasting.
- Worked with the Business Team and SME of various departments in gathering the requirements, creating the Business Requirement documents and Design Specification documents to develop solutions and alternatives.
- Translated high-level information into detailed specifications.
- Created master data of inventories, established database parameters, and mapped across business processes in Baan test environment to facilitate accurate inventory management.
- Created the Data Mapping and specification documents for the source and target tables.
- Created and running SQL queries based on the Business Requirements in Test and Production environment to extract the data for validation purpose.
- Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing.
- Designed Power BI data visualizations, including maps and charts, to deliver analytical insights and support data-driven decision-making.
- Developed the Power BI reports and dashboards from multiple data sources for the Business and Stakeholders to guide decision-making processes and improve business processes.
- Project – SupplyConnect Coupa: The objective of SupplyConnect project is to make the indirect purchase capture in the Coupa system and make it pay through the master ERP.
- Collaborated with business team and SMEs from various departments to gather requirements and develop business requirement and design specification documents for effective solution development.
- Creating Master Data of GL accounts, Company Codes, Profit Centers, Suppliers, Purchase Orders and Receipts and establish the parameters in the database and map it across different business processes in Baan test environment.
- Migrating and merging Baan Repository and Catalogs.
- Running SQL queries to extract the data from the different ERP(Baan) environments for validation.
Software Quality Engineer
ThermoFisher Scientific
Asheville
11.2018 - 12.2019
- The objective of this project was to diminish the return orders by utilizing new product attributes to present the quote in a more logical format and include the standardization presentation of product information, pricing, and delivery specifications.
- Developed test plans, test cases, and test scripts based on functional requirement specifications to ensure comprehensive test coverage.
- Participated in Agile scrum sessions to adapt requirements and feature sets, contributing to iterative development and timely project delivery.
- Created and executed automated test scripts for Salesforce web application using Selenium WebDriver and Python, enhancing testing efficiency and accuracy.
- Developed test Automation frameworks using Python PYTEST unit Testing framework.
- Implemented Page object Design Patterns, Pytest fixtures, Log4j reporting for developing Framework with Industry standard Best Practices.
- Created PyTest test suites and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations.
- Performed Functional Testing, Data Driven Testing (Using Pyxl Libraries), and Cross Browser compatibility on different browsers like IE, Firefox & Chrome.
- Identified and isolated software defects and reported them via JIRA.
- Wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration from back-end to front end.
- Implemented BDD (Behave) Framework for all Tests with allure reports.
- Automated Rest API Testcases with Python 3 using Requests Library.
- Experience working with complex Json parsers using Python Json Libraries with heavy usage of Tuples, List and Dictionary data types.
- Building Dynamic Payloads with the data input from Databases and CSV Files.
- Debugged and maintained automated test scripts and test suites to ensure accurate and efficient testing.
- Performed functional, regression and Smoke testing on the front-end application.
- Worked with application development and operation teams using a variety of automated testing and build, and deploy tools (JENKINS, and Github) to resolve issues with transition to new DevOps solution.
- Tested features and reported bugs with the content such as missing content and graphical errors.
- Assisted in maintaining standardized testing artifacts for the System, UAT and Performance test phases.
- Wrote various SQL queries to validate data inserted, deleted, and updated in the Oracle database.
- Created test scripts for Security, Positive, Negative and User Acceptance Testing (UAT).
- Responsible for documenting defects and working with the development team to resolve issues.
- Worked on EC2 (Elastic Compute Cloud), Launch an EC2 Instance, Security Groups, Upgrading EBS Volume Types, Encrypt Root Device Volume and Create an AMI, AMIs - EBS Root Device Volumes vs Instance Store, Load Balancers and Health Checks, Cloud Watch EC2, Autoscaling Groups, AWS Command Line and EC2, Using IAM Roles with EC2 S3 CLI & Regions, Using Bootstrap Scripts, EC2 Instance Metadata and Elastic File System.
- Prepared, reviewed, and approved the validation plan, URS, FRS, SDS, IQ, OQ, PQ, validation summary report, and trace matrix documents.
- Collaborate with onshore and offshore teams.
- Environment: HP ALM, Baan, Amazon Web Services (AWS), Chrome, Firefox, Safari, HP ALM, Microsoft teams, MySQL, Selenium, Pycharm.
System Analyst
California Public Utility Commission
Sacramento
05.2018 - 09.2018
- Introduced Peoplesoft software to the department to migrate data from paper to the system.
- Facilitated implementation of FI$Cal enhancement project across 64 California State departments using Peoplesoft application.
- Implemented End to End Robotic Process Automation (RPA) using UiPath.
- Created objects and workflows based on client requirements to streamline project deliverables.
- Performed tool evaluation and feasibility to help in selecting suitable Automation tool for RPA implementation.
- Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Documents).
- Designed, Developed, and tested Robot tasks using RPA UiPath.
- Used UiPath Orchestrator for deployment, monitoring and management of UiPath Robot automation activity.
- Worked with OCR, ICR, and Machine learning for designing in UiPath studio.
- Writing SQL queries for back end testing and validation process.
- Environment: HP ALM, MS SQL server, Windows 8, MS Office, HTML, XML, Chrome, Firefox, Safari, UiPath, JIRA, Peoplesoft.
QA Engineer
CONSUMER ENERGY
Jackson
11.2016 - 03.2018
- The objective of the project is to enhance the features of the ABB Service Suite and make sure the features are compatible with the SAP Work Manager module. Also, the online system was enhanced with security credentials to make the user account safer.
- Supported enhancements and projects for Work Management and managed Electric and Gas work orders in SAP ERP system as a Quality Analyst.
- Tested the Work Management applications: Clarity (Electric Transmission Capital Management Tool), ED and ET GIS support enhancements, Gas Leak Survey, SAP Outage Management System (OMS) and various other independent applications.
- Tested the interface between SAP Work Manager system and ABB service suite (V9.0) to validate the data flow in the database system.
- Created automation test scripts utilizing data-driven framework and Page Factory model to validate web applications using Selenium WebDriver with JAVA and TestNG, ensuring effective element locator analysis.
- Designed the Test Strategy and Master Test Plans for the project.
- Developed Test Strategy, Test Plan, Test Scripts, Test Result documentation, and Test Summary documentation while managing scripts through Quality Center/ALM to ensure comprehensive testing coverage.
- Used Selenium Web Driver /RC / IDE for functional and regression testing.
- Identifying Automation Scenarios from the set of Testcases/User stories identified in cycle.
- Performed BDD (Behavior Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkins format.
- Worked with application development and operation teams using a variety of automated testing and build, and deploy tools (MAVEN, JENKINS, Github, and TestNG) to resolve issues with transition to new DevOps solution.
- Performed Cross Browser Automation using Selenium GRID.
- Performed Web Services Testing and Rest Services validation by creating test case suite using Postman.
- Supported the mobile application (ABB Vyntex) testing team in creating test cases using Appium.
- Running Smoke regression suite after every build and publish the detailed reports with the bugs detected.
- Running Full Automation suite for every Release and analyze the root cause of Failed scripts.
- Wrote SQL queries for back end testing and validating the process.
- Validated the traceability of test cases back to the Business requirements.
- Conducted the knowledge transfer sessions to train the employees with ABB Field service suite system (Version 9.0).
- Environment: HP ALM, Selenium WebDriver, JUnit, Eclipse IDE, SAP, Oracle, Windows 8, MS Office, HTML, XML, Postman, Chrome, Firefox, Safari, JIRA, MySQL.
Education
Master of Science - Technology Management
Bowling Green State University
Bowling Green, OH01-2017
Bachelor - ME
Bachelors of Engineering
India01-2010
Skills
- Software testing lifecycle
- Testing methodologies
- Manual testing
- Defect management
- Defect lifecycle management
- Agile process implementation
- Selenium and Cypress
- WebDriver and IDE
- Automation framework
- BDD and Cucumber framework
- Data-driven testing strategies
- Page object model design
- PyCharm and SQL
- Python and JavaScript
- MySQL management
- JIRA and HP ALM
- TestRail and Allure
- UIPath automation tools
Certification
- AWS Certified Solutions Architect, 03BQ5S5D1FBQ1T91, 04/01/21
- AWS Certified Cloud Practitioner, J2NM44NJCMBQ163J, 03/01/21
- Scrum Foundation Professional Certificate, 08/01/20
- Python Data Structures, Coursera (University of Michigan), 2019
- Python, Coursera (University of Michigan), 2019
Languages
English
Professional
Hindi
Professional
Accomplishments
Spot Awards
Timeline
Software Quality Engineer
Airlines Reporting Corporation
06.2021 - Current
Business Data Analyst
ThermoFisher Scientific
01.2020 - 06.2021
Software Quality Engineer
ThermoFisher Scientific
11.2018 - 12.2019
System Analyst
California Public Utility Commission
05.2018 - 09.2018
QA Engineer
CONSUMER ENERGY
11.2016 - 03.2018
Master of Science - Technology Management
Bowling Green State University
Bachelor - ME
Bachelors of Engineering