ETL API Test lead

SHIVAGURU SUBBIAH

*********.*@*****.*** ● Contact: 980-***-****

CAREER OBJECTIVE:

To utilize my project management, leadership and relationship building skills in sync with my technical knowledge, towards a growth oriented role in a well-reputed organization. I bring over 16+ years of industry experience in Quality Assurance, 10 years in ETL/DB testing and Webservice testing using SOAPUI NG PRO and POSTMAN with focus on Dataware housing, Oracle, Teradata, Informatica and Tracking Tools. 3+ years automation experience with Rubymine. Possess a positive attitude, flexible and strong analytical & communication skills to work in any challenging environment to provide quality output

PROFESSIONAL PROFILE:

●Have 16+ Years of experience in Software Quality Assurance

●Profound Knowledge of SDLC and Software Testing Life Cycle including analysis, test case preparation, Testing, Installation and Defect tracking.

●Excellent experience in Team Management, reviewing and designing Test Requirements, Test Scenarios, Traceability Matrix, preparation of test data manually & test environment creation

●Experience in working as ETL Tester/Test Manager with Accenture for a US based bank.

●Expertise in Webservice testing and automation using SOAPUI NG PRO (Groovy Scripts) and POSTMAN

●Experience in automation using Rubymine

●Strong knowledge and understanding on Data Modeling

●Expertise in working in Agile methodology

●Professional experience in Integration(end-end), Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing

●Extensive experience with onshore/offshore/nearshore co-ordination

●Expertise in healthcare domain and Legal, Compliance & Financial Crimes Technology domain.

ETL Testing Experience: 10 Years

●Have 10 years of experience in ETL/Database Testing.

●Expertise in ETL Testing (Informatica, Oracle and Teradata) – Process flat files using Informatica. Validate staging to target, Data Quality check and Data enrichment using Teradata. Generate/validate spotfire reports and validate extracts to the downstream applications.

●Experience on Data analyzing and Data Profiling

●Expert knowledge on SQL Queries

●Experience on Root Cause Analysis

●Proficient on querying different databases like – Oracle and Teradata

●Experience in translating Business requirements to DB queries for validation.

●Proficient in SIT Testing, UAT testing & Data Base Testing

●Expertise on Spotfire & Microstrategy report testing

●Communication with Client and Business User for Requirement understanding and data usage

Technical Expertise:

Skill

Years of Experience

Year Last used

Test Management

14 Years

2021

Mercury Quality Center

10 Years

2020

JIRA

5 Years

2021

ETL Testing

7 Years

2021

MS SQL Server

7 Years

2021

Toad for Oracle 11.6

5 Years

2017

POSTMAN

3 Years

2021

SOAPUI NG PRO

2 Years

2020

Rubymine

3 Years

2021

Spotfire

2 Years

2015

Teradata SQL assistant 14.10

5 Years

2015

Autosys

5 Year

2019

WinSCP/ Unix

2 Years

2015

Actimize Case Manager

2 Years

2012

Microstrategy 9

2 Years

2012

Borland Star Team

2 Years

2010

MS Team Foundation Server

2 Years

2009

Visual Source Safe

4 Years

2009

Citrix 4.0 & Citrix Xenserver

2 Years

2009

Microsoft Virtual Server 2005

3 Years

2009

QTP / UFT

< 1 Year

2016

CERTIFICATIONS & AWARDS

Certificate Name

Institute

Date certified

CMST (Certified Manager of Software Testing)

QAI

Jan – 2012

CSTE (Certified Software Tester)

QAI

Jan – 2009

NCFM-Capital Markets Dealers Module

National Stock Exchange(NSE)

Mar – 2011

NCFM-Derivatives Markets Dealers Module

National Stock Exchange(NSE)

May – 2011

●Completed Accenture Internal Certification for –

oFinance Foundation

oCapital Markets Level 1

Client/Company : Wells Fargo (NTT DATA INC) / Indus Group Inc.,

Project : Wholesale Customer Information System (WCIS)

Project Duration : Dec 2015 - Till Date

Standard Role : ETL/Webservice QA Analyst

Project & Role Description

The Wholesale Customer Information System supports various functions/processes that touch a customer. The customer system establishes/maintains legal structure of Wells Fargo customers that can be leveraged to support sales, credit, risk and other operational functions, whereby, any internal overrides performed for internal business reasons are identifiable and auditable. WCIS sources/shares this information with 100’s of systems in the division and provides a use interface to support lookup/research to over 15k users.

The testing services provided will include system testing, database testing, webservices testing, automation of webservice testing using SOAPUI NG PRO, regression testing, preparation of test plans, test cases and test data, defect reporting and tracking for system integration and regression testing, supporting re-test after fixes. Prepare and execute automation test scripts using Rubymine for regression testing.

Team Size : 14

My Responsibilities:-

●Involved in preparation of SQL Queries for backend testing, scripting for webservices testing, Test case documents, Test Data preparation and Regression Test cases.

●Coordination with the offshore team

●System Testing, DB testing, Webservices testing, Regression Testing using Rubymine

●Automation of webservice testing using Groovy scripts

●Written Test Cases for ETL to compare Source and Target database systems

●Complex data validation using SQL queries

●Reporting and Maintaining bug status using Quality Center

●Interacting with SME's & Client to leverage the Application Knowledge.

●Developing domain Knowledge in Banking and technical knowledge.

Client/Company : Bank of America/Accenture Services Pvt Ltd

Project : GRITT-TQMS

Project Duration : Mar 2010 - Oct 2015

Standard Role : Portfolio Lead/ETL Test Lead

Project & Role Description

Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. This project deals with Investment banking, Risk Management (FCT).

Team Size : 45

My Responsibilities:-

●Leading 45 member team in Onshore / Nearshore / offshore

●Worked as an ETL Test Lead in addition to resource management.

●Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica

●Written Test Cases for ETL to compare Source and Target database systems

●Complex data validation using SQL queries

●Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

●Performed the Back-end Integration Testing to ensure data consistency by writing and executing SQL statements

●Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool Informatica and data loaded into various databases

●Prepared SQL scripts for test data preparation for Back End functionality testing

●Tested Spotfire reports and extracts to the downstream systems

●Interacting with SME's & Client to leverage the Application Knowledge.

●Developing domain Knowledge in Banking and technical knowledge.

●Adhering to SLA and perform testing within the stipulated timelines

●Providing metrics to improve utilization and continuous improvement

●Analyzing Project Business Requirements

●Estimating effort required for the module

●Creating a detailed System Test Plan with Scope, Schedule and Testing Approach

●Preparing Traceability Matrix, Test Scenarios and Test Scripts in Quality Center

●Co-ordinate with the offshore functional teams for assistance preparing test plans and test execution

Additional Responsibilities:

●Ensure that all project documents are placed in share folder and uploaded to share point

●Explain the scope and give walkthrough

●Managing Onshore and Offshore Leads tracking the status of the projects in execution on daily basis.

●Update and send query tracker for initiatives

●Update the Monthly status reports every month on the projects worked on for that particular month

●Ensure that the environment tracker is updated for initiatives.

●Track the status of defects logged for initiatives and follow-up with dev team to get the defects fixed.

●Develop and Implement process improvements across the portfolio

●Provide updates to templates followed for delivery activities

●Closely working with the Change Management team for resource allocation and funding

Client/Company : Cognizant Technology Solutions

Project : BlockBuster LLC.

Project Duration : Dec 2009 - Feb 2010

Standard Role : Project Lead

Project & Role Description

Blockbuster LLC, also known as Blockbuster and formerly Blockbuster Video Entertainment, Inc. was an American-based provider of home movie and video game rental services through video rental shops, DVD-by-mail, streaming, video on demand, and cinema theater. At its peak in 2004, Blockbuster consisted of nearly 60,000 employees and over 9,000 stores.

The testing services provided will include system testing, regression testing, preparation of test plans, test cases and test data, defect reporting and tracking for system integration and regression testing, supporting re-test after fixes, supporting high level performance testing & database compare

Team Size : 10

My Responsibilities:-

●Overall responsible for Batch & Reports deliverables

●Technical Analysis & Design for Batch & Reports

●Responsible for doing estimates for Batch & Reports.

●Deciding the resource plan for Batch & Reports team.

●Subject Matter Expertise for Batch & Reports Architecture & functionality

●Support Test execution (SIT - Pass1, Pass2) of Reports & Batch with Testing Team

●Translate Batch & Reports requirements & design

●Perform code review for Batch & Reports

●Perform Test Case review for Batch & Reports.

●HLD sign-off from Batch & Reports perspective

Client/Company : ProVation Medicals (Wolters Kluwer) / Tata Consultancy Services Pvt Ltd

Project : Order Set Application

Project Duration : Apr 2005 - Nov 2009

Standard Role : Module Lead/ Project Lead

Project & Role Description

The ProVation suite of physician and preoperative procedure documentation software is an enterprise-wide solution available in a continually growing number of medical specialties. ProVation software promotes productivity, cost-reduction, compliance and - most important - broad-based utilization and satisfaction by physicians, nurses other caregivers

The testing services provided will include system testing, regression testing, preparation of test plans, test cases and test data, defect reporting and tracking for system integration and regression testing, supporting re-test after fixes, supporting high level performance testing & database compare

Team Size : 12

My Responsibilities:-

●Involved in preparation of Test case documents, Regression Test cases and Gap Analysis.

●Coordination with the offshore team

●System Testing, Regression Testing & Performance Testing (OpenSTA)

●Reporting and Maintaining bug status using Star Team

●Database Testing – Staging the application with the client’s DB(dump file), updating the DB to a newer version and validating the same against the old DB

●Test Environment setup (Citrix, MS Virtual Server)

●Preparation of Metrics and Root cause analysis

●Prepare the Test Evaluation Summary Report

Educational Details

Degree

University

Year of passing

B.Tech Information Technology

Kamaraj University, Madurai

2004

Contact this candidate