SUMMARY

• IT professional with 7 years of experience in Software Testing/Quality Assurance with experience in Unit, Integration, Backend and ETL techniques and automation tools
• Experience in projects ranging from support and maintenance to development and has been part of all phases of SDLC
• Clear understanding of Quality assurance role in all phases of Software Development Life Cycle (SDLC).
• Expertise in Validating the flat files, and loading them on different servers using Managed File Transfer, Kicking of Process Initiator.SH
• Expertise in Monitoring ETL batch jobs and Performing End to End testing for Data Extraction, transformation and Workload Scheduler to load records from source to target tables.
• Expertise in preparing test cases from use case documents.
• Hands on experience in web, DW and mainframe environments.
• Expert in writing test cases using the test scenarios and preparing test data.
• Worked extensively for preparing traceability matrix, to ensure that all the requirements are mapped with test cases and updated it regularly.
• Experienced with testing BI and Informatica applications.
• Experience in preparing test strategy for development project, Requirement Traceability Matrix, and Defect Analysis Reporting.
• Expertise in GUI Testing, functionality testing, Integration testing, Black box techniques, Regression testing, Security testing, User Acceptance testing (UAT), Smoke testing and System testing.
• Experience in performing Backend testing (Oracle and SQL Server databases and XMLs).
• Extensively involved in Defect Reporting and Defect Tracking process using Team Track, Test Director, Quality Centre (QC) and MS - Excel.
• Strong Knowledge on Automation testing using selenium Webdriver, Java, TestNG, Maven, Jenkins and GitHub.
• Strong Knowledge on Automation frameworks like Hybrid, Data driven and Page Object model with Page factory.
• Experience in creating user acceptance test cases and supporting User Acceptance Testing (UAT).
• Work across multiple cross-functional teams to execute full system, interface and end-to-end testing.
• Strong knowledge on Performance testing using LoadRunner and JMeter.

TECHNICAL SKILLS

Automation Tools: QTP, Load Runner, Quality Centre, Selenium, JMeter, JIRA, IBM AS400.

Language Skills: Java, C++, XML, HTML, JavaScript.

Packages: MS Office 2000, MS word 2000, MS Excel 2000, MS Access, MS SSIS.

Operating Systems: Windows, Linux/Unix, Mac.

Scripting Language: Shell, JavaScript, VBscript, and SQL.

Database: SQL Server, Oracle 11g MySQL, Teradata.

Browsers: Internet Explorer, Chrome, Mozilla Firefox, Safari.

PROFESSIONAL EXPERIENCE

Confidential, Denton, TX

Sr.QA Engineer

Responsibilities:

• Developing test plans and test cases for the new loyalty program.
• Created and executed test cases for testing Microsoft Dynamic CRM application used by Business systems group and Sally customer service group.
• Verified and validated newly created Accounts, Contacts and Cards from POS system are loaded into CRM application via Loyalty system and loaded finally into data warehouse according to business rules.
• Worked with Data Warehousing developers who extensively used SSIS, to design mapping to move data from source to target database using Stages to do the functionality.
• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Wrote complex SQL queries (Inner, Outer, Cross joins, Group by having, Triggers, Insert, Deletes and Truncates) for querying data against different databases for data verification on both source and destination databases.
• Used the SSMS to execute the jobs, validating and debugging its components, and monitoring the results.
• Performed Interface testing between Oracle Micros systems to MS CRM and ISeries IBM AS400 systems.
• Performed web services testing using SOAPUI.
• Created and executed test cases for testing EMV payment systems for POS.
• Created and executed test cases for Oracle Micros POS systems for Retail Stores covering major functionalities of POS like Pricing, Taxing, Offers, EMV and non EMV cards, Place orders, time keeping, check payments at POS and credit cards.
• Created and executed test cases for Points based loyalty systems for different systems like POS, CRM and Data warehouse.
• Performed End to End testing for application like POS, CRM and Data ware house.
• Performed Regression testing on the applications like POS, CRM and Data warehouse after every new build.
• Assisted the automation team in creating selenium web driver scripts using Java for some functionalities of sally beauty webpage.
• Negative testing for the undocumented requirements to verify the stability of the application.
• Defects identified in testing and other environments were communicated to the developers using Microsoft Test manager and Team foundation server.

Environment: Microsoft SSIS, Microsoft SSMS, Microsoft Dynamic CRM, Oracle Micros, ISeries IBM AS400, Microsoft Test manager (MTM), Selenium Web driver, JAVA, TestNG, Maven, Jenkins, GitHub, Microsoft Team foundation server (TFS), SOAPUI, Windows 7, MS Excel.

Confidential, Indianapolis, IN

Sr. QA Engineer

Responsibilities:

• Designing and developing test strategy, test plan, test cases and generating test reports and defect reports.
• Preparation of technical specifications and Source to Target Mappings for data migration.
• Created the test cases based on test strategy and test plans based on mapping documents for migrating data from SQL server to MySQL.
• Timely presenting Project Progress reports with various metrics like Schedule and Scope variances, Defect Analysis, Root Cause Analysis, RequirementtraceabilityMatrix (RTM).
• Wrote complex SQL queries (Inner, Outer, Cross joins, Group by having, Triggers, Insert, Deletes and Truncates) for querying data against different databases for data verification on both source and destination databases.
• Validated the records from source table are routed to target table in the destination database accurately (verified for duplicate records and invalid records).
• Designed and executed test cases based on the data migrator application 'Hydra' as per product requirements.
• Deploying and running the builds of migration application from Circle CI using Jenkins job both on stage and other environments.
• Verifying and validating data cleansing scripts generated to remove unwanted data.
• Understanding different components in Compass application from the business requirements.
• Performed Regression testing the applications that utilize the migrated data and also for schema changes in databases made for running the migrator application.
• Performed Negative testing for the scenarios covered to verify the stability of the application.
• Performed front end testing for validating the migrated data on the front end for the applications like mobile app and websites.
• Assisted the performance testing team for the issues related to data migrator application.
• Defects identified in testing and other environments were communicated to the developers using JIRA.
• Performed API testing using swagger tool.
• Involved in scrum planning, Test Design & Design/QA estimation and retro meetings.

Environment: JIRA, HYDRA (data migrator tool), Scala, .Net, SQL server, MySQL, MySQL Workbench, Jenkins, CircleCI, Swagger.

Confidential

QA Engineer

Responsibilities:

• Worked with Business Users and Developers to create complete test plan.
• Created and remodeled the test cases / scripts for Agile methodologies i.e. SCRUM for team to follow.
• Wrote Test Cases covering different test scenarios.
• Prepared RequirementtraceabilityMatrix (RTM), Project Progress Reports, Defect Analysis.
• Worked closely with software developers and take an active role in ensuring that the software components meet the highest quality standards.
• Extensively worked on Change Request / Enhancements; and Performed peer reviews to come up with the right test scenario coverage.
• Worked on Agile Methodology (Stand-up Meetings, Scrum Meetings, Update Time report).
• Preparation of technical specifications and source to target mappings.
• Used ALM for managing all the documents pertaining to the application.
• Created, executed tests, generated the test reports and created graphs using ALM.
• Migrated data from SQL Server to Oracle with SQL Server Integrated services (SSIS).
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Wrote test cases for ETL to compare source and target database systems.
• After runner intraday and end of day batch jobs, wrote complex SQL queries to validate the expected data (Inner, Outer, Cross joins, Group by having, Triggers, Inserts, Deletes and Truncates).
• Validated if the records from the file are routed to Target table in the database accurately (Verified for Duplicate records, Invalid Records etc.).
• Did Backend Testing using SQL Quires for various databases in both Oracle and SQL server.
• Performed GUI, Black Box Testing.
• Involved in both manual and automated testing using the automated tool selenium.
• Identified duplicate records in the staging area before data gets processed.
• Tested the source and target databases for conformance to specifications.
• Created UAT test cases and scenarios based on Use Cases and made sure those UAT test cases meets the business requirements.
• Conducted conditional testing of constraints based on the business rules.
• Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Selenium RC.
• Defects identified in testing environment were communicated to the developers using defect tracking tool HP ALM.
• Involved in creating weekly status reports and regularly participated in group meeting and walkthroughs.

Environment: HP ALM, ETL, Informatica, ORACLE - 10g,PL-SQL, Selenium RC, Unix, SQL Server 2012, SSIS, Java, JavaScript, C#.Net.

Confidential

QA Analyst

Responsibilities:

• Developed complex SQL queries mimicking the actual Informatica ETL mapping to test the ETL transformation rules and the data load into the target fact tables in different databases.
• Tuned test SQL to optimize the performance on a billion rows table.
• Responsible for testing the accuracy of the web analytics piece of the BI application.
• Developed test plans, test cases, test conditions, test designs, test templates and test reports.
• Extensively used SQL programming in backend and front end functions, procedure, packages to implement business rules and security.
• Responsible for writing complex SQL queries for querying data against different databases for data verification process.
• Involved in functional requirement analysis, effort estimation, identifying test conditions, creating test cases, reviewing test cases and executing test cases.
• Perform Back-End database testing on Oracle database. Test the data integrity of the application by writing SQL and PL/SQL code.
• Reporting on progress and risk to management, worked on defect management system.
• Recommend, Streamline and establish the testing processes.
• Extensively involved in database testing and checking the migrated data quality.
• Extensively done GUI testing.
• Extensively tested with SQL Query and stored procedures for data validation purposes.
• Extensively tested reports module which is Crystal Reports.
• Extensively working on regression testing, executed test cases.

Environment: Quality Centre, Oracle, SQL, PL/SQL, Crystal, BI, Shell, UNIX.