Sasmita R Email & Phone Number

Fort Mill, Sc

• Create comprehensive test plans covering functional, performance, and regression testing scenarios for data pipelines. Ensure test cases align with data mapping and defined business transformation rules.• Responsible for design and write test cases align with data mapping and business transformation rules defined.• Write SQL queries to compare data across source, staging, and target systems. Verify data accuracy, completeness, and consistency throughout the data pipeline. Identify and handle issues like duplicate records, invalid data types, and ensure referential integrity between tables, especially during on-premise to cloud data migrations.• Develop Python scripts using Pandas libraries to automate repetitive data validation tasks and improve efficiency. Utilize rule-based comparisons for data validation.• Conduct parallel system testing by comparing pre-production environment data loads with production data to ensure data accuracy before deployment.• Performing the Data Security Testing using Snowflake external UDF using Protegrity services for client PII data protection.• Participate in production support calls with stakeholders to help identify root causes and troubleshoot application issues related to data.• Perform data and system validation tasks after production deployments.• Developing Postman collection to perform REST API Integration testing.• Perform Functional Testing for Angular web application features using Selenium Wen Driver & executing the functional test cases for each release.• Involved in Ad-hoc testing to capture additional bugs that have escaped through the regular testing.• Work closely with data engineers to resolve data quality issues and troubleshoot identified problems. Keep all stakeholders informed about the testing process, progress, and any potential data quality risks.

Chicago, Illinois, United States

• Responsible for design and write test cases align with data mapping and business transformation rules defined.• Write SQL queries to compare data across source, staging, and target systems. Verify data accuracy, completeness, and consistency throughout the data pipeline. Identify and handle issues like duplicate records, invalid data types, and ensure referential integrity between tables, especially during on-premise to cloud data migrations.• Participate in production support calls with stakeholders to help identify root causes and troubleshoot application issues related to data.• Perform data and system validation tasks after production deployments.• Developing Postman collection to perform REST API Integration testing.• Perform Functional Testing for Angular web application features & executing the functional test cases for each release.• Involved in Ad-hoc testing to capture additional bugs that have escaped through the regular testing.• Work closely with data engineers to resolve data quality issues and troubleshoot identified problems. Keep all stakeholders informed about the testing process, progress, and any potential data quality risks.• Participate in SCRUM ceremonies, including Sprint Grooming, Planning, Retrospective, Review Sessions, Client Demo, and daily stand-up calls, fostering collaboration and agile development practices• Designed and developed automation scripts following the behavior-driven development (BDD) approach using Core Java, ensuring effective testing of application changes.• Customized the automation framework by configuring POM XMLs with necessary dependencies (Apache Poi, Extent report, Log4j), and built reusable utility classes, optimizing test automation.• Designed and developed test automation scripts using TestNG within Selenium, leveraging test case annotations and comprehensive test reporting.• Involving in Functional Testing & Regression Testing with Selenium Web Driver.

• Designed and developed automation scripts following the behavior-driven development (BDD) approach using Core Java, ensuring effective testing of application changes.• Actively participated in SCRUM ceremonies, including Sprint Grooming, Planning, Retrospective, Review Sessions, Client Demo, and daily stand-up calls, fostering collaboration and agile development practices.• Customized the automation framework by configuring POM XMLs with necessary dependencies (Apache Poi, Extent report, Log4j), and built reusable utility classes, optimizing test automation.• Designed and developed test automation scripts using TestNG within Selenium, leveraging test case annotations and comprehensive test reporting.• Developed a REST API automation framework using POSTMAN workspace, testing a wide range of client and server assertions, and built a data framework using Excel and Property files for efficient API testing.• Utilized Bitbucket to maintain test scripts, ensuring version control and collaboration among team members.• Integrated the automation suite with Jenkins, achieving continuous integration and continuous testing (CI/CT) for seamless and automated build and test processes.• Created a detailed breakdown of Test Tasks, encompassing Analysis, Design, Automation, and Execution phases, within the JIRA board, effectively planning and managing testing efforts.• Actively participated in Feature grooming sessions, raising questions, addressing risks, and collaborating effectively with agile teams. Regularly reported test status and impediments in Daily Stand-up meetings, facilitating quick issue resolution and alignment with project goals.

Bengaluru, Karnataka, India

• Reviewed and analyzed functional specification requirements to gain a deep understanding of the Application Under Test (AUT), ensuring that testing efforts are aligned with project goals.• Designed and developed automation test scripts using Selenium WebDriver, leveraging core Java, to automate testing processes efficiently.• Created Keyword Driven and Data-Driven frameworks to enhance test automation capabilities, allowing for flexible and reusable test scripts.• Collaborated with developers and recorded defects in JIRA, actively tracking them until resolution, ensuring comprehensive issue management.• Generated detailed reports of bugs and test execution summary reports, maintaining transparency and documentation throughout the testing process.

Bengaluru, Karnataka, India

• Analyzed Agile methodology requirements presented in the form of iterations, preparing detailed analysis documents to ensure a clear understanding of project needs.• Participated in reviewing Business Requirements Documents and Technical Specifications to ensure alignment between business needs and technical implementation.• Assisted in writing comprehensive test plans that outlined testing scope, strategy, test requirements, and resource requirements, providing a clear roadmap for testing activities.• Played a key role in designing, developing, and managing the Quality Assurance (QA) process, ensuring effective testing practices throughout the project lifecycle.• Analyzed and understood business specifications to define the scope of testing, ensuring that testing efforts align with business goals.• Authored Product Functional Test cases for various features and executed these functional test cases for each release, validating the functionality of the software.• Conducted ad-hoc testing to capture additional defects that might have escaped regular testing, enhancing the overall quality of the software.• Raised defects and maintained a detailed bug history in Clarify, ensuring comprehensive defect tracking and performing regression testing of defects after they were fixed.• Conducted functionality testing, usability testing, and compatibility testing to ensure the application operated seamlessly across different browsers, including IE, Mozilla, Opera, and Safari.• Performed functional, system, and web testing on various builds of the application, verifying its performance and functionality.• Participated in User Acceptance Testing (UAT) for Java applications, aligning the testing activities with user requirements and collecting user feedback.