We provide IT Staff Augmentation Services!

Qa Analyst Resume

Salisbury, MD

EXPERIENCE SUMMARY:

  • 6+ years of work experience in Software Testing to delivering critical solutions on various levels of Quality Assurance.
  • Having extensive Knowledge in SDLC and STLC.
  • Extensive experience in Manual Testing, DWH/ETL Testing, BI Repots testing, System Testing, Alpha and Beta Testing (UAT).
  • Good experience in Automation Testing Using HP tools QTP and HPQC.
  • Involved in Functionality Testing, GUI Testing and Regression Testing.
  • Good in writing SQL statement & ETL testing.
  • Extensive experience in HPQC 10.0 & HP ALM 11.0
  • Experience in deriving Test Cases from Business Requirements (BRD), Functional Specifications (FSD) and Technical Specifications (TDD) and Mapping documents (ETL).
  • Expertise in defining, creating, documenting, verifying, and executing test cases and work with development team to resolve Application issues.
  • Very good understanding about Bug Life Cycle or Defect Life Cycle
  • Preparing Test plan, Test strategy, Test Report and Test metrics
  • Good experience in Service Oriented Architecture (SOA), Agile Methodologies (Scrum) and Test Driven Development.
  • Good Knowledge on web services (RPC, SOAP & REST) and Data warehouse (DWH) and ETL tools.
  • Good work experience on UNIX (HP, AIX & Solaris) and Windows platforms (NT/2000/ XP)
  • Good understanding on Retail, Healthcare & Financial (Pricing & Payments) domains.
  • Good understanding of Entity Relationship Models and ER - Diagrams.
  • Extensive knowledge of the relational database concepts like Tables, Primary and foreign keys, views proficient in the data manipulation using SQL for the retrieval of data from the relational database (inner joins, outer join, group by, order by, etc.) using SQL Editor and TOAD Environment.
  • Good knowledge and work experience on data analysis & validation - and generates reports and bar charts by using Power Pivot tool.
  • Good understanding knowledge on various programming languages, concepts and tools & technologies.
  • Strong expertise in MS suite like MS Word, MS Excel, MS Project and Visio
  • Excellent inter personal and communication skills with flexibility of working both individually and as a team member.
  • Quick to learn and adapt to new skills, tools and techniques.

SKILL SET SUMMARY:

Operating Systems: Windows 95, Windows Server 2003 & XP, UNIX (AIX/Solaris/HP)

Test Management Tools: Test Directory, HP Quality Center, Enterprise Architect

Test & Tracking Tools: Manual Testing, QTP, Load runner, Win Runner, Rational Robot, HPQC & HP-ALM

ETL Tools: Informatica 8.6.1 & Data Stage

ETL Reporting Tools: Cognos BI 8.3 & Business Objects

Web Services: RPC, SOAP, REST & SOAPUI

Databases: Oracle, Informix, SQL Server & Teradata

Scripting Languages: HTML, JavaScript, XML, Shell & VB (Visual Basic)

Languages: Pro*C, ESQLC, C, C++, Java, .Net, C# and Oracle (SQL)

Other Tools: Clarity, WRM, Version One, VSS, PVCS, SVN, TOAD, Eclipse, HALO, Tivoli, UC4 & HP RM

Microsoft Tools: MS Office, Word, Excel, Visio, PPT, MPP & Power Pivot.

PROFESSIONAL EXPERIENCE:

Confidential, Salisbury, MD

Role: QA Analyst

Responsibilities:

  • Gathering business knowledge and understanding business specifications & requirements.
  • Developing test cases & scenarios based given BRDs.
  • Review of Test cases with key stake holders and amendments as per review comments.
  • Test case execution and test results monitor & validations
  • Generate test results summary report and update the test case traceability excel.
  • Interaction with client Team and SMEs for clarifications on open issues and outstanding defects.
  • Walk through on HP sprinter and its usage.

Tools &Technologies: HPQC, HPALM, Oracle11.2g, Windows, MS - excel, Visio & power point.

Confidential, Bentonville, AR

Role: QA Analyst

Responsibilities:

  • Gathering business knowledge and understanding design specifications.
  • Involving in Data Verification and Validation through the source to Target tables to confirm correct implementation of the changes
  • Developing test scenarios based on the knowledge obtained from the existing system & given BRDs.
  • Prepares test cases by analyzing the transformation rules & mapping document.
  • Prepares Test data for the Positive and Negative scenarios.
  • Converting the test cases into SQL scripts, executing them and logging defects in HPQC if any issues.
  • Review of Test cases, validating test data, monitoring Test execution and Test results
  • Generated Defect log, Traceability matrix and Test Summary Report
  • Interaction with client Team and SMEs for clarifications on open issues and outstanding defects.
  • Performing integration test once changes deployed in different environments (QA and UAT)
  • Ensures the testing cycles are completed on or before scheduled deadline and notified QA Lead and project team of bottlenecks and any outstanding issues

Tools &Technologies: Informatica, Informix SQL, HPQC, Cognos 8.3, Windows Server 2003/XP, HP-UNIX, C & ASP.Net

Confidential,  Chicago, IL

Role: QA Tester + Data Analyst

Responsibilities:
  • Track data over time
  • Identify patients who are due for preventive visits and screenings
  • Monitor how patients measure up to certain parameters, such as vaccinations and blood pressure readings
  • Improve overall quality of care in a practice
  • Working closely with SMEs, BA’s and Dev Team to understand the business requirements to fulfill the testing needs.
  • Preparing high level test scenarios based on SRS and detailed test cases based on BRDs.
  • Working on the Environment setup to get it ready for testing.
  • Manual execution and Automation testing by using automation tools QTP, QC for the ongoing features and functionality changes of the application.
  • Preparing Test Specification document for each release.
  • Conducting peer reviews of test cases and team meetings to discuss on open issues/defects.
  • Review of all defects which were raised by team in Quality Center.
  • Working with Dev team to follow-up on open defects.
  • Incident management, arrange and attend the meetings for key issues and update the status about the health of the application and continuously strive in improvement of the application.
  • Analysis on production data and validation for data quality & reports
  • Extract and transform data into PowerPivot tool and generates pivot reports and charts to senior leadership about store, region, state level business and

Tools & Technologies: MS SQL Server-2008, HPQC, QTP, ASP.Net, MS Office-2010, MS Visual Studio-2010, PowerPivot & Windows7.

Confidential

Role: QA Analyst

Responsibilities:

  • Gathering business knowledge and understanding design specification.
  • Involved in Quality Analyses of the new/updated jobs with the business rule updates.
  • Involved in Data Verification and Validation through the source to Target tables to confirm correct implementation of the changes
  • Designing test cases and converting them into SQL and executing them in QC.
  • Worked on creation of Test Plan and Strategies along with the QA Lead.
  • Developing test scenarios & test cases based on the knowledge obtained from the existing system.
  • Executing test cases using SQL scripts in Toad and logging the defects.
  • Generated Defect log, Traceability matrix and Test Summary Report
  • Interaction with client calls for clarifications and issues. Attending status call to discuss about outstanding defects and issues.
  • Preparing test execution report and sending to business team at the EOD.
  • Involved in peer review within the team and also coordinate with the onsite and bridge the gap between onsite and offshore.
  • Review of Test cases, validating test data, monitoring Test execution and Test results
  • Performing integration testing of the application once it is deployed in different environments (Dev, QA and UAT)
  • Analyzing and reporting the issues identified in sanity check in Quality Centre.
  • Resolving application specific deployment issues and ensuring that offshore team is not blocked

Tools & Technologies: Data Stage, UNIX, HP Quality Center, Oracle 10g, Toad and Windows Server 2003 & XP

Confidential

Role: QA Analyst

Responsibilities:

  • Working closely with Development team and SMEs to understand Business Requirements, functional specification and design documents to ensure testability.
  • Developing Test Cases from BRD, FSD & DDD.
  • Build, execute, and maintain Integration test harnesses, test scripts as assigned.
  • Performing Integration test and ensure all services developed are well integrated according to the specifications
  • Provide system and applications support to users including troubleshooting and issue resolution. Ensure fixes and changes are adequately tested.
  • Working on day to day issues and coordinate with development team as necessary.
  • Actively participated weekly status calls with onsite team to discuss on the project status and issues.
  • Worked on the Environment setup to get it ready for Testing.
  • Execution of detailed test cases and test results validations and verifications.
  • Organized weekly defect status calls with all stake holders to discuss on open defects.
  • Identified data dependency, environment setup, and configuration details related to testing during test case development.

Tools &Technologies: MS SQL Server-2008, MDM, Soap UI, XML, Enterprise Architect, Business Objects and Windows Server 2003 & XP and UNIX

Confidential

Role: QA Tester

Responsibilities:

  • Analyzing existing data environment and involved in preparation of roadmap for migration strategy to Teradata
  • Understanding the mappings in Informatica according to functional/application areas to load the data from source to target tables.
  • Validations on transformations like Source Qualifier, Lookup, Aggregator, Expression, Filter and Sequence Generators, etc.
  • Performance validations on the Informatica Mappings and code for high and robust.
  • Identify Test scenarios, cases& strategy for the history/incremental data.
  • Preparing detailed test steps and executing them
  • History/Incremental Data validation.
  • Test execution on change candidates and developed new strategy for the ETL jobs and/or new ETL jobs.

Tools &Technologies: Informatica 6.2, Teradata V12, UNIX (AIX), HALO, UC4, HPQC, Windows Server 2003 & XP

Hire Now