Test Data Sql Server
Resume:
Kewaji Gomase
Mobile: +1-813-***-****
Email id: *******@*****.*** 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