*+ Years of experience in Software Testing and Quality Assurance including Database Testing SSIS Package - Datawarehousing –DWH-ETL tesing

Strong experience with Mediation,Siebel CRM,Telecom BSS/OSS,Payment System, Big Data analytics [DWH+BI]System/Domain.

Analyse ETL Requirements and Mapping sheet with BA

Map Source and target data In term of Duplicate, Count, Nullable,datatypes,constraint, length.

Involved in the analysis of source systems, gathering business requirements and identification of business rules.

Prepared and ran sql queries to verify Dimensional and Fact tab les,Verifying the data in target database by ETL process, Transformation logic is applied before loading the data.

Knowledge of all Datawarehousing /DWH concepts, Good understanding of OLAP, OLTP, Star schema, snowflake schema.

Understand and analyse SRS to ensure it meets the Customer requirement, Responsible for Test Case Writing, Execution, Bug Tracking and Reporting.

Actively involved in Review of test Case, Performed Functional, Integration and Retesting, Regression, Sanity, and Database testing.

Enough exposure to all stages of SDLC, Mapped the business requirements with test case by preparing Traceability matrix. Strong knowledge over whole Software Test Life Cycle (STLC).

Work closely with other testers and developers with bug fixes and Defect Analysis Using defect management tool such as JIRA

Wrote SQL queries to access the data from the database tables to ensure data integrity.

Strong Knowledge about UNIX Commands to validate server data,A result-oriented team player and skillful in coordinating with development team and problem solving abilities.

Capable of working under time constraints in a target-oriented environment.

Self-motivated, Pro- Active and Quick learner of new concepts and technologies.

Currently working as Associate ( Software test engineer) with Cognizant (Kuala Lumpur,Malaysia October 2022 – Present )

Previous Work Exp :- Associate - cloud big test engineer in IBM Pune 411 037 (May 2019 – August 2022)

Project Sequence 1

Project Name : Data Migration and historical data loading for Malaysia

Client : Union Overseas Bank (UOB) Malaysia

Technology : ETL testing, Query Surge,SQL

Project Title : Banking

Project Description :Migration of data from one bank to another for better business purpose.where as in data of customers eg. Customer Credit/ Debit card transaction details, Loan transaction details,Customer details reviewing and processing as per business requirement.

Task Handled:

Experience in Agile methodology.

Good knowledge of Software Development life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Reviewed and Analyse Business Requirements, Functional Specifications, and Detailed Design documents (including UML).

Updated test plans, created test cases and test scenarios for assigned functional areas (including Transact SQL queries for data validation).

Analyzed and identified the Test Cases based on requirement document of the application.

Verify data is mapped correctly from source to target system

Verify all tables and their fields are copied from source to target

Verify keys configured to be auto-generated are created properly in target system

Verify data is neither garbled nor truncated,Verify data type and format in target system is as expected

Verify there is no duplicity of data in the target system,Verify transformations are applied correctly

Verify that the precision of data in numeric fields is accurate

Insert a record which is not loaded into target table for given key combination

Copy records, sending same records that are already loaded into target tables-should not be loaded

Update a record for a key when value columns changed on day_02 loads,Delete the records logically in the target tables

Values loaded by process tables, Values loaded by reference tables, Check if the target and source data base are connected well and there are no access issues.

For a full load, check the truncate option and ensure its working fine, While loading the data, check for the performance of the session, Check for non-fatal errors.

Verify you can fail the calling parent task if the child task fails, Reviewing and modifying the Test Cases.

Execute the test case in build and validate the impact.

Performing Smoke, Functional, Compatibility and User Interface testing.

Regression testing was performed after each new build of the application..

Executed test cases to ensure functionality meets the customer requirement

Project Sequence 2

Project Name : Historical Data Loading,Indonesia

Client : Union Overseas Bank, Indonesia

Technology & Tool : Database testing, ETL, Query Surge, Hive,SQL

Project Title : Banking

Project Description :Migration of data from one bank to another for better business purpose.where as in data of customers eg. Customer Credit/ Debit card transaction details, Loan transaction details,Customer details reviewing and processing as per business requirement E2E.

Task Handled:

Understand the FRS document and analyse the requirement.

Prepare the test case from use case

Execute the test case to validate customer requirement

Updated test plans, created test cases and test scenarios for assigned functional areas (including Transact SQL queries for data validation).

Analyzed and identified the Test Cases based on requirement document of the application.

Verify data is mapped correctly from source to target system

Verify all tables and their fields are copied from source to target

Verify keys configured to be auto-generated are created properly in target system

Verify that null fields are not populated

Verify data is neither garbled nor truncated,Verify data type and format in target system is as expected

Verify there is no duplicity of data in the target system,Verify transformations are applied correctly

Verify that the precision of data in numeric fields is accurate

Project Sequence 3

Project Name : Buyer Initiated Payment- E2E

Client : Freedom Mobile - Canada

Vertical : Payment,Telecom BSS

Technology & Tool : Database Testing, File processing, Webservice testing,job run,Report analytics Testing -BI

Project Overview

Raw Data from corporate databases is extracted. The data could be spread across multiple systems heterogeneous systems. The data is cleaned and transformed into the data warehouse. The table can be linked, and data cubes are formed. Using BI system the user can ask quires, request ad-hoc reports or conduct any other analysis. Business intelligence is a system of various solutions used to garner insights from different types of data. Driving business decision making is the primary use of business intelligence and is accomplished by utilizing different techniques to understand historical, live, and predictive data. In this bi defined page, we’ll delve deeper into the purpose of BI and specifically, it’s relation to an important element of BI, business intelligence reporting. Businesses are able to source data from external and internal systems, assemble the data for analysis, generate and execute queries against the collected data to create reports and dashboards for decision makers. Visualizations within these reports and dashboards are powerful statistical tools that empower decision makers to action data quicker. Reporting is an early step in the process of data processing. It presents data in an interactive fashion to turn it into actionable information. There can be many levels of interactivity within a report such as the ability to drill down, sort, and filter, as well as additional capabilities such as self-service editing which allows you to further explore your data for more insights. Business intelligence reporting is most beneficial when it is designed to help track and measure your strategic business goals. Other use cases for reporting tools include tracking key performance indicators, maintaining regulatory compliance, or even measuring goals between different departments or applications. Report developers and report writers use tools such as This solution Designer, our report design tool, to distinguish elements such as data sources, display formats, graphics, filters, and other options that are essential for report presentation. Enterprise reporting solutions, such as This solution, also allow end-users to create reports and dashboards directly from web application interfaces using ad-hoc data resources specified by developers. Users are therefore given the ability to generate speedy data-driven decisions through building report components, collecting various data, and designing ad hoc reports. Reports can be published to a reporting engine, such as This solution Server, which extracts data and generates reports.

Task: Handled

Properly analyse Business logic and SRS

Created and executed test cases to ensure Functionality meet Business logic

Analyzed logs generated reports and identified failures.

Identified bug trends and participated in general QA initiatives

Maintain a consistent look and feel throughout all modules

Understand the FRS document and analyse the requirement.

Prepare the test case from use case

Execute the test case to validate customer requirement

Involved in review test case and send review comments to colleagues.

Prepared mapping sheet of SRS and test case

Sending the Regular status to the higher authorities in a timely manner.

Participate in scrum meeting to discuss about project progress report every day.

Resister the defect using defect management tool such as JIRA

Project Sequence 3

Project Name : Rating & Charging & Revenue Management – E2E BSS

Vertical : Telecom BSS,Siebel CRM

Client : Freedom Mobile - Canada

Technology & Tool : Data warehousing /Etl, SSIS Package,Big Data Analytics

Detail Project Overview and Workflow :

This solution is a powerful rating and billing engine that performs the complex rating, bundling, contract management, and discounting functions that CLECs, wholesale carriers, resellers, cable companies, unified communications and IP providers demand.

The main features are

Support for corporate hierarchies, Order Management automation, Product management and pricing for any business model, One bill for any service, Capture all your revenue, Integrate with ease, Agent support

Roles and Responsibilities

Reviewed Business Requirements, Functional Specifications, and Detailed Design documents (including UML).

Updated test plans, created test cases and test scenarios for assigned functional areas (including Transact SQL queries for data validation).

Analyse mapping sheet and verify source and target system

Use complex queries to check output to ensure it meets the business logic

Executed test cases to ensure functionality meets the customer requirement

Logged and regressed bugs using Jira

Email:- adxqb9@r.postjobfree.com

Mobile Number:- +60-199-**-****

D. O. B - 23-05-1993

EXPERIENCE SUMMARY

WOKING ZONE – ORGANIZATION

PROJECTS

PERSONAL DETAILS:

Contact this candidate