Dhivya M

Client: Roche Malaysia; Role: Test Coordinator / Lead.

• Co ordinating QA testing Team and working closely with scrum team members, Business stakeholders and solution architects to understand the project scope
• Good experience in working with Agile methodology (Scrum, Kanban). Currently working on Scrum.
• Responsible for Finalizing the Testing Scope based on the story /Change Request / Incident Task
• Responsible for co ordinating a team and resolving issues / obstacles with Iteration task/allocation/testing
• Responsible for Creating automation test strategy /Test suite to create /review and execute complex SQL script through pyspark framework and review python scripts to verify and validate data across multiple stages / layers within AWS
• Responsible for validating the Customer Master data (MDM) received from IQVIA and validate from sftp and processed through various layers in data hub and flow through various downstream including salesforce
• Creating Athena automation test suite to validate certain layers of data in AWS where data stored on athena tables
• Responsible for validating the Initial and Incremental data loads to ensure the data quality, Integrity and latency has been met as per the requirement and ETL Mapping documents
• Responsible for data quality, such as file validation, data validation, business rules validation between the source and target systems, golden record validation, functional validation, and audit tables or flat files validation.
• Responsible for system testing, integration E2E testing, and regression testing using an automation framework to validate across stages in AWS.
• Participate in Agile ceremonies (PI Planning, Daily Scrum, Sprint Review, Sprint Backlog Refinement, and Retrospective).

Client: Sun Life Malaysia; Role: UAT Test Coordinator.

• Worked in an Agile (SCRUM) methodology.
• Worked in the insurance domain on validating the proposal form, sales illustration, and customer fact find.
• Coordinating with different teams as part of UAT validation, such as the Pricing Team, Product Team, and Underwriting Team.
• Validating the sales data before production deployment.
• Client/Stakeholder Management and Issue Resolution.
• Planned test schedules in accordance with project scope and delivery deadlines.
• Interacted with customers and internal stakeholders to ensure a complete and thorough understanding of all requirements.

Client: Nielsen Malaysia, Role: Senior ETL Test Engineer.

• Worked as an individual contributor and SPOC in the testing environment.
• Developed ETL test scripts based on technical specifications, data design documents, and source-to-target mappings.
• Extensively tested several Business Objects reports and dashboards to validate the reports, the data, and the cosmetics of the report.
• Performed count validation, dimensional analysis, statistical analysis, and data quality validation as per data mapping in data migration.
• Validate the full load and delta load in the Staging DB, and perform data validation.
• Involved in loading data into the target system, where I identify the gap between the source data and the loaded data in the target.
• Worked on the production data migration activity for moving the data into the cloud environment.
• Data handling on a big scale and managing to handle data from different countries at the same time.
• Developed complex SQL queries for querying data against different databases for the data verification process.
• Spool data from tables into files as part of post-validation of loading and verifying the data sync.
• Tested a number of complex ETL mappings, and reusable transformations for daily data loads.
• Client/Stakeholder Management and Issue Resolution.
• Planned and strategized test schedules in accordance with project scope and delivery deadlines.
• Worked on issues with the migration of data from the development to the QA test environment.
• Interacted with customers and internal stakeholders to ensure a complete and thorough understanding of all requirements.

Client Best Buy Europe- Infosys iEngage Apparel and Infosys Telco Platform

• Designed the test scenarios as per the business requirements and mapping documents.
• Profiling the data using Talend and PostgreSQL.
• Responsible for verifying the data movement between Talend and the database server, and verifying that the data has been pushed to the respective Datamart schema by using PostgreSQL.
• Validation rules, as per the requirements in different cases,
• Acquired knowledge in complex SQL scenarios.
• Involved in end to end testing and in different stages of the project Understand the transformation rules and create test cases based on the business requirement
• Involved in generating various reports from pentaho tool
• Involved in FTP processing the test data file in the local servers using PUTTY(unix commands) and File zilla
• Reporting the defects using TFS Bug Validation and setting a defect triage call with the development and BA leads for bug validation
• Worked independently as a single point of contact from the testing team for Web Analytics testing using the Insight Infosys tool.
• Involved in batch testing and real-time integration testing.
• Involved in customizing the website using the Hybris management console.
• Preparing and sharing various status reports, which include the daily status report, defect report, test completion report, and project sign-off report, to all the project stakeholders.