Tao Lin Email & Phone Number

* 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, effectively integrating scattered data sources into a centralized data warehouse for advanced analytics and reporting* Developed interactive dashboards using Pentaho Ctools, enabling real-time and data-driven decision-making* Implemented workflow automation applications using 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

Toronto, Canada Area

As an actuarial associate at Sun Life Financial, I had experience in the following key areas:* 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* Spearheaded the rollout of a liquidity risk management framework, employing extensive industry research and rigorous data validation. Identified and reported internal control risk factors, culminating in enterprise-wide integration within 1.5 years

Toronto, Canada Area

As Enterprise Risk Intern at Scotiabank, I collaborated with Enterprise Risk Manager for reviewing bank's wholesale lending portfolio and analyzing risk factors impacting performance value. Key Achievements :* Performed data validation and ad-hoc data queries using MS Access* Supported the implementation of new OSFI reporting standards in SAS. Set up relational database diagrams and change control documentation to ensure data accuracy

Toronto, Canada Area

As a system testing analyst at Ontario Public Service, I assisted with quality assurance of Ontario's new welfare system under Ministry of Community and Social Services.Key Achievements: * Reviewed Business requirements to design and execute test cases for potential scenarios* Identified, monitored, and reported functional and security issues for the new welfare system; collaborated with developers and business analysts actively to ensure 100% pass rate.

Ottawa, Canada Area

As a Data Insight Analyst at MD Financial Management, I developed SPSS queries for collecting client data and analyzed customer behaviour for marketing team.Key Achievements:* Analyzed client base and classified into 4 key categories; profiled client personas to understand customerneeds and identify potential business opportunities* Compiled client survey responses in SPSS and presented analytical results to marketing team in a clear and compelling way

Master Of Management Analytics

Bmath, Actuarial Science (Finance Option), Statistics