Gabriel P.

- Strategic Revenue Generation: Led a direct marketing initiative by identifying a high-potential customer segment and modeling a profitable offer structure. Project managed from concept to execution, generating a 7-figure revenue stream in 6 months with a 5.6 ROI.

- Loyalty Program Architecture: Designed the data strategy at the core of a new loyalty program with 8-figure annual revenue projections. My purchase data analysis was decisive in structuring program tiers to systematically increase customer lifetime value.

- Automated Customer Retention: Identified and targeted a segment of over 20,000 high-risk unique buyers. Designed and deployed a fully automated email workflow, reactivating over 7% of this previously lost segment and converting them into loyal customers.

- Marketing Data Ecosystem Ownership: Took full ownership and management of the marketing data ecosystem on GCP as the sole technical point of contact. Re-architected data reliability from a critical failure state to a trusted source, enabling advanced analytics for the first time. This centralization reduced the time to insight for complex analyses from over a week to less than a day.

- Cross-functional Leadership & Digital Transformation: Co-led the migration to a new data warehouse on Azure Fabric, managing a team of up to 5 consultants with a 6-figure budget. My role was to ensure the marketing data was the first pillar fully integrated into the company's new single source of truth, unifying sales and marketing data for the first time.

- Created custom Google Data Studio/Looker Studio dashboards to showcase marketing campaign results for over 10 clients by working with the Adverity ETL platform and SQL databases (Google Big Query).

- Built custom Google Sheets Budget Trackers to monitor marketing spend for over 10 clients by collaborating with Account Managers.

- Improved our dashboard template to include new features with challenging Key Performance Indicators (KPIs) that meet client needs by collaborating with account managers and the data team.

- Managed client requests in Canada, USA, Brazil, and Mexico by delivering quality dashboards that exceeded their expectations.

- Implemented a knowledge management system to document our work and issues to improve our productivity by sharing knowledge with the team and non-technical teams to enable them to solve common problems.

- Trained my colleagues and a manager on the Google Big Query tool, teaching them how to write SQL queries so we could work together to prepare the necessary data for the dashboard.

- Created a global SEO performance dashboard with challenging KPIs, merging data from multiple sources, in collaboration with the SEO Director.

- Developed a POC project in collaboration with the Chief Information Officer (CIO) and a Corporate Social Responsibility (CSR) expert from Onepoint to create a CSR dashboard with relevant KPIs intended to provide analyses used by the CIO, translating data analysis results into decision-making recommendations.

- Implemented an AGILE working methodology using SCRUM on Notion and improving sprint reviews/planning, which allowed us to increase our productivity by 25%.

- Trained my colleagues on the PowerBI tool so we could work together on the dashboard.