Post Job Free

Resume

Sign in

Test Data Sql Server

Location:
Houston, TX
Salary:
120000
Posted:
October 01, 2023

Contact this candidate

Resume:

Kewaji Gomase

Mobile: +1-813-***-****

Email id: adz20v@r.postjobfree.com Valid H1B Visa with I-140

Summary:

Over 16.5 years of progressive experience in Software Quality Assurance, and experience in leading a team across multiple geographies (Onsite, Offshore).

Hands on experience in Banking and finance Domain

Expertise in Functional, Regression, System Testing and UAT testing for GUI, Batch and Backend processes.

6 Years' Experience in Automation testing using selenium and Cucumber (BDD Framework). Selenium Web driver, Junit and TestNG framework.

Expertise in Test Process, SDLC & Bug Life Cycle.

Experience in working with Agile Scrum,

Expertise in creating technical documents like Test Case templates, Effort estimation, Traceability, Metrics, Defect Report, and Test Summary Report and adheres to Release schedule and QA sign off dates.

Experience in Jira, GIT, TFS, QC, Postman, JMeter

Experience in CI / CD tools like Jenkins and GitLab.

Experience in web service testing tools like Soap UI or any supporting tool.

Able to create data-driven tests using external sources in SOAP UI. API Testing/UI Automation

Interaction with Client for gathering requirements & with development team in resolving the issues.

Flair to adapt to new Technologies, self-starter, good communication and interpersonal skills.

Experience in working independently as well as in a team and across various departments.

Experience in insurance domain.

Has good experience in handling the team as a QA Lead Analyst. Has 12 plus years of domain expertise in Banking, Finance ERP, Health Care Domains and Capital Market/Investment Banking.

Technical Skills:

Database technologies: SQL Server 2012/2008R2/2008/2005/2000, Oracle SQL Developer, DBeaver testing DB like PostgreSQL, Snowflake

GUI: DELPHI 2005 & XE, MS Visual Studio 2008/2010

Languages: VB.Net, Selenium, Cucumber, and React

Operating System: Windows XP/2000

Configuration Tool: CVS, VSS, MS TFS, & JIRA, Gherkin, GIT.

Testing Tools: QC (ALM), SOAPUI,, Jira, TFS, VSS, MTM tool, Mobile testing, API, Automation testing with Selenium with Cucumber.

Education:

M.E – Master of Engineering Osmania University, Hyderabad, INDIA

B.E. – CBIT (Chitanya Bharathi Institute of Technology), Hyderabad, INDIA

Professional Experience:

Client: AIG/Corebridge (10/2020) – Till Date

Project Name: Retirement Services, Valic Online and Agile net, Retirement Manger, Financial wellness, V-systems, Life services consumer portal.

Role: Project Lead (QA)

Project Description: Creating a workflow for Retirement manger. Financial wellness assessment with Next best actions with participant and home office users, Creating Accounts and processing using V-systems (Mainframe)

Responsibilities:

Identifying possible enhancements and gaps in requirements, giving regular feedback.

Identifying the test scenarios as per the requirements.

Automation using Selenium web driver using Cucumber.

Creating API and UI Test Scripts and executing.

Responsible for testing multiple application delivery.

Experienced with testing of Client/Server and Web based application.

Client: JPM Chase (10/2019) –(10/2020)

Project Name: Low Value execution Box and Morcom & Decom Project

Role: QA Lead

Project Description: Low value execution box is payment gateway to process the transactions for APAC regions like Australia, Singapore, Thailand, Japan ect.. by running the various Jobs so that the transaction moved from one stage to the other stage.

Morcom-Decom project is de commissioned and updated with React technology.

Responsibilities:

Identifying possible enhancements and gaps in requirements, giving regular feedback.

Identifying the test scenarios as per the requirements.

Automation using Selenium web driver.

Responsible for testing multiple application delivery.

Experienced with testing of Client/Server and Web based application.

Environment: Dot. Net, SQL Server 2012, Manual, Mobile, IPADs, Jira, Windows 2000/2003/NT/XP, confluence tool

Automation using Cucumber, Selenium scripting.

Client: JPM Chase USA. New York, NY (10/2015) – 07/2019

Project Name: Chase credit cards Creation and Digital cards.

Role: QA Lead

Project Description:

Chase credit card creation for the various users and various cards like Chase Freedom, Chase ink, Chase Bold to offer the ultimate rewards point to the customers. User can use the ultimate rewards points for every purchase on the credit cards.

Chase payment activity is invoked to the users to pay the With Credit card payments, auto loan or auto lease payments through the cards and the user can view the payment details he paid and schedule a payment in advance.

Responsibilities:

Analyzing of the Business Requirement Document and identifying the scope of the testing.

Mobile testing in various variations like variation A, B and C, which is desktops, tabs and mobile devices including simulators.

Participating in Triage meetings.

Identifying possible enhancements and gaps in requirements, giving regular feedback.

Identifying the test scenarios as per the requirements.

Responsible for testing multiple application delivery.

Experienced with testing of Client/Server and Web based application.

Hands on experience in testing Web services and XML with tool called SOAP UI.

Experience on automation testing using selenium and cucumber.

Performed data driven testing using parameterization for large set of data.

Verified various API Service errors and status codes.

Adding various assertions to validate the response.

Writing and updating of test cases as per the requirements and change request documents.

Identification of test data including negative and boundary data

Perform Cross Platform/Browser/Mobile testing.

Automation using Cucumber.

Environment: Dot. Net, SQL Server 2012, Manual, Mobile, IPADs, Jira, Windows 2000/2003/NT/XP, confluence tool

Automation using Cucumber.

Client: Schwab. Inc. USA. Richfield, OH (01/2010) – 09/2014

Project Name: RPS-BSR (Benefit Statement Reports)

Role: QA Lead

Project Description:

Retirement Plan Service group (RPS) provides bundled retirement plan solution for companies.

The core organizational business units within RPS are plan Administration (Operations, Trading, ERIAS compliance, Defined Benefit Services), Client Services, Participant Services and Education Services.

SRI (Schwab Retirement Information system) is the Retirement Investment plans to provide the services to its client. It has the various modules like maintenance module, Conversation plan validation module and Trade Data Interchange. Conversion plan validation module generates the report for the customer based on the Plan ID. Money laundering is the disguising or concealing of the illicit nature or source of income or assets in order to make them appear legitimate. Money Laundering is also the use of legitimately earned funds for illegal purposes.

Responsibilities:

Analyzing of the Business Requirement Document and identifying the scope of the testing.

Identifying possible enhancements and gaps in requirements, giving regular feedback.

Identifying the test scenarios as per the requirements and writing the test cases.

Responsible for running the QA environment setup.

Responsible for testing multiple application delivery.

Develop the Pilot Project as Proof of Concept

Experienced with testing of Client/Server and Web based application.

Writing and updating of test cases as per the requirements and change request documents.

Identification of test data including negative and boundary data

Involved in Smoke testing for each build and analyzing if further testing can be performed.

Establish the Database Connectivity and write SQL Queries to import the Test Data

Share the Project Reports across the board.

Perform Cross Platform/Browser/Mobile testing.

Environment: Delphi, SQL Server 2000, Manual, TFS, Windows 2000/2003/NT/XP

Client: IFC World Bank Jan’10 – July’11

Project Name: IDESK & IBIS

Role: QA Lead

Project Description:

IDESK is the application for the World Bank IFC Support Services is composed of multiple application component support areas. These areas are User Support Services, Application Technical Support, and Application Change Requests and Production System Monitoring. Integrated, Centralized data foundation to support the data needs of the client IFC BI solutions provided by the Enterprise Data Warehouse. IFC ‘s data is maintained in various Transactional Systems like iDesk, EPMS, TRS, ACBS, CAPRI, MFA, BMS & ICASE and Informatica plays an ETL role across these systems. IBIS is the Integrated Budgeting and Information solutions which calculates the funding source information and uses component along with additional contributions.

Responsibilities:

Identifying the test scenarios as per the requirements and writing the test cases.

Responsible for running the QA environment setup.

Responsible for testing multiple application delivery.

Experienced with testing of Client/Server and Web based application.

Writing and updating of test cases as per the requirements and change request documents.

Identification of test data including negative and boundary data

Involved in Smoke testing for each build and analyzing if further testing can be performed.

Daily team meetings and client calls

Coordinating with teams as well as On site coordinator.

Defects analyzing and following with the team members.

Sending Daily status report to the onsite coordinator as well as client

Test estimation preparation and requirements analysis

Designed Automation framework and POC’s (Proof of concept)

Provide required technical/functional support to team members in their day-to-day activities.

Reviewing all the deliverables from team including automation work

set testing methodology for internal applications.

Knowledge in cognos, Java reports, and ETL Informatica.

Attending project related meetings/reviews, preparing test data, preparing test readiness review check list/Strategic test plan/System test summary report, Verify completeness and readiness of test environment for testing.

Resolve/raise teamwork issues/risks on time, well handling of customer requirements, implement new tools/techniques as per the requirement.

Environment: IDESK, IBIS, Java Reports, Cognos Reports, Java, Flex, SQL Server 2000, TOAD, ETL and Informatica, Manual, Quality Center 9.2, Windows 2000/2003/NT

Client: CISCO Systems Inc. USA March’06-Dec 08

Role: Quality Analyst

Project Name: ASPT

Project Description:

The Advanced Services Pricing Tool (ASPT) is an enhancement project which is already released various phases, used to create an opportunity, Quote and modified based on the customer requirement. This application has saved and modification facility to the customer so that customer can modify the quote details based on his requirement. It has modules like BI tool which is used to search the details of the user based on the Customer name, Quote number and

Responsibilities:

Experienced with testing of Client/Server and Web based application.

Writing and updating of test cases as per the requirements and change request documents.

Identification of test data including negative and boundary data

Involved in Smoke testing for each build and analyzing if further testing can be performed.

Establish the Database Connectivity and write SQL Queries to import the Test Data

Daily team meetings and client calls

Coordinating with teams as well as On site coordinator

Defects analyzing and following with the team members.

Sending Daily status report to the onsite coordinator as well as client

Test estimation preparation and requirements analysis

Environments: Java, SQL Server 2000, TOAD, Manual, Test Director 8.2, Quality Center 9.2, Windows 2000/2003/NT

Client: GenTech Lab June’05-Dec 10

Role: QA Lead

Project Name: mShoppe and Visa money Transfer.

Project Description:

The main objective of ‘MShoppe’ is a payment infrastructure that enables financial institutions to rapidly deploy several payment solutions to meet the needs of the emerging payment market. Medicine Shoppe is like card payment. The cards issued to the mShoppe must be enrolled with the ACCOSA server. The enStage personnel will do this step using the admin console. ACCOSA server will have a Base I listener running which will listen for incoming base I requests. The first time the card is used by the merchant, he has to load the amount (specified by the customer) on the card, so that it can be used for POS purchase. If the customer wants to cancel his card and get back the balance amount, he can ask the merchant to do a Cancel request. The Admin Console is a web-based interface that would be provided to each of the merchant terminals.

Visa Money Transfer is a powerful funds transfer product through electronic means. This facility enables the customers to transfer funds from their Debit/Credit card account to any Visa Debit or Credit Card. VMT facility is an efficient, secure, reliable and expeditious means to transfer funds across the globe. It has Three Modules as VMT module, Acquiring Module, Customer Service Module.

Responsibilities:

Experienced with testing of Client/Server and Web based application.

Writing and updating of test cases as per the requirements and change request documents.

Identification of test data including negative and boundary data

Involved in Smoke testing for each build and analyzing if further testing can be performed.

Establish the Database Connectivity and write SQL Queries to import the Test Data

Daily team meetings and client calls

Coordinating with teams as well as On site coordinator

Defects analyzing and following with the team members.

Sending Daily status report to the onsite coordinator as well as client

Environment: Java, SQL Server2000, manual, windows2000/2003/NT, POS Device



Contact this candidate