Sarvesh Khatri
Test Analyst
Pune
Summary
Test analyst with 8 years of experience and most of it with Banking domain. Experience in DWH/ETL testing using different tools and technologies.
Overview
8
8
years of professional experience
Work History
ETL TEST ANALYST
Barclays Bank PLC
3 2021 - Current
- Lead the team to test different projects within Barclays communication and marketing domain (Emails, SMS, Push Notifications, Statements, and Letters)
- Provided demos/walk through regarding testing results
- Worked closely with software developers/project owners and BA's to develop and execute
thorough test suites in all phases of the software development cycle - Involved in all production deployment activities and PVT
- Extensively interacted with developers, business management teams to understand the business requirement and ETL design document specification.
- Documented flows, diagrams ,specifications and requirements of pilot AWS project on confluence for US cards domain
- Strong in ETL data validation developed using Abinitio/SQL/Unix/Tivoli and other ETL environment
- Knowledge on API testing using tools like Postman,Openshift,Kibana and consul
TEST ANALYST
Amdocs (project- AT&T communications)
02.2020 - 02.2021
- Validated the complete data for Data Completeness, Data Transformation and Data Quality Test using Queries in Microsoft SQL Server
- Prepared Test Cases based on source filtrations , transformation and loading rules as per the Functional Specification Document
- Created Functional and Non-Functional test strategies and other test documents
TEST ENGINEER
Tata Consultancy Services(Projects -Westpac Bank and TD Bank
10.2016 - 01.2019
- Developed and executed detailed ETL related functional, performance, integration and regression test cases, and documentation
- Tested complete migration of data from source to target in every stage of ETL using Informatica Tool and SQL
- Created test cases , test results and test plan to validate E2E testing
Education
MBA - Leadership And Strategy / Business Analytics
Liverpool Business School And IMT Ghaziabad
04.2001 -
Bachelor of Engineering - Computer Science Engineering
Ram Meghe College
04.2001 -
Skills
Jira
Confluence and documentation
Abinitio and Informatica
ETL Datawarehouse , SQL
Unix
API Testing
AWS cloud
Tableau Reporting
Languages
English
Accomplishments
- Certified Scrum Product Owner -PSPO 1 - Scrum.org
- Business Analysis Certified Professional-TrainSmart Academy
- Business Analysis Fundamentals- The BAGuide
- Getting Started as a Business - LinkedIn Learning
- Visio Essential -LinkedIn Learning
Timeline
TEST ANALYST
Amdocs (project- AT&T communications)
02.2020 - 02.2021
TEST ENGINEER
Tata Consultancy Services(Projects -Westpac Bank and TD Bank
10.2016 - 01.2019
MBA - Leadership And Strategy / Business Analytics
Liverpool Business School And IMT Ghaziabad
04.2001 -
Bachelor of Engineering - Computer Science Engineering
Ram Meghe College
04.2001 -
ETL TEST ANALYST
Barclays Bank PLC
3 2021 - Current