Shubham Kumar Sahu Email: Shubhmasahu410@gmai.
com
Test Engineer Ph: +919713621385
SUMMARY:
● Having 2.3 years of experience in Software Testing and experienced on ETL/DWH Testing &
manual Testing
● Good knowledge on Data warehouse concepts like Star schema, snow-flake schema, fact table,
dimension table etc.,
● Experience on Oracle database and sql query.
● Extensively used Workflow manager, Workflow monitor in Informatica ETL tool
● Having complete Defect Life Cycle knowledge and Hand on experience on Quality Center
● I have hand on experience in BI Report testing
● I consider myself self motivated and constant learner
● An exceptional performer with the ability to work in teams as well as excellent communication,
analytical, relationship management and problem-solving skills.
SKILLS:
Testing DWH/ETL Testing ,Regression Testing ,functional Testing
ETL Tools Informatica Power center
Test Management HP ALM Quality Centre
Language SQL
Operating System Windows, Unix
Other Tools Jira,SQL Developer
EDUCATION DETAILS:
● BE(MECHANICAL) from RGPV university with 6.84 cgpa
● 12th from H.S. Excellence School, indore with 78.00%
● 10th from H.S. Excellence School, chhatarpur with 87.5%
PROFESSIONAL EXPERIENCE:
Working as Test Engineer for Cognizant Technical Solution in Bangalore from June 2020 to till date.
Project Title: Insurance
Description: This project is related to healthcare insurance. Health insurance is a type of insurance
coverage that pays for medical, surgical, and sometimes dental expenses incurred by the
insured.Healthcare insurance is often included in employer benefit packages as a means of enticing
quality employees, with premiums partially covered by the employer but often also deducted from
employee paychecks. it have the hetrogenous sources it will extract the data from the different
sources and loads into the DWH and it have the reports which are used the analise the data.
Roles & Responsibilities:
● Interactions with clients for analyzing business requirements and domains.
● Creation of test plan doc based on customer requirement.
● Understand the business requirement.
● Involved in functional study of the application.
● Identified the Test case scenarios and writing details test case
● Prepared and ran SQL queries to verify the data.
● Running the ETL jobs.
● Verifying the ETL data in target database.
● Prepared test data for functional & Integration testing
● Interactions with Dev teams to resolve the issues.
● Executing the test cases and results are updated in the test plan doc
● Raise defects and report them. .
● Sending the Test status reports.
Project Title: Daily Sales Reporting Data Warehousing Project
Description: Corporate Food Store company, which is one of the organizations that sells various
products every day. This company has more branches in various locations, which maintains a Database
that has lots of previous customer details, company personal information, raw materials details, etc. This
system has an oracle 10g database which stores information about sales, profits and contacts of various
customers. The main aim of the sales Data warehousing cognos project is to analyze sales of major
brands varying with different promotional schemes.
Environment: Oracle 10g, Informatica
Roles & Responsibilities:
● Interactions with clients for analyzing business requirements and domains.
● Creation of test plan doc based on customer requirement.
● Understand the business requirement.
● Involved in functional study of the application.
● Identified the Test case scenarios and writing details test case
● Prepared and ran SQL queries to verify the data.
● Running the ETL jobs.
● Verifying the ETL data in target database.
● Prepared test data for functional & Integration testing
● Interactions with Dev teams to resolve the issues.
● Executing the test cases and results are updated in the test plan doc
● Raise defects and report them. .
● Sending the Test status reports.
