We provide IT Staff Augmentation Services!

Quality Analyst Resume

SUMMARY

  • Wealth Management - Securities Instrument Master, Equities & Fixed Income, MF, IPO, OTC Options, ETD, Security Transfer, Position Transfer, Syfxforwards, Accumulator- Decumulator, DCI, & Corporate Action’s
  • Experience in Tosca Automation suite, Selenium Web Driver - Java- Hybrid Framework, API Testing
  • Gherkin Language - BDD
  • I have sound knowledge and good experience on ETL - Data Integration, Data Migration testing.
  • Experience in writing complex MySQL, Oracle queries including calling stored procedures by passing parameters, functions using MySQL and Oracle Toad as development tools.
  • Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.
  • Expertise in Data Warehouse Testing, ETL Verification, BI reports
  • Retail Bank - CIF, CASA, Teller, Deposits, Payments, Swift Messages (102,103,202,192,292,195,196,199), Safe Deposit
  • Channels - ATM, IVR/Phone Banking/Call Centre
  • Loans(LOS & LMS) - Auto & Real Estate Products, Inventory & Purchase, Invoices & Payments, Vehicle Return & Repossession, Tender & Auction Process, Suppliers/Dealers Maintenance, Write Off
  • Alerts, Black list Management, Anti-Money Laundering (AML) Test Data Preparation
  • Insurance (Life & General) - Motor Insurance, Home Insurance, Personal Accident Insurance, Agency Management
  • Demonstrated abilities inRequirements Management, Test Planning, Test Execution, Test Analysis, Test Estimates, Defect Management and Test Closure.
  • Experience in waterfall and agile software development model for the QA activities.
  • Worked extensively on User Acceptance and System Integration Testing
  • Managed onshore and multi-shore delivery engagements comprising 6+ member teams with a major focus on requirements gathering, scope definition, test planning, test design review and execution, defect management & test closure .
  • Possessing strong interpersonal and analytical skills and comes with the experience of working in multicultural client environments across APAC, UK, United Arab Emirates and India.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows

Database: Oracle DB, SQL Server

Programming: MySQL, Oracle

Data warehouse Tool: Informatica 9.1(ETL)

Automation: Tosca Automation Suite, Selenium Web driver - Java

Automation Framework: Hybrid, Keyword & Data Driven Framework

BDD: Cucumber

Reporting Tool: SAP Business Intelligence - Tyconz

Defect Management Tools: Quality Centre V10, JIRA, SPIRA

PROFESSIONAL EXPERIENCE

Confidential

Quality Analyst

Responsibilities:

  • Requirement Gathering & Validating the requirement with finding gaps
  • Data Integration Testing from Satellite System -T24 - Database- Satellite Systems
  • Product data flow validation on these contracts - Securities Instrument Master, Equities, Bonds, MF, IPO, OTC Options, ETD, Security Transfer, Position Transfer, Syfxforwards, Accumulator-Decumulator, DCI, & Corporate Action’s
  • Prepared Test Approach - Entry & Exit Criteria for T24 - Staging & ODS ETL testing
  • Prepare / Review the Test Cases document.
  • Created test scripts using Tosca Automation
  • Mapping-Tosca Requirements,
  • Creating -Tosca Test Sheet, Tosca Test Cases, Tosca Module for page source identification
  • Tosca Execution, Tosca Reporting
  • Execute/Run the scripts.
  • Involving the framework development.
  • Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.
  • Tested the ETL mappings from Source to Target.
  • Testing ETL Logic from Staging, ODS, Data cache Environment using MySQL scripts
  • Testing Slowly changing Dimension type 1,2,3 logic using scripts
  • Tested Real Time data & EOD data with multi country requirement
  • Validating XML data by parsing it and comparing it against staging table History data.
  • Validating the dimensional and Facts data against the Staging data tables as per the business and Functional Requirements
  • Managed team of 4 members & allocating day today tasks.
  • Preparing DSR

Environment: T24 - R14, JIRA, Tosca Automation, MySQL Toad, Staging RT, ODS RT, STG EOD, ODS EOD Environment

Confidential

Associate Test Lead

Responsibilities:

  • Requirement Gathering & Validating the requirement with finding gaps
  • Check / Review the Test Cases document.
  • Involved in Identifying and Creating the Business component & Generic Scripts.
  • Involved in Identifying the E2E scenario & Creating the Reusable methods, Generic methods & Page Factory.
  • Created test scripts using Web driver.
  • Developed new scripts for the regression and sanity testing
  • Execute/Run the scripts.
  • Involving the framework development.
  • Prepared and executed batch test suite through TestNG via Jenkins
  • To run the parallel execution using TestNG
  • Extracted reports data from T24 system using SQL queries with Oracle Toad
  • Validating XML data by parsing it and comparing it against staging table History data.
  • Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.
  • Validating the BO reports by running it against the Dimension area to ensure the BO reports data are matching the End Business Customers need
  • Managed team of 4 members & allocating day today tasks.
  • Prepared DSR

Environment: T24 - R14, Tyconz SAP Reports, Quality Center V11, Selenium Web driver, Cucumber

Confidential

Associate Test Lead

Responsibilities:

  • Requirement Gathering & Validating the requirement with finding gaps
  • Check / Review the Test Cases document.
  • Prepared Test Execution Plan
  • Involved in Identifying the E2E scenario & Creating the Reusable methods, Generic methods & Page Factory.
  • Created test scripts using Web driver.
  • Execute/Run the scripts.
  • Involving the framework development.
  • Prepared and executed batch test suite through TestNG via Jenkins
  • To run the parallel execution using TestNG
  • Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.
  • Validating the T24 ETL reports
  • Managed team of 6 members & allocating day today tasks.
  • Prepared COB plan
  • Subject matter expert on Banking Interface Systems & Liability module
  • Prepared DSR

Environment: T24 - R13, ATM - BASE24, IVR - BTC, Phone Banking - T24, Quality Center V11

Confidential

Test Analyst

Responsibilities:

  • Requirement Gathering & Validating the requirement
  • Interacting with clients to crystallize the test requirements.
  • Prepared Test Plan for Loans - Inventory & Purchase project
  • Write / Reviewing the Test Cases document.
  • Arrange the hardware and software requirement for the Test Setup.
  • Carried out System Integration Testing & User Acceptance Testing
  • Was the Single Point of Contact (SPOC) between the client business and testing teams and also between internal client testing team
  • Trained bank business user on UAT and successfully implemented Inventory and Purchase system
  • Prepared the DSR
  • Prepared Test Closure Report

Confidential

Senior Test Engineer

Responsibilities:

  • Understanding the Requirements and raising clarification documents
  • Preparing the Product Matrix & Traceability Matrix
  • Preparing & Reviewing of High level Scenarios/Test Conditions/ Test Cases /Test Data preparation/ Logical run plan
  • Test Execution & Defect Reporting
  • Trained bank business user on application flow and usage
  • Prepared DSR

Confidential

Senior Test Engineer

Responsibilities:

  • Understanding the Requirements and raising clarification documents
  • Preparing the Product Matrix & Traceability Matrix
  • Preparing & Reviewing of High level Scenarios/Test Conditions/ Test Cases /Test Data preparation/ Logical run plan
  • Prepared Insurance premium calculator
  • Test Execution & Defect Reporting
  • Trained business user on application flow and usage

Confidential

Test Engineer

Responsibilities:

  • Understanding the functions of the CMS application for the scheduled new modules.
  • Understanding the Requirements and raising clarification documents
  • Preparing the Product Matrix & Traceability Matrix
  • Preparing & Reviewing of High level Scenarios/Test Conditions/ Test Cases /Test Data preparation/ Logical run plan
  • Test Execution & Defect Reporting in QC

Hire Now