SUMMARY

• Over 7+ years of overall IT exposure in Quality Assurance using Manual & Automation testing with Data Warehousing which involves ETL, Teradata, Reporting and Data modeling experience.
• Proficient in using test automation tools such as Selenium Web Driver using Java, SOAPUI to develop automation testing scripts for web and client server applications.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Experience in Water Fall, V Model, Agile Scrum, Agile XP, and RUP methodologies, well versed with Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Logging and Tracking Defects in all the phases.
• Experience in working with Cucumber to develop BDD (Behavior - Driven Development) test cases using Gherkin syntax.
• Experience with test automation tools such as Selenium, TestNG.
• Experience in working with Frameworks like TestNG, Data Driven Framework, Page Object Model (POM)
• Expertise in writing unit test cases using JUnit.
• Experience in using JENKINS for Continuous Integration (CI) testing and MAVEN, GRADLE build tool to download the dependencies.
• Experience in Functional Testing, Data Driven Testing and Web/HTTP for Web Services using SOAP UI.
• Expertise in Manual /Automation testing of Web Applications and Database testing using SQL Queries.
• Used external jxl. jar (JExcelApi) and Apache poi to get the test data from Excel sheets.
• Experience with Testing frameworks and used libraries such as rest assured and with API testing framework using Karate.
• Used LoadRunner to regularly test performance life cycles.
• Very good understanding overall ADMS project and its functionalities.
• Worked with AMS developers for PON/PRN Processing and ADMS web UI testing for ADMS Services.
• Worked on validating the PAS application for ADMS Services.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Extensive work in ETL Testing using SQL, UNIX, PL/SQL, TOAD.
• Strong SQL query skills using an enterprise-wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL, DCL and TCL.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, MYSQL and Teradata.
• Extensively tested data validation, load processes (ETL) using Toad and SQL Developer.
• Daily and Weekly Status reports were updates to the Team Lead, Test Groups, and Test Managers to coordinate test cycles.
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Experience in Functional Testing, Black Box Testing, System Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Good Knowledge in Data Modeling and HADOOP/BIG DATA.
• Experience in Black Box Testing, Functional Testing, Data Driven Testing and Web/HTTP for Web Services using SOAP UI, POSTMAN tool.
• Extensively performed automated testing for SOAP/WSDL/XML web services for the different portfolios.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Co-ordinate in creation and execution of QA and testing processes, test strategies and plans, bug documentation and bug tracking and used Requirement management and bug tracking testing tools like JIRA XRAY, Quality Center (HPALM).
• Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.
• Proficient in different phases of testing like Sanity Testing, Functional Testing, GUI Testing, Regression Testing, Integration Testing, Front End Testing, System Testing, API Testing, Performance Testing, User Acceptance Testing (UAT) on windows systems.
• Experience in version control tools SVN and GIT repository for code sharing.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.
• Team management for onsite-offshore teams including performance tracking and technical support.
• Time management, Strong analytical, Excellent organizational, Detail oriented and Problem-solving skills with a consultative approach in defining solutions.
• Good communication and interpersonal skills.
• Good understanding of the Cloud platforms like Microsoft AZURE.
• Created projects in Azure Devops.
• Worked on configuring Azure pipelines for build by using YAML Scripting.
• Worked on Jenkins declarative pipeline for building the code.
• Experienced in developing Automated scripts using Selenium Web Driver with Java for CI/CD Pipeline.

TECHNICAL SKILLS

Data Warehousing ETL: Abinitio, Data Stage, HADOOP, INFORMATICA Power Center, Metadata, Data mart, FACT & Dimensions tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

Test Build & Integration Tools: Gradle, Maven, Jenkins

Databases: Oracle 11g/10g/9i/8.0, MySQL 5.4, MYSQL, OLTP

Programming: SQL, PL/SQL, SQL Loader, Unix, Shell Scripting, C, Java, HTML, XML, Perl, PHP, JavaScript

Frameworks: Keyword Driven, Data Driven, Hybrid, Page Object Model (POM) and Karate.

Environment: UNIX(IBM AIX, Sun Solaris), Windows XP/Vista, Linux(RHEL)

Testing Tools: Selenium Web Driver, TestNG, Selenium IDE, Selenium RC, Selenium Grid, JUnit, Cucumber, Soap UI, QC, QTP, GIT, SOAP UI, HP Quality Center 10, QTP, Selenium, Test Director, JIRA Xray

Browsers: Edge, Mozilla Firefox, Google Chrome, Safari, Chromium

Utilities: Eclipse, BitBucket, Firebug, Fire Path, IntelliJ

Cloud Platforms: Microsoft AZURE

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL/QA Automation Test Engineer

Responsibilities:

• Involved in preparing Master Test Plans, QA metrics and mentoring the team in testing methodologies.
• Performed UI and API testing and created framework from scratch.
• Manage life cycle ofautomationproject involving in hosting theautomationmeetings, coordinating, gathering theautomationrequirements, defining the scope ofautomationtesting.
• Developed the automated test script for regression test suite in an application by usingSeleniumtool.
• Createdautomationframework using Hybrid model framework and Data Driven framework to test web application. Thorough understanding of POM using page factory.
• Worked onSeleniumWebDriverautomationscript in Java for cross browser testing. Used testing annotations to group the test methods and for cross browser.
• Involved in Web Application GUIautomationcreating regression suites usingSeleniumWeb Driver, JUnit/TestNG, and Eclipse.
• Ability to enhance LoadRunner test scripts
• Developed test scripts to fetch test data from Excel using Apache POI API.
• Use Fire path and Firebug Firefox plugins for identifying all the web elements using locators.
• Developed Java Test scripts using TestNG annotations.
• Maintaining theSeleniumand Javaautomationcode and resources in the SVN source control.
• WroteSeleniumscript for taking screen shots using Extent Reports API and implemented action class to perform mouse movement.
• Design and BuildAutomationFramework from scratch usingSeleniumWebDriver, Eclipse, TestNG and Java in Windows platform.
• Experience with Testing frameworks and used libraries such as rest assured and with API testing framework using Karate.
• UsedSeleniumPage Object Model, Page Factory design pattern to build data driven framework.
• Interacted with the Subject Matter Experts (SME) and Business Analyst to get a better understanding of client business processes and gather requirements.
• Attended weekly design meetings to understand the application and specific new or modified features.
• Analyzed functional requirements and design specifications to ensure that application meets all technical and business requirements.
• Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from Oracle database.
• Participated in sprint planning, execution, testing and releases in Agile Methodology.
• Performed System Testing, GUI Testing, Integration Testing, Functional, Black box and Regression Testing.
• Performed database validation using Oracle SQL queries and wrote testautomationscripts usingSeleniumWeb Driver.
• Used Junit and TestNG as testing framework, and Maven for project building.
• Configured Jenkins built job for continues integration and also for regression testing.
• ImplementedautomationusingSeleniumWebDriver, JAVA,SeleniumGrid, TestNG and Jenkins.
• Extensively worked in Regression testing usingSeleniumWebdriver in TestNG.
• Used Junit and TestNG as testing framework, and Maven for project building.
• Performed functional testing of SOAP and RESTFULL Web Services using SOAPUI Tool.
• Support CI/CD (Continuous Integration and Delivery) using Jenkins
• Implemented BDD (behavior-driven development) to run automated acceptancetests using Cucumber tool.

Environment: Java,SeleniumWebDriver, Cucumber, TestNG, Maven, Jenkins, SOAP UI, GIT, Agile, Firebug, Fire path, XPath, Eclipse, Quality Center, Oracle, Windows, Java, J2EE

Confidential, Kentucky

QA Automation(SDET)

Responsibilities:

• Participated in all meetings with project team members on Overview and Architecture.
• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Worked on testing data migration, data integration and data transformation.
• Written test cases to validate the ETL Informatica mappings and maples.
• Executed SQL queries using TOAD to query Oracle database. Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts.
• Used SQL Assistant to write SQL and query the Teradata database tables.
• Created complex SQL queries to validate the initial and incremental ETL loads. Used PL/SQL function to validate some test scenarios.
• Very good understanding overall ADMS project and its functionalities.
• Worked with AMS developers for PON/PRN Processing and ADMS web UI testing for ADMS Services.
• Worked on validating the PAS application for ADMS Services.
• Tested both multi-protocol and multi-party processes. Worked with UNIX commands like GREP, LESS and Diff.
• Tested several Informatica Mappings to validate the business conditions. Written positive and negative test cases for Cognos reports based on report specifications.
• Performed the build and Maven dependencies using the Maven build tool.
• Experience working with TestNG by using different Annotations.
• Developed features and test scripts using BDD (Behavior-driven development) in Cucumber.
• Developed Cucumber HTML, JSON test reports for analyzing the test outputs
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Validated several Drilldown and Pivot reports published in Cognos Scoreboard. Worked on testing report filter and view filter in Cognos reports.
• Experience with Testing frameworks and used libraries such as rest assured and with API testing framework using Karate.
• Worked with non-transactional data entities for multiple feeds of reference data using MDM
• Validated Prompts, filters, calendars and Cosmetics in reports. Participated in Project Status meetings and updated QA status and defect status.
• Used Quality Center to document and open defects and track them from time to time.
• Interacted with developers to resolve the ETL and reports defects.

Environment: Selenium WebDriver, Data warehouse ETL Informatica 8.1, Teradata V2R6, MAVEN, TestNG, CUCUMBER, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, UNIX, and Quality Center 9.0.

Confidential

Test Engineer/ETL Tester

Responsibilities:

• Created Modular DrivenAutomationFramework from the Scratch.
• Developed automated test scripts usingSeleniumand in Java Eclipse.
• Involved in test cases review by development team, product management and modified the test cases based on their feedback.
• Experience with Testing frameworks and used libraries such as rest assured and with API testing framework using Karate.
• Experience in working with Build Systems like Ant, Maven, and continuous integration systems like Jenkins, Hudson, TeamCity, and Cruise Control.
• Performed Regression testing for new builds and every modification in the application using SeleniumWebDriver.
• Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
• Performed cross-browser testing.
• UsedSeleniumGRID to execute test cases on multiple platforms.
• Responsible for updating and maintenance of existingseleniumscripts.
• Performed testing on web services using SOAPUI with XML web services and SOAP.
• Created positive and negative assertions based on the business requirements.
• Performed Data Driven testing using SOAPUI.
• Extensively involved in resolving bugs fixes with Development Team.
• Performed Black Box and Functional Testing
• Used Jenkins as continuous integration tool to schedule and run the automated test scripts.
• Used SVN for Build Management for each release, QA, Integration and staging environments.
• Actively participated in daily Scrum meetings and involved in bi-weekly Sprint releases.

Environment: ETL Informatica, Oracle, SQL Server, Quality Center/ALM, ANT, MAVEN, SQL, TOAD, Teradata, PL/SQL, SQL Server, UNIX, SSRS, MS Access, Flat Files.

Confidential

Functional Test Engineer

Responsibilities:

• Involved Manual testing, Black Box Testing, Functional Testing, Regression testing, System testing, Integration testing and end-end testing, User Interface testing and Data Driven Testing.
• Gathered test data requirements for data conditioning from Business Units to test total application functionality.
• Responsible for testing Remedy Incidents (production defect tickets), regression testing existing functionality of the application and features.
• Created test scenarios for System testing and Regression testing.
• Prepared test plans, test cases for both positive and negative scenarios and mapped the same to requirements.
• Executed test scripts, and analyzed the test results.
• Experience with Testing frameworks and used libraries such as rest assured and with API testing framework using Karate.
• Used Test Director as a central repository for all the test activity.
• Attended meetings with developers in the discussion on resolving the issues, priority of bugs and updating the status of bugs once they are fixed.
• Responsible for writing the SQL queries to verify GUI front-end results and to extract and to manipulate the data to satisfy test cases/ requirements.
• Tested Web page presentation manually for different browser compatibility.
• Tested broken links and inter application links in Development, Test, and Production environments.
• Bug tracking and defect logging tools like Bugzilla, Jira, remedy, HP Quality Center/ALM.
• Executed test cases before and after bug fixes for each build for User acceptance testing.
• Tested the application for third party vendor confirmation and client reports as peruse cases.

Environment: Test Director, Win Runner, J2EE, Tomcat, HTML, UNIX Oracle and Toad.