Engineer Data

MAKDUM IRFAN Email: ********.*****@*****.***

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

SUMMARY:

Having 3.6 years of experience in Software Testing

Having experience on 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 & SQL Sever

Extensively used Workflow manager, Workflow monitor in Informatica ETL tool

Basic exposure to UNIX.

Good knowledge on AGILE, STLC and SDLC Concepts.

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 :

Worked as Software Test Engineer for :

• PWC, Bangalore from Aug 2019 to Dec 2019.(Contract)

• Mphasis, Bangalore from Jan 2018 to Aug 2019.

• Ness Technologies, from June 2016 to Dec 2017.

EDUCATION DETAILS:

Bachelor of Engineering from VTU University, Belgaum in 2016.

PROJECTS:

Project#1

Project Name : TDIC report analysis

Client : The Dentist’s Insurance Company, USA

Environment : SQL Server, Informatica

Role : Software Test Engineer

Description:

TDIC’s mission is to support dental professionals in their practice and service to the public by providing the best value insurance products and related services.

TDIC’s Claims Lines of Business following mainly Professional Liability, Commercial Property.

Responsibilities:

Understanding Requirement Specifications and Design Documents.

Involved in writing test cases and execution of test cases

Involved in writing SQL Queries for Data Validations

Executed test cases in JIRA

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

Investigating Bugs, Reporting and Tracking using JIRA tool.

Providing detailed analysis on each defect to fix the cause.

Actively involved in Daily status Call & discussion with the Onsite Team.

Project#2

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 #3 : Woolworth Analysis System

Client : Woolworth, UK

Environment : Oracle 10g, Informatica

Role : SoftwareTest Engineer

Description:

Woolworth, UK, Retail food stores, which is one of the organizations that sells various number of products. Woolworth has various stores across UK, 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#4

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