• Conducted rigorous market research and analysis to identify quality properties for clients, leading to successful investments and building portfolio.• Leveraged data analysis skills to analyze risks and opportunities, ensuring client needs were always met with clear communication.• Collaborated with clients to understand their goals and provide tailored property recommendations based on market insights.

• Managed data warehouse enhancements and defects for EY Analytics in Melbourne, Australia• Provided leadership and guidance on quality standards and testing best practices• Coordinated with stakeholders to report, track, and close deliverables• Organized defect triages and tracked them to closure

¬ Worked for one of the largest banks in Australia¬ Review the Business and functional requirement documents¬ Create TSD (Test Scope Document) for Effort Estimation and Scope from application testing point of view ¬ Prepare and Review the Master Test Plan for the different projects under the define testing methodologies and different types of testing to be undertaken by the project like ST, SIT and UAT phases ¬ Prepare and Review requirements traceability matrices for testing ¬ Involve in developing test cases and test harnesses based on high-level and detailed designs. Authored Test Cases to include prerequisites, detailed directions and descriptions of the anticipated outcome.¬ Organize and Participate in Test Case walkthroughs, MTP walkthroughs and inspection meetings.¬ Coordinating with the environment services for the availability of appropriate test environment¬ Extensively perform System testing, requirements verification testing, Progression, Regression, Performance testing, Mostly in Data warehouse-ETL Testing, user acceptance testing (UAT), Risk Based testing.¬ Weekly status meeting with the client side Project Manager to report and discuss testing status in terms of scope, schedule, quality, risks, issues, dependencies and any change requests.¬ Prepare PDU (production data usage) for multiple projects for testing¬ Perform back-end testing and verified the data from source to ORACLE data warehouse and from ORACLE data-warehouse to Business reports.¬ Verify the data stored in the database with the help of SQL queries using TOAD, SQL Developer¬ Designed strong SQL/PLSQL queries for data validation¬ Interact and work closely with the development team to solve the problems encountered in the test scenario run.¬ Job verification, Validations using Informatica ETL tool¬ Execute UNIX batch jobs and mainframe jobs to populate database tables from Source system using Control–M¬ Support UAT team to prepare test case, test data and verification.

¬ Worked for one of the largest banks in Australia¬ Review the Business and functional requirement documents¬ Involve in developing test cases and test harnesses based on high-level and detailed designs. Authored Test Cases to include prerequisites, detailed directions and descriptions of the anticipated outcome.¬ Organize and Participate in Test Case walkthroughs, MTP walkthroughs and inspection meetings.¬ Coordinating with the environment services for the availability of appropriate test environment¬ Extensively perform System testing, requirements verification testing, Progression, Regression, Performance testing, Mostly in Data warehouse-ETL Testing, user acceptance testing (UAT), Risk Based testing.¬ Weekly status meeting with the client side Project Manager to report and discuss testing status in terms of scope, schedule, quality, risks, issues, dependencies and any change requests.¬ Perform back-end testing and verified the data from source to ORACLE data warehouse and from ORACLE data-warehouse to Business reports.¬ Verify the data stored in the database with the help of SQL queries using TOAD, SQL Developer¬ Designed strong SQL/PLSQL queries for data validation¬ Interact and work closely with the development team to solve the problems encountered in the test scenario run.¬ Job verification, Validations using Informatica ETL tool¬ Execute UNIX batch jobs and mainframe jobs to populate database tables from Source system using Control–M

¬ Review the Business and functional requirement documents¬ Prepare and review the Master Test Plan for the various projects under the defined testing methodologies and different types of testing to be undertaken by the project like ST, SIT and UAT phases.¬ Work on different methodologies like WATERFALL.¬ Extensively perform Data warehouse/ETL/DWBI testing, Requirements Verification Testing, Functional, Regression, User acceptance Testing (UAT), Risk Based Testing. ¬ Weekly status meeting with client manager to report progress and discuss testing issues in terms of scope, schedule, quality, risks, issues, dependencies and any upcoming change requests.¬ Interact and work closely with the Technology and business teams to resolves the issues or problems encountered during testing.¬ Participate in daily stand up meetings to provide regular updates on progress to project team.¬ Involved in requirement analysis to develop test cases and test harnesses based on high-level and detailed-level designs.¬ Organize and take ownership of test case walkthroughs and inspection meetings.¬ Coordinating with the environment services for engaging appropriate test environment till project closure.¬ Regular interaction with the team to check the progress and address their concerns and resolve them.¬ Provide updates to higher management on testing status and any issues encountered.¬ Expertise in Data warehouse concepts¬ Expertise in Data Models¬ Extensively involved and performed Test Execution.¬ Good Knowledge on Informatica -The ETL Tool to analyze and run the workflows/jobs ¬ Worked on error analysis/data analysis and data load.¬ Usage of unix scripts and commands during Test Execution.¬ Perform data Validation with the help of SQL queries using Oracle SQL Developer, TOAD.¬ Support business UAT teams to prepare test cases, test data as required and data validation.¬ Prepare knowledge transition documents for all the projects

¬ Review the Business and functional requirement documents¬ Responsible for gathering requirements from Subject Matter Expert (SME).¬ Prepare and review Requirements Traceability Matrices for testing.¬ Work on different methodologies like WATERFALL, Agile.¬ Extensively perform Data warehouse/ETL/DWBI testing, Requirements Verification Testing, Functional, Regression, User acceptance Testing (UAT), Risk Based Testing. ¬ Weekly status meeting with client manager to report progress and discuss testing issues in terms of scope, schedule, quality, risks, issues, dependencies and any upcoming change requests.¬ Participate in daily stand up meetings to provide regular updates on progress to project team.¬ Involved in requirement analysis to develop test cases and test harnesses based on high-level and detailed-level designs.¬ Organize and take ownership of test case walkthroughs and inspection meetings.¬ Coordinating with the environment services for engaging appropriate test environment till project closure.¬ Provide updates to higher management on testing status and any issues encountered.¬ Expertise in Data warehouse concepts¬ Expertise in Data Models¬ Extensively involved and performed Test Execution.¬ Good Knowledge on Datastage -The ETL Tool to analyze and run the Jobs ¬ Worked on error analysis/data analysis and data load.¬ Usage of unix scripts and commands during Test Execution.¬ Perform data Validation with the help of SQL queries using Oracle SQL Developer, TOAD.¬ Prepare knowledge transition documents for all the projects