Sr. Qa Testing Analyst Resume
Reston, VA
OBJECTIVE
- Looking for a fulltime position as a System Analyst in an exciting and fast paced IT environment where I can use my work experience, technology expertise, communication skills and leadership qualities to optimize the quality assurance environment.
SUMMARY
- PMP certified Detail Oriented Quality Assurance Professional with extensive experience in Manual Testing, Automated Testing and Quality Assurance of Web based and Client/Server based applications.
- Extensive Experience with data analysis including data modeling, data mapping and data validation.
- Expertise in managing requirements and traceability using Doors.
- Expertise in using Clear Case for version control of all development (code and non - code) artifacts.
- Extensive experience in using Clear Quest for issue and defect tracking, deployment request tracking and change request tracking.
- Strong experience in many phases of the testing cycle including documenting and translation of functional specifications to test objectives.
- Proficient in analyzing functional specifications, writing detailed test plans, test cases, execution of test scenarios, automation of test cases for integrated, regression and system testing, analyzing results/reports and bug tracking.
- Extensive experience on Functionality, GUI, Regression, Integration, System, Database, Performance, Stress, User Acceptance, Volume and Load testing.
- Good experience in Developing Test Plans, Test Cases (Manual/Automated), Test Procedures, Test Strategies, Test Suites, Test Scripts and Expected results.
- Created and edited complicated automated scripts.
- Expertise in Unit Testing and User Acceptance Testing.
- Hands on experience in the entire QA Life Cycle which includes Design, Development and Implementation of the entire QA process.
- Experience with User requirements, Business requirements and Use Cases analysis.
- Skilled in creating and performing data driven tests for checking positive and negative test scenarios using automation tools by using test data provided.
- Well versed in back-end testing using SQL queries, generating reports to ensure Data Integrity and validate business rules.
- Managed Requirements, Test Plans, and Test Cases using Test Director.
- Excellent working knowledge of MS Access, SQL Server, DB2 and Oracle Databases.
- Excellent knowledge in every phase of Software Development Life Cycle (SDLC) and strong basic programming and analytical skills.
- Proficient in Oracle table manipulations using SQL.
- Extensive experience on Win Runner and Load Runner.
- Highly motivated individual with strong communication skills, ability to interact with Developers, Users, Peer groups, Customers, Business and Technical peers.
- Excellent ability to handle multiple tasks, works well independently as well as with-in a team.
TECHNICAL SKILLS
Operating Systems: Windows XP/2000/ME/7/8, Windows NT4.0, UNIX/Linux
Software: C++, JAVA, WinRunner, UNIX Shell Scripts, Load Runner, SQL, PL/SQL, SQL *PLUS, C
GUI: Visual Basic, Developer 2000 (Forms 4.5, Reports 2.5), AutoCad
Databases: Oracle 10G/11G, DB2, MS Access, MS SQL server
Packages: MS Office suite
Functional Testing: Win Runner, Quality Center, Test Director, Clear Case, Clear Quest, QTP
Load Testing Tools: Load Runner
Internet: HTML, JavaScript
Specific expertise include: GUI Testing, System Specifications Analysis, Functionality/Integration Testing, 508 Compliance testing, Regression testing, Back end/Front testing, User Interfaces and Business Requirements Analysis, Performance/Stress Testing, Load Testing, Technical Training, System Testing
PROFESSIONAL EXPERIENCE
Confidential, Reston, VA
Sr. QA Testing Analyst
Responsibilities:
- Worked on numerous cross platform applications, organized Joint Application Developments (JAD),Joint Requirement Planning sessions (JRP), Interviews and Workshops, Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group
- Field Validation Testing, Functionality Testing) of UI and Web Applications. Extensively worked in creating Test Procedures, Test plans, Test cases and reviewing them for quality assurance. Tracking defects and interacting with team members in fixing errors. Worked on both Black box and White box Testing.
- As a key part of the IR2 System test team responsible for creating test scripts, test cases and plans to support all software testing activities.
- Reviewing requirements and design documents to ensure adequate understanding to develop test cases and test scenarios.
- Attending Internal and External reviews, uploading the test cases in Quality Center and executing them.
- Validating data in the tables by writing SQL queries and verifying the results.
- Responsible for defect tracking and entering/reporting them in Clear Quest.
- Reviewing the functional requirements in DOORS.
- Work with development teams investigating and correcting software bugs and deficiencies based on the testing results.
- Lead a small QA team in the creation and preparation of Test Plan and Test Strategy and conducted quality assurance reviews of test cases and test scripts.
- Developing and maintaining RTM through the project life cycle.
- Participate in daily DRB (Defect Review Board) meetings with developers and manager.
- Designing and developing Test Plans and Test Cases in Quality Center based on the Business requirements and mapping documents.
- Performing software testing of applications and computer systems based on defined requirements.
- Use SQL queries extensively for backend testing and to identify the test data using Toad.
- Issue reporting & tracking using Clear Quest tracker and coordinate with development team.
- Meeting with Business Analysts to define, document and review functional and technical requirements.
- Worked with Project Managers, Senior Management, and other stakeholders to define project goals, scope and define requirements.
- Facilitated and managed meeting sessions with users and SMEs to review business requirement.
- Conducted detailed and comprehensive business analysis by working with other BA’s, IT developers, financial analysts and end-users, in order to identify system and operational requirements and improvements.
- Led and guided team to write requirements for future releases of the project as well as requirements management.
- Created system requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives
- Assisted the PM with MS Project plan and updating it periodically
- Coordinating with different teams to get the weekly updates and project tasks.
- Involved in regular reports, feedback and communication with the management, coordinating the team members and maintaining the project log Presentation, delivery and documentation of project.
- Participated in project review meetings to resolve defect related issues. Managed defects in Quality Center
Environment: Java, Unix/Linux, Windows NT, IE, PL/SQL, XML Spy, QTP, DOORS, TOAD, Oracle 10g, Oracle 11g, MS Access, Clearquest, Clearcase, Quality CenterSAIC Inc, Oct '06 to April '11
Confidential, McLean, VA
Lead System Tester and QA Analyst
Responsibilities:
- Responsible for the entire testing of all Safe Drinking Water Information System (SDWIS)/STATE components for the EPA.
- Duties included composing test plans, test scenarios and completing test assignments such as the testing of SDWIS STATE on different platforms such as Windows NT, Windows 98, Oracle, DB2 & SQL Server. Analysis is achieved using Oracle, Auto tester, and MS Access.
- Reviewed test plans and specifications to ensure adequate test coverage. Reviewed Design, Business and Functional Requirement documents.
- Interacted with System engineers and System Architects on issues with these documents.
- Also performed functionality testing of the Monitoring, Non-compliance, Sampling, Inventory, Legal Entities, Enforcement and System Admin components of SDWIS/STATE.
- Worked as the primary tester for SDWIS/STATE on different databases testing user support events and create data to run Compliance Determination (batch based process) reports in addition to being major contributor to the User Support Team.
- Tested complex functionality associated with the Total Coliform Report Compliance Determination component.
- Analyzed business rules and modified XML files included in test suite using XML Spy to test new business rules. Business rules changed whenever EPA issues new guidance on reporting drinking water data.
- Typical business rules were: reference integrity must be maintained in the reported data, data must match the domain reported in the metadata, data must confirm to the permitted level of reporting, data must meet minimum reporting requirements, data must pass all data quality checks and all inventory data that must be submitted before actions data.
- Responsible for incorporating updates into the test scripts and test plans to test new bugs.
- Used Soap UI to test web service calls that returned XML files.
- Tested the MTS 2.0 by creating XML documents to in corporate the changes made in MTS 2.0 and testing the newly added objects in MTS2.0. Also regression test was done for the other objects. This regression test included testing the ability to load multiple objects (Inserts and Changes - i.e. MTS1 0 Run1.xml and MTS1 0 Run2.xml).
- Tested Inventory triggers and CDS triggers. HELP was reviewed.
- Tested the Consumer Confidence Report (CCR) which is a regulatory report with content prescribed by the EPA. It is produced annually for each water system and contains summarized sample and violation information for specific regulatory contaminants.
- Created test data in order to test that the CCR Setup Process will update the fields in TCCCONT with the current levels recorded in SDWIS/STATE, converting them to the units required by the CCR at the same time.
- Created data to test for Turbidity summary and LCR tap summary and the values to be stored in the tables TCCTURB and TCCLCR respectively.
- Also tested the Lead and Copper section of CCR.
- Developed and incorporated Auto tester scripts to test MTS 2.0 and Data Bridge.
- Automated over 200 release acceptance test cases using Selenium IDE/RC.
- Developed and maintained automated (Selenium IDE) regression test of product download.
- Developed test automation projects in Selenium with JUnit.
- Recorded, edited and executed Selenium test cases/suites.
- Worked as Lead tester for ESS (Electronic Sanitary Survey) including planning and developing procedures to test ESS.
- Created queries in MS Access to verify the results.
- Created MS Access queries for each staging table based on the MTS 2.0 structure set documentation.
- The queries were developed for Oracle as well as for SQL Server.
- Verified that all relevant data is extracted from the SDWIS/STATE 2.0 production tables to the ESS staging table in the correct column.
- IT also verified that the counts in the TMG tables matched the count from the MSACCESS queries.
- Tested Data bridge by creating .csv files through the staging tables.
- Responsible for running the csv files through Data bridge to ensure there are no generation errors.
- Downloaded the files in XML format and running them through Migration to verify that the generated business errors are the same as in MTS2.0.
- Created SQL plugins for Oracle and MS Access.
- Test effort also included scheduling the time for testing and writing Release notes for Data bridge.
- Worked as a member of the team that developed 2 state modules of SDWIS using the Agile process.
Environment: Java, Unix/Linux, Windows NT, IE, Firefox, PL/SQL, Auto Tester, Selenium IDE/RC, XML Spy, SQL Developer, JAWS, SQL Server, Oracle 10g, Oracle 11g, DB2, MS Access
Confidential, McLean, VA
Sr System Tester
Responsibilities:
- Worked as Lead tester for ESS (Electronic Sanitary Survey) including planning and developing procedures to test ESS.
- Created queries in MS Access to verify the results.
- Created MS Access queries for each staging table based on the MTS 2.0 structure set documentation.
- The queries were developed for Oracle as well as for SQL Server.
- Verified that all relevant data is extracted from the SDWIS/STATE 2.0 production tables to the ESS staging table in the correct column.
- IT also verified that the counts in the TMG tables matched the count from the MSACCESS queries.
- Tested Data bridge by creating .csv files through the staging tables.
- Responsible for running the csv files through Data bridge to ensure there are no generation errors.
- Downloaded the files in XML format and running them through Migration to verify that the generated business errors are the same as in MTS2.0.
- Created SQL plugins for Oracle and MS Access.
- Test effort also included scheduling the time for testing and writing Release notes for Data bridge.
- Responsible for 2 state modules of SDWIS using the Agile process
Environment: Java, Unix/Linux, Windows NT, IE, Firefox, PL/SQL, Auto Tester, XML Spy, SQL Developer, JAWS, SQL Server, Oracle 10g, Oracle 11g, DB2, MS Access
Confidential, Sterling, VA
Quality Analyst
Responsibilities:
- Analyzed business requirements to write test plans, test procedures and test cases.
- Created test plan and testing based on that created test cases for manual as well as automated test.
- Closely worked with business unit as well as developers to create test data.
- Prepared Automated testing scripts using Mercury Imperatives Win runner tool.
- Test plans and scripts were maintained using Test Director.
- Executed test scripts, analyzed the test results and documented reports.
- Performed regression testing during the various phases of the application and in various environments.
Environment: SQL Server, Oracle 9i, Windows NT, IE, PL/SQL, Win Runner, Test Director.
