Phoenix Li Email & Phone Number

Montreal, Qc, Ca

Montreal, Quebec, Canada

Developing end-to-end enterprise data quality solutions

Fredericton, New Brunswick, Canada

ETL data pipeline• Architected and built a robust star-schema data warehouse in Snowflake from the ground up • Pioneered the development of the company’s first API-Integration automated ETL pipeline, integrating data from various sources (JSON/XML API, SQL Server, SharePoint) into Snowflake via IICS; The pipeline included optimized features such as auto-recovery and incremental loading, resulting in the recovery of 10 years of historical data and expanding the dataset from 36 to 70 columns. Finally, engineered daily automated dashboards via Power BI• Generated annual savings of $700K in labor costs and eliminated repetitive manual tasks through the fully automated ETL processes and BI dashboard ecosystem• Successfully deployed pipelines across multiple environments (Development, UAT, Production)• Oversaw pipeline monitoring and maintenance, ensuring high standard data quality through comprehensive QA testingPower BI & Data Analysis• Led the weekly meetings with end users to collect requirements for the Power BI dashboard and communicate through change adoptions with them• Implemented automated Power BI dashboards which replicate the reports that end users are creating manually every week; saves $300K human cost per year• Leveraged Python (snowpark, streamlit) and BI dashboard to produce data presentations supporting critical business decisionsMentoring & Leadership Skills• Coached teammates by organizing weekly scrum meetings, hosting workshops, and creating detailed documentation; Collaborated closely with data scientists by facilitating daily scrum meetings to support the development of predictive AI models; accelerated the progress of data engineering projects across the company while saving $120K in new employee training costs• Collaborated with data scientists by scheduling daily scrum meetings to support them in building predictive AI modelsTechnical tools used: Informatica, Snowflake (SQL & SnowSpark), SQL Server, Power BI, Python, Devops

Montreal, Quebec, Canada

● Built a performance validation pipeline for Azure Cognitive Redaction Service via Python; The pipeline increased the accuracy of data governance model by 15% and saved 8 full-time employees equivalent costs of $1.2 million over building a sensitive data masking model (Deep Learning NER model) from scratch● Built a synthetic dataset-generating pipeline and assembled raw data from multiple sources using statistical research methodology; The tool reduced the time of manual data collection and enabled greater data quality and agility● Prepared data-driven reports and presented actionable insights to stakeholders in an understandable manner ● Technical tools used: Azure, Python (Pandas), GitLab, PowerPoint, Natural Language Processing, Data Pipeline, Java

Montreal, Quebec, Canada

1. Conducting Geospatial Analysis to identify market expansion opportunities for Rogers for Business division 2. Creating predictive models on the current reports at Rogers to generate valuable insights.3. Creating a framework through which internal departments at Rogers can retrieve datasets from the database using simple keywords. We will be using predictive modeling and other data analytical tools (such as regression and classification models) to come up with insights that will aid Rogers for business division in their decision-making process. This project will also include making visualizations and dashboards in PowerBI.

Ottawa, Ontario, Canada

• Designed, created, and maintained the core database, which allowed the data storage process to be structured and optimized for the associated company.• Scraped, cleaned and pre-processed 3000+ missing URLs and merged them back to core database using GoogleAPI, and Mongo database, which provided 1000+ data points stable growth every month.• Visualized 15000+ geospatial datapoints and created PowerBI dashboard for the Canadian Food Industry.• Fixed vital bugs from 1500+ lines of Python codes, which ensured data security and database stability and decreased the overall runtime of the program from 6 hours to 3 hours.

China Main

Worked as a TA to help international students succeed in the North American/UK/Australia College Entrance Official English Tests.

Master'S Degree, Master Of Management Analytics

Awards: - Entrance Scholarship Courses taking: - Data Mining and Visualization - Decision Analytics (Optimization) - Intro to AI & Deep.

Bachelor Of Science - Bs, Computer Science And Statistics

Activities and Societies: McGill University Chinese Debate ClubCourses have taken: - Data structures and Algorithms - Database Systems.