SUMMARY

• Overall, 14 years software industry experience, worked as QA consultant in Web, Salesforce, Cloud, Power Builder, Client Server, AS400/Mainframe applications in various domains.
• Experienced in working with Stakeholders and Executive management for Project Status, Roadmaps, Release Planning and reporting.
• Experienced in building the automation frame works using Selenium, Cucumber, TestNG, UFT/QTP and ReadyAPI.
• Designed and implemented different kind of automation frameworks like BDD, TDD, Page Object Model, Keyword Driven and Data Driven.
• Expertise in writing automation test scripts using Java, JavaScript, Python, VB Script, Gherkin and Groovy.
• Experienced using DevOps tools like Maven, Gradle, Git & Jenkins.
• Experienced in web services / API testing using tools Ready API, Postman and UFT API.
• Experienced in working on AWS ELK Stack (Elasticsearch, Logstash, Kibana).
• Experienced in testing BI reports of Kibana, SAP Business Objects and Splunk.
• Solid back end testing experience in writing and executing SQL Queries and executing Unix Shell Scripts.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W for ETL verification and validation testing.
• Experience in Data Analysis, Verification, Validation, Modeling, Cleansing, and identifying data mismatch.
• Participating in all Agile, Scrum, Sprint ceremonies etc.
• Experience in preparation and review of Test Strategy, Test Plan, Test Scenarios, Test Cases, Test Scripts, Test Reports, Requirement Traceability Matrix and Defect Reports for manual and as well as automation testing.

TECHNICAL SKILLS

Automation Tools: UFT/QTP, Selenium, Cucumber, TestNG, JUnit

Web Service Test Tools: ReadyAPI (SoapUI Pro), Postman, UFT API

Languages: Java, Python, Gherkin, COBOL, JCL, VB, HTML, PL/SQL

Scripting Languages: VBScript, JavaScript, Shell Script, Groovy

Test Management Tools: ALM (Quality Center), TestRail, Clear Quest, JIRA

Data warehouse Tools: Informatica, Logstash

BI tools: Kibana, Tableau, SAP BO, Splunk

CI/CD Tools: Jenkins, Git, Maven, Gradle

Scheduler Tools: Control - M, Autosys

Databases: MongoDB, Elasticsearch, MySQL, Oracle, SQL Server, Teradata, VSAM, DB2

Mainframe Tools: Hiperstation, File-Aid, Rumba, Personal Communicator

Management Tool: Rational Portfolio Manager

PROFESSIONAL EXPERIENCE

SDET - Automation Engineer

Confidential

Responsibilities:

• Developed BDD automation framework for UI and API using Selenium, Cucumber, NodeJS, JavaScript.
• Developed features, scenarios, step definitions for BDD and TDD using Cucumber, Gherkin and JavaScript.
• Generated automation test results report using Cucumber HTML Reporter.
• Executed automation scripts on different browsers using Selenium Box.
• Designed and created test automation framework for restful web services using ReadyAPI.
• Created different kind of assertions including Groovy script in ReadyAPI.
• Integrated automation scripts with Jenkins for CI/CD pipeline.
• Used Postman tool for manually executing the RESTful services.
• Analyzed the XML/JSON request and response of RESTful web services.
• Validated EDI X12 request and response documents.
• Verified and validated Kibana and Splunk reports.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Hands-on experience in developing/testing automation execution metrics/KPIs using ELK.
• Integrating and Scheduling the automation test suites in Jenkins for both Test and UAT environments.
• Tested 508 compliance accessibility using WAVE extension tool.
• Writing and executing the test cases using TestRail and Enterprise Tester and JIRA.
• Participated in all sprint/scrum ceremonies.

SDET Automation Engineer

Confidential, Richardson, TX

Responsibilities:

• Setup Selenium Test Environment using the entire open source tools like Eclipse, TestNG, Selenium WebDriver, Cucumber, Java, Maven and Jenkins.
• Extensively used SQL queries for data validation and backend testing.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Conducted peer reviews for the automated scripts and ensured that scripts meet completion criteria.
• Implemented Behavior Driver Development (BDD) using Cucumber automation tool and by writing feature files using Gherkin.
• Developed custom java classes that are application dependent and independent which increases the re-usability and speed up script development.
• Implemented Log4J for generating customized and detailed logs.
• Used Selenium grid to create bulk orders.
• Used excel and YAML as a data source
• Performed cross browser and platform compatibility testing in virtual machine environment.
• Developed and maintained automated test scripts in UFT using VB Script.
• Automated the AS/400 CICS screens using UFT and effectively tested the application as per the requirements.
• Written the UFT scrips to automate the end to end flows from Web Applications to Mainframe.
• Implemented various Checkpoints for data validation and synchronization and developed reusable functions using UFT.
• Reviewing the existing manual test cases and identifying the scenarios for automation.
• Generating the test results in HTML report format.
• Involved in querying using SQL and updating records and validate database records as expected.
• Executed the automation test suite on daily, weekly build by implementing continuous integration using Jenkins.
• Performed API testing using UFT and SOAP UI.
• Defect Reporting, Analyzing, Tracking and Report Generation using ALM.

Automation & ETL QA

Confidential, San Francisco, CA

Responsibilities:

• Responsible for Test deliverables sign off
• Created BDD automation framework for web applications using Selenium, Cucumber, Java and TestNG.
• Worked on UFT hybrid framework, identifying the functional areas and created different functions to make the scripts reusable in UFT.
• Developing automation test scripts test scripts in UFT using VB Script.
• Prepared UFT test scripts using checkpoints and used regular expressions for handling objects with different names.
• Data Driven Testing using parameterization in UFT to test the application with different sets of data.
• Executing test scripts from ALM.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Analyzed application data using the SQL to identify the ETL processes
• Running Informatica workflows
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Writing complex SQL queries to verify data from Source to Target
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Writing and executing SQL scripts to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Extensively tested the Business Objects reports by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Analyzing the test results and creating the bug report.