Qa Analyst/ Tester Resume
MN
SUMMARY
- Over 7+ Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Software Testing.
- Excellent Functional knowledge on various domains like Insurance, Payroll management, Finance/Banking, Telecommunications, Education.
- Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum, RAD, TDD.
- Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
- Well versed with writing detailed test cases for functional & non functional requirements.
- Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
- Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
- Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
- Expertise in use of Quality Center & Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
- Experience in developing, trouble shooting and customizing Manual as well as Automation scripts using Quick Test Professional.
- Experience with version control, configuration management and change control procedures using tools such as Rational ClearCase.
- Extensive experience testing using automation Tool like QTP and QC.
- Familiarity with Programming & Scripting languages.
- Good working knowledge of major Operating Systems and tested applications on windows 98/NT/2000/XP, LINUX & UNIX environments.
- Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
- An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects.
- Good communication & interpersonal skills & self-motivated & quick learning skills.
TECHNICAL SKILLS
Testing tools: Quick Test Pro, WinRunner, Load Runner
Defect Tracking: Test Director/ Quality Center
Databases: SQL Server 2008/2005, Oracle 11g. 10g, 9i, MySQL, Access, DB2 UDB, MS Access.
Data Warehouse & ETL Tools: Informatica (PowerMart4.7.2/5.1, PowerCenter 9.1/ 8.6/ 8.1, PowerPlug and PowerConnect), Oracle Designer 10g, 9i, 6i/2000, Business Objects (5.0.3, 4.1.4), Cognos Power Play 7.5/ 7.1, Cognos Impromptu 7.4.4/ 7.1, Crystal Reports 14 & 10, Erwin 8, 7.2, 4.1.
Configuration Management: Rational ClearCase
Tools: / Utilities: Visio, Erwin 8/ 7.2, Business Objects, SQL*Loader, SQL Trace
Scripting languages: VB Script, HTML, XML, Java script
Application environments: C#, .NET Framework, ASP.NET, EDI, Crystal, .NET Web Services, SSIS/ SSRS/ SSAS, SOA, CSS, Java
MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project
Methodologies: Waterfall, Agile, RUP, Scrum, RAD, UML.
Operating Systems/ Products: UNIX, LINUX, Windows - 7, Vista, XP, NT, 2003, 2000, 98
PROFESSIONAL EXPERIENCE
Confidential, MN
QA Analyst/ Tester
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 Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
- Executed automated regression testing which contains the risks associated with agile methodology.
- Tested and used extensively Agile Data Load Instructions System Engineering Report.
- The steps required to facilitate the loading of electronic documentation into the Agile PDM system for future data migrations.
- Executed and managed test cases and reported bugs in Quality Center.
- Created the UAT test environment consisting of UAT application, UAT database tables, UAT files etc.
- Carried out different types of UAT like Operational Acceptance Testing, Contract and regulation Testing.
- Involved in writing Automation Scripts (in QTP) for Banking and Insurance applications.
- Automated the Manual Test Cases into QTP Automation Scripts for Functional, Integration, System Test Cases
- Used Agile testing methodology for achieving deadlines in UAT.
- Developed automated Test scripts using QTP to perform Functional and Regression testing.
- Used Toad and SQL Plus for testing execution
- Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
- Validated data in between source and target after running Mappings by the Informatica developer team.
- Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
- Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
- Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
- Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
- Hands on work experience working with off site team model; coordinate my own efforts with team members in the off- site team..
- Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
Environment: Windows - 7, Vista, XP, 2003, 98, UNIX, UBUNTU, Unix, Oracle 10g, SQL Server 2008, Java, PL/SQL, Visual Basic 6.0, Java Script, Crystal, SSIS/ SSRS, QTP 9.5, WinRunner, XML, HTML, QC 9.2, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.
Confidential, San Antonio, TX
QA/Software Tester
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 Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing(UAT) and Data validation Testing.
- Used Agile testing methodology for achieving deadlines in UAT.
- Developed automated Test scripts using QTP to perform Functional and Regression testing.
- Executed and managed test cases and reported bugs in Quality Center.
- Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
- Responsible for validation of Target data in Data Warehouse and Data Marts.
- Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
- Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
- Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
Environment: Windows NT/XP, Unix, Oracle 10g, TOAD, Java, JSP, PL/SQL, Visual Basic 6.0, Informatica, QTP 9.5, QC 9.2
Confidential, Houston, TX
QA/Software Tester
Responsibilities:
- Coordinated all QA activities and enhancements using Agile Methodology.
- Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the specification issues.
- Created test cases and executed test scripts using Test Director.
- Involved in performing various levels of testing like Unit Testing, System testing, Integration testing and Regression testing.
- Performed Manual Testing of the application as well as identified the critical test scripts to be automated.
- Supported Performance tester with the Performance and Load testing using Load Runner.
- Created scenario to check the response time using Load Runner.
- Performed Data driven testing using multiple test data inputs with QTP and spreadsheets.
- Used Test Director to track and manage bug life cycle.
- Conducted various management activities by analyzing and verifying test results, providing status reports.
- Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
- Assisted Business team with planning, coordinate and execution of User Acceptance Testing.
ENVIRONMENT: Windows NT/2000, Oracle 10g, SQL / PL SQL, JAVA, Test Director 8.0, QTP 8.2, Load Runner 8.0
Confidential
QA/Software Tester
Responsibilities:
- Responsible for reviewing Requirement Specifications and Design Documents.
- Involved in Test Case Design with respect to Test Plan.
- Executed Positive and Negative Test cases.
- Initially performed White box testing with a limited number of test cases to the internal workings of software under test and in the remaining part takes Black Box approach in applying input and just observing outputs.
- Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
- Used Joins like Inner join, Outer joins while testing from multiple tables.
- Experienced to Functional, Integration, Smoke and Sanity testing.
- Involved in Test Execution and Bug Reporting using Test Director.
- Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
- Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
- Executed test cases through Iterative testing for testing the incremental functionality.
- Defects were tracked, reviewed, analyzed compared using Quality Center.
- Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
- Involved in Test Reporting on daily/ weekly basis through company prescribed format.
ENVIRONMENT: Windows NT/2003, SQL Server, C, JAVA, Visual Basic, Win Runner 7.5, Test Director7.0
Confidential
QA/Software Tester
Responsibilities:
- Responsible for reviewing Requirement Specifications and Design Documents.
- Involved in Test Case Design with respect to Test Plan.
- Performed GUI, Functional, Regression and compatibility Testing.
- Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.
- Involved in Test Reporting on daily/ weekly basis through company prescribed format.
- Responsible to resolve exceptions in UAT in a very expeditious way and re-UAT to ensure accurate and timely delivery.
- Ensured that UAT results are signed off by the right people in user community; worked with several different levels of users in UAT such as floor agents to the VP level.
Environment: Windows NT/2003, SQL Server, C, JAVA, Visual Basic, Win Runner 7.5, Test Director 7.
