PAVAN KUMAR

Calgary, AB

Phone: +1-825-***-**** e-mail: ad4que@r.postjobfree.com

EXPERIENCE SUMMARY

Currently working as Senior Quality Analyst with 9 years of experience in Migration, Manual and Automation Analysis, Implementation and Testing.

Expertise in QA Testing in distributed Unix/Windows Environment and Oracle,Teradata databases as back end, Performed end-to-end testing.

Well versed with Manual and Automated Testing methodologies and principles.

Designing & writing Test cases according to Requirements & going on design call for sign off.

A team player with strong analytical, organizational and relationship management skills.

Extensively worked on Automation of the webservices using SOAP UI tool with Groovy scripting languages.

Strong automation testing experience in SOAP, REST and JSON API’s using Katalon Studio.

Extensive experience in testing and defect tracking using automation Tool like Azure Devops and JIRA.

Good knowledge to Software testing life cycle & Bug life cycle.

Experience in System Testing, System Integration testing and User Acceptance Testing, Pre-Production and Production testing.

Proficiency in Bug Reporting and Defect management.

Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.

ACADEMICS

B.Tech(Electronics and communication Engg.) with 69.5% (aggregate) (2007 – 2011), Jawaharlal Nehru Technological University, Andhra Pradesh.

CERTIFICATIONS

ISTQB Foundation Level Certified.

Oracle SQL Foundation Level Certified.

ISTQB Agile tester Foundation level Certified

ACHIEVEMENTS

Received appreciation from Ziggo for work in SIT.

Received PAT ON THE BACK award from British Telecom.

Received SPOT appreciation award for the automation work in SHAW Project.

TECHNICAL SUMMARY

SKILLS

TOOLS

OPERATING SYSTEMS

Windows, Unix and Linux.

DATABASE(S)

Oracle, Sql Server.

TOOLS

JIRA, Azure Devops, Katalon Studio, postman, salesforce Administrator.

LANGUAGES

Core java, J2EE, EJB, Servlets, Selenium Web driver.

ETL TOOL

Informatica power center 9.1

WORK HISTORY

Duration

Organization

Designation

April 2012 – Nov 2015

TechMahindra Ltd.

Technical Associate

Nov 2015 – Jan 2023

Net Cracker solutions

Senior Quality Analyst

Jan 2023 – till date

Procom

Quality Assurance Analyst

WORK EXPERIENCE

Project Name 1

SHAW System Integration.

Client

Duration

Shaw Telecommunications(Canada)-onsite

Nov 2015 to Till Date

My Role: As a team member I was involved in the following

Involved in querying using SQL and updating records and validate database records as expected.

Developed test scenarios for manual and automated functional, integration, system and regression tests.

Used Katalon Studio to design,plan and create automation tests.

Provided Test estimates and involved in test planning, execution and defect analysing, tracking and reporting

Coordination with the system, business analysts, development group and client along with test execution activities and ensuring that the client’s QA requirements are met.

Involved in Testing Production Hot-fixes and identified the Root cause for the production issues.

Performed several SHAW Releases builds and patches installation in SIT environments by using Jenkins.

Conducting the status meetings and sent the Status Report (Daily, Weekly etc.) to all the Stake holders.

Working as the main point of contact between Development, Testers and Release teams.

Updated JIRA with the latest status and sending everyday Status reports to the Client.

Configured Proucts,Promotions and Business rules in the SHAW Production catalogue.

Involved with Design calls and End to End Test scenario preparation.

Coordination with the development, execution and evaluation of different test levels (SIT, E2E, UAT).

Project Name 2

Ziggo Zumba Fulfillment Migration

Client

Duration

Ziggo Telecommunications(Netherlands)-onsite

Jan 2014 to Nov 2015

My Role: As a team member I was involved in the following

Solid experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Involved in testing data migration from Legacy database to Strategic Systems.

Actively participated in developing Scenarios based on the mapping documents provided by the client, designing and execution of test cases and SQL Queries for the test cases.

Been involved in analyzing requirements and Documentation of impact analysis documents.

Involved in Tracking and analyzing defects across various cycles of testing (System Testing and Regression Testing) thereby taking sole responsibility on deliverable perspective.

Strong skills in Oracle10/11g programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views.

Good Knowledge on Oracle E-Business Suite for Order provisioning and Fulfillment.

Thoroughly tested ETL scripts (PL/SQL) to read the data from dat files to load the data into Target Staging tables. These ETL scripts also include logging the status or debugging statements into Central Migration Controller.

Created and executed SQL queries to perform source to target testing on Oracle database. Performed the following tests:

DATA COMPLETENESS

VALIDITY

UNIQUENESS

DATA INTEGRITY

DATA TRANSFORMATION

DATA QUALITY

Guiding the Team members, allocating the tasks to offshore & leading SIT support team from Offshore.

Involved in Writing / Reviewing Test Objectives.

Contact this candidate