Automation Tester Resume
Philadelphia, PA
SUMMARY:
- Over Seven years of IT experience in Software Quality Assurance and Testing Manually on Windows Platform using HP Tools ( QC) and Automation using Mercury Interactive Tools (QTP, Test Director) as a Quality Analyst / Tester.
- Over 4 years of experience with automation expertise and in depth hands - on experience with several versions of QTP.
- Expertise in developing and applying customized Automation Testing Strategies/ Automation Methodology and Automation Test Process.
- Evaluate different frameworks in QTP and define the right one for testing based on testing needs.
- Conducted System Testing/ Functional/ Integration and Regression testing using QTP.
- Excellent in converting existing Manual Test Cases into Automation Scripts in QTP environment.
- Expertise in working with Checkpoints of QTP.
- Have worked with Automation Framework (of QTP) like Keyword Driven and Modular Driver Framework.
- 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.
- Thorough understanding of Software Development Life Cycle (SDLC). Waterfall Model, Spiral Model, Quality Assurance Life Cycle (QALC)
- Experience in testing in the domains such as Banking, Finance and Insurance.
- 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.
- Experience in backend testing using SQL Server, Oracle, MS Access and good knowledge in SQL, PL/SQL.
- Expertise in converting Use cases to Test Cases.
- Proficient in Front end (Functional & GUI Testing), Black Box Testing, System Integration Testing (SIT), Regression Testing, and User AcceptanceTesting (UAT)
- Experience in writing SQL Queries for back-end Testing
- Expertise in Traceability Matrix preparation and Defect Prevention Analysis activities.
- Worked closely with development team, support team and customers. Coordinating with the onsite team and updating the status.
- 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
- Skilled at working independently, multi-tasking and delegating responsibilities.
- Quick learner, strong analytical skills, motivated with a positive attitude, good inter-personal skills, individual contributor and team player.
TECHNICAL SKILLS:
Testing tools: Quick Test Pro, WinRunner, Load Runner
Defect Tracking: Test Director/ Quality Center
Databases: SQL Server 2005/2008, Oracle, MySQL, Access
Configuration Management: Rational ClearCase
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
BI Tools: Business Object
PROFESSIONAL EXPERIENCE:
Confidential, Philadelphia, PA
Automation Tester
Responsibilities:
- Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
- Used Descriptive programming in scripting dynamic objects and reusable actions in defining scenario flows in Quick Test Professional (QTP).
- Used two types of Descriptive Programming, by giving the description in form of the string arguments and by creating properties collection object for the description.
- Captured Properties and objects of values for Descriptive Programming using Object Spy.
- Performed Data Driven testing with multiple test data inputs with QTP and MS-Excel.
- Optimized QTP scripts for Regression testing of the application with various data
- 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).
- 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.
- 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
- Tested ETL's and flat file data transfers without relying on any tools or GUI layer.
- 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.
- Verified logs to find any errors generated after running ETL jobs.
- Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
- 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.
- Used Agile testing methodology for achieving deadlines in UAT.
- Developed automated Test scripts using QTP to perform Functional and Regression 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.
- 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, Richmond, VA
QA Analyst
Responsibilities:
- Coordinated all QA activities and enhancements using Agile Methodology.
- Analyzed user requirement document and developed Test Plans, Test Cases and test Script.
- Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
- Worked on with Object Repository where properties of object is stored under respective logical name.
- Exposure to Database checkpoint to verify the data present in database with the help of DSN(Data Source Name).
- Worked with Error Handling Technique like Recovery Scenario Manager present in QTP.
- Extensively used QTP integrated environment like Data Table, Actions, Recovery scenarios
- Performed System testing, Functional testing, Integration testing, Web testing and GUI testing.
- Prepared and executed scenarios for the Regression testing on new builds.
- Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
- Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required sign-off’s.
- Escalation and resolution of issues with different teams during the UAT phase, getting the re-work done in a timely manner and re-testing the same.
- Analyzed test cases for automation and used Quick Test Professional (QTP) to automate manual test scripts for Regression and Functional testing.
- Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
- Administered Quality Center partly by creating the user groups and assigning privileges to Users.
- 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.
- Performed Backend testing to validate the data using SQL queries to the required Test cases.
- Report and review the defects in Mercury Quality Center defect tracking systems.
- Helped to create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
- Attended several walkthrough meeting with Business analysts, Project Manager and Developers and provided feedback accordingly.
Environment: Windows - 7, NT, 2003, 98, UNIX, LINUX, Oracle10g/11g, SQL Server 2005, SQL/ PL SQL, UML, HTML,.Net, JavaScript, VB Script, Crystal, XML, HTML, SSIS/ SSRS, QC 9.5, QTP 9.5/10.0, WinRunner, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project
Confidential, New Jersey
Automation Tester/ Analyst
Responsibilities:
- Thorough understanding of Business Requirement Documents, Functional/System Requirement Documents, Use Cases, Design Specifications in each phase of the application.
- Involved in meetings with developers, Systems Analysts and Business Analysts to verify the testability of the requirements and signed off on requirements.
- Involved in developing Test Plan for the application.
- Documented Test Cases corresponding to business rules and other operating condition.
- Developed SQL Queries to identify the test data.
- Planned and developed test cases using Test Director for functional testing.
- Wrote and modified required SQL validation scripts, and wrote SQL scripts to validate the outputs.
- Extensively used SQL to perform Database testing.
- Performed End-to-End testing manually.
- Closely worked with developers and System Engineers to nail down the technical problems.
- Analyzed test incidents and coordinate defect resolution with the development team via test director.
- Executed test cases and incident/defect management utilizing mercury test director tool.
- Worked with development team to establish timelines and deliverables.
Environment: Test Director 8.0, QTP 8.2, Win Runner, Load Runner 8.0, Oracle 10g, SQL / PL SQL, JAVA,, XML, HTML, VB Script, JavaScript, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, Windows - Vista, XP, 2003, UNIX, LINUX, UBUNTU.
Confidential
QA Tester
Responsibilities:
- Involved in functional testing, regression testing, system testing.
- Performed Manual (Black Box type) testing for the UAT.
- 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.
- Test sets are created for the test according to the purpose such as regression test.
- Logged, maintained & tracked defects, assigned type & severity levels, using the Test Director.
Environment: Test Director, SQL, Visual Basic 5.0, MS Access, Windows NT/ XP
Confidential
QA Jr. Automation Tester
Responsibilities:
- Responsible for writing scripts manually.
- 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.
- Worked with both Expert view and Keyword view of Editor Window in QTP.
- Worked on with Object Repository where properties of object is stored under respective logical name
- Include testing and analyzing the system testing, functionality testing, Integration testing.
- Attended several walkthrough meeting with the Business Analysts, Project Manager and developers and provided feed back accordingly.
- Got involved in preparing scenarios for the regression testing using automation tool WINRUNNER and also joined for training classes of QTP with senior testers for enhancements of new builds.
- Execution of the test scenarios and scripts and review of product functionality.
- Testing of various kinds of interfaces depending on the applications.
- 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.
- Created manual and automated tests for several different modules.
- Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
- Helped the Lead create Traceability Matrix to ensure comprehensive test coverage of requirements, identify all test conditions and test data needs.
- Used Test Director to plan tests, manage test data, create and run manual test.
- Created, Updated and maintained Test Scripts for different builds and releases.
Environment: SQL, WinRunner 7.6, TestDirector 7.6, Excel, HTML, SQL, Windows 95/98