RBC Investor & Treasury Services (RBC I&TS) is a specialist provider of asset services, custody, payments and treasury and market services for financial and other institutional investors worldwide, with over 4,500 employees in 16 countries across North America, Europe and Asia. We deliver services which safeguard client assets, underpinned by client-centric digital solutions which continue to be enhanced and evolved in line with our clients’ changing needs. We have over 120 years of history in providing investor and treasury services and are trusted with CAD 4.5 trillion in client assets under administration.I am responsible for designing and developing IBOR controls by using Alteryx. This includes testing and validation of data flows within RBC record keeping systems to ensure it conforms to the business requirements. I perform data extraction, loading, data cleaning, data preparation, analyse, interpret data and create a mapping specification between source and target systems. I am also responsible for managing and resolving any exceptions generated by these workflows on a daily basis. This role requires a strong understanding of RBC system architecture ranging from trade matching, trade capture, accounting record keeping system, FX to trade settlement systems.More recently, my role has been expanded to include trade management oversight function where I act as an escalation point for trade issues and to provide effective resolution in a timely manner. I always strive to provide excellent service delivery to our clients, while managing and maintaining relationship with third party providers including brokers, custodians and market participants.

I was part of a dedicated global business team working with SSC IT, Client Service, and the Business Operations teams to ensure accurate end-to-end oversight of Information Delivery to our clients within the Operational Control Framework (OCF). As an SME on the Enterprise Service Platform (ESP), I provided support and provide analysis for items impacting the Enterprise processes and Operating Models. This role required an excellent technical ability in data modelling and SQL including a strong product knowledge in Equity, Fixed Income, OTC, FX and Derivatives.

My main responsibility is to provide liquidity analysis, exposure analysis and implementation recommendations for Russell Equity, Fixed Income and Multi Assets portfolios in APAC region. The role involves directed trading for multi-asset portfolios with real-time facilitation with internal and external stakeholders.

• Responsible for coordinating major transitional events such as client onboarding and outgoing, product launches and closures.• Allocate daily clients and inter-fund cashflow in accordance to their Strategic Asset Allocation (SAA) as determined by portfolio managers• Provide trade instructions including FX, special spreads, rebates, switches and cash transfers to custodian for processing.• Reconciliation of daily data download from custodian, and resolve any issues on incomplete or erroneous data.• Improve the in-house transaction system, provide upgrade specification and system testing prior to any upgrades being rolled into production.• Provide supervision and training to junior team members

Responsibilities include processing daily cash flows, cash management and rebalancing over 150 RIML Fund of Funds (FOFs) and clients' portfolios according to their strategic asset allocation. I was also responsible for client account opening and maintenance, instructing our custodians to execute various FX trades and manual spread trades.