Ranjita Nepal
***************@*****.***
PROFESSIONAL SUMMARY:
I worked as an Automation Tester and Quality Analyst for the last 7 years, analyzing design and implementing the testing strategy for application.
Good understanding and experience working on AGILE Methodologies and involved in all phases of Software Development Life Cycle (SDLC).
Proficient in different forms of testing like Manual testing, Unit testing, Integration testing, Regression testing, Performance testing, and Non-functional testing.
Strong expertise in developing test automation using C#/.NET.
Experience in creating test data and end to end testing for web-based applications.
Experienced in unit testing with NUnit and XUnit.
Automation experience in Selenium using C# and Java.
Experience in writing and executing SQL queries on databases for backend testing.
Extensive experience of working on both web-based and client-server applications.
Extensively automated Regression and Functional test suites by developing test cases and test suites using Selenium WebDriver.
Expertise in testing Web Services using Postman and SoapUI tool.
Experience in Data Migration testing and Web Interface testing.
Involved in creating a test framework based on BDD, DDD, TDD using tools like Specflow, Cucumber, to automate UI testing and API/web services testing.
Experience in writing and executing SQL queries on databases for backend testing.
Deploy and run the Continuous Integration builds as part of the Code deployment using Jenkins.
Strong experience in functional and UAT testing using Selenium Web driver on both platforms as well as cross-platform web testing on all major web browsers.
TECHNICAL SKILLS:
Languages
C#, .Net, Java, HTML/XHTML, XML, SQL, PL\SQL, T-SQL
Testing Tools
Selenium WebDriver, Jira, Postman, Specflow, Cucumber, SOAPUI,
IDE
Visual Studio, Eclipse, IntelliJ, SSMS
Databases
SQL Server, MS Access, Cassandra DB
Browsers
Internet Explorer, Firefox, Safari, Google Chrome
Test Framework
NUnit, XUnit, TestNG, JUnit, Chai-Mocha Framework
PROFESSIONAL EXPERIENCE:
JCPenney, Plano, TX, Feb 2022 – Present
SDET / QA Automation Engineer
Responsibilities:
Extensively involved in all stages of testing life cycle, Test Driven Development methodologies, Software Development Life cycle (SDLC) using Agile methodologies.
Developed and maintained test automation framework using C#/.NET and Selenium WebDriver.
Developed and implemented robust MVC pattern base testing with Selenium WebDriver which cut down the script development time in half.
Designed and Developed Test Cases for automated testing using Selenium and TestNG.
Created test cases, scripts based on functional specification, prepared test data for simultaneous and combined Trade testing.
Automated unit and integration tests with NUnit and XUnit
Developed Test cases manually and generated Automation Scripts using open-source tools like Selenium Web Driver, TestNG, SOAP UI, Maven, and Jenkins.
Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing, environment using Selenium WebDriver.
Worked on Selenium GUI Object/element verification is done through XPath, CSS Locators.
Used TestNG Annotations in Selenium WebDriver and executed a batch of tests as TestNG suite.
Created XML based test suite and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations.
Wrote Behavior-driven, Cross Browser automation test cases and executed them for Cross-browser compatibility using Selenium Grid and Cucumber.
Used Soap UI tool to test SOA based architecture application to test SOAP web services and REST API.
Involved in executing SQL queries and PL/SQL procedures, functions, and packages for backend testing.
Used GIT for code repositories and Maven for the dependencies.
Extensively used SQL statements to query the Oracle Database (RDBMS) for Data Validation and Data Integrity.
Environment: Java, Selenium WebDriver, TestNG, Maven, Jenkins, Cucumber, SOAP UI, Eclipse, TDD, Agile, HTML, XML, XPath, JavaScript, Quality Center/ALM, GIT, SQL, Windows.
Comerica Bank, Dallas, TX Aug 2019 - Jan 2022
SDET / QA Automation Engineer
Responsibilities:
Performed meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
Wrote scenarios and tests in Gherkin language in Specflow for BDD approach.
Conducted user acceptance testing (UAT) to validate that the developed application meets the business requirements.
Automated test cases using Selenium WebDriver, NUnit and C#.
Mocked test data to test all the scenarios and test cases planned.
Written several complex SQL queries for data verification and data quality checks.
Located web elements using different locators in Selenium WebDriver.
Integrated automation framework with UI automation testing using BDD and DDD approach.
Tested API and web services using manual and automated methods using Postman and C#.
I Wrote scripts to upload data into database tables on the SQL Server environment.
Communicated with Project Management to establish LOE of each phase of SDLC and prioritized QA task.
Helped developers in preparing test data, and aided BA in understanding SQL scripts.
Performed User Acceptance Testing (UAT) on each release of the project with the help of end-user requirements.
Excel reports are validated using SQL and embodying complex formulas in Excel.
Environment: Selenium WebDriver, NUnit, SQL, Postman, SharePoint, SQL Server, TOAD, Flat files, MS access
SunTrust Bank, Atlanta, GA Apr 2017 - Jul 2019
Automation Quality Assurance Analyst/ Tester
Responsibilities:
Created Test plans, managed team members, assigned tasks and conducted meetings.
Follow Agile Methodology for all the phases of SDLC and actively involved in all stages of STLC (Software Testing Life Cycle).
Created and maintained test plans, test cases, and automated test documents.
Supported Temenos T24 core banking implementation and data migration activities.
Created checkpoints and synchronization points in the application to deal with timing problems.
Involved in Web Services/REST API Testing using Postman and automated the web services testing.
Automated regression test cases for key T24 modules, reducing manual effort.
Identified, developed, and reviewed systematic procedure for each test case after going through the documents provided.
Resolved post-go-live defects by analyzing T24 logs and system reports.
Wrote Gherkin language test case scenarios in a feature file using Cucumber.
Validated financial transactions and balances post-migration using SQL queries.
Used Jira to open bugs, create tasks and user stories, initiate change requests.
Effectively Communicated testing status to QA lead, project managers, and teams who are involved in User Acceptance Testing.
Environment: Java, TestNG, Postman, Windows, Gherkin, Cucumber, BDD, SQL Server, Agile, API, Jira, Selenium WebDriver
EDUCATION:
Bachelor of Science in Information Systems, University of Texas at Arlington