Etl test lead, sql, datastage, netezza, Oracle, ssis, ssrs, cognos, TM
Resume:
Mahesh Goud Thirmandas ******.***@*****.***
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