• Validated regulatory capital allocations and lending profitability hurdles for term loans and revolving credit facilities exceeding $50bn by applying Basel FIRB and AIRB credit risk models to drive high-quality credit commitment decisions while ensuring transparency in RBC's adherence to internal risk mitigation policies and OSFI's requirements at the deal level• Presented weekly updates on changes to RBC's Corporate Loan Portfolio exposures with regards to new borrowers, credit… Show more • Validated regulatory capital allocations and lending profitability hurdles for term loans and revolving credit facilities exceeding $50bn by applying Basel FIRB and AIRB credit risk models to drive high-quality credit commitment decisions while ensuring transparency in RBC's adherence to internal risk mitigation policies and OSFI's requirements at the deal level• Presented weekly updates on changes to RBC's Corporate Loan Portfolio exposures with regards to new borrowers, credit issued, outstanding balance, and credit rating changes while highlighting the underlying drivers to justify the impacts on RBC’s risk-weighted assets to senior managers• Managed the delivery of enterprise risk and regulatory compliance reports for OSFI and supported cross-functional teams in reviewing loan portfolio summaries and snapshots to ensure accurate reporting amid a rate-hiking cycle• Participated in fireside chats as a speaker to foster better understanding of RBC’s credit risk mitigation initiatives among employees within its Corporate Banking division, reducing the volume of technical inquiries received by the team by 50% Show less

• Worked closely with the client reporting team in the quantitative management division on a monthly basis to automate the retrieval of revised pension balances, investment allocations, and hedging positions to help fulfill reporting cycles in a timely manner• Supported the financial engineering team to decommission an Azure SQL database by validating the migration of its batch data processes to a new database server, reducing long-term database licensing costs for the… Show more • Worked closely with the client reporting team in the quantitative management division on a monthly basis to automate the retrieval of revised pension balances, investment allocations, and hedging positions to help fulfill reporting cycles in a timely manner• Supported the financial engineering team to decommission an Azure SQL database by validating the migration of its batch data processes to a new database server, reducing long-term database licensing costs for the firm• Created a MATLAB program that automated the mean-variance optimization of performance statistics for a given retail portfolio and shortened the time needed for portfolio specialists to complete this task down to 10% of its original time Show less

• Sourced portfolio performance data from Factset, Morningstar, Sylvan, and Manulife's Investment Data Lake to fulfill requested portfolio and benchmark reports to support portfolio managers' day-to-day market analyses• Streamlined the generation and delivery of daily investment performance reports to various portfolio managers for monitoring purposes using VBA and Power BI, reducing the Investment Analytics team's manual reporting workload by 2 hours each day

• Enhanced the quality of management reporting across the brokerage by creating Power BI dashboards that visualized sales, marketing and retention KPI metrics over dynamic time horizons

• Helped prepare fact sheets of the firm's construction mortgages to secure further funding from prospect investors in the private credit market• Fulfilled weekly bookeeping tasks to update operational income balances generated by the firm's real estate assets• Conducted research on Toronto's multi-unit residential real estate market to highlight investment opportunities that align with the firm's risk profile by size and cap rate

• Supported engineers with the storage and retrieval of automotive components for testing purposes and completed quality assurance documents to verify their specifications• Increased the firm's inventory transparency by completing storage and inventory database entry tasks in a timely manner