Nicolas Barrera

Nicolás Barrera Caicedo

About Me

Data Analyst specializes in data modelling using digital marketing campaigns and optimizing marketing strategies through meticulous data analysis. His expertise lies in leveraging advanced analytical tools and techniques to drive results and enhance brand engagement, with experience in emails and landing pages design using HTML and CSS, applied for marketing strategies in companies like Unity and Oracle

Passionate about knowledge and mechanisms of the world, seeks to advance into the arts of marketing to create and execute omnichannel digital campaigns ,focused in the gathering of relevant business data for the creation of a predictive model that improves digital marketing campaigns, and later, the creation of an AI that would be the right hand of every marketer.

Python Projects

Extracting and Visualizing Stock Data

Web Scraping

Extracting essential data from a dataset and displaying it is a necessary part of data science; therefore individuals can make correct decisions based on the data. In this assignment, you will extract some stock data, you will then display this data in a graph.

Project Chicago Data Base

SQL

In this Python notebook I will; analyze three Chicago datasets, load the three datasets into three tables in a SQLIte database and execute SQL queries to answer assignment questions

Data Analytics for House Pricing Data Set Project

Python Data Analysis

The Trust would like to start investing in Residential real estate. I'm tasked with determining the market price of a house given a set of features. I'll analyze and predict housing prices using attributes or features such as square footage, number of bedrooms, number of floors, and so on.

Analyzing wildfire activities in Australia Project

Python Data Visualization

Coming soon

Experience

Digital Marketing Analyst

RED DESIGN SYSTEMS

Digital marketing specialized in email marketing campaigns for Oracle and Unity communications, structuring, editing, and refining landing pages and HTML emails for their strategies. Additionally, creating and connecting digital campaigns across different marketing tools such as Eloqua, Certain, Sendgrid or Salesforce.

Freelancer

Peña Bennett Studio Legal

Developed, implemented, and managed Google Ads campaign to promote the company's services. Analyzed collected data to optimize the campaign for lower cost per click and better results.

Marketing Assistant

GRICOL

Engaged in various activities including managing corporate events, virtual training, supplier management, customer communication, data analysis, metric dashboards, translation of catalogs into English, design of technical data sheets, business cards, event support, graphic design, and editing.

Sales and Customer Service Agent

Concentrix

Provided customer service for AT&T, handling calls through CRM, constantly interacting with native North Americans to solve their issues and sell products. Developed proficient English communication skills, leading to comfortable and understandable conversations.

TOOLS AND SKILLS

HTML

HTML

Structuring layouts for responsive websites and emails, creating forms, text articles with relevant tags, link configuration, and implementing audio, video, and images.

CSS

CSS

Using attributes to customize styles and perform basic animations within HTML, box model configuration, text properties, display properties, and adaptability.

Python

Python

Using libraries for Big Data Analytics, processing, analyzing, discretizing, exploring through graphs and matrices, and modeling data for predictive model creation.

Certain

Certain

Automation and creation of welcome pages, thank you pages, confirmation emails, pending emails, thank you emails, reminders, and contact management for event marketing.

Eloqua

Oracle Eloqua

Automation and creation of welcome pages, thank you pages, reminders, and emails for various email marketing strategies and contact management for webinar, in-person event, newsletter, promotions, offerts, discounts, general information, and everything needed

Excel

Excel

Using various formulas for different types of operations with internal or external data, using macros to facilitate data management, creating and configuring pivot tables, and creating dashboards based on data.

Power BI

Power BI

Data analysis and dashboard creation from various campaigns, summarizing data behavior and KPI fulfillment with conclusions and proposals.

Google Looker Studio

Google Looker Studio

Data analysis and dashboard creation from various Google campaigns, summarizing data behavior and KPI fulfillment with conclusions and proposals.

Google Ads

Google Ads

Creating and structuring campaigns on search engine and display network with compelling ad copies for the target audience, configuring remarketing lists for increased conversions, researching relevant keywords for optimization and cost reduction.

Google Analytics

Google Analytics

Configuration, analysis, and data tracking for web pages optimization, considering customer experience and relevant actions such as purchases, downloads, views, among others.

Meta Business

Meta

Configuration, publication, analysis, and content tracking for Meta's social media campaigns optimization, considering user interactions and brand sentiment in relation to KPIs.

Adobe Dreamweaver

Dreamweaver

Editing HTML and CSS templates to adjust styles, composition, structure, content, and adapt them to different email marketing strategies.

Adobe Illustrator

Illustrator

Composition, editing, and adjustments to graphic pieces for internal or external communications, such as pieces for different social media formats or internal communications.

Adobe Photoshop

Photoshop

Editing and composition of photos to create creative pieces, adapt graphic composition of images to convenience, perfect photos or images containing imperfections.

Adobe Premiere

Premiere

Composition, editing, and adjustments of visually aesthetic videos with transition effects, color, and audio adjustments, as well as creating visual pieces for display campaigns on web pages.