Qa Tester/ Etl Tester Resume
Manhattan, NY
SUMMARY:
- Experience in full Software Development Life Cycle (SDLC) and Methodologies and Validations to ensure the Quality Assurance Control of over 7 years.
- Strong analytical and QA/ testing skills, capacity for work and diagnostic ability, Gathering different kind of projects requirement. Covered Agile and Waterfall models of SDLC.
- Expertise in Analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.
- Strong working knowledge in C, C#, Java, Java Script VB Script, J2EE, XML, SQL, SQL Server, .NET Environment, DB2, and Oracle.
- Worked in important phases of Software Testing Life Cycle (STLC) like Smoke Testing, Functional Testing, Integration Testing, Regression testing, and was involved in Load Testing, Performance Testing, End to End Testing and User Acceptance Testing (UAT).
- Thorough knowledge of Internet standards (HTML, HTTP), web site design principles and software usability practices
- Experience in Back - end testing using SQL Queries on Oracle RDBMS and SQL Server .
- Expertise in Manual and Automation Testing.
- Testing Methodology and Test Plan Formulations.
- Test Case analysis and design, Test Script development and Test Coverage.
- Test Summary Reports, Defect Tracking and change management.
- Expertise in Integration Testing, System Testing, Performance Testing, Functional Testing, ETL Testing and Regression Testing.
- Experienced with Black Box testing.
- Expertise in manual testing and in automation testing tools like Quick Test Professional, Win Runner, and Load Runner.
- Strong hands on experience in testing Commercial Websites and Business Applications.
- Extensive experience in Testing both WEB and Client/Server environment.
- Experience in testing database applications of RDBMS in ORACLE, PL and SQL Server.
- Expertise in writing and executing SQL Queries.
- Knowledge of Software QA Standards and Methodologies.
- Excellent communication, interpersonal, intuitive and analytical skills.
- Expertise in participating actively in the meetings & tele-conferences with Users, Business Analyst team, Development team, QA team members and Managers.
- Proven ability to work efficiently in both independent and team work environments.
- Ability to work in a team.
TECHNICAL SKILLS:
Testing Tools: QuickTestPro 8.0/8.2/9.0/9.2/9.5, 11.53, TestDirector8.0/7.6, UFT 12.02QualityCenter 8.2/9.0/9.2/ 11.52/12.50, Clear Quest, Winrunner7.0, LoadRunner8.0
Languages: C, C++, Java, VB Script, TSL, Visual Basic, .Net, SQL, PL/SQL, ASP
Internet Technologies: VBScript, JavaScript, XML, HTML.
Database Technologies: Oracle 8i/9i, MS-SQL Server 2005, MS-SQL Server 2012.
Others: MS-Word, MS Excel, MS-PowerPoint, MS- Outlook, IIS.
Platforms: MS-DOS, Windows 95/98/2000/NT/XP, Windows 2007, Windows 2010.
WORK EXPERIENCE:
Confidential, Manhattan, NY
QA Tester/ ETL Tester
Responsibilities:
- Involved in analyzing System Requirements and developing test plans for Functional and Regression testing.
- Involved in writing test cases and test plan for the system application.
- Executed manual and automated test cases and verified actual results.
- Interacted with Business experts and Senior Developers to arrive at the mutual solution.
- Used SQL to perform Backend Testing/Database testing.
- Involved in downstream ETL testing for Data Warehouse and Data Mart.
- Worked on data Migration and Conversion projects where applications were newly developed from Client server to Web interfaces.
- Created test cases executed and recorded results of test cases using Quality Center.
- Analyzed the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Quality Center.
- Monitored the defect tracking process, trouble shooting and generating customized graphs and reports for the client. Reported Bugs using Quality Center, JIRA and In-house application: Footprints and ServiceNow.
- Executed the automation scripts using Quality Center. Created test cases and tested Web based and consumer applications, using manual and automation tools like HP QC/ALM and QTP.
- Documented issues found during test on the Quality Center system and communicated recorded problem to the responsible QA Manager.
- Wrote manual test scripts for all the GuideWire ClaimCenter Interfaces to automate them.
- Wrote test scripts for automation on smoke and regression testing.
- Checked the dependency of an application and coordinated with DBA’s, Developers, Managers and other QA’s to set up the environment ready for testing.
- Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans.
- Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
- Involved in ATDD (Acceptance Test Driven Development)
- Worked as Software Development Engineer in Test (SDET)
- Conducted manual testing for checking Functionality, Security, and Performance testing during the various phases of the development of the online application.
- Involvement in automated testing including Functionality Testing, GUI testing and Regression Testing using Quick Test Pro.
- Performed Integration testing, User acceptance testing and regression testing using the QTP.
- Performed Black Box Testing of the entire application using Quick Test Pro/UFT.
- Assisted QA Lead on End to End Testing.
- Worked extensively on Production Support. Attended the weekly production support meetings.
- Involvement extensively in User Acceptance Testing (UAT).
- Responsible for sending weekly status reports showing progress and future testing efforts to the QA Manager.
- Worked with development team to ensure that the productions issues are resolved.
Environment: s: IE 10/11, Java, .NET, HTML, Hyland OnBase, Sapiens Rapidsure(PS), Insurity PDCL(PS), Quick Test Pro 11.53, UFT 12.02, ALM/Quality Center 11.52/12.50, JIRA, VB Script, Agile, Microsoft SQL 2012, MS Office 2010, Guidewire ClaimCenter 8.0, Majesco Renaissance Billing System V3 and V5, RBS ODEN, WebMethods, Guidewire UM.
Confidential, Northbrook, ILQA Analyst/Manual Tester
Responsibilities:
- Analyzed the Business Requirement Documents, and prepared detailed test cases.
- Checking the dependency of the applications.
- To communicate with project manager for security issues of the application.
- Involved in Functional testing, and Acceptance testing.
- Logging the defects of all the team member’s applications and looking for the change of status of defects to ready for retest and communicate to team members that application is ready for retesting and retesting the application successfully and closing the defects.
- Stored scripts and called Automation scripts from QC.
- Executed automation scripts extensively with multiple O/S.
- Thoroughly analyzed the functional requirements documented in the Software Requirements Specifications to develop the corresponding test cases in Mercury/HP QC.
- Participated in Agile Development Cycle.
- Developed manual test cases and execute the devices manually.
- Performed on Agile to emphasize face-to-face communication over written documents.
- Used HP Quality Center/ALM, QTP, SoapUI for tracking and reporting for Internal High Level access and also to create reports and update bug status
- Managed requirements and Test Cases using Quality Center and executed the scripts/steps using Manual runner.
- Worked in an Agile technology with Scrum
- Worked as Software Development Engineer in Test (SDET)
- Worked on Claims, Underwriting, Billing and finance modules
- Involved in UAT testing and System testing of all phases of Accumulator.
- Performed UAT testing with Business Users
- Wrote several System Test Scripts and UAT Scripts.
- Leveraged the test management features of Quality Center for System Testing, UAT and Regression Testing.
- Responsible for UAT testing of the project.
- Developed test plan and test cases for UAT testing and performed Integration testing.
- Participated in meetings with developers to discuss enhancements and modifications.
- Involved in facilitating formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing
- Participated in Defect assessment meeting.
Environment: Quality Center 9.2, QTP 9.5, SQL Server 2005, UAT, TOAD, ALM, Oracle 9i, Agile, UNIX, VBScript, C#.Net, SOAP, HTML, JavaScript.
Confidential, PAQA /Manual Tester
Responsibilities:
- Gathered, refined, and prioritized business requirements from business owners through meetings and questionnaires.
- Captured results of Process & Requirement Analysis workshops and interviews.
- Interacted with developers for analysis of the application.
- Analyzing the Business requirements and the site specifications.
- Generated reports and metrics to provide project status to Upper Management.
- Developed Requirements Traceability Matrix (RTM) to track requirements during the QA Testing Phase using Quality Center.
- Documented the defects in Quality Center.
- Extensively worked on Testing Status, Summary reports and log reports.
- Involved in UAT Testing and composing training manuals
- Conducted Functionality testing during various phases of the application
- Imported Requirements from the Product Backlog Excel Spreadsheet into the Mercury/HP QC Requirements Tab in order to link the requirements to the corresponding test cases.
- Used to develop Test Plan, Test Strategy, Test Cases, and executed them in test lab (QC/ALM 11.0) and excel sheets.
- Imported the test cases from the individual Testing Sprint Backlog Excel Spreadsheets into the Mercury/HP QC covering all testing scenarios in the Test Plan Tab and executed the same using the Test Lab Tab.
- Performed Integration Testing and Batch Testing.
- Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
- Performed User Acceptance Testing, GUI testing, Smoke testing etc.
- Involved in User Acceptance Testing.
- Involved in UAT Testing and composing training manuals
- Write SQL Query to extract data from various database tables for testing purpose.
- Involved in developing Entry & Exit criteria and defined the pass and fail standards.
- Performed different types of testing on application to ensure that application is error free.
- Tracked business and functional requirements throughout the project lifecycle.
- Translated business and functional requirements into test cases.
- Worked as a liaison with Quality Assurance Manager on the execution of system testing
- Leveraged the test management features of Quality Center for System Testing, UAT and Regression Testing.
- Involved heavily in Database Testing. Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
- Contributed to the development of improved implementation methodologies.
Environment: Quality Center 9.0, Load runner 8.1, VB Script, HP ALM, UAT, .NET, ASP.NET, C#, SQL, XML, HTML, Oracle 9i, Java and MS Office.
Confidential, Baltimore, MDQA Tester
Responsibilities:
- Involved in analyzing System Requirements and developing test plans for Functional and Regression testing.
- Involved in writing test cases and test plan for the system application.
- Executed manual and automated test cases and verified actual results.
- Interacted with Business experts and Senior Developers to arrive at the right transaction mix on the Production environment for Load/Stress/Performance testing.
- Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, and tracking defects.
- Created test cases executed and recorded results of test cases using Quality Center.
- Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Quality Center. Monitored the defect tracking process, trouble shooting and generating customized graphs and reports for the client. Reported Bugs using Quality Center.
- Created automated scripts using Quick test pro and developed test suites to execute the scripts using Quality Center. Created test and tested Web based and consumer applications, using manual and automation tools like HP QC/ALM and QTP
- Documented problems found during test on the Quality Center system and communicated recorded problem to the responsible QA Manager.
- Conducted manual testing for checking Functionality, Security, and Performance testing during the various phases of the development of the online application.
- Involved automated testing including Functionality Testing, GUI testing and Regression Testing using Quick Test Pro.
- Perform integration testing, User acceptance testing and regression testing using the QTP.
- Performed Black Box Testing of the entire application using Quick Test Pro.
- Assisting QA Lead to perform Load, Stress and Performance Testing.
- Experience in developing Shell scripts in UNIX.
- Used SQL to perform Backend Testing, Involved in Load Testing and Regression Testing using Load Runner.
- Involved in User Acceptance Testing (UAT).
- Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
- Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans
- Worked with development team to ensure that the testing issues are resolved.
Environment: J2EE, JSP, Servlets, Java, HTML, WebLogic, EJB, Quick Test Pro 8.0, ALM, Quality Center 8.0, Load Runner, VB Script, ClearCase, Agile, SQL, Oracle, MS Office, Windows NT, UNIX platform.
Confidential, Redondo Beach, CAJunior QA Analyst
Responsibilities:
- Analyzed use cases, functional requirements to write test plans and test cases.
- Involved in the creation of test plan, test cases and test procedures required for manual testing and to initiate automated testing.
- Responsible for implementation of Hybrid Test Automation Framework build using Selenium WebDriver, TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
- Involved in creation of automation framework in Selenium WebDriver using behavior driven approach like Cucumber.
- Created and executed the test scripts with Java, Selenium WebDriver, and TestNG.
- Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.
- Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
- Used Page Object Model, UI Mapping, Selenium Manager, Data Driven using CSV, CSS Selectors as a part of Framework.
- Extensively used Selenium (XPath and CSS locators) to test the web application.
- Extensively used Selenium IDE to record, playback and debug individual test cases, using Selenium WebDriver provided more flexibility in automating test cases.
- Extensively worked on selenium web Driver with the preferred Languages Java, C Sharp, Python, Ruby and Perl.
- Involved in discussion with the Subject Matter Experts (SME) during creation of test plans and updating of business requirements.
- Responsible for creating and execution of automated test scripts using QTP and Carried out Functionality, Integration and Regression testing using QTP.
- Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
- Validated Web Services using SOAPUI. Sent SOAP request to check web services data and analyzed the response Performed data driven testing by using JDBC connection, Excel sheet as data source.
- Created database connection, customized assertion, property transfer using Groovy Script.
- Used steps like Groovy scripts, Data Sink, JDBC Request etc. to enhance and customize the testing.
- Designed and executed functional, data driven and basic load test cases for web services testing in SOAP UI.
- Used Jmeter for functional, Regression and Load testing.
- Created and tested scenarios using positive and negative test data.
- Performed Backend testing using SQL Queries in QTP.
- Validated WSDL with the use of different assertions using SOAPUI.
- Identified, analyzed, and documented defects, errors, and inconsistencies in the application using Mercury Quality Center.
- Manual Testing for checking the flow of the application functionality
- Involved in Developing, revising, and verifying software test plans and strategies.
- Involved in documenting the defects found during UAT.
- Prepared Jmeter test cases and verified for load testing.
- Review test cases developed by the QA team and provide feedback on any missed use cases, and to ensure documentation of any edge-case scenarios in technical design documents.
- Created Call flow diagrams for IVR applications using VISIO.
- Periodically run queries against Eivr database to determine what type of errors occurring and the frequency.
- Research all errors types and contact the appropriate resource and communicate promptly.
- Involved in supporting weekend workflow tasks and releases during production support.
- Developed the UML Use Cases, Activity, Sequence and Class diagrams using Rational Rose.
- Played crucial role in assisting developers, QA, UAT by providing the needed data for their test cases so as to validate the business requirements.
Environment: Quality Center, MySQL, TOAD, SOAP UI, QTP 9.5, JMeter, VISIO, Rational Rose, Windows 7.