Krishna Chaitanya Lakkur Muralidhar

Coordinating with Client, Tech Leads, Business Analyst and Offshore team from Onsite to gather the requirements, understand the business expectations and supervise the offshore team to accomplish the Iteration testing goals.
Gather new requirements for different applications, drawing out a plan for Testing of the enhancements for the applications requested by the users and planning work for offshore team members
Perform ETL testing for Data Warehouse application enhancements as per given complex Business rules
Prepare the Test Plan, review with the team and follow up for reviews and comments
Responsible for reviewing every work done by Offshore team (test cases, Queries, validation logs, defects raised by team, etc)
Automating, Scheduling and running Data Warehouse ETL jobs using Autosys and Batch script files
Owning Build and Deployment of Release enhancements into Production using Jenkins
Identify areas for automation and come up with automation feasibility analysis
Design Test Automation strategies and frameworks and customize it as per the application testing requirements
Automate ETL validations using Python, SQL
Participate in daily meetings happening at Onshore and discuss about upcoming milestones, bring up the issues / risks foreseen if any and follow up for the resolutions and pass the updates to offshore team
Providing Plan estimates for the User stories.
Overseeing the smooth execution of the new functionalities as Onshore Coordinator
Follow up on escalations and issues with clients
Addressing and testing critical customer defects
Ensure all deliverables are met on time across all phases right from Requirements gathering till Test closure.
Reviewing work products from offshore - Interacting and coordinating with the offshore team
Participate in the stand-up call to update the status and discuss the issues if any.

Leading the offshore team and ensure all deliverables are met on time across all phases of testing right from Requirements gathering till Test closure.
Reviewing Test plan and identification of Test scenarios for Integration Testing
Responsible for reviewing every work done by Offshore team (test cases, Queries, validation logs, defects raised by team,.. etc)
Identifying validations that could be automated and come up with the action plan for developing the QTP script for the same by conducting discussions with the automation resources in the team
Came up with the automation initiative to optimize the Production checkout ETL validations by merging the queries and making them run through the automation suite. This automation approach significantly reduced the QA manual efforts from 10 hours to 2 hours
Providing testing estimates for the test items.
Creating Test Execution Metrics to report the SIT Status Day to day.
Co-ordinate with Onsite counterpart and lead the daily status calls and discuss about upcoming milestones, bring up the issues / risks foreseen if any and follow up for the resolutions.
Participate in the daily stand-up call to update the status and discuss the issues if any.
Following up on defects raised by team until closure.
Preparation of KT plan for newly joined resources in the Team.
Mentored the newly joined resources about Agile Testing practices
Owning the process activities Defects leakage prevention and Senior Management Review

Involved in Requirement & Understanding phases across all Releases
Involved in providing testing estimates for the test items.
Involved in creating Test plan.
Preparation of Test Cases and execution query.
Involved in running the Informatica session and monitoring it.
Identified the Test scenarios for Integration Testing
Executed Oracle and Teradata SQL test queries to validate Referential Integrity between tables for each subject area across all phases of Data Movement.
Responsible for reviewing every work done by System testing team (test cases, validation logs, defects raised by team and etc)
Logged all defects in ALM that were encountered during manual validation and followed up until closure
Attending daily status call to discuss the issues and to update the status.
Created Daily Dashboard in ALM to report the SIT Status Day to day.

Understanding the functionality using the Functional Specification Documents, Data Model, Data Mapping Specifications and Low-level design and raising clarifications present if any in the clarification tracker and response updating through discussions with Onsite.
Preparation of Test Cases by decomposing of requirements into testable functions, Execution templates to validate the accurate Upload of data from listed source systems (Core & Transactional data) through verification of data in the staging area and Query (taking in to consideration the transformation logics if any) for extraction of Data to feed the execution Templates.
Preparation of queries for reconciliation of Data from source to target based on the Quantitative testing approach.
Completion of planning effectively with good quality of Test wares.
Day Zero verification with a checklist to ensure the expected resources to be in place in the test environment for start of test execution.
Executing the test cases with proper sampling data meeting all the required scenarios of different permutations and combinations.
Preparing defect report and tracking defects till closure.
Reconciling the production data for 30 days after GO - LIVE of every release.