# Shin Rung Hao

Shin Rung Hao is a remote worker on Himalayas, Consultant, Data, Data Technology Solutions at Healthcare of Ontario Pension Plan, based in Canada.

Source: https://himalayas.app/@shinrunghao

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

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Canada |
| Authorized to work in | Canada |
| Salary expectations | 133k+ CAD |
| Job categories | Business Analyst, Product Manager, Technical Writer, Data Analyst |
| Skills | Business Analysis, Data Analysis, Requirements Documentation, User Stories, Functional Specifications, Business Requirements Document, Data Migration, Equity Repo, Post Trade Operations, Risk Analysis, Business Continuity Planning, Key Risk Indicators (KRIs), Data Attribution Analysis, Data Pipelines, Data Integration |

## About

```text
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

### Consultant, Data, Data Technology Solutions (current)

[Healthcare of Ontario Pension Plan](https://himalayas.app/companies/hoopp). Jan 2026 - Present

```text
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.
```

Skills: Sailpoint, Azure-DevOps, SharePoint, Qlik, Business-Analysis, Requirements-Documentation

### Business Analyst, Data, Delivery & Integration

TD Securities. Jul 2025 - Nov 2025

```text
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.
```

Skills: User-Stories, Data-Migration, Loanet, EquiLend, Post-Trade-Operations

### Assistant Manager, Global Banking & Markets

[Scotiabank](https://himalayas.app/companies/scotiabank). Dec 2024 - Jun 2025

```text
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.
```

Skills: Business-Continuity-Planning, Risk-Management, OSFI, Salesforce-Fusion, Key-Risk-Indicators-(KRIs)

### Senior Business & Data Analyst, Enterprise Reporting & Controls

CPP Investments. Jul 2016 - Mar 2023

```text
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
```

Skills: SQL, Python, Excel, Jira, Data-Analysis, Data-Pipelines, QA, UAT, Process-documentation

### Secondment, Management Insight & Analytics

CPP Investments. Sep 2020 - Aug 2021

```text
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
```

Skills: Tableau, KPI-Reporting, Data-Analysis, Dashboarding, Stakeholder-Reporting

## Education

### University of Toronto

Bachelor of Commerce, Finance and Economics

```text
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.
```

## Tech stack

- Tableau
- Microsoft SharePoint
- Azure DevOps
- Python
- Microsoft Excel
- SQL
- Microsoft Word
- Power BI
- Microsoft PowerPoint

To contact Shin Rung, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [ojaswini User](https://himalayas.app/@ojaswiniuser): Business Analyst, Ageis Technologies
- [supreet sandhu](https://himalayas.app/@supreetsandhu): Senior Business Analyst, SMCP
- [Aditya Vardhan](https://himalayas.app/@adityavardhan): Associate, Cognizant
- [Nisha Nisha](https://himalayas.app/@nishanisha1): Senior Technical Analyst, Royal bank of Canada
- [Richa G](https://himalayas.app/@richag): Business Systems Analyst, BMO
- [Ankush Sharma](https://himalayas.app/@ankushsharma10): Business Analyst Credit Risk Data, Controls and Regulatory Reporting, CIBC
- [Harry J](https://himalayas.app/@harryj): Senior Business Analyst, RBC Investor & Treasury Services
- [Benjamin Harbor](https://himalayas.app/@benjaminharbor): Senior Business Analyst / Transformation Lead, BMO Financial Group
- [Nidhi Narang](https://himalayas.app/@nidhinarang): Lead Business Analyst, BMO Commercial Bank
- [Yashika Jain](https://himalayas.app/@yashikajain): Senior Business Analyst, Homesite Insurance
