Skip to main content
SH
Looking for a job

Shin Rung Hao

@shinrunghao

Data business analyst at Healthcare of Ontario Pension Plan, documenting SailPoint SSO implementation and Qlik SaaS migration.

Canada
Message

At Healthcare of Ontario Pension Plan, I’m the lead business analyst on a SailPoint SSO application implementation, documenting work through Azure DevOps and Microsoft SharePoint. I also authored business requirements and functional design specifications for a Qlik SaaS migration pilot that ported six critical reports.

At TD Securities, I documented user stories for three end-user groups during the Loanet-to-Equilend migration for equity repo functionalities and post-trade processing.

At Scotiabank, I documented critical business services and reviewed continuity plans with Global Capital Markets and Corporate & Investment Banking. I also implemented a Key Risk Indicators process using Salesforce Fusion technology.

At CPP Investments, I used SQL, Python, and Excel for attribution analysis across data covering over $500B in assets under management. I also helped build data pipelines and integrate systems, reducing data discrepancy incidents by 95%; during a secondment, I created Tableau dashboards that reduced manual reporting time by 30%.

Experience

Work history, roles, and key accomplishments

Healthcare of Ontario Pension Plan logoHP
Current

Consultant, Data, Data Technology Solutions

Jan 2026 - Present (10 months)

Lead business analyst on SailPoint SSO application implementation, logging documentation through Azure DevOps and Microsoft SharePoint, coordinating testing timelines. Authored Business Requirement Document and Functional Design Specifications for the Qlik SaaS migration project, ensuring alignment with governance and compliance, porting 6 critical reports as part of a pilot.

TD Securities logoTS

Business Analyst, Data, Delivery & Integration

TD Securities

Jul 2025 - Nov 2025 (4 months)

Documented user stories across three separate end user groups, focusing on process and data migration from Loanet to Equilend for equity repo functionalities and post-trade processing.

User StoriesData Migration
Loanet
EquiLend
Post Trade Operations
Scotiabank logoSC

Assistant Manager, Global Banking & Markets

Dec 2024 - Jun 2025 (6 months)

Liaised with Global Capital Markets and Corporate & Investment Banking to document critical business services, conducting scenario analysis and reviewing business continuity plans to align risk strategies with OSFI guidelines and compliance. Implemented Key Risk Indicators (KRIs) process, leveraging Salesforce Fusion technology to standardize reporting metrics across three regional offices.

CPP Investments logoCI

Senior Business & Data Analyst, Enterprise Reporting & Controls

CPP Investments

Jul 2016 - Mar 2023 (6 years 8 months)

Translated client business requests into actionable project requirements by collaborating with technical and non-technical stakeholders, writing user test cases, performing QA and UAT testing, and ensuring alignment with organizational goals with Atlassian Jira. Utilized advanced data tools (SQL, Python, Excel) to perform attribution analysis on large data sets for over $500B in assets under manag

CPP Investments logoCI

Secondment, Management Insight & Analytics

CPP Investments

Sep 2020 - Aug 2021 (11 months)

Translated consumer requirements into actionable project plans, ensuring seamless delivery of portfolio data to the Active Equities investment department. Created and maintained reporting dashboards for asset exposure and investment monitoring key performance indicators (KPIs) using Tableau, reducing manual reporting time by 30% and improving data accuracy on security lending and liquidity. Produc

Education

Degrees, certifications, and relevant coursework

University of Toronto logoUT

University of Toronto

Bachelor of Commerce, Finance and Economics

Bachelor of Commerce with a major in Finance and Economics and a minor in English Literature from the University of Toronto's Rotman School of Management.

Interested in hiring Shin Rung?

You can contact Shin Rung and 600K+ other talented remote workers on Himalayas.

Message Shin Rung

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan