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