SUMMARY

• Software Professional with 8 years of diversified experience in managing and leading Quality Assurance testing efforts in domain like Loyalty Rewards, CRM, Airlines, Hospitality, and Retail in Agile and Test - Driven development (TDD) environment.
• Proven expertise in Requirement Analysis, Manual & Automation Testing of Client Server/ Web Based Applications using Selenium WebDriver With Python 3.x . Inspecting elements on Chrome, FireFox and building Xpath.
• RestAPI Testing with SoapUI & Postman and using other tools like Jira, Confluence, TestRail
• End to End Integration with Selenium, Maven, GitHub and Jenkins (CICD)
• Experience in ETL - DWH testing, data validation and S2T mappings.
• Familiar with OLTP, OLAP, DWH Concept Kimball, Inmon, Data Mart, Normalization, Denormalization, Star Schema, Fact & Dimension.
• Worked with Informatica Power Center validating Mapping, Transformations, S2T logic
• Hands on Experienced in Testing Big Data, Hadoop applications using Spark, Hive, Pig, Scala, and NOSQL technologies such as HBase, MangoDB, Cassandra.
• Complete understanding of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC) including Integration/System Testing, Performance Testing, Regression Testing, Functional, Non-Functional Testing on teh legacy system and Big Data Hadoop Cluster
• Experience in software testing process including Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Experience in automation technologies, tools, and frameworks: Selenium WebDriver, SauceLab and RestAPI Automation using RestAssured, SoapUI & Postman and managing Automation regression Scripts
• Developing Automation Framework and End to End Integration with Selenium, Maven, GitHub and Jenkins
• Expertise in ETL-DWH testing, writing complex SQL queries and executing stored procedures for data validation . Experienced in Data Profiling, Metadata validation and S2T mappings.
• Exposure to BigData Testing and Hadoop ecosystem technologies: HDFS, Map Reduce, Hive, Pig, Spark, HBase, ZooKeeper, Flume, Sqoop, Oozie and NoSql Database MangoDB, Casasandra.
• Extensively worked on projects in Agile environment participating in Scrum calls, Sprint Planning, Backlog grooming, Pointing, Daily stand up and sprint retrospective using JIRA.
• Possess good communication skills, self-motivated, task oriented and quick learner
• Experience in working onshore/offshore model and provide quality mentoring

TECHNICAL SKILLS

Methodologies: Waterfall, V - Model, Rational Unified Process (RUP), Agile (Scrum), Kanban-Agile Lean Project, TDD, BDD

Agile Framework: Agile, User Stories, Product Backlog, Sprint Planning, Pointing, Daily Scrum Stand Up, Burndown chart, Retrospective

Quality Assurance: Software Application Testing Life Cycle, Automation Frameworks, WebService API, ETL backend data validation, BigData Hadoop cluster

QA Tool/ Automation: ALM, Selenium WebDriver, SuaceLab, RestAPI Automation using RestAssured, SoapUI & Postman SoupUi, Postman, VisualStudio

Defect Management: Jira, Confluence, TestRail, Bugzilla, TFS, MTM

Languages: SQL, PL/SQL, HTML, CSS, Java, Java Script, Linux, XML, Groovy, Python, JSON, Cucumber.Js

Database/DWH: OLTP, OLAP, DWH Concept Kimball, Inmon, Data Mart, Normalization, Denormalization, Star Schema, Fact & Dimension. Oracle 11, Sql Server 2012

ETL Testing / Tool: S2T Mapping, Data Profiling, Matadata Validation, Data Models, Erwin, Informatica PowerCenter, SSIS

Bigdata Hadoop Ecosystem: SQL, PL/SQL, HTML, CSS, Java, Java Script, Linux, XML Ambari, HDFS, MapReduce, Yarn, Spark, TEZ, Hive, Pig, Hive, ZooKeeper, Oozie, Storm, Hbase, MangoDB, Cassandra

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis MN

Software Quality Test Engineer

Responsibilities:

• Participated in all phases of teh test cycle, including Integration/System Testing, Performance Testing, Regression Testing, User Acceptance Testing, etc.
• Worked in agile environment, employing 2 week sprints, daily scrum meetings, sprint planning, retrospective, pointing, burn-down charts, task assignments, reports and review
• Staged test data, test account to executed End to End test scenarios as part of User Acceptance Testing. Validated and reproduced UAT defects providing test cases and scenario
• Develop test plans from design and requirements documents(TDD. BRD), consolidates scenarios, test cases and other input contributed by other team members
• Performed ETL and Database testing, wrote SQL queries, and executed stored procedures for validating data, reports and extracts
• Validated Full and Incremental loads through ETL tools on different environment
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping.
• Validate Kafka real time streaming of data and HDFS storage
• Validated RRDs transformation logic on Spark Data steam / DStream
• Wrote Spark SQL to view and validate of RRDs dataset as per Spark Script
• Performed Data validation against HDFS files in CLI writing UNIX shell command
• Created Hive tables for Data Viewing.
• Used Sqoop for Data Moving from RDBMS to HDFS using UNIX shell command
• Validated data from RDBMS to HDFS using UNIX command executed in CLI
• Tested Web services (SOAP and REST) using SOAP UI, Postman Collection and Swagger Doc to validate consumer Rest API in a TTD / agile environment .
• Developed and Run automated test suits in Selenium Webdriver for new modules and regression suits for teh application covering all test scenarios
• Extensively used JIRA, Confluence and TestRail for Defect reporting, tracking and Test Case Execution.

Environment: Test Rail, JIRA, Confluence, Babmboo, SauceLab, Portman, Soap UI 5.3, Selenium, SQL Server 2012, multisource, BatchMagicServlet, SpringFramework5, GitHub, SourceTree, SwaggerDoc

Confidential, Minneapolis MN

Software Quality Test Engineer

Responsibilities:

• Worked closely with business client, business analyst and development to review requirements and to define detailed acceptance criteria for teh features being developed to achieve teh expected quality of teh product before delivering to customers within an agile process.
• Actively participated in Iteration Planning, Stand-ups, and Team Retrospectives
• Effectively contributed and implemented new ideas on improving teh software testing framework development & testing process with changing product requirements
• Developed test plan, test cases and Perform test case review, automation code/script review and provide feedback
• Designed, developed, executed and maintained automation/manual test scripts for Functional, Non-functional, Backend, GUI, Integration and System End-to-end tests to ensure code meets requirements and also addressed different types of testing needs.
• Processed Load Files in QA / Staging environment using FileZila - SFTP
• Testing Responsive Web application using Sauce Lab for multiple operating systems, Browsers and Devices such as smart phone, tablets, desktop etc.
• Involved in testing teh Web Services and validating teh WSDLS in SOAP UI & Postman preparing teh Request XMLs and validating teh Request and Response XML in SOAP UI Editor
• Monitors progress of testing efforts using JIRA and Confluence for Defect reporting, tracking to ensure deadlines are met
• Built complex SQL queries to validate back-end data integrity on complex data model over its entire life-cycle

Environment: Oracle 11g, SourceTree, GitHub, Jenkins, Test Rail, JIRA, Soap UI 5.1, Confluence, Sauce Lab, Agile. Portman, Selenium, Chimp, Cucumber.js

Confidential, Minneapolis

Software Test Engineer

Responsibilities:

• Run automated Smoke test scripts batch every morning after each build.
• Review and update teh existingTest Plan
• PerformManual Testingand create test cases includingFunctional Test Cases, Acceptance Test Cases & Regression Test Cases
• Involved in design teh Process, Methodology and Framework for Automated Regression Testing in Selenium
• RestAPI testing validating response, status code and Error Msg using SoapUI & Postman
• Conduct Regression Testing for each release / build running Automation script
• Run Code deploy and Built for continuous integration using Jenkins in QA and Stage
• Wrote SQL scrips for Back end data validation, reports and extracts .

Environment: Oracle 11g, MS server 2012, VisualStudio, SourceTree, IGitHub, Jenkins, Test Rail, JIRA, Soap UI 5.1, Confluence, Sauce Lab, Agile. Portman, Selenium WebDriver

Confidential, Bloomington, MN

Software Quality Analyst / UAT

Responsibilities:

• Performed functional testing, regression testing, integration testing, system compatibility testing, and user Acceptance testing.
• Developed test cases and test scripts for Functionality and Regression testing of web application
• Implemented HP Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.
• Automation Testing of Client Server/ Web Based Applications using Selenium WebDriver and RestAPI Automation using RestAssured, SoapUI & Postman
• Owned and Managed Automated regression Scripts with regular feature / module upgrade
• Wrote SQL Quires to perform Backend database testing.
• Worked with OLTP, OLAP-DWH, Data Mart, Normalization, Denormalization, Star Schema, Fact & Dimension to validate reports and extracts
• Executed stored procedure and wrote validation SQL queries
• Followed up with teh development team as they fix teh bug.
• Facilitated UAT testing by Staging test data, test account to executed End to End test scenarios as part of User Acceptance Testing. Validated and reported UAT defects log sheet .

Environment: HP QC/ ALM, Oracle 11g, MS Server 2012, ETL, Selenium, RestAssured, SoapUI, Filezilla, Putty, GitHub

Confidential

Software QA Test Engineer

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Identified teh Test Cases, documented and executed using QC ALM .
• Participated in test plan and test cases review meetings.
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules.
• End to end execution of test cases, automated scripts, and Test Result analysis.
• Responsible for entering bugs into an automated bug management system and performing regression tests after teh bugs were fixed.
• Responsible for Backend testing by executing SQL statements and ETL testing.
• Followed Agile Testing Methodology for every release of project.
• Built complex SQL queries to validate back-end data integrity on complex data model over its entire life-cycle.
• Tested ETL’s to ensure dat teh source and teh target are mapped as per teh user stories and halped team on data conversion testing

Environment: QC ALM, 10.0, ETL, SQL Server, Oracle11g, Selenium, SoapUI

Confidential, Portland OR

Software Test Engineer

Responsibilities:

• Involved in Requirements analysis, business rules and logics for teh application development.
• Involved in studying teh functionality and flow of data.
• Prepared test cases for functionality testing.
• Involved in Peer Review of teh Test Cases
• Performed functional testing, regression testing, integration testing, system compatibility testing, and user Acceptance testing.
• Performing Sanity, Regression, GUI, Functionality, Browser Compatibility Testing.
• Logging and Retesting of Defects using VersionOne
• Performed Database testing by executing SQL
• Performed ETL/Record count validation and data validations.

Environment: HP QC, SQL Server 2008, Visual Studio 2008/2010, Sharepoint, SOAP, VersionOne