Test Cases Project
Resume:
Sarabjeet Singh
Phone: +1-416-***-****
ac1h1s@r.postjobfree.com
SUMMARY OF EXPERIENCE (November 2007 – Till Date)
** ***** ** ** ********** with relevant experience of QA as 9+ years.
Experience in different phases of the Project Management Life Cycle (PMLC), System Development Lifecycle (SDLC) which includes Requirement gathering, Testing and Production Support
Certified ISTQB Tester at Foundation Level.
Experienced professional with over 6 years in the banking industry (Retail, Wealth, Commercial and Capital Markets).
9 years of experience in working with all the testing concept, Software Methodologies including Agile, Waterfall and V-Model.
Proficiency in testing Client Server and Web based applications using Manual testing techniques and Automation tool.
Experience in interacting with BAT/UAT (Business Acceptance/unit Acceptance Testing), Business Analysts, Developers, and Technical Support to help them base line the requirement specifications.
Automation tools used are Selenium, SOAPUI, READY API, Jmeter and QTP.
Database tool i.e. AQT, IBM DB2 and My SQL are used.
Experience in testing web services (SOAP, XML, WSDL) and web based applications.
Experience in conducting different types of Non Functional and Black Box testing including Business Workflow, GUI, Data Driven, Database, Regression, Functional, User Acceptance (UAT) and System Testing.
Defect tracking tools used are HP ALM, JIRA and HP QC.
Advance Knowledge of MS Excel and other Microsoft products including Word, PowerPoint, Access, Visio, MS Project.
Self-motivated and willing to work with minimal Supervision
Strong communication, presentation, and documentation skills
Resourceful and flexible leader and coordinator in fast-paced, time-critical systems and project environments.
WORK EXPERIENCE
AUTOMATION QA LEAD
Bank of Montreal - Toronto, ON
March 2013 to Present
PROJECTS: CUSTOMER 360, OSFI-J, FATCA, CASL
PROJECT DESCRIPTION
CUSTOMER 360 is the holistic view of records for Customer at Enterprise Level. This project involve ETL Testing. Record comes from Source as per Party 360 Layout and SIF Mapping layout was defined for each source. IDP does L3 testing and ETL rules were tested.
FATCA (Foreign Account Tax Compliance Act) project determined the US Indicia for US Customer. US Customer was determined on certain parameters such as US Address, US Citizenship, US Phone, R/A Attestation and so. Source send the file as per Party 360 layout and loaded the data in MDM through SIF Mapping. This project involve ETL and MDM Testing
OSFI J(Office of Superintendent Financial Institution) project deals with Non Customer Cash Transactor. Non Customer doesn't have any account with BMO. This testing involve batch and real time testing.
Testing of CASL(Canada's Anti Spam Legislation) project Rules were implemented which involve testing of Email with preferences. Subscribed user should receive Promo Offers Email and Unsubscribe user should not.
Roles & Responsibilities:
Performed User Acceptance testing, System testing, System Integration testing, Functional Testing, Database testing and Regression testing.
Prepared Test Plan, Test cases, Bug Tracking, Logging and reporting bugs using HP ALM.
Work in Agile Environment, attends Triage Call, Stand Up Meetings.
Assign and manage the task to offshore team. Organized meetings for offshore task reporting and concerns if any. Reports have been created for assigned task and matches with Test Estimate Effort.
Used Selenium Web driver 3 for creating and executing test scripts for functionality testing of the web application (Application under test).
Created Selenium automation scripts using Java to perform Integration and System Testing for application product suite for MDM.
Automating scripts for Selenium in Python and Java both.
Used SOAPUI Pro for creating Automated scripts for Web Services. These automated scripts were used during Regression and testing in different environment.
Understanding and Analyzing the Requirements, Functional Specifications.
Web Services are tested for real time to Add, Update, Get or Search Party (Customer). There were other functionalities also such as Adding, Updating or Retrieving Preferences, Adding Contract details and so on.
Testing of CASL(Canada's Anti Spam Legislation) project Rules were implemented which involve testing of Email with preferences. Subscribed user should receive Promo Offers Email and Unsubscribe user should not.
Executing ETL batch jobs, Output Extracts, DBI jobs, Remediation and Conversion jobs.
For testing of FATCA(Foreign Account Tax Compliance Act) project, US Indicia was tested for US Customer and US Customers was determined on certain parameters such as US Address, US Citizenship, US Phone and so ons
Validate all the Customer data exist in MDM Database.
Prepare traceability matrix with the requirements of the project and map them to the test cases designed.
SQL Data base testing for proper insertion, updating and fetching of the records. Use Advance and Complex queries using AQT tool.
Run the UNIX commands to execute Batch load file.
Prepared test cases, functional specifications, use cases and Automation testing using Selenium WebDriver 2.0
Conducted system testing for applications to ensure requirements are met and defects are managed.
Extensively interacted with developers to analyze and resolve the issues that were encountered while testing the application.
Managed testing tasks concurrently on multiple projects.
Reporting Daily Status Reports to the Client Manager.
Enhanced the test scripts through Check Points and Parameterization
Participated in everyday standup meetings to discuss the issues arising out of testing.
Involved in writing of modification reports for errors identified in testing and clearly communicated with development via defect tracking system.
Communicated vision, plans, status, issues and activities to all levels, from individual contributors up to senior management.
SENIOR QA ANALYST
CITI USA
April 2012 to February 2013
PROJECT : RTCC EVENT CLOUD
PROJECT DESCRIPTION
RTCC is Real Time Customer Connection project where Customer Data was created and updated using Real time services. RTCC testing was Middleware testing where all the services were tested and verified the schema structure with data.
Roles & Responsibilities:
RTCC is Real Time Customer Connection project where Customer Data was created and updated using Real time services.
Performed Functional Testing including Regression Testing, UAT Testing, End-To-End Testing and Non-Functional(GUI) Testing adhering iterative release cycle(Sprint) in Agile Methodology.
Tested Real time services using SOAPUI and Groovy script was created for Automation.
WSDL was imported using SOAP UI and Automated Scripts were created. These automated scripts were used during Regression and testing in different environment.
JIRA tool was used for reporting and logging defects.
Accurately reported derivative's daily P&L, and analyzed MTM movement.
Performed User acceptance testing (UAT) testing with Business Users.
Organize the status meetings and send the Status Report of testing activities like testing results, test case coverage, required resources, defects discovered and their status (Daily, Weekly) to the Client.
Used Jmeter to test web services host on EMS Server.
Test Risk were defined during Test Plan and Mitigated also.
WINSCP was used as an Interface between UNIX Machine and local System.
Validate the SOAPUI response and all the attribute value should exist in MDM DB in their respective tables and column using AQT tool.
Involved in writing of modification reports for errors identified in testing and clearly communicated with development via defect tracking system.
Developed and executed test strategies, plans, test scripts and test cases as well as supported business users during User Acceptance Testing (UAT) phase.
Prepare traceability matrix with the requirements of the project and map them to the test cases designed.
SQL Data base testing for proper insertion, updating and fetching of the records. Use Advance and Complex queries using AQT tool.
Attended meeting of project requirement analysis and project retrospective meeting to interact with PM, BA, development team and QA team.
QA ANALYST
OMNICARE USA
July 2011 to April 2012
PROJECTS : CLAIMS 2 WORK
PROJECT DESCRIPTION
OMNICARE Project is of HealthCare Domain which feature services such as Maintaining History of Record for Customer with real time, Insurance details, efficient administration of medications, complete infusion therapy service and so on. Services testing was performed using QTP tool.
Roles & Responsibilities:
Development of data driven framework of web based SmartFolio application using Quick Test Professional (QTP11)
Maintenance and Development of Oracle forms application using Unified Functional Testing (UFT 12)
Execution of framework integrated with HP QC using QTP.
Preparation & Execution of Manual Test Cases in QC.
HP Quality Centre for raising and closing defects.
Used HP ALM to report and log defects.
Created System Test Plan which outlines Scope, Objective, Focus and Approach of the testing effort for this particular project
Implemented and tested the application with Agile Methodology for overall software test strategy and approach, project schedules, issue management, estimations and risk assessment
Performed Black Box testing which includes System Integration (SIT), User Acceptance (UAT), Regression, Functional, Positive and Negative Testing.
Involved in writing of modification reports for errors identified in testing and clearly communicated with development via defect tracking system.
Developed and executed test strategies, plans, test scripts and test cases as well as supported business users during User Acceptance Testing (UAT) phase.
Prepare traceability matrix with the requirements of the project and map them to the test cases designed.
SOFTWARE TESTER ENGINEER
VODAFONE - ITALY-SPAIN
April 2010 to June 2011
PROJECTS: VODAFONE
PROJECT DESCRIPTION
VODAFONE-ITALY SPAIN is of Tele Communication project. This project involve production support and performance testing.
Roles & Responsibilities:
Coordinated non-functional testing such as Performance Testing, Installation & Back-out, Fail-over and Network testing and reviewed the results.
Prepared Test Plan, Test cases, Bug Tracking, Logging and reporting bugs using HP QC
Preparing the test cases for non-functional testing
HP QC was used for defect tracking and logging.
Executing, monitoring and analyzing Performance Tests.
Providing input from a testing perspective to the delivery release roadmap and project schedule plan, capacity, and deployment to production schedule.
SOFTWARE ENGINEER
LARSEN AND TOUBRO
November 2007 to April 2010
PROJECTS: ESTABLISHMENT MANAGEMENT SYSTEM, CITI-CI(CREDIT INITIATION)
Roles & Responsibilities:
Created Test Cases and Test Scripts based on the business requirements and reviewed with other team associates.
Performed cross browser compatibility testing to check the compatibility of the application under test with different browsers.
Performed Functional testing by executing test scenarios & test cases and validate the results at SQL Server database using SQL queries.
Supported Test Lead in preparing periodic status reports.
Involved in performing system testing, unit testing, back-end testing, end-to-end testing, and integration testing in every release.
Conducted system Integration testing in the system test environment to detect defects, end-to-end testing to ensure conformance with the requirements prior to code migration to UAT.
Executed Regression Test of operational releases
Mapped the test data to a specific test case for execution purpose.
Actively participated in Enhancement meetings focused on making the application more effective.
Defect Reporting using bug tracking tool such as HP QC.
CERTIFICATION
ISTQB (International Software Testing Quality Board) Certified at Foundation Level
Banking Domain Certification of National Certification in Financial Market
EDUCATION
Bachelor of Degree in Electronics and Communication
Contact this candidate