We provide IT Staff Augmentation Services!

Sqa Project Analyst/tester Resume

Columbus, OH

SUMMARY:

  • Over 6 years of experience in Enterprise Software Quality Assurance (QA), automation and manual testing, Managing test planning and test strategy, QA Analyst, Web Service automation testing, Back - end job flow testing using ESP scheduler, End to End ETL/Data Warehouse test and development using Informatics and related databased technology.
  • 1 Year as lead QA Analyst for currency upgrade project using Linux, Oracle, Shell script, Basic Automation using ruby cucumber, ESP Scheduler at Confidential, Columbus OH
  • 2 Years in project test strategy, test planning and execution of on-line Web Interface using web technologies, Web Services automation using SOAP UI Pro and SQL & backend database at Confidential
  • 3 Year in testing planning, QA analyst, project test strategy, end-to-end test execution of data warehouse system using ETL, Oracle, PL/SQL, SQL and Unix at Confidential Investment, PA

TECHNICAL SKILLS:

Methodologies: Agile, Waterfall

Operating Systems: Windows 2000/XP/7, UNIX/Linux

Bug Tracking: HP Quality Center, Jira

Middleware: RESTful Web Services, SOAP UI Pro

Databases/Tools: Informatica 9.1/8, Oracle 9i/10g/11g/12c, TOAD

Languages: HTML, SQL, PL/SQL, Ruby, Cucumber

Software Package: CA Workstation (ESP Scheduler), ServiceNow, Splunk (Log Analysis)

PROFESSIONAL EXPERIENCE:

SQA Project Analyst/Tester

Confidential, Columbus, OH

Responsibilities:

  • Developing test strategy documentation and getting review/approval from stakeholders
  • Building dependency matrix for each application component so that end-to-end dependency can be identified for smooth migration without blockers.
  • Unix Shell programming and Linux/Unix commands
  • Test data setup and Informatica workflow execution, validation of workflow mapping and target database
  • Building test suite for application and review of regression test suite.
  • Review of Unix shell scripts, ESP Jobs and database migration and performing impact analysis.
  • Performs functional, Regression, System Integration, User Acceptance
  • Log Analysis and application health check review.
  • Coordination with external team’s test leads for dependencies and execution of test cases and managing decencies.
  • Performance and non-functional testing
  • Develops and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
  • Conducts variance management by analyzing and verifying test results, providing status and progress reports
  • Uses Agile in daily scrum/standup. Review work done, pending work, what are we doing today, what we did yesterday, any blocker for test data or defect blocking future testing, goal for today etc.
  • Microsoft Word, Excel, Power Point, Visio for writing test document, requirements, test cases, test data, test strategy
  • Visio for business process flow walk through end to end.
  • Power Point for presentation and show and tell of what is tested overview of the end to end testing and gain approval from stakeholders
  • Test data management through SQL
  • Used SQL for fetching the data from database using sql queries, complex query join for relational data
  • Tracks defects and life cycle management in Quality center
  • Used SharePoint to store documents
  • RTC to store manage stories and approval
  • Followed SQA best practices for all phases of testing using Unit, system, user acceptance testing
  • Implements Agile testing practices and test planning
  • Analyze requirement carefully against the business use cases
  • Identify gaps early and highlight so that we catch gap early in the process and avoid rework later, save cost

Environment: SQL, Oracle 11g/12c, Toad, Quality Control, SOAPUI Pro 1.4, Unix, ESP, Informatica ETL

SQA Analyst

Confidential, Wheeling, West Virginia

Responsibilities:

  • Reviews requirements for testability and usability, consulted with development and business team for system functionality
  • Executes testing for online security questions and authentication
  • Perform usability and digital content testing in various browsers and operating system, mobile devices.
  • Performs SOAP/RESTful Web Services automation testing using SOAPUI Pro
  • Builds the xml and JSON request payload for RESTFul Web Services and testing, verification of web service response
  • Performs functional, user experience, Regression, System Integration, User Acceptance
  • Configuration and content testing for web-based online application
  • Performance non-functional testing in various browsers and operating system
  • Tests application security features, including session expiry, book marking, passwords and compatibility across multiple browser types
  • Develops and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
  • Conducts variance management by analyzing and verifying test results, providing status and progress reports
  • Creates test cases, test plans, executed database queries for testing purposes
  • Uses Agile in daily scrum/standup. Review work done, pending work, what are we doing today, what we did yesterday, any blocker for test data or defect blocking future testing, goal for today etc.
  • Visio for business process flow walk through end to end.
  • Power Point for presentation and show and tell of what is tested overview of the end to end testing and gain approval from stakeholders
  • Test data management through SQL
  • Used SQL for fetching the data from database using sql queries, complex query join for relational data
  • Insert, update, delete SQL for data updates
  • DDL statement to create alter table using SQL
  • Manages test case using Quality Center
  • Tracks defects and life cycle management in Quality center
  • Used SharePoint to store documents
  • VSS to store version control documents followed SQA best practices for all phases of testing using Unit, system, user acceptance testing
  • Performance testing to make sure that customer get quality system
  • Measures testing effectiveness by logging all production defects comparing month by month
  • Test automation of Web Services and most of the UI component
  • Security testing of application
  • Implements Agile testing practices and test planning
  • Analyze requirement carefully against the business use cases
  • Review with all stakeholders for completeness and approval

Environment: SQL, Oracle 10g, Toad, Web/App Server, HTML, Quality Control, SOAPUI Pro 1.4, Google Chrome REST Client, Splunk (Log Analysis)

Informatica ETL QA Analyst

Confidential, Oaks, Pennsylvania

Responsibilities:

  • Verified business requirements and functional specifications
  • Analyzed database and understanding the data model
  • Executed Informatica Workflow, deployment of workflow and processing from OLTP database to Decision Support Database (DSS) and testing of workflow
  • Compared the source and target data and identifying gaps and defects
  • Tested workflows and unit and system testing
  • Conducted system functionality testing: developed and executed test cases, produced problem reports, suggestions, system test logs, and test incidents reports
  • Involved in code and deployment document reviews
  • Used Agile for Biweekly team planning, stories review, estimation for testing, development/build. Discuss dependencies, sequencing. Prioritize stories to be build and tested both from business and IT
  • Responsible for end to end DSS database ETL which is used to generate reporting and statement
  • Tested the statement print process end-to-end
  • Executed the print job (execution only).These were written by develop, comparing the customer data in the database and on the statement. Test script and execution using Quality Center
  • Mapped requirement and test case and getting approval from business partner using Quality Center
  • Used SQA best practices on all phases of testing
  • Compared logs from month to month to measure testing effectiveness
  • Used Agile Methodology for testing practices and test planning
  • Created the Test Process/Support Documentation
  • Identified gaps early to prevent rework
  • Mapped requirements to test scenario/test cases
  • Understand nonfunctional requirements
  • Performed end of day test batches using Informatica

Environment: Informatica Power center 8.1, SQL, PL/SQL, Oracle 9i, Quality Control

Hire Now