Project Management North Carolina

SONALI CHANDANKHEDE Location: Charlotte, North Carolina, USA

Contact: +1-980-***-**** Email: ************@*****.***

Overall, 9 + Years of experience in IT industry in Automation Testing/Maintenance (Selenium/Java/TOSCA), Functional Testing, Database Testing, Manual testing, API Testing using Postman/Rest Assured library, Mobile testing, ETL testing and Agile project management process experience in Warehouse, Pharmaceuticals domain, Banking domain and retail.

SUMMARY:

•Solid understanding of Agile methodology, Test Planning, Test Design, Test Execution and Defect Reporting & Tracking. Strong understanding of Agile development principles and DevSecOps practices.

•Experience in designing and implementing POM (Page Object Model), Data driven Framework using Selenium WebDriver, TestNG & CI-CD Process (Jenkins).

•Strong Experience in UI Testing, API Testing, Functional Testing and Web Application Testing.

•Experience in White Box, Black Box testing, Functional, Regression, Integration and System Testing.

•Expertise in writing SQL queries to validate Database.

•Created automation test framework using TOSCA,Worked with ALL Modules of TOSCA, like Modules, Test cases, requirements, test case design and execution Lists

•Completed TOSCA Certification.

•Experience in ETL (Extract, Transform, and Load) testing with SSIS packages and validating data using SQL queries.

•Strong understanding of data warehousing AND data modeling concepts.

•Experience in Mobile testing using tool Appium.

•Experience in Mobile App testing on Android, iPhone,Emulator Simulator to perform Mobile App testing, phone functionality and native app testing

•Involved in setting up Automation Framework Using Selenium Web Driver, JAVA, BDD Cucumber and TestNG.

•Experience in API Automation Testing using a Java-based library, Rest Assured.

•Good experience in Java Object-oriented Programming and Its Implementation in Project.

•Expertise in developing and executing scripts using Selenium Web Driver and TestNG framework.

•Experience in designing automation framework using Page Object Model (POM) Design for better code reusability & maintenance.

•Experience in defect logging, tracking, and monitoring using JIRA, HP ALM, and HP Quality Center (ALM).

•Experience in working closely with users during User Acceptance Testing.

•Involvement in Project Planning, Project Road Map Discussions, Test Estimations, Test strategy implementation, Creation of Test Plans and Test Reports.

•Involved in Production support and Post Release support.

•Coordinating with Upstream/Downstream applications, development team and all the supporting teams

•Weekly, Daily Status meetings with Business team and sending Daily/Weekly Status Reports on Project Progress.

•Expertise in Software Development Life Cycle (SDLC) in Web and Client-Server Applications.

•Experience Working in Agile Methodology and Waterfall Methodology.

•Self- motivated, highly energetic and ethical in all work-related assignments thus able to immediately contribute to corporate goals and objects.

•Good written, communication, interpersonal skills, problem solving and delivering solutions.

•Capable to adapt and learn new tools, techniques and approaches.

•Able to handle multiple tasks and work independently as well as in a team.

PRIMARY SKILLS:

Methodology

SDLC, Waterfall, Agile/Scrum.

Testing Tools

Selenium IDE, Web Driver (Java), API-REST, Postman, Rest Assured, TOSCA, Appium, HP ALM

Test Build and Integration Tools

Maven, Jenkins, Azure DevOps, GIT

Frameworks

Data Driven, Page Object Model,ASP.NET, BDD Cucumber, TestNG

Database

SQL Server, SQL, ETL testing

Business Intelligence ETL Tool

SSIS Package, Autosys

Languages

C#, JAVA, SQL, JavaScript, gherkin, xml, HTML,CSS

Project management &

Defect Tracking Tools

JIRA, TFS, HP QC, HP ALM, q test

Other tools

Eclipse, Visual Studio Code.

PROJECT EXPERIENCE:

Client: Molina HealthCare, SFO, CA (remote) Oct 2023 – Till Date

Role: Software Development Engineer in Test (Web/Mobile automation) Company: Moxie IT

Project Description: eBilling-Web Application maintained by Molina to view Medicaid, Medicare, Group and Individual Invoices and its related Transaction, enroll account, and allows Payments either bank or credit card, terminate Account, Provide notifications.

Responsibilities:

Documented Test plans and Test cases corresponding to business rules and requirements.

Worked in Agile/Scrum, attended daily Scrum meeting, Sprint planning, Retro meeting.

Performed Integration testing, System Testing, End to End testing, User Acceptance testing, Functional Testing, Regression Testing, Interface Testing.

Created automation framework from using JAVA Selenium Web Driver and TestNG framework.

Developed BDD tests using Cucumber by writing behaviours and step definitions.

Developed complex SQL queries for data validation and backend testing.

Maintained the Selenium & JAVA automation code and resources in source controls like GIT over the time for improvements and new features.

Developed Appium script for native Android/iOS using java.

Identified Objects of app using Apple UI Automator tool for android and Appium Inspector for iPhone.

Used virtual devices (Emulator & Simulator) and real devices for Test Cases validation.

Used maven for building the project .Integrated with CI tool Jenkins for running Automation Scripts.

Created and executed test cases for ETL operation to ensure all data quality standards and regulations.

Performed Data validation and reconciliation on ETL process execution to check data load, data mapping, data transformation.

Used JIRA to create Bugs, provide detail Scenario outlines, attached picture of the Logs to help the developers understand the bug provided also for defect submitting and tracking, managing tasks, change orders and enhancements, release management and uploading the test results, Generating reports and graphs.

Conducted API testing on validating customer data services using Rest Assured.

Used SQL server for Backend Testing, SQL Queries for data validation and validate report data.

Communicated and collaborated information flow between Client, QA Team and Developers.

Involved in Production support and Post Release support.

Involved in team meetings with representative from Development, Database Management, Configuration Management, and Requirements Management to identify and rectify defects

Environment: Java, Selenium, JIRA, gherkin, cucumber,GIT, Web API Testing using Rest Assured, Jenkins, Appium,Azure DevOps, TestNG, maven, ETL,SSIS, SQL

Client: Bank of America, Charlotte, NC Aug 2022 – Jun 2023

Role: Software Engineer in Test Company: Collabera

Project Description: Deal Entry for Lending and Transition Approval (CASECURA) is a credit approval system which integrates the credit pipeline with system of records. DELTA provides the basic credit workflow, contains enhancement to integrate and provides the increased scalability and support additional reporting functionality. This product is divided into five sections: accessing DELTA, pending deals from salesforce dashboard, Deals dashboard, DELTA downstream data flow and reports

Responsibilities:

Worked in Agile Team, attended daily Scrum meeting, Sprint planning, Retro meeting.

Documented Test plans and Test cases corresponding to business rules and requirements.

Performed Integration testing, System Testing, End to End testing, User Acceptance testing, Functional Testing, Regression Testing, Interface Testing.

Created automation test framework using TOSCA,Worked with ALL Modules of TOSCA, like Modules, Test cases, requirements, test case design and execution Lists

Used JIRA to create Bugs, provide detail Scenario outlines, attached picture of the Logs to help the developers understand the bug provided also for defect submitting and tracking, managing tasks, change orders and enhancements, release management and uploading the test results, Generating reports and graphs.

Used SQL server for Backend Testing and checking the output of various reports.

Conducted Back End Testing for data validation using SQL Queries.

Communicated and collaborated information flow between Client, QA Team and Developers.

Involved in Production support and Post Release support.

Involved in team meetings -Development, Database Management, Configuration Management and Requirements Management to identify and rectify defects.

Environment: TOSCA, JIRA, SQL, q test

Client: Radian Group Inc., Philadelphia PA Jan 2021 – July 2022

Role: Software Development Engineer in Test (Web/Mobile automation) Company: Moxie IT

Project Description: Geneuity allows Agent, Broker, Buyer and Seller to either List or Purchase Property. It gathers

Property’s MLS data in one place such as documents, market trends, e-signatures, scheduling and communication.

Responsibilities:

Documented Test plans and Test cases corresponding to business rules and requirements.

Performed Integration testing, System Testing, End to End testing, User Acceptance testing, Functional Testing, Regression Testing, Interface Testing.

Created automation framework from using JAVA Selenium WebDriver.

Used TestNG scripts to run automated test cases in different environments.

Developed BDD tests using Cucumber by writing behaviours and step definitions. Designed and executed features of ATDD (acceptance test driven development)/BDD using selenium, cucumber for java.

Maintained the Selenium & JAVA automation code and resources in source controls like GIT over the time for improvements and new features.

Implemented Appium scripts to test iOS and Android platforms for testing.

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

Conducted testing and validation of ETL processes ensuring accurate data extracting, transformation and loading.

Used JIRA to create Bugs, provide detail Scenario outlines, attached picture of the Logs to help the developers understand the bug provided also for defect submitting and tracking, managing tasks, change orders and enhancements, release management and uploading the test results, Generating reports and graphs.

Conducted Back End Testing for data validation using SQL Queries.

Involved in team meetings with representative from Development, Database Management, Configuration Management, and Requirements Management to identify and rectify defects

Environment: Java, Selenium, JIRA, gherkin, cucumber, GIT, Web API Testing using Postman Tool, Appium, Jenkins, Azure DevOps TestNG, maven, ETL,SSIS, SQL

Client: Anheuser Busch Brewing, St Louis, MO Nov 2018 – Sep 2020

Role: Software Engineer in Test Company: Infosys USA

Project Description: Pricing Master Inquiry (Mainframe Modernization) is an intranet web application used to view price of a product along with other details such as brand, package description, container cost for the wholesale number entered by user in the consecutive screen and generate the invoice

Responsibilities:

•Conducted Smoke, GUI, Functional, Integration and Regression testing during various phases of Development.

•Developed Test cases from business use cases, Test data and Selenium scripts for UI Testing.

•Regression testing by automation using Selenium WebDriver & JAVA.

•Maintained the Selenium & JAVA automation code and resources in source control using Git Remote repository GitHub Over the time for improvements and new features.

•Developed and maintained Selenium Script on Jenkins to support Regression testing whenever a Change Request is completed.

•Configure the CI environment & ran automation script in Continuous integration (CI) tool using Jenkins Followed Continuous delivery (CD) process.

•Configured Maven for JAVA automation projects and developed Maven project object model (POM).

•Extensively automated Regression and Functional Test suites by developing test cases, test suites using Selenium WebDriver, JAVA and JUnit.

•Design, implemented, executed and maintained ETL test cases to ensure data integrity and accuracy.

•Perform ETL validation to check data mapping and data transformation

•Reported & tracked the bugs, performed E-mail notifications to the developers using JIRA.

Created Automation Framework & ran scripts on different browsers/environments & reported defects/results

Used TestNG scripts to run automated test cases in different environments.

Conducted API testing on validating RESTful Web Services using Rest Assured.

•Performing Back End Testing with extensive use of SQL Queries

•Performed GUI, Functional, Front-end, back-end testing and reviewed page content problem, Link verification.

•Gathered and analyzed Tests logs, Defects and Implement Final Test Summary Report in SharePoint.

•Achieved customer satisfaction and high quality by effective Automation testing, AGILE Processes Responsibilities.

•Participated in Defect Review Meetings with team members and coordinated with project development team.

•Involved in QA Activities -Test Planning, Requirement Analysis, Creation of Test Traceability Matrix, Test Case preparation

Environment: Java, Selenium, JIRA, GIT, Web API Testing using Rest Assured, Jenkins, Azure DevOps, TestNG, maven, ETL,SSIS,SQL

Client: Themis-Pharmaceutical Company Jun 2016 – Aug 2017

Role: Software Engineer Company: Sapology India

Project Description: Pharmaceutical Sales Force Automation Application is designed for Automating Sales and Marketing Strategy for Themis Company. It provides functionality for Marketing, Budgeting and Targeting Sales and provides Reporting Management Yearly, Monthly, and Daily from Marketing Executive Manager

Responsibilities:

•Analysed Business requirements and developed Test cases based on Use Cases to evaluate the functionalities.

•Responsible for implementing effective quality assurance processes and practices.

•Attended use case and technical specifications review sessions with product and architecture teams to provide feedback in the elaboration phase.

•Created test plans outlining the scope, approach, schedule, resources and deliverables.

•Coordinated the maintenance of multiple test environments to support parallel test efforts.

•Worked with Business Analyst to define and design test cases template.

•Performed GUI, regression of front end manually.

•Used JIRA to map requirements to test cases, provide traceability to requirements, create test sets, and selectively run tests both manually and using Automation Test Scripts.

•Maintain and updated Requirement Traceability Matrix.

•Involved in daily defect meetings during testing phase and worked extensively throughout Defect Life Cycle from opening to closure.

•Isolated test cases for manual and automated testing, also established a regression test suite, both manual and automation, to assure the stability of UAT.

•Perform backend testing to validate the data using SQL Server, added SQL queries to the required Test cases.

•Reviewed product requirements, functional and design specifications to determine and prepared automated test Script.

Environment: Java, Selenium, TFS, Web API Testing using Postman Tool, Jenkins, maven, TestNG, SQL Server Testing

Client: Themis-Pharmaceutical Company Nov 2015 – May 2016

Role: Software Engineer Company: Sapology India

Project: HRMS Project, Appraisal Module is in-house project of Themis for Management of Data to be filled by Employee for their Appraisal Process as per Company standards of Appraisal. Provides all feedback and Score as per Questionnaire as per the Score of Appraise, Provided by Appraiser and resultant Score is the Appraisal Report

Responsibilities:

•Reviewing Functional Requirement Specifications as well as Test plan, Test Cases and Test Reports.

•Ensure that the required level of the product quality is achieved, documenting and testing is performed in accordance with the Test plan, processes and Requirements.

•Managed test case development and supported using formal specifications, data flow diagrams, and other accepted design techniques.

•Planed, designed, executed test plans and test cases for automated test and manual test to support maintenance releases for multiple software applications.

•Coordinated and facilitated meetings between test team and development team members to identify and resolve defects identified by the test team.

•Created and executed test scripts for application testing, regression testing and acceptance testing.

•Coordinating with Upstream/Downstream applications, development team and all the supporting teams

•Maintain and updated Requirement Traceability Matrix

•Performed back-end testing to ensure that the user data was updated in database using SQL queries.

•Prepared of test summary reports, defect analysis reports.

•Tested enhancements and bug fixes for software releases and patches and document findings.

•Define and track quality assurance metrics such as defects, test results and test status

•Provided a systematic review process and resources to assure all products met regulatory and conformant requirements prior to client release.

Environment: Java, Selenium, TFS, Web API Testing using Postman Tool, Jenkins, maven, SQL Server Testing

Client: Keys Hotel, Mumbai Jan 2014 – Nov 2015

Role: Software Engineer Company: Sapology India

Project Description: Hotel Port Web Application acts as central hub for booking of hotel rooms. It is an in-house Hotel booking Application of Keys Hotel. Keys Hotel is a leading chain of budget hotels & resorts in India offering best business, cheap and affordable hotel.

Responsibilities:

•Worked in Agile/Scrum methodology,Attended Weekly and Daily Status meetings with Business team; sending Daily/Weekly Status Reports on Project Progress.

•Documented Test plans and Test cases corresponding to business rules and requirements.

•Used Team Foundation Server (TFS) for defect submitting/tracking, managing tasks, change orders and enhancements, release management, running test cases, uploading test results, Generating reports and graphs.

•Attended daily Scrum meeting, Sprint planning and Retro meeting as part of the agile team.

•Performed Integration testing, System Testing, End to End testing, User Acceptance testing, Functional Testing, Regression Testing, Interface Testing.

•Created UI automation framework from scratch using JAVA Selenium Web Driver.

•Used JIRA to create Bugs, provide detail Scenario outlines, attached picture of Logs to help developers understand the bug provided, also maintained the Bug Life Cycle.

•Involved in QA Activities Like Test Planning, Requirement Analysis, Creation of Test Traceability Matrix, Test Case preparation, System testing, System Integration testing, Test Reporting, Defect Management, Change Requests of the application.

Environment: Java, Selenium, TFS, Web API Testing using Postman Tool, Jenkins, maven

EDUCATION:

Bachelor of Engineering (Electronics and Telecommunication), Maharashtra, India-2014

Contact this candidate