SUMMARY

• 10 years of diversified experience in field of IT with Software Quality Assurance (SQA), Analysis and Testing of Client/Server and Web based Applications
• Good experience in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Test Processes, and Test Methodologies
• Extensive testing skills includes develop and execution of Test plan, Test Scenarios Test Scripts, and participates in QA reviews and documenting QA activities
• Proficient in Requirements/User Stories/ Use Case Analysis, Test planning, Test Schedules, Test case preparation, Manual & Automated test execution, Performance/ Load Testing, Defect reporting and Defect tracking
• Excellent Functional knowledge on various domains like Mortgage, Insurance, Financial Services, Health Care, Telecom, Pharmacy, CRM, and Retail Applications
• Good experience in different type of tests like Functional test, Integration, End to End, System test, Regression test, UAT, GUI, Usability test, Back end test, Exploratory test, Black box, White box, Performance test, Security test, and Smoke testing for various Applications
• Good experience in coordinating with QA teams Confidential Offshore and Onsite
• Experienced in defect reporting and defect tracking using defect management tools HP Quality Center/ALM, Rally, Microsoft Test Manager (MTM), Test Director, JIRA, Rational Clear Quest, and Bugzilla
• Innovatively manage quality assurance in the form of Black Box Testing, Functional Testing, Integration Testing, Security testing, Cross Browser Testing and Regression testing of various Web based Applications
• Good experience in Backend testing includes writing SQL Queries on various databases like Oracle, SQL Server, SSMS, Toad, Teradata, MySQL, and T - SQL to check the data integrity
• Very Good in RDBMS concepts and experience in testing using SQL queries with joins, sub queries for database validations. Experience in working with a fast-paced Agile Environment, and involved in TDD, and ATDD processes
• Good experience in writing and executing manual and automated testing using Selenium, QTP, HP Quality Center (ALM), Rally, Microsoft Test Manager (MTM), Team Foundation Server (TFS), and Rational tools
• Good Experience in Web testing and Web Services testing on different Applications
• Good knowledge of Software Quality Assurance (SQA) methodologies like Agile, Waterfall and Scrum
• Experience in developing test plans and automating test cases following standard testing frameworks
• Good Experience in understanding of Data warehousing, data validations, data migration, data conversion, and ETL validations and good in using Unix commands for file operations
• Good Knowledge in testing and validating Claims information for Home & Auto Insurance claims, and Rx Claims processing
• Ability to support multiple projects under tight deadlines often with competing priorities and complexities and able to work independently and within team environment as well
• Ability to communicate effectively utilizing interpersonal skills, self-motivated, quick learner with strong analytical and problem solving skills

TECHNICAL SKILLS

Testing Tools: HP Quality Center/ALM, Rally, Microsoft Test Manager (MTM), QTP, Selenium, JIRA, TestNG, CucumberUFT, Jenkins, Coded UI, Postman Client, Win Runner, Rational Clear Quest, Test Director, Bugzilla, and Rational Test Manager

Languages: Visual Basic, VB.Net, Java, ASP, MS Visual Studio, TFS, Java, SQL, PL/SQL, MySQL, T-SQL

Web Technologies: HTML, XML, JSON, JDBC, SMTP, TCP/IP, IIS, SOA, Web services, SOAP UI, and

Scripting Languages: Testing Script Language (TSL) and VB Script, Java script, TSO, ISPF

RDBMS: SQL Server, PL/SQL, AQT, Oracle, Toad, Hadoop, SSMS, Teradata, DB2, and MS-Access

Process Methodologies: Agile (Scrum) methodology, and Waterfall

Others: Informatics Power Center (Repository Manager, Designer, Workflow Manager, Data Warehouse, Share Point, ETL, HIPPA, MS Visual Studio, Team Foundation Server (TFS), Rx Claims Process, MS Office (Word, Excel, Power Point, Excel Macros, and MS Visio)

Version Controls: Rational Clear Case, CVS and Visual Source Safe

Operating Systems: Windows, UNIX, and Mainframes

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr.QA Analyst

Responsibilities:

• Worked as Test Analyst for Mortgage Default Servicing projects and also as Scrum QA Analyst for sprints in Agile Development Process
• Attend the Story Grooming meetings which helps in getting clear understanding with Acceptance criteria from testing Prospective
• Interact with the Development team and Business Users as part of Agile Scrum Methodology
• Participates in daily Agile meetings and attend Sprint planning and Sprint review meetings
• Responsible for creation of test scripts and execution of test scripts and updating results in Rally
• Participates in Test Plan review, Test scripts review and provides feedback
• Participation in daily Scrum standup calls and updating tasks in Rally tool
• Prepared Test Scripts and Test data for various type of Mortgage loans
• Participates in daily defect meetings with developers and with Business to discuss the defects and get priority
• Defects and update the Issue log on regular basis
• As part of Web Services testing validated the API's responses which are in XML/JSON format
• Involved in system testing phase for Mortgage Default Servicing project
• Coordinated all QA activities and assisted with User Acceptance Testing (UAT)
• Involved in Web Services testing of CRDE related API’s and validating Request and Response of Web Services using SOAPUI
• Participates in test execution, system validation on Mortgage Premiums, Loan Amount, and Interest Rates
• Validate the CRDE API's response file comparing with Database by writing SQL queries
• Test the API's and provide Loan Evaluation ID's to LRM in order for LRM to validate the data fields
• Writing different types of SQL queries and performing data validation using SSMS
• Responsible for all assigned tasks and project related assignments and delivering the tasks on time

Environment: JAVA, SQL Server (SSMS), Rally, Soap UI, Web Services, XML, JSON, Postman Client, Selenium, TDD, TestNG, TFS, SharePoint, MS Project, MS Office, and Windows NT/XP

Confidential, Roseville, MN

Test Lead

Responsibilities:

• Analyze the business requirements, identify the requirement gaps and interact with Business Analysts, and get clarifications on requirements
• Design Test scenarios and Test scripts corresponding to Business Requirements
• Performed Integration, System test, End to End, Database Integrity, and coordinate with UAT
• Worked on Microsoft Test Manager (MTM) to store testing results, metrics, and implement Test plan document
• Created and executed test scripts for Functional testing and Regression testing
• Used SQL queries for extracting the required data related to testing, test dataset creation and verification
• I am the part of onsite team where my role is as a lead, handling the responsibilities to coordinate the offshore team and also directly interacts with client
• Participated in Sprint review meetings, Retrospective meetings, and daily Scrum meetings in Agile Process
• Performed Back end Integration testing to ensure data consistency on front end by writing and executing SQL Statements in SQL Server Management Studio (SSMS)
• Involved in SQA activities, Requirements walkthrough, Defect Report meetings during various phases of SDLC
• Participated in the QA Meetings, Bug Review Meetings, and Go/No-Go Meetings & responsible for updating and Verification of the Project Checklist during the Deployments/Releases
• Worked closely with technical team & Business Analysts for review functional requirements
• Involved in the projects from the requirement analysis phase till post production activities and entire Test Lifecycle
• Schedule and run the reports on Tableau Workbooks and validate reports data on database using SSMS
• Interact with Development team and with the real-time users to implement the entire Test Management process
• Involved in Production deployments, perform production validations & assist with production Implementations

Environment: .Net, SQL Server (SSMS), Microsoft Test Manager (MTM), Selenium, Test NG, Web driver, Tableau tool, MS Visual Studio, Team Foundation Server (TFS), SQL/PLSQL, SharePoint, MS Project, and Windows NT/XP

Confidential, Plymouth, MN

Test Lead

Responsibilities:

• Participated in BRD review meetings and interacted with business and involved in functional walkthroughs for each release of Data Release Governance project.
• Develop Test Plan, Test Scenarios and Test Scripts for Functional, Regression and End-to End test
• Responsible for Mapping requirements with developed Test cases, prepare Traceability matrix and participates in QA reviews with Business team for Test case prioritization
• Provide Test schedules and prepare Test Scripts and Test data and mentor offshore team members
• Tested Web Services and validated the API’s response which are in XML format
• Participated in daily Scrum meetings and attends for Sprint planning and Sprint review meetings
• Validated different types of API's in Postman Client tool and validate API’s responses
• Worked closely with dev team & business in order to meet Software Quality Assurance (SQA) process and procedure
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules
• Used SQL Queries for data validation while testing API response files
• Worked as a UAT liaison between QA team & business by using test plan to design & execute business driven test cases.
• Lead a team of offshore testers for all QA activities, reviewing and providing feedback on their work
• Performed Backend testing writing SQL queries to validate the reports and Check database Integrity
• Execute Test scripts and log the defects and assign severity and report defects & track logged defects
• Participates in daily defect meetings with developers and with BA and discuss the defects and get priority of defects and update the Issue log on regular basis
• Interact with the Development team and Business Users as part of Agile Scrum Methodology
• Schedule and run the reports, validate the Reports, and supported during Production Implementations

Environment: HP Quality Center /ALM, JAVA, J2EE, Rally, ETL, SOA, XML, JSON, SOAP UI, JSON, Web Services, API’sData Warehouse, Mainframes, and MS Visual Studio

Confidential, Eagan, MN

Sr.QA Analyst /ETL Tester

Responsibilities:

• Analyze Requirements and design test scenarios & test scripts corresponding to functional requirements
• Performed Integration, System test, Functional, Regression, Database Integrity, and coordinated with UAT
• Created test scripts and UAT test cases, coordinated with UAT team and project manager and performed UAT activities with end users. Involved in Unit testing of Business transformation rules, Error conditions, and mapping fields
• Experience in Data Warehousing testing within the environment of Oracle and SQL Server
• Validate Member data and Group data files that are processed in AS/400
• Used Mainframe extensively to validate the step codes and other claims information
• Validated various AS/400 screens, Menus and Options, provide System Integration and UAT Support
• Worked with scheduling and execution of various AS/400 batch jobs
• Testing ETL processes that use flat files as source and generate flat files using Unix commands
• Verified ETL jobs as per business rules using ETL design document
• Worked with various files on AS/400 (DBU utility), worked with CL/400 commands, and validate data on AS/400 DB2
• Worked with SQL, PL/SQL and functions to test the database integrity
• Conducted extensive manual testing on Windows, and Unix environments
• Validated the ETL Informatica mappings and validated transformation and involving business Logic
• Analyzing defects and Interact with developers and with SME’s/BA’s in prioritizing and fixing defects
• Log defects in Microsoft Test manager (MTM) and verify root cause & resolution of defect fixes for each build during test execution

Environment: Microsoft Test manager (MTM), Rx Claim Process, SQL, UNIX, SOA, XML, HTML, ETL, Data Warehouse, AS/400, Mainframes, DB2/400, AQT, and Beyond Compare tool

Confidential, Minneapolis, MN

QA Analyst/ Test Coordinator

Responsibilities:

• Analyze business requirements and developed Test Plan, Test Scripts, expected Test Results and Test Procedure from functional requirement for Auto Insurance and Home Mortgage Applications
• Interacted with the Business to clarify ambiguities and verified traceability of test conditions to test cases
• Interacted with business users like Loan Officers, Mortgage Consultants, Sales, Vendors and Business to analyze and test the business requirements
• Delegated work to the Offshore QA team and reviewed test case scenarios and test execution results
• Written Test Cases for ETL to compare Source and Target database systems
• Performed quality assurance checks and audits on completed Foreclosures, Defaults, and Support Operations
• Developed & tested Various ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Participated Defect Triage meeting sessions with BA's/ SME’s for the Defect Resolution
• Performed functionality, regression, compatibility, Web testing, End to End, Ad hoc testing for Nexsure enhancements
• Responsible to prepare and set up Test Data for each Test environment and execute Test scripts
• Written and executed SQL queries to extract the data from database for data verification testing
• Validate Reports and coordinate with reports BA’s in trouble shooting Issues causing Inaccurate data
• Entered numerous claims for testing purposes to ensure accurate and quality adjudication and implementation of business and operational requirements.
• Attend Defect meetings with developers and Business Analysts and discuss logged defects and get defect priority and follow up on open defects and update the status on regular basis in HP ALM Quality Center

Environment: HP Quality Center/ ALM, .Net, QTP, UFT, SQL Server Management Studio (SSMS), ETL, Data warehouse, Unix, Oracle, Toad, and Visual Studio

Confidential

Sr.QA Analyst/Test Coordinator

Responsibilities:

• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure
• Executing Test case for cross browser testing and working in a Fast-Paced Agile environment
• Develop Test Scripts and prepare Traceability matrix and prioritize test cases for each release
• Participated in daily Scrum meetings and attends for Sprint planning and Sprint review meetings
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules
• Performed Testing on Web Services and Server Components in J2EE Environment
• Performed Backend testing writing SQL queries to validate the reports and Check database Integrity
• Involved in Creating test cases and executing in Java and Mainframe environment
• Perform End to End test, Back end test, Functional test and Regression testing on DRG Application
• Worked with HP Quality Center/ALM for Test management and Defect management activities, and created separate Test suites for each test cycle in each release

Environment: HP Quality Center /ALM, JAVA, J2EE, Teradata, Rally, ETL, SOA, XML, JSON, SOAP UI, JSON, Mainframes, Data Warehouse, and MS Visual Studio

Confidential, Minneapolis, MN

QA Analyst/ ETL Tester

Responsibilities:

• Analyze business requirements and developed Test Plan, Test Scripts for Auto Insurance and Home Mortgage Applications
• Involved in system validations of Loan processing for Home equity, Mortgage, Personal, Business and Auto loans
• Participates in test execution for Loan Amount, Interest Rate, Mortgage Premiums, Billing, Account Management, Claims for Home and Auto Insurance
• Coordinated User Acceptance Testing (UAT) with end users
• Written Test Cases for ETL to compare Source and Target database systems
• Participated in Sprint review meetings and daily Scrum meetings in Agile Process
• Coordinated Offshore team on all QA activities Supported during Production and post production Implementations
• Responsible for reviewing Release Notes for each build and perform Smoke test, retest defects fixes and perform Regression test and update defect list
• Created UAT test cases in test plan and executed those tests from test lab in HP Quality Center/ALM
• Written and executed SQL queries to extract the data from database for data verification testing
• Worked on Unix environment and used Unix commands while working on File processing

Environment: HP Quality Center/ ALM, .Net, QTP, UFT, SQL Server Management Studio (SSMS), ETL, Data warehouse, Unix, Oracle, Toad, and Visual Studio

Confidential, Plymouth, MN

QA Analyst

Responsibilities:

• Responsible in reviewing assigned Functional Specifications, list out the questions and discuss with Business teams
• Performed validation and verification of Reports test results using Excel Macros
• Responsible for scheduling and to run Reports and validate data and testing in multiple languages and Currencies
• Participates in conducting Quality Assurance reviews and responsible for develop and execute Test plan, Test scenarios and Test scripts on SOA Applications. Evaluating the Reports that are developed in Actuate Reporting tool
• Performed Integration testing on PMC web Application. Developed test cases for verifying & validating Web based applications
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Involved in reproducing & debugging Issues, analyzing test reports & file appropriate defects in JIRA
• Performed Backend testing writing SQL queries to validate the reports and Check database Integrity
• Clarification/Issues tracking and reporting using JIRA as a defect tracking tool
• Managed Project requirements and tractability using Rational Test Manager
• Responsible for User Interface testing, web testing of PMC Web based application
• Serve as a test coordinator for all testing activities and make sure following QA process on a project

Environment: JAVA, J2EE, Teradata, SOA, JIRA, Visual studio, and Actuate Reporting tool

Confidential, MN

QA Analyst

Responsibilities:

• Developed System test plan and gather Test data and perform System testing an d Integration testing
• Testing the Interfaces and ensure that the data that is migrated and is populated in the correct fields, and testing the security of User Permissions. Performed Functional test, Integration test, Black box, and White box testing
• Involved in executing Automation scripts to support Regression and functional testing
• Developed SQL queries for Database testing. Developed test script for web based application developed in .Net frame work
• Performed validation and verification of test results and used Excel macros to verify SQL query results
• Used Rational Clear Quest for bug reporting and tracking

Environment: VB.Net, Oracle, QTP, Clear Case, Clear Quest, Toad, TFS, DB2, Scrum (Agile) methodology

Confidential, Duluth, GA

QA Tester

Responsibilities:

• Involved in System requirement analysis phase to ensure requirements adequately cover users prospective and all requirements are Testable. Written and executed SQL queries to extract the data from database for data verification testing
• Written Test Cases for ETL to compare Source and Target database systems
• All stories of the each sprint entered in Team Foundation Server (TFS) and created Tasks
• Responsible for preparing Test metrics & daily status and report to QA Lead
• Used Bugzilla to manage and execute test scripts, log defects and pull defect & test execution reports

Environment: Bugzilla, ETL, DWH, e-Commerce Applications, UNIX, Teradata, Rational Clear Quest, SQL Server, VB.Net

Confidential, Irvine, CA

QA Tester

Responsibilities:

• Performed Functional test, Integration test, Black box testing and participated in User Acceptance Test (UAT)
• Written SQL queries to extract the data from Oracle database for data verification and data validation
• Used Rational Clear Case Version Control for the project
• Developed test scripts and test data for various type of Mortgage loans
• Participated in creating Mainframe Test data and executing Mainframe batch testing
• Create test cases and conduct manual/automated test execution for Web-based, UNIX, SQL and CRM applications
• Involved in User Acceptance testing of CRM Application and End-to-End testing
• Validated Loan evaluation process and Mortgage premiums
• Managed Project requirements and tractability using Rational Test Manager
• Responsible for creating Defects in Clear Quest and track and close the Defects after fixes

Environment: Rational Clear Quest, Clear Case, Rational Test Manager, Mainframes Application, JAVA, JSP, XML, SOA, Unix, and Oracle

Confidential, Hartford, CT

QA Tester

Responsibilities:

• Prepared Test Plan, Test Scenarios and supporting the testing procedures
• Coordinated test planning and test execution effort for Functional, Regression, Integration, System, and End to End workflow testing with the QA Team. Verified and validated premiums of various Insurance Policies
• Coordinated Defect Management process during Test execution in Test Director
• Generated daily and weekly status reports to QA manager and attended weekly status meetings with team members, Business Analysts, and Technical team to discuss progress statuses, Issues and concerns
• Responsible for creating Defects in Clear Quest and track and close the defects after fixes
• Used Rational Clear Case Version Control for the project

Environment: Win Runner, Test Director, Java, Clear Quest, Rational Clear Case, Test manager, HTML, XML, SQL Server, Oracle, Excel, Toad, COBOL, JCL, DB2, MS Visual Studio, MS project, Live link (Workflow management tool)

Confidential, New Jersey

QA Tester

Responsibilities:

• Actively participated in System testing, Integration testing and coordinated UAT testing
• Prepared detailed Test cases by understanding Functional requirements
• Developed and executed test scripts for Regression testing
• Performed on-line GUI testing of multi-state Mainframe billing system utilizing billing and adjustment transactions for Confidential &T
• Involved in End-to-End testing, for CRM Application
• Managed Project requirements and tractability using Rational Test Manager
• Performed Backend testing on Oracle writing SQL queries to validate the reports and Check database Integrity
• Responsible for communicating the Issues, Status and discuss on concerns with QA Lead
• Responsible for creating Defects in Clear Quest and track and close the defects after fixes

Environment: Rational Clear Quest, Rational Clear Case, Test manager, Siebel Communication, XML, Oracle, Unix, JAVA, Mainframe, Web logic, Windows /NT/XP