Apr 2021 – Sep 2023 · 2 yrs 5 mos · Ontario, Canada · Hybrid

• Spearhead business process evolution, promoting data-driven decision-making and automation to drive efficiency and productivity. Worked with executives and team heads to determine KPI metrics and held leaders accountable on their daily activities and achievements.
• Successfully rebuilt the entire data automation system and business intelligence reporting system, resulting in enhanced visibility, transparency, and granularity across all functions, including sales, credit risk, collection & delinquency management, and recovery activities.
• Act as the owner of company-wide data operations, ensuring data integrity and collaborating with executives to present monthly results to the Board, external investors, and funders.
• Built high-performance teams and maintained a robust technology infrastructure aligned with the company's business objectives. Hold team members accountable on project deliverables and process automations.
• Developed loan book forecasting process including loan balance forecasting/revenue forecasting/run off forecasting, leveraging historical loss curve and early payout curve models in compliance with IFRS 9 standards.
• Played a crucial role in year-end auditing by providing data support and explanations in credit risk, ensuring a smooth and accurate financial audit process.
• Set strategic directions for technology platforms and successfully drove enterprise digital transformation by leading multiple technology/data migration projects, including enterprise cloud migration, core loan management system migration, accounting system migration, and daily collection activities migration to third party, resulting in enhanced system efficiency and scalability.

Aug 2018 – Apr 2021 · 2 yrs 8 mos · Toronto, Ontario, Canada

• Developed and maintained a cloud-based real-time investment portfolio monitoring and risk management tool to monitor portfolio from 6 banks for a Singapore based family fund. Developed data processing framework to back test option strategies with 10 years option pricing and Greeks data.
• Built from scratch a web-based customized business intelligence visualization for a real estate digital broker based in Toronto to support 20+ users in 4 different office locations in Canada. Covered audiences from executives to branch CRM.
• Detected electronic vehicle electricity consumption pattern for a hydroelectric company, performed comprehensive cluster analysis in big data environment.
• Customized a cloud-based inventory hub to synchronize product inventories across three selling platforms via API for an e-commerce distribution company, automated sales transactions to QBO accounting system by API. Addressed sales capacity issue by highly automated processes and boosted sales 40% up during the COVID period.

Jul 2016 – Aug 2018 · 2 yrs 1 mo · Toronto, Ontario, Canada

• Developed 60+ production processes and 50+ Qlik apps to monitor/analyze wide range of Treasury topics such as equity & debt investments P&L, banking book FX hedging strategies, liquidity metrics (LCR, NSFR, NCCF), retail/commercial deposit trends, mortgage prepayments, wholesale funding, FTP rates, EV & AI, etc.
• Managed 7+ TB data pool with daily incremental of 60+ GB data. Automated and optimized numerous processes, improved efficiency by 75%. Implemented data healthy checks to improve data source quality.
• Re-built liquidity metrics LCR for Caribbean Units in daily frequency using Python, improved run time by 94% (8 hrs to 0.5 hr), enabled possibility of scenario analysis to provide more accurate treasury guidance.
• Performed deposits run-off analysis, vetted methodology, provided mathematical expertise in various aspects. Results were critical parameters for annual interest rate pricing guidance to all South American countries.
• Being invited as a guest speaker in a Qlik Sense seminar to demonstrate the technologies to realize real time machine learning algorithms in Python and result visualization in Qlik Sense.

Jan 2015 – Jan 2016 · 1 yr · Toronto, Ontario, Canada

• Re-built entire reporting systems that supported 400 sales representatives and the business unit management team, re-designed analytical infrastructure including database, ETL processes, analytical models, and dashboards.
• Automated entire reporting process to replace 400 hours monthly routine manual processes to less than 20 hours, enabled the entire team from processing to analyzing analytics to provide valuable insights to sales team.
• Accomplished a comprehensive cluster analysis on a credit card cross sales initiative for better customer target selection, interpreted results and answered challenging questions in front of 5 VPs of the bank.

Jan 2015 – Apr 2015 · 3 mos · Toronto, Ontario, Canada

• Performed pricing and risk analytics reconciliation for entire alternative investment portfolio.
• Researched and processed First Loss Fee Structure analysis to optimize net-of-fee returns.
• Developed UI interface and algorithms in MatLab to conduct notional reduction analysis during the drawdown periods to perform stress testing and scenario analysis to better understand downside risk.

Apr 2014 – Jul 2014 · 3 mos · Toronto, Ontario, Canada

• Implemented key marketing strategies for development of partnerships with Toronto local accounting firms and Chinese based education abroad agencies. Made cold calls to potential clients.