Professional Summary:

Very passionate ISTQB Software QA with over 9 + years of experience in Quality Assurance, Web/Mobile application, ETL, Functional testing.

• Implementing effective improvements in process and practices

•Improve software quality and customer experience by implementing processes which are efficient, drive towards consistency, leverage tools, use industry best practices, and are regularly measured, evaluated and improved

•Knowledgeable in CMMI, Six Sigma, ISO 9001 and Rational Unified Process

•Strong aptitude and practical experience in managing and implementing continuous software quality process improvement with small to medium size teams as a test lead

•Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica 8.6 & SQL Server Integration Services (SSIS 2012)

•Hands on experience with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions, Metadata and Star schema/Snowflake schema.

•Experience in Software Testing for Web, Mobile, Migration, GUI and Standalone applications of complex systems on different domains.

•Experience in Sanity, Functional, Regression, System Testing, End to End Testing, Black Box, GUI testing, System Integration Testing (SIT), User Acceptance Testing (UAT), White Box Testing, Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

•Hands on experience in preparing Test Plan, designing test cases by decomposing Business Requirements, planning, execution and reporting through a combination of fundamental structured testing techniques and rapid testing practices

•Good domain experience in Financial services, Insurance and E-commerce.

•Active member of Agile (Scrum) team followed daily Scrum calls, Scrum standards.

•Highly experienced in developing Manual Test Cases, Test Plans, Test Execution, Defect tracking, and Report generation, documentation of test results, test deliverables.

•Experience of communicating with the stakeholders for review and finalizing the requirements.

•Working Knowledge on Tableau, Arc GIS tools.

Technical Skills

Operating Systems: Windows 2003/2008 R2/2012, Linux, OSX

Programming Languages: C, C++, T-SQL

ETL Tools: Informatica and SSIS

Process Models: Agile (SCRUM), Waterfall model

Web technologies: VB Script, HTML, XML, JAVA (Basic)

Databases: IBS, FDR, SQL Server 2008/2012, MYSQL

Automation testing tools: QTP, Selenium, Soap UI

Test management Tools: ALM, Quality Centre 10.0, Bugzilla, JIRA and TFS

Xerox Corporation, Webster, New York Feb ’14 to till Date

Global Supply Chain Business Intelligence

Role: SQA Lead

Responsibilities

•Understanding, Analyzing and Identifying scenarios from the requirement document.

•Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.

•Tested the ETL mappings from Source to Target.

•Written test cases for checking the populated data correctly into fact and dimension tables.

•Responsible for creating test data for validating ETL loads.

•Validating manually ETL loads from source to target ensuring business transformation are applied as expected writing SQL queries.

•Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.

•Attending requirement-gathering meetings with Project Manager, Business Analysts, Architecture team and Development team.

•Worked on SQL Server, Stored Procedures, Functions.

•Planning all the testing activities like Test Planning, Test Estimation and scheduling of QA activities, Test Strategy, Test Case Design, Requirements Traceability matrix, Review, execution and Reports.

•Planning and execution of, Functional, Regression, Integration, System, Compatibility, and User Acceptance testing.

•Reporting test results and working closely with project team members on issue resolution and process optimization.

•Participated in daily scrum meetings, requirements/story review meetings, and design reviews and preparing release notes for each sprint.

•Reported issues/blocker/regression issues to test Manager and Scrum master .

Environment: Windows Server 2012/ 7, Informatica, SSIS, SQL Server 2008/2012, JIRA,

ALM, TFS

Arizona Department of Education, Phoenix, AZ Nov ‘12– Feb’14

SAIS

Role: QA Analyst

SAIS (the Student Accountability Information System) is a new administrative application that collects student detail information using the Internet from all the school districts and charter holders and then send to ADE’ SAIS database.

Responsibilities:

•Identified data streams and reviewed data models for testing strategies

•Identifying duplicate records in the staging area before data gets processed

•Extensively written test scripts for back-end validations

•Ensured that the mappings are correct and conducted data validation testing

•Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

•Validating the Archive process to purge the data that meet the defined business rules.

•Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle..

•Detailed Business Requirement analysis

Environment: MS Office, Test Director Windows Server 2000, Informatica, SQL Server, DTS,

Xerox Corporation, Webster, NY Sep’09-Sep’12

Docusp

Role: QA Tester

DocuSP is basically network print server software. It accepts print jobs from various network (OR Mainframe) clients, spool the jobs and sends them to the connected printer. DocuSP is a common front-end solution to provide a familiar interface across the various product lines.

Responsibilities

•Understanding Requirements.

•Planning and Executing test cases, Reported defects in A R Tool.

•Involved in functional, reliability, performance and User Interface Testing.

•Preparing daily and weekly reports.

•Participated in status meetings showing the progress of test case execution.

•Interacted with customers, designers, and supervisor to determine needs and desires for project direction and documentation.

•Giving creative suggestions to the customer and receives customer input and instructions.

•Developed Automated Test Scripts Using DAML.

•Resolved hardware/software issues with systems

•Contributed to the product documentation, including online help

Environment: Manual Testing, Solaris3.0, A R Tool, MS-SQL, WebSphere 5.0, J2EE,XML

Yahoo Software Development, Sunnyvale, CA Oct’08-Sep’09

Yahoo Hot jobs

Role: QA Tester

In this project, jobs are scraped from the paid sites and are posted onto the hot jobs Site. A order is created in the bugzilla that defines the initial specifications.

Responsibilities:

•Database Testing to verify the number of jobs and to test various other fields.

•Checking for LDIF errors.

•Updating the Test Case Sheet and Executing the Test cases.

•User Interface Testing.

•Defect Reporting in Bugzilla.

•Uploading the agent and the subsequent Test Case Sheet via Twiki.

•Preparing daily and weekly reports.

•Working with two team members and reviewing there work.

Environment: Bugzilla, J2EE, WebSphere5.0, HTML, JavaScript, XML, oracle 8,Twiki

Yahoo Software Development, India May’06-Aug’08

Yahoo! Local

Role: QA Tester

Yahoo! Local helps you find the things you need in your neighborhood and beyond. It gives you the names and numbers of local services and businesses but it also shows you information related to them.

Responsibilities:

•Test Case Execution and manual testing and regression testing.

•GUI & Functional errors based on specs.

•Analyzed system requirements and wrote test cases for testing the application and Prepared bug Report

•Involved in testing of database using SQL queries

•Reported software mismatches to the development team using Win Runner

•Involved in the End-To-End test and responsible for the Quality Performed hardware support as necessary in both production and testing environments Identified and documented the additional functional requirements of the updated system and mapped them to the individual test case requirements.

•Participated in the entire Testing lifecycle processes including Integration Testing, UserAcceptance Testing, and System Testing along with the Entry/Exit criteria for each phase of testing.

•Participated in regular project status meetings ranging from updates on the company’s SDLC Bug Report and Defect Life Cycle reports meetings.

Environment: HTML, SQL Server, Bugzilla,Twiki, Test Director.

Education and Certifications:

Masters in Communication Engineering

Completed course and certification on Data Visualization and Communication with Tableau by Duke University (Coursera 2016)

Certification program on Geographic information system at San Jose State University [2013-2015]

Contact this candidate