We provide IT Staff Augmentation Services!

Lead Qa Analyst Resume

4.00/5 (Submit Your Rating)

Washington, DC

SUMMARY:

  • Nine years of IT experience and specialization in QA Manual and Automation software test design, test development, Testing and Quality Assurance practices in a structured, full life - cycle development and validation environment, seeking for a full-time position where I can apply my experience and knowledge to enhance the ability.
  • Experience in SDLC process and STLC processes and best practices
  • Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements
  • Proficiency in Microsoft Office suite (Word/Excel//PowerPoint), SharePoint.
  • Proficiency in IBM RQM system, Creates and executes test cases link and tracks the progress of defects in RQM.
  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management (ALM )
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, DB2 and Flat Files.
  • Good Knowledge of Object Oriented programming Concepts(OOPS), Java and C# Skills
  • Good experience in creating test scripts using WebDriver, Selenium Grid in Java and C#.
  • Experience in automating test cases using Testing, Junit and Cucumber QUnit, NUnit, TFS Coded UI scripting and execution
  • Experience in data- driven test using Jenkins and Excel.
  • Excellent knowledge on Tosca engines
  • Good knowledge on Tosca test Suit- Module, Test Case, Test Case Design, Requirement and Execution.
  • Developed automated test scripts using VB Script to perform Functional and regression testing in QTP.
  • Expertise in TOAD, SQL Developer, Data Studio, Win SQL, Davis and BTEQ query tools.
  • Expertise in working in SDM, Agile Environment (Scrum), Waterfall.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL.
  • Extensively used Rational's Quality Manager (RQM), Secure FX, Secure CRT, Web Services and SOA, Eclipse, Pegasus, Even Producer, INFOConnect, Eclipse, XML Spy WSDL in order to creates test data files and perform the test executions.
  • Involved in RDBMS, Oracle, SQL Server, MS Access, DB2, Back-end Testing, stored Procedures and Triggers, PL/SQL Scripting.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • Excellent knowledge of system integration testing, software testing methods, and 508 policy and best practices
  • Enthusiastic, Success driven, customer-focused, result oriented, willingness to learn and work hard to achieve the goals, ability to travel extensively, ability to work cooperatively, tactfully and diplomatically with a diverse group of people.
  • Strong analytical, good communication skills and the ability to work independently with minimal supervision and perform well as part of a team.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: RQM, UFT/ QTP/ALM, Load Runner, JIRA, TFS, SpecFlow selenium, Tosca, SharePoint

RDBMS: Oracle 11g/10g, MS SQL Server 6.5/7.0, 2000, UDB, DB2, Sybase, SQL Server 12.0/11.x, MS Access 7.0. Selenium.

Programming: Java, C# .NET, VB, Soap, WCF, IIS, JavaScript, ETL, J2EE,UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Lead QA Analyst

Responsibilities:

  • Communicated with Project Managers, Systems Architects, Systems Analyst, DBA's and Software Engineers to gather requirements for testing and develop estimates for testing execution
  • Developed testing plan/schedule and maintain test matrix based on development completions and project timelines
  • Designed and Developed the Automation Test Scripts using Selenium WebDriver using Java
  • Developed the Automation Test Scripts in Selenium WebDriver using Java based on the design pattern Page Object Model for reusability
  • Prepared Test Cases using Data Driven, Hybrid, Modular, and Keyword Driven Framework in WebDriver
  • Designed, executed and maintained Selenium Web Driver (TestNG, JUnit) automated test cases for regression test cases
  • Selected the Test Cases to be automated and performed functional testing of the front end using Selenium (IDE and Web Driver) & created Data Driven framework using JUnit.
  • Conducted extensive data analysis/verification by writing and executing complex SQL queries in Microsoft SQL Server Management Studio and DB2 Data Studio
  • Created test data, developed/executed test cases for System Integration, Regression, and User Acceptance testing.
  • Develop, update and maintain quality testing standards and procedures.
  • Assist in the planning, creation and control of the test environment(s)
  • Facilitate and participate in structured walk-through, and peer reviews
  • Lead/participate in the coordination, and execution of release testing
  • Mentor other testers on methodology framework testing processes, and application knowledge as appropriate.
  • Coordinated with cross-functional teams and ensured standard protocols are followed in all testing plans
  • Prepared and drafted Conversion Issue documents, Master List QA Anomalies, and Excel data mismatch reports for Senior Management as well as User Groups for the purpose of analysis and possible data corrections
  • Reported and prioritized defects using Track Record, and coordinated with Client, developers in defect management analysis.

Confidential, Herndon, VA

Quality Analyst

Responsibilities:

  • Participate in requirements gathering sessions
  • Create test plans for SIT testing
  • Create test cases for SIT testing, including the identification, collection and/or creation of test data
  • Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.
  • Execute frontend, and backend tests.
  • Automating application using Selenium.
  • Developed Data Driven Tests using Java, Selenium and automated functional testing.
  • Automated test suites using Data Driven automation test frameworks and with element locators and Selenium WebDriver methods in TestNG.
  • Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
  • Ensure test scenarios based on business process flows have been created.
  • Develop, update and maintain quality testing standards and procedures
  • Assist in the planning, creation and control of the test environment(s)
  • Lead/participate in the coordination, and execution of release testing
  • Mentor other testers on methodology framework testing processes, and application knowledge as appropriate
  • Participated in Workgroup Meeting, SIT status updates and other project meetings on a daily basis using Live Meeting and Voice.
  • Determine and meet time estimates, and schedules for testing efforts.
  • Keep management informed of testing progress status regularly.
  • Performance CRUD operation and verification ACID Properties with SQL.
  • Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables

Confidential, Lanham, Maryland

QA/ ETL Tester

Responsibilities:

  • Analyzed requirement documentation, functional specification, design documentation and translated the functional requirements into Test cases.
  • Creates Test Plan, Test cases, test scripts, complete the Peer review process, executes test cases execution records (TERs) record test results and attached test artifacts with applicable screen shorts in the RQM.
  • Extensively used IBM Rational Quality Manager (RQM )
  • Involved in multiple projects and participated in meetings with SME and Business Analysts.
  • Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.
  • Estimate, prioritize, plan and coordinate testing activities and actively participated in the team meeting with QA lead and Manager.
  • Creates Data files in Pegasus for All required Confidential Form.
  • Logged into the defects using KISAM and linked the defect with RQM assigned them to corresponding developers..
  • Writing SQL queries and statements to test database for retrieving information, editing data and inserting data.
  • Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables
  • Participated in Integration, System, Smoke and User Acceptance Testing and production testing using RQM.
  • Ensured weekly deliverables of the requirements as per the Agile Model.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Reported outstanding bugs, followed up bug fixes, conducted review of existing test scenarios and assessed the need for their enhancement.

Confidential, MD

ETL Tester

Responsibilities:

  • Design and Created test plan, test scenarios and test cases for Data warehouse and ETL testing..
  • Involved in daily Scrum meetings (Agile Methodology). Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
  • Tested mappings with the Design Documents and also performed testing for various sample data.
  • Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Application lifecycle management (ALM ).
  • Exclusively used test plan module to write and test lab module to execute the test cases in Application lifecycle management (ALM).
  • Exclusively used requirement module for requirement and defect module for entering the defects in Application lifecycle management (ALM ).
  • Created, enhanced and maintained high-end test scripts for various functional and regression using Quick Test Professional and VBScript.
  • Used Informatica Power Center as an ETL Tool for extraction, transformation and loading (ETL) of data into the Enterprise Data Ware House (EDW).
  • Responsible for testing Micro strategy Reports by running the SQL Queries on the database by reviewing the report requirement documentation.
  • Exported the results through SQL and documented the test results for test cases, suites executed.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Involved in promotion of Informatica code and Unix Shell scripts in development and testing phase.
  • Involved in extensive DATA validation using SQL queries and back-end testing

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using ALM for Functional and Regression Testing.
  • Tested functionality of the application by inserting various check points like standard check points, text check points, table check points, image check points, and database check points in QTP.
  • Created, enhanced and maintained high-end test scripts for various functional and regression using Quick Test Professional and VBScript.
  • Developed automated test scripts using VB Script to perform Functional and regression testing in QTP.
  • Actively participated in test case automation using a structured, key word driven framework with QTP.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Agile Methodologies. Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
  • Involved in multiple projects and participated in meetings with SME and Business Analysts. Conducted Validation and Verification of bug fix.
  • Performance CRUD operation and verification ACID Properties with SQL.
  • Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables.
  • Intensively conducted Functionality, User Interface, Security, and Regression testing during the various phases of the development using Quality Center.
  • Published the final test results as test metrics and upload to specified links where project team has access to verify results
  • Monitored adherence to quality standards in development, testing and business processes and able to produce quantifiable metrics to measure success
  • Assisted user testing of systems (User Acceptance Testing), developing and maintaining quality procedures and ensuring that appropriate documentation is in place.
  • Conducted Functionality testing during various phases of the application using QTP.
  • Performed various types of testing such as Functional, Regression, SIT, UAT, and Backend.
  • Creating Automation Scripts (VBScript) in the sprints and stored them in the Test-Plan module of ALM/Quality Center.

We'd love your feedback!