KANCHAN VELHAL
E-mail: adjgfe@r.postjobfree.com
Mobile# 206-***-****
Immigration Status: Green Card
PROFESSIONAL SUMMARY
Over 9+ Years of experience in Manual and Automation Testing
• Previous Employer: 1) Cognizant Technology Solutions –India & USA (Jan. 2005 – Apr. 2011) 2) Capgemini Consulting – Mumbai, India (Jun. 2011 – Apr. 2012) 3) Wipro Technologies, Los Angeles, USA (Nov. 2012 – Jun. 2013) 4) Wells Fargo Bank, Phoenix, USA (Feb. 2019 – Till Date)
Domain experience includes projects in Banking, Auto-Insurance, Automobile, Energy and Utility
5 Years of experience working in US for clients – Washington Mutual Bank, New York Times, American Honda, Wells Fargo Bank.
Experience in Functional Testing, Regression Testing, Smoke Testing, Integration Testing, Compatibility Testing, Database Testing, Mainframe Testing, Web Application
Experience in Agile Process methodologies, attend Scrum meetings, and provide resource estimates for Stories.
Strong Knowledge of SDLC and STLC process, Bug Life Cycle.
Experience in tools – Big Data - Apache Kafka, Kibana, HP Quality Center/ HP ALM, Test Director
As an Onsite Test Lead, coordinated with the Business, Development, System Administrators and Offshore teams.
Able to handle multiple assignments simultaneously, and effectively bring discussions and issues to closure
Automation testing experience includes enhancing and maintaining Test Automation Framework, creating test scripts, reviews, defining scope
Mentored and groomed several junior testers throughout projects.
Exceptional working knowledge of the peer review process.
Capability to respond to critical issues in an appropriate and systematic manner.
Extensively involved in all stages of Quality Assurance Life Cycle.
Quick learner and has the ability to adapt to changing priorities.
Goal oriented team player with strong analytical, organizational, problem solving and communication skills.
Personal skills include excellent communication, strong sense of organization and effective time management and have the ability to work in a team as well as independently.
Strong in analyzing Business Requirements and Functional Specifications and use cases.
Proficient in creating traceability matrix for one on one mapping of test cases with the Business requirements.
Hands-on experience in creating, maintaining & reviewing test documentations including Test Strategies, Test Plans, Test Cases, Test Scripts and Test Execution Results.
Good knowledge of Quality processes, SDLC life cycle, QA testing methodologies (Waterfall, V Model, Agile).
Knowledge on writing UFT (Formerly QTP) Test scripts using VB Script.
Knowledge on Keyword Driven, Data Driven Testing, Cross Browser Testing and Database Testing using UFT (Formerly QTP)
Well-versed in SQL Server & Oracle environments to query and manipulate data for data validation, manipulation and verification by SQL.
Excellent verbal, written and analytical skills with ability to work in a team as well as individually in fast paced, dynamic team environment
EXPERIENCE SUMMARY
Jan. 2005 – Apr. 2011 Cognizant Technology Solutions –India & USA Jun. 2011 – Apr. 2012 Capgemini Consulting, India
Nov. 2012 – Jun. 2013 Wipro Technologies, Los Angeles, USA Feb. 2019 – Till date Wells Fargo Bank, Phoenix, USA CERTIFICATIONS
EXTERNAL CERTIFICATIONS:
HP Quick Test Professional 9.2 Software Certified
HP Quality Center 9.2 Software Certified
INTERNAL COGNIZANT CERTIFICATIONS:
Cognizant Certified Professional for Software testing. Cognizant Certified Professional for Quick Test Professional 8.2 TECHNICAL SKILLS
Bug Tracking Tools Rational Clear Quest,Test Director, HP Quality Center, JIRA, ALM 12.55
Management Tools and Database MYSQL, MS-SQL Server 2000, Mainframe, TOAD, Oracle SQL Developer
Programming Language Visual Basic 6.0
Automation Tool UFT (Formerly QTP -Quick Test Professional 8.2/9.2/9.5/10.0,
Other Tools Kafka, Kibana, Eclipse IDE, IBM Infrared 360, POSTMAN Operating Systems Mac OS X, Windows 2000/XP/7
PROJECT DETAILS
Project Name: Payment Tracker
Duration July.2020 TO Till Date
Location Chandler, Phoenix (US)
Client Wells Fargo Bank
Domain Banking (Testing Services)
Tools Apache Kafka, Kibana, SQL Developer, IBM
Infrared 360, JIRA, Postman
PROJECT DESCRIPTION
Payment Tracker is an application that will communicate with various key Payment Systems(SAA,SRDS/SMP,EMTS, GMTS, RTP and EPE is standalone) . It will make Payment Information visible to Wells Fargo’s Internal Operations Team. Testing included initiating the tests from SAA flowing to SMP/MTS and mapping Validation of Kafka Topic messages with Elastic Search data in Kibana and verification of data in Payment Tracker User Interface. ROLES AND RESPONSIBILITIES IN THE PROJECT
• Analyzed the business and participated in the requirement and functional specification review sessions.
• Developed Test Scenarios using Business requirements, Use Cases and Functional Design Documents
• Created test cases and executed using tool HP ALM.
• Understanding of mapping performed on Kafka topics and verifying it in Kibana and Payment Tracker UI.
• Insert test data for Fin Messages in database based on the test scenarios/use cases and verification of the same in Kafka Topics and Kibana UI based on mapping provided in Data Dictionary document.
• Insert test data through IBM Infrared 360 tool in Xml format for injecting the messages and verifying it in Kafka and Kibana UI.
• Validate APIs using POSTMAN.
• Validated User Stories on PT UI and Defect tracking in JIRA.
• Involved in daily Scrum meetings, Sprint planning, Retrospection.
• Verification of new features and bug fixes at all stages of the development and release process
• Report progress of the project to client lead and ensure timely delivery of the project.
Project Name: SWIFT Messaging Platform-1SRDS
Duration Mar.2019 TO June 2020
Location Chandler, Phoenix (US)
Client Wells Fargo Bank
Domain Banking (Testing Services)
Test Management/Other Tool ALM, JIRA, SOAP UI, Msg Injector, Oracle SQL Developer, IBM Infrared 360
PROJECT DESCRIPTION
1SRDS application is built to process messages received by SWIFT or sent to SWIFT. The purpose of this effort is to reduce the core SWIFT platform attack surface by externalizing business routing rules and thus reduce the reliance on SWIFT Alliance Access(SAA) vendor solution. In externalizing routing rules, the project will include the build out of a integration layer protecting core SWIFT, but that allows a non-technical support team to create, update, delete and manage SWIFT routing rules and messages with two-factor authentication and four eyes validation. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As a QA, analyzed the business and participated in the requirement and functional specification review sessions .
• Requirement gatherings from Business Analysts and Business Team.
• Developed Test Scenarios using Business requirements, Use Cases and Functional Design Documents
• Created test cases and executed using tool HP ALM.
• Mapped requirements and provided the Traceability matrix.
• Validated the SMP web portal and enhancements and verified database using SQL queries.
• REST API Endpoint testing .
• Validation of new features and Bug fixes at all stages of the development and release process
• Report progress of the project to client lead and ensure timely delivery of the project.
Project Name: SWIFT Recon Manager
Duration Nov.2018 TO Feb.2019
Location Chandler, Phoenix (US)
Client Wells Fargo Bank
Domain Banking (Testing Services)
Test Management Tool ALM
PROJECT DESCRIPTION
SWIFT Recon Manger application ensures Wells Fargo is not exposed to SWIFT message processing gaps that may exist, which could lead to a significant impact, both financial and reputational. The lack of reconcilement between the SWIFT and its back office interfaces has cause challenges to recover during the event(s).
The solution provided by this project eliminated payment process risks, included end to end reconcilement of transactions throughout the SWIFT message lifecycle, ensured messages are not altered in-flight and provided a real time data visualization/dashboard for operations. This application verifies Completeness and Accuracy by verifying every message in the source system set is also in the target system record set, and report any exceptions. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As a QA, analyzed the business and participated in the requirement and functional specification review sessions .
• Requirement gatherings from Business Analysts and Business Team.
• Developed Test Scenarios using Business requirements, Use Cases and Functional Design Documents
• Created test cases and executed using tool HP ALM.
• Mapped requirements and provided the Traceability matrix.
• Validated the SRM/Recon web portal and enhancements and verified database using SQL queries.
• Validation of Features and Bug fixes at all stages of the development and release process
• Report progress of the project to client lead and ensure timely delivery of the project.
Project Name: CMS – American Honda
Duration Nov. 2012 TO Jun. 2013
Location Torrance,CA (USA)
Client American Honda, USA
Domain Automobile
Test Management Tool ALM 11.0
PROJECT DESCRIPTION
NGT Content Management System is an HTML5 based application that allows user to author the content/message deliver to vehicle customer. These messages are delivered across three platforms of Web, mobile and Vehicle (Navi system).
ROLES AND RESPONSIBILITIES IN THE PROJECT
• Participated in requirements gathering meeting with the project team.
• Deliver application knowledge to offshore team & resolve the queries.
• Developed Test Plans and estimation for the testing efforts required
• Used ALM as the test repository for executing test cases and log defects.
• Mapping of requirements and providing the Traceability matrix.
• Involved in testing Web Application.
• Co-ordinate with BA for smooth delivery and to achieve the targets.
• Report progress of the project to client lead and ensure timely delivery of the project.
• Facilitate smooth and effective coordination with offshore team.
Project Name: TIE – Volvo
Duration Jun.2011 TO Apr.2012
Location Mumbai (IND)
Client Volvo Cars Corporation, Sweden
Domain Automobile (Testing Services)
Test Management Tool Quality Center 10.0
PROJECT DESCRIPTION
Technical Information Exchange (TIE) is a communication tool for discrepancy reporting, for vehicle and service products.
The goal for the TIE (Technical Information Exchange) is that it should be the preferred channel for VCC (Volvo Cars Corporation) to publish the Technical issue and journal to their SC (Service Centers) and through service centers to their Dealers worldwide in their local language.
ROLES AND RESPONSIBILITIES IN THE PROJECT
• As a Senior Consultant, involved in understanding requirements, system analysis and preparing Test plan documents.
• Mapping requirements and providing the Traceability matrix.
• Co-ordinate with front office team for smooth delivery and to achieve the targets.
• Testing the TIE web portals and enhancements.
• Developed Test Plans using Business requirements, Use Cases and Functional Design Documents
• Testing the Production defects/Hot tickets raised by customer support team.
• Report progress of the project to client lead and ensure timely delivery of the project.
• Executing the SQL commands to verify.
Project Name: New York Times – Ad Portal
Duration July 2009 – Dec 2010
Location NY (USA)
Client New York Times
Domain Media (Testing Services)
PROJECT DESCRIPTION
The NYT Ad portal enables placing orders for classified and display advertisements in print version of The New York Times newspaper. The Ad portal can be subdivided in to 5 applications: ATP, R1, R3, R4 and R5. ATP, R1, R5 and R4 applications are used to take the ads for the Classified Advertising and R3 application is used to take ads for the Display Advertising. Advertisers having contract with The New York Times use ATP and R4 and the Advertisers with no contract with The New York Times use either R1 or R5 for placing their ads. This project includes Application Enhancement, Infrastructure Software Support, and Strategic Support ROLES AND RESPONSIBILITIES IN THE PROJECT
• As an Onsite Coordinator, analyzed the business and participated in the requirement and functional specification review sessions
• Deliver application knowledge to offshore team & resolve the queries.
• Creation of the test Plan, test cases and test data for functional and GUI testing.
• Verified database via SQL commands to determine successful data transactions.
• Used Quality Center as the test repository for executing test cases and log defects.
• Interact with Users and Business Analysts to understand the requirements.
• Provide status reports & metrics on testing progress
• Performed validation in all inputs fields on the front end GUI. Tested the html links and navigation using the functional design document.
Project Name: SBO- Bill Payment
Duration Oct.2007 TO Feb.2008
Location Seattle (USA)
Client Washington Mutual Bank, USA
Domain Banking (Testing Services)
PROJECT DESCRIPTION
Bill Payment application is an interface from CBBS through AIS which was created to send and receive messages from BPW. This will allow customers to add and manage online Payees and to make payments to these Payees. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As an Onsite Coordinator, the major duties in the project involved coordination with Business Analyst for analysis of the requirements, knowledge transition to the team members
• Test execution, defect reporting and prioritization and to manage the life cycle of each defect reported in the testing phase.
• Mapping requirements and providing the Traceability matrix
• Created Test Plan for Bill Payment module.
• Prepared Test case estimations & Test strategy documents for projects.
• Used TOAD to execute SQL queries for database verification
• Used mainframe for validating the data in database
• Walkthrough of Test plans with Business Teams.
• Test case Execution and Bug tracking through QC.
Project Name: TRBO Redesign FPL
Duration Mar.2009 TO Apr.2009
Location Pune (India)
Client FPL, US
Horizontal Domain Energy and Utility (Testing Services) Test Management Tool QTP
PROJECT DESCRIPTION
FPL(Florida Power & Light Company) is a client of Cognizant under Energy and Utility domain. It’s a US Based power distribution organization with more than 4 million customers in US. The application (TRBO Redesign) is web based application for customer care representative. This application gives a systematic approach to representatives to log customer’s requests and issues. The technologies used in application are Java ASP SQL server. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As an Automation Tester, involved in developing automated test scripts using QTP 9.2 from Manual test cases.
• Developed and Debugged VB Script functions and fixed automation failures.
• Defect Reporting.
Project Name: HBOSS - Mortgages
Duration Nov.2008 TO Mar.2009
Location Pune (India)
Client HBOSS, UK
Domain Banking (Testing Services)
Test Management Tool QTP 9.2
PROJECT DESCRIPTION
Mortgage origination system is an application used by the Halifax, BoS and TMB brands that handles the initial sales interview and then manages the fulfillment processing through to completion whereupon the account is moved to Borrowers. Automation is developed for the different stages of the application from Pre-Offer till Full Offer. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As an Automation Tester, involved analyzing and Understanding the Application through Requirement Documents.
• Developed Automation test scripts using QTP 9.2
• Effective execution of the test scripts.
• Debugging VB Script functions and fixing automation failures.
• Defect Reporting.
Project Name: Wamu - CBBS
Duration Aug.2006 TO Nov.2008
Location Pune (India)
Client Washington Mutual Bank, USA
Horizontal Domain Banking (Testing Services)
Test Management Tool Quality Center and QTP
PROJECT DESCRIPTION
Commercial Capital Bank (CCB) brings an innovative and robust system called Framework to WaMu’s environment with the integration of the two Banks. The primary objective of testing is to validate the changes to support implementing Framework in the WAMU infrastructure. Various Bank functionalities such as (Wires/funds Transfer, ACH, Accounts, Billing, Contributions) are verified through a UI called as Custom Cash Management and Contribution Management. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As a Programmer Analyst, involved in gathering and understanding of requirements.
• Co-ordination of testing activities with onsite coordinator
• Preparing Test Cases and Test Scenarios.
• Test Case execution.
• Test Management and Updating test results in Quality Center
• Defect and Issue Reporting
• Defect Tracking and follow up
• Knowledge transition to new team member.
• Prepared automated test scripts using QTP 9.2
• Test planning and Development of automated scripts using “Descriptive programming” using QTP.
• Developed and Debugged VB Script functions and fixed automation failures.
• Involved in Script Tuning, Result Generation in HTML and Updating QC/Perforce.
• Execution of Test scripts.
Project Name: PolyPath Risk and Trading Reporting Duration Apr.2006 TO Jul.2006
Location Pune (India)
Client Washington Mutual Bank, USA
Horizontal Domain Banking (Testing Services)
Test Management Tool Test Director and QTP
PROJECT DESCRIPTION
The Risk and Trader Reporting tool consists of the Repo Cube, the DTS package to accommodate the Repo data, Report Comment functionality and new VaR cube logic and scrubbing logic. The Repo desk requires a view of the Repo position and Repo margins from the customer/counterparty and the product perspective. The reports provided a view of the underlying position for all Repo transactions done by the bank. The reports help the business to understand the underlying positions and margins based on activity and revaluation.
ROLES AND RESPONSIBILITIES IN THE PROJECT
• As a Programmer Analyst, involved in gathering and understanding of requirements.
• Co-ordination of testing activities with onsite coordinator
• Preparing Test Cases and Test Scenarios.
• Test Case execution.
• Test Management and Updating test results in Test Director
• Defect and Issue Reporting
• Defect Tracking and follow up
• Co-ordination of Testing activities with client
• Prepared PoC for Automation
Project Name: Financial Accounts - PoC for Automation Duration Feb.2006 TO Feb.2006
Location HYD (IND)
Client Ameriprise Financial, USA
Horizontal Domain Financial Services (Testing Services) Test Management Tool QTP 8.2
PROJECT DESCRIPTION
Financial Accounts provides a client portal that will evolve a single point of entry for a customer to access his/her Ameriprise accounts as well as accounts with third party institutions. It had multiple releases so was the application chosen for preparing the Proof of Concept for automation project. ROLES AND RESPONSIBILITIES IN THE PROJECT
• As an Automation Tester, developed a proof of concept for a module in Ameriprise application.
• Plan for automation.
• Prepared automated test scripts using QTP 8.2.
Other Projects
Project Duration Client Company
UBS (Union Bank of
Switzerland)
Jan. 2010 TO
Mar.2011
UBS, Zurich Cognizant Technology Solutions, Pune
One Merck May 2009 – June
2009
Merck, US Cognizant Technology Solutions, Pune
Client Snapshot - SAO UAT Mar 2006 Ameriprise Financial, USA Cognizant Technology Solutions, Hyderabad
Registration Tools Mar 2005-Jan
2006
Information Services, USA Cognizant Technology Solutions, Hyderabad
PROFESSIONAL QUALIFICATION
• Master of Computer Application, SMU, India, July 2008
• Bachelor of Science in Information Technology, Mumbai University, India, July 2004 PASSPORT AND VISA STATUS
• Nationality: Indian
• Current Passport (Place of Issue): Mumbai, India
• Current Visa Status: GC
• Current/Preferred Location: Lake Mary, Florida