M IRFANALI Email id: adiau1@r.postjobfree.com

Software Test Engineer Mobile: +91-889*******

SUMMARY:

Having 3.3 years of experience in ETL/DWH Testing & Manual Testing

Good knowledge on Data warehouse concepts

Hands on experience in writing SQL Queries

Hands on experience on Jira and Quality Center test management tool

Good knowledge on Defect Life Cycle

Experience on Oracle database

Extensively used Workflow manager, Workflow monitor in Informatica ETL tool

Basic exposure to UNIX.

Having experience on TOAD which involves writing and executing SQL queries.

SKILLS:

Testing

DWH/ETL Testing & Manual Testing

ETL Tools

Informatica Power Center 9.5

Database

Oracle

Test Management

HP ALM & Jira

Languages

SQL

Operating System

Windows, UNIX

Cloud

AWS

PROFESSIONAL EXPERIENCE :

• Xeon Systems Pvt Ltd (Mphasis), Bangalore from Jun 2019 to till date

• Xeon Systems Pvt Ltd.(Emids), Bangalore from Aug 2017 to May 2019.

EDUCATION DETAILS:

Bachelor of Engineering from VTU University, Belgaum in 2016.

PROJECTS:

Project#1

Project Name : Cellular report analysis

Client : Cellular, USA

Environment : Oracle 11g, Informatica

Role : Software Test Engineer

Description:

United States Cellular Corporation, doing business as U.S. Cellular, is a regional carrier which owns and operates the fifth-largest wireless telecommunications network in the United States, serving 5 million customers in 426 markets in 23 states, The Company has its headquarters in Chicago, Illinois. It has huge number of customer overall USA . It have heterogeneous sources and it extract the data from the different sources and loads the data into the DWH .It have the reports and it helps to analyses profit and loss based on Quarterly and yearly base

Responsibilities:

Understanding the business requirements

Designed Test scenarios and Test cases

Involved in writing SQL Queries for Data Validations

Executed test cases in QC

Run the Informatica Workflows for ETL Process

Validated data in Target database according to business rules

Prepared SQL queries and executed to validate the ETL processed data in target database.

Verifying the column mapping between source and target databases

Worked closely with Dev team

Project #2 : Countdown Retail Warehouse

Client : Countdown New Zealand

Environment : Oracle 10g, Informatica

Role : SoftwareTest Engineer

Description:

Countdown, NZ, Retail food stores, which is one of the organizations that sells various number of products. Countdown has various stores across NZ, which maintains sales, Profits with lot of historical data. This project was to create sales data warehouse and generate reports using reporting services. The aim of sales data warehouse is to analyze the sales and profit in month wise, year wise. The data gets refreshed yearly and is maintained historically. This data warehouse plays a major role in enabling various stores to view the data at the lowest level and help them to make decision to bring more revenue to company with a new polices.

Responsibilities:

Involved in understanding the business requirement

Involved in running the ETL Jobs for ETL process

Designed, Reviewed & Executed Test cases

Prepared SQL queries for data validation

Verifying the data in target database after ETL process

Interactions with BA &Dev teams to resolve the issues.

Reporting daily testing status report

Identified Test cases for Regression testing

Defect Analyzing and Reporting in QC

Project#1

Project Name : MICROFINANCE NETWORK HELPLINE Client

Client : Zolt Info Solutions Pvt Ltd

Environment : SQL server, QC

Role : Test Engineer

Description:

MNHL is a Micro Finance Network helpline which was developed for both Windows and Web Application. Where a call center was developed for registering the Complaints on Different MNHL companies and can be followed upon the complaints which were raised in windows application. It’s purely developed for users to register complaints and they can follow up the registered complaints. Web Application is used for MFI Agents, MFIN Admin and Govt. Officials, where they can view the complaints which are pending, In-Progress and Closed. Here, Govt. Officials can view the complaints of all companies and can give comments for each Complaint. MFIN Admin can view all companies’ complaints and can give the comments for each Complaint. MFI Agents can give the reply for the complaints which are posted on windows application.

Responsibilities:

Analyze the requirement specification documents.

Prepared test Scenarios & test cases.

Involved in System Testing and Regression testing.

Executed Test cases.

Tracking Defects using Quality Center.

Contact this candidate