Bhargav Bagusetty
Granville,Australia
Summary
Hi, I’m Bug (Australian Citizen) Data Warehousing/ETL Test Analyst from Sydney. Have been living here
for the past 15 years, working and studying. Have a strong passion for working on Data oriented
platform and would like to utilize Functional, Technical Skills and Knowledge to Test Data Warehousing,
Business Intelligence by providing High Quality Deliverables with in functional and business scope and within
stipulated timelines. It is phenomenal engaging in teams and working together, learning new things and
discussing new techniques within the team. Right now, looking for a data-oriented role where can
contribute learning and experience to the team and company, and apply myself with energy and
passion to all the Works involved with.
Overview
3
3
years of professional experience
1
1
Certification
Work History
ETL Test Analyst + Coordinator
NAB via Infosys
08.2021 - Current
- Work with other NAB teams to ensure required quality of NAB applications
- Solicit and provide peer review of test documents including plans and results
- Receiving feedback on personal testing activities and the NAB testing methodology
- Understanding the technical requirement and Low-Level Design
- Source System Analysis and understanding the reporting requirement
- Giving right estimates, after the Solution Design on the SOAP Diagram walkthrough
- Perform Testing as per Quality Standards
- Setting up defect triage meetings
- Managing stakeholders and multiple project Managers
- Handling multiple Projects
- Coordinating with the test leads and testers
- Assigning daily tasks to the testers
- DATA Domain Lead for managing all DATA related projects and directly report to QEM
- Managing the delivery of all test artifacts
- Positive stakeholder feedback effectively to ensure quality outputs
- Work delivered accurately and efficiently with agreed schedule and budget
- Risks / Issues resolved or escalated in a timely manner in alignment with organizational standards
- Performing all the activities of a Test Analyst, SLA performing more complex test activities which may be beyond the competency or skill of a Test Analyst
- Working with the Test and Project Manager to identify the streams of testing required for the Project and helping to create an overall testing approach for the project
- Reviewing and signing off on MTP & TSR
- Running project defect meetings to ensure all defects raised either by any of the project streams are progressed in a timely fashion to ensure each testing stream remains unblocked and can close out on time
- For each testing stream for the project acquiring and analyzing all relevant project documentation to determine testing coverage for each testing stream documented in the MTP format
- Liaising with business users, business analysts and developers to ensure that planned testing coverage meets their requirements
- For each testing stream for the project managing the test case creation (whether writing the test cases myself, managing Test Analysts to do so or a combination of both) such that the test planning closes out on time and within the budget assigned
- For each testing stream for the project ensuring the test data and environment requirements are provided to the environment manager in a timely fashion to allow testing to begin on time
- Providing overall project test execution progress reporting using the assigned template daily including all testing streams
- For UAT specifically working with the business to manage the business execution on a day-to-day basis
- Logging any defects found during testing, escalate in accordance with set procedures and then work with build and design teams to rectify issues and then work to accept fixes back into the environment for re-execution
- For each testing stream for the project ensuring all test information is tracked throughout execution and then summarizing into a Test Summary Report using the appropriate template.
- Managed approximately 12 team members in the current Citibank Migration project
ETL Test Analyst
MLC Insurance via Wipro
07.2021 - 08.2021
- Worked on Claims and Policies project
- Review requirements from data BA
- Plan out test coverage
- Build test coverage and test approach document
- Build test cases to run scripts in Data Platform
- Execute test cases and reconciliation of data from source to Data platform
- Run batches in lower environment(automated batch)
- Creation of test strategies, plans, scenarios and test cases for assigned projects
- Performing testing coordination activities which involve providing estimation, planning, team management, and reporting on testing activities
- Identifying, communicating, and managing risks and issues as arise
- Preparation of Master Test Plan
- Preparation of Test scenarios
- Preparation of Test Cases
- Used Qtest for Test Cases and defect tracking
- Documenting and verifying test results and communicating incidents, bugs and issues to the relevant team in alignment with NAB testing methodology
- Run Control-m jobs according to the job run sheet
- Used Air flow to see the jobs are running fine
- Prepare Test Summary Report.
- Managed more than 30 test cases per day from the test suit
Education
MBA - Business Administration And Management
University of Southern Queensland (Australia)
Sydney, NSW05.2010
Skills
- Requirements Analysis
- Test Execution
- End-to-End Testing
- Bug Reporting Tools, Rally
- Test Management Tools, qtest
- Database Testing
- Integration Testing
- Test Planning
- Test Data Preparation
- Manual Test Analysis
- Functional Testing
- Test Documentation
- Test Reporting
- Issue Resolution
- Test case design
- Expert Test Planning
- Manual test case preparation
- Defect Tracking and Reporting
- Scenarios and Use Cases
- Teamwork and Positive Attitude
- Team Collaboration
- Decision-Making
Certification
- ISTQB Certified Tester Foundation Level (2018)
- ISTQB Certified Tester Advance Level (2012) - Test Manager
- Certified ScrumMaster (CSM)
- Micro Certification – ServiceNow
- Introduction to Programming using HTML and CSS
References
References will be provided upon request
Hobbies and Interests
- Professional Cricket
- Swimming
- Table tennis
- Billiards
Timeline
ETL Test Analyst + Coordinator
NAB via Infosys
08.2021 - Current
ETL Test Analyst
MLC Insurance via Wipro
07.2021 - 08.2021
MBA - Business Administration And Management
University of Southern Queensland (Australia)
- ISTQB Certified Tester Foundation Level (2018)
- ISTQB Certified Tester Advance Level (2012) - Test Manager
- Certified ScrumMaster (CSM)
- Micro Certification – ServiceNow
- Introduction to Programming using HTML and CSS
Similar Profiles
SAIRAM PALAKURTHISAIRAM PALAKURTHI
Test Analyst at Infosys Limited - NATIONAL AUSTRALIAN BANK (NAB)Test Analyst at Infosys Limited - NATIONAL AUSTRALIAN BANK (NAB)
Shravani KuppaShravani Kuppa
Data Engineer at NAB, Infosys ConsultingData Engineer at NAB, Infosys Consulting
Nirmal KorothNirmal Koroth
Test Manager/ Technical Test Lead at Infosys (NAB)Test Manager/ Technical Test Lead at Infosys (NAB)