Qa Automation Engineer Resume
New York, NY
SUMMARY
- 5 years of experience in Agile test automation wif Data Driven and Keyword Driven testing frameworks using Maven project wif Java, TestNG, AssertJ, Allure Report and using Jenkins pipeline as an orchestrator.
- Experience in migrating a test framework to BDD style and using Cucumber in production for 2 years.
- 3 years of experience in Rest API testing using Postman and REST - assured library.
- 4 years of experience wif relational DBMS and OLAP cubes in Waterfall and Scrum models.
- Total work experience in IT 10 years, developed business logic scripts for Oracle product, performed data validation testing, UI functional and REST API testing for various projects.
- Profound knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Error Life Cycle.
- Accurate understanding of user stories, product requirements and functional specifications.
- Develop solid documentation including test plans, test cases, test suites, traceability matrices.
- Create clear and easily reproducible/understandable bug reports for developers/architects using teh full power of issue tracking software.
- Hands-on experience wif smoke, sanity, acceptance, regression, feature-based, Rest API and other types of testing, using various automation tools and following teh Page Object Model design pattern in functional UI testing where appropriate.
- Perform cross browser and cross platform compatibility testing using Selenium Grid and Selenoid.
- Self-learner and can quickly go through manuals on new tools and search for best practices in teh network, adapt or modernize and implement into a project.
- Can properly work under pressure and deadlines. Team Player.
TECHNICAL SKILLS
OS: Windows NT, Unix-like (macOS, AIX), GNU/Linux (Ubuntu, Fedora).
DBMS: Oracle 12c, MySQL 8.0, PostgreSQL 11, Teradata 15.0, Oracle Hyperion Essbase 11.1.
Web Server: WebLogic, Nginx, Tomcat, IIS.
Programming: Java, JavaScript.
Query: SQL, PL/SQL, MDX, MaxL DDL, Essbase Calc Script.
WEB: HTML, CSS, JS, XPath/CSS locators, HTTP, XML, JSON, REST API.
IDE: IntelliJ IDEA, DataGrip, Oracle SQL Developer, PL/SQL Developer, Navicat Data Modeler.
Testing Tools: Maven, Selenium WebDriver, Cucumber, Junit, TestNG, AssertJ, Allure, Chrome DevTools, ChroPath, Lighthouse, Charles Proxy, Selenium Grid, Selenoid, SQLMap.
API Tools: Postman, Interceptor, Newman, REST-assured library, Swagger.
ETL Tools: Oracle Data Integrator, Talend Open Studio.
Virtual: VirtualBox, VMware Workstation.
CI/CD: Jenkins, CircleCI.
Control Tools: TortoiseSVN, GitKraken, GitHub.
Management: Jira, Xray for Jira, Bugzilla, Confluence.
PROFESSIONAL EXPERIENCE
QA Automation Engineer
Confidential, New York, NY
Responsibilities:
- Member of Agile team wif 3-week Sprint, attended daily Stand Up, Sprint Planning, other ceremonies.
- Implemented a new BDD-style (Cucumber) test automation framework.
- Reviewed legacy test scripts and migrated to teh new test framework following POM patterns.
- Organized test data from different data sources (DB, .csv, .xml, .yml), deployed a DB schema, normalized it to 3NF, mapped test data, developed ETL scripts, created SQL statements.
- Deployed Selenium Grid for parallel execution across different browsers. Later migrated to Selenoid.
- Redeveloped of REST API testing, replaced Postman collections wif a REST-assured library.
- Implemented an AssertJ library and refactored every assertion.
- Maintained existing scripts and developed new automation scripts for novel features.
- Fixed flaky tests using explicit wait.
- Reviewed false positive tests.
- Parsed .yml for test data using teh SnakeYAML library.
- Increased automation test coverage by 20% to 80% (from 1100 tests to 1500 out of 1900 total tests).
- Maintained QA documentation in Confluence.
EPM Consultant
Confidential
Responsibilities:
- Was primarily focused on technical aspects in Oracle Planning and Essbase for various projects.
- Analyzed existing OLTP and DWH schemas on Prod environment using SQL Developer and DataGrip.
- Created and deployed dimensions and metadata for Essbase (OLAP) on Dev.
- Implemented business logic using MDX and Calc Script for BSO cubes in Essbase on Dev.
- Developed Java methods for custom-defined functions in Essbase.
- Participated in creation of Business System Testing documents using Oracle AIM templates.
- Prepared QA/UAT environment for testing.
- Participated in creation of test cases, test suites, test data.
- Automated test scripts using Selenium WebDriver and TestNG for UI functional testing.
- Developed RPA in-house framework using WebDriver for task automation in WEB application.
- Created data mapping sheets based on migration requirements.
- Performed data validation using ETL tool for a migration project to a new DB vendor.
Business Analyst
Confidential
Responsibilities:
- Gathered business volumes and metrics using SQL, VBA, PivotTable (Excel).
- Prepared daily basis reports on consolidated data for mid-level management.
- Participated in implementation and support of Teradata data analytics tools.