Post Job Free

Resume

Sign in

C# Sql Server

Location:
Hanover Park, IL
Posted:
August 09, 2023

Contact this candidate

Resume:

Rajesh Vaghani,

Chicago, IL adytel@r.postjobfree.com 224-***-**** US Citizen

PROFESSIONAL SUMMARY

•Results-driven IT professional with over a decade of global experience in Manual/Automation Software Testing for Web UI, web services/APIs using Agile, Waterfall, and V-Model methodologies.

• Adept in creating comprehensive testing strategies, plans, scenarios, and scripts.

•Skilled in diverse testing types including Blackbox, Functional, end-to-end/System, Regression, Performance, and Load testing.

•Proven expertise in Web API automation using Java-RX, Postman, and SoapUI/ReadyAPI.

•Proficient in Object-Oriented Programming (Java/C#.Net) and designing automation frameworks from scratch.

•Design and Develop automation frameworks like Data Driven, Keyword Driven, Hybrid and Page Object Modal, Cucumber (BDD), Hybrid BDD, Customized report using Selenium Web Driver.

•Extensively used Joins, sub-queries, grouping, stored procedures in SQL to data verification and backend testing using RDBMS such as Oracle, MS SQL Server, MySql etc.

•Experienced in JIRA, HP ALM and Clear Quest for defect management.

•Lead the small size test team through the complete Software Testing Life Cycle (STLC).

•Proven ability to work under pressure on multiple projects, prioritize and meet deadlines, Highly motivated, team player, quick learner, self-initiative, problem solving skills.

TECHNICAL SKILLS

Automation Tools

Selenium WebDriver, UFT, JUNIT, TestNG, Java, C#.Net, Nunit 3.0 Cucumber, Eclipse IDE, Amazon cloud S3, Jenkins.

Web Services Tools

Java, Postman, SoapUI/Ready API, Rest / SOAP, Jersey ( JAX-RS API)

Project/Defect Management Tools

HP ALM, JIRA, Zephyr, Git/GitLab, Clear Quest, TFS, Test managment

Databases & Tools

Oracle, MS SQL Server, MySql, SyBase, TOAD, SQL Workbench, SSMS

Programming

Java, JavaScript, React.Js, jQuery, VBA, C#.Net, C/C++, Python

Cloud And AI

MongoDB, Pivotal Cloud Foundry, SalesForce (CRM), AWS, ADO

WORK EXPERIENCE

SDET (Automation Test Lead), Wipro Ltd. June 2018 – Present

Charles Schwab Bank -(Austin, TX), Remote IL

•Participates in SCRUM meetings like daily standup, Story grooming, Sprint retrospective, Sprint demo, Srint Planning, Defect tracking and weekly status meeting with QA team.

•Review the requirement and prepare test data sets for the different test

•Performs GUI, functional, integration, and regression testing of various modules within the applications

•Documents the test results and Perform Defect Tracking & Management in JIRA

•Extensively used POSTMAN for WebAPI test for Rest Protocal using collections, javascript, data file.

•Developed POM automation frameworks using Selenium, JAVA, TestNG, Maven.

•Writes test scripts using Selenium WebDriver to validate all UI components, Pop-ups, Browser navigations, Mouse Movements for functionality

•Validate reports using PCF log, Splunk log, RabbitMQ, DB2 database, and S3 client.

•Utilize SQL (DB2, MS SQL Server, TOAD) for backend testing and data verification.

•Performs performance testing using JMeter.

•Uses Bitbucket for a source code versioning and repository system.

•Coordinate and mentor offshore testing team, ensuring successful project delivery.

Environment: Java, Eclipse, Selenium Webdriver, Bitbucket/Git, Bamboo, RestAssured, Postman, MongoDB, DB2, MS-SQL server, TOAD client, Mongo Compass, PCF, TeestNG, RabbitMQ, Splunk, Jmeter, ControlM.

Client : PriceWaterhouseCoopers -(Miami,FL), Remote,IL.

•As a member of Scrum Team participates in daily Standup, Story sizing, Backlog refinement, Sprint retro/demo and Sprint Planning meetings. Weekly status meeting with QA team.

•Writing test scripts using Selenium WebDriver bases QT framework to validate GUI applications using C#.net and NUnit.

•Performs Automation API testing with Rest-Assured using C# as well Java.

•Using C#, performs in detail validation of the JSON response/payload, data validate against database.

•Creates Test cases, Test Plan/Test Suits in Azure DevOps and associated with Test script for test run automation with ADO pipeline.

•Automates the PowerBI reports validation like, Bar chart, Circle chart, data count, Slicer, Dataset tables.

•Uses ADO /GitHub for a source code versioning and repository system.

•Using Azure DevOps for planning & organizing of story, tasks, workflows and testcases, testruns, Bugs.

•Parameterizes the Automation test script to login with different permission/roles.

•Writes test script using C#.Net to Automate MongoDB test cases.

•Responsible for code review, pull request approver, to maintain test script standards.

Environment: Selenium WebDriver, C#.Net, Visual Studio, Azure DevOps, GITHub, GIT, NUnit, Java, RestAssured, MongoDB, NoSQLBooster, PCF, Fiddler, Postman, SauceLab

Client: USBANK, Chicago, IL

Key Responsibilities:

•Develop Test Scenarios and test cases to demonstrate conformance to functional and non-functional success criteria and Design wireframe documents with Agile SCRUM methodology.

•Performed Cross-Browser Testing both Manual and automation using Selenium.

•Involve in Designing & developing Modular framework using Selenium Web Driver.

•Writing test cases using Selenium WebDriver with C#.net and Nunit framework.

•Participated in all Agile-SCRUM meetings and ceremonies.

•Use GitLab and TFS for a source code versioning and repository system

•Automated test runs, test results and Bug creation in JIRA with Jenkins/Test mgnt for JIRA /Selenium

•Designed and Developed test cases, test case mapping, traceability matrix, coverage matrix and other report in Jira using Test management for JIRA plug-in.

Environment: Selenium WebDriver, C#.Net, TFS, GITLab, GIT, JIRA, Test management plugin (Adaptavist), Visual Studio 17, NUnit test framework, Beyond Compare.

Technical Testing Lead, Infosys Ltd. Feb 2018 – June 2018

Ford, Dearborn, MI

Key Responsibilities:

•Lead off-shore QA team for the Parts and Dealer management e-commerce automobile portal.

•Prepared Test Strategy document, Test Scenarios, Estimation for the test for SCRUM/Agile env.

•Member of the Requirement review and test review team.

•Designed, developed and executed automation test cases/scripts using Selenium WebDriver, JAVA, TestNG, Maven bases on IWAF.

•Tested functional and end-to-end test. .

•Designed and execute automated regression test suits.

•Wrote SQL queries to test data on backend.

•Analyzing test results to verify project requirements and their success criteria.

•Regular interactions with Client/Business Leadership Team and various Offshore (performance, mobility, security testing) team and Onsite Team Members to ensure timely release of the Software.

Environment: Java, Selenium WebDriver, TestNG, IWAF, MS SQL Server, Eclipse IDE, Rally.

Principal Engineer (QA Automation Lead)

Fresenius-Kabi - Chicago, IL Jun 2017 to Dec 2017

Global health care company that develop and deliver inject able pharmaceuticals and infusion systems; blood collection, transfusion and cell technologies; and essential nutrients for parenteral nutrition.

Key Responsibilities:

•Review the manual test cases, Data dictionary, sysRs document for OnedrugLib (C#.Net, WCF,IIS) project.

•Prepared & Executed test cases, test scripts for end to end system testing,create traceability matrices.

•Developed BDD, Page Object automation frameworks using Selenium, Cucumber, JAVA, TestNG, Maven.

•Pioneered the automation of API testing using Java, Jersey and Jackson.

•Automated API testing using Postman for WebAPI test.

•Wrote SQL queries and Stored procedure to test data on backend.

•Identify weaknesses in QA Processes, Web testing. Suggested & implemented improvements.

•Evaluated Test Results, Change Request and Testing approaches throughout the development process using track & defect management tool IBM Clear Quest.

•Wrote testcases for Risk Management as per FDA regulation, Generated daily testing status reports.

•Manage repository and version control using IBM Clear Case.

Environment: Java, Selenium WebDriver, TestNG, Jersey,POSTMAN, MS SQL Server, Cucumber, Eclipse IDE, ClearQuest, MS Office.

Test Architecture/Developer, People Infotech Pvt Ltd., India Sept 2009- Mar 2016

Key Responsibilities:

•Designed data-entry screens/Forms, Coding, analysis Reports, Testing, Debug, Maintenance.

•Designed and Developed Tables, views, Indexes, Stored Procedure, Triggers

•Developed and tested dozen of Projects like Investment Portfolio Management System, Life Insurance Corp, Delta neutral Trading System, Multi-Head Payroll System, Financial Accounting System

Product Manager, Capital Legal Solutions, Falls Church, VA May 2008- Sept 2008

Key Responsibilities:

•Performed data validation using SQL queries, Checkpoints to verify data quality and calculations.

•Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.

•Executed test cases for end to end testing.

•Performed integrated and regression testing.

•Collaborated with Scrum Master and QA Lead to monitor and communicate status.

IT Consultant, FTI CONSULTING INC, Washington DC Jan 2007- Apr 2008

Key Responsibilities:

•Supported daily technical and operations support in all facets related to data migration, processing, converting.

•Quality assurance, tracking, and management of client data.

•Extensively used Joins, sub-queries, grouping in SQL to check backend data and data integrity as part of Data Driven Testing.

•Validated bulk data logically and physically after import from the load file.

•Used remote computing to perform the multitasking and multi-processing QA jobs.

•Developed SSIS packages for uploading and validating bulk data into MS SQL Server.

•Wrote QA VBA script as required to check file folder and file types.

•Designed tool to convert Office documents, Outlook .PST to the individual documents and then convert to Tiff images, fetch the metadata of the documents and record it to SQL server.

•Developed/upgraded tools for automating work process and QC process.

Software Developer, CALAMOS INVESTMENT, Naperville, IL April, 2006 – Dec 2006

Key Responsibilities:

•Involved in Phase I (Read Only Module) of the project.

•Designed and implemented Wrappers, SQL Stored procedure, Strategy for code migration.

•Changed VFP code, debugged, analyzed, solved the current bug and validated reports.

•Executed test case manually of other developer, reported Bug.

•Performed regression and system testing.

•Actively participated and provided solution to the defect resolution discussion.

•Provided data analyses due to database migration.

EDUCATION

Degree in Bachelors of Engineering (Electronics), MACT (REC), Bhopal University, India

Post Graduate Diploma in Human Resource Development, SP University, India

Certificate Course in Java, JavaBeans, JDBC, VJ++

Corporate Training in Advance C# and MS.Net Techniques

Certificate Course in Android Programming

Certificate Course in SAP-ABAP programming



Contact this candidate