SUMMARY

• Over 13+ years of experience in Quality Assurance, Business Analysis, and Testing, worked through each and every phase of QA Life cycle, beginning with planning to the release of the product.
• I have implemented QA methodologies, practices and processes in all kinds of environments including Client/Server, Web, IBM Mainframes, and UNIX. Furthermore, my strong analytical, communication and interpersonal skills emphasize my experience and qualification in the pursuit of delivering a quality product on time.
• Extensive experience in Business Analysis, Quality Assurance and Business Acceptance Testing
• Good experience in gathering Requirements from End Users, Scope Documents and Business Specifications
• Highly experienced in Agile methodology and Waterfall methodology
• Good experience with working on Offshore - Onsite model and leading teams
• Possess an excellent understanding and working experience in Enterprise service testing
• Strong skills in performing System, Acceptance, Web Services Testing, Integration, Regression, Security, Front End and Back End Testing
• Expertise in mobile application testing for Android, Blackberry and Cloud applications
• Experience in developing Test Strategy, Test plan, Test cases, Use Cases, Test scripts and traceability matrices
• Experience in testing both REST and SOAP web services application
• Expertise in ETL/ Data warehouse backend testing including three years in Data Archiving and Test Data Management
• Good understanding of HP Load Runner for Load and Stability testing
• Strong Skills in performing automated testing for Web and GUI applications
• Expertise in Functional, Non Functional testing of web based applications, and Batch applications
• Expertise in use of HP tool for writing test cases, test execution, defect management, and defect tracking
• Excellent skills in Bug Reporting using HP Quality Center/ ALM
• Exposure to software development methodologies such as Waterfall, Scrum and Agile Methodology
• Excellent interpersonal skills and proven team player with problem solving and delivering product
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment

TECHNICAL SKILLS

Testing tools: HP Rational Tools, Clear Quest, Clear Case, Win Runner 7.6, Load Runner 8.0, Quick Test Professional/ UFT, SOAP UI PRO, Selenium

Scripting: TSL, VBScript, JavaScript, SQA Basic

Bug Reporting: Quality Center 10.0 / ALM, JIRA

Programming Languages: JAVA, Visual Basic, SQL, PL/SQL

MAINFRAME: JCL, CICS

Databases: Oracle 9i, DB2, SQL Server and MS Access

Web Technologies: J2EE, .NET and MQ Series

Operating Systems: HP Unix, Windows 2000Professional/NT/XP, and MSDOS

Front Ends: Visual Basic 6.0 and Developer2000

App Servers: Web Sphere, Web Logic

Network: FTP, HTTP, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Brea, CA

Sr. QA Analyst

Environment: .NET, PL/SQL, Oracle, Visual Studio 2013, Sales force, SOAPUI Pro, Quality Center/ ALM

Responsibilities:

• Reviewed the Business and functional requirement documents and identified test scenarios
• Working Mode - SCRUM and AGILE Process. Projects deliverables as per the each sprint schedule
• Reporting Daily progress and discuss during the sprint's Story Grooming, Demo and Retrospective meetings
• Tracking Product backlog items, defects
• Participated in Code reviews and walkthroughs
• Prepared test cases for each assigned task, completed peer review, loaded/executed test cases in QC/ALM, and managed defect life cycles
• Gathered business process requirements and utilize Salesforce functionality to automate and achieve those objectives
• Gather requirements for Test Data Management and Data Archival
• Involved in mentoring the team members
• Performed testing on web services using SOAP UI
• Validating the response against the database and expected result
• Analyzed application data using theSQLto identify the ETL processes
• Customized user Roles, Role hierarchies, Profiles and Sharing settings to ensure that the protected data is available only to the authorized users
• Validated workflows processes in Salesforce
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis
• Worked with data analysts to implementInformatica mappingsandworkflows,shell scriptsandstored proceduresto meet business requirements.
• Performing backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases.
• Wrote and modifiedSQL validation scripts, and writing scripts in SQL to validate the outputs.
• Involved in providing training sessions as an when required
• Extensively worked onMapping Variables, Mapping Parameters, Workflow Variables and Session Parametersto extract only the additional data added during that period.
• Implemented end to end Enterprise Data Management
• Executing the test cases at the project test suite level or individual level for the services
• Planning and managing functional and regression testing
• Planning and executing UAT with Business Users
• Defect Analysis using Quality Centre /ALM, Reporting and sharing with all the stakeholders
• Provided Knowledge transfer for new team members
• Closely interacted with product management and development teams to assure most effective project execution.

Confidential, Centennial, CO

QA Lead

Environment: .NET, SQL Server 2012, Microsoft Test Manager, Quality Center/ ALM, Team foundation Server, Visual Studio 2013, SOAPUI Pro, Selenium

Responsibilities:

• Reviewed the Business and functional requirement documents and identified test scenarios
• Performed requirements verification testing, functional and user acceptance testing (UAT), Risk Based testing
• Provided Knowledge Transfer sessions to the new team members
• Working Mode - SCRUM and AGILE Process. Projects deliverables as per the each sprint schedule
• Reporting Daily progress and discuss during the sprint's Story Grooming, Demo and Retrospective meetings
• Tracking Product backlog items, defects and queuing new build releases and deploying in QA using TFS
• Gather requirements for Test Data Management and Data Archival
• Extensively used QC/ ALM to write and executing the Test Cases
• Developing test cases, test procedures and test data from requirement document using Microsoft Test Manager
• Strong experience in Automating Web Application testing using Selenium WebDriver
• Performed testing on web services using SOAP UI
• Validating the response against the database and expected result
• Used SQL Server Management studio for creating and executing SQL queries for testing the conversions and ETL Process
• Wrote complex queries in SQL assistant to check the data from Source and Target
• Implemented end to end Enterprise Data Management
• Executing the test cases at the project test suite level or individual level for the services
• Planning and managing functional and regression testing
• Participated in Static walkthroughs, code reviews and defect reviews
• Provided training and mentoring to the new team members
• Closely interacted with product management and development teams to assure most effective project execution.

Confidential, Englewood, CO

QA Lead

Environment: Java, SQL Server 2008 R2, Visual Studio 2013, Coded UI, SOAPUI Pro, STARC, Octopus

Responsibilities:

• Working with Product Team to understand the business requirement and technical specification documents
• Working Mode - SCRUM and AGILE Process. Projects deliverables as per the each sprint schedule
• Reporting Daily progress and discuss during the sprint's Story Grooming, Demo and Retrospective meetings
• Expertise working with Requirements Traceability Matrix
• Web based and Cloud based applications testing in Agile
• Expertise with security testing of PMI application based on roles
• Developing test cases, test procedures and test data from requirement document using CodedUI
• Developed complex SQL queries for querying data against different data bases for data verification process
• Performed Smoke, System testing, Integration Testing, User acceptance testing, Database testing and Regression testing.
• Performed Testing on web services and updating test data based on the requirements using SOAPUI PRO
• Experienced in running and validating the batch jobs in Dashboard Job Scheduler
• Expertise in testing the IVR (Interactive Voice Response) application
• Reviewing change request documents, defect description and attendant meetings to document the required changes.
• Worked with the development team to create appropriate cloud solutions for client needs
• Involved in UAT testing, Prepared UAT test cases and testing estimates
• Updating status report daily basis and weekly basis by conducting meetings with QA team
• Closely interacted with product management and development teams to assure most effective project execution.

Confidential, Englewood, CO

Sr QA Analyst

Environment: Java, TOAD, WebLogic, SOAPUI, JMeter, HPALM, SSIS, Selenium and OBI

Responsibilities:

• Reporting Daily progress in Rally and also discuss during the sprint's Story Grooming, Demo and Retrospective meetings
• Lead the QA team by providing effective SDLC process and providing status to the management on the daily test coverage
• Gather requirements for Data Archival and Data Life Cycle Management
• Planning and managing functional and regression testing
• Drive quality assurance initiatives and process improvements and testing on premise and cloud applications
• Performed testing on web services using SOAP UI
• Used Selenium IDE for Open source web testing
• Preparing the test cases in the SOAP UI tool for all the identified test scenarios
• Performed comprehensive testing of Prepaid App on Mobile devices in android and iOS platforms
• Profound knowledge of writing security test scenarios and procedures
• Executing the test cases at the project test suite level or individual level for the services
• Validating the response against the database and expected result
• Preparation of Test Cases and performing Regression Testing for new builds
• Developed Test Plans, Test Scripts, executed Test Cases, and reported Defects using HP QC/ HP ALM
• Involved in conducting reviews of test documents with SM Teams
• Performed ETL testing using SSIS and ensures that all expected data is loaded
• Validating peaks, valleys of the network traffic and dashboards
• Validating Sessions with AD, clicks and play
• Monitoring the daily ETL process data
• Comparison of ETL loading times with peak production volume and smaller amount of date

Confidential, CO

Senior QA Analyst and QA Lead

Environment: .NET, DB2, Mainframe, SQL Server2005, 2008, TOAD for Oracle, Quality Center/ ALM, QTP/ UFT, HTML, SOAP UI, TFS, SSIS, Tealeaf

Responsibilities:

• Requirements Gathering and Bug Management using Quality Center
• Translate requirements into documents and executable test cases with a coverage of testing methodologies
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications
• Lead the QA team and providing status to the management on the daily test coverage
• Planning and managing functional and regression testing
• Performed testing on web services using SOAP UI
• Profound knowledge of writing security test scenarios and procedures using Tealeaf
• Executing the test cases at the project test suite level or individual level for the services
• Performed testing on Progressive native apps using different devices in different platforms (Android and iOS)
• Preparation of Test Cases and performing Regression Testing for new builds
• Developed Test Plans, Test Scripts, executed Test Cases, and reported Defects
• Involved in conducting reviews of test documents with SM Teams
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Comparison of ETL loading times with peak production volume and smaller amount of data
• Analyzing data transformation processing and understanding ETL workflows and monitoring production environment
• Extracted data from various sources like Oracle, flat files and DB2 server
• Worked on issues with migration of Data from development to QA-Test Environment
• Expertise with SQL & DB2 queries for backend testing and validating database, comparing the data
• Responsible for coordinating and executing UAT test cases with End Users during UAT
• Generating Matrices Reports and Charts for Defect Analysis using HP QC /ALM to analyze statistical nature of the defects
• Defect logging and defect tracking using HP - Quality Center
• Integration of QTP with the test management tools, responsible for maintaining automation infrastructure
• Coordinating sign off efforts and perform production checkout to move projects into production

Confidential, Cleveland, OH

Sr QA Analyst

Environment: Load Runner 8.1, Quality Center 9.2, ASP.net, XML, JavaScript, Windows XP/NT, and MS SQL Server 2000, Visual Studio.NET

Responsibilities:

• Reviewed the Business and functional requirement documents and identified test scenarios
• Authored Test Cases to include prerequisites, detailed directions and descriptions
• Performed requirements verification testing, functional and user acceptance testing (UAT), Risk Based testing
• Prepared the Traceability Matrix for mapping the Requirements with the Test Cases through Quality Center
• Interacted and worked with the development team to solve the problems encountered in the test scenario run
• Analyzed-Designed-Executed performance tests to meet App requirements in user perspective
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios
• Provided subset of Functional test cases to UAT test
• Extensively used SQL for data integrity testing at the backend
• Worked in close coordination with software designers and business analysts in performance and failure analysis of detected problems
• Participated in weekly status meetings to report any bugs, issues and risks

Confidential, DE

Sr QA Analyst

Environment: IBM-S/390, Mercury Quality Center, Quick Test Professional 9.2, Java, HTML, UNIX, JSP and SQL server

Responsibilities:

• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements
• Involved in writing Test Plan for the testing effort of the module
• Developed and executed Test Cases and Test Scripts using QTP and managed it using Quality Center
• Prepared Test Scenarios using SQL Queries for Backend Testing and
• Manually performed User Acceptance Testing (UAT)
• Prepared and planned shell scripts in UNIX using SQL commands for the data validation.
• Schedule reports through schedule Manager
• Conducted Security, Performance, and Regression testing during the various phases of the development
• Investigated software bugs and interacted with developers to resolve technical issues
• Identifying Test Cases for Regression Testing and conducting Regression testing when new builds were made
• Used Quality Center for Bug Tracking and Reporting

Confidential, Columbus, OH

QA Analyst

Environment: IBM-S/390, JCL, CICS, DB2, Test Director 7.6, QTP 8.2, and Java

Responsibilities:

• Analysis of the Applications
• Source Code Maintenance, Requirements and Bug Management Using Test Director
• Performed Functional, System and Regression testing using QTP
• Created test cases and test plans according to System specifications using Test Director
• Developed test processes, procedures and practices for testing
• Wrote Test Scripts, executed Test Cases, and reported Defects
• Wrote SQL to validate or retrieve data and tested batch programs
• Analyzing the results and preparing the documentation
• Responsible for coordinating with End Users towards User Acceptance testing (UAT)
• Assist in the defect resolution process, following up with App Dev groups on the defect closures

Confidential, Bloomington, IL

Test Analyst

Environment: TSO/ISPF, COBOL, JCL, XML Test Tool, Test Director, Java, J2EE, HTML

Responsibilities:

• Preparation of Requirement specifications, detailed test plans and Status of work
• Responsible for identification of test data requirements
• Wrote Test Scripts, executed Test Cases, and reported Defects
• Identifying, Unloading and Loading Test data from Production to Test regions
• Set up Customers with IEFT, ACH, AT products & verify failed jobs against XML logs
• Executed Test scripts for IEFT, AT (A/C Transfer), ACH (Automated Clearing House)
• Performed User Acceptance Testing (UAT)
• Preparation of Production verification Test plan
• Assist team in defect resolution process; follow up with App Dev teams for defect closure