際際滷

際際滷Share a Scribd company logo
KUMAR SAURABH AGRAWAL
E-Mail: saurabh.vnit11@gmail.com
Mobile No: +1 937 931 6235
Seeking for middle to senior level position in Software Testing with a leading organization in the IT
Sector.
Professional Snapshot
Key Deliverables:
Primary Skills: Mobile Testing on Android and iOS devices, Web based Manual & Automation Testing,
AS400 testing, Functional Testing, SQL
Testing Tools: Selenium IDE, Selenium Web driver  using python in Eclipse, Appium, Genymotion &
uiautomator, UFT (Formerly known as Quick Test Professionals QTP), vbscript, Robot Framework (Git HUB)
using RIDE, Exposure to SoapUI and Jenkins
Test Management Tools: HP ALM , Test Director/Quality Center (QC), JIRA, Zephr, Tarantula
Testing Methods: Agile Scrum Methodology, V-model, Waterfall model
Domain: Banking and Financial domain, Secured and Unsecured loans, Investment Banking, Healthcare
domain, insurance claims, Sales force
 More than 10.5 years of extensive experience in Software Testing for software application and
product development including around 4 years experience in Automation Testing  Quick Test Pro
(QTP) and close to one year Onsite experience.
 Working experience in performance testing using Microsoft Visual Studio (VSTS) 2010.
 Experience in Banking and Finance (BFSI) domain, Home Loans
 Experience in Healthcare Insurance domain
 Worked on Retail Banking Products, Web based applications like GEM, Hub Front End (HFE), CRMS,
2G & Compass and Client Server application AS400 IBM I-series.
 Experience in Investment Banking domain in Research and Strategy
 Worked on assignments which involved Global Event Management and its integration with Salesforce
application.
 3+ years hands on experience into Salesforce desktop, Tablet and Mobile testing.
 Experience into Web Services testing using SOAP UI tool.
 Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 for CVS Caremark
 Currently using agile scrum methodology - responsible for end to end deliverables including
Requirement Analysis, Sprint Planning Meeting, Test Plan and Review of scripts, Test execution,
Attending scrums, defect calls, preparation of different metrics, conducting retrospective meetings,
team mentoring etc.
 Used QTP10.0 to create test data for current GEM project.
 Used V-model and Waterfall models in couple of projects in HSBC using testing techniques 
Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Experience based
testing etc.
 Involved in Functional testing like Smoke testing, Sanity testing, SIT, UAT, Regression testing.
 Mainly worked on Core Banking domain, Loans and Payments side.
 Have got expertise in Database testing
 Good exposure on AS400 queries and SQL.
 Exposure to performance testing using Load Runner 9.5
 Working experience with GIT extension, Stash server and Jenkins machine.
 Working experience with Console, Confluence and Sharepoint.
 Gained considerable international exposure of working in places like London and Birmingham while
working on-site testing projects as Onsite Coordinator.
 Showed expertise in working on Application Life Cycle (ALM) HP Quality Center and Test Director
as Test Management Tool. Worked as local QC admin/TD admin.
 Experience of working closely with Development team and Business Analyst team.
 A team player with strong communication, analytical and organizational skills.
Certifications
 PMI  PMP certified professional.
 CSTE (Certification of Software Testing and Examination) certified tester securing more than
85% marks.
 Cleared ISTQB/ISEB Certification securing more than 80% marks.
 Cleared Oracle Database 11g: SQL Fundamentals1 (Exam Code: 1Z0-051) exam securing 100%
marks.
 Cleared QTP certification exam HP0-M47 HP Functional Testing 11.x Software securing 80%
marks.
Summary Graph
Academia
Completed B.E. from National Institute Of Technology (Formerly Visvesvaraya Regional College Of Engineering)
Nagpur in 2005. Secured 67.5%.
Completed Intermediate from U.P. Board in 2000. Secured 78.8%, topped at city level.
Completed High School from U.P. Board in 1998. Secured 82.67%, topped at district level.
Current Employer
Working as Agile QA Lead for ATTRA Inc at Synchrony Financials, New York city, NY, USA, since
March 2015 till date
Previous Employer
Jun14 to Feb15 with Nagarro Software Ind Pvt Ltd, Allentown, USA/Gurgaon, Ind as Lead
Nov11 to May14 with GalaxE Solutions (I) Pvt. Ltd. Noida as QA Lead.
June10 to Oct11 with RBS Development (I) Pvt. Ltd, Gurgaon as Test Engineer.
Aug05 to May10 with HSBC Software Development (I) Pvt. Ltd, Pune as Senior Software Engineer.
Roles and Responsibilities
Project Level:
 Carry out detailed requirements analysis, strategy and estimation
 Ensure tractability between requirements and test cases
 Prepare and maintain test-ware, conduct reviews of test-wares
 Participate in knowledge management activities
 Participate in defect prevention activities
 Collect and analyze test metrics
 Guide and support a team of test executors
 Do execution for complex functions
 Do QA on the testing done by test executors
 Understanding scope and requirements
 Produce Test Plan
 Test Case Writing/Test Script writing
 Customer facing
 Status Reporting
Team Level:
 Played role of Software Configuration Manager from Dec08 to Aug09 where used to upload all the
mandatory previous and current project documents in a central repository called Domdoc with the
correct version number as and when requested by the team members.
 Played role of Internal Quality Assurance from Mar08 to Jun08 in the team where ensured if all the
team members are following the correct project guidelines for eg using correct templates and are aware
of the overall project updates.
 Played role of Defect Prevention Champions from Jan07 to Jul07 in the team where consolidated all
defects raised by the team members and analyzed the cause for rejected defects and worked on to
prevent such rejections in future.
 Conducting knowledge sharing sessions on weekly basis
 Conducting One-to-One sessions on monthly basis with the team members and providing them
performance rating during Annual appraisal.
Business Unit Level:
 Member of Cultural committee for organizing events like Festival celebration, sports activities etc
 Part of recruitment panel to conduct interviews on weekdays/weekends.
 Part of award committee which identify and recognize the resources who perform well for the
Organization.
Accolades
 Received Spot Award for performing extremely well in the month Nov09.
 Received Long Service Award in Aug09 for working consecutive four years with HSBC Software (Ind)
Pvt Ltd.
 Received Certificate Of Recognition on the last project for consistently exceeding expectations.
 Received Quarterly Award For Going Extra Mile for performing excellent in 2007.
 Rated as performing constantly above expectation from the management
 Completed BrainBench Certification for Software Testing.
 Topped at city level in 12th
standard.
 Topped at the district level in 10th
standard.
 Was the university captain and champion of Chess
 Won several accolades in Debate, Paper presentation and Essay Writing.
Extra Curricular Activities:
 Won 3rd
prize in Paper presentation at national level in IIT Kharagpur on COMPOSITES in 2002.
 Was involved in organizing numerous activities in VNIT
 President of the Blood donation committee for one year. Successfully organized 2 donation camps in
year 2002-03.
 Organizing Committee member of Various technical and cultural festivals held at college level, like
Odyssey 2002,2003, Hostel -day , Janmashtami- 2001,2002,2003 etc.
Personal Details
Date of Birth: 01st
July 1983
Marital Status: Married
Hobbies: Solving puzzles, Playing Chess, Watching Cricket
Current Address: House number 1246, Urban state, Sector-21, Gurgaon, Haryana - 122002
Permanent Address: 74, Mehtan Street, Kathera Bazaar, Jwalapur, Haridwar, Uttrakhand  249407
Visa Status
H1B valid till Nov 2017
ANNEXURE
Project Details:
SyPi
Duration: Feb15  Till Date
Client: Synchrony Financial (A GE Company)
Testing Methodology: Agile Methodology
Role: Agile QA Lead
Location: Manhattan, New York
Responsibilities:
 Performing Android automation testing using Selenium python Client and Mentoring a team of manual
testers.
 Working with Eclipse, Selenium IDE, Web driver, Appium, Genymotion & uiautomator
 Attending Sprint planning meeting, Daily scrum, conducting Defect Triage meetings, conducting
applications demos and driving retrospective meetings.
 Interaction with Business
 Coordination with Offshore team/managers
Lutron Electronics
Duration: Jun14  Feb15
Client: Lutron
Technology: Keyword Driven Automation Testing
Database: SQL Server 2008
Tool: ROBOT Framework (RIDE)
Testing Methodology: Agile Scrum Methodology
Role: Test Manager
Responsibilities:
 Requirement gathering, Test Estimation, Kick Off meetings
 Identification of projects risks and mitigation plans
 Interaction with Business
 Preparation of Test Plan and review of Test Scenario/Test Scripts
 Writing complex automation scripts in ROBOT Framework (RIDE)
 Uploading latest code on Stash server via GIT extension and running code using Jenkins machine
 Review of automation scripts and check-in to Live environment.
 Application and Keyword bug reporting
 Working closely with the Manual team to understand system and to discuss defects
 Participate in knowledge management activities
 Daily Status Reporting (Conducting scrums)
Vender Transition Claims Migration from Recap to RxClaim
Client Billing and Reporting  CBR
EZ Test project.
Duration: Nov11  May14
Client: CVS CareMark  A healthcare company
Technology: AS400 Testing/ QTP Automation of EZtest web application
Database: DB2
Testing Methodology: Agile Scrum Methodology
Role: Test Manager
Responsibilities:
 Requirement gathering, Test Estimation, Kick Off meetings
 Identification of projects risks and mitigation plans
 Interaction with Business
 Preparation of Test Plan and review of Test Scenario/Test Scripts
 Test execution  SAT, SIT, Regression, Database Testing
 Adjudication of Manual Claims
 Testing of Automation process which migrates Claims from Recap to RxClaim system.
 Testing of existing EZtest claim processing tool
 Defect reporting
 Working closely with the Dev team to understand system and to discuss defects
 Participate in knowledge management activities
 Daily Status Reporting (Conducting scrums)
 Testing of Claim Extraction Taps (CETs)
 Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 as part of testing CETs
Global Event Management's integration with Salesforce
Duration: June10  Oct11
Client: RBS Bank
Technology: Manual/Automation Testing/Performance Testing (Web based Manual/ Automation testing using
Hybrid Framework/Performance testing using Visual Studio 2010), Database Testing
Database: SQL Server 2008
Testing Methodology: Agile Scrum Methodology
Role: Test Lead
Description: Gobal Event Management is a Java based front end web application which is used by Royal
Bank Of Scotland users to enable them to create Corporate/Institutions/Corporate
Group/Institution group roadshows where RBS plays the role of mediator and schedules
roadshows/meetings/events for Corporates/Institutions. Through this application, RBS also
maintains the logistics to pickup attendees from airport/station or any pickup point, providing
them accommodations and drop them till the meeting points. Accounts and Leads are created
in Salesforce and its integration with Global Event Management application is tested.
Responsibilities:
 Review of Test Scenario/Test Scripts
 Testing Saleforce and its integration with Global Event Management application.
 Creation of test data using QTP 10.0
 Test execution  SAT, SIT, Database Testing, Regression
 Performance testing using Microsoft Visual Studio.
 Defect reporting
 Interaction with BA team to understand business
 Working closely with the Dev team to understand system and to discuss defects
 Participate in knowledge management activities
 Daily Status Reporting (Conducting scrums)
 Web Services testing using SOAP UI tool
 Tablet and Mobile testing for Salesforce application.
Poland DBwB (Direct Banking with Branches)  LEVEL4 Project
Duration: Oct 09  May10
Client: HSBC Poland
Technology: Manual/Automation Testing (Web based testing, Database Testing and AS400 testing)
Database: DB2
Testing Methodology: V Model
Role: Lead Tester
Team Size: 6 (Handling a team of 4 resources offshore and 2 resources onshore)
Description: The objective of the project is to implement Advance Proposition in Poland in addition with less
emphasis on a branch network, and instead focus on selling HSBC products via direct channels.
The Advance proposition is part of a wider PFS Customer segment strategy, driven by a global
PFS initiative. The project would involve implementation of some local enhancements applicable
for the Poland site.
The following test items are being used:
 HUB  Screen Input / Enquiry / Batch Output.
 HFE2  Normal Teller functions, Demand Deposit, CRMS, Global Premier Marker
 AS400 Query/SQL Query  File Interrogation (Database Testing).
 Mercury QTP  Automation of HFE2 and Back end Test Scripts where applicable.
 Mercury Quality Center  Test Management & Defect Management Tool.
Responsibilities:
 Carry out detailed requirements analysis and estimation
 Producing Test Plan
 Ensure tractability between requirements and test cases
 Review of Test Scenario/Test Scripts
 Do execution for complex functions
 Providing assistance to QTP tester
 Assisting Manual testers in data staging, SQL etc.
 Defect reporting and attending defect calls
 Participate in knowledge management activities
 Participate in defect prevention activities
 Do QA on the testing done by test executors
 Customer facing (Interaction with Business, Overall IT Project Manager)
 Daily Status Reporting
CWD For Compass
Duration: Aug 08  Sep 09
Client: HSBC United Kingdom
Technology: Manual Testing (Web based testing and AS400 testing)
Database: Oracle
Testing Methodology: V Model
Role: Lead Tester
Team Size: 4 (all offshore)
Description: Compass is a front end based application which is used to create loan accounts. System needs
customers details like Bank details, Personal details, address, date of birth, employment
details, existing loan account details. Based on the details provided by the customer, bureau
decides customers eligibility in terms of score. This score will decide how much loan can be
disbursed to the customer. If customer and bank both are happy upto this point, system then
process customers request through the system, gets it approved via Compressive Banking
system, prints necessary documents and create loan account for the system.
Cashiering system is used to disburse loan amount to the customer via BACS process, once
disbursed, BACS file should get updated. CBS and GL reconciliation to be done after every
batch. Cashiering is also used to for different functions like Repayment, Settlement Letter, Loan
disbursement, Request Settlement letter. Cashier start and end of the day should be done & Till
and Cash balances should match at every end of the day.
Responsibilities:
 Carry out detailed requirements analysis
 Producing Test Plan
 Ensure tractability between requirements and test cases
 Test Scenario Writing/Test Script writing
 Guide and support a team of test executors
 Do execution for complex functions
 Defect reporting and attending defect calls
 Participate in knowledge management activities
 Participate in defect prevention activities
 Collect and analyze test metrics
 Do QA on the testing done by test executors
 Customer facing
 Status Reporting
Intraday MT942 Testing
Duration: Aug 07  Jul 08
Client: HSBC United Kingdom
Sites: Britain, Netherland, Belgium, Ireland, Spain
Technology: Manual Testing (AS400 testing)
Database: DB2
Testing Methodology: Waterfall Model
Responsibility: Onsite Coordinator & Test Analyst
Team Size: 5 (4 offshore and 1 onshore)
Description: Intraday MT942 message enables customer to see his/her intraday cash flows (in or out) done
on a particular account within the day. These messages can be generated either at a
predefined time or after every XX minutes.
The structure of the information in MT942 files is based on the SWIFT format. SWIFT
(Society for Worldwide Interbank Financial Telecommunication) is an international,
electronic communication network used by banks throughout the world for data
exchange. The SWIFT format is the universal standardized format that has been
developed for this purpose.
The file consists of one or more messages. Each message consists of a Message
Header, followed by an Interim Transaction Report (MT942), which in turn is followed
by a message trailer.
Testing of MT940/950 messages after batch.
Responsibilities:
 Carry out detailed requirements analysis, strategy and estimation
 Producing Test Plan
 Ensure tractability between requirements and test cases
 Test Scenario Writing/Test Script writing
 Guide and support a team of test executors
 Do execution for complex functions
 Defect reporting
 Participate in knowledge management activities
 Participate in defect prevention activities
 Collect and analyze test metrics
 Do QA on the testing done by test executors
 Customer facing
 Status Reporting
HUB Frontend 2.4
Duration: Jun 06  Jul 07
Client: HSBC United Kingdom
Technology: Manual Testing (Web based testing and AS400 testing) /Automation Testing (QTP using Data
driven framework)
Database: DB2
Testing Methodology: V Model
Responsibility: Test Analyst
Description: HFE 2.4 is the first deliverable on the HFE to R2 Roadmap. HFE 2.4 will migrate existing HFE
Teller and CRMS applications to an R2 front-end architecture. This includes migration from the
IBM WSBCC application framework to the Group standard Execution Services framework,
adoption of the Group Message Framework and integration with Group EAI (Enterprise
Application Integration) technology. The CRMS is a sales support system, developed to further
the Groups personal banking Wealth Management initiatives. This system is essentially a tool
for the Customer Service Representatives (CSRs) and Relationship Managers (RMs) to further
the Group's Wealth Management initiatives in the Personal Banking sector.
Customer Relationship Management System 3 (CRMS), which is aimed at the Customer Service
Representative (CSR) and Personal Financial Services representatives (PFSR), provides for
consolidated customer information, individual solutions, contact history, opportunity
management functions and sales and marketing data mart to facilitate analysis. Integration of
HFE 2.4 with Salesforce is tested.
HUB Frontend 2.3
Duration: Aug 05  May 06
Client: HSBC United Kingdom
Technology: Manual Testing (Web based testing and AS400 testing)
Database: DB2
Testing Methodology: V Model
Responsibility: Test Executor
Description: HFE 2.3 is the first deliverable on the HFE to R2 Roadmap. HFE 2.3 will migrate existing HFE
Teller and CRM applications to an R2 front-end architecture. This includes migration from the
IBM WSBCC application framework to the Group standard Execution Services framework,
adoption of the Group Message Framework and integration with Group EAI (Enterprise
Application Integration) technology.
The main deliverables for HFE are:
 Customer creation and maintenance of sole and joint relationships.
 Creation of customer profile in salesforce.
 Creation and maintenance of address, demographic, family, and contact preferences information for
new and existing HUB customers.
 Demand deposit account opening with optional links to associated services.
 All teller functions (deposit, withdraw, transfer, cheques, currency handling etc.)
 Term deposit account opening/maintenance.
 Payments (demand draft/telegraphic transfer/cashier's order)
 Loan/OD scoring via an interface to AAPS
 Back office transactions (inward remittance, salaries, inward clearing etc.)
 Remote approval of transactions via a Central Approval Repository (CAR).
 Peer approvals.
 Printing of pre-filled application forms for payment transactions (demand draft/telegraphic
transfer/cashier's order) and Term Deposit accounts.
 Consolidated customer advices printed on laser printers.
 Electronic Journal to enquire, reverse and re-print transaction confirmation advices.

More Related Content

Kumar Saurabh Agrawal

  • 1. KUMAR SAURABH AGRAWAL E-Mail: saurabh.vnit11@gmail.com Mobile No: +1 937 931 6235 Seeking for middle to senior level position in Software Testing with a leading organization in the IT Sector. Professional Snapshot Key Deliverables: Primary Skills: Mobile Testing on Android and iOS devices, Web based Manual & Automation Testing, AS400 testing, Functional Testing, SQL Testing Tools: Selenium IDE, Selenium Web driver using python in Eclipse, Appium, Genymotion & uiautomator, UFT (Formerly known as Quick Test Professionals QTP), vbscript, Robot Framework (Git HUB) using RIDE, Exposure to SoapUI and Jenkins Test Management Tools: HP ALM , Test Director/Quality Center (QC), JIRA, Zephr, Tarantula Testing Methods: Agile Scrum Methodology, V-model, Waterfall model Domain: Banking and Financial domain, Secured and Unsecured loans, Investment Banking, Healthcare domain, insurance claims, Sales force More than 10.5 years of extensive experience in Software Testing for software application and product development including around 4 years experience in Automation Testing Quick Test Pro (QTP) and close to one year Onsite experience. Working experience in performance testing using Microsoft Visual Studio (VSTS) 2010. Experience in Banking and Finance (BFSI) domain, Home Loans Experience in Healthcare Insurance domain Worked on Retail Banking Products, Web based applications like GEM, Hub Front End (HFE), CRMS, 2G & Compass and Client Server application AS400 IBM I-series. Experience in Investment Banking domain in Research and Strategy Worked on assignments which involved Global Event Management and its integration with Salesforce application. 3+ years hands on experience into Salesforce desktop, Tablet and Mobile testing. Experience into Web Services testing using SOAP UI tool. Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 for CVS Caremark Currently using agile scrum methodology - responsible for end to end deliverables including Requirement Analysis, Sprint Planning Meeting, Test Plan and Review of scripts, Test execution, Attending scrums, defect calls, preparation of different metrics, conducting retrospective meetings, team mentoring etc. Used QTP10.0 to create test data for current GEM project. Used V-model and Waterfall models in couple of projects in HSBC using testing techniques Equivalence Partitioning, Boundary Value Analysis, Error Guessing and Experience based testing etc. Involved in Functional testing like Smoke testing, Sanity testing, SIT, UAT, Regression testing. Mainly worked on Core Banking domain, Loans and Payments side.
  • 2. Have got expertise in Database testing Good exposure on AS400 queries and SQL. Exposure to performance testing using Load Runner 9.5 Working experience with GIT extension, Stash server and Jenkins machine. Working experience with Console, Confluence and Sharepoint. Gained considerable international exposure of working in places like London and Birmingham while working on-site testing projects as Onsite Coordinator. Showed expertise in working on Application Life Cycle (ALM) HP Quality Center and Test Director as Test Management Tool. Worked as local QC admin/TD admin. Experience of working closely with Development team and Business Analyst team. A team player with strong communication, analytical and organizational skills. Certifications PMI PMP certified professional. CSTE (Certification of Software Testing and Examination) certified tester securing more than 85% marks. Cleared ISTQB/ISEB Certification securing more than 80% marks. Cleared Oracle Database 11g: SQL Fundamentals1 (Exam Code: 1Z0-051) exam securing 100% marks. Cleared QTP certification exam HP0-M47 HP Functional Testing 11.x Software securing 80% marks. Summary Graph
  • 3. Academia Completed B.E. from National Institute Of Technology (Formerly Visvesvaraya Regional College Of Engineering) Nagpur in 2005. Secured 67.5%. Completed Intermediate from U.P. Board in 2000. Secured 78.8%, topped at city level. Completed High School from U.P. Board in 1998. Secured 82.67%, topped at district level. Current Employer Working as Agile QA Lead for ATTRA Inc at Synchrony Financials, New York city, NY, USA, since March 2015 till date Previous Employer Jun14 to Feb15 with Nagarro Software Ind Pvt Ltd, Allentown, USA/Gurgaon, Ind as Lead Nov11 to May14 with GalaxE Solutions (I) Pvt. Ltd. Noida as QA Lead. June10 to Oct11 with RBS Development (I) Pvt. Ltd, Gurgaon as Test Engineer. Aug05 to May10 with HSBC Software Development (I) Pvt. Ltd, Pune as Senior Software Engineer. Roles and Responsibilities Project Level: Carry out detailed requirements analysis, strategy and estimation Ensure tractability between requirements and test cases Prepare and maintain test-ware, conduct reviews of test-wares Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Guide and support a team of test executors Do execution for complex functions Do QA on the testing done by test executors Understanding scope and requirements Produce Test Plan Test Case Writing/Test Script writing
  • 4. Customer facing Status Reporting Team Level: Played role of Software Configuration Manager from Dec08 to Aug09 where used to upload all the mandatory previous and current project documents in a central repository called Domdoc with the correct version number as and when requested by the team members. Played role of Internal Quality Assurance from Mar08 to Jun08 in the team where ensured if all the team members are following the correct project guidelines for eg using correct templates and are aware of the overall project updates. Played role of Defect Prevention Champions from Jan07 to Jul07 in the team where consolidated all defects raised by the team members and analyzed the cause for rejected defects and worked on to prevent such rejections in future. Conducting knowledge sharing sessions on weekly basis Conducting One-to-One sessions on monthly basis with the team members and providing them performance rating during Annual appraisal. Business Unit Level: Member of Cultural committee for organizing events like Festival celebration, sports activities etc Part of recruitment panel to conduct interviews on weekdays/weekends. Part of award committee which identify and recognize the resources who perform well for the Organization. Accolades Received Spot Award for performing extremely well in the month Nov09. Received Long Service Award in Aug09 for working consecutive four years with HSBC Software (Ind) Pvt Ltd. Received Certificate Of Recognition on the last project for consistently exceeding expectations. Received Quarterly Award For Going Extra Mile for performing excellent in 2007. Rated as performing constantly above expectation from the management Completed BrainBench Certification for Software Testing. Topped at city level in 12th standard. Topped at the district level in 10th standard. Was the university captain and champion of Chess Won several accolades in Debate, Paper presentation and Essay Writing. Extra Curricular Activities: Won 3rd prize in Paper presentation at national level in IIT Kharagpur on COMPOSITES in 2002. Was involved in organizing numerous activities in VNIT President of the Blood donation committee for one year. Successfully organized 2 donation camps in year 2002-03. Organizing Committee member of Various technical and cultural festivals held at college level, like Odyssey 2002,2003, Hostel -day , Janmashtami- 2001,2002,2003 etc. Personal Details Date of Birth: 01st July 1983 Marital Status: Married Hobbies: Solving puzzles, Playing Chess, Watching Cricket Current Address: House number 1246, Urban state, Sector-21, Gurgaon, Haryana - 122002 Permanent Address: 74, Mehtan Street, Kathera Bazaar, Jwalapur, Haridwar, Uttrakhand 249407
  • 5. Visa Status H1B valid till Nov 2017
  • 6. ANNEXURE Project Details: SyPi Duration: Feb15 Till Date Client: Synchrony Financial (A GE Company) Testing Methodology: Agile Methodology Role: Agile QA Lead Location: Manhattan, New York Responsibilities: Performing Android automation testing using Selenium python Client and Mentoring a team of manual testers. Working with Eclipse, Selenium IDE, Web driver, Appium, Genymotion & uiautomator Attending Sprint planning meeting, Daily scrum, conducting Defect Triage meetings, conducting applications demos and driving retrospective meetings. Interaction with Business Coordination with Offshore team/managers Lutron Electronics Duration: Jun14 Feb15 Client: Lutron Technology: Keyword Driven Automation Testing Database: SQL Server 2008 Tool: ROBOT Framework (RIDE) Testing Methodology: Agile Scrum Methodology Role: Test Manager Responsibilities: Requirement gathering, Test Estimation, Kick Off meetings Identification of projects risks and mitigation plans Interaction with Business Preparation of Test Plan and review of Test Scenario/Test Scripts Writing complex automation scripts in ROBOT Framework (RIDE) Uploading latest code on Stash server via GIT extension and running code using Jenkins machine Review of automation scripts and check-in to Live environment. Application and Keyword bug reporting Working closely with the Manual team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Vender Transition Claims Migration from Recap to RxClaim Client Billing and Reporting CBR EZ Test project. Duration: Nov11 May14 Client: CVS CareMark A healthcare company Technology: AS400 Testing/ QTP Automation of EZtest web application Database: DB2 Testing Methodology: Agile Scrum Methodology Role: Test Manager Responsibilities: Requirement gathering, Test Estimation, Kick Off meetings Identification of projects risks and mitigation plans
  • 7. Interaction with Business Preparation of Test Plan and review of Test Scenario/Test Scripts Test execution SAT, SIT, Regression, Database Testing Adjudication of Manual Claims Testing of Automation process which migrates Claims from Recap to RxClaim system. Testing of existing EZtest claim processing tool Defect reporting Working closely with the Dev team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Testing of Claim Extraction Taps (CETs) Generating and Testing financial reports like APCL1013, APCL2016, APCL2021 as part of testing CETs Global Event Management's integration with Salesforce Duration: June10 Oct11 Client: RBS Bank Technology: Manual/Automation Testing/Performance Testing (Web based Manual/ Automation testing using Hybrid Framework/Performance testing using Visual Studio 2010), Database Testing Database: SQL Server 2008 Testing Methodology: Agile Scrum Methodology Role: Test Lead Description: Gobal Event Management is a Java based front end web application which is used by Royal Bank Of Scotland users to enable them to create Corporate/Institutions/Corporate Group/Institution group roadshows where RBS plays the role of mediator and schedules roadshows/meetings/events for Corporates/Institutions. Through this application, RBS also maintains the logistics to pickup attendees from airport/station or any pickup point, providing them accommodations and drop them till the meeting points. Accounts and Leads are created in Salesforce and its integration with Global Event Management application is tested. Responsibilities: Review of Test Scenario/Test Scripts Testing Saleforce and its integration with Global Event Management application. Creation of test data using QTP 10.0 Test execution SAT, SIT, Database Testing, Regression Performance testing using Microsoft Visual Studio. Defect reporting Interaction with BA team to understand business Working closely with the Dev team to understand system and to discuss defects Participate in knowledge management activities Daily Status Reporting (Conducting scrums) Web Services testing using SOAP UI tool Tablet and Mobile testing for Salesforce application. Poland DBwB (Direct Banking with Branches) LEVEL4 Project Duration: Oct 09 May10 Client: HSBC Poland Technology: Manual/Automation Testing (Web based testing, Database Testing and AS400 testing) Database: DB2 Testing Methodology: V Model Role: Lead Tester Team Size: 6 (Handling a team of 4 resources offshore and 2 resources onshore) Description: The objective of the project is to implement Advance Proposition in Poland in addition with less emphasis on a branch network, and instead focus on selling HSBC products via direct channels. The Advance proposition is part of a wider PFS Customer segment strategy, driven by a global
  • 8. PFS initiative. The project would involve implementation of some local enhancements applicable for the Poland site. The following test items are being used: HUB Screen Input / Enquiry / Batch Output. HFE2 Normal Teller functions, Demand Deposit, CRMS, Global Premier Marker AS400 Query/SQL Query File Interrogation (Database Testing). Mercury QTP Automation of HFE2 and Back end Test Scripts where applicable. Mercury Quality Center Test Management & Defect Management Tool. Responsibilities: Carry out detailed requirements analysis and estimation Producing Test Plan Ensure tractability between requirements and test cases Review of Test Scenario/Test Scripts Do execution for complex functions Providing assistance to QTP tester Assisting Manual testers in data staging, SQL etc. Defect reporting and attending defect calls Participate in knowledge management activities Participate in defect prevention activities Do QA on the testing done by test executors Customer facing (Interaction with Business, Overall IT Project Manager) Daily Status Reporting CWD For Compass Duration: Aug 08 Sep 09 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) Database: Oracle Testing Methodology: V Model Role: Lead Tester Team Size: 4 (all offshore) Description: Compass is a front end based application which is used to create loan accounts. System needs customers details like Bank details, Personal details, address, date of birth, employment details, existing loan account details. Based on the details provided by the customer, bureau decides customers eligibility in terms of score. This score will decide how much loan can be disbursed to the customer. If customer and bank both are happy upto this point, system then process customers request through the system, gets it approved via Compressive Banking system, prints necessary documents and create loan account for the system. Cashiering system is used to disburse loan amount to the customer via BACS process, once disbursed, BACS file should get updated. CBS and GL reconciliation to be done after every batch. Cashiering is also used to for different functions like Repayment, Settlement Letter, Loan disbursement, Request Settlement letter. Cashier start and end of the day should be done & Till and Cash balances should match at every end of the day. Responsibilities: Carry out detailed requirements analysis Producing Test Plan Ensure tractability between requirements and test cases Test Scenario Writing/Test Script writing Guide and support a team of test executors Do execution for complex functions Defect reporting and attending defect calls
  • 9. Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Do QA on the testing done by test executors Customer facing Status Reporting Intraday MT942 Testing Duration: Aug 07 Jul 08 Client: HSBC United Kingdom Sites: Britain, Netherland, Belgium, Ireland, Spain Technology: Manual Testing (AS400 testing) Database: DB2 Testing Methodology: Waterfall Model Responsibility: Onsite Coordinator & Test Analyst Team Size: 5 (4 offshore and 1 onshore) Description: Intraday MT942 message enables customer to see his/her intraday cash flows (in or out) done on a particular account within the day. These messages can be generated either at a predefined time or after every XX minutes. The structure of the information in MT942 files is based on the SWIFT format. SWIFT (Society for Worldwide Interbank Financial Telecommunication) is an international, electronic communication network used by banks throughout the world for data exchange. The SWIFT format is the universal standardized format that has been developed for this purpose. The file consists of one or more messages. Each message consists of a Message Header, followed by an Interim Transaction Report (MT942), which in turn is followed by a message trailer. Testing of MT940/950 messages after batch. Responsibilities: Carry out detailed requirements analysis, strategy and estimation Producing Test Plan Ensure tractability between requirements and test cases Test Scenario Writing/Test Script writing Guide and support a team of test executors Do execution for complex functions Defect reporting Participate in knowledge management activities Participate in defect prevention activities Collect and analyze test metrics Do QA on the testing done by test executors Customer facing Status Reporting HUB Frontend 2.4 Duration: Jun 06 Jul 07 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) /Automation Testing (QTP using Data driven framework) Database: DB2 Testing Methodology: V Model
  • 10. Responsibility: Test Analyst Description: HFE 2.4 is the first deliverable on the HFE to R2 Roadmap. HFE 2.4 will migrate existing HFE Teller and CRMS applications to an R2 front-end architecture. This includes migration from the IBM WSBCC application framework to the Group standard Execution Services framework, adoption of the Group Message Framework and integration with Group EAI (Enterprise Application Integration) technology. The CRMS is a sales support system, developed to further the Groups personal banking Wealth Management initiatives. This system is essentially a tool for the Customer Service Representatives (CSRs) and Relationship Managers (RMs) to further the Group's Wealth Management initiatives in the Personal Banking sector. Customer Relationship Management System 3 (CRMS), which is aimed at the Customer Service Representative (CSR) and Personal Financial Services representatives (PFSR), provides for consolidated customer information, individual solutions, contact history, opportunity management functions and sales and marketing data mart to facilitate analysis. Integration of HFE 2.4 with Salesforce is tested. HUB Frontend 2.3 Duration: Aug 05 May 06 Client: HSBC United Kingdom Technology: Manual Testing (Web based testing and AS400 testing) Database: DB2 Testing Methodology: V Model Responsibility: Test Executor Description: HFE 2.3 is the first deliverable on the HFE to R2 Roadmap. HFE 2.3 will migrate existing HFE Teller and CRM applications to an R2 front-end architecture. This includes migration from the IBM WSBCC application framework to the Group standard Execution Services framework, adoption of the Group Message Framework and integration with Group EAI (Enterprise Application Integration) technology. The main deliverables for HFE are: Customer creation and maintenance of sole and joint relationships. Creation of customer profile in salesforce. Creation and maintenance of address, demographic, family, and contact preferences information for new and existing HUB customers. Demand deposit account opening with optional links to associated services. All teller functions (deposit, withdraw, transfer, cheques, currency handling etc.) Term deposit account opening/maintenance. Payments (demand draft/telegraphic transfer/cashier's order) Loan/OD scoring via an interface to AAPS Back office transactions (inward remittance, salaries, inward clearing etc.) Remote approval of transactions via a Central Approval Repository (CAR). Peer approvals. Printing of pre-filled application forms for payment transactions (demand draft/telegraphic transfer/cashier's order) and Term Deposit accounts. Consolidated customer advices printed on laser printers. Electronic Journal to enquire, reverse and re-print transaction confirmation advices.