Akash Pandya

Summer 2026

• Remediated 11 SQL injection vulnerabilities across 10 production components and 3 core data services using PostgreSQL and DBeaver, executing 40+ live database tests and resolving 3 additional critical functional regressions.
• Built a production Trade Information Warehouse (TIW) retrieval pipeline, indexing hundreds of settlement documents for vector-based semantic search with typical chatbot responses under 1 minute.

Summer 2025

• Supported migration of legacy Funds Only Settlement web components into DTCC's Real-Time Trade Matching application, improving application reliability and maintainability.
• Shipped 8+ Angular UI components and Java/Spring Boot REST APIs while maintaining 90% unit test coverage and resolving Jenkins CI/CD build failures.

Summer 2024

• Automated KPI test-result aggregation using SPL, eliminating 2+ hours of manual reporting per week and enabling more frequent performance monitoring.
• Streamlined Global Trade Repository alert analysis using SPL, reducing alert response time by 30% and generating automated daily reports for the Alerts Team.

• Evaluated free and commercial data sources for an AI-driven data marketplace platform to inform integration strategy.
• Explored machine learning approaches for automated data quality assessment using metadata coverage, freshness, and uniqueness signals.
• Analyzed 10+ data marketplaces across pricing models, product capabilities, and AI features to prioritize roadmap direction.