Jonathan Li Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

• Provide data-driven insights for business decisions through Power BI dashboarding, forecasting and ad hoc analysis, leading to 15% growth in transforming conventional to modern pharmacies with automated drug dispensing.
• Develop performance model and data dashboard for Operation Performance Incentive project to boost performance visibility and inspire employees.
• Develop Inventory Control Power BI dashboard that monitors physical inventories with book values, reconciles inventory discrepancies and reduces operation expenses.

• Created and deployed an MS Access Inventory Management application to monitor the stock level of the narcotic vaults and digitized physical records of narcotics transactions in accordance with Health Canada Regulations.
• Enhanced data accuracy and operational efficiency through automating manual Power BI Reports. Migrated data sources from spreadsheets to SQL Server, scheduled SQL stored procedures and set up Power BI Data Gateways.
• Forecasted production volume and supplies usage for central pharmacy automated filling sites, optimizing drug formularies and streamlining supplies planning.

Toronto, Ontario, Canada

• Maintained and analyzed the master data for all prescription products to ensure consistency across multiple systems (SAP, CRx, Kroll, MMS) and alignment with regulatory and business guidelines.
• Provided support to Shoppers Drug Mart, Loblaw, and Medisystem sites and collaborate with other second-level pharmacy support teams to resolve issues or concerns.
• Implemented and maintained all product listing and DSP information with Pharmaceutical Partnerships Team and QA to contribute to the generic efficiency.
• Automated daily report extracts and vendor price change requests with VBA SAP integration.
• Developed queries, analyzed databases and assisted data upload to meet the latest standard and policies.
• Provided training and technical supports to junior team members on business processes.

Richmond Hill, Ontario, Canada

• Developed python web scrapers that improved business intelligence and automotive parts catalog development efficiency by over 300%.
• Assisted data cleaning and cataloged data into MySQL database.
• Analyzed and visualized North America vehicle sales data to predict popular products.
• Gathered and Analyzed competitors pricing information for industry trends.
• Established eBay file exchange bulk upload templates and improved products listing efficiency by over 50%.
• Worked with marketing team to create advertisement strategies to increase website traffic and brand awareness.

Hangzhou, Zhejiang, China

Fuzhou, Fujian, China

Haerbin, Heilongjiang, China

Master Of Business Administration - Mba

Honours Bachelor Of Science - Hbsc, Double Major In Statistics And Pharmacology