Rocio Castro

ROCIO CASTRO ENTHUSIASTIC DATA-DRIVEN MARKETER (- |-| rociocastropinto PROFILE Perceptive analyst – melds technical skill and strong business acumen to identify unexpected opportunities to contribute to the bottom line. Skilled communicator - adept at representing information in meaningful ways and distilling complex data sets into easy-to-understand customer and market insights. Problem Solver – always looking for creative ways to solve problems. EXPERIENCE BUSINESS INTELLIGENCE ANALYST (DF, MEXICO) PageGroup | Sept 2021 - August 2022 Developed automated dashboards with Power BI using SQL and DAX functions for different types of clients of Page Resourcing. Developed and delivered Executive-level data presentations to Project managers. FREELANCE DIGITAL MARKETING CONSULTANT Freelance | 2017 - Today EDUCATION M.A. IN DIGITAL MARKETING (ONLINE) IUBH University of Applied Sciences | 2021 - 2023 B.S., MAJOR IN COMMUNICATIONS AND MARKETING (PERU) Universidad de Lima | 2009 - 2015 PRODUCT MANAGEMENT NANODEGREE Udacity® | July 2021 – Nov 2021 SPECIALIZATION IN MARKETING MANAGEMENT (PERU) Universidad del Pacifico | 2016 SPECIALIZATION IN APPLIED STATISTICS (PERU) Escuela Nacional de Estadistica ENEI | 2017 TECHNICAL SKILLS Developed and executed online marketing strategies for several small businesses which increased social media following by 40%. https://travelbuddiesperu.com/ https://natourandes.com http://www.konnect.pe MARKETING ANALYTICS CONSULTANT (LIMA, PERU) Attachmedia | Oct 2020 - Sept 2021 Redesigned and enhanced portfolio reporting; reduced report production time by 65% using SQL, Big Query, and Google Data Studio. Designed easily digestible dashboards to promote data-driven decisions. MARKETING DATA SPECIALIST (GEORGIA, USA) UPS | Oct 2018 - Mar 2020 Led a project that identified a $5M business opportunity revenue for the sales team through data analysis and manipulation using SQL, Excel, and Power BI. Created interactive dashboards for stakeholders, and performed ETL data process for data analysis and cleansing. DIGITAL MARKETING ANALYST (LIMA, PERU) Marriott Hotels | Sept 2015 - Aug 18 Organized and managed the strategic planning across Marriott's digital properties in Peru including social media, websites, emailing, and analytics. Executed 100+ digital marketing campaigns across multiple channels with an expert-level familiarity with digital Key Performance Indicators like CPC, CTR, CPL, and CPA. 70% SQL 46% 80% Python Power BI GCP Social Media Adobe Suite Google Data Studio Tableau CERTIFICATIONS DATA ANALYSIS WITH R PROGRAMMING GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATE INTRODUCTION TO SQL DATA ANALYST BOOTCAMP GOOGLE ANALYTICS INDIVIDUAL QUALIFICATION INTRODUCCION TO DATA STUDIO PRODUCT MANAGEMENT