SUMMARY:

• Having 11 + years of Software Quality Assurance experience as a QA Automation Test Lead /ETL Test Lead/Bigdata Hadoop Test Lead which includes Selenium Webdriver Java Automation frame work Testing,Web Services/Rest API Testing with Soap UI, Cucumber BDD Testing, Web Application Testing, Database Testing, Dataware house ETL Mapping Testing and Hadoop Bigdata Testing.
• Having experience on various domains like Retail Marketing, E - commerce, Insurance,911 Emergeny Call, Power station and Mobile Telecom.
• Selenium Automation Framework Testing (Java Environment, .Net Environment)
• ETL Dataware house Testing
• BI Report Testing
• Bigdata-Hadoop Testing
• Web Application Testing
• Backend/Database Testing
• API Testing/Webservices Testing
• Unix Testing
• Excellent experience in each phase of Test Life Cycle, Test strategies, Test plans and UAT.
• Experience in Defining Testing Methodologies, creating Test plans, Test Strategy, Test cases, Test Reports, Verifying and validating QA implementation in all phases of Software Development Life Cycle (SDLC).
• Automated highly transactional e-commerce web application using Selenium WebDriver.
• Experience in Selenium automation testing by using Selenium WebDriver, Selenium Grid and Selenium IDE
• Designed and implemented different automation frameworks from starch like Page Objects framework, Keyword Driven framework, Data Driven framework and Hybrid framework.
• Experience in Maven, Jenkins, Git, TFS and GitHub.
• Experience in CI/CD integration testing on the Devops principles.
• Experience in the frame works by using TestNG,JBehave and JUNIT
• Experience on the Performance Testing by using JMeter.
• Hands-on coding experience in scripting language- VB Scripting.
• Having experience on the Bigdata Hadoop Testing by using HDFS,Pig,Mapreduce,Hive,Hbase,Spark and Azkaban.
• Having experience on the Data Ingestion process Testing and validation testing by using Hive-HQL and HBase.
• Solid experience of Software Development Life Cycles, Cucumber, JAVA, JUnit, Web Applications, JIRA, Maven.
• Executed automation scripts on different browsers/environments & reported defects/results to the team.
• Experience on the Web services/API testing by using SOAP UI, REST, XML, WSDL and XSD.
• Having very good experience of Quality Assurance methodologies like Waterfall, V-Model, and Agile Scrum.
• Solid experience of AGILE Methodologies, Scrum processes
• Solid experience of Defect/Test Management tools like JIRA, Quality Center/Test Director, BugZilla and Rational Clear Quest.
• Proven ability in developing BDD scripts with Cucumber and writing step definitions for behavior.
• Excellent experience of build tools like Maven and managing JAVA automation projects using them.
• Strong communication & interaction with Clients, Developers, Business Analysts, Management
• Experience in Working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, Reporting and Assisting to Manager
• Experience to handle the multiple projects and delivered as per the project deadlines.
• Expertise to write complex SQL Queries and performance Database testing.
• Experience on the Web testing by using HTML, XML, Java,J2ee,CSS,Java Script, AngularJS, jQuery, PHP.
• Strong experience on the On-shore -off-shore model process and leading the off-shore team.
• Experience in the Mainframes Testing on the Batch-process and On-line process.
• Experience on the Pre-Production validation testing and Post Production validation testing.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data verification and identifying data mismatch.
• Experience in ETL testing of applications which use integrated database using Informatica, Oracle, DB2, Tera Data, Sql Server, Hive and Netezza.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Experience on Data Validation Automation Testing by using Informatica DVO tool.
• Experience on the Testing of Unix shell scripts and Linux commands.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Expert in different types of testing that includes Black Box testing, White Box Testing Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT).
• Knowledge in testing Python Scripting and Ruby Scripting.

TECHNICAL SKILLS:

Automation Testing Tools: Selenium WebDriver/RC/Grid/IDE,QTP,UFT

Languages/Frameworks: JAVA, JBehave,JUnit,TestNG,Python,Ruby

BigDataHadoop: Hive, Hbase, HDFS,Azkaban,Pig,Unix

Bug Tracking Tools: JIRA, BugZilla, Rational Clear Quest

Test Management Tools: HP QualityCenter/TestDirector

RDBMS: Netezza,SQL,Teradata,MySQL,Oracle,DB2,Mongo DB, No SQL

Scripting Languages: Java Script, Python,Ruby,HTML,XML,VB ScriptAngularJS,jQuery

Operating Systems: Windows 7/8, OS/390, UNIX, LINUX, Windows-10, Windows - 7, Vista, XP, NT

Domain Knowledge: E-commerce,Retail, Insurance, Banking, TelecomETL Tools: Informatica Power Center 9.5/9.1/ 8.6/ 8.1 , Abinitio, Aginity MDM

Analytics: Netezza Analytics

Tools: / Utilities: Erwin 8/ 7.2, Aginity, IBM Fluid Query, JIRA, IBM-Unica, Informatica DVOIBM: COBOL, JCL, CICS, DB2, Fi le-Aid, QMF, SPUFI, Unica

BI Tools: Cognos, Microstrategy, Tableau

Application environments: C#, .NET Framework, ASP.NET, VB .NET, Web Services, Java,J2EE,JSP

MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio

SDLC Methodologies: Waterfall, Agile Scrum, V-Model

Google environment: Google Sheet, Google Drive

WORK EXPERIENCE:

Confidential, Mnemoneefalls, WI

Automation QA Lead/BigData-Hadoop Test Lead

Responsibilities:

• Agile Methodology implemented.
• Analyzed the Sprint User stories and the technical specification documents.
• Involved in Sprint planning, Sprint Review, Sprint Retrospective and Sprint Demo
• Prepared the Test Plan, Test schedule estimates based on the Sprint User stories.
• Understand JIRA stories, use cases, business rules, requirements and acceptance criteria and convert them to test scenarios and test cases.
• Implemented automation using Selenium WebDriver, JAVA, Selenium Grid, Cucumber and Maven .
• Writing and modifying the automation test scripts according to requirement changes for every release using Selenium WebDriver.
• Created and developed automation testing framework by using TestNG,Jbehave & JUnit
• Running the scripts for validation and stabilization, analyzing the errors and issues.
• Extensively automated regression and functional test suites by developing the automation scripts using Selenium WebDriver and JAVA.
• Implemented Page Objects framework and classes from scratch to represent web pages.
• Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases.
• Used Maven, Selenium Grid to execute Selenium automation suites on different platform, browser combinations in parallel.
• Developed BDD tests using Cucumber by writing behaviors and step definitions. Developed required Selenium support code in JAVA for Cucumber.
• Wrote SQL queries extensively, queried database and generated test reports. Performed Purchase Orders Database testing by developing SQL scripts .
• Performed Defect Tracking & Management in JIRA. Generated automated daily dashboards reports using JIRA.
• Assisted Manager by providing automation strategies, Selenium/Cucumber Automation and JIRA reports.
• Identified weaknesses in QA Processes, Web testing, Selenium Automation. Suggested & implemented improvements.
• Executed and managed test cases and reported bugs in Quality Center-ALM.
• Jira tool has been used to develop the User Stories for Agile process.
• Developed the Automation scripts and did the Mobile Automation Testing by using Appium.
• Followed the On-shore -off-shore model process and lead the off-shore team.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, System testing and User Acceptance Testing.
• Supported for the Production Data validation testing and UAT testing.

Environment: Selenium, Java,Java script,HTML,Json,jQuery,TestNG,SQL,Teradata,UNIX, QC-ALM, Jira, MS Visio,Junit,Jbehave, Google Drive, CIA-Unica, JBehave,Netezza,Hive,Jenkins, GitHub,JMeter, Cucumber,BDD, Maven, Eclipse, IntelliJ IDEA,HDFS,Pig,Hue,Putty,Unix,Hbase,Azkaban.

Confidential, Beaverton, Oregon

Automation QA Lead/ETL Test Lead

Responsibilities:

• Created automated Test scripts using automated tools and ran the test scripts on various Builds and instances.
• Created Test cases using Element locators and Selenium Web driver methods
• Enhanced Test cases using Java programming features and TestNG Annotations.
• Execution of selenium test cases and verified the Test suits.
• Conducted Data driven testing, cross browser testing and parallel test execution.
• Involved in Automation environment setup Eclipse,Java,Selenium Web driver and TestNG
• Designed the Automation Framework and Implemented the Automation Framework.
• Followed the Agile Scrum methodology process.
• Involved in Sprint planning, Sprint Review, Sprint Retrospective and Sprint Demo
• Understand JIRA stories, use cases, business rules, requirements and acceptance criteria and convert them to test scenarios and test cases.
• Define the scope of what will be tested, how it will be done (i.e. the testing tasks), when it will be tested (start/end dates), testing dependencies, associated program/project risks with testing, test entrance/exit criteria and who will be testing.
• Develops test plans and strategies based on system requirements and design documentation.
• Execution of test cases with documented results by using HP Quality Center Tool.
• Raised the defect s for unmacthing of the expected and actual results.
• Logged defects in HP Quality Center Tool with thoroughly documented details and attached examples.
• Written the complex SQL queries to perform the data validation.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
• Involved in Test Reporting on daily/ weekly basis and updated to same to the management and client.

Environment: Java, JSP, Selenium,Junit Webservices, Rest API, HTML, XML, CSS, JUNIT, Windows-10, Quality Center-ALM, VB-Script,QTP,UFT,Jira, Jenkins, Maven, Eclipse, AngularJS, Bootstrap, Node.

Confidential, Minneapolis, MN

QA Test Lead

Responsibilities:

• Performed web Application Testing by using client provided environment.
• Applied Agile Scrum methodology
• Analyzed the Sprint User stories.
• Involved in Sprint planning
• Involved in Sprint Review meeting
• Write requirements for user stories in QC
• Peer review on requirements
• Write test cases for new requirements
• Associate requirements to test cases in QC
• Participate in Prerelease review
• Verified the data transfers through executing the SQL queries by using DB2.
• Report and Review defects in Quality Center
• Performed Functional testing, Regression testing, Integration testing, System testing, and E2E Testing
• Interaction and discussion with Client on daily basis
• Interaction with Australia customer on daily basis
• Prepared Best Practice documentations and shared with team
• Conducted trainings and mentoring junior team members.
• Responsible for offshore deliverables and Team.
• Responsible that there are no defects escape and high severity incidents for all tests delivered in subsequent faces.
• Conducted weekly status meetings and Bug review meetings.
• Organize the test status meetings and send the Status Report (Daily, Weekly etc.) to the Client.
• Track and prepare the report of testing activities like test completion report for each phase, defects discovered and their status, performance baselines etc.
• Updating Test results in QC and reporting the results on daily basis and weekly basis.

Environment: Eclipse, Core Java, Selenium, Webservices, Rest API, HTML, XML, Ajax, CSS, JUNIT, Windows-10, Quality Center-ALM, Jira, Jenkins, Maven, XML, XML SPY, Oracle, SoapUI,WSDL,PHP,MYSql

Confidential, Sanfransico, TX

Senior QA Test engineer

Responsibilities:

• Involved in the Business Requirements and scope of the application Testing.
• Performed various levels of testing like System testing, Integration testing and Regression testing.
• Prepared the Test plan based on the business requirements.
• Prepared the Test cases based on Functional Specification and System Requirement document
• Peer review on Test cases
• Upload the Test cases in Quality Center
• Associate requirements to test cases in QC
• Developed Automation test scripts using QTP and enhancement of the functionality of the Script for automation of testing Scenario.
• Created and Tested framework module wise by using Vb-scripts to test the application functionality.
• Prepared Test data for Test case execution
• Executed the Test cases and validated the Test results.
• Raised the defects for unmatched of the expected and Actual Test results.
• Interaction and discussion with Client on daily basis.
• Conducted weekly status meetings and Bug review meetings.
• Monitoring Work progress on daily basis.
• Prepared the Test summary report on the weekly basis.

Environment: QTP,VB-Script, ASP.NET, C#.NET, AJAX, HTML, PHP, XML, Quality Center, Windows-XP,, MYSql, Sql Server.

Confidential, Beaverton, Oregon

Senior QATest engineer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, Confidential, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the issues.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Enhanced and created new ETL test cases based on the change requests.
• Validate the source and the Confidential systems by executing the complex sql queries.
• Tested the performance bottle necks at sources, targets, mappings and sessions and employed required measures.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Performed various levels of testing like System testing, Functional Testing, Integration testing and Regression testing.
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.

Environment: Informatica PowerCenter 8.6.1/9.0.1 , Teradata, Oracle 9i,Unix,Unix Shell Script Flat files,DB2, SQL, TOAD 7.0, Windows XP, OS390 and Autosys. Sql Server, Erwin 8.0, Quality Center, Agile Tool.

Confidential, Mnemoneefalls, WI

QA-Test Engineer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in unix environment.
• Optimizing performance tuning at source, Confidential, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the issues.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Enhanced and created new ETL test cases based on the change requests.
• Validate the source and the Confidential systems by executing the complex sql queries.
• Tested the performance bottle necks at sources, targets, mappings and sessions and employed required measures.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Performed various levels of testing like System testing, Functional Testing, Integration testing and Regression testing.
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.

Environment: Informatica PowerCenter 8.6.1/9.0.1 , Teradata, Oracle 9i,Unix,Unix Shell Script Flat files,DB2, SQL, TOAD 7.0, Windows XP, OS390 and Autosys. Sql Server, Erwin 8.0, Quality Center, Agile Tool.

Confidential, West-Minister, Colorado

QA-Test Engineer

Responsibilities:

• Analyzed the Sprint User stories.
• Involved in Sprint planning, Sprint execution, Sprint demo.
• Prepared the Test cases based on the user stories in QC
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to
• Load data from source flat files and RDBMS tables to Confidential tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Performed segmentation to extract data and create lists to load the data in the Confidential system.
• Running workflows though control-M-jobs. Attending the client calls and updating the status of the Testing status
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Executed the workflows in the workflow manager, to start the ETL process.
• Created and executed SQL queries to perform source to Confidential testing on DB2 database.
• Worked on Autosys which involved in creation of Autosys jobs and execution.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading and pulling the data.
• Updating Test results in QC and reporting the results on daily basis and weekly basis.

Environment: Cognos,SQL,Test Cases, Test Scripts, Test Plan, Traceability Matrix, Quality Center,IBM DB2, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), SQL, Oracle8i.

Confidential, Colorado-Springs, Colorado

QA-Test Engineer

Responsibilities:

• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to
• Load data from source flat files and RDBMS tables to Confidential tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Performed segmentation to extract data and create lists to load the data in the Confidential system.
• Running workflows though control-M-jobs. Attending the client calls and updating the status of the Testing status
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Executed the workflows in the workflow manager, to start the ETL process.
• Created and executed SQL queries to perform source to Confidential testing on DB2 database.
• Submitted the Jobs and verified the results in Spool files and tables.
• Performed On-line Testing by using CICS screens.
• Verified the data by executing Sql queries by using DB2, QMF, SPUFI
• Involved in End to End Process Testing for Mainframes Testing and Web application Testing.

Environment: SQL, PL/SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director,IBM DB2, COBO L, Flat Files, Copy Books, MVS, TSO, JCL, Control-M, ISPF, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), SQL, Oracle8i.