We provide IT Staff Augmentation Services!

Sr.qa Analyst/etl Tester Resume

0/5 (Submit Your Rating)

Conyers, GA

SUMMARY

  • Around 12 +years of strong experience in Quality Assurance of Web based, Mobile Device, Client/Server and Data ware house applications.
  • Good concept of ETL, Warehouse and BI applications integration.
  • Proficient in Manual testing and Automation testing for web - based, client server and n-tier applications.
  • Experienced in automation testing with tools such as Selenium (Web Driver/IDE/ /TestNG and preparation of Automation Test framework.
  • Good Experience on Selenium IDE and creating Scripts in selenium.
  • Experience of developing Data Driven, Keyword Driven and Hybrid Frameworks.
  • Experience in development of VB Scripting for Automation in Quick Test Professional.
  • Experience in all aspects of the Software Development Life Cycle, with specific focus on testing. Followed and implemented the Water fall model, V-model of SDLC and Agile development methodology.
  • Experience on Native and Mobile App application.
  • Experience in programming with Java Script and VB Script.
  • Extensively worked on manual and Automation testing for GUI and Non-GUI objects.
  • Experience in both Black Box and White Box testing techniques.
  • Experience in using Automated Tools like Quick Test, Active Directory, Quality center and Load Runner in Client /Server, Web, Database and GUI Testing.
  • Proficiency in using Mercury Interactive Quality center, for Test Management and Defect tracking.
  • Responsible for development HP QTP and Perfecto Mobile automation strategy across multiple projects.
  • Extensive Experience in testing POS applications in Telecommunications and Retail domains
  • Quality Assurance experience includes Telecommunication, Banking, Healthcare, E-commerce, and Financial domain.
  • Good understanding of Database Management Systems (Oracle, SQL Server)
  • Performed the Database Testing (back End testing) of the Data, which is retrieved from the Database by viewing the data in the SQL.
  • Experience with mobile cloud platform like Device Anywhere and Perfecto Mobile
  • Specialized in testing on both WINDOWS and UNIX environments.
  • Experience in Installation and Configuration of Software and Hardware in testing environment.
  • Proficiency in using Rational Clear Case for Documentation and used Clear Quest for Defect tracking.
  • Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/NT/XP, UNIX

Languages: C, Java, Visual Basic, VB.Net, Web Services, SQL, Shell Scripting

Automated Tools: Win Runner Load Runner, QTP 9.2/10.0/11,UFT, Appium and Selenium 2.4

CASE Tools: Rational Requisite Pro, ERWin3.5, Rational Rose 4.0, TOAD

Test Management Tools: HP Quality Center 10.0/11and ALM 11.0, Rally, and JIRA

RDBMS: MS-Access, oracle 9i, MS SQL Server 2000.

Web Servers: IIS4, JWS, Web logic 4.0 and Web sphere4.0

Reporting Tool: Crystal reports, Business Reports and Cognos

ETL Tools: Informatica power center 9.1/8.6.1,7.x/6.2, Power mart 5x/4.7, Data StageAbinitio, SQL Server Reporting Services(SSRS)

Billing Engine: Amdocs Billing (Enabler & Ensemble), Geneva 4.2

Web Technologies: ASP.NET, Web Service, SOAP 2.5/3.6/4, XML, and VB Script

Mobile Device: Apple and Samsung.

CI Tool: Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr.QA Analyst/ETL Tester

Responsibilities:

  • Involvement in Preparation of Test Procedures, Test Scenarios, Cases and Test Data.
  • Responsible for GUI and Functional Testing, using Black box Testing Techniques.
  • Perform Functional, Data Validation, Integration, Regression and User Acceptance testing.
  • Involvement in Test Execution, Results Analyzing and Defect Reporting.
  • Created Test Cases Using Element locators and Selenium Webdriver methods.
  • Enhanced Test using Java programming features and TestNG Annotations.
  • Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars and TestNG.
  • Execution of Selenium Test cases and Reporting defects.
  • Conducting Data driven testing, cross browser testing and parallel test execution.
  • Involved in Regression Testing using Selenium.
  • Involved in the continuous integration of automation frame work with Jenkins.
  • Preparation of weekly and monthly status reports.
  • Written complex SQL queries for each level of data validation.
  • Performed the Backend Testing of the Data, which is retrieved from the Database by viewing the data in the SQL.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Connected remotely to UNIX servers using PUTTY.
  • Created and Verified Web services API requests, SOAP Protocols.
  • Tested functionality and performance of web services
  • Analyzed Test Results, posted to Quality Center for Defect Tracking.
  • Good understanding in Data Warehousing and ETL testing concepts.
  • Experience with Mercury Test Management tools Quality Center and JIRA Defect tracking tool
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.

Environment: Manual Testing, Selenium, Java Script, Web Driver, Cucumber, Protractor, Eclipse, Jenkins, ANT,JUNIT, Quality Center, Java,Informatica,, Oracle, SQL, Postgres TOAD, SOAP, Postman, XML,UNIX Jira, Windows XP.

Confidential, Conyers, GA

Sr.QA Tester

Responsibilities:

  • As test Engineer, involved in plan & perform testing, verification & validation, and quality assurance.
  • Conducted thorough smoke, functional, regression, integration and system testing on the product tracking application.
  • Performed functional testing of web services using swagger tool.
  • Validated the Web Services, both Request and Response messages
  • Responsible in executing Selenium test scripts on different browsers and checked for compatibility.
  • Used Java Script for developing the Selenium script.
  • Involved in regression testing using Selenium.
  • Written and executed SQL queries and Joins, Group By clause, having clause etc. to validate the data.
  • Worked on mobile device(ios and Android)
  • Involved in the Regression Testing after each modification and enhancement.
  • Documented the raised defects and followed up with development team for defect fixes.
  • Involved in Functional and performance testing of the web-based application
  • Coordinated with UAT team by providing them with test cases and test data.
  • Involved in End to End testing of business rules on the Web based application

Environment: Quality Center, VSTS, Java/J2EE, Java Script,SQL Server, Selenium, Junit,Web Services, UNIX, Swagger, Postman, TFS,Windows, Mobile Testing, Hockyapp, TestFlight, and Wi-Fi testing.

Confidential, GA

Sr. QA Analyst

Responsibilities:

  • Involved in Preparing Test Plan and writing Test Cases.
  • Doing Functional, Integration and UAT testing on the application.
  • Worked as a defect manager for IST, E2E and PVT defects.
  • Validate the web services data from Account Creation and CPNI Account Information
  • Involved in Automation Development using Selenium.
  • Execution of selenium Test cases and Reporting defects.
  • Performed functional testing to identify various critical points in the application and automated it by using Selenium web driver
  • Used Id, Name, Links, XPath and CSS to work with dynamic and static elements in application.
  • Responsible in executing Selenium test scripts on different browsers and checked for compatibility
  • Developed new Automation test cases using selenium WebDriver and TestNG,
  • Validate the REST API services through SOAP UI.
  • Used HP Quality Center (QC) and JIRA for reserving, executing test cases, defect tracking, and the complete test management.
  • Used the BO Tool to schedule the reports.
  • Took a leading role in all QA and QC activities during UAT and PROD SDLC stages.
  • Working with clients, co-ordinate with teams from onshore and offshore.

Environment: Manual Testing, Selenium, Java Script, Web Driver, Eclipse, Jenkins, ANT,JUNIT, Mobile Testing, Quality Center, Load Runner, Business Objects, Java, C#, .Net, Oracle, SQL, TOAD,SOAP,XML,UNIX, Rally, Mozilla Firefox and Windows XP

Confidential, GA

Sr. QA Engineer/ETL Tester

Responsibilities:

  • Worked in Agile environment.
  • Developing project test plan, test cases based on software requirement specifications using ALM Quality Center and executed in time.
  • Tested on different Mobile devices like apple (iPod and, iphone) and Samsung(phone, tablet).
  • Android (Mobile) applications, client server applications and cloud applications.
  • Designed test cases using selenium WebDriver and testing.
  • Extensively used Selenium (data-driven, XPath locator) and Web Driver to test the web applications
  • Develop scenario based testing for the Java Script scripts.
  • Involved in generation of automation reports using ReportNG.
  • Responsible in executing Selenium test scripts on different browsers and checked for compatibility.
  • Involved in automating test cases using Selenium RC with Junit.
  • Prepared test data for testing the application in various test phases.
  • Created Automation script using Selenium WebDriver. Executed scripts on different browser and different platform.
  • Creation of Automated test plans( test sequence) based on the state model using Postman tool.
  • Tested the native app in IOS and Android
  • Worked on developing the automation scripts using Selenium Web Driver with JUnit Frame work.
  • Perform database verifications using SQL queries to validate test data.
  • Performed functional testing of web services using SOAPUI tool.
  • Responsible for updating and maintaining ALM Quality Center for all the defects found during the functional and regression testing and follow up the bug life cycle.

Environment: Manual Testing, QTP, Selenium, Web Driver, Eclipse, JUNIT, Appium, Perfecto Mobile Testing, Postman, Quality Center, ANT, Java, Oracle, SQL, TOAD, SOAP,XML,UNIX, Rally, Mozilla Firefox and Windows XP

Confidential, GA

Sr. QA Analyst

Responsibilities:

  • Manual testing for usability and compatibility.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Validated the Web Services (SOAP), both Request and Response messages
  • Involved in Testing Web Services using SOAP UI and Web Service Navigator.
  • Developed automated scripts using Quick Test Pro(QTP) to perform functional and regression testing.
  • Connected remotely to UNIX servers using PUTTY.
  • Developing project test plan, test cases based on software requirement specifications using ALM Quality Center and executed in time.
  • Executing the test scripts and reporting defects in Quality center.
  • Developed Data driven Test cases automated regression test suite using QTP/UFT.
  • Tested the application under different networks and Internet speeds including while on EDGE, 3G, and Wi-Fi.
  • Tested the connected car in middleware environment.
  • Identified defects, retested defects using defect Tracking and Reporting software’s defects using HP Quality Center during various phases of testing.

Environment: Manual Testing, ALM Quality Center 11, Rally, JIRA, SQL, TOAD, SOAP, Enabler, Mediation, Selenium 2.0 (Web Driver2.0), Eclipse, XML, UNIX, Linux Java, Load Runner, Oracle and Windows XP.

Confidential

Senior QA Analyst/Lead

Responsibilities:

  • Create and execute various test scripts as per test plans and execute them in different environments.
  • Reviewed and analyzed Business Requirement Documentation (BRD) to gain understanding of POS implementation.
  • Performed positive & negative and End-to-End testing, Regression testing manually and was associated with User Acceptance Testing.
  • Involved in testing the following services under Retail-Pay.
  • Responsible for writing and executing QTP Scripts for Functional, Regression and integration testing of the application.
  • Developed Data driven Test cases automated regression test suite using QTP.
  • Created automation scripts using HP QTP for different scenarios, used Smart Identification feature of QTP to identify unique properties of objects, created user defined functions, reusable actions, and managed shared object repositories.
  • Used HP Quality Center to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
  • Checked the data flow through the front end to backend and used SQL queries, to extract the data from database Created test scripts from the test plans and identified test scenarios and test harnesses.
  • Providing solutions for the Business requirements of the Telecom Billing.
  • Created complex SQL queries for extracting Customer information from multiple tables in database.
  • Wrote and Executed SQL queries to perform backend testing.
  • Executed Batch jobs in UNIX environment.
  • Performed functional, regression, and black-box testing on the payment and billing application.
  • Created appropriate test cases, test scenarios, logged defects in HP ALM Quality Center.

Environment: Manual testing, HP ALM Quality Center 11.0, Load Runner,J2EE, Java,.net, XML, HTML,VB Script, Oracle 11i,TOAD, QTP 11.0, BPT, Flex Monkey, Rally Software, SQL Developer, UNIX, Shell script, SOAP UI, Load Runner, Amdocs Enabler, and Windows 2000/XP

Confidential, Atlanta-GA

Senior QA Analyst/ETL Testing

Responsibilities:

  • Responsible for preparing and executing Test Plan, Test cases and Test scripts using Quality Center.
  • Performed Batch Testing, Key word driven testing, functional driven testing and data driven testing.
  • Conducted security event monitoring for corporate wide in-scope applications.
  • Performed Manual Testing and created test cases including Functional Test Cases, Acceptance Test Cases.
  • Responsible for writing and executing QTP Scripts for Functional, Regression and integration testing.
  • Performed Regression Testing and developed GUI map of application data of the scripts with QTP.
  • Extensively creating scripts using Load runner.
  • Created complex SQL queries for extracting Customer information from multiple tables in database.
  • Designed and built out a data driven framework, with VB scripting using QTP.
  • Performed data validation testing after the ETL process.
  • Unix Shell Scripts and executed them to analyze the server logs.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
  • Used HP Quality Center to generate reports and graphs to analyze the test results.
  • Updating and maintaining the results in HP ALM Quality Center for all the defects found during regression testing and follow up the bug life cycle.
  • Executed the Test cases for BO.
  • Extensively involved in testing several Business Objects Reports and Hyperion’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Windows XP, ADO.Net, ASP.Net, C#, VB. Net,, HTML,SVN, Rally Software, Frame work 2.0,SOAP UI 3.0, Informatica 8.6, Business Objects, Cognos,Oracle, UNIX, Putty, TOAD, QTP, TFS,Load Runner,Manual Testing, Snagit, SharePoint, Load runner and Quality Center 9.2.

Confidential, Warren, NJ

QA Analyst/ETL Tester

Responsibilities:

  • Worked as a QA Analyst on different projects for web base Mortgage application.
  • Performed GUI testing, integration testing, regression testing, Ad -hoc testing, negative testing on multiple projects.
  • Analyzed Business Requirements, Functional specifications, Minor Development documents.
  • Application was built on Agile (Scrum) methodology.
  • Functional coverage, Identification of Regression Test cases and test cases execution.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Involved in Functional, Integration, System, Regression, Data migration & Compatibility Testing.
  • Involved in Web Services Testing using SOAP UI.
  • Participated in the testing of the software for the financial Content Management System to ensure the highest level of quality including.
  • Worked on Credit card processing in Transactional module.
  • Tested application within Testing, Development and Production environments
  • Used Quality center for Defect Tracking and reporting, updated the bug status and discussed.
  • Executed Batch jobs, FTP and UNIX shell scripts.

Environment: AbInitio, JAVA,J2EE, Java Script, Oracle 10g, UNIX, Shell script, SOAP, SQL, XML, Agile(Scrum), SQL Server 7.0,TOAD, putty, QTP, Quality center, and Windows XP

Confidential, Little Rock, AR

QA Analyst/ETL Tester

Responsibilities:

  • Involved in Writing and executing Test plans and Test cases of PMIC. These Scripts were developed after reviewing the business requirements document, and technical specifications document
  • Reviewed the requirements and the use case diagrams and lead preparation of Test Cases/ Test plan that would test various scenarios.
  • Conducted System, Backend (database), Regression and Adhoc/Manual.
  • Prepared many simple to Complex SQL Scripts to validate the data and structure of the tables in for conversion.
  • Validate the Data Mart tables to check the data has been populated correctly.
  • Conducts ETL tests defined in the test plan, analyzes results and reports progress for assigned projects.
  • Involved in Data migration testing.
  • Tested the Data loading from Source files to staging tables, Staging to Data Warehouse and Warehouse to Data Mart.
  • Created complex SQL queries for extracting Customer information from multiple tables in database.
  • Worked with developers to fix bugs that occur on the Sequoia staging environment through the use of Jira.
  • Database Validation to check the updated data in the Database using Toad.
  • Defining defects and carried out test reports using Quality Center.

Environment: Windows XP, UNIX, XML Share point, Oracle11i, SQL Server, SSIS,SSRS, TOAD, putty, SOAP, Cognos, JIRA, Source Forge and Quality Center 9.2.

Confidential, Memphis-TN

Sr. QA Tester

Responsibilities:

  • Involved in Functional and Regression testing.
  • Involved in power pad device Testing.
  • Verifying the accuracy of billing details and revise for any error.
  • Responsible for preparing and executing System Test Plan, Test cases and Test scripts using BPT in Quality Center.
  • Developed Test Plans, Test Case design using Quality Center Business Components (BPT).
  • Developed Data driven Test cases automated regression test suite using QTP 9.2.
  • Responsible for writing and executing QTP Scripts for Functional, Regression and integration testing.
  • Used HP Quality Center for adding requirements, writing test cases, executing test cases and defect tracking.

Environment: Windows XP, JDK 1.4.2 13, Java Swings, TIBCO,HTML,UNIX, Eclipse 3.2, BEA Web logic, XML, GENEVA, Oracle, QTP, VB Scripting, Manual Testing, SharePoint, BPT module, Quick Test Pro, Load runner and Quality Center 9.2.

Confidential, Chicago, IL

Sr. QA Engineer

Responsibilities:

  • Responsible for preparing and executing Test Plan, Test cases and Test scripts using Quality Center.
  • Testing of Guide wire UI, rules and integration processes.
  • Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy center and Payment manager in Guide wire application based on the business requirements.
  • Responsible for Regression testing after bug fixes and verifying those fixes.
  • Performed Manual Testing and created test cases including Functional Test Cases, Acceptance Test Cases.
  • Involved in reviewing and analyzing the existing test cases in Rally. and Quality Center
  • Performed the Backend Testing of the Data, which is retrieved from the Database by viewing the data in the SQL.
  • Identified defects, retested defects using defect Tracking and Reporting software’s defects using Quality Center during various phases of testing.

Environment: Manual Testing, Quick Test Pro, BPT, Quality Center, Guide wire, Rally, JAVA, J2EE, XML, Web Logic, SQL Server2008, SSRS, SQL, SOAP, and Windows XP

Confidential, Memphis-TN

Responsibilities:

  • Involved in Preparing Test Plan and writing Test Cases.
  • Performed testing for various modules.
  • Responsible for Regression testing after bug fixes and verifying those fixes.
  • Provided assistance to team members to clarify functional and technical difficulties.
  • Analyzed functional specifications from the front-end application with reference to requirement documents.
  • Responsible for preparing and executing Test Plan, Test cases and Test scripts using Quality Center.
  • Wrote SQL scripts for retrieving and updating the database tables for the Backend Testing.
  • Involved in designing framework which involved in running the tests from a batch file
  • Defining defects and carried out test reports using Quality Center/Jira.

Environment: Manual testing (Black Box and White Box),QTP, VB Scripts, Load Runner, Subversion, Quality Center, JIRA, Java, AJAX, Junit, Biz Talk,Oracle9i,DB2, XML,SQL,UNIX,VB Script, TOAD, and Windows 2000/XP.

We'd love your feedback!