Sitoshna Bhoi

• Designed and executed data validation and ETL testing to ensure data accuracy, integrity, and consistency across databases and reporting systems.
• Responsible for writing Test strategy and Test Plan document.
• Developed and automated SQL queries to perform backend data validation, ensuring compliance with business rules and regulatory requirements.
• Led end-to-end data testing efforts for data warehouses, ETL pipelines, identifying discrepancies and optimizing data flow.
• Worked closely with data engineers, BI teams, and business analysts to define data quality metrics and resolve data inconsistencies.
• Designed and executed test cases for machine learning models deployed on Azure, validating data pipelines, model performance metrics, and integration into Azure ML pipelines.
• Streamlined QA processes by developing automated testing scripts, resulting in increased efficiency and reduced manual effort.
• Automated data validation using Python, reducing manual effort and improving test efficiency.
• Validated reports and dashboards in Tableau, to ensure correct data representation and visualization.
• Implemented data comparison techniques to validate large datasets, ensuring data transformation and migration accuracy.
• Ensured compliance with GDPR, HIPAA, and other data governance standards through rigorous data testing.
• Mentored junior team members in QA best practices, fostering a culture of continuous learning and professional growth.
• Collaborated in Agile environments, actively participating in sprint planning, backlog grooming, and defect triaging for data-related issues.
• Update Requirements Traceability Matrix with test case traceability to the
  requirements.
• Functional Test execution - System Integration, assist in User Acceptance Testing,
  and Regression testing.
• Logging defects in JIRA and analyzing the causes.
• Create Traceability Matrix to ensures all business and functional requirements are covered by test scenarios and test cases.
• Defect management process in JIRA and follow Enterprise Testing standards.
• Carrying out severity analysis of reported defects.
• Client coordination for the project testing activities including defect triage and status meetings.

Tools and Technology: Python3, PL/SQL, PgAdmin, SSMS, Regression Testing, ETL Testing, Putty, Scrum, Data Analysis, Service Now, Tableau Desktop,JIRA

• Analysis of the Project Requirements from BRD and Project Specs Documents.
• Worked with Data Quality team to Analyze datasets to evaluate their accuracy, completeness, and consistency.
• Performed data profiling to understand the structure, content, and interrelationships of data.
• Detect and rectify inaccurate, incomplete, duplicate, or inconsistent data and Implement processes to ensure real-time or batch data cleansing.
• Managed defect tracking system effectively, maintaining clear communication channels with stakeholders regarding bug status and resolution timelines.
• Performed end-to-end testing on web applications, ensuring an exceptional user experience across various platforms and devices.
• Played a key role in successful software deployments through diligent validation of release candidates against established acceptance criteria.
• Conducted risk assessments for potential software releases, ensuring optimal product stability before launch.
• Optimized testing workflows by introducing innovative tools and methodologies that enhanced overall team productivity.
• Built automated test scripts to handle repetitive software testing work.

Tools and Technology: Python3, PL/SQL, PgAdmin, SSMS, Regression Testing, ETL Testing, Putty, Scrum, Data Analysis, Service Now, Tableau Desktop,JIRA

• Analyze the Business Requirements documents and prepared Test Plans for the various project releases.
• Test Plan Preparation, Test case design for new products and Execution.
• Estimate the efforts and timelines for delivery.
• Implementation of the automation framework for the regression suites as part of POC.
• Execution of test cases, logging valid defects and analyzing their causes.
• Developing Automation scripts and macros to reduce the manual effort for performing the repetitive task and to avoid human errors.
• Ensure scripting is carried out as per coding standards.
• Preparation of new scripts as per the change in the functionality or implementing the changes in the existing ones.
• Ensure that all the test cases are updated in the Quality Center.
• Executing the Regression Suite team for Regression Testing.
• Logging of the defects obtained while testing onto ALM for defect management monitoring and tracking.
• To interact with Client using IM and Conference Calls in case of any new requirements coming up.
• Process Improvement/Six Sigma within the project.

Tools and Technology: Test Automation, Regression Testing, UFT, Selenium WebDriver Putty, Data Analysis, ALM

• Analyze the Requirements documents and prepared front-end of application as per the requirement.
• Developed JCL Programs and DB2 queries for database connectivity.
• Developing test plan, execution of test cases, logging valid defects and analyzing their causes.
• Learned to interact with Client.