Yiran Garrick Wang
North York,ON
Summary
Results-driven risk and analytics professional with expertise in financial analysis, enterprise risk management, and IT risk frameworks (NIST CSF 2.0). Skilled in building data-driven models, conducting control assessments, and optimizing strategy using Excel, SQL, Python, and Tableau. Strong collaborator with a track record of turning complex data into actionable insights for executive decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Information Security Analyst
Bank of China USA
10.2024 - 02.2025
- Conducted ISRA on FedLine, ACH, and SWIFT to identify compliance gaps and risk areas.
- Performed two quarterly phishing simulations through Cofense for information security awareness.
- Utilized security tools such as OneTrust for third-party privacy risk assessments and regulatory mapping.
- Assisted in the development and implementation of security policies and procedures.
Teaching Associate (Third Party Risk Management)
Columbia University
09.2024 - 12.2024
- Developed engaging lesson plans to enhance student understanding and participation.
- Assisted in classroom management, fostering a positive learning environment for diverse student groups.
- Collaborated with faculty to integrate technology into curriculum, improving instructional delivery.
- Supported assessment processes by grading assignments and providing constructive feedback to students.
Undergraduate Research Assistant
Columbia University
05.2022 - 09.2022
- Cleaned 20 years of daily data using Python; aggregated to monthly to reduce non-Gaussian effects.
- Built and optimized Excel portfolio models (Markowitz & Index) with Solver under multiple constraints.
- Visualized efficient frontier, minimum-risk, and optimal portfolios; delivered scenario analysis in PowerPoint.
Project Assistant
Hitone Capital
04.2021 - 09.2021
- Built DCF models for $1B+ real estate projects using Excel (VLOOKUP, Solver); structured GP/LP funds achieving ~15% IRR.
- Evaluated 10+ assets via site visits and due diligence; applied sensitivity analysis, SWOT, and feasibility studies.
- Developed SQL-connected Tableau dashboards and trend trackers; presented insights weekly to support investor decisions.
- Coordinated project schedules and resources to ensure timely completion of deliverables.
Education
Master of Science - Enterprise Risk Management
Columbia University
New York, US10.2024
Bachelor of Management and Organizational Studies - Honors Specialization in Finance
University of Western Ontario
London, Canada06.2023
Skills
- Risk mitigation
- Privacy regulations
- Microsoft Excel
- Microsoft Word
- Python
- SQL
- Tableau
- Operational risk
- IT risk management
- Financial statement analysis
Certification
- CFA level 1 candidate
- ISC2 Cybersecurity Certification Candidate
Timeline
Information Security Analyst
Bank of China USA
10.2024 - 02.2025
Teaching Associate (Third Party Risk Management)
Columbia University
09.2024 - 12.2024
Undergraduate Research Assistant
Columbia University
05.2022 - 09.2022
Project Assistant
Hitone Capital
04.2021 - 09.2021
Bachelor of Management and Organizational Studies - Honors Specialization in Finance
University of Western Ontario
Master of Science - Enterprise Risk Management
Columbia University
Similar Profiles
Jiayi SuJiayi Su
Bank Intern at China Merchants Bank (CMB China)Bank Intern at China Merchants Bank (CMB China)
Sigmund TuckerSigmund Tucker
Environmental & Safety Specialist at China Jushi USA CorporationEnvironmental & Safety Specialist at China Jushi USA Corporation
Yueyao WangYueyao Wang
IP Network Engineer at China Mobile International USAIP Network Engineer at China Mobile International USA
Spencer DallasSpencer Dallas
IT System Admin at Toronto ElectricIT System Admin at Toronto Electric
FELIPE HERNANDEZ-MERLANOFELIPE HERNANDEZ-MERLANO
Sales Manager at YESASales Manager at YESA