SUPRIYO GHOSH
Test Lead, Data QA And Test Automation
Kolkata,India
Summary
Test Lead with a demonstrated history of working in the information technology and services industry for clients of Insurance and telecom domain. Expertise in data quality, data management, Datawarehouse, Test management, ETL and MDM testing, BI Testing, white box testing,test automation.
Overview
12
12
years of professional experience
7
7
years of post-secondary education
1
1
Certification
3
3
Languages
Work History
ETL Test Lead and Test Automation Architect
Cognizant Technology Solutions Pvt. Ltd.
Kolkata, India
01.2015 - Current
- Worked for reputed Canada based insurance client for multimillion dollar data modernization projects(covering Master data management,data quality,data governance,Data integration,Data warehouse,data migration,Cloud implementation and validation projects)
- Managed team of 10 members from various ETL, big data implementation projects
- Pre-sales experience with estimations,testing approach,resource loading for new business proposals for cognizant.
- Tested functional and compatibility of new programs or updates in comparison to existing applications.
- Built ETL test automation framework using python and robot framework
- DevOps for Test automation framework by integration with Jenkins and GITHUB for easy test suite run and test result publication
- Built automated test scripts using SQL and python to handle repetitive software testing work.
- Authored and maintained well-organized, efficient and successful manual test cases for entire team.
- Completed automation of functional and regression testing.
- Gathered data on integration issues and vulnerabilities, reported findings and recommended improvements.
- Monitored resolution of bugs, tested fixes and helped developers tackle ongoing problems by providing QA perspective.
- Researched and resolved issues regarding integrity of data flow into databases.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Participated in requirements meetings to understand business needs.
- Incorporated delivery requirements into planning of testing schedules.
- Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
- Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews and sprint retrospectives.
- Participated in data architecture review with data architects
- Client and stake holder presentation of MVP for sign off for production deployment
Senior Test Analyst
CMC Ltd.
Kolkata, India
02.2013 - 01.2015
- Worked for reputed Insurance domain clients for end to end functional testing of insurance product implementation in policy underwriting,claims,re-insurance,accounting modules of life and non life products
- Created successful automated test scripts in smart bear test complete using VB scripts to manage automated feature testing,
- Directed team members to follow specific testing standards and guidelines as outlined in project requirements.
- Reviewed all test cases and test scripts for quality and identified additional areas to review.
- Documented current production methods to identify points of limitation to target for quantification through testing procedures.
- Documented integration issues and vulnerabilities and outlined improvement recommendations.
ETL Tester
Tech Mahindra Ltd.
Kolkata, India
11.2010 - 01.2013
- Worked for UK based Telecom client with ETL testing and Automation testing
- Tested functional and compatibility of new programs or updates in comparison to existing applications developed in oracle warehouse builder,Oracle PL/SQL and OBIEEE.
- Automation test script development using QTP(VB script with descriptive framework) for business reports validation in OBIEEE .
- Completed pre-implementation testing for new system modifications to assess potential impacts.
- Performed end to end testing for data flow between source system to Business reports
- Worked in waterfall model
Education
Bachelor of Technology - Electronic And Communication Engineering
Jalpaiguri Government Engineering College
Jalpaiguri,West Bengal 06.2006 - 07.2010
CISCE - Science
De-Nobili School
Maithon, Jharkhand 03.2004 - 03.2006
ICSE -
De-Nobili School
Maithon,Jharkhand 03.2003 - 03.2004
Skills
Python
SQL
Apache Nifi
SQL Server on Azure
VB script
Test Complete
OBIEEE
Power BI
Stored Procedures
Graph QL
Postman
ETL Test automation
Functional ETL Testing
MDM Testing
API Testing
QTP
Certification
AI900
Timeline
AI900
03-2021
ETL Test Lead and Test Automation Architect
Cognizant Technology Solutions Pvt. Ltd.
01.2015 - Current
Senior Test Analyst
CMC Ltd.
02.2013 - 01.2015
ETL Tester
Tech Mahindra Ltd.
11.2010 - 01.2013
Bachelor of Technology - Electronic And Communication Engineering
Jalpaiguri Government Engineering College
06.2006 - 07.2010
CISCE - Science
De-Nobili School
03.2004 - 03.2006
ICSE -
De-Nobili School
03.2003 - 03.2004