Sergio Franco Email & Phone Number

Barcelona, Catalonia, Spain

• Built and automated executive KPI dashboards for managerial decision-making.• Developed reporting for marketing by connecting and automating multiple platforms (Google Ads, GA4, BigQuery, Facebook Ads, etc.).• Collaborated with the Developers team on data engineering projects to design systems for collecting, storing, and analyzing data at scale for use in dashboards and reports.• Developed tools for the Marketing team to streamline data extraction from multiple platforms.• Integrated multiple systems and marketing platforms to enhance operational efficiency.𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬/𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬:• Built Python connections to automate data extraction from databases, leading to more efficient report generation.• Implemented BigQuery in company dashboards, developing new SQL queries and dashboards from scratch.• Reduced time and improved processes for affiliates/partners (reporting, payment, invoicing, order checking), reducing completion time from a week to a couple of days.• Integrated the CRM system (Pipedrive) with email marketing (Brevo/SIB) and reporting (Looker Studio/Sheets), automating data and processes to eliminate manual work.

Barcelona, Catalonia, Spain

• Develop and implement onboarding, trigger, and one-time campaign strategies.• Build and implement marketing automations (emails, notifications, reports, data organization).• Develop, launch, monitor, and analyze email marketing campaigns.• Create and manage pop-up campaigns.𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬/𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬:Established automation processes from scratch:• Developed onboarding series and trigger emails.• Created automatic reports gathering data from various platforms.• Implemented trigger and pop-up campaigns for lead generation.

Barcelona Area, Spain

• Developed CRM and engagement strategies.• Created lead nurturing, lead qualification, and follow-up strategies.• Managed the development, launch, monitoring, and analysis of email campaigns and landing pages.• Built and implemented marketing automations (emails, notifications, reports, data organization).𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬/𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬:Implemented automation processes from the ground up:• Created an automatic follow-up/lead nurture system considering leads' behavior and stages.• Developed a scoring and notification system to focus sales on qualified leads.• Automated report generation, reducing manual data processing.• Built a Facebook Chatbot and an automatic FAQ system.Increased enrollments from online campaigns by 30% through lead nurturing strategies.

Barcelona Area, Spain

• Automated and personalized email campaigns.• Developed and implemented customer retention strategies.• Planned and launched marketing campaigns.• Monitored and analyzed campaigns using tools like Google Analytics.• Conducted data gathering, analysis, and segmentation of the customer database.• Created HTML templates for newsletters and trigger emails.

Barcelona Area, Spain

• Conducted benchmarking of competitors.• Launched email campaigns.• Created creative concepts and conducted A/B tests in campaigns.

Rennes Area, France

• Organization, planning and logistics in events and activities for students.• Promote ESC Rennes through field marketing strategies.

Fortaleza Area, Brazil

• Promote the foundation in social media• Development of offline advertisement strategies to promote events and get fundraising.• Optimization in the storage and expenses monitoring with Access and Excel (Macros and Pivot tables)

Bogota, Colombia

• Organizing seminars. • Getting sponsors and fundraising.

Bogota, Colombia

• Making company presentations with videos and ppts• Updating reports and tracking of projects

Postgraduate Course, Online Marketing And Digital Communication Strategies

Master Of Science (Msc), International Marketing

Bachelor’S Degree, International Business Administration

Bachelor’S Degree, International Finance And Economy

Fifth semester

High School