Johan Pedraza Mayorga

Johan Pedraza Mayorga

About

Detail

Business Administrator with a specialization in Digital Marketing
Bogota D.C., Colombia

Contact Johan regarding: 
work
Full-time jobs
Starting at USD2k/month

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • OMD Colombia
    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.
  • Havas Group Colombia
    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.
  • Cheil Colombia
    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.
Education verified_user 0% verified
  • C
    Business administration
    Corporación Unificada Nacional de Educación Superior
    Jan 2017 - Current (9 years 5 months)