VEMUL A Vemulasurya322@gmail.
com
SURYA +91- 8500156870
With 4.8 years of IT experience, I have become a skilled ETL Tester in the production and Healthcare
domains. I excel in Agile Scrum and SDLC methodology environments, adapting quickly to changing project
requirements. My expertise is in Software Quality Assurance Testing, specializing in ETL and Data Warehouse
Testing. I also have solid experience in Back End Testing, confidently writing and executing SQL Queries to ensure
data accuracy and integrity.
SKILLS
• Informatica PowerCenter • Python
• SQL • Agile Methodology
• Data Warehouse testing • Database testing
• Reporting Testing • Functional testing
• Test Scenarios • Test Cases
• Oracle • ETL Process
• Redshift • Data Validation
• Tableau • MS SQL Server
• DBeaver • Jira
• Notepad++ • Putty
• Unix commands • HP-ALM / HP-QC
• SQL Scripts • MS-Excel
EXPERIENCE
ETL TESTER – MCKESSON
Oss technologies Pvt Ltd | Bengaluru, India
OCT-2023 TO SEP-2024
• Company Overview: McKesson Corporation is an American company distributing pharmaceuticals and
providing health information technology, medical supplies, and care management tools
• The company had revenues of $231.1 billion in 2020
• Focused exclusively on Data Warehouse track.
• Analysis the Mapping document and estimate the testing process
• Performed column data mapping between source & target database
• Prepared the Test Scenario, Test cases and providing walkthrough of the same front of Project
Stakeholders
• Writing reconciliation test scripts in SQL for data moments in various layers starting from Staging layer
=> Data Warehouse layer => Semantic layer
• Developing SQL test scripts for different incremental load logics (mostly SCD type 1 and SCD type 2)
• Interacting with Clients QA team
• Defect analysis and reporting in QC
• Involved in daily standup meetings, review the test cases and participated in the review meeting
• Reporting daily testing status report and Interactions with dev team to resolve the issues.
SOFTWARE TESTER
Taltech Technology Pvt Ltd | Bengaluru, India (Remote)
JAN-2023 TO AUG-2023
• Company Overview: Moderna is an American health care company
• This project was to create HCO's and HCP's data in Data Warehouse and generate reports using
reporting service
• There are several types of data maintained like HCP, HCP data based on the country wise
• And mainly few organizations collaborate with Moderna to do the process of Health care related tasks
• Focused exclusively on Data Warehouse track
• Analysis the Mapping document and estimate the testing process
• Performed column data mapping between source & target database
• Prepared the Test Scenario, Test cases and providing walkthrough of the same front of Project
Stakeholders
• Writing reconciliation test scripts in SQL for data moments in various layers starting from Staging layer
=> Data Warehouse layer => Semantic layer
• Developing SQL test scripts for different incremental load logics (mostly SCD type 1 and SCD type 2)
• Interacting with Clients QA team
• Defect analysis and reporting in QC
• Involved in daily standup meetings and updated daily status report
• Involved in reviewing the test cases and participated in the review meeting
• Reporting daily testing status report
• Interactions with dev team to resolve the issues.
ETL TESTER
Logisol Technologies Pvt Ltd | Mumbai, India
NOV-2018 TO OCT-2021
• Company Overview: Health Care Service Corporation, a Mutual Legal Reserve Company (HCSC), and an
Independent Licensee of the Blue Cross and Blue Shield Association, is the largest customer-owned health
insurer in the United States and fourth largest overall, operating through our Blue Cross and Blue Shield
Plans in Illinois, Montana, New Mexico, Oklahoma and Texas.
• HCSC affiliates and subsidiaries such as Dear born National, Medecision and Dental Network of America
offer group life, disability and dental solutions, as well as a range of other individual solutions
• Prepared SQL queries and executed to validate ETL Processed data in target
• Prepare and run SQL queries to verify Dimension and Fact tables
• Performed column data mapping between source & target database
• Comparing record counts of Source and Target
• Interacting with Clients QA team
• Defect analysis and reporting in QC
• Involved in daily standup meetings and updated daily status report.
• Involved in reviewing the test cases and participated in the review meeting
EDUCATION
BSC Computers SRI VENKATESWARA UNIVERSITY-TIRUPATI – MAR 2018
DISCLAIMER
I hereby declare that the above-mentioned information is correct to the best of my knowledge and
belief.
