Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sai Kiran Reddy Vobanapalli

Plano,TX

Summary

Results-driven IT professional with 9+ years of experience in the industry including 5+ years in Big Data testing and 8+ years in ETL testing. Skilled in regression testing, user acceptance testing (UAT), and various performance testing methods. Proficient in SDLC and STLC with expertise in Salesforce testing and web services validation. Experienced in test planning, execution, and defect tracking using Jira and Quality Center (QC).

Overview

8
8
years of professional experience

Work History

Sr QA Tester (ETL & BIG DATA/Hadoop)

Volkswagen Group of America
Auburn Hills , MI
2016.09 - 2022.09
  • Created test scenarios based on the requirements provided by the business
  • Developed expected results test scripts to perform Functional and Regression Testing
  • Involved in updating the requirements along with the developer
  • Provided daily status reports to the delivery manager and discuss issues related to the issues and deadlines
  • Involved extensively in source to target data validations by verifying the mapping documents and ensuring the data is being populated correctly
  • Performed various Teradata controls like comparisons between Landing zone tables and tracing tables generated during the ETL process
  • Responsible for validating the ETL extracts against the mapping document and validation of business logic rules based on the requirement and the cleansed data is loaded into MDM
  • Created mock test data in Hive, Data Warehouse and Salesforce for testing flows to validate and prove positive and negative cases
  • Provided training to new resources on using Hive/Impala, how to validate, create data and views in salesforce and test case and defect creation in JIRA
  • Using MDM, finding data from multiple sources and match them into single record based on demographics and other rules to create a global record
  • Hands on experience in testing salesforce standard objects (Campaign, Accounts, Cases, Opportunity) and custom objects, page layouts, field validations and its access to the user based on defined profile
  • Performed root cause analysis for issues in production and provided documentation with the results explaining about the impacts to the business
  • Used informatica to debug the errors if there are any workflow failures
  • Responsible for communicating with development team to resolve the issues and retest them
  • Updated the test scenarios and added new test scenarios when there are changes in the business requirements
  • Performed data validation between Hive to Salesforce such as field mapping etc., Involved in generating the sample file for the business so they can run their ETLs
  • Reviewed test scenarios with the business and made updates if suggested
  • Logged the defects and improvements in JIRA to keep track
  • Involved in testing file transfer between Client and External vendor by creating sample files using Winscp
  • Performed back-end testing by executing SOQL queries
  • Worked on production issues reported by the business along with the development team to make sure there are no downstream impacts
  • Testing Web Services and integration with various systems
  • Retested the defects and improvements once the development is done and closed them in JIRA
  • Executed the ETL workflows by triggering those using UNIX Scripts in PuTTY
  • Tested Web Services by validating Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI and POSTMAN tools
  • Created UAT test scenarios and worked with business users to execute the UAT test scenarios
  • Good understanding and hands on experience with web technologies like HTML and XML
  • Validated Data security and sharing rules in Salesforce
  • Tested Users, Profiles, Role hierarches and Permission sets as per user profile and public group
  • Performed data analysis and data validation using SQL and Informatica Data Explorer on various sources systems including Oracle and Toad
  • Involved in meetings with the business to discuss about the enhancements and new project change requests
  • Experience debugging XML data like SOAP request and response
  • Documented the test results in the word document and attached them to related test scenarios
  • Created the test cases in JIRA and added them to the test cycles based on the deployments to the production
  • Involved in System Integration Testing (SIT) along with the business, includes SIT test cases, shared the test results with the business.

ETL QA Tester

Ven Soft LLC
2015.01 - 2016.08
  • Create test plans, test cases, and participate in user acceptance testing to ensure the highest quality products are released to production
  • Tested ad hoc and canned reports for Business objects
  • Work closely with business users and the project team to analyze business requirements in order to create project test scenarios Analyzed the requirements from business requirement & functional use case diagrams, and other project related documents to design and develop effective Test cases Formulate methods to perform Positive and Negative testing against requirements
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing
  • Used Agile testing methodology for achieving deadlines in UAT; extensively worked on UAT of several modules single handedly
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica Tested Business Objects reports and Web Intelligence reports Ran workflow in workflow manager of Informatica and verified session logs for data load discrepancy
  • Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required sign-off’s
  • Created and executed SQL statement to perform Backend Testing manually that ensured data consistency on the Front-end
  • Defect tracking and Status reporting using Quality Center (QC) ALM defect tracking tool
  • In-charge of Usability testing on the product and making appropriate recommendations Developed SQL queries to check the database automatically and checking the data integrity in ETL Flow of data from source to stage and target Database Design, develop and execute regression, usability, stress, database verification, ad-hoc and other types of testing activities
  • Participated in weekly status meetings, walkthroughs, design review meetings and documented proceedings
  • Develop and maintain internal technical documentation relevant to the QA processes and procedures.

Education

Master’s in Computer Science -

New York Institute of Technology
NY, USA

Bachelor’s in Computer Science -

JNTUA University
India

Skills

  • Regression testing
  • User Acceptance testing (UAT)
  • Load Testing
  • Performance Testing
  • Stress Testing
  • Software Development Life Cycle (SDLC)
  • Software Testing Life Cycle (STLC)
  • Salesforce testing
  • Test plans
  • Test scenarios/scripts
  • Test cases
  • Manual testing
  • Bug tracking tools
  • SOAPUI
  • Teradata
  • Informatica Power Center ETL
  • Business Intelligence reports
  • Quality Assurance methodologies
  • Waterfall
  • Agile (Scrum)
  • Test case writing
  • Back-End Testing/Database Testing
  • SQL queries
  • Configuration management
  • Change control procedures
  • Rational Clear Case
  • Data warehousing environment
  • Onsite/ off site team model
  • Communication skills
  • Interpersonal skills
  • Self-motivated
  • Quick learning skills
  • Defect Tracking
  • ALM / Quality Center / Jira/Azure
  • Databases: SQL Server, Oracle, MySQL, Teradata
  • Scripting languages: Java script, Python, HTML, XML
  • Application environments: .NET Web Services, SSIS/ SSRS/ SSAS, SOA, CSS, Java
  • MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project, MS SharePoint
  • Operating Systems/ Products: Windows, UNIX, UBUNTU, LINUX
  • DWH/ETL Tools: SSIS, Informatica PC, Informatica ICS, Informatica ICRT, SSRS, Business objects, Toad, Hive
  • API Testing Tools: Postman, SoapUI
  • Test Procedure Documentation
  • Collaborative Team Player
  • Cross-Functional Team Collaboration
  • Decision-Making
  • Agile Best Practices
  • Cross-platform testing
  • Data Analysis
  • Training and Onboarding

Timeline

Sr QA Tester (ETL & BIG DATA/Hadoop)

Volkswagen Group of America
2016.09 - 2022.09

ETL QA Tester

Ven Soft LLC
2015.01 - 2016.08

Master’s in Computer Science -

New York Institute of Technology

Bachelor’s in Computer Science -

JNTUA University

Similar Profiles

  • Alex Needham

    Alex NeedhamAlex Needham

    Financial Systems Key User at Volkswagen Group of AmericaFinancial Systems Key User at Volkswagen Group of America

    View Profile
  • Hesham Hachem

    Hesham HachemHesham Hachem

    Digital Connect Specialist at Volkswagen Group of America (Porsche)Digital Connect Specialist at Volkswagen Group of America (Porsche)

    View Profile
  • MATTHEW MISLEH

    MATTHEW MISLEHMATTHEW MISLEH

    Global Financial Product Controller at Volkswagen Group Of AmericaGlobal Financial Product Controller at Volkswagen Group Of America

    View Profile
Sai Kiran Reddy Vobanapalli