Bhanudev Sahoo
Mississauga,Canada
Summary
Strategic Test Manager with extensive experience in software testing, End-to-End Data Validation Testing, Strong Domain Knowledge in Banking-Finance-Insurance (BFSI) and team leadership, recognized for developing and implementing robust test strategies that enhance product quality. Proven track record in leading cross-functional teams and managing multiple concurrent projects, driving significant contributions to overall project success. Strong problem-solving capabilities combined with a commitment to continuous learning and improvement ensure optimal testing outcomes.
Overview
12
12
years of professional experience
1
1
Certificate
Work History
Test Manager
CITI Group for TCS
Mississauga, Canada
08.2020 - Current
- Led a team of 11 in Data Governance, utilizing the Reconciliation process for project GRU DSFT and BAU.
- Experienced in work planning, prioritization, and internal/external stakeholder status reporting, as well as managing the testing team for the end-to-end testing process.
- Worked as a Business Analyst & Performed an end-to-end data lineage assessment and documentation for selected CDEs for WLCR.
- Very good understanding of various fixed income, equity, and FX derivative asset class workflows for front office, middle office, and back office source systems.
- Testing all aspects of Global Reconciliation & Utilization defects
- Reporting the defects to respective stakeholders for resolution by reporting INCs in ServiceNow.
- Designing, building, and maintaining a test suite using Atlassian JIRA.
- Collaborated with data engineering and business intelligence teams to identify and address data quality issues, ensuring a seamless data flow across systems.
Test Lead
RBC for TCS
Toronto, Canada
02.2020 - 07.2020
- Led data quality tests using a validation tool for the RBC Loyalty Data Migration Project.
- Requirement gathering, test planning, and test scenario, test case, and test steps designing based on the user story and FRD.
- Test Data Preparation for Unit and Smoke Test.
- Data validation for loyalty profiles migration between Epsilon and Moneris systems.
- Data validation for different success and failure reports.
- Test execution when required, and reporting the defects to HP ALM.
- Reviewing Defect Trackers and Test Results.
- Publishing the Daily Status Report to relevant stakeholders and higher management for traction.
Data Quality Consultant
Refinitiv Thomson Reuters Ltd. for TCS
Bhubaneswar, India
06.2018 - 01.2020
- Worked as a Data Quality Consultant for TCS Quality Engineering and Transformation: BITS 11.0 Tool which was a TCS Proprietary Tool
- Involved in Proposal Demonstration to new Customers for BITS tool
- Involved in Due Diligence & actively involved in POC and Demonstrating the BITS POC result to Customer
- Worked in Relational Data base like: Oracle 10g, MSSQL and No SQL like: Snowflake and Flat Files like Cobol Files, CSV Files, XML Files
- Data Quality Check across DB to find data duplicity, data non-standards
- Worked for Refinitiv-TR to accomplish end to end Data Validation Testing for the migration project from Oracle to NO-SQL Snowflake
Functional Test Analyst
Morgan Stanley for TCS
Bhubaneswar, India
05.2014 - 05.2018
- I worked as a Functional Test Analyst for the Wealth Management project at Morgan Stanley.
- Requirement gathering, test planning, and test scenario. Test case and test steps are designed based on the user story and FRD.
- Uploaded test cases in QC from MS Excel to map requirements to test cases, provide traceability to requirements, create test sets, and selectively run tests manually.
- Clearly communicated defects with developers, and updated comments in HP ALM.
- Executed test cases in the lab section and entered defects with appropriate screenshots and requirements.
- Logged and tracked defects using JIRA.
- Performed cross-browser testing across different browsers like IE, Edge, GC, FF, and Safari in different combinations of OS like Windows, Mac, and Android, with different browser version combinations to ensure full compatibility and user-friendly access of the AUT using the iBrowse tool.
IDQ Developer
Tata Communications Ltd, USA for TCS
Bhubaneswar, India
03.2013 - 04.2014
- Creating Physical Data Object (PDO) and Relational Data Object by connecting to the Relational Database using 9.6.1.
- Good knowledge of various types of profiling, like column profiling, primary key profiling, frequency profiling, and outlier analysis.
- Creating reference tables and documenting data quality metrics and dimensions, such as accuracy, completeness, duplication, validity, and consistency.
- Used various Informatica Data Quality transformation components.
- Creating a scorecard and trend chart by defining various metrics and configurations.
- Brief knowledge on 'Score Card Lineage' to analyze the unacceptable scorecard variance in metrics in the Analyst tool.
Education
Bachelor of Technology - Electrical Engineering
Biju Pattanaik University of Technology (BPUT)
Odisha, India01.2012
Skills
- Project Management
- Business Analyst for Wholesale Lending, Credit Risk (WLCR), Data Lineage Management
- Data governance for the Global Reconciliation and Utilization process
- Functional Testing and Cross-Platform Testing of Web-Based and Mobile Applications
- Data Quality Tool: BITS 110, Data Surge
- SQL Server 2005, 2008, Oracle 10g Client, Oracle Exadata, and IBM Toad
- NOSQL: Snowflake 32
- Data Cleansing, Data Profiling, Data Quality: IDQ 961
- Unix Basics
- Agile methodology and sprint concepts
Certification
ISTQB Certified Tester Advanced Level – Test Manager
Timeline
Test Manager
CITI Group for TCS
08.2020 - Current
Test Lead
RBC for TCS
02.2020 - 07.2020
Data Quality Consultant
Refinitiv Thomson Reuters Ltd. for TCS
06.2018 - 01.2020
Functional Test Analyst
Morgan Stanley for TCS
05.2014 - 05.2018
IDQ Developer
Tata Communications Ltd, USA for TCS
03.2013 - 04.2014
Bachelor of Technology - Electrical Engineering
Biju Pattanaik University of Technology (BPUT)
Residency
Permanent Resident of Canada
Similar Profiles
Sanjay KafleSanjay Kafle
CISO CyberArk SME at Tata Consultancy Services TCS/ Citi BankCISO CyberArk SME at Tata Consultancy Services TCS/ Citi Bank
Akshaya KishoreAkshaya Kishore
NOC ENGINEER at TCS (CITI BANK PROJ)NOC ENGINEER at TCS (CITI BANK PROJ)
Joaquin Alberto Galvez EstradaJoaquin Alberto Galvez Estrada
SDET Engineer at TCS-CitiSDET Engineer at TCS-Citi