Professional Summary:

●Over * years of experience in Quality Assurance in Information Technology, Manual and Automation testing of web and mobile applications.

●Experience as a QA Tester / ETL Tester in analysis, development, testing, maintenance, and implementation of Data Warehousing applications using ETL tools.

●Extensive work experience in different types of testing like data integration, data transformation, Incremental, Functional, Regression, Database and User Acceptance Testing (UAT).

●Good knowledge of the quality assurance/quality control (QA/QC) processes applied to Web based systems and web services

●Experience in creating and executing test scripts and performing QA functions for custom application development projects.

●Solid knowledge of SQL and experience in querying and manipulating data from various databases and data sources.

●Experience accessing, compiling, and analyzing large volume data into concise and precise information utilizing SQL Server database programming

●Experience with back-end testing, accessing, and manipulating databases using SQL. Strong knowledge of SQL and database structures, including the ability to write complex queries

●Experience with ETL tools and technologies, such as Informatica and SSIS.

●Experience with UI automation frameworks like Selenium and Appium

●Experience with maintaining data driven framework and extracted data using Apache POI and loaded into the variables in the scripted code.

●Experience in implementing Page Object Model (POM) by creating elements for each page and distributing automation execution for Continuous Integration process using Selenium Grid and Jenkins.

●Experience with tools such as Gitlab for source code management and continuous testing using Jenkins CI/CD pipeline

●Experience with Web Services testing using tools Postman and Fiddler

●Good Knowledge of Autosys Scheduler

●Proven understanding of white box and black box testing techniques with a complete QA cycle, defect logging and verification of fixed bugs.

●Experience with test management/defect management tools such as JIRA, qTest and ALM

●Experience in working in an Agile/Scrum development process.

Professional Experience:

Marathon Petroleum, San Antonio, Texas April 2022 - Present

Quality Assurance Engineer

Performed design, user interface, functionality, performance, database, and API testing ensuring superior quality and compliance to existing standards including manual functional, web usability, system integration, regression, and backend database validation.

Analyzed user requirements, design documents and other documentation to develop detailed test cases and Work across disciplines to accurately assess quality requirements for accurate pointing of stories and tasks in Azure DevOps

Developed Test Plans, Test Scenarios, Test Cases using requirements and design documents throughout Functional, System, Regression and UAT Testing of web applications for projects managed through Agile development methodology

Performed data validation on the backend by writing complex SQL queries, accessing, and manipulating databases including validating stored procedures, jobs, and triggers

Performed API services testing using postman and fiddler to post components for data validations.

Documented software issues on MS Azure DevOps and assist development with concise and detailed steps for duplication of issues found.

Used ALM(Quality Center) to organize and manage all phases of the software testing process, including planning tests, executing tests, logging bugs, and tracking defects

Prepared required test documentation and prepare test data, review test results, and evaluate for conformance with design.

Worked closely with product managers, developers, Agile teams to create well-structured test cases that assert the interests of our customer as part of a comprehensive test strategy

Participated proactively in all Agile events including grooming, sprint planning, sprint execution, daily stand-up, and retrospective.

Client: ExxonMobil, Spring, Texas Feb 2020 – April 2022

Programmer Analyst

●Developed and executed comprehensive test plans, test cases, and test scripts for ETL processes and data integration workflows.

●Performed end-to-end testing of ETL systems, ensuring the accuracy and completeness of data transformations, data mappings, and data loads.

●Validated data integrity, consistency, and conformity across various data sources and targets.

●Identified and documented data quality issues, anomalies, or gaps in the ETL processes and recommended appropriate solutions.

●Collaborated with cross-functional teams, including data engineers, data analysts, and business stakeholders, to understand data requirements and business rules.

●Conducted performance testing to optimize ETL processes for efficiency and scalability.

●Used data testing tools such as Query Surge to validate data quality and integrity

●Proficient in troubleshooting database issues and experienced in using performance monitor for queries that run longer.

●Ability to work closely with Development, Business, system analyst and UAT teams to provide them the required support.

●Defect tracking and reporting was done using JIRA as Test Management software.

Client: Verizon, Piscataway, New Jersey Aug 2018 – Jan 2020

Automation Developer

●Designed, Developed and Maintained automation software for Point-of-Sale suite of applications.

●Developed and implemented a POM based automation framework using Appium, Java, TestNG Maven and Selenium Web Driver to test web and mobile applications (iOS devices including native and web testing)

●Automated regression suites by developing and testing over 2000 scripts for POS (Point of Sale). converted functional tests into Regression tests and add them to Regression suite.

●Maintained data driven framework and extracted data from excel files using Apache POI and to load into the variables.

●Design, develop and implement a scalable test automation framework using Java, selenium and Appium.

●Good knowledge on web services tool Rest API and understanding of HTTP code responses using postman

●Used Git as code repository to manage code, document coding standards and perform code reviews periodically. Experience with Source Code Management using GIT and automating scripts using Java.

●Built CI/CD pipeline to enable automated test execution on each build using Jenkins to provide feedback to the team about the test execution.

●Involved in resolving critical bugs/defects and verifying in a timely manner for a given Sprint using defect tracking tool JIRA/qTest.

●Maintained automation scripts, risk analysis, root cause analysis for Release support. and reproduced failed test cases manually. Performed regression and system-level testing to verify software quality and function prior to release.

●Coordinate and collaborate work with the onshore/offshore external team members to automate test scripts, run test suites, analyze, and visualize the findings.

Virtusa Consulting Services, Hyderabad, India May 2016 – Dec 2016

Programmer Analyst

●Designed and automated functional, integration, system and end-to-end test scripts using Selenium WebDriver.

●Automated regression test cases using Selenium WebDriver and TestNG across systems to ensure that changes and fixes do not impact other modules of the system.

●Extensively used Page Object Model (POM) for readable test script and easy maintenance.

●Configured Selenium Web driver, Maven tool and created selenium automation scripts in Java.

●Updated the JIRA with manual/automated test cases and attended weekly status meetings with development and management teams.

●Actively involved in production support and performed post-Production verification.

●Experience in Blackbox testing with a complete QA cycle from testing, defect logging and verification of fixed bugs.

Education:

Master’s in Information Technology; Rutgers, New Jersey

Contact this candidate