Navathej Gowd Marupakula

• Having 4 years 6 months of Experience in ETL Testing; 2+ years of Experience in Tableau Desktop and Tableau Server; and 8 years of Experience in Financial Data Services sector.
• Strong in SQL, Tableau Desktop and Tableau Server.
• Good knowledge on Data Warehouse and ETL process.
• Experienced on waterfall and Agile Methodologies.
• Experienced in Integration Testing, Regression Testing of various applications.
• Well acquainted with Software Test Life Cycle.
• Involved in writing Test cases and executing the test cases.
• Involved in Functional, Integration, System, Smoke and Sanity Testing.
• Extensive experience in Black Box Testing.
• Experience in Tableau in creating filters, Quick Filters, Table Calculations and Parameters.
• Experience in working on Individual Axis, Axis Blending, and Dual axis.
• Merged multiple data sources by joining multiple tables and using data blending.
• Developed Reports Using various reporting objects like Actions, Hierarchies, Calculated fields, Sets, Groups, Filters, Parameters, Legends etc., in Tableau Desktop.
• Experience in Creation of Data Visualizations, Reports and Dashboards.
• Having good knowledge to create Maps and customized charts.
• Experience in publishing Tableau dashboard on Tableau Server.
• Experience in creating User Groups and Adding Users to groups.
• Committed, result oriented, and interested to learn new technologies.
• Innovative mind and Interest in learning new concepts, skills and implementing.
• Good experience in Test Case Development and Execution.
• Effective in Defect tracking and Bug Reporting in Bug Tracking tool.
• Hard working, Self-directed individual and have always demonstrated a good record of completing projects with high quality and on schedule.

Project # 4

Project Name : Scotiabank

Client             : The Bank of Nova Scotia, Canada

Environment  : Oracle 10g, Informatica 8.6, Tableau 10.x, windows XP

Role               : Software Test Engineer

Description    : The Bank of Nova Scotia (French: Banque de Nouvelle-Écosse), operating as Scotiabank, is a Canadian multinational banking and financial services company headquartered in Toronto, Ontario. One of Canada's Big Five banks, it is the third-largest Canadian bank by deposits and market capitalization. In 2023, the company’s seat in Forbes Global 2000 was 88. It serves more than 25 million customers around the world and offers a range of products and services including personal and commercial banking, wealth management, corporate and investment banking. With more than 92,001 employees and assets of Can$1,136 billion (according to 2020 annual report), Scotiabank trades on the Toronto (TSX: BNS) and New York (NYSE: BNS) exchanges.

Responsibilities:

• Involved in functional study of the application.
• Involved in writing Test Plan.
• Running the Jobs/Workflow for ETL process.
• Prepared and ran SQL queries to verify Dimensional and Fact tables.
• Verifying the data in target database after ETL process.
• Performed column data mapping between source & target database.
• Prepared test data for testing.
• Verifying the data which is loaded into target database.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.
• Developed, Reviewed & Executed Test Scripts and Designed test data.
• Identified Test Scripts for Regression testing.
• Defect Analyzing and Reporting in QC.
• Created Filters, Groups, Sets on Tableau Reports.
• Implemented Blending concepts in my Tableau Reports.
• Created Parameters to achieve desired functionality.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Scheduled extract refresh for weekly and monthly reports and Worked on workbook Permissions, Ownerships, and User filters.

Project # 3

Project Name : W&S

Client             : Western & Southern Financial Group, USA

Environment  : Oracle 10g, Informatica, Tableau 10.x, windows XP

Role               : Software Test Engineer

Description    : Western & Southern Financial Group, also commonly referred to as Western & Southern, is a Cincinnati, Ohio-based diversified company of financial services subsidiaries with $111.6 billion in assets owned and managed as of December 2021. As of 2022, it held a "AA- Very Strong" rating from Standard & Poor's, a "A+ Superior" from A.M. Best, a "AA Very Strong" from Fitch, a "Aa3 Excellent" from Moody's, and a "96 out of 100" Comdex ranking. Through its subsidiaries, Western & Southern offers a variety of financial services, such as life insurance, annuities, mutual funds and investment management.

Responsibilities:

• Understanding various Business requirements.
• Involved in writing Test Plan.
• Interactions with BA & Dev teams to resolve the issues.
• Developed, Reviewed & Executed Test Scripts and Designed test data.
• Prepared test data for testing.
• Prepared and ran sql queries to verify Dimensional and Fact tables.
• Verifying the data in target database after ETL process.
• Verifying the data which is loaded into target database.
• Reporting daily testing status report.
• Defect Analyzing and Reporting in QC.
• End to end experience in designing and deploying data visualizations using Tableau.
• Created and modified some of the existing reports and dashboards.
• Implemented Blending concepts in my Tableau Reports.
• Worked on Dual Axis concept while working with reports.
• Publishing sheets and dashboards on server Using Tableau Desktop.

Project # 2

Project Name : WRB Corp.

Client             : W. R. Berkley Corporation, USA

Environment  : ASP.net, SQL Server, Quality Center

Role                : Software Test Engineer

Description   : W. R. Berkley Corporation is a commercial lines property & casualty insurance holding company organized in Delaware and based in Greenwich, Connecticut. The company operates commercial insurance businesses in the United Kingdom, Continental Europe, South America, Canada, Mexico, Scandinavia, Asia and Australia; and reinsurance businesses in the United States, United Kingdom, Continental Europe, Australia, the Asia-Pacific region and South Africa.

Responsibilities:

• Involved in functional study of the application.
• Involved in writing Test Plan.
• Developed, Reviewed & Executed Test Scripts and Designed test data.
• Interactions with BA & Dev teams to resolve the issues.
• Involved in test case Development based on user stories.
• Involved in test case execution.
• Identified Test Scripts for Regression testing.
• Defect Analyzing and Reporting in QC.

Project # 1

Project Name  : Pace plc

Client              : Pace plc, UK

Technology     : PHP, HTML, JQuery

Role                : Associate Test Engineer

Description     : The company was founded by Yorkshire born businessmen Barry Rubery, David Hood and Robert Fleming in 1982, taking the name Pace Micro Supplies in 1983, eventually being renamed to Pace Micro Technology plc in 1987. It introduced the first low cost commercially available modems in 1985. In 1987, it started selling its first analogue satellite set top receivers. In 1996, it introduced the world's first DVB decoders, for Australian satellite company Galaxy.

Responsibilities:

• Understanding the software requirements.
• Knowing how the end user will use the application.
• Creating test cases from the user stories or from test scenarios.
• Interactions with BA & Dev teams to resolve the issues.
• Execute the test cases.
• Reporting daily testing status report.
• Defect Analyzing and Reporting in QC.
• Perform the task again where the defect was found to make sure that the application is defect free.
• Send the test reports to the test lead.