Resume

Sign in

SENIOR ETL QA ANALYST

Location:
Toronto, Ontario, Canada
Posted:
February 06, 2018

Contact this candidate

SUNITHA MARRI

**** ******* ***, ***********, *******, Canada

Tel: 647-***-**** Email: ac4dbi@r.postjobfree.com

EXPERIENCE SUMMARY

Senior Quality Assurance Analyst with around 10 years of International experience in Software Development encompassing ETL testing, Report testing, Database testing, Manual testing, functional testing.

Have a very good knowledge working in Banking and Financial Domain.

Worked extensively on Data Warehousing projects and have strong experience on ETL tools.

Experience working in Agile projects, have a very good understanding of Scrum Methodology in delivering the output.

Have exposure on Automation tools like Selenium Web driver.

Have proficiency in using Query-surge tool for testing.

Have a very good understanding on Big Data and tools like Pig, Hive.

Excellent understanding of Software Development Life Cycle (SDLC) and experience in all phases of Software Testing Life Cycle (STLC).

Experience in writing Test Plans, defining High level Test Scenarios and Test Cases, creating and maintaining test cases, analysing bugs, interacting with team members and track the bugs till closure.

Expertise in Health Insurance and Retail domains.

Well versed with Sprint planning, Daily Scrum calls, Sprint Review meetings.

Having knowledge on SAP BO to do Report testing.

Hands on experience in using HP interactive tools like HP ALM (QC 12.0).

Conversant with analysis and accuracy of engines by coding in UNIX shell scripting, GGI-Perl, php, ASP.NET, Informatica.

Worked on Speaker and Speech Recognition System. Hands on experience in modules of Speaker Recognition System such as Feature Extraction, Voice Activity Detection and Engine Algorithms and Automatic Speech Recognition-Sphinx based Password Verification System.

Expertise in Functional testing, GUI testing, Usability testing, System testing, Integration testing, Regression testing, User Acceptance testing, Interface testing and Database testing

Self-starter and team player with excellent communication, problem solving skills, interpersonal skills and a good aptitude for learning new things

Actively participated in various meetings with the developers, clients, and project management to discuss and prioritize the defects found during testing, enhancement issues, and future design modifications

Ability to work with ease under tight deadlines and fast-paced environments. Played a major role in timely delivery of the application under critical situations.

An effective communicator with strong leadership, interpersonal, and coordination skills.

AREAS OF EXPERTISE

Technical

Programming Languages :C, Core java

ETL & Reporting Tools :Business Objects 6.5, Informatica 8.6.0,SAS,

Ab Initio 3.1.7, Winsql

Automation Tools :Query-Surge, Selenium Web-driver

Database :MS-SQL Server 2005, MY-SQL, MS ACCESS,

Teradata (SQLAssistant13.0), IBM-Netezza,

Oracle SQL DEVELOPER, DB2

Scripting Languages :CGI-Perl, Shell Scripting, PHP

Web Technologies : ASP.Net, JSP

Environment : Windows 10, Windows XP, UNIX

Server : Apache

Utilities : Toad, $Universe, Kintana, PVCS, Control-M, Code Promotion Tool, RTC,

Quality Center (HP ALM 12.0), Abinitio Control center, SSH Techia Client

Domain : Retail, Health Insurance, Banking-Finance

Legacy Systems : IBM Mainframes

Functional

Ensuring ROM level estimates for projects are provided when an Intake is submitted.

Interfacing with clients for business gathering, conducting system analysis and finalising technical / functional specifications and high level design documents for the project.

Contributing to the design, development, testing, troubleshooting and debugging of the software.

Ensuring smooth implementation and testing at client location.

Ensuring compliance with SLAs across the product/ software development lifecycle.

Complying with ISO and CMM quality standards.

EXPERIENCE CHRONOLOGY

Growth Path:

Sep’15-Dec’16 QA Analyst(Onsite)

Feb’15-Jul’15 Test Lead

Nov’11 – Feb’15 Team Lead

Aug’10-Nov’11 Senior Software Engineer

Jul’07-March’10 Software Engineer

Dec’06-Jun’07 Trainee

On Maternity Leave from Jan 2017 to Till date

QA ANALYST Sep 2015 to Dec 2016

CLIENT:TD

FATCA:

Description:

FATCA is US tax legislation which requires all non-US financial institutions (FFIs) to identify US owned accounts and report information about those clients and their accounts to the IRS. FFIs will need to identify and report all 'financial accounts' for specified US persons, certain US owners or non-US entities, and non-Participating FFIs (NPFFI).

Key accomplishments:

Extract the data from different source systems and apply transformations in the Staging area (ESI) to Load the data to different Downstream Systems.

Participate in Daily calls and provide the execution status at the Program level.

Coordinate with the upstream to receive source files.

To process the source files, execute the jobs and deliver the files to downstream.

Make the environment ready for the execution.

Execute the Daily and Monthly jobs required for NAOM and PEAR execution.

Investigate the root cause if there are any data issues and provide the details to the Program.

Interact with the upstream and downstream teams in providing the required data to resolve any data issues.

To involve in Defect Triage calls and work on the defects assigned.

SAS-AML:

Description:

TD utilizes SAS AML application for Transaction Monitoring and Suspicious Transaction Reporting (STR) reporting to FINTRAC. The current version (4.2) has reached its capacity. As a result, end users have experienced slow application response times when performing their daily duties from time to time.

The SAS 6.3 upgrade project aims to address the existing capacity and performance issues as well as to position the Transaction Monitoring and STR reporting function to be integrated into Enterprise Case Management (ECM) platform.

During SAS AML 6.3 upgrade analysis and design, it has been confirmed that current platform will not deliver the required performance and capacity improvements required to meet the business and technology needs.

Key accomplishments:

Analyse the SRS and SDS documents shared by Project team.

Extract the data from multiple source systems and apply transformations in the Staging area (ESI) to send the data to AML Downstream Systems.

Understand the ESI scope and interact with Project team for any further clarifications.

Allocate work to the offshore team and coordinate them accordingly.

Attend weekly status meetings with Program Team to provide overall Project status.

To have discussions with Project team in planning the different phases of project.

Prepare High-Level scenarios and have walkthrough with the Project team.

Prepare Test Plan document, have walkthrough with the Project team.

Investigated whether already available Datasets can be used for testing.

To execute the jobs under different phases and validate specified data.

MBNA VISA:

Description:

MBNA is implementing dual network capability to increase their co-brand partnership offer flexibility. MBNA Visa Project is building Visa rails within their existing platform. Existing MBNA MasterCard technology and processes should be replicated wherever possible, minimizing technological and organizational change. Although the MBNA platform has been built to be flexible, allowing the implementation of new products, there are Visa specific requirements that need to be worked through.

To support this requirement AML/ WLM/CRR application testing is required, and to support this task ESI team has been engaged. MDM, CODS and TSYS files will be processed by ESI to provide extract files to the downstream AML/WLM/CRR application. ESI role is to support AML/WLM/CRR testing.

Key accomplishments:

Attend the Program level meetings to understand ESI scope.

To process the data from source systems and apply Transformations to send the data to AML, CRR, WLM downstream systems.

To understand Program Level Master Test plan and to have discussions for any clarifications.

To gather inputs from Program, Tech Lead and prepare ESI Test Plan.

To have Test Plan walkthrough with the Program and based on the feedback provided update Test Plan accordingly.

To process the files provided by source and load data into downstream environment

To make sure that proper access is provided to load data to the downstream systems.

To validate the data and make sure that data is loaded in the staging tables.

To execute Daily and Monthly job's as per the cycles.

To coordinate with source if there are any issues with source files provided.

LEASEWORKS UPGRADE:

Description

Lease works is the “system of record” for lease accounting and management. It provides users the ability to enter and book leases, process lease payments, invoice, manage delinquencies, and manage equipment inventory. TD Equipment Finance (“TDEF”) staff is the user of this application.

This project encompasses upgrading to the current version of Lease works which will allow TD Equipment Finance to be compliant with recent enhancements to the application and expand its suite of products.

Key Accomplishments:

To attend Daily calls and provide updates to the Program about the execution status.

To prepare the environment ready for execution.

Interact with upstream and downstream partners

To get necessary approvals and access to the downstream systems

To interact with Tech lead for any technical assistance.

To validate data and report if there any issues.

CDIC:

Description:

Audit has identified Momentum file transmissions that include CDIC data that do not meet security requirements. These transfers must be migrated to TIBCO to conform to Audit security requirements. The files will be received via TIBCO rather than Momentum.

Key accomplishments:

Attend the Project meetings to understand the ESI scope.

To gather inputs from the Program, Tech Lead and prepare ESI Test Plan.

To prepare the Test Artifacts and have walkthrough with Project Team, incorporate the changes as per the feedback provided.

To prepare the environment ready for the execution.

To do the execution and investigate the root cause for any job failures.

To raise the defects and assign to the Development team.

To participate in the Defect call meetings and re-execute jobs after issue is resolved.

To coordinate with source if there are any issues with source files provided.

MDM-MIGRATION:

Description:

Loading of MDM Notification file due to mailbox change. To transfer the file from the new TIBCO Mailbox.

Key accomplishments:

To analyze the Intake form for project and provide high level ROM Testing estimates.

To process the Notification file from the new Mailbox server and execute the respective jobs.

To prepare the required Test artifacts.

To coordinate with the Source team if any issues with the file sent to ESI.

To process both Daily and Monthly notification files.

MDM-DECOUPLING:

Description:

To achieve the architectural direction for the enterprise to no longer leverage MDM as a real-time system, C-ODS required re-architecting to be the single book of record for credit card customer data. MDM will be sending C-ODS Party Alias ID for all C-ODS customers to ESI, ESI to pass the new data to CRR, EDW.

Key accomplishments:

To attend the Daily status meetings with the Program team where all the upstream and downstream partners are involved.

To coordinate with the source team while processing the files.

To raise defects if any issues while processing the source files.

To make sure access is provided to Downstream systems.

To prepare the required Test Artifacts.

To execute the jobs successfully and make sure data is loaded into Target systems.

North-Phase2:

Description:

Apple Pay Phase2 for MBNA and CUETS will implement Apple pay as part of TD’s mobile wallet strategy.TD is partnering with VISA, MasterCard and Apple to provide customers with the ability to provision of credit cards and make transactions with eligible Apple devices.

Key accomplishments:

Schedule meetings with ESI Project team to understand the ESI scope.

To gather inputs from Project team and prepare ESI Test Plan.

To prepare the Test Artifacts and have walkthrough with Project Team, incorporate the changes as per the feedback provided.

To prepare the environment ready for the execution.

To do the execution and investigate the root cause for any job failures.

To process the data from source systems and apply Transformations to load the data to AML, CRR, WLM downstream systems.

To follow up with the Development team in resolving the defects

To participate in the Defect call meetings and re-execute jobs after the issues are fixed.

To do data validation as per the mapping sheet provided.

ALP-Tetris:

Description:

Account Level Processing(ALP) provides a fundamental shift in the way that transactions are processed, where products are customized at the account level rather than BIN level. This results in customer having the same credit card number “for life”. As a customer moves throughout their lifecycle acquiring different products, the product code will be used for card identification and processing rather than BIN. For this reason, there are many downstream impacts for any internal and external systems or processed that currently utilizes the BIN.

Key accomplishments:

Analyze the SRS and SDS documents shared by the Project team.

Schedule meetings with the Project team to have clarifications on documents shared and understand ESI scope.

Prepare Test Strategy document and provide High Level Test scenarios to the Program Team.

To attend Program Level Meetings to provide Project status.

Schedule meetings with Project Team to have walkthrough on Test Plan and incorporate the review comments provided.

Prepare the required Test Artifacts and upload Test cases in ALM for each of the respective cycles.

Prepare the environment ready for execution.

To process the jobs and validate the data based on the Mapping sheet provided.

To validate the Extracted data and load into EDW Downstream systems.

To report if any issues and raise defects to the Development team.

Coordinate with Development team and re-run the jobs after the defects are fixed.

To pass on data to the Downstream applications.

Tetris-Product Launch:

Description:

Project Tetris is a transformational journey that will consist of five key projects. This program will allow TD cards to maintain and grow market share and capture operational wins in the medium/long term. Tetris Product Launch supports addition of new products to VIL feed to ESI to EDW.

Key accomplishments:

Analyze the SRS and SDS documents shared by the Project team.

Schedule meetings with the Project team to have clarifications on documents shared and understand ESI scope.

Prepare Test Strategy document and provide High Level Test scenarios to the Program Team.

To attend the Program Meetings to provide the Project status.

Schedule meetings with Project Team to have walkthrough on Test Plan and incorporate the review comments provided.

Prepare the required Test Artifacts and upload Test cases in ALM for each of the respective cycles.

Prepare the environment ready for execution.

To process the jobs and validate the data based on the Mapping sheet provided.

To report if any issues and raise defects to the Development team.

Coordinate with Development team and re-run the jobs.

To pass on data to the Downstream applications.

TEST LEAD IN WIPRO TECHNOLOGIES Feb 2015 to July 2015

CITI BANK-CHINA LRR:

Client : CITI BANK

Project : CHINA LRR

Role : TEST LEAD

Data base : Netezza, Oracle SQL Developer

Tools : Control-center, Quality center, SSH Techia Client, Abinitio

Domain : Banking & Financials

Description:

China is a Calendar Day 3 reporting country, with a large and increasing number of regulatory reports, with both national and city-level reports. Potential reporting errors caused by manual work had a significant negative impact on Citi China franchise. China LRR implementation requires several technical configurations and business-related entities to be maintained in Map Hub. It will provide reference data across the China RegInsight platform for report generation process.

Key Accomplishments:

oAs per the requirement run monthly, weekly, daily, rules jobs.

oGenerate reports accordingly for various products and deliver the same to user.

oTest the reports, to check whether data is reflected properly in report by writing the SQL query according to the rules and by referring to the documents given.

oTest the change requests for the Reports, verify the changes properly reflected in the Report.

oData analysis and investigation

oDo the defect analysis, find the root cause, and report the same to the ETL team to fix it.

oSending every day and over all status to on site team. Client and business people.

oCoordinating with Development team about the code deployment and test the reports.

oInteracting with other teams and vendors who are involved in the data flow.

oDefect logging and retesting the fixed defects.

TEAM LEAD IN NTT DATA GLOBAL DELIVERY SERVICES PVT LTD Nov 2011 to Feb 2015

BCBSNC NCTIO:

Operating System : Windows XP, UNIX

Language : Abinitio

Data base : Teradata (SQL Assistant 13.0)

Tools : Control-M, RTC, Code Promotion, Quality center

Domain : Health Insurance

Client : BCBS NC

Description:

The North Carolina Topaz Integration Office (NCTIO) is focused on the deployment and implementation of the Topaz Platform. Topaz technology within BCBSNC is responsible for planning and managing member migration to the new platform i.e., FACETS and the subsequent retirement of the Legacy systems. Facets is an integrated health care management system that integrates eligibility, provider and plan/product data to efficiently process claims, utilization management, reviews, case management and customer service information.

Key Accomplishments:

oWorking in Agile methodology, participating in Scrum meetings and sprint planning sessions.

oInteracting with other teams who are involved in the data flow.

oTest plan preparation and review the test cases provided by the team based on the business requirement documents provided by the clients.

oTesting the graph in different environments and present the results to onsite Team.

oDefect logging and retesting the fixed defects.

oSeeding data and testing according to the scenarios.

oPreparing the test case scenarios and test cases and reviewing the test cases provided by the team.

oCoordinating with Development team to set up the environment for testing.

oGetting access to the team to perform testing in specified environments.

oBurn the daily hours in RTC, work on the task allocated and intimate the team status in Daily Scrum call.

oSending every day and over all status to on site team. Client and business people.

oGiving KT to new team members and ensuring expectations and responsibilities are clear to them as and when needed.

oAnalysis of the specification document and have discussion with the onsite Team for any clarifications.

CDW-EDW REMEDIATION:

Operating System : Windows XP, UNIX

Language : PC SAS 9.2, SAS Enterprise Guide

Data base : Teradata (SQL Assistant 13.0)

Tools : Control-M, Code Promotion

Domain : Health Insurance

Client : BCBS NC

Description:

Blue Cross and Blue Shield of North Carolina (BCBSNC) is a leading health services company in delivering innovative health care products, services and information to help customers improve their health and well-being. It is the largest health insurer in the state, serving more than 3.6 million customers. It outlines the data migration from one warehouse to the other in order to facilitate daily updates to business user rather monthly updates. Latest information can be obtained based on which further decisions can be taken.

Key Accomplishments:

oParticipated in Scrum meetings and sprint planning sessions.

oGiven KT to team members.

oEnsures expectations and responsibilities are clear to team members.

oSet up the environment for testing.

oSending every day and over all status to Client and business people.

oReview the test cases provided by the team based on the Business requirement documents provided by the clients.

oGetting access to the team to perform testing in specified environments.

oDefect logging and retesting the fixed defects.

PQE

Operating System : Windows XP

Data base : Teradata 13.0, MS ACCESS

Domain : Health Insurance

Client : BCBS NC

Description:

PQE Initiative is a yearly project aimed at extracting data from MS Access tables and loading them into Teradata, which is done in two phases. In the first phase data is filtered to get current year’s data and placed in MDB and also copy of data received for maintenance in MDB. In second phase, transformations are applied to MDB tables and combined with history data and loaded to Teradata.

Key Accomplishments:

oAnalysis of the specifications provided by the client

oPreparing the Test case scenarios and Test cases.

oValidation of current year data which is updated to MDB.

oTesting the data from source to Target.

oLog the defects occurred and informing the same to Dev team.

State Reporting Matrix Reports & Medical Expense Reports:

Operating System : Windows XP, UNIX

Language : PC SAS 9.2

Data base : Teradata,

Tools : Control-M, Code Promotion

Domain : Health Insurance

Client : BCBS NC

Description:

Matrix reports contain the QTD and YTD and other paid information for State Health Plan for Teachers and State Employees. Medical Expense Reports are created by pulling the data from CDW and PMPM trend values by product are created.

Key Accomplishments:

•Analysis of specifications and requirements provided by the clients.

•Establishes and communicates to the team the project vision, mission and strategic value.

•Communicate to Client on the testing progress and organize defect status meetings.

•Tracking the tables mappings as per BRD and FDs

•Test Case Authoring, User Acceptance Testing, Report testing and getting Signoff.

•Analysis of the specifications provided according to the requirement. Defect Tracking and analysis

SENIOR SOFTWARE ENGINEER IN TECH MAHINDRA Aug 2010 to Nov 2011

CCW (BI Testing)

Operating System : Windows XP,

Data base : ORACLE 9I

Tools : Citrix, HP Quality Center 9.2, Business objects, TOAD

Domain : Retail

Client : CISCO Inc

Description:

Cisco Commerce Workspace (CCW) enables the foundation for an end-to-end customer/partner selling and purchasing experience in an integrated workspace. The initiative is focused on constructing a commerce back-end to support the next decade of global growth. In order to facilitate a warehouse out of Cisco Customer Care Center (Cisco C3) OLTP system, a business layer was created and named Cisco customer care business layer (C3BL). This warehouse supports for BI – decision supporting system. C3 system is taking care of the process of service order/ service request and task.

Key Accomplishments:

• Test Plan preparation as per business requirement

• Tracking the tables mappings as per BRD and FDs

• Test Case Authoring

• Evaluating design steps as per functionality ensure that the test case uses the most appropriate.

• User Acceptance Testing and getting Signoff.

• Unit testing & integration testing.

• Analysis of the specifications provided according to the requirement.

• Defect Tracking and analysis

EDWCQA (ETL Testing)

Language : Teradata SQL, ANSI SQL, Informatica

Operating System : Windows XP, UNIX

Data base : Teradata 12.0, Oracle

Tools : Informatica 8.6.1, Dollar U, HP Quality Center 9.2, Kintana

Domain : Retail

Client : CISCO Inc

Description:

The application is Enterprise Data Warehouse – CISCO Quality Assurance. This involves end to end functional testing of data which is done on individual tracks (subject areas).Loading data directly from source systems ODS i.e. (maintained on ORACLE DBMS) and reporting directly from EDW2B is the approach used. Informatica is used as the primary ETL tool with possible use of Teradata SQL. Teradata environment is used to support Staging, Error, Work and 3NF data Warehouse. Data is extracted from source into flat files and subsequently loaded into Teradata tables. Data is then transformed, restructured, filtered, etc. into the normalized tables.

Key Accomplishments:

oAnalysis of the specifications provided by the client

oPreparing the Test case scenarios and Test cases in Quality Centre.

oLoading the Data manually or through $U.

oTesting the data from source to Target.

oResponsible for overseeing the Quality procedures related to the project.

SOFTWARE ENGINEER IN SATYAM COMPUTER SERVICES Jan 2007 to Feb 2010

Blood Line (Blood Bank Management System) for HMRI

Language : Perl, ASP.Net

Operating System : Unix, Windows

Domain : HealthCare

Key Accomplishments:

oInvolved in requirement gathering, design, testing.

oGenerated the requirement documents, Project Related documents like URD, SRS, DDD,

designing and User Interface document.

Voice Based Time Sheet Tool for ICFAI

Key Accomplishments:

oInvolved in writing test cases and test plan for testing the application.

oDone various kinds of testing of application and database designing.

oInvolved in writing automated scripts for analyzing the results of application by Perl Coding.

oDeveloped code for Reviews and Timesheet Modules.

oParticipated in preparing URD, SRS and DDD document.

V-ACCESS for EMRI

Key Accomplishments:

oSuccessfully analyzed the specifications provided by the clients.

oDeveloped Client-Server architecture tool, with the entire voice related processing taking place in

the client machines.

oGenerated reports by deploying Perl scripting.

V-Control Nuisance Calls for HMRI

Key Accomplishments:

oPerformed Speaker Verification for testing process by using Perl at background process.

oUnderstanding the business requirements and designing application to meet customer needs.

oComprehending the architecture of the contact center, to identify irrelevant calls quicker

oDeveloped stored procedures and functions for capturing and matching the caller’s details.

oAlso developed our own Speaker Recognition technology (achieved state of art accuracy in

the field of voice biometrics).

oPerformed unit testing and system testing for the system developed.

Speaker Recognition System

Description: The aim of the project was to develop commercially viable Speaker Recognition systems. Speaker recognizing process entails, identifying the person who has spoken rather than what he/she had spoken.

Responsibilities:

oWriting automated scripts for analyzing the results of Engines by Perl Coding.

oTesting different business applications.

oGenerating different test case documents and business solution documents.

oGiving presentations on speech technology to potential customers.

Secure FTP

Responsibilities:

oInteracting with clients on daily basis, regarding issues on the scripts.

oTransferring FTP files from production server to Customer server.

oLooking after troubleshooting of failed scripts and devising root cause analysis and reporting.

ACADEMIA

2015 MBA(HR) from INDIRA GANDHI OPEN UNIVERSITY (IGNOU)

2006 B.Tech. (Electronics and Communication), JNTU University, Secured 73% marks.

2002 12th, Nalanda Junior College Secured 92% marks.

2000 10th St. Pious X Girls High School Secured 82% marks.

ACCOLADES

Active participant of the CSR activities organized by Satyam Computer Services Ltd.

Held the post of Student Representative, IEEE at College.

Awarded outstanding performer in academics in school and received Merit scholarship in B.Tech.



Contact this candidate