Tyler Li Email & Phone Number

Toronto, Ontario, Canada

• Modeling new payment data to construct a multilayer and modular data mart. Investigate new data ingested from payment providers by the product engineers, design and create data models that solve business needs, perform.
• Work closely with the risk team to model and prepare data reports such as risk reviews, early fraud… Show more
• Work closely with the risk team to model and prepare data reports such as risk reviews, early fraud warnings, and variant-specific transactions, enabling the risk team to perform their reviews and other daily actions
• Created SQL cohort logic and Looker Studio reports for the Payment Migration project. Accommodate evolving project needs by collaborating closely with Marketing, Product, Engineering, and Sales, and ensure data.
• As the lead DA in the Trialer Routing Optimization (TRO) project team, my work provided invaluable insights into lead volume, quality, and revenue metrics, which enabled Business to make informed decisions to refine.
• Maintain and own a Sales analytical model, including logic updates and knowledge transfer. Led project with DE to transform the model into a data product via DBT. Surfaced model data in Salesforce and ensured its.

Markham, Ontario, Canada

• Design and monitor KPIs (actual vs. forecast, available vs. demand) by querying QuickBase data of 10,000+ sites and directly working with regional PMs to generate weekly executive reports that track the progress of.
• Design and monitor KPIs (actual vs. forecast, available vs. demand) by querying QuickBase data of 10,000+ sites and directly working with regional PMs to generate weekly executive reports that track the progress of.
• Process a variety of interdepartmental work requests (on average 10-20 daily) via the agile ticket system using Excel and SQL; perform business-critical actions such as database updates/imports/audits, or customer.
• Compile stop-sell, reopen, and available-for-sale reports weekly. Reports help inform marketing and provisioning actions that could alleviate network congestion and directly impact customer experience
• Perform weekly audits to check consistency and accuracy of data; eliminate duplications and ensure the data alignment between databases (QuickBase, Salesforce, etc.) used by engineering, marketing, and operations teams
• Use Excel power query to compile annual rent report of around 3000 sites; revealed opportunities to save thousands of dollars in rent and tower utilities

Toronto, Ontario, Canada

• Preprocessed, compiled, and imputed 10 years of Toronto rent data extracted from the TREB database (about 15,000+ records). Converted and cleaned Stata files into tabular format, then exported into CSV format using R
• Resulting analysis used in the subsequent research/publications about the GTA housing market and financial risks

Markham, Ontario, Canada

• Discovered issues with the legacy database system. Subsequently initiated and led the database migration project. Established workflow to clean data in Excel and import it into Salesforce. Boosted efficiency and data.

Master'S Degree, Information Science/Studies, 3.96/4.0

Concentration in Human-Centered Data Science.

Doctor Of Philosophy - Phd, Neuroscience

Discontinued by personal choice due to change of career interests.

Undergraduate, Cognitive Science W/Spec Human Computer Interaction, Cognitive And Behavioral Neuroscience