• Engineer and optimize advanced SQL queries to extract, aggregate, and validate loan-level data from database across ABS transactions, supporting high-frequency analysis and disclosure accuracy
• Conduct cross-platform data reconciliation between Bloomberg and SEC filings by standardizing inconsistent field naming conventions using Python and Excel, significantly improving data alignment and reliability for RMBS and CMBS research workflows