In this project, I designed and implemented an optimized SQL-based reporting system aimed at improving the daily trade reports used by corporate bond desk traders at CIBC. The project involved several key steps:
Data Staging and Integration: I created a staging table to temporarily hold transaction data, ensuring accurate and consistent data management before it was integrated into the main database. This included filtering and storing significant Credit Default Swap (CDS) transactions and processing them to retain only the most recent entries for each security.
Consolidation of Bond and Market Information: I merged bond and market data from multiple sources, including bond master records and issuer details, to create a comprehensive dataset that provided a full snapshot of corporate bonds on their most recent trading day.
Incorporating Trader-Specific Data: I integrated specific prices and yields provided by CIBC traders, focusing on end-of-day values. This data was critical for enhancing the final trade reports with trader-specific insights, distinguishing between general market data and CIBC’s internal trading assessments.
Calculating Yield Spreads: I calculated the yield spreads between corporate bonds and their government bond benchmarks, adding these key metrics to the final dataset. This included both general CDS spreads and CIBC-specific spreads, providing valuable insights into market risk assessments.
Final Report Generation: I finalized the trade report by presenting the key elements such as security ID, coupon, maturity, issuer name, market prices, CIBC-specific prices, and calculated spreads, ensuring a clean and accurate presentation of the data.
This project gave me practical experience in SQL-based data management, financial data analysis, and report generation, all within the context of a real-world financial trading environment.