We provide IT Staff Augmentation Services!

Sr. Qa Automation Engineer/tester Resume

DenveR

SUMMARY:

  • 7+ years of Software Testing, Development and Quality assurance of Client/Server and Web based applications using Win Runner, Load Runner, Test Director, Quality Center, Quick Test pro and Manual testing.
  • Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
  • Experience in writing automated scripts, designing Test procedures, Manual Test cases And preparing Quality feed back to QA team & manager
  • Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policycenter and Paymentmanager in Guidewire application based on the business requirements using LISA.
  • Expertise in using automated tools like Load Runner, and QTP
  • Exposed to diverse business processes, that includes Investment Banking, E-business, Banking, Mortgage, Research Groups and Service Industry sector.
  • Proficient in Testing methodologies, Test Matrices and Trace matrix
  • Extensive experience in Functional testing,, Integration testing, Regression testing, GUI testing, Back-end testing, Browser Compatibility testing, Ad-hoc testing, Black Box Testing, White Box Testing, System Testing, Build Verification Testing, User Acceptance Testing.
  • Expertise in Manual Testing of applications developed on Windows and UNIX Environment
  • Knowledge of basic UNIX commands
  • Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.
  • Experienced in analyzing Functional Requirement Specifications (FRS) and conversant with System Design Specifications (SDS).
  • Experience in designing and developing project document templates based on SDLC methodology.
  • Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Excellent working knowledge in design & implementation of all QA Test strategy plans for both Manual and Automation as demanded by the AUT
  • Extensively used L oad Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario
  • Extensively used Test Director & Quality Center to write Test Cases and for reporting. All the Scripts are maintained using Test Director & Quality Center.
  • Extensively uploaded test cases from MS Excel, MS Word to Test Director & Quality Center.
  • Experienced in Bug Tracking System and Process.
  • Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
  • Strong in manual testing, Automated testing in Visual Basic & other protocol of automation tools Experience in testing applications under. Net, Windows.
  • Proficient in Database (Oracle, SQL Server) testing skills using advanced SQL, PL/SQL
  • Versatile team player with good communication and problem solving skills with all management levels
  • High proficiency in Scheduling, Managing resources and activities in QA Teams
  • Present and train team members on tools obtained
  • Setup and maintain QA Test Lab for testing & maintenance.

TECHNICAL SKILLS:

Operating Systems/Languages: LISA,Windows 98/ME/XP, UNIX, C, C++, JAVA, SQL, VB 6.0

Quality Standards: Implementation knowledge of ISO 9001 & ISMS (Info. Security Management System)

Testing Tools: Mercury Interactive Win Runner 7.6/8.0, Load Runner 7.8/8.0, QuickTestPro 6.5/8.0, Test Director 7.6/ 8.2, Quality Center 9.0

Conversant with Web Technologies: HTML, ASP, XML, DHTML, VB script, Java script, Java Servlets, JDBC, Applets

Documentation Tools MS: Office, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential, Denver

Sr. QA Automation Engineer/Tester

Roles/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.
  • Exposed to and worked with Subject Matter Experts in Fixed Income Annuities, Equities, Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing, Derivatives.
  • Created user interface using ASP.NET Web Forms and controls
  • Assists Web Developers with development and maintenance of web sites and applications using ASP.NET, SQL, HTML, CSS, Javascript, AJAX, Flash, ActionScript.
  • Conducted requirement analysis techniques such as Business Process Automation, Business Process Improvement, and Business Process re-engineering.
  • Regular interaction with the core developers helped us in fixing the defects in less time.
  • Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
  • Manually tested the forms, generated the reports and also integrated various modules
  • Designed and developed Use Cases and UML models using Microsoft Visio
  • Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
  • Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Created automated Load test scripts using Load Runner.
  • Tracked change requests and monitored workload and schedule
  • Conducted GUI and functionality testing using QTP.
  • Prepared a test strategy and test procedure to best test the application in a given timeline
  • Analyzed the already developed framework for developing as well as executing the automated scripts.
  • 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.
  • Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
  • Involved in full life cycle of Business Objects reporting Application.
  • Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
  • Played key role in defining test automation procedure and standards, creating Win Runner and QuickTestProfessional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
  • Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
  • Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members
  • Written Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups
  • Developed the Automation Framework for QTP Functional testing and End To End scenarios of the system
  • Performed Load and Stress Testing using Load Runner.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • 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.
  • Created test scripts for all the test cases in PL/SQL.
  • 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.
  • Created Use-Case diagrams and State diagrams using MS Visio.
  • Preparing Weekly action report & QA feed back to QA team & Manager.

Environment: Web Logic, Java, Python, Quick Test Pro 8.2,.NET. MS Visio, MS Office, Mercury Quality Center 9.0, Load Runner 8.2, Sun Java, MSJVM, Oracle 8i/9i/10g, SQL Server 2000, DB2, MS-Project 2000/2003.

Confidential, VA

QA Automation Engineer/Tester

Responsibilities:

  • Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
  • Followed software testing methodologies and plans to ensure software product quality.
  • Design and develop new processes to handle the merger between the clients and ultimately establishing the operational general ledger on the target platform
  • Extensive experience as an Automation Testing Specialist using tools like Quick Test Professional, LISA, Test partner, Win Runner and good knowledge on Load Runner.
  • Extensively worked in designing the Testing approach for the ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP).
  • Conducted Performance testing using QTP.
  • Used SQL to test various reports and ETL load jobs in development, QA and production environment
  • Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
  • Involved in testing the Automation process of the Application using QTP
  • Used mocked up data and TOAD to create and execute SQL scripts for back-end data validation.
  • Analysis of Mortgage Processing workflow
  • Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
  • Conducted GUI and functionality testing using QTP.
  • Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
  • Respond to user requests, troubleshoot dashboard/report issues, document procedures, design, develop, implement and maintain complex Business Intelligence applications
  • Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
  • Studied the application flow, data to be used for exercising the different functionality’s and created Test cases for functionality.
  • Performed backend testing using SQL queries and analyzed the server performance on UNIX.
  • Executed SQL Queries to retrieve data from tables and to create views and perform backend testing
  • Prepared test scripts for automated testing using QTP
  • Performed Web Services testing and Validated XML request response data using ITKO-LISA.
  • Performed functionality testing using QTP
  • Experience with Web Services Testing Using LISA.
  • Developed Business Requirement Document (BRD), Functional Requirement Document (FRD), ETL Specifications and Report Specification Document (RSD).
  • Develop and execute scripts to test data migration using SQL and UNIX Shell Scripting
  • Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
  • Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
  • Execution of PL/SQL on MS-ACESS in order to view successful transaction of data.
  • Validated database contents using SQL Queries.
  • Used Bug zero to report the defects and reports in weekly team meetings.
  • Defined Quality Assurance requirements, and established advanced testing standards and methods. Designed and developed a full life-cycle hardware and software test environment.

Environment: Microsoft Office Suite, GuideWire, MS Visio, Java, C, QTP, Windows NT, Quality Center, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner

Confidential, Chicago, IL

QA Automation Engineer/Tester

Roles/Responsibilities:

  • Developed SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and ability to perform data validation (of ETL processes, schema and DDL check, data flow from data warehouse to application databases, data marts, return marts, referential data, repositories).
  • Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
  • Profound knowledge of web services testing using SOA (Service Oriented Architecture) tools SOAP UI,SOAP UI Pro, ITKO LISA.
  • Written Java Scripts for asserting the various Filter values in Lisa.
  • Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.
  • Responsible for construction, testing and implementation components of the business intelligence development life cycle.
  • Reviewed test assignments, developed test plan and scripts, and conducted tests as assigned.
  • Executing the jobs and validating the reports and output files as per Test Cases
  • Review and analyze all major conversion/migration projects to determine if these projects have any cash clearance and settlements or general ledger impact. Once the impact is determined, help project team in developing a viable process to handle all cash settlements and general ledger related activities including balance moves from the current general ledger system (JPMC) to target system (SAP).
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
  • Parameterized the scripts by running the same operation with multiple sets of data in QTP.
  • Maintain test matrices on various dimensions like client and test status to reflect the test progress.
  • Enhanced the script using different checkpoints like Text output value, Table checkpoint in QTP
  • Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
  • Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties.
  • Involved in Functional Testing, Integration Testing, Business Process Validation, Load & Performance Testing, Virtual Service Environment, and Continuous Validation Service using ITKO LISA Tool with combination of HP tools.
  • Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
  • Used Quick Test Pro’s Data Table, to manipulate the data sets and create multiple test scenarios.
  • Responsible for business units consolidated general ledger inclusive of preparation month end closing, including adjusting, closing and balancing accounts, journal entries, account reconciliations, inter-company analyses, and balance sheet, income statement, and cash flow analyses
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Coordinating with other teams like planning, applications, Environment and Media
  • Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Worked on trouble ticket process for the releases using Quality Center.
  • Involved automated activities to improve the existing processes.
  • Performed backend testing using SQL queries and analyzed the server performance on UNIX.
  • Analyze the functional requirements, writing test cases for each and every object. Using test specs and test frames created, automated the test cases using Test Director.
  • Involved and responsible for creating weekly status reports regarding the progress of testing process.

Environment: Mercury Tools (Win Runner 7.0, Test Director 7.0/7.5, QTP, UNIX, Load Runner 6.5/7.0, Quick Test Pro 6.5, Quality Center 9.0), NT/00, SQL, SQL Server, XML

Confidential, Cleveland, OH

QA Tester

Roles/Responsibilities

  • Involved in gathering Business Level Requirements and reviewed manual testing methods
  • Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
  • Responsible for writing Test cases to cover overall quality assurance using Test Director
  • Performed initial manual testing of the application as part of sanity testing
  • Planned, coordinated, and directed research and facilitated the computer-related activities of the firm using .Net technologies (ASP and VB), FileMaker Pro, MS SQL Server 2000 and SDLC concepts.
  • Performed various tests such as positive, negative to check business functionality manually
  • Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
  • The tests also included GUI testing: Testing for validation and display of screens
  • Created dummy accounts on our system and verified the account generation process and date integrity
  • Prepared complex queries to retrieve data for database testing
  • Created and enhanced TSL scripts using Win Runner
  • Created various checkpoints in the script using Win Runner
  • Created reports using Mercury Interactive Test Director
  • Application and network performance testing analysis
  • Developed Shell Scripts to automate loading processes
  • Writing shell scripts to run batch processes and to run Oracle background\Processes
  • Used SQL queries to test the integrity of data by querying the database
  • Interacted with the development team to assure that all the defects are addressed in time
  • Participated in the team meetings to discuss the issues arising out of testing

Environment: - Win runner, Test Director, Windows 2000 Professional, SQL

Hire Now