Qa Analyst/ Tester Resume
NJ
SUMMARY
- Over 7 years of experience in Information Technology Industry with emphasis on Quality Assurance & Software Testing in Client/server and web based Applications with Manual Testing, Quick Test Professional (QTP) and Load Runner.
- Involved in development of Test Process, developed automation testing requirements, prepared test scripts, running tests, collecting test results.
- Experience In testing Stand Alone, Web Based Applications.
- Experienced in test management and defect tracking tool Quality center.
- Excellent knowledge of various phases of Software Development Life Cycle (SDLC) with emphasis on the Testing and Requirements gathering phases.
- 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, Automated & Bug tracking tools.
- Experienced in Agile testing process.
- Excellent Functional knowledge on various domains like Finance, Banking, Equities, Fixed Income,
- Experienced in Quality Assurance methodologies like Waterfall, V - Model, Agile, Scrum, Spiral etc.
- Perfect understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Excellent skill in creating SQL Objects like Tables, Stored Procedures, Views, Indexes, Triggers, and user defined data types and functions.
- Well versed with writing detailed test cases for functional & non functional requirements.
- Expertise in use of Quality Center (QC) for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
- Excellent Knowledge in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & 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.
- 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.
- Extensive data validation in batch files, reports and databases; used SQL to query database extensively for data validation; expert in SQL for sub-queries, nested queries and for complex data enquiries.
- Familiar with Rally Agile planning tool which was used to integrate Project management with requirements management, test management and defect management.
- Experience in developing, trouble shooting and customizing Manual testing and understanding the processes.
- Involved as part of automation team using Selenium 0.6 and developed test scripts.
- 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
Functional & Performance Testing tools: Quick Test Professional (QTP), Win Runner, Load Runner, Test Quest
Defect Tracking: Test Director/ Quality Center, Mantis
Databases: SQL Server, Oracle, My SQL, Access, DB2
Configuration Management: Rational Clear Case
Scripting languages: Java script, VB Script, HTML, XML, UNIX Shell/ Cron,C,C++
Application environments: C#, .NET Framework, AJAX, ASP.NET, PDF, Crystal, .NET Web Services, SSIS/ SSRS/ SSAS, SOA, CSS, Java, J2EE
MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project
Methodologies: Waterfall, V-Model, Agile, RUP, Scrum, RAD, UML, TDD.
Operating Systems/ Products: Windows - 7, Vista, XP, NT, 2003, 2000, 98, UNIX, UBUNTU, LINUX, IBM MF, AS400, Touch Point
PROFESSIONAL EXPERIENCE
Confidential, NJ
QA Analyst/ Tester
Responsibilities:
- Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
- Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data
- Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
- Automated the Manual Test Cases into QTP Automation Scripts for Functional, Integration, System Test Cases.
- Performed functional, regression, stress, performance and interoperability testing using Test Quest Pro.
- Experience in Integrating into Microsoft Visual Studio other third-party Integrated Development Environments for fast, extensible and flexible test creation that accelerates time to market using Test Quest Pro
- Designed and developed user defined functions of QTP with well versed VB scripting.
- Involved as a representative from the QA team in creating Sprint/ iteration (of Scrum/ Agile Process) with closely defined and agreed output.
- Executed testing of the applications using Agile’s Test Driven Design (TTD) technique.
- 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 project planning, coordination and implemented QA methodologies.
- Responsible for preparing test strategy, test cases, scenarios.
- Modified test cases against upgrades in the builds for regression test purposes.
- Performed test for functionality, security, GUI, system and backend.
- Performed extensive Regression testing for subsequent versions of the application.
- Performed manual and automated testing including functional, load and stress testing.
- Extensively used Image, Database and GUI checkpoints through QTP.
- Reported bugs, sent email notifications to the developers using the Test Director
- Maintained detailed logs of test activities in Mercury Test Director.
- Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
- Helped to create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
- Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
- Used Quality Center for Integration into Microsoft Visual Studio Team System for QA /Developer collaboration for accurate defect management.
- Prepared Test Summary Report.
Environment: QTP 10.0, Load Runner 9.1, HP Quality Center 10.0, .Net, SQL Server 2005, SSIS/ SSRS (Data Warehousing tools), Informatica, MySQL, Microsoft Windows, UNIX, Documentation Tools: MS Office - MS Word, Excel, PowerPoint, MS Project, Visio, .Net Framework, C#, Specflow, Visual Studio, End to End Testing, Integration Testing. Test Quest
Confidential, Charlotte, NC
QA Analyst
Responsibilities:
- Attended several walkthrough meeting with the Business Analysts, Project Manager and developers and provided feed back accordingly.
- Performed tests based on Agile Environment to increase revenue of Amica.
- Analyzed the business requirements divided the test features among the members of the team.
- Involved in writing Test Plan. And developed in Traceability Matrix. Analyzed system requirements and developed detailed Test plan, Test scenario, Test cases and Test scripts for testing the Application under Test (AUT).
- Set up, execution and maintenance of the testing environment platforms to ensure the Quality for Confidential ’s Valuable customers.
- Performed Data Driven testing in QTP and checking the behavior of the application and analyzed the results.
- Performed GUI, Smoke, Sanity, Regression, System and Backend testing.
- Responsible for performing Functional testing of the project.
- Participated in the team to performed User Acceptance Testing.
- Interacted with developers and users to resolve major bugs.
- Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
- Inserted check points to check the consistencies of the links in the webpage.
- Involved in Analytical Services (SSAS) delivers both OLAP (Online Analytical Processing) and Data Mining functionality for BI applications.
- Developed various T-SQL stored procedures functions for the web based application.
- Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
- Extensively used the built-in services for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) using the SQL Server Business Intelligence Studio Tool.
- Performed ETL testing to validate data is transformed correctly from OLTP to data ware house.
- Performed that all expected data is loaded on destination.
- Performed that all data is transformed correctly according to design spec.
- Validated correct process of ETL.
- Successfully designed, developed and implemented a complete regression testing for the entire system.
- Database testing was done to see whether the correct data is being retrieved.
- Created, Updated and maintained Test Scripts for different builds and releases
Environment: QTP 9.0, Quality Center 8.2, Web logic Server, MS SQL Server, VSS, Oracle database, MS Access, UNIX, Load Runner.
Confidential, Bellevue, Washington
QA/Software Tester
Responsibilities:
- Analyzed the applications to gather the business requirements.
- Prepared Test Plan that provides a detailed list of conditions under which the system will be tested using Test Director.
- Extensively involved in the Manual Testing of the applications.
- Conducted Unit Testing, Integration Testing and organize User Acceptance Testing (UAT).
- Got involved in Regression testing after bugs been fixed.
- Actively participated in various meetings like defect resolution meeting, QA status, Knowledge transfer meeting.
- Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
- Worked on writing and executing unit test cases using Visual Studio.
- Debugged code using Visual Studio debugger.
- Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
- Report and review the defects in Mercury Quality Center & Jira Defect tracking systems.
- Attended several walkthrough meeting with Business analysts, Project Manager and Developers and provided feedback accordingly.
- Wrote and maintained test automation using Visual Studio 2008 Team System as well as developed quality assurance standards for the development team.
- Analyzed test cases for automation and used Quick Test Professional (QTP) to automate manual test scripts for Regression and Functional testing.
- Writingmanualtest cases.
- Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
- TestingMethodologies Involved inmanualtestingthat includes functionaltesting,
- Involved in designing process/ methodology to identify the opportune areas for automation.
- Responsible for Quality Assurance of validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatics Power Center.
- Experienced in preparation of automated test cases with in Data Driven Automation framework.
- Extensive experience in executing Automation Test tasks - automation requirements, automation test scripts, running tests, monitoring/ analyzing results.
- Administered Quality Center partly by creating the user groups and assigning privileges to Users.
- 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 offsite team model; coordinate my own efforts with team members in the off- site team.
- Hands on experience in collecting several metrics and preparation of defect reports.
- Conducted Regression testing using QTP after the bugs have been fixed by the development team.
Environment: Windows NT / 2003, Oracle 9i, SQL Server, HTML, XML, Web Logic, Test Director 8.0
Confidential
QA Tester
Responsibilities:
- Involved in functional testing, regression testing, system testing.
- Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
- Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
- Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
- Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures
- 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.
- Documented test hierarchy, test scenario, test case based on the SRS and BRD.
- Documented the test data such as customized, historical and the Production data.
- Executed the test cases for manual testing of the UAT.
- Performed both Positive and Negative testing.
- During the testing the Actual results are updated to the test steps
- At the end of the execution test results report delivered.
- Test Director was used to create a Repository for storing the test plan, test subjects, test strategy, test steps, test scripts.
Confidential
QA Tester
Responsibilities:
- Launch of new web site and involved with the look and feel testing of all the web pages, Top Side, Bottom navigation, category pages, family pages, checkout page. Have also performed extensive Regression testing with each modification.
- Provided inputs from QA standpoint to the Design/Development teams and Stakeholders.
- Prepared Test plan, Test cases for the Module, Integration and System testing phases.
- Involved in Requirement gathering phase and performed Usability to verify “friendliness” of application.
- Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
- Defect tracking and Status reporting using Quality Center 10.0 defect tracking tool.
- Tested Data Integrity by executing SQL queries against Central databases.
- In-charge of Usability testing on the product and making appropriate recommendations
- Validated the CRM functions in the product - managing customer information, cross-channel customer information access,customer history, preferences and profiling.
- Performed Functional testing for each module.
- Involved in Unit testing at developer side and than performed Integration, System and Regression testing.
- Prepared parts of the User Manual, reviewing with the team and releasing the final document.
- Performed Database testing to check the data integrity.
- Prepared the Release notes(for every release/version) by consolidating current product status
- Involved in setting up the various Review Processes for the QA team
- Developed several T-SQL stored procedures functions for the web based application.
- Report Enhancement: Tender summery report and Tender Detail report new field added - BILLING CITY ADDRESS.
- Created invalid request to test Error handling response.
- Participated in User Acceptance testing (UAT) at the client site.
Environment: Windows XP/NT/2003, Oracle 9i, SQL Server 2000, JAVA, Visual Basic, Quick Test Professional 8.2, Quality Center 9.0