SANJEEV SUBRAMANI
Email: sanjeevsubramani05@gmail.com
Mobile No: +91 7904088125
Career Objective
Over all 2.9 years of experience in ETL Testing, Database Testing, Functional
Testingand Data Analytics.
Professional Summary
Having 2.8 years of experience in ETL Testing, Database Testing and Functional Testing.
Having hands on Experience in Data Warehousing concepts.
Interacted with Business Analysts to understand the Business Requirements and in
response developed the Technical Design docs.
Experience in test planning, test design, test execution and defect reporting in Agile.
Strong SQL skills for creating the queries to compare data between the report and
database.
Good exposure to STLC (Software Testing Life Cycle) process, Defect life cycle and Data
Quality Process.
Experience in writing SQL scripts for Data migration testing, database testing and
Report testing.
Experience in Bug reporting tools like JIRA.
Excellent exposure in data analysis.
Executing the test cases and raised the defects in defect tab.
Experience inwriting SQL scripts, Index, Views and Joins.
Involved in business requirement gathering, performed gap analysis, feasibility
study for the given requirement and in users training during UAT process.
Education Details
Bachelor of Engineering (B.E) in Mechanical Engineering (2013-2017) from United
Institute of Technology, affiliated to ANNA University.
Work Experience
Currently working with Softech Infinium Solutions LTD, Bangalore as Software Test
Engineer from Feb 2021 to till date.
Technical Skills
Testing Data Warehouse - ETL Testing, DB Testing ETL Tool Informatica
Database - Oracle
Test Management Tool - JIRA
Language – SQL, Python(Basic), Java(Basic)
Operating System - Windows 11
Certification - Lean six-sigma green belt, IATF 16949:2016, ISO9001:2018.
Project Details
Project #1:
Client-name: BODY THUG
Description: Body Thug deals with Health & fitness business and sports equipment
manufacturer based in US since 1992. Generally, the business includes Fitness equipment,
Dietary supplements and home work out videos.
Roles and Responsibilities:
Written and executed SQL queries to validate the data.
Verification and validation of Informatica mappings for extracting the data from External tables
and loading it to Target Tables.
Followed Agile/Scrum Methodologies for all of the project activities.
Prepared daily status reports with details of executed, passed, and failed test cases and
defect status.
Execution of Test Cases and reporting the bugs through defect tracking tool JIRA.
Validated data in Target database according to business rules.
Verifying the column mapping between source and target databases.
Reporting bugs for the failed test cases and tracking the status.
Developed, Reviewed & Executed Test Scripts and Designed test data.
Project #2:
Client-name: NORDSTROM
Description: W. Nordstrom and Carl F. Wallin, it originated as a shoe store and evolved into
a full-line retailer with departments for clothing, footwear, handbags, jewelry,
accessories, cosmetics, and fragrances. Some stores feature home furnishings and
wedding departments, and several have in-house cafes, restaurants, and espresso bars.
Roles and Responsibilities:
Involved in sprint planning meeting.
Involved in functional study of the application to understanding the story cards.
Running the jobs/Workflows for ETL process.
Involved in Testing mainly ETL testing.
Involved in developing the test cases of smoke, regression and end to end scenarios.
Prepared and ran SQL queries to verify Dimensional and Fact tables to have correct
computed values.
Verifying the data in the target database by ETL process.
Verified column mapping between source and target.
Involved in daily scrum meetings and updated daily status reports.
Involved in review test cases and participated in review meetings.
Involved in execution of smoke, Regression, and end to end scenarios for each release.
Involved in defect tracking, management and reporting activities.
Involved in sprint retrospective meetings to prepare sprint retrospective
document.
Personal Details
PAN No : FNBPS4656H
Date of Birth : 05.11.1995
Address : 54 SLV Nilaya, 6th cross 10th main friends layout ext.
Chinnapanahalli Bengaluru - 560037.
Declaration
I do here by declare that the information furnished above is true to the best of my knowledge.
Sanjeev S
