| Year | Made at | Project | Description |
|---|---|---|---|
|
2025
|
JAMP Pharma
|
Back in Stock emails
|
Automated the distribution of “back-in-stock” emails to over 15,000 pharmacies. Each message was dynamically generated based on the pharmacy’s historical purchases to highlight products with the highest conversion potential. View example |
|
2025
|
JAMP Pharma
|
Profitability Initiative
|
Designed and implemented a project tracking framework for a professional allowance reduction initiative, resulting in measurable savings of over $610K to date and a projected annual savings of $1.48M. |
|
2024
|
JAMP Pharma
|
Data Model Optimization
|
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. |
|
2023
|
L3HARRIS
|
Workforce Database
|
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. |