We provide IT Staff Augmentation Services!

Sr. Qa Lead Resume

Bellevue, WA

PROFESSIONAL SUMMARY:

  • Information technology professional with 10 + years of experience in Requirement’s Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance Lead and testing, worked as Manual Tester, Web Tester, POS Testing, Mobile Application Tester, ETL/BI Tester, Quality Data Analyst and Sr. QA Associate
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Expert in testing mobiles apps on different operating systems like Windows, Unix
  • Experienced in validating web applications across operating systems and different browser versions
  • Strong knowledge in functional/regression/UAT/GUI testing etc
  • Worked on several test management tools like HP quality center, Jira and Bugzilla
  • Had sound knowledge on automation tools like Selenium, QTP, Perfecto
  • Quality Assurance: Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing based on the User Requirement Document and System Requirement documents.
  • Experience in writing Test Plan and Test Strategies for Data Warehousing Applications.
  • Good experience in System, Integration, Performance, Sanity, Security, Load, Database, UAT, Usability and Regression Testing.
  • Professional Experience in Retail, Financial, Mortgage, Brokerage, Banking, HealthCare applications and strong understanding of Banking/Financials/Mortgage lending applications.
  • Experience of various data warehousing, web - based, client-server and distributed multi-tier applications.
  • Experience in data validation of various sources like Teradata, DB2, Informix, Oracle, SQL Server and Sybase.
  • Excellent written and verbal communication & interpersonal skills.

TECHNICAL SKILLS:

Testing Tools: Test Director 8.0/7.6/7.2, Win Runner 7.6/7.0/6.5, Quick Test Pro 8.0/6.5/6.0, Load Runner 7.6/7.2, Rational Clear Quest

Networking: GSM, GPRS, TCP/IP, UDP, MPLS, Core Networks, Wireless Networks including 802.11, Network stack, LAN, WAN and MAN

Middleware: SOAP, REST, TIBCO

Languages: Java, .NET, XML, HTML, SQL, Java Script, VB Script

Operating Systems: Windows 95/98/NT/2000 pro/XP/2010, Unix, Linux

Databases: MS Access, Teradata V2R6, MS SQL Server 2005/2008 R2, Oracle10g/9i/8iInformix, DB2

ETL Tools: Informatica Power Center 7.1.3/8.6.1 , Abinitio 2.1, Data Stage 8.0/8.6, SSIS

Reporting Tools: Business Objects 4.0/5.0, Cognos 7.3/10, OBIEE 10.0, SSRS

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Trust, Bugzilla, Quality Center, Jira

GUI Tools: Visual Basic 5.0/ 6.0, Crystal Reports 4.6/6.0

App/Web Servers: Apache, Tomcat, Web logic, Web spheres, TFS

MS Suite:: MS Office 2007/2010/2011 (Word, Excel, Power Point, Outlook)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QA Lead, Bellevue, WA

Responsibilities:

  • Provide technical support to the various team such as automation team, QA team and design team to meet production expectation.
  • RCA for failures on network side and defect tracking using HPQC.
  • Oversee production deployment and communicate project goals and timeline to upper management.
  • Tools used- IRIS, JDSU, Wireshark and Tesla automation Provide technical support to the various team such as automation team, QA team and design team to meet production expectation.
  • Created Test input requirements and prepared the test data for data driven testing.
  • Involved in developing detailed Test plan, Test cases and test scripts using Test Director for Functional, Security and Regression Testing.
  • Validate different call flows like registration, de- registration, messaging, file transfer etc.
  • Troubleshot issues on a daily basis and have the defect assigned to right team
  • Worked on Execution Tracker, Test Design Tracker & Defect Metrics
  • Validating the data passed to downstream systems and verify results
  • Tested the processes for both before data validation and after data validation process

Environment: SIP, Wireshark, XML, iOS 6.0 (Mobile Client Application) / Android, J2EE, MYSQL, Quality Center, Windows OS, Chrome, Firefox, Tesla

Confidential

QA Lead, Bellevue, WA

Responsibilities:

  • Analyzed Software requirements, Business requirements and Functional Specifications documents to get a better understanding of the application from both technical and business perspectives.
  • Actively participated in Test Planning, Functional Specification reviews, Design/Code reviews, Implementation /Engineering reviews, Guidelines, Process and Standards.
  • Implemented the software development lifecycle (SDLC) to follow the Standards process of the application.
  • Designed and developed the Test plan, Test Scripts, test goals for the applications and executed them.
  • Maintained and modified to accommodate new changes to the software by interacting with development team and conducting meetings with partners and vendors.
  • Identified Test Data requirements and created Test Data for System and E2E testing
  • Performed Functionality, Integration, Performance, System, Regression tests manually based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs on SIP,HTTP,HTTPS protocols, XML applications, ORACLE database, Weblogic server on both UNIX and WINDOWS environment.
  • Participated in User Acceptance Testing (UAT) and user feedback reported to QA Manager in the form of Change requests (CR’s)
  • Created Data-Driven tests to check the performance of the application with different sets of data. Developed SQL scripts to extract data from the target tables to provide the data mapping.
  • Worked closely with the Project Management, Development, Engineering and Operations teams in performing QA/QC activities and smooth deployment into Production environment and Post Production support.
  • Used Web Based Change Request System for defect tracking and reporting, also followed up with the development team to verify defect fixes and updated defect status.
  • Expertise in bug tracking reports using Bug Tracking tools like Mercury Quality Center used for defect tracking and reporting, also followed up with the development team to verify defect fixes and updated defect status.
  • Actively participated and supported on all other on-going Projects within and outside Data Engineering Systems platforms.
  • Listed and recommended testing strategies to be employed to test the critical areas of different modules.

Environment: SIP, Wireshark, XML, iOS 6.0 (Mobile Client Application) / Android, J2EE, MYSQL, Quality Center, Windows OS, Chrome, Firefox, Tesla, Jira

Confidential

Sr. Data Analyst, Beaverton, OR

Responsibilities:

  • Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 10.0
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Collected requirements and tested several business reports.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
  • Performed high-end data analyst with very strong database skills and SQL.
  • Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Developed Test Cases for testing the mapping designs before going to the production phase.
  • Used SQL tools to run SQL queries and validate the data loaded in to the target tables
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags
  • Interacting with senior peers or subject matter experts to learn more about the data
  • Identifying duplicate records in the staging area before data gets processed

Environment: Informatica 8.6, Oracle 10g, MS Excel, UNIX, Quality Center 10, Toad 9.1, Unix Shell scripting, Autosys 4.0, Windows XP.

Confidential

DI Analyst, Milwaukee, WI

Responsibilities:

  • Worked with Architect and Business users to collect the requirements to test the warehouse/mart.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
  • Prepared Test Plan document to track the execution and results of test activities.
  • Actively participated in calls with offshore team to track the progress of various testing activities.
  • Conducted team meetings and project meetings when needed to in order to meet testing deadlines.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Written test cases to test the application manually in Quality Center.
  • Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Quality Center.
  • Developed scripts, utilities, data sets and other programming test tools as required for executing test plans.
  • Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
  • Creating test cases for ETL graphs and design documents for production support.
  • Setting up, monitoring and using Job Control System in Development/SIT/QA/UAT/Prod.
  • Extensively worked with flat files and excel sheet data sources. Scheduling and automating jobs to be run in a batch process.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using QC
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Worked on issues with migration from development to testing.
  • Document the test execution and results in shared environment to have them available to other team members and get the status from fellow teams.
  • Used various techniques like using automation scripts to drive the execution smooth and quicker.

Environment: Informatica 8.6, Peoplesoft, Rapid SQL, SQL SERVER 2008, Db2, Windows XP, SQL.

Confidential

Quality Data Analyst, Irvine, CA

Responsibilities:

  • Analyzed business requirements documents and writing Functional Test cases, Integration Test cases.
  • Mapping of test cases to user requirements and coordinating with the Development team for defect analysis.
  • Attending Status meetings, standup meetings and Defect Review meetings during execution.
  • Understanding the System Requirements for web based application and creating high level Scenarios and writing low level test cases.
  • Used the Agile methodology to build the different phases of Software development life cycle. (SDLC).
  • Involved in gathering the requirements for the Operational Reports.
  • Designing, Executing and Defect Tracking in TFS.
  • Helped the Testing team by writing SQL statements to validate the reports.
  • Validating the data passed to downstream systems.

Environment: Data Stage 8.6, TFS, SSIS, SSRS, SQL SERVER 2008 R2, Windows XP, SQL, PL/SQL.

Confidential

QA Analyst, Framingham, MA

Responsibilities:

  • Established the business analysis methodology using Iterative model of SDLC (Agile).
  • Involved in preparation of Effort estimation and schedule documents and presented to clients.
  • Facilitate System, Regression and User Acceptance Testing.
  • Design and Develop Testing Strategy and Plans for different application releases.
  • Created and executed detail function test scripts and Test cases based on the business requirements.
  • Incremental development/testing of Enterprise Data Warehouse.
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • Validating fields present in the reports are as agreed in specifications.
  • Arranged meetings with business customers in better understanding the reports by using business naming conventions.
  • Involved in validating the aggregate table based on the rollup process documented in data mapping.
  • Wrote and executed detailed test cases including prerequisites, detailed instructions and anticipated results.
  • Utilized Quality Center to map the Requirements, Test Cases to develop Requirement Traceability Matrix.
  • Created multiple test scenarios based on business rules to create data driven testing.
  • Performed various types of testing, such as Black box, Functional, Performance, Negative, System and Regression testing.
  • Determined testing scope and prioritized deliverables in different phases.
  • Tested data warehouse components, data marts, testing of Dimension and Fact loads.
  • Preparation of test scenarios for data flow, and testing of automation of jobs.
  • Tested ETL process for both before data validation and after data validation process.
  • Tested the messages published by ETL tool and data loaded into various databases.
  • Extensively used ETL Data Stage to load from operational system (Oracle database) and flat files into the target data warehouse.

Environment: Data Stage 8.6, Mainframe, Quality Center 11.0, SQL SERVER 2008, Biz Talk ServerRumba UNIX Display, Windows, DB2, Cognos 10.0, SQL.

Confidential

Manual/ETL/BI Tester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Written complex SQL queries for querying data against different data bases for data verification process.
  • Designed the data flow diagrams using VISIO.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Written test cases to test the application manually in Quality Center.
  • Written Test Plans and Test Cases on Mercury’s Test Director Tool.
  • Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Test Director.
  • Developed scripts, utilities, simulators, data sets and other programming test tools as required for executing test plans.
  • Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
  • Creating test cases for ETL graphs and design documents for production support.
  • Setting up, monitoring and using Job Control System in Development/SIT/QA/UAT/Prod.
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
  • Scheduling and automating jobs to be run in a batch process.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using Test Director 6.5.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Worked on issues with migration from development to testing.

Environment: UNIX Shell Scripting, Informatica 8.1, Mercury Test Director 6.5, SQL *Loader, Cognos 7.3, Oracle8i, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD.

Confidential

QA Analyst

Responsibilities:

  • Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used SQL for Querying the DB2 database in UNIX environment.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
  • Responsible for different Data mapping activities from Source systems to Teradata.
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Tested on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rules.
  • Tested jobs and used Ab Initio as an ETL tool to load the final loads.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
  • Involved in creating both positive and negative test data to cover all business scenarios.
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Used Clear Quest to track and report system defects and bug fixes. Written modification requests. for the bugs in the application and helped developers to track and resolve the problems.
  • Performed quality assurance reviews on all System Development Life Cycle.
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Teradata V2R6, SQL Assistant 6.0.0, SQL, PL/SQL, Sybase, HTML, TOAD, UNIX, Clear Quest, Quick Test Pro, Quality Center 9, Shell Scripting, PERL.

Confidential

QA Tester

Responsibilities:

  • Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
  • Validated all kinds of transformations used in every work flow used to transform data.
  • Validating the data flow from source to target.
  • Checking the data flow from one end to another by using SQL queries.
  • Worked with technical staff to create, interpret and implement business requirements into technical specifications.
  • Involved in Smoke, Functional, Regression, System, Integration and Security testing during all phases.
  • Performed manually testing using Cross browser and Cross Platform.
  • Validated various Hyperlinks on web pages also performed GUI testing manually.
  • Participated in the team to performed User Acceptance Testing.
  • Involved in the executing and retrieving the data for SQL Queries.
  • Interacted with developers and users to resolve major bugs.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Developed automated test scripts using QTP to perform Functional and Regression testing.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
  • Performed quality assurance reviews on all System Development Life Cycle.
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: .NET, VB Script, Oracle, XML, XSD, XSLT, Microsoft Office, Test Director, SQL, PL/SQL, PERL, Shell Scripting

Confidential

QA Engineer

Responsibilities:

  • Review web-based application and identify critical functionalities
  • Gathering, Understanding and Documenting Requirements
  • Develop and execute Test Plans and Test Cases from requirements and specifications documents
  • Participate and create Test Plans
  • Manually create, develop and executed Test Cases
  • Execute manual testing for all cases
  • Test Engineer / UAT Support
  • Team Coordination & Mentoring New Team Members.
  • Worked in capacity of Module lead / SPOC for testing of SMS & Admin Portal modules.
  • Involved in requirement analysis, impact analysis sessions with respect to testing activities & efforts for new requirements.
  • Test Case Creation, Peer Reviews & Execution
  • Functional, Integration, System & Regression testing of Web/Mobile (iOS/Android) application.

Environment: Windows, Quality Center, Chrome, SOAP, XML

Hire Now