Pavan Kumar Thanneru
Memphis,TN
Summary
Overall, two years eleven months of experience, Dedicated and meticulous ETL (Extract, Transform, Load) Tester with a proven track record of ensuring data accuracy, integrity, and reliability within complex data warehousing environments. Proficient in SQL queries and testing methodologies, I specialize in validating the successful execution of data extraction, transformation, and loading processes. My expertise includes data mapping, record count validation, and defect reporting to maintain the highest standards of data quality.
Overview
3
3
years of professional experience
Work History
Test Engineer
Future Focus Infotech Private
Chennai, Tamil Nadu
06.2022 - 11.2022
- In my role within the American investment management and wealth management division of Bank of America, I used SQL queries extensively to validate ETL processed data in the target system.
- This validation step was crucial in detecting any discrepancies or data losses that might occur during the ETL process.
- Collaborating closely with the Clients' QA team was an integral part of my role.
- This experience reinforced the importance of adaptability, proactive problem-solving, and effective teamwork in the dynamic field of ETL testing.
- Analyzed system requirements to create test cases.
- Assisted in developing standards for software development lifecycle processes.
- Executed functional, regression, system integration, stress, security and compatibility tests on the applications.
Data Analyst
Global Logic Technologies And Future Focus InfoTech Pvt Ltd
Hyderabad, India
12.2019 - 11.2022
- In my role, I extensively utilized SQL queries to validate ETL-processed data in the target system.
- As a part of a collaborative team, my responsibilities encompassed vendor data integration (inbound/outbound) and adhoc data extracts to meet legal audit requirements
- I also played a pivotal role in planned enhancements, such as optimization, automations, and infrastructure upgrades, including SQL server and DataStage upgrades.
- Additionally, I managed data integration for various downstream users and provided crucial production and maintenance support.
- This involved preparing and executing SQL queries to verify both Dimension and Fact tables.
- Additionally, I conducted a thorough column data mapping between the source and target databases.
- Record counts of Source and Target were compared meticulously, and I was responsible for generating comprehensive test reports.
- Collaborating with the Clients' QA team, I effectively analyzed and reported defects in QC.
- Active participation in daily stand-up meetings ensured that I stayed updated and reported daily testing status.
Education
Master of Science - Computer information system
Christian Brothers University/Memphis
United States12-2024
Bachelor of Technology - Civil Engineering
St. Mary's Group of Insititutions/ Hyderabad
India05.2019
Dipolma - Civil Engineering
Tudi Ramreddy Institute of Technology & Sciences/Nalgonda
India06.2016
Secondary School Education -
Krishnaveni Talent Highschool/Bellampally
India03.2013
Skills
- Power Bi
- ETL Testing
- Manual Testing
- Informatica
- Intelligence Cloud Services
- Sql Server
- Teradata
- Data Warehousing
- HP - ALM
- JIRA
- Python
- Toad Data Point
- Test Planning
- Test Documentation
- Agile Methodologies
- Creating Test Cases
- Oracle database
- Defect tracking
- Selenium
Accomplishments
- Prosper Guru, 06/2021, 07/2021, For pitching the most innovative ideas to solve problems and issues
- Alpha Player, 03/2022, 04/2022, For being the slayers of deadlines and being the best in what they do regardless of the time and circumstances
Languages
English
Full Professional
Telugu
Native/ Bilingual
Hindi
Professional
Timeline
Test Engineer
Future Focus Infotech Private
06.2022 - 11.2022
Data Analyst
Global Logic Technologies And Future Focus InfoTech Pvt Ltd
12.2019 - 11.2022
Master of Science - Computer information system
Christian Brothers University/Memphis
Bachelor of Technology - Civil Engineering
St. Mary's Group of Insititutions/ Hyderabad
Dipolma - Civil Engineering
Tudi Ramreddy Institute of Technology & Sciences/Nalgonda
Secondary School Education -
Krishnaveni Talent Highschool/Bellampally
Similar Profiles
Wasim MehboobsabWasim Mehboobsab
Desktop Support Engineer at Future Focus Infotech Private LimitedDesktop Support Engineer at Future Focus Infotech Private Limited
MD AZHARUDDINMD AZHARUDDIN
Sr. FMS Engineer at VDA INFOSOLUTION PRIVATE LIMITED (At Client - Endurance Technologies Limited)Sr. FMS Engineer at VDA INFOSOLUTION PRIVATE LIMITED (At Client - Endurance Technologies Limited)
Swathy SRSwathy SR
Consultant at Future Focus Infotech Pvt LtdConsultant at Future Focus Infotech Pvt Ltd