MANASA CHANDRI

Mobile: +1-203-***-****

E-Mail: ad2upl@r.postjobfree.com LinkedIn:https://www.linkedin.com/in/ManasaChandri/

PROFESSIONAL SUMMARY:

Dedicated and Invocate QA automation lead with 10 years of progressive experience in software analysis, software quality assurance automation testing of web, windows, webservices, client server application and database across Banking, Insurance (Property & Casualty (Guidewire (PC, BC, CC)), Guidewire OOTB, web and mobile applications., Test Automation, Team, and Stakeholder Management. Execution of testcases to verify application functionality against business requirements, utilizing selenium web driver, rest assured, Junit, API automation, Java, Appium, postman, BDD, maven, Karate, GIT, GitHub, SVN, Jenkins, cucumber, cyprress, Jira, Playwright, Microsoft Azure, Salesforce CRM, Salesforce Lightning CRM, Pega, Apex, MongoDB, sql server, ReactJS, CSS, HTML, UFT, Lamba, Microsoft Access, Eggplant, Data Warehousing Pyspark, Databricks, Power BI, UX/UI, WSDL, XML. Linux, Performance testing, Micro services, eclipse, Apache Kafka, Eggplant, IntelliJ among several others. Strong abilities in White Box testing, Microsoft SQL server, Black Box testing, writing test plans, GUI automation testing, system testing, Integration testing and regression testing of web-based applications. Expertise in UAT testing so that the business users the business users properly involved and supported throughout the UAT timelines. Responsible for database analysis and database testing, testing ETL procedures and data reconciliation using ETL report and custom SQL’s. Responsible for driving project status calls with the client, including reviewing, and getting approval from client for complete documentation, test plans, test scenarios and test script. Tracked, prioritized, and organized defects by working with the development team to facilitate timely corrections. Direct team members to follow specific test standards and guidelines and outlined project requirements.

TECHNICAL SKILLS:

Testing tools, Approaches, Frameworks, Build & Integration Tools: Selenium WebDriver, TestNG, Cucumber, SOAPUI, Junit, JMeter, ALM, QC, BDD, Agile/Scrum, Waterfall, SDLC, STLC, Bug Life Cycle, Maven, ANT, Jenkins, TortoiseSVN, Keyword driven, Data driven, Hybrid, Page Object Model, Karate, SVN, GIT.

Programming Languages, Databases, Operating Systems: JAVA, JavaScript, Gherkin, Angular, MYSQL, Oracle, T-SQL, Windows, MAC OS, Unix

MS Office, Utilities: Outlooks Word, Excel, PowerPoint, MS Access, SharePoint, SoapUI, ServiceNow, SILVA, HP Quality Center (ALM), JIRA, Bugzilla, Mantis, Confluence, qTest, ROBOT framework, Tomcat server, JMeter, Confluence.

Applications: Guidewire, Oracle eBS, Mule Soft, Mobile Applications

Cloud: Microsoft Azure, AWS, Salesforce

Education Details:

Master of Computer Applications (2010), JNTU

BSC (Computer Science) (2007), OU

Achievements:

Received Customer Delight award for extraordinary performance.

Received Work together award from Client.

Received Raising start award for extraordinary performance.

Professional Scrum Master Certified.

Worked both on Agile and waterfall model.

PROFESSIONAL EXPERIENCE:

Client: Kemper Auto (June 2023 to Till Date)

Designation: QA Consultant

Project Name: Kemper Auto (Reciprocal for IL)

Implementation: Stratus

Responsibilities:

As a Quality Analyst, I am involved in testing and validating Kemper Personal Line (Auto) business insurance policy, Billing, and claims processes. Some of the major business processes in Policy Decisions are creating a quote, issuing a policy, documents, Suppress contributions, Billing cancellation, RPP, CFQ’s, BROS, endorsements, cancellations, Reinstatement, Reports, Rewrite, and renewals. These processes were tested and evaluated under various business situations that might initiate an action in other modules/products like PC (Policy Center), BC (Billing center) and CC (Claim center) in Property & Casualty.

Experience working on Policy center, Billing center and claim center as writing testcase in claims center, creating claim, FNOL Process, Reports, and policy flows and testing the defects in SIT, Regression, Ad hoc and End to end testing.

Reviewed and understood user stories/ functional Requirements and various business requirements documents.

Played a key role in developing and maintaining automation frameworks for medical device software, focusing on Test Driven Development (TDD) and Behavior Driven Development (BDD) principles.

Develop and maintain serverless applications using AWS Lambda.

Design and implement automated solutions for data processing and analytics using AWS Lambda.

Utilized Microsoft 365 platform, JIRA, Power BI, and various third-party QA tools to enhance the QA process and deliver high-quality software products.

Expertise in Policy center testing in creating, Endorsement, OOS, UW’s, Non-renewal, cancellation, Renewal, 2nd Renewal, Renewal terms (10 Renewal terms), MVR, Claim attachments, UDI, rating, and premium calculations.

Designed and executed Test plans and Test cases according to product backlog and user stories Identified and organized the plan for test data, strategy, and the Scope of testing within the context of each Sprint.

Contributed to developing Automation Framework that uses Java, Selenium Web Driver, Cucumber and TestNG.

Created new users for Producers, I user and Euser all states (AZ, IL, IN, NV, and TX) of NEWINS and 3rd party.

Automated and performed functional testing of the front-end using Selenium Web Driver & created Hybrid framework using TestNG, Junit and JDBC Connections which reads data from scripts using database and XML files.

Spearheaded the establishment of automation testing processes using Playwright, significantly enhancing efficiency and reliability of testing workflows.

Expertise in utilizing Playwright for automated testing, with a strong emphasis on efficiency and reliability.

Experience in Kafka from UNIX Box and validated Policy data, vehicle data and calculated the premium for the policy.

Experience in Apache Kafka for API testing validation for Policy, driver, Vehicle validations and premium calculations of rating engine.

Participate in Agile ceremonies such as sprint planning, retrospectives, and daily stand-ups.

In the Agile development model (Scrum/Sprint), organized regression test suite and optimized the workflow.

Executed the database test cases for Policy, Billing, Renewal, Reports, OCP, Claims and Surplus contributions using Microsoft SQL server database.

Executed the database queries for required Policy, Billing and claim related queries, also executed SSRS reports and AXIS reports in database and web UI.

Executed the Digital customer portal, AWD, and mobile application testing (ABANA, Illinois vehicle, Kemper auto, Access Insurance).

Experience in Playwright for API load testing for personal auto application.

Experience in Executing the API testing of rest Assured using Playwright tool.

Developed and maintained a Data Quality Framework to capture, measure, monitor, and remediate data quality issues in data pipelines.

Experience with Native App Automation frameworks/tools such as Appium/Katalon Studio.

Experience in web app interface, performance and compatibility testing using Katalon.

Experience in working Cypress UI (JavaScript/TypeScript and NodeJS) for angular application end to end testing.

Collaborated with development and testing teams to create and maintain unit tests for application code.

Experience in working with Charlet Proxy Debugging tool.

Verified the Charlet proxy network traffic between the app and backend server. Debugging the issues for API Integration testing and verified the data is transferred correctly.

Experience in Cypress API testing for automating Integrating testing the Insurance suite.

Experience Cypress UI for automating the end-to-end testing from scratch of Insurance application and web applications.

Also Experience in writing the CSS selector, Xpath’s and assertions for Framework in cypress UI.

Performed End-to-End testing of data pipelines using ETL techniques.

Created pipeline jobs to integrate automated tests with continuous integration tools using Jenkins.

Architecture a robust automation framework for cross-browser testing on multiple browsers.

Generated automated test reports and summarized test execution results for stakeholders.

Strong experience in Accessibility testing for Kemper custom application for Insurance suite, Claim and assigning the claim, user creations, Reports assigning, content and roles & responsibilities for the user provided correct.

Expertise in SQL queries to check the data accuracy and verify the SIT and end-to-end data from UI to the database.

Working on mobile application testing for IOS and Android using Appium.

Implemented Appium script to test IOS and Android Platform.

Experience in Accessibility testing of content is visible or not, heading and Logos.

Implemented UI Automator viewer in Appium to inspect elements in mobile application (WDIO).

Performed testing on the various mobile devices of Xcode’s with a various platform (iOS, Android)

Expertise in Executing the SQL queries for verifying reports and Source and target data in SQL server, oracle database.

Perform manual testing to assess keyboard accessibility, screen reader compatibility, and alternative text for images and multimedia content.

Verified the Accessibility testing for the documents, Policy creation values in insurance domain.

Executed manual and automation test cases for AZ, IL, IN, NV, and TX of Kemper and AACC UW.

Client: AXA-XL, a division of AXA (Nov 2022 to June 2023)

Designation: Claims Quality Assurance lead (SDET lead)

Project Name: AXA XL Reinsurance (PC, BC & CC)

Responsibilities:

As a QA Lead, I was involved in testing and validating Personal Line business insurance Claim processes. Few major business processes in Claim creations. These processes were tested and evaluated under various business situations that might initiate an action in other modules/products like PC (Policy Center), BC (Billing center) and CC (Claim center) in Property & Casualty.

I am part of Claims System QA team, which claim system Reinsurance migrates towards a single point for Claim Creation and Legacy systems by means of Guidewire Claim Center.

Requirement Analysis and providing Test Estimation for complete testing life cycle of the Integration with Guidewire Claim Center for every iteration.

Verifying and validating the system software application for Guidewire policy center, Billing center, claim center and third-party Integrations. Preparation of Test Scenarios from raw documents like Use Case Documents and Data Mapping Requirements.

Utilized Microsoft 365 platform, JIRA, Power BI, and various third-party QA tools to enhance the QA process and deliver high-quality software products.

Tested the Guidewire OOTB Functionalities for the Policy, billing and claim and cross the functionalities.

Developing and Executing test scripts using Gunit framework.

Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression Jira test suites (TestNG and Maven).

Involved in Functional testing, Integration System testing (API Postman and Rest Assured), Multi Browser testing, Production validation testing, Assembly testing & Database testing.

Stayed updated with industry best practices and emerging tools in performance testing and monitoring.

Used BDD Cucumber Selenium with JAVA and TestNG as a Framework to automate the test cases.

Test Data Design in Claim Center and Test Execution with all the necessary justifying documents both on the Claim center UI using CIA Page/Support Page and with the inbound & outbound files for the third-party applications.

Hands on experience in working Cypress UI (Node JS, React) for angular application end to end testing.

Performed feed validation, column mapping, data quality testing and ETL quality testing. (Performed database performance testing).

Day to day activities like building and deploying code in different environments like SIT, UTA using Jenkins, Azure DevOps.

Experience in Kafka from UNIX Box and validated Policy data, vehicle data and calculated the premium for the policy.

Experience in Apache Kafka for API testing validation for Policy, driver, Vehicle validations and premium calculations of rating engine.

Developed and maintained Eggplant test automation scripts for GUI, web, and mobile applications, ensuring comprehensive test coverage and early defect detection.

Develop, maintain, and execute automated test scripts using WebDriverIO-Appium and JavaScript to ensure high quality and timely delivery of software products.

Expertise in App Automation frameworks/tools such as Appium/Katalon Studio.

Expertise in web app interface, performance and compatibility testing using Katalon.

Used select SQL queries to check the data accuracy and verify the SIT and end-to-end data from UI to the database.

Work closely with the development team to identify and resolve defects and performance issues.

Collaborate with cross-functional teams to ensure smooth and successful delivery of projects.

Participate in code reviews to ensure the quality and maintainability of test automation code.

Participate in Agile ceremonies such as sprint planning, retrospectives, and daily stand-ups.

Keep up to date with industry trends, best practices, and new testing tools and technologies.

Peer reviewed the test cases and after completion of testing reviewed the test results and provided signoff for SIT and End-to-end test cases.

Implemented Appium script to test IOS and Android Platform.

Experience in Accessibility testing of content is visible or not, heading and Logos.

Implemented UI Automator viewer in Appium to inspect elements in mobile application (WDIO)

Performed testing on the various mobile devices of Xcode’s with a various platform (iOS, Android)

Capgemini: Lead SDET Engineer (Automation / Selenium / Guidewire/ API)

Client: DLG (Oct 2018 to Aug 2021)

Location: Hyderabad Telangana

Project Name: Direct line Group Auto Insurance.

Responsibilities:

As a Quality Analyst, I was involved in testing and validating Personal Line (Auto) business insurance policy processes. Some of the major business processes in Policy Decisions is creating a quote, issuing a policy, endorsements, cancellations, and renewals. These processes were tested and evaluated under various business situations that might initiate an action in other modules/products like PC (Policy Center), BC (Billing center) and CC (Claim center) in Property & Casualty.

Experience working on guidewire claim center as writing testcase in claim center, creating claim and testing the defects in SIT and End to end testing (FNOL Process).

Reviewed and understood user stories/ functional Requirements and various business requirements documents.

Expertise in Policy center testing in creating, MTA, OOS, cancellation, Renewal, 2nd Renewal, Migrations, promo and discounts, Telematics device, DVLA, rating and premium calculations.

Designed and executed Test plans and Test cases according to product backlog and user stories Identified and organized the plan for test data, strategy, and the Scope of testing within the context of each Sprint.

Experience worked on Jenkins, Azure-Iass DevOps, Build Pipelines, Release pipelines for continuous integration and for End-to- End automation for all build and deployments.

Performed Sprint level testing, Functional Testing, Systems Integration Testing, UAT, and Regression Testing. Performed unit testing using GUnit of guidewire Insurance suite.

File are stored in the SharePoint location for Auditing and references.

Perform verification and validation testing in guidewire third party Integrations like Address lookup, Vehicle lookup, Radar, DVLA, Claim lookup, lexis Nexis, NCD, Pricing barring, LPT, Telematics, vendor invoicing, Rating, Motor Vehicle, Digital (policy creation), PCW (Quote creation), Smart comms (for Documents), payment gateway (world pay, Spike Integrations).

Participated in daily Scrum Meetings, Sprint Planning Sessions, Sprint Review and Sprint Retrospective Sessions.

Strong experience in Accessibility testing for Insurance suit guidewire Application of principle, content and roles & responsibilities for the user provided correct.

Verified the Accessibility testing for the documents, Policy creation values in insurance domain.

Involved in preparing burned down chart for measuring the progress of the project with stakeholders.

Support other ETL developers, providing mentoring, technical assistance, troubleshooting and alternative development solutions.

Day to day activities like building and deploying code in different environments like DEV, SIT, UAT using Jenkins, Azure DevOps, Docker.

Demonstrated to client/product owner in sprint review sessions that all requirements are met as per sprint backlog Interacted with developers, Business & Management Teams and End Users Prepared and provided status summary reports on system status, system changes, problems, and potential impacts.

Have been working on Guidewire Policy Center transformation testing project, handling a team.

Contributed to developing Automation Framework that uses Java, Selenium Web Driver and TestNG.

Automated and performed functional testing of the front-end using Selenium Web Driver & created Data Driven framework using TestNG and JDBC Connections which reads data from scripts using database and XML files.

Experience in creating the Jenkins (CICD) jobs to push the newly built docker image to Azure- Iass container registry.

Automated test scripts and processes for improved test repeatability and efficiency.

Responsible for updating Daily/weekly Status reports and involved in task allocation, leading & training the junior team members.

Performed Guidewire UI testing in Policy Center, Billing center and Claim Center Screens for Personal lines business.

Functional Regression testing the Personal Lines application to create policies and perform all policy jobs.

Worked closely with the QA Manager in co-ordination and Implementation of the Agile methodologies /QA processed and generating Test Scenarios and documents like (DOD, Process documents, Traceability)

Pulled the Kafka logs from UNIX Box and validated Policy data, vehicle data and calculated the premium for the policy.

Expertise in testing critical time travel templates and Inflight testing for all the releases.

Expertise in database feed testing (Oracle finance, firco-soft and pulse).

Automated test cases using Selenium, automated release acceptance and regression sets of test cases.

Used Data Loader to insert, update, and bulk import or export of data from salesforce.com Objects. Used it to read, extract and load from comma separated values (CSV) files.

Used select, update, insert into SQL queries to check the data accuracy and verify the end-to-end data from UI to the database.

Perform data analysis, testing, and validation using SQL queries, stored procedures, and data to tests that leverage source-to-target validation for Data Reconciliation between source and target of oracle application system.

Conducting UAT tests to ensure that the application meets business requirements and identifying any defects or issues.

Helped users on validating and providing sign-off to the UAT testing that indicates the application is ready for production release.

Facilitated UAT meetings to keep stakeholders and users informed of progress and ensure that testing is on track.

Hands on experience in working Cypress (Node Js, Mocha) for angular application end to end testing.

Peer reviewed the test-cases and after completion of testing reviewed the test results and provided signoff for SIT and End-to-end test cases.

Tested performance and reconciliation of oracle Bi reports and QlikView in insurance domain.

IBM: SDET Engineer (Automation Testing / Selenium Testing)

Location: Hyderabad Telangana

Client: DBS Bank Limited

Project Name: ONLINE Banking – IDEAL 3.0 & IDEAL connect (March 2015 to Jan 2018)

Responsibilities:

Understanding the software requirements and get clarifications from end users.

Involved in project KT sections, walk-through on FSD, E2E testing of business rules on applications from project test team, dev team and customers as a BAU tester.

Involved in testing of the workflow which includes Smoke Testing, Regression testing, System testing, Functional testing, GUI and UAT testing.

Validating and end-to-end testing of the Corporate Banking applications which includes PAYMENTS- SWIFT Outgoing Pay-OTT, ACT, XCUIT, SWIFT XCUI Test, Expresso, with Katalin with cloud service, Telegraphic Transfer-TT, RTGS-Incoming/Outgoing, Payroll, Cheques, FAST and GIRO.

As a BAU Tester engage and coordinate with clients for test planning of existing production defects to identify testable requirements and develop test cases.

Extensively performed Manual Testing process to ensure the quality of the software on different browsers as IE, Firefox, and Chrome for the same set of test scripts.

Conducted functional and regression testing of mortgage origination and servicing systems to ensure they met business requirements.

Involved in developing selenium automation framework using TestNG.

Participated in system integration and user acceptance testing, ensuring end-to-end mortgage processes functioned as expected.

Developed and maintained Eggplant test automation scripts for GUI, web, and mobile applications, ensuring comprehensive test coverage and early defect detection.

Written several SQL statements to confirm successful data transfers between source and target.

Worked closely with the QA Lead in co-ordination and Implementation of the Agile

Implemented Appium script to test IOS and Android Platform.

Experience in Accessibility testing of content is visible or not, heading and Logos.

Implemented UI Automator viewer in Appium to inspect elements in mobile application (WDIO)

Performed testing on the various mobile devices with a various platform (iOS, Android)

Tema Business Systems: QA Engineer/ SDET Engineer

Location: Hyderabad Telangana

Client: Sage Group

Project Name: OSP Portal (Community Portal) (Aug 2011 to Sept 2012)

Responsibilities:

Reviewed product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

Preparing and executing Test-Cases for OSP portal.

Preparing Test Data’s and Test Environment to execute the test cases.

Used select, update, insert into SQL queries to check the data accuracy and verify the end-to-end data from UI to the database.

Performed Sanity and Regression testing on communication portals and chatting portals.

Involved in Functional, Integration Testing and System Testing and End to end testing.

Updating the test cases based on the Change Requests/Enhancements.

Strong experience in Digital Marketing and multi-lingual sites built on Adobe AEM.

Review of Functional & Design documents, Review of Test cases written by other team members.

Verified the form validations in SQL.

Tema Business Systems: QA Engineer

Project Location: Hyderabad, India

Client: Sage Group

Project Name: Fine HRM (Aug 2010 to Aug 2011)

Responsibilities:

Reviewed Functional Requirement Specifications and created Test cases based on Test scenarios drawn from functional requirements.

Worked closely with Developers, Product Managers and Business Analyst to get updates and resolve defects.

In the Agile development model (Scrum/Sprint), organized regression test suite and optimized the workflow.

Performed Positive testing and Negative testing for HP QC, UFT Environment.

Extensively used Functional testing, Performance testing, and Regression testing for HR module and payroll..

Performed functional, Cross Browser, and GUI testing using Java, Selenium Web Driver.

Performed Sanity, Regression, Functional, Integration, System and End to End and UAT testing.

Reported defects using mantis tool and interacted with developers to resolve defects/issues.

Written testcase for ETL to compare the source to target database systems.

Strong experience in Digital Marketing and multi-lingual sites built on Adobe AEM

Verified the data in source to target tabled in database.

Worked on JavaScript for client-side validation in Java.

Contact this candidate