Notable Achievements

Customer-facing ordering portal enabling Canadian pharmacies to place direct orders for JAMP Pharma products, with internal system integration providing sales representatives tools to identify upsell opportunities and efficiently manage near-expiry inventory. *Slated production release: January 2027.

Automated the distribution of "back-in-stock" emails to over 2500+ pharmacies. Each message was dynamically generated based on the pharmacy's historical purchases to highlight products with the highest conversion potential.

Designed and implemented a project tracking framework for a professional allowance reduction initiative, resulting in measurable savings of over $2,02M in the fiscal year.

Redesigned large-scale dimension tables by implementing proper data modeling principles such as normalization up to the Boyce-Codd Normal Form (BCNF). This optimization reduced table size by up to 11× in extreme cases, significantly improving query performance and storage efficiency.

Developed a centralized database of field mechanics, detailing their skill sets and projected years until retirement. This initiative allowed HR identify at-risk expertise areas and strategically target recruitment efforts for future workforce needs.