AILI XIEYIDAI
Braintree,MA
Summary
- Self-taught and Highly competent Software Development Engineer In Test (SDET) with 8 years of experience in Automation and Manual testing on web-based applications and databases across different domains, such as Healthcare and Finance.
- Skilled in Agile methodologies with a strong focus on delivering high-quality software. In-depth understanding of Java Object-Oriented Programming (OOPs) concepts and Automation Framework using Java, Selenium WebDriver, Cucumber, JUnit, and Maven, Experienced with different programming languages such as c#, typescript, and JavaScript.
- Proficient in testing REST API web services via Postman tool or Swagger and automating via Rest-Assured java libraries by sending HTTP requests and performing data validation.
- Created SQL queries to verify data in MySQL, PostgreSQL, Oracle, and other databases while performing back-end database testing.
- Involved in analyzing User story specifications to create and execute Test Cases, able to understand the business requirements and translate to technical requirements.
- Create High- & low-level technical design documents in Confluence.
- Cross-functional team members who can effectively collaborate, Highly flexible and adaptive team player, adept at multitasking and thriving in a fast-paced environment while assisting numerous time-sensitive projects and ability to prioritize tasks.
Overview
9
9
years of professional experience
Work History
SDET
PwC
03.2023 - 10.2023
- Responsible for analyzing business requirements and design documents, and creating test plan documents
- Analyzed and prioritized user stories, and created test cases including positive, negative, and edge-case scenarios
- Effectively documented on ADO
- Verify and understand the documents, and convert technical and non-technical documents
- Hands-on experience working with DevTest tools to create test data and automated test cases for API
- Used SQL server and Jmeter for performance testing of the Database
- Well-experienced in Waterfall and Agile Scrum methodologies and a valuable contributor during Sprint Grooming, Planning, Demo, Retrospective meetings, and Backlog refinement Meetings
- Accepting the challenges with new tools and new projects, developed the ability to quickly learn and adapt
- Environment and tools: DevTest, Postman, Azure DevOps tool, Confluence, MS SQL server.
QE Automation Engineer
Charles Schwab
07.2022 - 02.2023
- Responsible for creating test plans, and technical documentation for test approach
- Created Regression suits, and participated in continuous integration and improvement
- Take on the responsibility of researching test tools and implementing them
- Developed knowledge and hands-on experience using Mabl for different Automation testing, and created data-driven tests using data tables
- Also documented test cases, test data, and test results
- Used Page Object Model structure and Data-Driven functionalities to API Automation Framework, increased reusability and maintainability of the code
- Used JSON Object, Excel Sheet, and Rest API to perform various data-driven testing on the Automation framework
- Performed database testing using SQL queries for data validation
- Environment and tools: Mabl, restSharp, Newton Soft Json, Bamboo, C#, SQL database management tool.
QE Engineer
BNY Mellon | Data and Analytics Solutions
10.2019 - 06.2022
- Created technical documents and analyzed stories
- Automating complex UI and API tests
- Prioritize and organize test cases, create Regression tests and Acceptance Tests
- Used Page Object Model structure and Data-Driven functionalities to UI Automation Framework, increased reusability and maintainability of the code
- Implemented Page Object Model and Selenium, testNG for UI test automation
- Participated in a full life cycle of an Agile Scrum project and applied QA practices to ensure full Functional Testing of new features being added every Sprint, as well as major Regression Testing for all previously implemented functionalities in every sprint
- Automated manual functional Test Cases and maintained the Automation Regression Suite
- Worked closely with developers to analyze the stories, and implement unit tests
- Experienced with debugging failures, investigating logs, and resolving at the early stage
- Utilized HTML reports and JSON reports to automate test reports and included screenshots of All scenarios
- Efficiently monitored and tracked defects through New Relic
- Used Git and GitHub for version control and Jenkins CI/CD pipeline
- Utilized JSON Object, Excel Sheet, and Rest API to perform various data-driven test
- Accepting the challenges with new tools with new projects very often, developed the ability of Quick learning and adapting
- Environment and tools: Gradle, Spring, Selenium WebDriver, JIRA, Agile, HTML, JSON, MySQL, Git, IntelliJ IDE, Postman, Microsoft Azure, Testah Framework, JavaScript.
SDET
Rally Health
10.2017 - 10.2019
- Developed Test Automation Framework using Selenium WebDriver, Java, Cucumber, JUnit and Maven for application UI Testing
- Used Page Object Model structure and Data-Driven functionalities to Automation Framework, increased reusability and maintainability of the code
- Created Feature files and test scenarios in Cucumber using Gherkin language
- Participated in a full life cycle of an Agile project and applied QA practices to ensure full Functional Testing of new features being added every Sprint, as well as major Regression Testing for all previously implemented functionalities in every sprint
- Identified GUI elements using various locators provided by Selenium WebDriver such as ID, Name, Class Name, Link Text, Partial Link Text, Tag Name, CSS, and XPath
- Automated manual functional Test Cases and developed and maintained the Automation Regression Suite
- Actively dealt with data tables, calendars, iFrames, pop-ups, and alerts on the application using Selenium WebDriver
- Utilized Cucumber HTML reports and JSON reports to automate test reports and included screenshots of failed scenarios
- Efficiently logged and tracked defects using Jira
- Accurately developed timely Cucumber Reports using Jenkins
- Used Git for version control and Jenkins CI/CD pipeline
- Utilized JSON file, Excel Sheet, and Rest API to perform data-driven testing
- Experience in manually testing REST API web services via the Postman tool and automating via Rest-Assured Java libraries by sending HTTP requests and performing data validation
- Conducted mentoring to current and new team members on automation testing using current tools within my framework
- Actively participated in all phases of Agile scrum methodology
- Effectively communicate testing activities and findings in oral and written formats
- Environment and tools: Maven, Selenium WebDriver, JIRA, Agile, HTML, PostgreSQL, Git, Eclipse IDE, Postman.
QA Automation Engineer
Navy Federal Credit Union
01.2016 - 09.2017
- Focused on fully understanding the project and effectively communicated and collaborated with the Scrum team to achieve each Sprint goal
- Developed expertise working in a dynamic Agile environment and efficiently tested newly proposed changes at any time during SDLC
- Successfully maintained Automation Framework using Selenium WebDriver, Java, TestNG, Maven and Page Object Model Design
- Created and executed both manual and automated Test Cases to perform both Functional and Regression Testing
- Maintained Regression Test Suite and supported each major release by executing the Regression Suite against the application under test
- Performed Data Driven Testing using Selenium WebDriver and TestNG Framework and utilized Apache POI libraries to retrieve and export data to external sources using Java
- Performed defect logging and tracking using Jira and interacted with developers to resolve any technical issues
- Performed Back-end Testing of MySQL databases using JDBC API
- Generated reports for upper management
- Environment and tools: Maven, Selenium WebDriver, Java, Junit, Maven, MySQL, Page Object Model, HTML, Git.
QA Tester
Cerner
11.2014 - 12.2015
- Reviewed Requirement Specification to obtain a better understanding of the project
- Interacted with product owner and development team to better understand the User Stories and Acceptance Criteria
- Designed effective manual Test Cases based on Business Requirements analysis
- Created SQL queries to retrieve test data from Oracle database and analyze and verify results
- Executed manual Test Cases by using positive and negative test data inputs for UI Testing
- Worked directly with the development team to resolve quality issues and retest defects
- Identified the setup, input data, appropriate steps and the expected responses in Manual Test Cases
- Derived Test Scenarios, Documented Test Cases and Collected Test Data for Functional Testing
- Performed Manual Testing of each functionality of the application under test
- Participated in daily and weekly status reporting
- Environment and tools: Manual testing, Microsoft Excel, SQL, PostgreSQL.
Skills
- Languages: Java, SQL, HTML, JavaScript
- Web Services Testing Tools: POSTMAN, RESTAssured, DevTest tool, Mabl
- Build Tools: Maven, Gradle
- Testing Tools: Selenium WebDriver, Cucumber, TestNG, Junit, Testah
- IDE: Eclipse, IntelliJ
- CI tool: Jenkins, Bamboo
- Database tools: Oracle, MySQL, PostgreSQL, MS SQL server
- Repository System: Git, Github
Workauthorization
Eligible to work in the US for any Employer without Sponsorship
Timeline
SDET
PwC
03.2023 - 10.2023
QE Automation Engineer
Charles Schwab
07.2022 - 02.2023
QE Engineer
BNY Mellon | Data and Analytics Solutions
10.2019 - 06.2022
SDET
Rally Health
10.2017 - 10.2019
QA Automation Engineer
Navy Federal Credit Union
01.2016 - 09.2017
QA Tester
Cerner
11.2014 - 12.2015