Sanghamitra Das Adhikari
Waterloo,ON
Summary
Test Analyst Motivated, teamwork-oriented, responsible Test Analyst with 9+ years of experience. Proficient in ETL Testing, Database testing and all testing procedures. Capable of developing workflows and mapping in Informatica. Proven ability to understand customer requirements and translate into actionable project plans with cross functional skills.
Overview
10
10
years of professional experience
Work History
Test Analyst
Cognizant Technology Solutions Canada, Inc.
01.2022 - Current
- Analysis of Business requirement document and developing logical and physical specification.
- Research and analyze the information to create the test design for the developed code.
- Create and Optimize test cases to maximize success of manual software testing.
- Creating successful test scripts to manage automated feature testing.
- Reviewed all test cases and test scripts for quality and identified additional areas to review.
- Execution of test cases and assessed the findings from the code along with suggested fix for development team members.
- Maintaining the Traceability Matrix through Defect management tool, JIRA.
- Directed teams completing regression tests to support successful product development stages.
- Conducted in-the-line testing and evaluated resulting measurements to identify variances in output using current production methods and compare against application-specific tolerances.
Associate
Cognizant Technology Solutions, US HealthCare &Insurance, John Hancock Financial
05.2018 - 11.2021
- Responsibilities:
- Actively engaged in Quality Assurance team, involved in creation of Test Strategy, Test Planning, Test Scripts, Test Data Setup, Test Case creation, Test Execution, Defect Reporting and preparation of Test Results Summary
- Experienced in ETL testing using Informatica
- Developed robust and complex Informatica mappings, workflows and sessions using power Center Designer to load and transform data
- Developed work jobs in CAA workload to execute the workflows from Informatica
- Develop complex queries and responsible for tuning and optimize SQL queries
- Involved in generating new data using business transformation logic and deploy it into test environment
- Creates data subsets from production data for masking using Informatica TDM
- Performed statistical analysis on various types of data from different heterogeneous databases to analyze and interpret large data sets
- Also, as a part of the maintenance task, perform cleaning of databases removing redundant, missing and duplicate data
- Strong knowledge in SDLC, STLC and Defect Life Cycle
- Also end to end business knowledge in Insurance and Finance industry
- Implemented and drove adoption of various innovations and tools to efficiently deliver projects by improving productivity by 60%
- Conducts analytical meetings to understand business needs and requirements to deliver error-free outcomes
- Demonstrate knowledge and execution of tasks to team members with detailed information
- Leads a team of 6 members.
Senior System Engineer
Infosys Technology
03.2013 - 05.2018
- As part of Test Data Management Team, worked independently in Data Generation, Data Mining and Data Masking using IBM Optim.
- Developed masking codes in mainframe RUMBA, using Job Control Language (JCL) to create jobs that mask PHI, such as credit card, Social Security numbers with a non-sensitive substitute, in a way that preserves the integrity of the data. This data includes Relational data, flat files and Virtual Storage Access Method (VSAM) datasets.
- For Data mining projects, extracting useful information from huge production files. Understanding of the business was an essential part of this.
- Utilized analytical and technical expertise to provide insights and proposals to support business improvements
- Performed regular maintenance of organization transactional database by continuous regression to ensure accuracy,completeness and uniformity.
Education
Bachelor Of Technology -
Heritage Institute of Technology
Masters - Applied Computing
Wilfrid Laurier University
2021
Skills
- Compatibility Testing Software
- Database Querying
- Requirements Analysis
- Penetration Testing
- Defect Resolution
- Team Mentoring
Accomplishments
- R Programming by Udemy
- Principles of Insurance by Life Office Management Association (LOMA)
- America's Health Insurance Plans Premier IBM Certification as a 'Data Analyst' Fundamentals of Healthcare Part A & B
Timeline
Test Analyst
Cognizant Technology Solutions Canada, Inc.
01.2022 - Current
Associate
Cognizant Technology Solutions, US HealthCare &Insurance, John Hancock Financial
05.2018 - 11.2021
Senior System Engineer
Infosys Technology
03.2013 - 05.2018
Bachelor Of Technology -
Heritage Institute of Technology
Masters - Applied Computing
Wilfrid Laurier University
Similar Profiles
Agnibha RoyAgnibha Roy
Lead System Architect at Cognizant Technology Solutions- CANADALead System Architect at Cognizant Technology Solutions- CANADA
KAVINILAVU VINOTHA RAJANKAVINILAVU VINOTHA RAJAN
ETL Developer (SSIS | Python | Mirth Connect)) at Cognizant Technology Solutions Canada Inc.ETL Developer (SSIS | Python | Mirth Connect)) at Cognizant Technology Solutions Canada Inc.
Manojkumar BalamuruganManojkumar Balamurugan
Senior Associate at Cognizant Technology Solutions Canada Inc.Senior Associate at Cognizant Technology Solutions Canada Inc.
Zachery McCallZachery McCall
Sales Associate at Movati AthleticSales Associate at Movati Athletic
Alexander BowmanAlexander Bowman
Roofing Laborer at Dayview RoofingRoofing Laborer at Dayview Roofing