SUMMARY

• Over 7 years of IT experience in Software Quality Assurance and Testing on Windows Platform using HP Tools as a Manual, Functional & Automation Test Analyst. A unique blend of business analysis and quality assurance skills.
• Excellent analytical skills, detail oriented and superb in oral and written communication. Customer focused, self - motivated and driven leader capable of successfully orchestrating complex solution development with cross-functional and distributed teams
• Experience in testing various applications such as Web based/Client Server/Standalone applications and Infrastructure testing in various domains- Retail, E-Commerce and Telecom
• Extensively used tools: Quick Test Pro (QTP), HP ALM,JIRA, Quality Center, Bugzilla, Share point server (SPS) and also used various visually impaired tools e.g. JAWS, Dragon and Zoom Text.
• Experienced in developing and maintaining Requirements Traceability Matrix (RTM) to make sure customer requirements are captured successfully using HP ALM/HP Quality Center and Test Director.
• Experienced in developing and executing manual test cases and reported defects using HP ALM/HP Quality Center
• Experienced in Test Execution and Defect Reporting using ALM/Quality Center/BugZilla.
• Worked in Testing Center of Excellence (TCoE) model for 3 years and has got exposure to various projects right from the analysis phase
• Worked closely with cross-functional teams to thoroughlytestrequirements and functionality
• Participated extensively in GUItesting, UserAcceptancetesting, Functional testing, Integrationtesting, System testingand Regressiontesting
• Thorough understanding of Software Development Life Cycle (SDLC). Waterfall Model, Spiral Model, Quality Assurance Life Cycle (QALC)
• Worked in the QA Life cycle, which includes Design, Development, and Implementation of the entire QA process and documentation of Test Plans, Test Cases, Test Procedures and Test Script for Manual & Bug tracking tools
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control and identifying the Test Requirements based on User Requirements and Design Specifications
• Expertise in testing applications on both Windows and Linux platforms
• Involved in performing various levels of testing like Unit Testing, System testing, Integration testing and Regression testing
• Extensivedata validationin batch files, reports and databases; used SQL to query database extensively fordata validation; expert in SQL for sub-queries, nested queries and for complex data inquiries
• Experience in backend testing using SQL Server, Oracle and good knowledge in PL/SQL
• Hands on experience on BMC tools in managing DB2 database, Change Management and Service Request
• Proficient in Front end (Functional & GUI Testing), Black Box Testing, System Integration Testing (SIT), Regression Testing, and User Acceptance Testing (UAT)
• Experience in writing SQL Queries for back-end Testing
• Expertise in Traceability Matrix preparation and Defect Prevention Analysis activities.
• Good programming, scripting and debugging skills.
• Skilled at working independently, multi-tasking and delegating responsibilities.

TECHNICAL SKILLS

Languages/Specifications: COBOL, REXX, CICS, JAVA, HTML, CSS, XML

Tools: QC 11.0, SOAP UI, BMC Remedy tools, IBM DB2 Command Editor, Teradata SQL Assistant, TOAD, CA7, Control-M, MFT, IBM Data Studio, VersionOne, JAWS, Dragon and Zoom Text

Bug Tracking Tools: HP Quality Center, VersionOne, HP ALM, JIRA, Bugzilla, TFS

Web/Application Servers: WebLogic 11g/10g/9.x, WebSphere

Databases: Oracle 11g, MS SQL, SQL, MS Access, DB2, TeraData, ETL

Methodologies: Waterfall, Agile, Scrum, Rally, Sanity, Smoke Testing.

Operating Systems: Windows - 7/Vista/XP/2000/98, UNIX, Linux, Mainframes Z OS

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Agile QA Tester

Responsibilities:

• Comprehensive knowledge of agile software development cycle, white box testing, and web based application testing
• In-depth knowledge of software testing methodologies, functional, and regression testing
• Responsible for software components testing by coordinating with product engineers
• Responsible for test validations, developing testing plans, and estimating project resource
• Performed defect identification, writing test procedures, and reporting metrics

Environment: Windows 7, MS Office Tools, SQL Developer, VersionOne

Confidential, Minneapolis, MN

QA Test Lead

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements. Conducted Unit, System, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing for new Data Warehousing/ Reporting solution.
• Executed and managed test cases and reported bugs in Quality Center (QC), test management suites for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Execute the Mainframe batch jobs to unload data from DB2 and manipulate the data.
• Execute the MFT jobs to transfer the files to Vendor location and verify the files.
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into target database.
• Validated data in between source and target after running mappings by the developer team.
• Observed all data flow in the data warehouse system and verified details
• Ensured the existing data structures had a smooth migration to the new database
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation in the new data warehouse environment.
• Wrote SQL queries for validating constraints, indexes.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: HP Quality Center 11, Windows 7, MS Office Tools, Mainframes, MFT, JCL, COBOL, DB2, Oracle DB & CA tools, ADW, EDW, ETL, Teradata SQL Assistant

Confidential, Minneapolis, MN

QA Test Lead

Responsibilities:

• Performed manual functional testing for two major releases.
• QA Lead for 5 offshore manual testers and 2 QA Analysts at onshore
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Performed UI and FunctionalTestingthrough Web interfaces.
• Observed all data flow in the data warehouse system and verified details
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation in the new data warehouse environment.
• Wrote SQL queries for validating constraints, indexes.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Used Agile testing methodology for achieving deadlines in UAT
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Importing requirements, create test cases, validate requirements with test cases and generate reports using Quality Center.
• Worked closely with developers, SAs and DBAs to perform root cause analysis
• Hands on experience in collecting several test metrics and come up with corrective measure to be presented to senior management.
• Involved in the sunset & implementation plans for the legacy applications.

Environment: HP Quality Center 11, Windows XP, MS Office Tools, Mainframes DB2, Oracle DB & CA tools, Soap UI, TOAD, Online Screens

Confidential

QA Analyst

Responsibilities:

• Involved in identification of test scenarios and test cases for different types of testing like functional, system, integration and regression testing as per the requirements of the site.
• Worked on tuning the SQL database queries.
• Performed Backend Testing to validate the data using SQL queries
• Data Integrity testing on an Oracle Database to validate and test data using TOAD
• Prepared Test cases, procedures, Bug Tracking, Logging and reporting bugs using QC
• Responsible for entering, Tracking bugs in Quality Center 9.2 to resolve bugs
• Used Quality Center for maintaining requirements and maintained the Traceability Matrix between the requirements and Test Cases
• Responsible to designUAT scenariosand performed User AcceptanceTesting(UAT).
• Performed UI and FunctionalTestingthrough Web interfaces.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team
• Used fix knowledge environment with lead team
• Responsible for analyzing the system specifications, business requirements for full understanding of the business
• Observed all data flow in the data warehouse system and verified details
• Ensured the existing data structures had a smooth migration to the new database
• Extensively interacted with developers to analyze and resolve the issues that were encountered while testing the application.

Environment: Windows - Vista, XP, UNIX, Oracle 10g, 11i, SQL, XML, HTML, QC 9.2, HP Quality Center 9.2, MS Office Tools, Mainframes DB2, COBOL, JCL, VSAM, CICS, REXX, CTM, Xpeditor, Endeavor

Confidential

QA Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Performed Positive & Negative Testing.
• Provided inputs from QA standpoint to the Design/Development teams and Stakeholder.
• Prepared Test plan, Test cases for the Module, Integration and System testing phases.
• Executed ~2000 mainframe batch jobs through CTM scheduler.
• Include testing and analyzing the system testing, functionality testing, Integration testing.
• Involved in DB2 data testing using BMC DBA tool.
• Attended several walk through meeting with the Business Analysts, Project Manager and developers and provided feedback accordingly.
• Front office orders were built as web services and were tested using SOAP UI
• Preparation of Functional Test Plan and writing actual Test Cases Running the test scripts using Test Director.
• Manually written the SQL queries to test the back end database.
• Created Test Plans which describes the features and functions to be tested.
• Any identified production bugs are tracked using BMC Remedy Service Request and Change Management tools.
• Helped the Lead create Traceability Matrix to ensure comprehensive test coverage of requirements, identify all test conditions and test data needs.
• Created, Updated and maintained Test Scripts for different builds and releases.

Environment: HP Quality Center 9.2, HP Load runner, Windows XP, MS Office Tools, Mainframes DB2, COBOL, JCL, VSAM, CICS, REXX, CTM, Xpeditor, Endeavor, BMC Remedy tools