Johan Pedraza Mayorga Business Administrator with a specialization in Digital

Data Management Coordinator

OMD Colombia

Nov 2023 - Current (2 years 7 months)

Team leader for two major brands: CCC and Tigo. Responsible for time management, processes, team hours, and task tracking. Skilled in data visualization tools like Looker Studio, Power BI, and Tableau. Manages self-service platforms such as Google Ads and Meta Ads. Creates and manages reports for Research, ATL, and digital campaigns. Utilizes social listening tools like Talkwalker.

Data Analyst Senior

Havas Group Colombia

Sep 2021 - Oct 2023 (2 years 2 months)

Led reporting and data automation projects for Telefónica Colombia. Analyzed data and generated insights focused on business objectives. Created performance reports for online and call center campaigns using Data Studio and Power BI. Direct client engagement and cross-functional collaboration. Provided support for tagging and regional projects.

Digital Data Analyst

Cheil Colombia

Mar 2021 - Aug 2021 (6 months)

Extracted, processed, and analyzed data from multiple sources to gain actionable insights on consumer behavior, brand digital ecosystems, and campaign performance. Focused on optimizing digital channels and communication strategies.

G

Digital Data Analyst

Grupo Sancho (Sancho BBDO)

Nov 2020 - Feb 2021 (4 months)

Extracted, processed, and analyzed data from multiple sources to gain actionable insights on consumer behavior, brand digital ecosystems, and campaign performance. Focused on optimizing digital channels and communication strategies.

G

Business Intelligence Specialist

Grupo Sancho (Annalect - Sancho BBDO)

Apr 2018 - Oct 2020 (2 years 7 months)

Created dashboards and reports for internal and external clients using Power BI, Tableau, and Data Studio to support data analysis and decision-making based on KPIs.

G

Digital Data Analyst

Grupo Sancho (OMD Colombia - Omnicom Media Group)

Oct 2016 - Apr 2018 (1 year 7 months)

Extracted and analyzed data from various digital measurement platforms. Delivered actionable insights on user behavior and campaign optimization.

G

Data Collector

Grupo Sancho (Omnicom Media Group)

Sep 2015 - Sep 2016 (1 year 1 month)

Prepared planning reports using client data. Managed Excel-based databases to organize, store, and maintain documentation.

Johan Pedraza Mayorga

About

Detail

Timeline

Résumé