Test Cases Data
Resume:
VEENA JATTI
Indianapolis,IN ӏ (C) 317-***-**** (Email)************@*****.***
Professional Summary
Functional: ETL and Web-based Test Engineer with 5 years of experience in ETL and web based functional Testing for Banking, Financial services and Insurance (BFSI) projects and BMV of Indianapolis
Areas of expertise include Requirement Analysis, Test Estimation, Test Plan, Test case creation and Execution, Reporting Defects, Extended support to UAT and Production teams when required.
Good knowledge of Software Development Life Cycle(SDLC)
Worked on Waterfall model and Agile Model projects
Worked on Onsite-Offshore Model
Skills
ISTQB and FLIP and Agile Certified ETL Tester
Fair theoretical and practical knowledge of database and Sql queries.
Good Domain knowledge of Banking, Financial services and Insurance (BFSI) with FLIP(Finitiatives Learning India Pvt. Ltd.) certification
Worked 4 years for the same client 'Silicon Valley Bank - SVB.com' for different projects
Excellent knowledge of Oracle FLEXCUBE, Finacle universal banking solution(UBS), Fiserv core banking system(CBS), Operational data store(ODS), Data Analysis and Reporting Tool (DART)
Fair knowledge of Applications like - CRM, Actimize, PSGL, TurboCar
Good Team Player- worked with max. 12 members in a team
Good Team Leader- Lead a team of 3 people.
Excellent Individual Contributor
Keen Learner- Was nominated for some certifications like ISTQB and FLIP.
Basic knowledge of automation and automation tools QTP and Selenium.
Work History
Role: QA Analyst
Company: iLAB LLC, Indianapolis, Indiana, USA 08/2015 – 02/2016
Client: Indiana State
Methodology: Agile
Project: Bureau of Motor Vehicle (BMV)
Client: Indiana State, Indiana, USA
Duration: Aug 2015 – Feb 2016
Description: BMV had a lot of production issues early 2015 release. It decided to replace its QA team with 3 QA Analysts (including me) from iLAB LLC. Under Agile methodology, QA is assigned all the Legislative SRs in sprint of 2 weeks fixing the issues for 5 releases in Nov ‘15, Dec ’15 and Feb ‘16. Nov release went well with zero issues in production for the SRs I tested and client is very happy to continue with iLAB and thus extending the QA team from 3 to 8.
Team Size: 3
Role:
Participating in Sprint Planning :
Providing Story point for User stories
Providing QA estimates in terms of Time based on the complexity and challenges involved in finding the test data
Understanding the user story and acceptance criteria and the background behind the particular SR (Service Request)
Participating in Daily standup pointing what was done yesterday, What will be doing today and the impediments/blockers
Test Estimation
Test Plan creation
Test Cases creation
Test Environment setup
Smoke test of the builds
Identifying Test data from database / Creating test data as per the scenario and test cases
Test case execution and regression testing if required. a. Comparing the predictions with the actual results by testing the business rules in the test environment. b. Displaying the comparison result in a separate worksheet.
Test Summary Report
Participating in the Sprint retrospect pointing what went well this sprint and what did not go well and what is the impediment
Support to User Acceptance Test team
Production Support: Worked on release nights to make sure Basic functionalities are working as expected in production.
Tools used:
1. Data access tool: MS-SQL
To analyze content of tables and to analyze results of loads.
2. Test management tool: TFS
to maintain and track the requirements, test cases, defects and traceability matrix.
Applications tested:
Stars – BMV’s Information System
Android and iPhone Stars Application
Barcode
Kiosk
IVR
myBMV- Online BMV User interface
Role: Senior ETL Test Engineer 04/2011 to 04/2014
Company: Mindtree-Bangalore, Karnataka, India
Client: Silicon Valley Bank, San Jose, CA, USA
Methodology: Waterfall and Agile
Project 1: SVB AML WLF (Anti Money Laundering - Watch List Filtering)
Client: SILICON VALLEY BANK, US
Duration: Jan 2013 – Apr 2014
Description: Without proper oversight, business models and services of SVB, clients can be exploited for money laundering. Regulators expect SVB to have up-to-date software solutions to monitor payment transactions in compliance with anti-money laundering (AML) and global economic sanctions regulations. SVB's sanctions filtering tool used for on-demand and batch screening is set to be de-supported by the vendor soon. Hence the purpose of this work effort is to start using Actimize Watch List filtering (WLF) module to screen entities individually and in batches.
Loading data from all the source systems [DBs and Flat Files] to DART staging layer on daily basis.
Transmitting the entity information from the staging layer to ACTIMIZE_EXP on daily basis.
Exporting the data from Actimize Export layer to Actimize Staging schema.
Team Size: 2 at offshore and 1 at onsite
Role:
Understanding of System Requirement Specification
Test Estimation
Test Plan creation
Test Cases creation
Test Environment setup
Smoke test of the builds
Receiving test data file from the developers
Test case execution and regression testing if required. a. Comparing the predictions with the actual results by testing the business rules in the test environment. b. Displaying the comparison result in a separate worksheet.
Test Summary Report
Knowledge transfer document prepared
Support to User Acceptance Test team.
Tools used:
1. Data access tool: Oracle Sql developer
to analyze content of tables and to analyze results of loads.
2. ETL tool: SAP Business Objects Data Integrator (BODI)
To run the jobs.
3. Test management tool: HP Quality Center (QC)
to maintain and track the requirements, test cases, defects and traceability matrix.
Project 2 : Positivepay
Client: Silicon Valley Bank, US
Duration: Nov 2012 to Jan 2013
Description: The Positive Pay Project is a client Fraud Prevention Product. The strengthening of SVB's fraud prevention product suite will significantly contribute to retention efforts and will aid in new client acquisition and also focus on product enhancements and key product offerings to attract businesses. It includes,
Check Traditional Positive Pay: Traditional Positive pay validates against check serial number and check amount
Check Positive Payee: Positive Payee would include payee name validation in addition to check serial number and amount as mentioned above in Traditional Positive Pay.
Check Reverse Positive Pay: Reverse Positive Pay process entails SVB sending clients a list of all checks paying against their account for them to take decision.
ACH Blocks & Filters: Client instructs SVB of ACH transactions that should either automatically pay (Filter) or automatically return (Block) without being presented to the client to decision
ACH Reverse Positive Pay: SVB presents all received ACH transactions that are hitting client account for Decision.
Account Reconciliation: SVB provides account reconcilement reports to client at agreed upon cycles.
Team: 1 at offshore and 1 at onsite.
Role:
Worked alone on the ETL part of the project
Validated the data of source file and the extract file generated by running jobs,applying business rules
ETL Test Case creation
Test case Execution
Defects reporting
Test summary Report of ETL part
Knowledge Transfer document created explaining how the business rules are applied in queries
Tools used:
1. Data access tool: Oracle Sql developer
To analyze content of tables and to analyze results of loads.
2. ETL tool: SAP Business Objects Data Integrator (BODI)
To run the jobs.
3. Test management tool: HP Quality Center (QC)
To maintain and track the requirements, test cases, defects and traceability matrix.
Project 3: UK cards
Client: SILICON VALLEY BANK, US
Duration: Nov 2011 – Nov 2012
Team Size: 2 at Offshore and 1 at onsite
Description: With the opening of the UK branch, SVB need to offer their clients the products and services they need to conduct their business. Card Services is a critical product to SVB’s clients. UK card Services Phase 1 provided their clients with Debit Cards and set the foundation with our vendor EDB - Ergo Group for the next phases to include Credit Cards, Multi Currency Cards etc.
Scope of ETL testing was from the source file from EDB to ODS to DART to Downstreams like PSGL, CRM, Actimize, TurboCar, ALM and CATS Certification.
Role:
Understanding of System Requirement Specification
Test Estimation
Test Plan creation
Test Cases creation
Test Environment setup
Smoke test of the builds
Receiving test data file from the developers
Test case execution and regression testing if required. a. Comparing the predictions with the actual results by testing the business rules in the test environment. b. Displaying the comparison result in a separate worksheet.
Test Summary Report
Knowledge transfer document prepared
Support to User Acceptance Test team
Tools used:
1. Data access tool: Oracle Sql developer
To analyze content of tables and to analyze results of loads.
2. ETL tool: SAP Business Objects Data Integrator (BODI)
To run the jobs.
3. Test management tool: HP Quality Center (QC)
To maintain and track the requirements, test cases, defects and traceability matrix.
Role: ETL Test Engineer 10/2009 to 04/2011
Company: Mindtree-Bangalore, Karnataka, India
Client: Silicon Valley Bank, San Jose, CA, USA
Methodology: Waterfall and Agile
Project 1 : UNIVERSAL BANKING SOLUTION
Client: SILICON VALLEY BANK, US
Duration: FEB 2010 – MAR 2011
Description: SVB decided to move all its data from CBS (Core Banking System), Fiserv to UBS (Universal Banking Solution). It involved many interfaces .Testing of each interface was to ensure that data is transformed correctly according to various business requirements and rules, all projected data is loaded into the data warehouse without any data loss and truncation.
Team Size: 10 at offshore and 2 at onsite
Role:
Understanding of System Requirement Specification
Test Cases creation
Smoke test of the builds
Receiving test data file from the developers
Test case execution and regression testing if required. a. Comparing the predictions with the actual results by testing the business rules in the test environment. b. Displaying the comparison result in a separate worksheet.
Support to User Acceptance Test team.
Documented all software support provided and tests carried on the applications. Worked on Aggregates Testing. Prepared a PowerPoint document on complete UBS Overview which is now serving as a KT for new joiners to this project.
Tools used:
1. Data access tool: Oracle Sql developer
To analyze content of tables and to analyze results of loads.
2. ETL tool: SAP Business Objects Data Integrator (BODI)
To run the jobs.
3. Test management tool: HP Quality Center (QC)
To maintain and track the requirements, test cases, defects and traceability matrix.
Project 2: SVBeConnect
Client: SILICON VALLEY BANK, US
Duration: MAR 2011 – Nov 2011
Team Size: 4 at offshore and 1 at onsite
Description: SVB Financial Group provides diversified financial services to emerging, growth and established technology companies and the life science, venture capital and premium wine markets. SVBeConnect provides Online Banking Platform for clients as well as Bank users.
Role:
This has different modules like User Administration, Client Administration and Client Enrollment. Privileges differ from bank users to client users. Tested whole application w.r.t. Bank User as well as Client User. Gained good Banking domain knowledge in this project.
Understanding of requirement Specification and the flow with the Business Analyst
As a Bank user, creation of client users and providing access to specified data to clients
As a Client user, Tested the Functionality of the services
Tested web based application using SoapUI
Test Case creation and Execution
Defect Reporting and working closely with the developers
Tools Used:
1> SoapUI
Training:
Campus Trainee
Company: Mindtree - Bangalore, Karnataka, India
Duration: Oct 2009 till Feb 2010
Trained and assessed on:
1> Basic Programming languages: C, C++, and Sql
2>Corporate Etiquettes
3>Testing Fundamentals and ISTQB Certification
Education
Bachelor of Engineering: Information Science and Technology
Basaveshwar Engineering College - Vidaygiri, Bagalkote, Karnataka 587102, India 2008
Certifications
International Software Testing Qualifications Board (ISTQB) – Foundation Level
Finance and Banking Fundamentals International -Finitiatives Learning India Pvt. Ltd.
owww.learnwithflip.com
Trained and certified Agile Tester
Sincerely,
Veena
25/02/2016
Contact this candidate