Sheetal Darpe

ac7f9g@r.postjobfree.com

408-***-****

Coralville, Iowa

Professional Expertise

Having around 3 years experience in Information Technology as developer and QA automation tester, involving analysis, Automation as well as Manual testing for web applications, Web Services and mobile automation .

Working with Agile environment and actively participate in grooming user stories, Sprint planning, and daily stands up to help establish a Behavior-Driven Development (BDD) approach.

Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).

knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.

Strong knowledge in developing Automation Framework with different patterns like Data Driven, Modular, UIMapping and PageObject pattern using Selenium WebDriver, TestNG/JUnit, Java also used java libraries like Apache POI for data driven testing, Log4j for logging and debugging applications.

Good understanding of Jenkins jobs for Smoke and Regression test cases execution based on Selenium Grid, pull request merge and build deployment.

Strong knowledge in automating REST API’s using HttpClient, REST Assured, JSON parsing with org.json and adding assertions using TestNG.

Worked on JSON and/or XML format for web services.

Extensive experience of testing web services (SOAP and REST) in SoapUI using Groovy and browser based plugins like Postman and REST Client.

Experience on SQL, PL/SQL to build Oracle stored procedures, functions.

Good knowledge of database objects like tables, indexes, constraints, triggers and stored procedures.

Good knowledge of Test automation for web application using Cucumber.

Good knowledge in Mobile App Testing manually as well as automation tools like Appium for testing ANDROID and iOS platforms collaborating with Android SDK and Xcode.

Good knowledge of Performance and Load testing with different protocols like HTTP, SOAP, JDBC using JMeter.

Experience working with version control such as Git for repository management and also used Maven as build tool.

Strong knowledge of Cucumber BDD framework with Selenium WebDriver for UI and API Automation.

Hands on Defect Tracking tools like Microsoft TFS,Rally and Jira.

Familiarity with NoSQL database – MongoDB.

Education:

Oracle9i OCA certified.

Master In Computer Management ( MCM ), Pune University

Technical Skills:-

Automation Engineer

DuPont Pioneer, Des Moines, Iowa July,2018 - Till now

Description: DuPont Pioneer Hi-Bred is a large U.S. producer of hybrid seeds for agriculture. They are a major producer of genetically modified organisms (GMOs), including genetically modified crops with insect and herbicide resistance. At DuPont Pioneer to increasing productivity and production of agriculture in an environmentally sustainable manner while helping farmers around the world become more successful. DuPont Pioneer uses cutting edge science to help improve farmer productivity and profitability while providing a foundation for farming as a sustainable livelihood that meets the needs of people today and future generations. The benefits of agriculture development programs accrue to others beyond DuPont Pioneer and its customers.

Responsibilities :

Working with tight iterations throughout the development cycle in Agile.

Working on End-To-End development related to testing activities like functional, Integration, system, regression, unit testing

Working on the Hybrid framework using Selenium WebDriver, TypeScript, Yarn, Microsoft TFS, Protractor, NodeJS.

Working on Team Foundation Server (TFS) as project management tool to use writing and execution of test cases.

Have experience to execute test cases parallel using Grid.

Working on Web services API testing using PostMan Tool for manual testing and SOAPUI to create script with JSON.

Creating performance test scripts using JMeter to monitor response time and performance of the RESTful APIs.

Working on Git Repository and developed build scripts, and executed them in TFS build Production Environment

Extensively use TFS for creating test cases and bugs, running the build, tracking and managing defects.

Using SQL Server for data integrity testing, capture the SQL statements from the application execution and manually checked the results.

Creating test data using SQL server and execution of setup and cleanup automation test data script using PowerShell.

Environment: Protractor, Node-JS, Selenium, SQL Server, Yarn, Microsoft TFS, TypeScript, JavaScript,Microsoft Visual Studio, powerShell.

Software Developer CCMIS- ICICI Bank, Mumbai, India Feb, 2007 - Sep,2008

Description: This application has been developed for Bank Employees to access information of all the customers of the bank to help resolve Customer queries/issues related to Accounts, Bill Pay, and Funds transfer etc. Application also deals with Case Management where Bank Employee opens a case when informed by Bank Customer. All stages of case open, close, escalation, CIF (Customer Information File) creation, risk grading of customers, blacklist customer is handled.

Responsibilities:

Involved in all cycles of the development like gathering requirements, design, development, testing, deployment and support.

Involved in Logical and Physical modeling of the new data marts created for reporting purposes.

Created ER Diagrams for business requirements and transformed them on to the database.

Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Tuning SQLs to enhance the performance of the campaigns, simultaneously to achieve better results.

Tuned performance queries using explain Plan, TKPROF, SQL TRACE, ANALYZE, HINTS etc.

Create partitioned tables & moving data from non-partitioned tables to partitioned tables.

Created views and materialized views to resolve complex queries.

Added/Changed Tables, columns and triggers.

Created Dimensions and Facts and have implemented Slowly Changing Dimensions for Historical Data captures

Developing macros and triggers for the common usage across the campaigns.

Environment: SQL, PL/SQL,Toad.

Software Developer

Larsen & Toubro Limited HED–IT, Powai, India Jan, 2006 - Sep, 2006

Description: Quality Management System (QMS) is designed so that Mechanical or Production engineers (Shop & Inspection & Radiographic Dept.) can maintain their record for project (job) in the system. It contains complete information about project. Reports can be on different filter viz. Seam, Without Seam, Section wise, Cleared Seam and Seam Range and print the same.

Responsibilities:

Creation of Technical Design Documents based on the High Level Design Documents provided by the Business analyst.

Developed Stored Procedures, packages, functions using PL/SQL to implement day to day modified business rules into the current system

Developed SQL Loader scripts for loading data from varying resources and inserting the master data into tables.

Implemented triggers to enhance functionality, supplement validation, and default transaction Processing.

Tuned the queries to improve the performance using Explain Plan, TK Prof, Auto Trace utilities, assessed the efficiency of the code modules.

Involved in daily Backups of transaction logs and scheduling Jobs to perform this task.

Loading and updating the Key Entities in base tables using PL/SQL Procedures.

Extensively involved in preparing Mapping sheets for Interface and Base table.

Preparing CTL files for loading data into the staging Database.

Involved in developing detail technical design documents for project implementation.

Guided and worked with the team in configuring the application

Reporting on a regular basis with the Development authorities, ensuring timely deadlines are met.

Environment- PL/SQL, Mapping sheets, SQL Loader script.

Contact this candidate