SUMMARY

• Having 13 + years of Software Quality Assurance experience as a QA Test Lead,Senior Automation Test engineer,Salesforce QA Test engineer, ETL Test engineer which includes Selenium Webdriver 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 Salesforce Testing.
• Having experience on various domains like Health - Care,Retail Marketing, E-commerce, Banking & Insurance,911 Emergeny Call, Power station and Mobile Telecom.
• Automation Testing (Selenium,Java)
• SalesForce QA testing (Visual Force,Apex,SFDC,Lightining Compnents,Force.com,SOQL,SOSL)
• ETL automation testing (Informatica-DVO,Informatica,Abinitio)
• Web Application Testing (HTML,XMLJavascript,Ajax,Angular JS,Jquery)
• Backend/Database Testing(Oracle,Teradata,Netezza,Hive,SOO,Sql,DB2,Mongo-DB)
• API Testing/Webservices Testing (SOAP,REST,JSON,WSDL,SOAPUI,POSTMAN)
• Unix shell script Testing
• TDD/BDD Testing (Cucumber)
• 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 usingSelenium 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, ANT,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
• Having experience on the Bigdata Hadoop Testing by using HDFS,Pig,Mapreduce,Hive,Hbase,Spark and Azkaban.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Having experience on the Data Ingestion process Testing and validation testing by using Hive-HQL and HBase.
• Experience on the TDD/BDD testing by using Cucumber
• Having experience on the Devops principle process testing.
• Solid experience of Software Development Life Cycles, Cucumber, JAVA, JUnit, Web Applications, JIRA
• 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.
• Having very good experience of Quality Assurance methodologies like Waterfall, V-Model, and Agile Scrum.
• Solid experience ofAGILE Methodologies and Scrum processes
• Solid experience ofDefect/Test Management tools like JIRA,Rally, 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,Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT).

TECHNICAL SKILLS

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

Languages/Frameworks: JAVA,C#,NUnit, JBehave,JUnit,TestNG,Python

BigData-Hadoop: 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,HTML,XML,VB ScriptAngularJS,jQuery

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

Domain Knowledge: Heath-Care,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

Salesforce: VisualForce,Force.com,Apex,SFDC, Lightining,SOQL,SOOL

PROFESSIONAL EXPERIENCE

Confidential

Salesforce-Test engineer/Senior Automation Test engineer

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.
• Validated and verified the data in the Data ingestion process.
• SFDC integration testing and validated the data.
• Rest-API Testing and validated the test results.
• 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 bydeveloping the automation scripts using Selenium WebDriver and JAVA.
• Implemented Page Objects framework and classesfrom scratch to represent web pages.
• DevelopedKeyword Driven and Data Driven frameworksto 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 testsusing Cucumberby 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.
• 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,Rally,Jenkins,Cucumber,BDD, Maven, Eclipse, IntelliJ IDEA,VisualForce,Force.com,Apex,SFDC, Lightining,SOQL,SOOL, SOAP,REST,JSON,WSDL,SOAPUI,POSTMAN.

Confidential

QA Lead/Salesforce-Test engineer/Senior Automation Test engineer

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.
• Executed the Hive,Hbase scripts and Pig scripts by using Azkaban Job scheduler.
• Validated and verified the data in the Data ingestion process.
• Executed HDFS commands and validated the data.
• 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 bydeveloping the automation scripts using Selenium WebDriver and JAVA.
• Implemented Page Objects framework and classesfrom scratch to represent web pages.
• DevelopedKeyword Driven and Data Driven frameworksto 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 testsusing Cucumberby 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.
• 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,Webservices.

Confidential

Senior ETL Test engineer

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: 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.

Confidential

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,Java,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

Senior QA Test engineer

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: HTML, XML, Ajax, CSS, JUNIT, Windows-10, Quality Center-ALM, Jira, Jenkins, Maven, XML, XML SPY, Oracle, SoapUI,WSDL,PHP,MYSql

Confidential

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, target, 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 Target 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

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, target, 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 Target 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

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 target 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 Target 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 target 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.