Sandesh Patil
Pune
Summary
- Looking for a good career opportunity to share my skills/experience on challenging projects involving extensive use of current techniques and tools to contribute productively towards the growth of the company.
- 8+ years of experience in ETL testing.
- Hands on experience in GCP BigQuery, Airflow etc
- Well acquainted with SDLC, STLC and Defect life cycle.
- Extensive knowledge and hands on experience in Database testing.
- Familiar with waterfall methodology & agile as well.
- Experience on reporting and tracking defects in HP ALM, JIRA etc.
- Hands on experience on Informatica DVO & Oracle EDQ
- Have hands on knowledge of Selenium using JAVA & TOSCA automation tool.
- Experience to handle a module independently.
- Worked effectively with onsite and offshore team.
- Quick learner with sound analytical skills and strong decision making ability.
- Result oriented and interested to learn new technologies and flexible enough to adapt new environment.
Overview
11
11
years of professional experience
4028
4028
years of post-secondary education
Work History
Associate Senior Test Analyst
TSYS Card Tech Pvt Ltd
05.2021 - Current
- ETL Testing, GCP Looker Report Testing
- TSYS is partner with hundreds of the world's leading brands-across finance, retail and beyond. Providing more secure payment solutions in industry.
- Project #1: Aperia - GCP Looker Report Testing
- Role: Senior Associate Test Analyst
- Tools: GCP BigQuery, Airflow, Looker Reports, Rally, QTest
- Team size: 5
- Project Profile: Migrating all legacy reports to GCP Looker and provide better user friendly experience to customer
- Contribution/Highlights: Requirement analysis and understanding the mapping document, Writing SQL queries, Used Rally for tracking purpose, Preparing the evidences and reports using Excel.
Testing Analyst
Infosys Technologies
08.2018 - 04.2021
- ETL Testing/Data Quality/Tosca Automation
- HSBC Holdings plc is a British multinational banking and financial services holding company. It is the 7th largest bank in the world.
- Project #1: FCR Name Screening (On-Going)
- Role: Test Analyst
- Tools: Oracle database, Datastage, Control M, HP ALM etc.
- Team size: 9
- Project Profile: Aiming to design and develop a framework called Landing Pad to process the customer's data and load it to DW. Analyze and screen data against watch lists to generate alerts if matching found.
- Contribution/Highlights: Requirement analysis and understanding the mapping document, Preparing estimate, Development of the SQL queries based on the transformation rules, Creation of test data based on the business rules mentioned in mapping docs, Used HP-ALM, JIRA for all the defect management activities, Preparing the evidences and reports using Excel, Running the sequences in unix.
- Project #2: Volumetric Testing & Automation
- Role: Test Analyst
- Tools: Oracle database, Datastage, Control M, HP ALM etc.
- Team size: 9
- Contribution/Highlights: Understanding the CR/JIRA requirement, provide IA and prepare test plan, Running Sanctions/Non-Sanctions jobs check whether any matching between Customer & Watch list data, Creating Processes in EDQ to analyze alerts spikes, Preparing reports, Completed Archival Automation in TOSCA.
Programmer Analyst
Cognizant Technology Solutions
09.2015 - 08.2018
- ETL Testing
- Wellmark BlueCross BlueShield is a health services company which offers Dental, Medical, Vision and prescriptive drug plans services to individuals and groups in Iowa, South Dakota.
- Project #1 - XB4 Quantum Reporting
- Role: Programmer Analyst.
- Tools: HP-ALM, WinSQL, Business Object, FACETS DB etc.
- Team Size: 4
- Project Profile: The main objective of the project is to move all the legacy data to FACETS and it should flow to downstream application as per business requirement.
- Contribution/Highlights: Understanding of requirements for functional design, technical design, & workflows, Understanding the Test approach and the application flow, Played role in Test Assets creation and review of Test Scenarios and Test Cases, Coordinating test data preparation as per requirement of test condition, Developed complex SQL queries for querying data against different databases for data verification process, Defect reporting and tracking using HP-ALM, Received client appreciations for the time bound delivery & quality of work.
- Project #2 - XB1 Wave B CDC (Change Data Capture)
- Role: Programmer Analyst.
- Tools: HP-ALM, WinSQL, Teradata, BO, Informatica DVO
- Team size: 3
- Project Profile: The project scope is to capture all the changes in member's data flowing from FACETS. Any small change in the member's information should capture and store in the audit tables.
- Contribution/Highlights: Requirements Analysis and Understanding, Preparing estimates based on requirements, Creation of Test plan test strategy documents, test cases and execution, Managing the resources and assigning the work based on priority, Development of the SQL queries based on the transformation rules, Creation of test data based on the business rules.
- Project #3 - BB6 Blue Cross Blue Shield Association Annual Extracts Audit
- Role: Test Analyst.
- Tools: HP-ALM, WinSQL, Informatica DVO, Oracle SQL Developer
- Team size: 1
- Project Profile: Wellmark sends Membership and Claims extracts to BCBSA association for annual audit. Scope of the project is to test extracts and automate in Informatica DVO.
- Contribution/Highlights: Creation of test cases and working with onsite on test plan, Preparing complex SQL based on business requirement, Design SQL view and generate table pairs in Informatica DVO, Raising and tracking defects in HP-ALM, Hosting and attending onsite calls and Defect Review meeting.
- Project #4 - B00 FEP Migration -EDW
- Role: Test Analyst.
- Tools: HP-ALM, WinSQL, Teradata DB, Oracle SQL Developer
- Team size: 3
- Project Profile: Objective of this project to create a separate Provider data mart in EDW also a FEP bridge to process claims online.
- Contribution/Highlights: Analysis and Understanding of requirements for functional design, technical design, & workflows, Understanding the Test approach and the application flow, Design of complex SQL based on business requirement, Created Basic PL SQL Script to load XML data into DB, Raising and tracking defects in HP-ALM.
Education
Masters In Technology (CAD/CAM) -
VIT University
VelloreBachelors of Engineering - Mechanical
Shivaji University
KolhapurSkills
- ETL Testing
- GCP- Big query, Data flow etc
- Oracle EDQ
- HP Quality Center (ALM)
- Informatica DVO
- Oracle
- MySQL Server
- Sybase
- Datastage
- Informatica
- SQL
- BO Reports
- TOSCA
- Word
- PPT
- Excel
Languages
- Marathi
- Hindi
- English
- Marathi
- Hindi
Personal Information
- Date of Birth: 08/05/91
- Gender: Male
- Marital Status: Married
Projects
- TSYS Card Tech Pvt Ltd, TSYS is partner with hundreds of the world's leading brands-across finance, retail and beyond. Providing more secure payment solutions in industry., Aperia - GCP Looker Report Testing, Senior Associate Test Analyst, GCP BigQuery, Airflow, Looker Reports, Rally, QTest, 5, Requirement analysis and understanding the mapping document, Writing SQL queries, Used Rally for tracking purpose, Preparing the evidences and reports using Excel.
- Infosys Limited, HSBC Bank, HSBC Holdings plc is a British multinational banking and financial services holding company. It is the 7th largest bank in the world., FCR Name Screening (On-Going), Test Analyst, Oracle database, Datastage, Control M, HP ALM, 9, Requirement analysis and understanding the mapping document, Preparing estimate, Development of the SQL queries based on the transformation rules., Creation of test data based on the business rules mentioned in mapping docs., Used HP-ALM, JIRA for all the defect management activities., Preparing the evidences and reports using Excel., Running the sequences in unix., Volumetric Testing & Automation, Test Analyst, Oracle database, Datastage, Control M, HP ALM, 9, Understanding the CR/JIRA requirement, provide IA and prepare test plan, Running Sanctions/Non-Sanctions jobs check whether any matching between Customer & Watch list data, Creating Processes in EDQ to analyze alerts spikes., Preparing reports, Completed Archival Automation in TOSCA
- Cognizant Technology Solutions, Wellmark Inc., Wellmark BlueCross BlueShield is a health services company which offers Dental, Medical, Vision and prescriptive drug plans services to individuals and groups in Iowa, South Dakota., XB4 Quantum Reporting, Programmer Analyst, HP-ALM, WinSQL, Business Object, FACETS DB, 4, Understanding of requirements for functional design, technical design, & workflows., Understanding the Test approach and the application flow., Played role in Test Assets creation and review of Test Scenarios and Test Cases, Coordinating test data preparation as per requirement of test condition, Developed complex SQL queries for querying data against different databases for data verification process, Defect reporting and tracking using HP-ALM., Received client appreciations for the time bound delivery & quality of work, XB1 Wave B CDC (Change Data Capture), Programmer Analyst, HP-ALM, WinSQL, Teradata, BO, Informatica DVO, 3, Requirements Analysis and Understanding., Preparing estimates based on requirements., Creation of Test plan test strategy documents, test cases and execution., Managing the resources and assigning the work based on priority., Development of the SQL queries based on the transformation rules., Creation of test data based on the business rules, BB6 Blue Cross Blue Shield Association Annual Extracts Audit, Test Analyst, HP-ALM, WinSQL, Informatica DVO, Oracle SQL Developer, 1, Creation of test cases and working with onsite on test plan., Preparing complex SQL based on business requirement., Design SQL view and generate table pairs in Informatica DVO., Raising and tracking defects in HP-ALM., Hosting and attending onsite calls and Defect Review meeting., B00 FEP Migration -EDW, Test Analyst, HP-ALM, WinSQL, Teradata DB, Oracle SQL Developer, 3, Analysis and Understanding of requirements for functional design, technical design, & workflows., Understanding the Test approach and the application flow., Design of complex SQL based on business requirement., Created Basic PL SQL Script to load XML data into DB., Raising and tracking defects in HP-ALM.
Disclaimer
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility or the correctness of the above-mentioned particulars.
Certifications Rewards Recognitions
- Completed TOSCA Automation Specialist 1, 2 certifications.
- Spark of AIM award in Q3 2016 for delivery and performance.
- Client Appreciation award for the time bound delivery & quality of work.
- Won twice Infosys Quarterly Awards
Abridgement
- 8+ years of experience in ETL testing.
- Hands on experience in GCP BigQuery, Airflow etc.
- Well acquainted with SDLC, STLC and Defect life cycle.
- Extensive knowledge and hands on experience in Database testing.
- Familiar with waterfall methodology & agile as well.
- Experience on reporting and tracking defects in HP ALM, JIRA etc.
- Hands on experience on Informatica DVO & Oracle EDQ.
- Have hands on knowledge of Selenium using JAVA & TOSCA automation tool.
- Experience to handle a module independently.
- Worked effectively with onsite and offshore team.
- Quick learner with sound analytical skills and strong decision making ability.
- Result oriented and interested to learn new technologies and flexible enough to adapt new environment.
Languages
English
Advanced
C1
Timeline
Associate Senior Test Analyst
TSYS Card Tech Pvt Ltd
05.2021 - Current
Testing Analyst
Infosys Technologies
08.2018 - 04.2021
Programmer Analyst
Cognizant Technology Solutions
09.2015 - 08.2018
Masters In Technology (CAD/CAM) -
VIT University
Bachelors of Engineering - Mechanical
Shivaji University