SANDEEPA KORPOL
Phone: 469-***-**** / *************@*****.***
PROFESSIONAL SUMMARY:
Over 7+ years of experience in the IT industry as a QA Tester for manual, automated software testing, Web based and Client/ Server applications playing a key role in test planning, test development, test execution and test methodologies. Experience in testing Mobile, Transport and Health Care Domains.
●Expertise in Manual and Automation testing, Web testing, Mobile testing for IOS and Android, Mobile web End to End testing, System testing, Test Documentation and Release Documents Quality process.
●Extensive experience in SDLC process development and implementation as SDET. Methodologies used include Waterfall and Agile (Scrum).
●Solid Experience with both manual testing and automation testing.
●Adapted to existing framework and worked on enhancements of Automation Framework for web applications.
●Leveraged Seetest cloud for mobile applications instead of physical devices ● Collaborating and coordinating with other QA members.
●Leveraged Charles Proxy for understanding the backend service calls while working on mobile applications.
●Validated the API service response by passing invalid/valid and no value scenarios as part of the request
●Worked on creating test scenarios in Gherkin language for BDD
●Experience in Automation Testing - using Automation Testing tools like Selenium IDE, and Selenium Web Driver as SDET.
●Experience in testing applications developed in Java and .Net technologies related to various domains like eCommerce, Telecom and Retail.
●Review database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL Server.
●Experience in Mobile testing across devices and browsers.
●Experience working as SDET, CI/CD.
●Worked on CICD pipeline for running smoke test cases on daily basis.
●Extensive testing of API services using SOAP UI/Postman.
●Experience in working with opensource tools Selenium (Selenium IDE, Selenium Web Driver), TestNG, JIRA Eclipse and preparation of automation test framework.
●Solid hands-on experience in Functional testing, Integration testing, Regression testing, Blackbox testing, GUI testing, Back-end testing in different stages of Software Development Life Cycle (SDLC).
●Worked on defect management, defect analysis and defect reporting using HP quality center, JIRA, Bugzilla, qTest, Rally.
Created ETL test data for all ETL mapping rules to test the functionality of the Informatica
graphs.
●
●Have good experience in creating High Level Test Strategies
●Working with the different tools to extract the status and sending DSR’s and WSR’s
●Expertise in database querying, data manipulation and population using SQL in Oracle.
●Ability to work in tight schedules, can handle multitask assignments in an organized & timely manner.
●Highly conceptual and innovative problem solver with excellent organizational skills.
●Maintain excellent performance and exceed Client's expectations consistently throughout projects.
●Supporting the production releases and giving a go/No-go for major features during the release.
TECHNICAL EXPERIENCE:
Technical Skills:
Testing Tools
Selenium WebDriver, Cucumber, seetest, HP ALM, UFT, Devtest/Lisa,Xamarin forms UI, Nuget packages,Bugzilla,Jira,Rally,Skype,Teams,Slack
Languages
JAVA, HTML, CSS, XML, PL/SQL, SQL
Web Technologies
HTML, XML, CSS, JSON
Scripting
Java, JavaScript
IDE
Eclipse, SQL Developer
Test Framework
Cucumber, Page object model, Junit, TestNG, Data Driven Framework
Build Tool
Ant, Maven
Processes
Agile-Scrum, Waterfall
Bug Tracking Tools
JIRA, Rally, HP ALM
Continuous Integration Tools
Jenkins
Version Control
GIT/GITHUB, GITLAB, Bitbucket
Data Bases
Oracle 9i/11g, SQL Server, Cassandra
Operating Systems
Windows (XP,7,8,10), Mac
CAREER PROFILE:
The details of the various assignments that I have handled are listed here.
CVS healthcare / Dallas Oct 21-till date
Project: CVS Mobile Application
Role: SDET II
Responsibilities:
•Manual and Automation testing for mobile web, API, mApp and Desktop Application.
•Worked in Agile Scrum Environment with frequently changing requirements and features set.
•Involved in developing work plan and preparation of QA Environment.
•Involved in analysis, understanding the requirement specifications.
•Validated automation scenarios for API using Rest assured libraries
•Had been leading a team of 6 members where working closely with the team in understanding the challenges in reaching their sprint goals
•Mentoring and Guiding the team in reaching automation objectives for the QA org and helping them with technical challenges they have come across
•Interacting with the BA & Developers and collecting the requirements in order to transform business requirements into functional Test Scenarios.
•Validated mApp and mWeb on mobile applications for Android and IOS devices. Validated mobile apps and mobile web .
•Leveraged Seetest cloud for mobile applications instead of physical devices
•Created BDD scenarios for automation using Gherkin language
•Leveraged Charles Proxy for understanding the backend service calls while working on mobile applications.
•Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases for SIT Environment.
•Created manual Test Cases in TFS for various User Stories based on Sprint plan, and Test Executing.
•Performed functional, integration, end-to-end, system, regression, sanity and smoke testing.
•Performed manual and Selenium testing of a web based applications.
•Automated web applications with open source tools Selenium Web Driver, Eclipse and preparation of automation test framework using Cucumber and TestNG.
•Involved in implementation of Test Automation build using Behavior Driven Development (BDD) Framework, Selenium WebDriver, Cucumber, TestNG, JUnit and Maven technologies under Java platform.
•Involved in creating BDD - Cucumber Framework, adding scripts in Java (Framework Contains: BDD, Cucumber, Selenium Web Driver, POM, Maven, TestNG, Junit, extentAPI reports, TFS, Jenkins, GitHub).
•Interacted with developers, BA’s and various members of the team to discuss issues, resolve defects and set priorities.
•Attend daily scrum meetings to update on status, road blocks or any other concerns.
•Actively participated in Sprint meetings as part of Agile Environment.
•Mentored and assisted juniors in different project activities, organized Weekly Defect Review and Defect Status meetings and provided updates to Team Lead on testing activities.
Environment: Manual testing, Selenium WebDriver, Eclipse, Java, BDD, POM, Cucumber, Junit, TestNG, Jira, Maven, GitHub, TFS, Jenkins, Share Point, Confluence
CVS healthcare / Dallas Jul 20- OCT 21
Project: CVS -Data Warehouse/ ETL Tester
Role: SDET II
Responsibilities:
●Understanding data models and excels at transformations
●Strong identification and mitigation of existing data defects and errors
●Excellent technical writing skills and makes solid recommendations
●Superior ability to collaborate with all stakeholders
●Solid understanding of source to target data mapping
●Excellent verbal and written communication skills
●checking the accuracy and completeness of the ETL process
●Highly analytical with strong critical-thinking and problem-solving abilities ● Conducted packages testing and schema testing.
●Verified data completeness and transformation rules.
●Tested referential relations and integrities of data.
●Experience in SQL and PL/SQL scripting
●Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
●Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
●Helping developers with Unit testing for functionality validation using Spring Source IDE and been using Advance Java concepts to automate web applications.
●Use Hybrid (keyword driven and POM) Framework and extracted data from external Excel files using Apache POI and loaded into the variables in the scripted code.
●Review database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL Server.
●Maintaining the Jenkins Job files for each functionality and execute them accordingly to generate test reports.
●Leverage to visual studio code for creating Automation scripts using java script as scripting language
●Expertise in mobile automation using selenium, seetest for both IOS and Android.
●Constantly evaluate the test automation strategy and approach to identify areas of improvement. (i.e, test automation frameworks, coding standards, components and object repository methods, etc.) Designing Test Plans, Test Scenarios and Test Scripts for Automation.
●Utilize parallel processing or grid systems to speed up the tests. Defined and establish test metrics to measure not just product quality, but the quality of testing and feedback to engineers
●Identifying bugs to report to the developers and tracking the status using Rally and give daily status reports.
●Partner with product owner and developers to identify areas for improved efficiencies Giving Product Design Reviews in order to provide functional requirements and support application testing.
Research and work on software and tools that support delivery: Rally API, SOAP UI, Jenkins, JavaScript. Expertise in developing
●Share and communicate ideas both verbally and in writing to staff, business sponsors, managers, and technical resources in clear concise language that is appropriate to the target audience.
●Writing documents for test production to ensure Standards
Environment: Visual studio, Seetest, GitLab, Jenkins, Rally, SQL Server.
Verizon / Dallas Nov 18 - Jun 20
Project: Compass/My Offers flow
Role: SDET I
Responsibilities:
●Involved in Daily Scrum, Post-scrum, Sprint Planning Meeting, and Sprint Review Meetings.
●Performed Manual, Mobile and automation testing as SDET.
●Design, develop and implement automated tests for telecom web application. Write and execute Test scripts using JAVA, Spring IOC framework, Selenium and TestNG. Creating TestNg Framework environment to develop the test scripts.
●Expertise in developing and automating web services which includes handling SOAP/REST requests and response using SOAPUI and Postman API.
●Helping developers with Unit testing for functionality validation using Spring Source IDE and been using Advance Java concepts to automate web applications.
●Use Hybrid (keyword driven and POM) Framework and extracted data from external Excel files using Apache POI and loaded into the variables in the scripted code.
●Review database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL Server.
●Perform Data Base Validations and Be able to manage test data and utilize test data management techniques by doing CRUD operations to the database
●Maintaining the Jenkins Job files for each functionality and execute them accordingly to generate test reports.
●Expertise in mobile automation using Appium, selenium, java in both Android and IOS.
●Use POSTMAN, SOAP, REST Client tool which captures the web services response cached files and validate JSON request and JSON responses by automating REST API’s using REST Assure.
●Constantly evaluate the test automation strategy and approach to identify areas of improvement. (i.e, test automation frameworks, coding standards, components and object repository methods, etc.) Designing Test Plans, Test Scenarios and Test Scripts for Automation.
●Utilize parallel processing or grid systems to speed up the tests. Defined and establish test metrics to measure not just product quality, but the quality of testing and feedback to engineers
●Have been using Extent report, I Test Listener to generate reports and also used Log4j to extract logs along with reports
●Identifying bugs to report to the developers and tracking the status using JIRA and give daily status reports.
●Partner with product owner and developers to identify areas for improved efficiencies Giving Product Design Reviews in order to provide functional requirements and support application testing.
Research and work on software and tools that support delivery: Rally, ALM, Spring Source IDE, Postman API, SOAP UI, Jenkins, JavaScript. Expertise in developing and automating web services which includes handling SOAP/REST requests and response using SOAPUI.
●Debug software and perform reviews of automation and application code. Performing tasks using SVN, GIT, Maven, Junit and Testing to commit, deploy code
●Share and communicate ideas both verbally and in writing to staff, business sponsors, managers, and technical resources in clear concise language that is appropriate to the target audience.
●Writing documents for test production to ensure Standards
Environment: Selenium WebDriver, Selenium Grid, Java, SOAPUI, TestNG, Log4j, GitLab, Maven, Jenkins, Jira, REST Assured, SQL Server, Eclipse.
Verizon / Tampa Apr 18 - Oct 18
Role: Software Test Analyst Project: ATOM/PEGA Renewal flow
.
Responsibilities:
●Expertise in validating /executing web services test which includes handling SOAP/REST requests and response using SOAPUI and Postman API.
●Helping developers with Unit testing for functionality validation using Spring Source IDE and been using Advance Java concepts to automate web applications.
●Use Hybrid (keyword driven and POM) Framework and extracted data from external Excel files using Apache POI and loaded into the variables in the scripted code.
●Review database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL Server.
●Perform Database Validations and Be able to manage test data and utilize test data management techniques by doing CRUD operations to the database
●Maintaining the Jenkins Job files for each functionality and execute them accordingly to generate test reports.
●Expertise in mobile automation using Appium, selenium, java in both Android and IOS.
●Use POSTMAN, SOAP, REST Client tool which captures the web services response cached files and validate JSON request and JSON responses by automating REST API’s using REST Assure.
●Constantly evaluate the test automation strategy and approach to identify areas of improvement. (i.e, test automation frameworks, coding standards, components, and object repository methods, etc.) Designing Test Plans, Test Scenarios and Test Scripts for Automation.
●Utilize parallel processing or grid systems to speed up the tests. Defined and establish test metrics to measure not just product quality, but the quality of testing and feedback to engineers
●Identifying bugs to report to the developers and tracking the status using JIRA and give daily status reports.
●Partner with product owner and developers to identify areas for improved efficiencies Giving Product Design Reviews in order to provide functional requirements and support application testing.
Research and work on software and tools that support delivery: Rally, ALM, Spring Source IDE, Postman API, SOAP UI, Jenkins, JavaScript. Expertise in developing and automating web services which includes handling SOAP/REST requests and response using SOAPUI.
●Debug software and perform reviews of automation and application code. Performing tasks using SVN, GIT, Maven, Junit and Testing to commit, deploy code
●Share and communicate ideas both verbally and in writing to staff, business sponsors, managers, and technical resources in clear concise language that is appropriate to the target audience.
●Writing documents for test production to ensure Standards
Environment: Selenium WebDriver, Selenium Grid, Java, SOAPUI, TestNG, Log4j, GIT Lab, Maven, Jenkins, Jira, SQL Server, Eclipse.
NitidoITSolutions, Hyd, India Sep 12- Apr 14 Role: Software QA Tester Project: Drug file Responsibilities:
●Developed test plans, test cases based on functional specifications and design documents.
●Documented test cases and executed the test cases using Quality Center.
●Created Traceability Matrix between Requirements and Test Cases.
●Responsible for creating the folder structure in QC for scripts based on the functionality.
●Manually validated the Business functionality of all the flows in the project.
●Improved the flexibility of the tests by parameterization of the entire test, inserted checkpoints to test the functionality.
●Performed cross browser Functionality testing on multiple versions of IE and Fire Fox.
●Extensively used Oracle to verify the integrity of the database.
●Identify the functional scenarios to do performance testing and Performance smoke testing.
●Kept track of the bugs/defects, decided their priority and then assigned them to different developers using quality Center.
●As part of Functional testing, Performed Data driven test and dynamic data validation.
●Involved in test data creation by writing and executing SQL queries on TOAD.
●Attended status review meetings, interacted with developers to resolve the issues.
Environment: Quality Center, Java, Windows 2007, IE, XML, Oracle, HP QTP.