• 2.5 years of experience in Data warehouse testing (ETL Testing) and Business Object report testing in Life Sciences domain.
  • Strong background in SQL queries and Excel VBA writing.
  • Experience working with huge volume of data, analyzing data quality using SQL and PL/SQL manually.
  • Experience in developing Test Scripts, Test approach documents.
  • Experience working with software development methodologies like iterative and waterfall.
  • Able to automate ETL testing using Excel Macros.
  • Experience in complete life- cycle of test case design, test plans, test execution, defect management.
  • Experience working with PL/SQL for regressing testing.
  • Strong in data warehousing concepts, dimensional model, and ETL Testing.
  • Dynamic team player who is consistently motivated towards success and completion of project.
  • A Quick learner who can swiftly adapt to new challenges.

Work History

Work History
Mar 2013 - Present

ETL Test Analyst

Cognizant Technology Solutions

Project : Astrazeneca Amazon Global Finance

Roles and Responsibilities :

  • Developing complex SQL Queries from technical specifications to test the business logic and data transformations.
  • Testing ETL effectively with no defect leakage.
  • Developing ,reviewing and executing Test Scripts.
  • Testing complex Business Object Webi Reports (both interface and data) using excel and SQL queries.
  • Participate in full lifecyle of testing.
  • Reporting bugs in sharepoint , following up defects and retesting of defects.
  • Reducing the testing efforts using Excel VBA and PL/SQL.
  • Work with developers and team lead to develop test plans, test scenarios and script through all part of testing cycle.
  • Performing data reconciliation using SQL scripts.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Defect management to ensure quality and to test all business requirements.

Environment :

Oracle 10g/11g, Informatica Power Centre 8.1, SAP Business Objects 8.1, MS Office -2007.


Jul 2008 - Jun 2012

Bachelor of Engineering

MIT College of engineering

BE in Computer Science with 69%.

Jul 2006 - Jul 2007


Government Senior Secondary School

Higher Secondary from Rajasthan Board with 81%.

Jul 2004 - Jul 2005


Adarsh Vidhya Mandir

Passed with 83% from Rajasthan Board.


Languages :  SQL, PL/SQL, VB 6.0, C.

ETL/Reporting Tools : Informatica, Business Objects.

Databases : Oracle 10g/11g.

Environment : Windows XP/Vista/7, MS Office 2007.


Dec 2013 - Present

ISTQB Foundation Level

Software Testing Board,  New Delhi

The Foundation Level qualification is aimed at professionals who need to demonstrate practical knowledge of the fundamental concepts of software testing.

Dec 2014 - Present

Oracle 11g SQL Fundamental Exam


This certification tests basic concepts of SQL and RDBMS.

Awards and Achievements

  • Received Rising Star  from cognizant for good performance as fresher.
  • Received Feather in Cap Award for Exception performance.
  • Appreciations from client for timely execution and delivery.