SUMMARY:

• 5 years of experience in the area of Software testing (Manual and Automation) with the solid understanding of Test Planning, Test Design, Test Execution, Defect Reporting and Tracking.
• Expertise in understanding and analyzing Test Requirements, Tracking Changes and maintenance of Test Requirements.
• Has extensive domain knowledge in diversified fields of Banking, Mortgage Financial Services and Retail.
• Well acquainted with all phases of Software Development Life Cycle and Software Development Life Cycle. Strong experience in Automating Web Application Testing using Selenium Web Driver.
• Hands on experience in Java Programming, Selenium IDE, Selenium Web Driver.
• Well versed with handling elements in Selenium Web Driver.
• Writing Test cases using Element Locators, Web Driver methods, Java Object oriented programming features.
• Executing Selenium Test scripts and Reporting Defects.
• Experience in Data Driven Testing, Cross browser testing and parallel execution test.
• Hands on experience in test management and defect tracking tool HP ALM .
• Hands on experience with Microsoft Office Suite Word, Excel, and PowerPoint.
• Extensive Experience in testing on Enterprise wide applications with multiple databases like ORACLE, DB2, and SQL SERVER writing SQL Queries for backend testing.
• 2 + years of experience as QA Test Lead of functional testing team in Support, co - ordination, Task Allocation, Status Reporting and responsibility of the testing activities which includes review of test cases and test conditions.
• Extensive experience in Functional testing, SIT Testing, UAT Testing, Web based testing, Mainframe testing, Data warehouse testing.
• In depth experience and knowledge on various testing methodologies such as V-model, Waterfall model, Agile.
• Strong knowledge of various QA Phases that include Manual, Functional, System, User Interface & System Testing, End-to-end, Pilot Testing, Black box, UAT, Positive, Negative, Regression, Sanity, Adhoc and Business Process and Integration Testing.
• Involved in implementing QA Standards, Guidelines and Regulations in large project environments.
• Quick learner, self - starter with excellent analytical, communication and interpersonal skills, a strong team player with good work ethics.

TECHNICAL SKILLS:

Defect Management tools: HP ALM 11,JIRA,TFS

Database: Oracle,Vertica,DB2,Toad,Access

Programming languages: PL SQL,C, Java, HTML,COBOL,JCL

Automation Testing tools: Selenium IDE, Selenium WebDriver 2.5.3

Domain Knowledge: Banking and Financial Services, Retail

Other Tools: TSO/ISPF, File Aid, SPUFI, QMF, Informatica Power Center 9.5,Easytrieve, CICS, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

UAT Tester

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Involved in Mainframe Testing using COBOL, JCL, VSAM, DB2, and CICS, on MVS, OS/390 and Z/OS systems.
• Written test cases to test the application manually in Quality Center.
• Defects identified in testing environment where communicated to the developers using defect tracking tool HP ALM.
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Explaining UAT scope, criteria and entry/exit strategy to junior engineers
• Conducting research on IT requirements and business requirements in UAT areas.
• Reviewing SIT Test Plan to ensure sufficient testing plans
• Ensuring that the Pre-UAT activity is performed accurately and efficiently
• Developing UAT test process and monitoring SIT execution phases
• Identifying defects and perform root cause analysis by analyzing data quality issues
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Serve r

Confidential

QA Tester

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability .
• Performed data validation testing writing SQL queries on both Front end Testing and Back End Testing.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Involved in the Unit testing and debugging to check the data consistency.
• Scheduled and monitored jobs using Informatica Workflow Manager, Workflow Monitor
• Performed End-to-End system testing.
• Developed complex SQL queries for querying data against different databases and data verification process
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
• Have experience in testing reconcile (initial) and delta (daily) ETL loads.
• Involved in the Unit testing and debugging to check the data consistency.
• Experience in Informatica Workflow Manager to execute workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Logging data validation defects using HP ALM and tracking it to closure

Confidential

Offshore QA Test Lead

Responsibilities:

• Preparing the Automation test strategy and test plan.
• Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars.
• Preparing SQLs using QMF to query the DB2 database on mainframe.
• Writing high level scenarios, test cases and acceptance test cases for each sprint.
• Reviewing services acceptance test cases for each sprint.
• Involved in writing test cases with the help of Test Strategy Document.
• Created Automation Test cases using element locators and WebDriver methods.
• Extensively worked with Mainframe technologies COBOL, JCL, VSAM, DB2, and CICS, on MVS, OS/390 and Z/OS systems.
• Analyzing output test data using file aid, creating datasets to test, setting up JCL.
• Perform integration testing, system testing and user acceptance testing.
• Map requirements and test scenarios for Requirement Traceability matrix.
• Execution of testing in both SIT and UAT environments.
• Execution of Selenium Test Cases and Reporting defects.
• Provided Test results in each SPRINT.
• Conducting data driven testing, cross browser testing and parallel test execution.
• Continuously monitor the testing progress with team members and make sure to meet the given timeline.
• Reporting and Tracking of Bugs in the Bug tracking tool till closure.
• Work with the development team for defect fixes.
• Acting as the single point of contact in between Functional team and testing team.
• Keep track of the new requirements / enhancements/critical requirements/user comments of the Project.
• Involved in creation of Test data.
• Attending daily SCRUM meeting and SCRUM of SCRUM meetings for each sprint.
• Escalating impediments in SCRUM meetings for each sprint.
• Review test cases prepared by team members and guide the team whenever required.
• Prepare Regression test suite.
• Preparation of Test Summary Report.
• Conducting knowledge transfer session to new team members.