Manjinder Dayal

Cell: 647-***-****

Email:ac7j38@r.postjobfree.com

PROFESSIONAL SUMMARY:

●8 years (ISTQB Certified Tester) QA Analyst with full system development life cycle experience, including Functional and Non-Functional Testing activities.

●Extensive experience in ETL and Report Testing using Red Point Data Management & IBM Congo’s tool.

●5+ years’ experience in Back End Testing, and developing of SQL Queries for database testing.

●Expertise in writing complex SQL Queries in Oracle, MS SQL Server.

●Experience in Financial sector with large clients like Bank of America, Fifth Third, and JPMorgan regarding banking application testing.

●Worked closely with Scrum master, BA and other team member in Agile.

●5 years of experience in Project planning, Sprint meeting, Retrospective.

●5 years of experience in agile environment and Onshore/offshore model.

●Create complete system testing documentation and Test Plan, Test Scenario and Test Cases for Functional and Non-functional Requirements.

●Experience in Testing of Web-based applications, Batch Jobs and Data Replications.

●5 years of experience in Web Services testing via SOAP UI tool.

●Strong working experience in Database Testing with writing complex SQL queries.

●Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile (Scrum).

●Vast experience in different testing methods such as Functional, System, Regression, Integration, Performance, Security, Positive, Negative, End to End, UAT.

●Working experience with applications based on UNIX, Java Servlets, SQL, Win 2000/XP.

●Experience in programming language like JAVA, XML and HTML.

●Experienced in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.

●Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.

●Experienced in Test Management Tool like HP Quality Centre Tool (HPQC), Zira.

●Experienced in Microsoft TFS & possess excellent understanding of Testing Process.

AREAS OF EXPERTISE

QA Testing

ETL Testing

Functional

System

Regression

Integration

UAT

CERTIFICATIONS AND ASSOCIATIONS

●ISTQB Foundation level Certification

TECHNICAL SKILLS:

Testing Tools

Selenium IDE, HP Quality Center(ALM), Jira, SQL, SoapUI, Soap Ui Pro

Programming languages

Web Technologies

Java,.Net

Perl, HTML, DHTML, VB Script, ASP, Web Services Java Script, Java Servlets, JSP.

Web Server

Java Web Server, BEA WebLogic, IBM WebSphere, Microsoft IIS

Operating System

UNIX, Linux, Windows

Primary Skills:

●ETL Testing

●SOAP UI

●Web services testing

●Mobile Application Testing

●Microsoft Team foundation server

●SQA Testing & Methodologies

●Manual Testing

●Test Automation

●Test Plans, Test Cases

●Functional Requirements

●Regression & Negative Testing

●SIT, BAT, UAT

●Data Interface & Migration Testing

●Defect/ Bug Tracking

PROFESSIONAL EXPERIENCE:

The Marketing Store Worldwide, Toronto (Mar 2014 – June 2018)

Role: ETL Tester

Responsibility:

Analyzed Business Requirements documents to get a better understanding of Business Perspectives.

Involved in Writing the Test Cases and Test Plans based on Source to Target Documents in JIRA.

Involved in extensive data validation using SQL queries as a part of Back-end Testing.

Involved in Mapping the Test Cases with the Requirements and Mapping Document.

Involved in writing Test Cases for Enterprise Data Warehousing (EDW) Tables in JIRA.

Mapping Doc Validation - Verifying if the ETL information is provided in the Mapping Document.

Designing Test Plan, Test Strategies, traceability matrix and writing detailed Test cases based on technical spec.’s/ SRS documents and presented business cases to team.

Closely work with Product Owner, Scrum Master and other team member in agile environment.

Data Check - Every aspect regarding the Data such as Data check, Number Check, Null check are tested in this case.

Also performed the checks on the various Business rules as well the different error codes that should be populated.

Used Red Point Data Management as an ETL tool.

Used Red Point Interaction to generate the automatic emails to the various customers on a daily and a weekly basis.

Extracted Data from the Old Legacy database to the new database with some changes and new functionalities.

Logged the Defects while executing the Test Cases and assigned it to ETL Developers using JIRA.

Extensively tested several reports for data quality, fonts and headers.

Ensures that all expected data is loaded in to target table.

Comparing unique values of key fields between source data and data loaded to the warehouse.

Prepared Test Defect Metrics on a Weekly basis to know the status of the application.

Status reporting on daily and Weekly basis to Manager-QA.

Coordinated with different users in UAT process.

Fidelity National Information Services, Toronto (May 2010 – March 2014)

Role: QA Analyst

Banking Bill Payment

Description: A banking payment system for making standard check/electronic payments to business payees or personal payees using their account numbers or addresses. It consisted of modules to check balances, Review transactions, transfer funds from Checking and Savings accounts, email money & pay a bill.

Responsibilities:

Involved in Agile Methodology to develop Project Management plans, Test design and execution

Developed Mockups, Use Cases and having discussions with Business Analysts.

Designed and developed Test plans and Test scripts that capture all software defects resulting in software products that are as close to defect-free as possible

Analyzed the business requirements and wrote high level Test plan, Test case and Test scripts in the HP Quality Center (ALM).

Managed the testing task on Microsoft Team Foundation Server and attended daily status report meeting with Scrum Master in Agile environment.

Performed banking apps testing on different mobile devices like iPhone.

Batch job testing on Unix server.

Wrote and executed SQL queries for database testing.

Responsible for gathering the Business requirements, User Requirements and Functional specifications for Test execution.

Used selenium Ide for regression testing.

Participate in Retrospective, Scrum Planning, Raised impediments and worked closely with Product Owner to understand the user stories.

Maintained the Tractability matrix used to organize Requirements and Test cases

Conducted Integration, Functional, System, GUI, Regression, Smoke, and User Acceptance Testing.

Worked with the Development and Production teams in resolving the issues related to the defects identified during the development and production phases

Actively participated in walk-through, weekly QA status & Defects meetings.

Tracked & logged all the defects in defects Management of HP Quality Center (ALM).

Environment: Java, UNIX, Oracle, Microsoft TFS, XML Web Services, SQL, web services (SOAPUI), HPALM

EDUCATION

●Master of Business Administration(Information Technology)

●Bachelor of Computer Science Engineering

Contact this candidate