We provide IT Staff Augmentation Services!

Qa Lead - Etl/big Data & Automation Resume

Atlanta, GA

PROFESSIONAL SUMMARY:

  • 7+ years of diversified experience in software industry as QA Lead, Manual Tester, Automation Tester, ETL Tester, Big Data Tester and Mobile Tester
  • Currently working as QA Lead at client location ( Confidential ) working on different projects which include Data Warehouse & Business Intelligence/Analytics Applications.
  • Good working experience in various domains such as Supply chain, Merchandizing and Capital Markets applications developed in different technologies for the prestigious clients Confidential and Confidential
  • Strong knowledge of Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC) and the Role of QA in different testing methodologies like Agile and Waterfall methodologies
  • Extensive experience in establishing and implementing standards, procedures and methodologies based on Quality standards like ISO and CMMI levels
  • Proven experience in Functional Testing, Integration Testing, Performance Testing, Database Testing, System Testing, Regression Testing, Sanity Testing, Smoke Testing, User Acceptance Testing and Black box testing.
  • Hands on experience in creating Test Plans, Test Strategy, Test cases, Test Designs, Test Analysis, Test data
  • Solid experience in Test Management tools like ALM, HP Quality Center, JIRA and Pivotal Tracker
  • Hands on experience in gathering and analyzing Product Test Requirements and converting them to Test Scenarios and Requirement Traceability Matrix.
  • Hands - on Experience in Generating Dashboards from QC/ALM & Excel and preparing Daily, Weekly and Monthly Status Reports and Defect Status Reports to report the status of the ongoing projects to the Stakeholders.
  • Strong in analyzing and writing Complex SQL queries to build expected results and to compare expected and actual results in Teradata, Hadoop, Hive, Oracle, SQL Server and IBM DB2 for ETL Validations
  • Extensive experience in Data Quality Checks, ETL Validations
  • Experience with BI Testing of Micro strategy, SSIS, SSRS and iPhone and iPad Dashboards
  • Hands on Experience in Dev Test, Selenium, Cucumber, Jenkins, JAVA, GitHub technologies based projects
  • Created automation framework using Dev test application and expanded it use across the team for different projects.
  • Having extensive experience in Selenium Automation with Java as scripting language.
  • Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Jenkins
  • Experience in developing Automation strategies, designing Automation test scripts.
  • Hands on Experience in QTP Descriptive Programming and frameworks such as Data-driven, Keyword-driven and Hybrid
  • As a Mobile Tester and QA Engineer, performed manual testing for the number of web projects in Home Depot web site across multiple browsers (IE, Firefox, Safari and Chrome) and different cross mobile devices phones, tablets, iPads etc.
  • Monitoring the Non-Functional Testing activities such as Implementation, Back-out, Monitoring, Security, Batch Performance Testing and Job Scheduling involving DBA, Development and Security Teams and provide the necessary documents.
  • Involved in testing application on different mobile Platform such as iOS and Android devices.
  • Tested the application under different networks and Internet speeds including 3G, 4G/LTE and Wi-Fi
  • Pairing with dev team for past 1 year and using Slack for interaction
  • Experience working in Waterfall, Agile and Extreme XP Software Methodologies
  • Experience in handling Multiple projects with Offshore-Onshore Model including work assignment, coordination, interviewing, mentoring and providing training for the team
  • Collaborate as part of the scrum team in grooming user stories and development of acceptance criteria for the user stories with good working knowledge in Agile Methodology (Scrum).
  • Hands on experience with Microsoft Office products such as Word, Excel, PowerPoint, Visio, Access and MPP
  • Able to work under tight deadlines and rapidly changing priorities with proactive, creative & focused approach to business needs with high analytical skill and team playing skills.
  • Flexible and versatile to adapt to pristine environment and work on any challenging project

TECHNICAL SKILLS:

Test Management Tools: HP ALM/Quality Center, JIRA and Pivotal Tracker

ETL Tools: Ab-Initio, Talend, Informatica, Data Stage

Automation Tools: HP QTP/UFT, Selenium IDE, Web Driver, Cucumber, Jenkins, Puppet, Excel Macros

Programming Languages: C, Java, Python, Pig, PL/SQL, BTEQ

Scripting Languages: Ruby, Python, JavaScript, UNIX Shell Script, VBScript

Web Technologies: HTML, CSS, JavaScript, VBScript, XML

Database: Teradata, Hadoop, Hive, Oracle, DB2, SQL server, MySQL and Sybase

FTP Tools: Win SCP, Core FTP, File Zilla and IBM Passport PC to Host

Operating systems: UNIX, Mac and Windows XP/7/10

Software Methodologies: Waterfall, Agile and Extreme XPOther Tools: GIT, GIT HUB, SVN, Teradata SQL Assistant, Microsoft SQL Server, DB Visualizer, PL/SQL Developer, Toad, Tivoli Work Load Scheduler, Tidal Scheduler, Putty, IBM Zypher Passport, Microsoft Office Products (Visio, Excel, Word, PowerPoint, MPP), MS Access and Notepad++

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

QA Lead - ETL/Big Data & Automation

Roles & Responsibilities:

  • Analyze Business Requirements Documents and System Requirements Specification to develop new QA procedures and recommend changes for effective testing process.
  • Responsible for environment configurations, data setup, user accesses to the team members, preparation of master test plans, test cases, and application installations and testing schedules.
  • Conducted review meetings and presentations with Business users for Master Test Plan and Test Strategy and also involved in Design Review Meetings
  • Lead process improvement activities to identify and resolve quality related issues across organizational boundaries.
  • Review the Test Cases & Requirement Traceability Matrix and suggest with improvements in the test case preparation for all the scenarios covered.
  • Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
  • Running the jobs and validating the tables and files after completion of the jobs.
  • Develop and maintain the daily/weekly/monthly report of Quality Data and report to Project Management to have the visibility of defect trends and identify areas of improvement.
  • Source & Target data validations in Teradata, Hadoop and DB2 and validating the Micro Strategy Reports & Dashboards in iPad and iPhone and UI Applications
  • Establishing structured QA and QC processes, and test environments.
  • Expertise in analyzing the requirements and provide efforts estimation to the management for the EDW projects
  • Involved in the Master Test Plan, Test Approach and Test Summary Report for Code Approvals.
  • Defects Management, Requirements Management using HP ALM & QC.
  • Monitor the Non-Functional Testing activities such as Implementation, Back-out, Monitoring, Security, Batch Performance Testing and Job Scheduling
  • Production Support and coordinating with different teams across organizations for post implementation validations
  • Participate in UAT with end users to provide them technical guidance and data set up needs. Coordinated both development and QA offshore-onshore teams to accomplish testing goals.
  • Daily, Weekly and Monthly Status Reports to report the status of the projects to the stakeholders
  • Identifying automation of repetitive tasks, time taking tasks and suggesting and implementing tools using VBA to benefit the Project

TECHNOLOGIES /SKILLS USED: HP ALM 12.01, Teradata 14, Oracle, DB2, Hadoop, Hive, SQL Server, UNIX, Windows 7, Windows 10, Ab-Initio, BTEQ, Teradata SQL Assistant, Putty, DB Visualizer

Confidential, Atlanta, GA

QA Lead - Manual & Automation

Roles & Responsibilities:

  • Gathering Business Requirements Documents and System Requirements Specification to develop new QA procedures and recommend changes for effective testing process.
  • Interacting with client for project updates and query resolution
  • Preparation of master test plans, test cases, and testing schedules and conducting the reviews.
  • Lead process improvement activities to identify and resolve quality related issues across organizational boundaries.
  • Review the Test Cases & Requirement Traceability Matrix and suggest with improvements in the test case preparation for all the scenarios covered.
  • Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
  • Develop and maintain the daily/weekly/monthly report of Quality Data and report to Project Management to have the visibility of defect trends and identify areas of improvement.
  • Source & Target data validations in Hadoop and Oracle with the Input and Output Feed files.
  • Establishing structured QA and QC processes, and test environments.
  • Defects Management, Requirements Management using HP ALM & QC.
  • Participate in UAT with end users to provide them technical guidance and data set up needs. Coordinated both development and QA offshore-onshore teams to accomplish testing goals.
  • Leading multiple offshore teams, assigning the task and reviewing the deliverables and reporting status/issues to client.

TECHNOLOGIES /SKILLS USED: HP QC 10, Teradata, Oracle, DB2, Hadoop and Hive, UNIX, Windows 7

Confidential, Denver, CO

Sr. Quality Assurance Analyst

Roles & Responsibilities:

  • Interacting with client for project updates and query resolution
  • Gathering and understanding client requirements and configuring tool based on requirement provided by the client
  • Assisting the Test lead in preparation of test strategy and effort estimation
  • Involved in Test case preparation, Test data preparation, Test case reviews and approval etc.
  • Raising the defects, tracking for its closure and preparation of defect report.
  • Analyzing work requests from Onsite.
  • Reporting the progress of the Project on a Daily/ Monthly basis to Team Leader and Onsite Counterparts.
  • Involved in Integration testing, Regression Testing, execution of Test cases, capturing, reviewing and analyzing test results.
  • Attending weekly project checkpoint meetings and addressing issues related to test activities.
  • Coordinating with the Team members on task to be done.
  • Preparation of Test Summary Report

TECHNOLOGIES /SKILLS USED: HP QC 9.2, Data Stage, Data Mart, Oracle, DB2 and Sybase, UNIX, Windows XP

Confidential, Mountlake Terrace, WA

Sr. Quality Analyst - Automation

Roles & Responsibilities:

  • Analyzed and defined testable requirements created and implemented test plans.
  • Developed Test Cases/Conditions for manual testing of the above Applications and Reports.
  • Involved in performing functional, application, integration, system and regression Testing
  • Created the Test Claims for PHP Facets.
  • Interacting with client for project updates and query resolution
  • Gathering and understanding client requirements
  • Preparation of Automation strategy and effort estimation
  • Creation of Script creation in HP QTP 10
  • Creating common library function files.
  • Preparation of Daily and Weekly status reports and Test Summary Report
  • Uploading the Automation Scripts and results to QC.

TECHNOLOGIES /SKILLS USED: HP QTP 10.00, HP QC 9.2, EDM Eagle PACE, Oracle, DB2, UNIX, Windows XP

Confidential, Dallas, TX

Quality Analyst - Manual

Roles & Responsibilities:

  • Developed deep relationships within the client organization and build effective cross-Functional Teams across diverse stake holder groups including client business and technical organizations.
  • Communicated defects to developers and log bugs encountered in Quality Center during test execution phrase, create defect tickets and followed up with appropriate developers until all issues were resolved.
  • Performed Functional, Negative, Regression and smoke tests on enhancements to the web application.
  • Analyzing and understanding the Business Requirement provided by the client for the project and preparing test scenarios for the same.
  • Involved in Test case preparation, Test data preparation, Test case reviews and approval etc.
  • Raising the defects, tracking for its closure and preparation of defect report.
  • Reporting the progress of the Project on a Daily/ Monthly basis to Team Leader
  • Involved in execution of Test cases, capturing, reviewing and analyzing test results.

TECHNOLOGIES /SKILLS USED: HP QC 9.2, Data Mart, Oracle, DB2, UNIX / Windows XP

Hire Now