Sr. Qa Analyst Resume
O Fallon, MO
SUMMARY:
- Over 8 experience in reviewing and understanding of Business & Testing requirements and writing detailed Test Plans, Test Cases, and Test Scripts.
- Involved in entire QA Life Cycle (SDLC), which includes Design, Development and Implementation of the entire QA process for the Relational Database, Web and Client/Server, IBM Mainframe Applications.
- Excellent working knowledge of designing and implementation of all QA test strategy plans and automated test solutions for client/server and Web applications with Mercury Interactive Test Suite (Load Runner, Win Runner, Quick Test Pro and test Director).
- Strategizing and Leading Performance Engineering to improve the team's methodologies, analysis tools, and workloads and participate in major initiatives to identify bottlenecks, improve performance by examining both software and hardware from the front end to the back end across multiple layers of the system.
- Expertise in planning/executing Black Box Testing for both Client Server and IBM Mainframe applications.
- Performance testing expertise in developing Performance Test plans, Test Strategy, Load Modeling, Performance Metrics and Performance Analysis.
- Knowledge of using automation tools - Win Runner, QTP, Load Runner, Quality Center and Test Director.
- Develop and implement load and stress tests with Mercury Load Runner, and present performance statistics to application teams, and provide recommendations of how and where performance can be improved.
- Well experienced in conducting performance test executions and analyzing the performance test results.
- Worked towards innovation by laying out strategies for continuous integration process by automation using performance testing tools such as SOASTA &Load Runner.
- Involved in capturing and maintaining business and technical requirements as well as capturing and analyzing process of the DB project, which was developed in Java, J2EE and XML environment.
- Identified Disk Usage, CPU and Memory for Web, APP, TUXEDO, Database servers and how the servers are getting loaded.
- Coordinated with WebSphere administration team for build deployment and build releases and involved in testing Java web based application.
- Performed validations on the Mainframe using DB2, CICS, TSO, ISPF, File Aid etc. and participate in determining test environment needs.
- Involved in batch processing of mainframe to update policies and configuration of WebSphere server in test environment.
- Document and communicate environment security requirements to security and involved in data gathering as well as creating and maintaining test data.
- Expertise in deploying J2EE applications on IBM Web Sphere application server thru Admin console as well as thru scripts.
- Experienced in creating data sources and setting up connection pools as well as creation of J2C Authentication aliases.
- Extensive knowledge of Software Development Life Cycle (SDLC), Methodologies (AGILE, RUP), Test Process and Software Testing Life Cycle (STLC).
- Integrating enterprise-wide J2EE applications and deploying using IBM WebSphere Portal Server Application Assembly Tool and managing security policies for different applications.
- Extensive working Experience in using testing methods like Functional, Regression, Integration, System, Security, Initialization, Usability, Database, Smoke/Sanity, End to End and User Acceptance Testing (UAT).
- Experienced in back-end testing using SQL queries, generating reports to ensure Data Integrity and validate business rules.
- Created and performed data driven tests for checking positive and negative test scenarios using automation tools by using test data provided.
- On-call Production Support (24x7), monitoring and maintaining multiple Applications in Development and QA and Production Environments.
- Ability to handle multiple tasks and work independently as well as in a team, having strong analytical and problem-solving skills.
- A good team player with excellent communication and interpersonal skills.
TECHNICAL SKILLS:
Languages: C, C++, Java, VB.NET, ASP.NET, VB
Operating Systems: Windows, UNIX, Linux
Tools: HP QTP/UFT, HPQC/ALM, TestNG, Load runner, JIRA
Databases: Oracle, SQL Server, MY SQL, MS-Access
PROFESSIONAL EXPERIENCE:
Confidential, O'Fallon, MO
Sr. QA Analyst
Responsibilities:
- Worked with business and technology leads to identify the appropriate data for testing, and prepare that data for the test cases.
- Designed and developed performance testing scripts, functions, scenarios, processes for simple to complex testing situations using HP Load Runner.
- Responsible for recording scripts for different business scenario and involved in script enhancement with heavy correlations and parameterization.
- Prepared the test cases for interfacing the Customers, Invoices, and Payments from ORMB to Oracle.
- Gathered performance requirements for the application and designed performance tests for the multiple clients within the organization.
- Focused on risk management and risk mitigation of AML Compliance risk issues to remediate the risk identified by the Regulators, Internal Audit, Compliance and Assurance.
- Creating and maintaining appropriate files which will be reviewed by AML supervisory staff.
- Extensively worked on performance monitoring and analyzed the response time Memory leaks hits/sec and throughput graphs.
- Planning of Test Strategy on how to automate the testing. Selecting the Test Cases for Regression testing and automating the Test Cases using Win Runner.
- Tested all the test cases for the ORMB to Oracle interfaces and tested the concurrent programs that loads the data in to interface tables and the spawned programs that imports the data in to Oracle.
- Performed Regression, Integration, UAT, End to End testing to verify the functionality with the new codes introduced for modifications and/or enhancement using Quickest Pro.
- Customized Load Runner scripts in C language such as String manipulation and using C libraries for the Load Runner Scripts.
- Setup server metrics for Site Scope and Executed multi-user performance tests, used online monitors, real-time output messages and other features of the Load Runner Controller in Load Runner.
- Used SOAP UI web services extensively to retrieve real time data from ORMB application for unit testing.
- Generated, reviewed and updated detailed defect reports in JIRA and also coordinated, prioritized and executed software re-testing of defects.
- Developed and implemented load and stress tests with Load Runner, and present performance statistics to application teams.
- Developed Automated Test Scripts using QTP for Functionality and System Testing and also used Performance Center for Test executions.
- Performed regression testing for the application. Parameterized the scripts and enhanced them according to the test case.
- Performed problem solving analysis and root cause for system functionality and testing challenges using Load Runner Analysis Tool.
- Led Performance Engineering by identifying bottlenecks across multiple layers of the system. Hands-on approach in building, running and working on enterprise performance initiative driven by Performance engineering team.
- Analyzed various graphs generated by Load Runner Analysis and communicated bottlenecks to the system administrators.
- Monitored Net Stat to check the connectivity Load Balance and network traffic in each of the JVM's by using Unix Shell scripting.
- Verified the SOAP message delivery to the web services and verified the XML formatted response using the SOAP UI.
- Worked closely with development team to resolve the defect and ensure that it is resolved and closed accordingly.
Environment: ASP.Net, WCF, Soap UI, Visual FoxPro, Windows, ORMB, SQL Server, Quality Center, XML, HTTP.
Confidential, San Jose, CASr. QA Analyst
Responsibilities:
- Analyzed the Business Requirement and developed detailed Test Cases for different scenarios based on Business logic and System architecture.
- Attended the Business and Functional Requirement Document (BRD) review meetings conducted by BA team to better understand the application functionality and to gather Functional requirement Document (FRD) to create the Test Plan and Test Scenarios.
- Integrated testing with systems such as Windward, ORMB to display available insurance products, benefit summary, and prices to match user criteria.
- Participated in implementing detailed test-plans and test-cases according to the Acceptance Criteria provided by Business Analyst (BA).
- Involved in writing Test Scenarios and Test cases from Design specification documents and based on the requirement, Generate Reports using Tableau.
- Proficient in working with testing tools and carrying out Functional testing, GUI Testing, Integration Testing, Regression Testing, End to End Testing, and UAT testing.
- Hands on experience using ALM/QC to create, organize, execute and maintain test plans, test cases, bug tracking purposes & generate test reports.
- Running load test with anticipated concurrent user load and also using App Dynamic Tool for performance monitoring tool which assists to monitor and manage the applications efficiently.
- Processed the XML response from ORMB to display data to the user in the SQE portal.
- Creating results with goal oriented scenarios like hits/second and throughput and conducting scalability testing and spike testing.
- Creating performance test reports and enhancing the reports with appropriate graphs, merging graphs and customizing the graphs in order to create better understanding.
- Analyzing the Load Runner reports to calculate Response time and Transactions per minute, Hits per sec, throughput.
- Ensure all test plans and test cases created covers the business requirements and meet all standards established by the QA organization.
- Validated Invoices, Debit Memos, Credit Memos, Receipts were in sync between ORMB & EBS systems.
- Involved in creating UAT test scripts and documenting the test steps and testing the web services and schematic user interface.
- Checking the system behavior with multiple values of data for regression testing using Load Runner and enhancing the scripts for Reusability and Modularity.
- Validated XML files against schema using oxygen and update them as required and also involved in testing Web services and XML with tool called 'SOAP UI'. Used this tool to locate WSDL file on internet, create Test cases and execute, run them.
- Conduct backend testing by querying databases with SQL manipulations and check for data integrity and proper routing based on workflow rules at each step.
- Tested whether a new supplier has been set up in oracle AP for the refunds sent from ORMB.
- Involved in defect reporting and assigning the defects to development team through Quality Center.
- Document Test Results in evidence files and attached the test results in Test Lab while executing the test cases.
- Worked with Agile Project management tool called Version One and provided daily updates to the Scrum Master.
- Attending Daily SOS (Scrum on Scrum) and providing the Story status to the Business and also showcase the User story to Concerned Product Owner for the Story Acceptance.
- Lead and Coordinate Quality Assurance offshore / onshore team efforts for the assigned initiative.
- Co-ordinate with Developers for defect analysis and performing Regression Testing and also Conducted/Participated in QA team meetings, defect report meetings, KT sessions and development meetings.
Environment: Quality Center/ALM, Soap UI, Version One, SQL, ORMB, Oxygen, TOAD, Guvnor DB, Oracle, JAVA, J2EE, Web Services, Share point, MS Office, MS Project.
Confidential, Chicago, ILQA Analyst
Responsibilities:
- Reviewed and analyzed various business documents BRDs, FRDs, TRs from several sources and by conducting requirement walkthrough meetings with end users and business analysts.
- Followed the Agile Methodology to emphasize on real time communication over written Documentation.
- Analyzed requirement documents and Use cases to prepare the detailed Test Plans, Test Cases and developing Test Scripts.
- Perform quality assurance, quality control, and security tests for system designs, processes, and security features.
- Maintained central repository to determine the readiness of the application by combining Planning, Execution and Defect Tracking.
- Wrote plenty of test cases to cover the scenarios discussed with business team (Finance/Audit) and setting up meeting for their approvals before testing the data.
- Created and Executed Manual Test cases in feature files and responsible to track and log the Defects using ALM and JIRA.
- Develop test cases and facilitated coordination of User Acceptance Testing (UAT) using Acceptance Test Driven Development.
- Interacted extensively with the business partners during the UAT calls to discuss the constant changing requirements.
- Involved in Analysis and System testing of Object Oriented and ERP Applications.
- Analyzed and audited testing data for AUT to conduct various types of testing such as data driven, end to end and boundary testing.
- Understanding of ERP functionality including Project accounting, Grants, Procurement and Finance.
- Created scenarios, monitored test under load, executed tests and analyzed test result using Performance Center.
- Created and executed scenarios in Load Runner controller to analyze system performance in Load Runner Analyzer under load.
- Used rendezvous concept of Load Runner to generate peak load onto the server thereby stressing it, and measuring its performance.
- Performed requirement traceability by setting automatic alerts for tracing changes in the requirements and system maintenance.
- Performed integration and system testing on all internal applications to effectively work with ERP application.
- Generated various reports and graphs from Quality Center and analyzed the testing process overview.
- Importing requirements, create test cases, validate requirements with test cases and generate reports using Quality Center.
- Created and maintained SQL Scripts to perform back-end testing on the MS SQL server database and also reviewed extensive SQL Queries with complex multi-table joins and nested queries.
- Prepare entry and exit criteria document based on business requirements and utilize it to sign off the stories.
- Participated in daily scrums to effectively communicate the progress, and road blocks in order to deal with the constantly changing requirements.
- Participated in daily defect resolution status calls to discuss defects with vendors, project management and users.
Environment: Windows, Outlook, ORACLE, XML, DB2, Excel, TEST DIRECTOR, MS word, JAVA, Mainframe.
Confidential, NJQA Tester
Responsibilities:
- Developing Test Plan with a Test Strategy for the System testing. Instrumental in creating design and frame work for automation.
- Analyzed the business and functional requirements of the application and also helped in developing detailed test plan and test cases.
- Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
- Helping development team in defining the scope for Unit testing. Although Unit testing is not in the scope of QA efforts but QA team helped delivery team in putting a process in place for Unit testing activities.
- Perform functional testing of the front-end application using Quick Test Professional (QTP).
- Backend testing of the DB by writing PL/SQL queries to test the integrity of the application.
- Involved in testing various New Policies, Amendments, Renewals, and Cancellations etc.
- Involved in end to end testing from Quick Quote to the policy activation in both frond end application and in the mainframe.
- Excellent working knowledge of designing and implementation of all QA test strategy plans and automated test solutions for client/server and Web applications with Mercury Interactive Test Suite (Load Runner, Win Runner, Quick Test Pro and test Director).
- Involved in creating entity and attribute definitions and created physical data model using Erwin.
- Worked with logical, physical, conceptual, star, snow flake schema data model and research in design methods to create scenarios for adequate test coverage.
- Tested the various coverage premiums such as Liability only, Comprehensive and Collision, Comprehensive only, Collision only etc. and verified the calculations based on the premium.
- Worked on documenting Master QA Strategy (a new template per ESDM guidelines). Defining the QA tasks for Java and data intensive projects. Customizing the scope of various QA activities based on nature of projects.
- Extensively involved in the automation of Regression Test Cases by scripting.
- Worked on creating a document on putting a process in place for incorporating Sarbanes - Oxley act to mock up real production data in case of volume testing.
- Actively involved in Source Driven Testing, Target Driven Testing, Business Cycle Testing, Business Scenario Testing and Data Integration Testing.
- Hand on experience on different SQL tools like Query Man was used to test the complex queries.
- Involved in the Production Validation for each Release Project and also took part in post-production support.
Environment: VB .Net, ASP.Net, VB Script, Java, J2EE, C+, IBM, Agile, Oracle, DB2, SQL, PL/SQL, SQL Server, SOAP, HTML, XML, IIS, Quality Center, QTP, Mercury, Load Runner, Windows XP, MS Office Suite, MS Visio, MS Access, MS Project.
Confidential, NYQA Tester
Responsibilities:
- Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
- Throughout the project, was involved in giving clarifications on domain and product functionality for the team.
- Regular interaction with the core developers helped us in fixing the defects in less time.
- Played key role in defining test automation procedure and standards, creating Win Runner and Quick Test Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
- Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software.
- Created automated Load test scripts using Load Runner and also conducted GUI and functionality testing using QTP.
- Conducted data driven testing using QTP to conduct backend testing. Performed White Box testing by using Expediter tool and updated some of the PROCs, JCLs and SAS programs in the Test region. Submitted batch JCLs in order to create output datasets for verification.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- Performed Load and Stress Testing using Load Runner and automated confidence tests that run on new builds on regular basis.
- Involved in setting up different configuration environment for compatibility testing and manual testing.
- Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
- Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
- Involve in preparing Trace Matrix to design test cases.
- Preparing Weekly action report & QA feedback to QA team & Manager.
Environment: Web Logic, Java, Quick Test Pro, Quality Center, Load Runner, Sun Java, MSJVM, Oracle, SQL Server, DB2, MS-Project.
