We provide IT Staff Augmentation Services!

Sr. Qa Lead Resume

NyC

SUMMARY:

  • 8 years of Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Extensive experience in Analyzing, Designing and Implementation of QA testing strategy for Web based and Client/Server applications using Manual testing and Automation testing Selenium of client server application in back end testing.
  • Good working experience in automation tools like selenium web driver.
  • Experienced with various types of testing like GUI testing, Web testing, Regression testing, User Acceptance Testing, Functional Testing, System Testing, Integration Testing, End to End Testing, Unit Testing.
  • Implemented functional tests using java, Test NG/Junit framework and also cucumber framework.
  • Experience in analyzing business specification documents, designing and developing Test Plans, writing and executing Test Cases.
  • Good experience in reviewing business requirement document and software requirement documents, test cases and their execution, also coordinated with developers for fixing defects.
  • Experience in Web debugging tools like XPath, Firepath, Firebug and also provided efficient locators for strategies like Xpath and CSS to run web driven scripts.
  • Experience in ANT, MAVEN to create projects, JAR files, POM.xml with artifacts and dependencies.
  • Worked on end to end testing using Selenium web drivers/IDE/Grid, Test NG/Junit and also web services like REST and SOAP.
  • Extensive experience in data driven, keyword driven and hybrid test automation frameworks.
  • Experience with Automated Testing tools such as Selenium - RC, Web Driver and Selenium Grid.
  • Experienced in automation based on WebDriver and Test NG framework with Java programming language.
  • Experienced in Creating/Executing/Troubleshooting Selenium automation test scripts generated from test cases.
  • Experienced in bug tracking, reporting and using Quality Center (QC) and JIRA for global test management.
  • Good knowledge in different programming languages like java, java script, HTML and databases like SQL server and ORACLE.
  • Experienced in continuous integration using JENKINS to support tools likes CVS subversion, GIT and execute Apache ANT and apache Maven.
  • Worked on database testing on triggers, logical views and SQL queries which support database refactoring
  • Familiar with OSI and TCP/IP
  • Have worked on sub version control tools like GIT and SVN.
  • Extensive testing ETL experience using & Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
  • 5 years of strong data base experience in Oracle, TOAD, SQL Server 2000/2005, IBM DB2.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Expertise in ETL BACKEND TESTING.
  • Expertise in handling Onsite-Offshore model, client handling and continues business process.
  • Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
  • Worked in Investments, Marketing, Wealth Managements domains
  • Performed Load, Integration and System Testing.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Strong in methodologies like waterfall model, Agile methodology
  • Involved in Load testing and web testing using Visual Studio 2008
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
  • Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved.
  • Excellent written and oral communication skills and a team-player with a results-oriented attitude.

TECHNICAL SKILLS:

Operating Systems: Windows 7/ XP/ 2000 Professional /98/NT, UNIX

Languages: HTML, CSS, Java, JavaScript, SQL

Database: ORACLE, SQL Server

Testing Tools: Selenium Web driver, Postman, Fiddler

Defect Tracking Tools: Quality Center (9, 10, 11.0), Jira, Team Foundation Server (TFS 2008, 2010, 2012), ALM QC,CA Agile, Test Director, Test Link, Bugzilla, Mingle.

Testing Framework: TestNG.

Built Tools: ANT, Maven.

Methodologies: Agile (Scrum), Waterfall.

ETL Tools: Informatica, Datastage, SSIS

BI Tools: Business Objects XIR3, Cognos Series 8.0, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Sr. QA Lead

RESPONSIBILITIES:

  • Interacted with Business Analyst and Developers to understand the application architecture and recommend testing strategy.
  • Involved in working on different projects in different domains like Investments, Marketing.
  • Managing the onsite and offshore based manual and automation test teams to coordinate all testing activities for all assigned applications.
  • Preparing Test Plan, Test strategy, timeline reports and weekly status reports.
  • Prepare the tractability matrices to fill the gap between the requirements and test cases covered.
  • Worked on testing the website features which are customer friendly on different browsers, different platforms and also on different devices
  • Understanding and testing the data feeds such as Product data feeds which play important role in Marketing products.
  • Conducted daily stand-ups with offshore team for the project status and defect triage for the review of defects in JIRA along with BA and developers.
  • Prepare and present presentations to senior management on the value of automated testing.
  • Verifying and validating the functionalities, reports as per the requirement.
  • Participated in Scrum meetings and sprint meetings.
  • Review and execute the test cases and scripts developed by offshore team.
  • Used Selenium Web driver, java, TestNG for designing automation test cases.
  • Executed test cases in multiple browsers and platforms using Selenium Grid.
  • Responsible for implementing page object model (POM) using Selenium Web Driver, TestNG and Java.
  • Performed Manual testing in physical devices emulator and IOS simulator.
  • Involved in test automation by using open source tools such as Selenium.
  • Involved in resolving complex automation issues in selenium using suitable Java code.
  • Created test cases using element locators and selenium web driver methods.
  • Extensively involved in testing the application manually for the Functional and Systems Integration test efforts.
  • Performed Web-Services Testing using Ready API and generated XML Files for messaging.
  • Used Ready API with Groovy Script to test the services.
  • Performed Scrum (Agile) methodology for testing the application.
  • Developed automated scripts and frame works using Java scripting.
  • Used BDD framework with Cucumber, Java and created future files with scenario and scenario outline files.
  • Used Quality Centre as a defect tracking tool for raising issues and interacting with developers and users about the errors in the application.
  • Identified defects and monitored resolution via defect tracking tool QC/ALM
  • Worked on ETL/Backend testing by writing the queries.
  • Expertise in using Selenium (data-driven, XPath locator) and WebDriver to test the web application.
  • Involved in development of automation scripts for new enhancements using TestNG and Selenium WebDriver.
  • Configured Selenium WebDriver, TestNG, Maven tool and created Selenium automation scripts in java using Junit prior to agile release.
  • Involved in integrating the test suites to Jenkins to execute them automatically after every successful deployment.
  • Involved in implementation of Test Automation Framework build using Selenium WebDriver, protractor to handle Angular JS, TestNG and Maven technologies under Java platform utilizing industry leading harness design patterns and approaches.
  • Used Xpath, Firepath and Firebug tools to locate elements.
  • Developed test code in Java language using Eclipse, IDE and TestNG framework.
  • Participated in design walkthrough and review meetings while interacting with customers.
  • Worked in onshore and offshore Model.

Environment: Selenium Webdriver, Junit, TestNG, Appium, Android UI Automator, iOS UI Automation, HP Quality Center 9.2, Ready Api, Postman, Fiddler, XML, Quality Center, Kanban Jira board, CA Agile, UNIX, windows 2007, PL/SQL, TOAD, UDeploy, Varden, Autosys IXP, FileZilla, Tableau, Informatica 10.1, SQL Server2005/2008, Cognos 8.1, Oracle 11g

Confidential, Warren, NJ

Sr. QA/ETL/DWH LEAD

Responsibilities:

  • Interacted with clients to determine User requirements and goals.
  • Participated in analysis of Business and functional requirements.
  • Involved in writing the FRD and MDD.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Developed Test Plan and overall Test Strategy for the Application. Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel. Developed Test Cases and Test Scripts for System and UAT Testing.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document. Worked with Agile Methodology.
  • Involved in the Meetings scheduled in order to discuss the documented Defects logged by the testing team using Clear Quest.
  • Migrated objects from SQL Server 2005 to SQL Server 2008.
  • Participated in load testing exercises and tested dashboards and assisted development team with testing activities.
  • Tested Cognos reports for verifying and validating the data.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
  • Did lot of Web Testing using Quick Test Pro. Involved in Unit testing and integration testing of Informatica mappings.
  • Did front-end testing and functional testing using Quick Test Pro.
  • Used Quality Center for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking.
  • Performed Positive and Negative Testing for this application.
  • Extensively used SQL queries to check storage and accuracy of data in database table.
  • Performed basic testing of security features using manual testing.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Extensive experience in coordinating with off-shore Team and onsite projects.

Environment: Informatica 9.1, SQL Server2005/2008, Cognos 8.1,HP Quality Center 9.2, Oracle 11g, XML, Rational Clear Quest, Clear Case, Agile, Quick Test Pro 9.0, UNIX Shell Scripting, UNIX, Windows 2007, SQL, PL/SQL, TOAD.

Confidential, Hartford, CT

Sr. QA/ ETL/ DWH Tester

Responsibilities:

  • Interacted with clients to determine User requirements and goals.
  • Participated in analysis of Business and functional requirements
  • Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
  • Developed Test Plan and overall Test Strategy for the Application. Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel. Developed Test Cases and Test Scripts for System and UAT Testing.
  • Performed Positive and Negative Testing for this application.
  • Extensively used SQL queries to check storage and accuracy of data in database table
  • Performed basic testing of security features using manual testing
  • Responsible for creating Test Strategy for the Data Warehouse
  • Involved in creating the design and technical specifications for the ETL process of the project.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
  • Verified Informatica session logs to identify the errors occurred during the ETL execution.
  • Tested Cognos Reports according to the business requirements.
  • Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
  • Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Used Erwin to reverse engineer the existing database design in SQL Server 2000
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Responsible for communicating Defect Status Reports to business in project meetings.
  • Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2000/2005
  • Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC
  • Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.

Environment: Informatica Power Center 9.1, (Power Center/ Power Mart,) Cognos 8.0, Rational Clear Quest, VB Script, Erwin 4.0, SQL Server2000/2005, SQL Plus, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, Shell Scripting

Confidential, Pittsburgh, PA

Sr. ETL/ QA/ DW Tester

Responsibilities:

  • Implement the strategic plan for support of future company information requirements.
  • Involved in predefining data mapping from ETL & BI to the relational source, and running ad-hoc queries for providing optimized reports.
  • Involved in testing the Ecommerce website and worked on testing the content testing as well as workflow functionality.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in Business analysis and requirements gathering.
  • 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.
  • Extensively used Informatica Workflow Manager to run the workflows.
  • Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
  • Done data validation for the Cognos reports.
  • Tested reports in Cognos using Analysis studio, Report studio and query studio.
  • Worked with Agile Methodology.
  • Involved in the Meetings scheduled in order to discuss the documented Defects logged by the testing team using Clear Quest.
  • Migrated objects from SQL Server 2000 to SQL Server 2005
  • Fully documented and replicated defects for Developers, enabling them to fix Defects faster and meet Production Deadlines.
  • Participated in load testing exercises and tested dashboards and assisted development team with testing activities.
  • Did front-end testing and functional testing using Quick Test Pro.
  • Used Quality Center for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security. SQLs are written using QMF to query the DB2 database on mainframe.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Validated the data after running the batch process from different Mainframe systems
  • Provided technical guidance and support to end-users by developing the documentation required.
  • Worked on Excel Add-in Tools to generate various reports to analyze the business
  • Created users, user groups in the Planning application for accessing the various application elements.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Involved in offshore and onsite Coordination activities

Environment: Informatica 8.6, Cognos 8.0, SQL Server2000/2005, Quality Center 8.2, Oracle 9i/8i, XML, XSLT, Rational Clear Quest, Clear Case, Agile, Quick Test Pro 9.0, UNIX Shell Scripting, UNIX, IBM AIX 5.3, Windows 2003, SQL, PL/SQL, TOAD

Confidential, Dallas TX

Senior Quality Engineer

Responsibilities:

  • Worked for different projects of Confidential like Intranet, Extranet, Gating Portal, Budget Input, PowerVU, BI B&F Reports, SR Reports and CPF Reports.
  • Design test strategy and define the scope of the project.
  • Prepare test estimates, test strategies and test plans for the different modules of DLR project.
  • Providing guidance to a team of 5 members. Reviewing the test conditions, test scripts, and test cases, presenting the DSR, WSR and overall risks to the project stakeholders.
  • Communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
  • Perform requirements testing from the orientation of understanding the business requirements and cross validating the same against the technical specifications.
  • Prepared test cases and test scenarios for functional and Regression testing and performed Equivalence partitioning & Boundary value analysis, database testing for all the reports.
  • Used different Excel functions to tests the reports and also used Pivot table to test the data.
  • Performed functional testing in SalesForce.com
  • Participated in daily Scrum calls and also worked on RTM.
  • Built custom reporting functions to provide greater detail and granularity.
  • Provide documentation to client around test environment configuration, Test execution instructions and troubleshooting guidelines.
  • Execute, Debug and Rerun the test cases, Log bugs and following up to its closure in Mingle.

Environment: /Tools: Visual Studio 2005, ASP.NET 2.0, C#, CSS, JQuery, MOSS 2007, WSS 3.0, SharePoint Server 2007, SharePoint Foundation 2010, SharePoint designer, Nintex Workflows, Deliver Point 2007, SQL Server 2005/2008, IIS and Windows Server 2008, Pivot table, Excel, Gemini, Mingle, Salesforce.com.

Hire Now