CPQ System Administrator (Salesforce Reporting and Analytics Focus) at RossVideo (2024-04 – 2025-10)
- Built and maintained regional Salesforce dashboards for Sales Directors and their teams surfacing product sales performance and pricing trends to help reps and leaders understand which products sold most in each region and at what price points.
- Authored complex SQL queries to pull and reconcile historical pricing data across time-based pricing objects enabling accurate reporting on warranty and contract records tied to original purchase prices rather than current pricing.
- Supported pricing strategy decisions for 3000+ hardware and software SKUs by analyzing tariff impacts and surfacing data-driven insights to Sales Directors for regional planning.
- Improved sales quote accuracy by 20% by implementing data validation logic within Salesforce CPQ quote templates reducing entry errors at the point of capture.
- Translated business requirements from Sales and Operations stakeholders into automated Salesforce reporting solutions and workflow improvements reducing manual effort across teams.
- Maintained data quality across 3000+ product and pricing records by identifying inconsistencies performing root cause analysis and applying targeted corrections.
Salesforce Administrator and Operations Specialist at Recollective Inc (2021-07 – 2023-10)
- Built and maintained core Salesforce reports and dashboards used daily by Sales and Operations leads to track pipeline health and closed revenue and team performance metrics.
- Led the migration of legacy Process Builder automations to Salesforce Flow taking full ownership of building and testing and deploying new flows as the org deprecated Process Builder.
- Built Zapier automations connecting Salesforce to Slack and email to trigger real-time team notifications on key sales events such as posting closed-won deals to the sales team Slack channel driving visibility and team engagement.
- Led an enterprise-wide data standardization initiative identifying inconsistent field entry patterns across Sales and Accounts teams (e.g. country recorded as both 'Canada' and 'CAD') then defined data standards and executed bulk corrections in Salesforce Data Loader improving data accuracy by 70%.
- Designed field-level validation rules and picklist standardization in Salesforce to enforce consistent data entry at the source preventing recurring data quality issues.
Cloud Computing Analyst Co-Op at Global Affairs Canada (2020-01 – 2020-08)
- Implemented Azure cloud solutions to centralize and secure file storage on virtual machines improving data accessibility and system accuracy for government teams.
- Used Azure DevOps for project management and version control establishing Git repositories and integrating virtual machines to support collaborative development workflows.
- Contributed to internal tool development using Python and web-based frameworks.
