LAKSHMINARAYANA DARISIGUNTLA

Project: Datawarehouse 2 implementation

• Led Data QA testing team.
• Attended daily data squad stand up call to review user stories and update daily task status.
• Test Strategy and Test plan being prepared for Datawarehouse Testing.
• Understood project architecture and proposed Data model to understand data flow.
• Gone through source and target data dictionaries to understand data definitions.
• Created Test scenarios/Test cases by going through data pipeline mapping sheets.
• Test execution by running ADF pipelines and validating data b/n source and target by using inhouse data comparison tool.
• Logged defects in JIRA and arrange defect triage calls with developers based on needs.
• Making sure all testing artifacts like test cases, Test execution and results are stored in JIRA.
• Prepared Test closure reports.

Project: DB and OS upgrade

• Led Data Migration testing team.
• Prepared Test Strategy and Test plan for the DB upgrade and Data migration project.
• Requirement analysis based on DB upgrade and Migration Solution design and architecture documents.
• Test design which includes test scenarios identification and test case creation.
• Test execution by confirming data extracts from source and Target systems using data comparison tools.
• Data reconciliation across source and Target
• Overall test management and defect logging and tracking in TFS.
• Coordinated Daily Defect Triage Meetings with client and vendor as needed for Reporting, Root-Cause discussions and tracking to Closure.
• Make sure all test deliverables meet timelines as per project plan.
• Daily and Weekly status updates on internal and customer management.
• Co-ordinate UAT along with business users.

Project: T24 upgrade from R16 to R18

• Prepared Test Strategy and Test plan for the Data migration project.
• Requirement analysis based on T24 R18 data migration mapping sheets.
• Test design which includes test scenarios identification and test case creation.
• Test execution by validating data extracts from source and Target systems using data comparison tools.
• Defect logging and tracking in JIRA.
• Coordinate Daily Defect Triage Meetings as needed to do the Reporting, Root-Cause discussions and tracking to Closure.

Project: Enterprise Datawarehouse implementation

• Led ETL Testing team
• Prepared Test Strategy and Test plan for the EDW project.
• Initiated new approach for ETL Test case preparation by analyzing Logical data model, physical data model, solution design and mapping documents against requirements.
• Supplied communication to management on the overall status of test case preparation and test execution.
• Coordinated with Deployment Manager and DBA to make sure Test environment databases are ready for testing (Data Refresh during each iteration).
• Coordinated Daily Defect Triage Meetings as needed for the Reporting, Root-Cause discussions and tracking to Closure.
• Supplied Daily/Weekly Status Report to Project Manager during Test Preparation and Test Execution Phases.

Project: Master Data Management - Customer Data Integration

• Collected information for different applications by interviewing users or through walkthroughs and share knowledge with offshore team.
• Worked with the Test Manager at Customer site for Test Project Planning and Tracking.
• Collaborated with Customer’s Subject Matter Experts for various applications to find critical test scenarios, and to clarify requirements.
• Ensure that Quality of testing deliverables from Offshore Testing Team. Review and certify the testing artifacts for the project during the QA signoff.
• Collect data set up details for specific applications and or getting production data to QA or populating user specific data in QA environment.
• Test design by analyzing Logical data model, physical data model, solution design and mapping documents against requirements.
• Test execution by running ETL batch jobs through putty and verifying the Database using SQL and in-house data comparison tools.
• Defect logging and tracking in HP Quality center.
• Collaborated with Customer’s Business Groups for MDM Customer Data Integration Project and coordinated and supplied support to the Business Group during User Acceptance Testing for Testing and Sign-Off.