Arun Mallanagoudra

• Create and execute database queries in order to test the underlying data for interactions of tableau reports.
• Created and executed SQL scripts for database and tableau report testing using MySQL, Oracle SQL, Snowflake DB and tableau.
• Led a team of quality engineers to complete a major quality assurance project on time
• Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs.
• Work independently between QA, Development & DBA teams to test the data migration.
• Identify and document data abnormalities then work with development to resolve issues
• Use customer data & feeds to perform root cause analysis accurately reporting on results
• Enter and query defects in defect tracking database and generate test cases providing meaningful acceptance criteria in tracking database as necessary in Jira tool.

• Created test cases that covered all functional requirements and ensured product quality
• Involved in QA estimations for test plan (FE + BE) and taking detailed tech sessions
• Test case execution in both (FE + BE) and Regression testing on Front End and executed functional test cases in SIT environment.
• Developed SQL queries and test procedures based on the test requirements and validate the data.
• Defects tracking and raising for the improvements in JIRA for both SIT/UAT environment
• Sanity checking in FE and BE for the project Go-Live activities, Analyzing and reporting PROD issues in ASPEN
• Report defects in JIRA and ensure problem resolution is communicated in a timely and effective manner between Developers, QA lead and Project Manager.
• Documented Errors and Implemented their resolutions.
• Providing the System Testing Sign-off after validation.
• Utilized Confluence Page for Requirement understanding.
• Led the team in the data separation project between Adidas and Reebok.

This project is Brand Shielding the data of adidas and Reebok in database & in SharePoint.

• Analyzing the requirements through Functional specifications (Confluence) and Business rules.
• Prepared Test Plan and Test cases.
• Executed Test cases and gathered test Execution results.
• Tested the Functionality of the reports through manual testing.
• Developed SQL queries and test procedures based on the test requirements.
• Created test cases manually for Function testing based on functional areas and used test case documents.
• Performed Front end testing using MicroStrategy – MSTR
• Performed Back-end testing using SQL queries to test the data in databases.
• Performed Sanity, Smoke, Functional test in SIT & UAT environments.
• Providing the System Testing Sign-off after validation.

This assignment is for creating Data Lake for the client by loading the data from RDBMS sources like PostgreSQL and MySQL to Database Environment by using Airflow jobs and storing the same in AWS S3 folders.

• Loading the data from RDBMS sources like PostgreSQL and MySQL to database Environment by using Airflow jobs and storing the same in AWS S3 folders.
• Testing and validating data present in the Data base by comparing it with RDS data.
• Data Validating by using AWS Athena / using SQL queries in CLI
• Testing functionality of build and verifying partitions created in S3 storage.
• Regression testing for verifying new functionality with old existing code
• If any Bugs found during the testing will be raised to concerned developers by sharing the logs produced during the job and tracking the same using Jira.
• Following and interacting with Dev folks in mitigating the bugs raised.
• Involved in Daily stand ups with team and Client meetings if required