GOWTHAMI KOTHA

This project focused on building an enterprise workflow to manage the exchange of portfolio data and analytics reports between internal investment platforms and MSCI risk and reporting systems. It was designed to support flexible data ingestion, configurable portfolio and report settings, regulatory data traceability, reconciliation, reruns, backfills, ad hoc requests, and high-volume processing across multiple portfolio, benchmark, and reporting scenarios.

• Conducted system integration and regression testing, ensuring stable, defect-free software releases.
• Automated testing processes using GitHub Copilot, Playwright, and a Python BDD framework, enhancing coverage and execution speed.
• Collaborated with clients and project managers to ensure timely delivery of quality releases.
• Evaluated business requirements and provided technical solution recommendations based on feasibility.
• Prepared comprehensive test plans and strategies to define scope, approach, and quality objectives.
• Documented defects and coordinated with teams for prompt resolution, maintaining project timelines.
• Compiled test closure reports to validate client requirements and confirm fulfilment.

• Designed SQL queries for data warehousing projects.
• Conducted ETL testing and performed DAG testing in Airflow.
• Scheduled jobs in Airflow to ensure timely execution.
• Developed scripts and code according to project requirements.
• Utilised AWS Athena for data analysis and reporting.
• Managed workflows using JIRA within Agile methodologies.
• Delivered services to clients with a focus on quality and efficiency.

• Conducted functionality tests on web applications to ensure quality standards.
• Applied deep knowledge of business requirements to inform testing strategies.
• Employed agile methodology for effective bug-tracking and regression testing.
• Utilised Selenium and IntelliJ tools for automation processes.