Senior Qa Analyst Resume
Columbus, OhiO
SUMMARY
- 9 years of extensive experience as QA Test Lead/Senior QA Analyst including experience in Manual, Data Warehousing/ETL, Mainframe and Web testing using SDLC & TDLC processes.
- Full life cycle experience in Quality Assurance including Black Box, system, integration, database, performance, GUI, Functional, Regression, Unit testing, User Acceptance, Smoke testing and Sanity testing of both client - server and web-based applications.
- Proficient in mentoring the team on key aspects of testing, technical, process and product leadership
- Expertise in project management skills by handling all meetings, data analysis, documentation and business reports.
- Effectively able to identify opportunities of improvement and most importantly able to develop and execute solutions.
- Proficient in delivering the desired outcomes for the project by balancing quality, resources and timelines
- Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing on Warehouse Applications.
- Experienced in writing and executing test plans, test cases and test scripts based on the Business requirement document (BRD), performing Regression, verifying test logs, generating output reports, GUI Testing, User Interface, Functional, Integration, performance, System, Application and Web based test.
- Responsible for Manual Testing Process for various Web and Client/Server projects by using HP Quality Center 9.2 & 10.0 as the primary Testing Tools.
- Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing and Production issues/defects ad-hoc and regression testing & support.
- Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
- Involved in QA Process with a complete Knowledge of Software Development (SDLC) and Test Development life cycle (TDLC) from Requirement understanding, Test Scenario, Test case creation, and Test case walkthrough with various Teams.
- Well trained in SAP FICO functional development using ECC 6.0.
- Extensive experience in testing the business processes in ECC 6.0 module FI/CO using SAP.
- Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
- Expertise in Using Microsoft Tools namely Word, Excel, PowerPoint, Outlook, Access, WordPerfect.
- Expertise towards Automation testing using Selenium (Selenium IDE/Selenium RC/Selenium WebDriver/TestNG/JUnit).
- Expertise in creating scripts in Selenium-RC and WebDriver using java.
- Extensively used Microsoft Team Foundation Server (TFS) as a Source Control, Data Collection, Reporting and Project Tracking tool.
- Used SharePoint server as a document management tool.
- Experience in testing applications in Windows Environment.
- Involved in preparation of Test Data to test the functionality of ETLSources Mappings and Targets.
- Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tool such as Quality Center, MS Visual Studio & TFS (Team Foundation Server).
- Extensive experience in SDLC processes such as Waterfall, V, Spiral and Iterative Models.
- Good understanding concepts on Business Intelligence and Informatica Power Center 8.X/7.3 using Repository Manager, Designer, Workflow Manager and Workflow Monitor .
- Exposure to .net technologies such as VB.net, C#.net and ASP.net.
- Highly motivated with the ability to work effectively in teams as well as independently.
- Demonstrated excellent communication skills while interacting with business teams.
- Committed to highest levels of professional and personal excellence.
TECHNICAL SKILLS
Software Packages: MS-Office.
Languages: C, C++, HTML, C#.net, VB.net, ASP.net, SQL.
Scripting Languages: Java script, VB script, XML
Databases: Oracle, MSSQL Server.
Operating System: Windows XP/2000/95/98.
Testing tools: Quality Center, QTP, Selenium IDE/RC/Web Driver and TFS, HP ALM
Data warehousing: Business Objective and Informatica.
IDE: Eclipse
SAP: SAP FI/CO, SAP ECC 6.0
PROFESSIONAL EXPERIENCE
Confidential, Ohio
Senior Test Lead
Responsibilities:
- Managed a team of 15 with 5 test leads and 10 test engineers participating in incremental development and testing.
- Work collaboratively and proactively with QA Team, Development SCRUM teams and others to design and develop effective automation solutions, troubleshoot issues and resolve bugs
- Interacted with Business Analyst and Software Developers for bug reviews and participated in QA meetings.
- Ensure that all quality standards are met by all projects & departments by educating the importance of maintaining industry wide quality standards and benchmarks
- Lead the implementation team to ensure highest standard of quality so that the organization meets both internal and external requirements
- Facilitated meeting between the client and contractors to elicit business requirements and explore solutions and process improvement.
- Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development and testing.
- Monitor and course correct during the execution of the Functional, Negative, Smoke and Regression tests as per design specs.
- Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.
- Prepared and Presented weekly and monthly QA Defect and Status Reports to the various Stake holders.
- Assisted the team in using MS Visual Studio & TFS (Team Foundation Server) as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Defect Management.
- Assisted team in using Selenium WebDriver to automate test scripts process.
- Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language.
- Expertise with Functional testing, System testing, Integration testing, Smoke testing, Expertise testing the application on data driven testing to test the application UI.
- Assisting automation team in performing Regression testing to test the impact of bug fix.
- Worked closely with developers and other staff members to form a unified team.
- Responsible for reviewing load testing plans, running test scenarios, and validating application usage.
- Extensively used SharePoint to maintain the testing deliverables.
Environment: TFS, Agile Testing, Windows, Manual Testing, Oracle, Automation Testing, Selenium WebDriver, Beyond Compare.
Confidential, Mason, Ohio
SAP FICO Test Lead
Responsibilities:
- Gathered, defined and assisted in documentation of financial reporting requirements.
- Involved in functional, business process re-engineering, implementation, designing, customizing, configuring, training, integrating, go-live and supporting using ASAP methodologies and industry best practices.
- Assisted different testing teams to test the third party tool (Vertex) to integrate with SAP ECC 6.0.
- Developed the pre-project work products required for project planning, budget estimation and statement of work.
- Provided guidance and support to in-progress Project Managers in the areas of project planning / project tracking, status reporting, issue management, risk mitigation and role definitions.
- Co-ordinates the testing efforts of multiple projects executed from near shore and offshore.
- Preparation of System Test Strategy, Test Plan and effort estimation.
- Formation of Test Team, distribute the work loads, track the progress.
- Provide detailed project scope and sizing of the projects so appropriate resource is allocated. Validate estimates from consultants.
- Get interlock from other project groups.
- Lead weekly status meetings with the team to monitor progress.
- Monitor development defects. Provide input to drive process improvements as necessary.
- Document any problems and work with the project team to resolve problems identified during the tests.
- Participate in quarterly department meetings with director to prioritize the projects.
- Annual employee reviews.
- Estimate annual development resources, timelines and budget
- Schedule Preparation, Module Allocation, Reviews on Test Process, Client Interaction, Verify Status Reports.
- Reviewed Functional Specifications Configuration, End User Manuals and Testing Scripts documents during the project.
- Reviewed with SAP Configuration Team on created test scripts, scenarios, test data and test conditions in HP ALM.
- Sign off on all test cases in accordance with the stated acceptance criteria by signing the completed test worksheets
Environment: SAP ECC 6.0, HP ALM
Confidential, Columbus, Ohio
Senior QA Analyst
Responsibilities:
- Interacted with Business Analyst and Software Developers for bug reviews and participated in QA meetings.
- Ensure that all quality standards are met by all projects & departments by educating the importance of maintaining industry wide quality standards and benchmarks
- Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables.
- Performed testing activities as a Senior QA analyst and prepared Traceability Matrix with requirements versus test cases.
- Used MS Visual Studio & TFS (Team Foundation Server) as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Defect Management.
- Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
- Involved in front end application testing of source and destination systems.
- Performed Multi Browser Testing across IE, Chrome and Firefox.
- Developed test scripts to automate process of testing in Selenium WebDriver.
- Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language.
- Wrote and executed test cases for major program modules.
- Performed usability, GUI, Functionality and regression testing of the new builds.
- Identified application defects to minimize number of steps to reproduce the problem
- Expertise with Functional testing, System testing, Integration testing, Smoke testing, Expertise testing the application on data driven testing to test the application UI.
- Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
- Performed Regression testing to test the impact of bug fix.
- Used Microsoft TFS to get around Work Items such as Bugs, Tasks.
- Worked closely with developers and other staff members to form a unified team.
- Responsible for reviewing load testing plans, running test scenarios, and validating application usage.
- Extensively used SharePoint to maintain the testing deliverables.
Environment: TFS, Agile Testing, Windows, Manual Testing, Oracle, Automation Testing, Selenium WebDriver, Beyond Compare.
Confidential, Detroit, MI
Senior Test Engineer
Responsibilities:
- Participated in walkthroughs of requirements, specifications, database designs, ETL code, and test strategies
- Analyzed functional specifications. Reviewed Use Case document and BRD to develop comprehensive functional manual test cases and automated scripts for testing functionality of the application.
- Interacted with BA to identify the gaps between requirements and prototype.
- Attend daily status meeting to discuss on requirements, test plan, test data and defects.
- Expertise in importing requirements, creating test cases and validating requirements with test cases and generate reports using Quality Center.
- Manage the testing process, schedule batch tests, log and track defects using Quality Center.
- Participate in review meetings to resolve bug related issues with developers.
- Responsible for through testing of browser and platform compatibility issues.
- Come up with test approach and test scenarios.
- Associated Test cases to requirements in order to ensure that all the functional requirements have been covered in the Test plan.
- Performed automation testing using Selenium WebDriver for web application.
- Developed the Automation Test Scripts.
- Design and execution of test scripts using Selenium WebDriver.
- User-level test automation with Selenium 2.0 WebDriver, Selenium-RC server.
- Developed the test scripts in JUnit using XML.
- Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.
- Conducted Functional Testing, Regression testing, Integration testing to check the system is working according to the requirement specifications.
- Executed End to End test scenarios after all components are integrated.
- Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.
- Wrote the SQL queries & PL/SQL code on COT tables and Data Mart Staging Tables to validate the data results and documented.
- Participated in test case review meetings.
- Gathered Test Input data. Test Input data includes Pre-condition, Test Input, Test Result and Test Regression data.
- Extensively worked on Oracle. Stored, analyzed and prioritized defects using Defects module in Quality Center.
- Analyzed various graphs and reports to make decisions about requirements coverage, test readiness and overall application quality. Reported defects to the developer upon detection of bugs.
- Maintained central repository to determine the readiness of the application by combining Planning, Execution and Defect Tracking.
- Produced daily reports extracted directly from Quality Center documenting the progress of the test execution and the quality of the application.
- Worked closely with developers and other staff members to form a unified team.
- Worked during weekend during Production Implementation to perform Sanity Test, Shakeout testing by doing testing in production environment during User Shakeout process.
- Responsible for keeping Plan view and Share Point sites up-to-date.
- Extensively used SharePoint to maintain the testing deliverables.
- Provide a Go/No Go Decision from a testing prospective for all projects.
Environment: SQL Server 2005, Windows 2000/XP/2003, Quality Center, SharePoint, Selenium WebDriver, ASP.Net, VB.Net.
Confidential
QA Analyst
Responsibilities:
- Involved in reviewing requirements and helped team lead for testing estimates.
- Reviewed test cases for requirements coverage, ambiguity, and completeness
- Organized, prioritized, tracked and controlled requirements usingRequirementsmodule inQuality Center.
- Gathered test data for Functional testing for different scenarios.
- Utilized requirements/design documentation for purposes of test planning and to validate requirements testability.
- Facilitated and participated in the meeting sessions with the business users and stakeholders to define the project scope and boundaries using the RequisitePro.
- Developed the Automation Test Scripts.
- Involved in development and implementation of overall test strategy and test plan for manual testing.
- Experience in testing the reports generated by the mainframe system.
- Leveraged existing manual test cases.
- Designed and developed new test cases in line with the test strategy and plan for Remittance module.
- Reviewed the Business and functional requirement documents and identified Batch and functional test scenarios.
- Performed the tasks of identifying and troubleshoot database issues as well as managing load scripts
- ConductedFunctional Testing, Regression testing, Integration testingto check the system is working according to the requirement specifications.
- Executed End to End test scenarios after all components are integrated.
- Participated in test case review meetings.
- Test execution and Defect reporting using HP Quality Center.
- Organized tests in to Test sets. Scheduled and ran the tests using Test Lab module in Quality Center.
- Stored, analyzed and prioritized defects usingDefectsmodule inQuality Center.
- Used Microsoft TFS to get around Work Items such as Tasks and to track the testing activities.
- Worked closely with developers and other staff members to form a unified team.
- Extensively used SharePoint to maintain the testing deliverables.
Environment: Quality Center 10.0, TFS, Mainframes, Load Testing, Windows, Manual Testing, Oracle, Eclipse IDE, XML, HTML.
Confidential
Software Consultant
Responsibilities:
- Understand the business requirements and come up with test plan and test estimates.
- Writing and executing software system test plans and test cases.
- These scripts were developed after reviewing the business requirements documents and technical specifications documents.
- Created test cases for integration testing based on requirements.
- Work with the Project Manager to identify resources, scope and limitations of testing.
- Identify Applications risks, issues and set priorities.
- Attend daily status meeting to discuss on requirements, test plan, test data and defects.
- Coordinated test case reviews with QA Lead and Project Manager.
- Maintained and provided status and progress of project activities.
- Design and execute detail test cases which involve testing end to end between various applications and also the database.
- Develop and execute complex SQL queries in database as part of testing process.
- Tested backend databases using SQL queries.
- Prepare Test Status report on weekly demand during planning and execution to summarized progress and results.
- Prepare Test Summary Report at the end of testing phase with results of readiness of system deployment to production. .
- Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.
- Maintain and provide status and progress of project activities.
- Participated in early phases of projects to ensure input into testing can be translated into test plans and test cases.
- Worked on all phases of Software Development Life Cycle (SDLC).
- Assisted in defect reporting in an effort to communicate to the appropriate personnel of the various stages of defects.
- Supported the design, development, testing and implementation of new business and support applications
Environment: Manual Testing, Bug Tracker, Java, Java Script, MS-SQL Server 2000, Windows.