Qa test lead

Archana Devi

QA Test Lead

*.***********@*****.*** Phone # 919-***-****

PROFESSIONAL SUMMARY:

8+ years experience in IT Industry with a strong back ground in testing of Client Server and Web based applications in various verticals such as Retail, Finance, point of sales and Banking.

Extensive experience in QA as Test Lead across applications in Retail, Telecom industry sectors.

Schedule Resources, lead requirements and Test designs discussions with line of business of all levels.

Excelled in performing Involved in Mainframe Testing, Manual Testing, Regression, GUI, Functional, Integration Testing, Sanity Testing, System Testing, UAT and Black box testing with basic Knowledge of Automation, performance testing.

Good understanding of technical trends, architectures, self-learner and motivated to stay on top of latest technology, new software and products.

Develop a Test plan to define testing strategy, test objectives, risk mitigation and Develop and identify task and resource estimates.

Experienced in defining Testing Methodologies, Test Environment and Designing Test Plans.

Writing Test Cases and Test Scripts, Verifying and Validating Application Software.

Manage and ensure requirements are met correctly through the entire SDLC process by participating in design, QA, UAT and deployment/implementation.

• Good Experience on Selenium IDE and creating Scripts in selenium --RC by using Java

Ability to work in a team environment or independently.

Business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies.

Experienced working with Excel Pivot and VBA macros for various business scenarios.

Manual and Automation expertise on mission critical and complex test engagements.

Good knowledge in Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC) which includes Requirement Gathering, Data Analysis, Application Design, Implementation and Testing of various applications.

Worked on QTP, QC, HP Quality Center (9.0), HP ALM 12.0,VSTS 2010 and TFS.

Strong knowledge in life cycle of Data Warehouse using Data Extraction, Data Transformation and Data Loading processes (ETL) and having profound knowledge in Dimensional modeling techniques Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).

Written SQL queries for data validation.

Experienced in defining Testing methodologies, Designing Test Plans and Test Cases, Verifying and Validating.

Data for web, ETL and BI applications and documentation based on standards for Software Development and

Effective QA implementation in all phases of Software Development Life Cycle.

Experience with structured QA Methodology and QA Process to ensure the Quality Assurance Control.

Extensive experience working in an Agile development environment.

Excellent ability to develop advanced concepts, techniques and standards.

Highly experienced in cross-browser compatibility testing in Windows/MAC OS platforms.

Experience in various stages of SDLC and experience in waterfall and agile methodologies.

Written easy-to-follow bug reports and utilized bug-tracking applications for entering bugs.

Proven ability to design, document, implement test plans, test scripts and test harnesses.

Exposure to Test Automation, Test Planning, Test management, Test reports, Reviews, Frameworks & Client Interactions.

Experience in handling a team of 10 Test engineers for different Modules.

Coverage Analysis, Test Case Authoring, Test Improvements, Bug Life Cycle, Test follow ups and Test Estimation.

Hands on Experience in Jscript, PowerShell, VB Scripting, PERL, SharePoint, Selenium Testing (IDE), TFS (Team Foundation Server).

TECHNICAL SKILLS:

Testing Tools

Selenium IDE, QTP, HP Quality Center, ALM12.1, VSTS

Languages

C#, .NET, HTML, CSS, VBScripting, Java, XML, Power Shell Script

Test Framework

Keyword driven, Data driven

Project Methodologies

Agile-Scrum, Waterfall, V-Model

Defect Tracking Tools

Jira, BugZilla, IBM Rational ClearQuest

GUI Tools

Visual studio 2010

Protocols

TCP/IP Protocol suite(HTTP, FTP, SMTP, UDP, DHCP, SSL, DNS)

Packages

MS-Office Suite (Word, Excel, Access), MS-Project and MS-Visual Studio

Databases

SQL Server, MS Access, Oracle

Operating Systems

Windows variants, UNIX, LINUX, MAC

PROFESSIONAL EXPERIENCE:

BB&T July 15 – Till Date

QA Test Lead

The BB&T Corporation (Branch Banking & Trust) is one of the largest financial services holding companies in the U.S. The project objective of Bank of Susquehanna Merger is to validate /Test the clients and their Deposit Accounts once the Migration process has been completed from Susquehanna bank to BB&T Bank Successfully.

Responsibilities:

End to End testing of financial transactions executed from Cash Manager Online and also validation for the BBT Mergers with other banks.

Validation in Mainframe for different regions as memo-post and hard-post based on the receipt date, time, sequence number and account number validating matching details also posted in the Mainframe datasets and database domain.

Interaction with business analysts to understand the requirements and create test design based on Functional Requirement Document (FRD).

Create UAT Dashboards to Identify defects and log through ALM 12.01 and help the manager to generate the reports( for defect & test execution satus) from the ALM.

Used to schedule weekly twice defect meetings and report the status to the line of business and the management.

Lead the cross-functional test team of a product initiative throughout the entire development lifecycle utilizing established standards and guidelines.

Direct all types of testing including functional, systems integration, user acceptance, performance and Multi-Browser Testing.

Participate in requirements and technical design reviews to ensure clarity of the design and usability.

Create and maintain test schedule and participate in triage meetings.

Direct test analysts in the writing of test specifications and ensure traceability of all requirements and Manage and participate in internal and external reviews of test specifications.

Coordinate test execution with project management, development, lines if business vendors and other internal departments.

Coordinate in the transition of the initiative to production support for implementation.

Assists test analysts with UAT and Regression testing of each application release and validation as needed.

Coordinates activities of Test Analysts organizing and prioritizing assignments.

Ensures understanding of the design and proper application to the test specifications.

Provides resource/time estimation for initiatives of Team Leads.

Provides re-estimation of testing effort is created and sent to initiative Manager or Project Manager when a scope or functionality change occurs during the initiatives lifecycles.

Provides testing status to Project Team and assigned testers.

Ensures that the builds are deployed on schedule and defect fixes are turn around quickly.

Ensures Test cases, Test Results have appropriate signoffs are done on time.

Making environment ready for the clients for the UAT (User Acceptance testing) and Go-Live.

Environment: ALM12.1, Mainframe Application, waterfall, SQL, HTML, MSWord, MS Excel, TFS, UNIX, Windows 7

BDSN International Nov 14 – July 15

QA Lead Analyst

Point of Sale systems, Payment Systems, forecourt merchandising and support services. The project is to test the security of applications around credit cards as they flow through their POS process during transactions at payment counter (cash register).

Responsibilities:

Was Test Lead for various project initiatives ranging in team size, scope and durations.

Providing test estimates, work allocation and progress tracking & reporting.

Prepared reports to communicate testing status for QA Manager to present to the larger project team.

Prepared user documentation with screenshots for UAT (User Acceptance testing).

Prepared test strategies for client side verifications and validations.

Performed regression tests on the application to assure proper functionality of the site after new builds using Clear Quest.

Tested test case scenarios (like capturing card details, Authorization, Settlements) which should be tested with any credit card payment when integrated with Point of sales applications.

Involved in Scrum meetings like Sprint planning and Daily stand up meetings.

Performed Manual Testing of this Web application and automated it by using Selenium IDE frame work.

Involved in functional testing, black box testing, negative testing, compatibility testing, and recovery testing.

Performed usability testing for web portal.

Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from oracle database.

Used Selenium IDE for Open source web testing .

Created test cases for user stories and Performed testing once the story is ready from Developers.

Performed regression tests on the application to assure proper functionality of the site after new builds using Clear Quest for Point of Sale systems

Performed GUI testing, Functional testing, Integration testing, Regression testing, Ad -hoc testing, Negative testing, End to End testing, Load testing, User Acceptance testing on multiple projects.

Executed User Stories of the projects available in JIRA implementing agile Methodology

Assisted quality assurance implementation in all the phases of SDLC.

Written SQL queries using SQL Server management studio for data validation.

Prepared test cases by analyzing functional requirement and documentation.

Performed Involved in running Selenium tests against multiple browsers using different browser profile.

Used SQL to validate backend database changes, deletes and update.

Wrote queries to extract data for testing purposes.

Reported the bugs/defects through JIRA Used IBM Clear Quest for tracking.

Identified software defects and interacted with developers to resolve them and provided full support to the Test team using Quality Center.

Participated in various meetings, discussed Enhancement and Modification Request issues.

Worked under Agile Scrum Methodology.

Environment: Selenium IDE, Java/J2EE, SQL Server2008, XML, Agile, SQL, HTML, VBScript, Quality center 9.0,HTML, MSWord, MS Excel, PL/SQL Developer, UNIX, Windows 7, JIRA, CLEAR QUEST

Microsoft Corporation, Redmond, WA Feb 2014 - Nov 2014

QA Test Lead

The project objective was to create an in house testing platform for Microsoft, which covers the complete life cycle of manual testing. It includes web and windows modules to serve different purposes. Delivery and Project Managers for planning, assigning and tracking the progress at team level use Service request web module. Lead view is another web module, which is used by team leads to assign tasks to individual team members and track the progress. Test Collateral Management is another web module that handles the addition of new test cases to the database, addition of help content, attributes and keywords to test cases. Windows modules Review and Release is used product owners to clarify the test engineers doubts, to review the test case results submitted by test engineers and release them to update in the client database.

Responsibilities:

Responsible for Test Planning, Test Execution, Automation & Defects Management.

Managing offshore and onshore QA team, providing estimates, work allocation and progress tracking & reporting.

Extensively used Test Director for test planning and defect reporting, tracking and executing manual test cases. Executed manual test cases and verified results with expected results.

Achieved 52% automation of data validation from backend (Database & Logs testing) and GUI testing.

Analyzing the business and functional requirements of the application and developing detailed test plan, test scenarios and test cases.

Performed checking the user profiles and their login scripts.

Coordinate test execution with the offshore team, Clients and with the team.

Checked the basic functionality by manual testing

Recorded the test cases using Automation tool, Win runner for web based application and checked the functionality of the application.

Modified the Test Scripts accordingly when we record the applications.

Performed User Acceptance Testing (UAT), interacted with users for execution of test cases in UAT.

Involved in examining the severity and priority of the Defects and Test Results Reporting.

Performed Functional, System, Integration, Upgrade, Portability and Regression Testing under various browsers.

Verified the data from backend by running the SQL queries.

Creating Test execution plans, schedule for automation development, reviewing test cases & test automation scripts.

Perform Code Reviews and facilitate automation testing approvals and signoffs.

Framework Gap analysis & modification using VB Scripting and UFT/QTP9.5

GUI Validation, Database Validation and Backend Log Files Validation

Tracking the automation progress & coverage.

Analyzing the results and Report Failures.

Feasibility Analysis and Code Management.

Logging the defect in Clear Quest and ensure that it is retested after fixing the defect.

Environment: QTP, SQL Server2008, XML, Agile, SQL, HTML, VBScript, Quality center HTML, MSWord, MS Excel, PL/SQL Developer, UNIX, Windows 7, JIRA, CLEAR QUEST/WTT.

WIPRO Jun 2013 – Jan 2014

Sr. QA Analyst.

Description: - Navion Healthcare solutions is an application to capture patient’s real-time data (inpatient & out-patient data) and submit required data to agencies such as The Joint Commission (TJC) and the United States Department of Health and Human Services’ Centers for Medicare and Medicaid Services (CMS).

Responsibilities:

Reviewed and analyzed the Business Requirements and worked with Business Analysts, Business Users in preparing Test Plan and Test cases.

Closely worked with Data modeler, Data analysts to understand the architecture and participated in reviewing the source to target mapping documents.

Developed test cases and test scripts for ETL mappings in ALM Test Plan module.

Linked test cases with requirements in ALM for Requirement Traceability Matrix (RTM).

Developed Test cases, Test scripts from the data mapping documents, functional Specification documents.

Used Informatica Power Center Workflow Manager to run workflows.

Used Informatica Power Center Workflow Monitor to monitor workflows and review log files.

Extensively worked on different source systems like SQL Server, Oracle and flat files.

Tested the Full load and Incremental data loads for initial, daily and weekly loads.

Wrote Complex SQL queries to support the test case results, also did the SQL performance tuning.

Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages.

Prepared mock test data for positive and negative test scenarios for Functional Testing as documented in the test plan.

Involved in testing Hadoop big data tables using hive SQL queries.

Used Hive SQL queries and queried table structure and list of partitions in Hadoop.

Experienced with MarkLogic NoSQL database.

Validated ETL mappings using SQL queries involving joins, set operators and case statements.

Used Unix diff command to compare data between two flat files.

Used Unix commands like wc, less, grep, cut and awk for validation of files.

Used VI editor commands in Unix for creating and manipulating files.

Extensively used the AutoSys jobs for the entire project.

Tested data migration to ensure that integrity of data was not compromised.

Perform defect Tracking and reporting with strong emphasis on root-cause analysis and effectively coordinated with the development team for closing a defect.

Participated in defect review, status meetings to help the business teams to understand the defects/issues.

Participated in daily stand-up meetings, weekly status meetings in agile methodology.

Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.

Created weekly test execution and defect reports from ALM and submitted to Project team.

Environment:- Oracle 11g, SQL, SQL Assistant, Informatica, UNIX, ALM / Quality Center, Hadoop, Big data, TOAD, Agile, MS Office, Autosys, windows.

Client: Capital One, Richmond, VA. Dec 2012 – Jun 2013

Role: Sr. QA Analyst

Capital Management LP is a leading manager of Institutional Asset Management Strategies. The firm manages over $33 billion in senior secured loans, high yield bonds, structured products, mezzanine debt, and equities for a global institutional investor base (clients). The project involved in implementation of Oracle Purchase and Order management in Oracle Apps 11.5.10.

Responsibilities:

Involved in all phases of testing such as System testing, Data validation and User Acceptance Testing.

Documented Test Plans for Test scripts and mostly involved in scenario based testing.

Verified and validated the custom functionalities and enhancements implemented in oracle financials and supply chain modules such as PO, AP and Order Management.

Gathered business scope and technical requirements.

Worked closely with development team during the testing phase and fixed bugs that were reported.

Worked and managed offshore team during the course of project.

Supported production support activities and experience as an on-call production support for the applications.

Performed unit testing/system testing and supported user acceptance testing (UAT).

Scheduled Sessions on the Server using workflow jobs.

Implemented performance testing on jobs sessions to provide maximum efficiency and performance.

Involved in fine-tuning queries for better performance

Responsible for testing the Counters, Quotes, Pricelists. Tested various customized and standard Reports pertaining to OM, OPS, WMS and Shipping.

Analyzed, tested and documented the conversion and customization of oracle Apps.

Converted data from legacy system to Oracle Applications. The conversion includes Customer information and Receipt information in AR through Auto lock box, Customer interface.

Major responsibility in testing the customization and supporting the Workflow (2.6) (PO Approval, Requisition Approval, PO Account Generator) Workflows as per the business requirements. Also tested the following..,

Purchase Order Detail Report

Purchase Requisition Status Report

Cancelled Purchase Order.

General Ledger - Define chart of accounts, enable currencies, validating accounting periods and calendar periods. Set of books and its structure.

Work Flows - Validated the email notification and approval notifications for workflows created for settlement and rollover accounts.

Reports: Validated Hedging reports, Settlement reports, Revaluation reports, Bank Statement reconciliation report etc.

Environment: Oracle Application 10.7/11i, PL/SQL, Forms 6i/4.5, Reports 6i/2.5, SQL*Loader, HP UX Server, Windows NT.

Microsoft Corporation April 2011- Dec 2012

Sr. QA Tester

Project: Win8 - Remote Desktop Management Servers (RDMS)

Remote Desktop Services (RDS) in Windows Server "8" Beta provides the ideal platform for companies to implement a centralized desktop strategy, helping organizations improve flexibility and compliance while improving data security and its ability to manage desktops and applications. RDS is a centralized desktop and application platform solution that uses Desktop Virtualization and VDI technologies, offering powerful opportunities for IT to deliver and manage corporate desktops and to respond to users’ needs in a flexible way. Remote Desktop Services is the new name for Terminal Services, and reflects the expanded role in Windows Server "8" Beta so that you can run the desktop or applications in the datacenter while your users can be anywhere.

Responsibilities:

Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.

Used Windows Test Technology (WTT) tool for developing and automating those test cases.

Ensure 100% requirement traceability by preparing Requirements Traceability Matrix.

Performed peer reviews during test case creation and execution.

Defect Tracking and Status Reporting to Project team and Business users on weekly basis.

Managed and conducted System testing, Integration testing and Functional testing.

Extensively used the AutoSys jobs for the entire project.

Worked on SQL scripts to load data in the tables.

Tracked the defects using WTT tool and generated defect summary reports.

Validated the data movement and transformations are done correctly.

Worked with developers who extensively used .NET to design mapping to move data from source to target database-using stages to do the functionality.

Worked closely with development team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.

Prepared status summary reports with details of executed test cases.

Interacted with Developers, Clients, Management Teams and End Users.

Responsible in conducting meetings between Onshore and Offshore teams to get the test case execution done and discuss about any major roadblocks delaying the project.

Keep a track of defects and the testing report during the signoff of the test pass.

WIPRO Feb 2009 – Mar 2011

Sr.QA Tester

Project: Nokia Lumia

Nokia Networks is a leading global enabler of telecommunications services. With its focus on innovation and sustainability, the company provides a complete portfolio of mobile, fixed and converged network technology, as well as professional services including consultancy and systems integration, deployment, maintenance and managed services.

Responsibilities:

Prepared detailed business requirement documents.

Reviewed the Business Requirement Documents and the Technical Specification.

Developed Test Cases to cover overall quality assurance testing.

Performed manual testing on different modules of the application.

Performed System Testing and Integrity Testing using WinRunner.

Developed, tracked and managed Issues Log created during the test phase using Excel.

Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Prepared Test Plan from the Business Requirements, detected defects tracked and reported bugs using Test Director.

Performed data integrity testing by executing SQL statements and manually verifying the contents.

Performed extensive database testing.

Performed Load Testing, Stress Testing and Performance testing using LoadRunner.

Involved in writing testing methodologies by following standards for test documentation, test requirements and test procedures.

Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.

Worked closely with development team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.

Involved in meetings and walkthroughs and Responsible for weekly status.

UNION BANK OF SWITZERLAND July 2007 - Jan 2009

Test Engineer

UBS is of one of the world's largest Investment Banking having its operations in all the parts of the world. Providing its customers with Stock market, which include share market throughout the world. Reconciliation is the booking team, which works from back office, and we do have clients from APAC (Asia Pacific Countries) Region. Reconciliation plays a vital role in booking shares. Reconciliation is responsible for the supply, trading and marketing by helping to book shares for biggest clients like Wealth Management, Barclays, JP Morgan and Standard Chartered. For consistent and scalable business process and EDI capabilities these systems are critical for Reconciliation team to reach the stated business growth levels and be competitive in the market.

Responsibilities:

Involved in transition from the client over the phone and helped in ramping up the team.

Was part of QA team involved in QA sessions and held meetings for smooth transition.

Involved in Manual Testing, Integration Testing, System Testing, UAT Testing, Regression Testing and Functional Testing.

Validating Requirement & Functional specifications of customers.

Participating in the Defect Triage meetings, Functional demo sessions and active interaction on status of work & discussion on issues with team.

Peer- Review of Test cases and Test scenarios for System Test cases phase.

Written test cases and test scripts for the functional testing and Regression Testing using HP Quality Center 11.0/9.2/9.0

Responsible for reliability, accessibility testing, Collecting Clients requirements, Executing and fixing product studio bugs, analyzing the build changes, identifying Functional and regression test cases and performing E2E testing using VSTS 2010.

Performed extensive database testing.

Performed Load Testing, Stress Testing and Performance testing using Load Runner.

EDUCATION:

Bachelors in computer science and information Technology (2007) from Guru Nanak College of Engineering College

Contact this candidate