Tao Lin's Portal

About Me

👋 I'm Tao, a Business Intelligence Developer with a knack for building helpful tools and turning raw data into meaningful insights.
📍 Originally from Southern China, I'm currently living in Toronto, Canada.
🎓 I studied Statistics at University of Waterloo and Management of Analytics at Queen's University.
💼 I've led multiple Business Intelligence initiatives in insurance industry and telecommunication industry, and had the pleasure of mentoring a fantastic team of up-and-coming engineers.
🔍 In my leisure time I love arts & DIY craft, gardening, food and travelling

Experienced Business Intelligence Developer with 7 Years of Expertise

ETL Development, Database Design, Data Modeling, Analytics & Visualization,

Full Stack Web Application Development

Smith School of Business, Queen's University, Toronto, ON

University of Waterloo, Waterloo, ON

Double Major in Statistics and Actuarial Science, Finance Option

Society of Actuaries

CFA Institute

Bell Business Markets, Bell Canada, Toronto, ON

Led high-impact BI projects from conception to completion, collaborating with Product, Marketing, Sales and HR teams to drive business objectives
Built robust ETL pipelines and data models using MySQL, Pentaho, and Python, integrating scattered data sources, such as flat files, internal databases and external data via APIs, into a centralized data warehouse for advanced analytics and reporting
Developed interactive dashboards using Pentaho Ctools and JavaScript, enabling real-time and data-driven decision-making
Crafted web applications using SQL Stored Procedures, VB.NET and JavaScript, boosting operational efficiency by 50%
Supervised a team of 4 developers, offering guidance, code reviews, and training to elevate team skills and project outcomes
Configured cloud server environments to integrate BI tools to optimize data accessibility and performance

Financial Risk Management & Group Valuation, Sun Life Financial, Toronto, ON

Served as the central liaison for GGY AXIS models, orchestrating monthly cash flow predictions on large-scale policyholder datasets. Streamlined processes that saved 80 hours per quarter-end reporting
Engineered dynamic Excel dashboards through VBA and Python programming, integrating external data extraction, feature engineering, and advanced data visualization that enabled actionable recommendations to senior management
Created a new enterprise liquidity risk model, synthesizing extensive guideline research and multiple business unit data to identify and monitor internal control metrics, achieving full integration within 18 months