Resume

Sign in

Etl test lead, sql, datastage, netezza, Oracle, ssis, ssrs, cognos, TM

Location:
Upton, MA
Posted:
March 25, 2018

Contact this candidate

Resume:

Mahesh Goud Thirmandas ac4xhr@r.postjobfree.com

617-***-****

Summary

9+ Years of IT experience in Analysis and Testing on Database using SQL

Expertise in ETL/ Data warehouse backend testing and BI Intelligence reports testing

BI Adhoc testing by using Cognos, TM1 PAW

Expertise in writing complex SQL queries

Flexible to work with Netezza, SQL Server and Oracle 10g databases, MapR file system

Data comparison by using various tools like Toad, Apache Drill, ICEDQ automation tool

Proficient in providing effort estimations

Worked with different BI models such as Star and Snowflake and strong working knowledge in dimensional modeling

Have knowledge on debugging of Data Stage, Cognos report studio, SSIS, SSAS and SSRS packages

Excellent Writing skills of Test Strategy, Test Scenarios and Test Cases

Have Domain knowledge of Retail, Telecom and Manufacturing

Highly analytical with strong thinking and problem resolving skills

Solid understanding of FRD, SRS and Source to Target mapping

Conducting Business walkthroughs with Customer and performing reviews on requirements

Proficient in providing technical expertise throughout the life-cycle of a project

Participation in design Model reviews

Strong knowledge of Software Testing Life cycle and Software Development Life Cycles

Expertise in Team Management skills

Have Experience in Application Testing

Good exposure in Bug Triage and have Experience in Bug tracking Tools like QC, VSTS

Technical Expertise:

Testing

Data wareHouse, Cube, Files, Data Migration, ETL, BI Report, Various applications

Database

Netezza, SQL Server and Oracle 10g

File System

MapR Big data system

ETL Tools

Data Stage, SSIS, Informatica

Reporting Tools

TM1 Paw, Cognos Query Studio, Cognos Report Studio, SSAS, SSRS

Other Tools

Toad, Apache Drill, IceDQ, MS office, CA work station, Putty, SSH tectia

Applications

RPAS, MDM Sitehub

Languages

SQL, PL/SQL

Domain

Retail, Telecom & Manufacturer

Test Management Tools

HP ALM, VSTS

Operating System

Windows 95/98/2000/XP, Unix

Methodologies

Waterfall Model, Agile Modeling

Academic Qualification:

Bachelors Degree in Technology (Electrical & Electronics Engineering ) from Joginpally B.R Engineering College, 2008

Professional Synopsis:

Wipro Technologies Ltd. Jun-2008

Projects:

Project 12:

Company: Wipro Limited

Client: TJX

Project Name: RPAS Planning & Analytics

Time Period: October 2017 – Till date

Role: ETL/BI Test Lead

Tools: Toad, Apache Drill, ICEDQ, TM1 Excel Paw

Applications: RPAS, TM1 Paw

Environment: MapR, TM1, Extract files

Testing: MapR Data Testing, TM1 Paw data validation, Report testing, Extract file Tetsing

Team Size: 8

Project Description:

The Merchandise Planning Program’s objectives are to upgrade the TJX Merchandise Planning application onto new robust technology, integrating unit planning and enhancing planning functionality

Part of Implemenation:

•Analytics – provide business users access to planning data from the new RPAS system in a flexible, dynamic, interactive business intelligence (BI) tool

•Core Reports – integrate planning data from RPAS into the legacy Print Factory process to produce the Ladder Plan Print and Ladder Plan Summary reports, both online and printed

Responsibilities:

Understanding predictive data measures at RPAS by reading FRDI, S2TM & Explainer documents

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Effort estimation for data validation from MapR files à Netezza tables, Netezza tables à Exports(.csv files), Exports à TM1 paw & TM1 paw à Exports(.csv files)

Test plan design and strategies documents for various modules

Designing test approach, Test scenarios & review with business on the same

Writing complex SQL scripts to test the complete functionality. Verification of SCD type 1, type 2 dimension and Fact table data validation by using complex sql queries

Data validation from from MapR files à Netezza tables, Netezza tables à Exports(.csv files), Exports à TM1 paw & TM1 paw à Exports(.csv files)

Data validation of cognos Reports

Execution of Datastage jobs through Datastage, Unix & ESP schedule(CA work stataion)

Managing onsite and offshore team and daily activities

Manage the test process and execution using HP ALM Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

Daily status preparation to business

Project 11:

Company: Wipro Limited

Client: TJX

Project Name: Po Visibility

Time Period: August 2017 – November 2017

Role: ETL/BI Test Lead

Environment: Netezza, SQL, Datastage, Cognos

Testing: BI testing, Datawarehosue Testing, Report testing, Adhoc testing

Team Size: 3

Project Description:

TJX Global buying office wants BI for analysing Purchase order lifecycle along with Booking and shipping information. Sourceing purchase order data from POCC imports and Booking & Shipping information from EDI system to make BI.

Part of Implemenation:

Build Data mart to support BI

Cognos BI recports

Responsibilities:

Verifying Data mart model to support business requirements in BI

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Test plan design and strategies documents for variuos modules

Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.

Writing complex SQL scripts to test the complete functionality. Verification of SCD type 1, type 2 dimension and Fact table data validation by using complex sql queries

Data validation of Cognos reports & Adhoc view by using sql

Execution of Datastage jobs through Datastage & Unix

Support business by providing data from Datamart in UAT phase

Manage the test process and execution using Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

Managing onsite and offshore team and daily activities

Project 10:

Company: Wipro Limited

Project Name: New POS

Client: TJX

Time Period: Oct 2016 – July 2017

Role: Test Lead/DA

Environment: Netezza, SQL, Datastage

Testing: BI testing, Datawarehosue Testing, MDM

Team Size: 2

Project Description:

TJX wants to replace its end-of-life POS platform – Triversity. TJX has chosen to implement Xstore as the next generation POS platform. As part of this new implementation NEW POS will convert POS LOG file in to the same format of Triversity TLOG to minimize the impact of downstream systems. As part of this project EDW QA team performs Regression of existing point of sales ODS & ADL to make sure there will be no impact to EDW due to source system change.

Responsibilities:

Works with existing Triversity team to understand the functionality of existing POS system for creating the Test Plan and Strategies

Perform data analysis on EDW data to identify various possible sales transactions

Works as DA to design data model for Master data movement from EDW to Xstore

Data quality of TLOG transactions

Design meetings to understand New POS system Xstore

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Sales TLOG & Balance file transaction from Triversity and Xstore source systems

Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.

Writing complex SQL scripts to test the complete functionality

Using ICEDQ tool for data comparison

Execution of Datastage jobs through Datastage & Unix

Manage the test process and execution using Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

Project 9:

Company: Wipro Limited

Client: TJX

Project Name: IMB Audit

Time Period: July 2016 – Sep 2016

Role: Test Lead

Environment: Netezza, SQL, Datastage

Testing: BI testing, Datawarehosue Testing, MDM

Team Size: 4

Project Description:

The 'audit' process performed by Financial Control by taking a sampling of merchandise sent to stores. The dates of the samplings are compared to calculated dates in the Implied Billing system. The analysis of this comparison is used to possibly make adjustments to the calculation table in Implied Billing on the mainframe.

The scope of the project is

1.Pull the input files from Windows server to EDW Input area

2.Generate the output files based on provided business key (Combination of Store number, department number, Style number) in input files and keep it in EDW output area

Responsibilities:

Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies

Data model validation to find out the issues in design

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Managed Off shore team to support Onsite – Offshore model

Test plan design and strategies documents for variuos modules

Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.

Writing complex SQL scripts to test the complete functionality

Execution of Datastage jobs through Datastage & Unix

Support for UAT phase

Manage the test process and execution using Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

KT to new members in team

Managing onsite and offshore team and daily activities

Project 8:

Company: Wipro Limited

Client: TJX

Project Name: ECD Canada

Time Period: March 2016 – June 2016

Role: Test Lead

Environment: Netezza, SQL, Datastage

Testing: BI testing, Datawarehosue Testing, MDM

Team Size: 3

Project Description:

The main objective of ECD Canada project is to consume bank token number into sales subject area. Bank token number will be avialable in the DE transactions or off-line transactions. Scope of the project is 1) Existing Tender fact job that is used for all banners using SQL is being kept as is 2) 2 new jobs to update token numbers in tender fact for Canada will be created for 2 inputs - DE input, offline token input 3) DE update job runs as part of existing fact load. The Sequence will be changed to add one more step for Canada banner to update token

Responsibilities:

Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies

Data model validation to find out the issues in design

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Managed Off shore team to support Onsite – Offshore model

Test plan design and strategies documents for variuos modules

Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.

Writing complex SQL scripts to test the complete functionality

Execution of Datastage jobs through Datastage & Unix

Support for UAT phase

Manage the test process and execution using Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

KT to new members in team

Managing onsite and offshore team and daily activities

Project 7:

Company: Wipro Limited

Client: TJX

Project Name: Master Data Authority

Time Period: Feb 2013 – March 2016

Role: Test Lead

Environment: Netezza, SQL, Datastage

Testing: Datawarehosue Testing, BI testing, MDM

Team Size: 8

Project Description:

The main objective of the MDA release is to build Master Data that is sourced from MDM applications that will eventually replace the Legacy as the Source. The data source for Hierarchy Manager – EUR Merchandise is being altered from Legacy (Merchandise system) to MDM Hierarchy Manager and Source for EUR Store data is being replaced from Store catalogue to MDM Sitehub and Supplierhub data is implemented as part of MDA Release. Master data is also maintained in EDW and integrated with several EDW subject areas such as Sales, inventory, pricing etc...

Responsibilities:

Works closely with Business to undestand the functionality of the project for creating the Test Plan and Strategies

Data model validation to find out the issues in design

Testing the Attribute mappings and transformations to test the data quality and data integrity at various stages during data movement

Managed Off shore team to support Onsite – Offshore model

Test plan design and strategies documents for variuos modules

Drafted the Test scenarios and Test Cases in effective way to cover the complete requirements.

Writing complex SQL scripts to test the complete functionality

Execution of Datastage jobs through Datastage & Unix

Support for UAT phase

Manage the test process and execution using Quality Center, generated reports for test coverage analysis

Conduct Defect Triage meeting with Dev & project management team to know the defect status

KT to new members in team

Managing onsite and offshore team and daily activities

Project 6:

Company: Wipro Limited

Client: Microsoft

Project Name: MS MSG SCM BOM RESTRU

Time Period: May 2012 – Dec 2012

Role: Sr.Test Engineer

Environment: MS SQL Server 2008 R2 Database, SQL, SSIS, SSAS, SSRS

Testing: BI testing

Team Size: 6

Project Description:

The BOM Restructuring project is a data modeling and conversion from the current structure of Procurement Bill of Materials (“BOM”) to Manufacturing BOM’s that detail the hardware configuration for eachunique asset tagged device in the GFS Datacenter Environment. All assets will also be remapped to align to the new structure.

Responsibilities:

Requirement Analysis

Technical discussion with Test, Development teams and Project Manager

Draft Test scenarios and Test Cases

Development of Stored Procedures which required in testing and development

Data Modelling Testing by using SQL

Debugging the stored procedures

Conducts Defect Triage meeting with Dev & project management team to know the defect status

Daily updates to the Onsite PM on the progress of the testing.

KT to new members in team

Project 5:

Company: Wipro Limited

Client: Microsoft

Project Name: MS Competancy Map

Time Period: Feb 2012 – May 2012

Role: Sr.Test Engineer

Environment: MS SQL Server 2008 R2 Database, .NET

Testing: Data Migration Testing, Application Testing

Team Size: 5

Project Description:

Wipro MS Competency Academy is to reflect Wipro’s commitment to Microsoft by ensuring continuous learningand development of talent pool. This application is a single stop where we can get over all employees technical, application, domain and functional competencies available across MS account team along with their experience and Suite details.

Responsibilities:

Performed Requirement Analysis to understand the customer requirements

Participated in Database design meetings and reviews

Participated in Application design meetings and reviews

Designed Test Scenarios and test cases to cover the requirement

Involved in technical discussions with Test, Development teams

Conducted Defect Triage meeting with Dev & project management team to know the defect status

Involved in project status tracking

Project 4:

Company: Wipro Limited

Client: Microsoft

Project Name: CRMBIOnline

Time Period: Dec 2010 – Jan 2012

Role: Test Engineer

Environment: MS SQL Server 2008 R2 Database, SSIS, SSAS and SSRS

Testing: Data warehouse Testing, SSRS Report Testing

Team Size: 5

Project Description:

CRM Online BI application aims to establish a tactical business intelligence platform for CRM Online measures that could be used to make educated business decisions around the Microsoft CRM Online product. Microsoft CRM Online combines everyday productivity applications with feature-rich, easy-to-use CRM software that is accessed over the Internet and hosted by Microsoft, providing advanced CRM without a major investment in IT and staffing

Responsibilities:

Perform Requirement Analysis to understand the business requirement

Perform Designing of Test cases from Source to Staging, Staging to Cube and Source to Reports

Perform System Testing, Performance Testing, Regression Testing

Technical discussion with Test, Development and Microsoft Team’s

Update Daily status to the Clients in Daily Stand-up Calls and clarified the doubts if any

UAT and Production support

Debugging the Packages, Jobs as well

Upload test cases into VSTF, executed the test cases and raised the Defects for the same

Defect Tracking

Project 3:

Company: Wipro Limited

Client: Microsoft

Project Name: MS ADCENTER BI & JAZZ

Time Period: July 2010 – Dec 2010

Role: Test Engineer

Environment: MS SQL Server 2008 Database, SQL

Testing: Data Migration Testing, Application Testing

Team Size: 4

Project Description:

MDS is an Enterprise Data Management tool released by Microsoft. It has many features like Version Management, Performance, Permissions can be given at the Hierarchy level etc. Following are the Major activities of this application, 1) Sources Pull 2) Planning Entity/Hierarchy Load Process 3) Custom Entity/Hierarchy Load Process 4) SSRS Reports 5) Data Validation Process 6) Email Notifications

Responsibilities:

Interact with Onsite people over Conference calls

Responsible for the implementation of configuration management

Draft Test scenarios and Test Cases

Review the test cases prepared by other Peer QA Engineers

Involve in Database testing, functionality testing, System testing of the project

Defect logging and Defect follow up in bug tracking tool Team Foundation Server

Involve in Deployment of the builds in SIT and support in UAT and PROD environments

Coordinate with the Project Lead for the new builds

Daily updates to the QA Lead and Project Lead on the progress of the project

Prepare release summary reports/Status

Project 2:

Company: Wipro Limited

Client: Microsoft

Project Name: MSIT BG PA INTEL

Time Period: May 2010 – July 2010

Role: Test Engineer

Environment: MS SQL Server 2008 Database, SSIS, SSAS, SSRS, SQL

Testing: Data Warehouse Testing, SSRS Report Testing

Team Size: 6

Project Description:

PA-Intel is reporting project under BGCOE group of Microsoft. This group is responsible for providing Reports to the business users regarding Product Activation for different products from all the possible Angles. This system pulls data from various source systems into the staging and summary databases Using ETL packages. From this staging/summary database, then reports are generated as per business Requirement. Reports are created directly using SSRS or SSAS cubes are created from which Pivot Reports are created.

Responsibilities:

Requirement Analysis on Outage and KeyWest Modules

Designing of Test cases from Source to Staging, Staging to Cube and Source to Reports

System Testing, Performance Testing, Regression Testing, Rollback Testing & UAT

Technical discussion with Test, Development and Microsoft Team’s

Defect tracking calls

Daily status to the Clients in Daily Stand-up Calls and clarified the doubts if any

Understanding the structure of Applications in source

production support

Project 1:

Company: Wipro Limited

Client: Aircel

Project Name: TRANSFORMATION_CORE_TEST

Time Period: Dec 2008 – Jan 2010

Role: Test Engineer

Environment: Oracle 10g, SQL

Testing: Data Migration Testing

Team Size: 13

Project Description:

Aircel Data Migration ensures Centralize, Integrate and Standardize data from Legacy Applications at Kolkata, Chennai and Coimbatore into COTS suite of products to achieve business objectives, and Meets the defined business and system requirements. The scope of the Data Migration (DM) Project is To migrate the CRM, Billing, OM (CRM) and FMS data from the existing circles into Siebel CRM and Kenan Billing Application. The objective is to present the challenges involved in validation for Attribute / Value mapping and Transformation mapping at Source to Staging and Staging to Target Provided by Development / Siebel / Comverse Teams. It also includes validation for Fallout records From Source to Target.

Responsibilities:

Handling entire Chennai track

Test Attribute Mapping Analysis

Critical Billing-Financial Data Test Case designing

Bill to bill comparison from legacy to target systems

Reconciliation scripts

Technical discussion with extraction team

Defect tracking calls

Production support for ROK and Chennai modules

Daily status to the Clients

Understand the structure of BSCS database and KENAN database



Contact this candidate