Built with datascienceportfol.io

Juan Jose Castillo Tellez

Data Analyst

Based in Bogota, COL

About

Engineer with 12-year experience in the energy, sales, and e-commerce fields. Trying to break into the data analysis field.

Skills

Projects

Experience

2020 - 2023

Co-Founder, operations and data manager - Primmavera Store

Online beauty products retailing. E-commerce co-founder. https://primmaverastore.com/. Management of online store and payment gateways. Extraction and analysis of valuable data using tools such as Google Analytics, Google Ads, Facebook Ads, Looker, and different BI tools. Data analysis and decision-making using Excel, Python, Pandas, and SQL tools. Design digital, logistics, and operations strategies to increase sales and optimize business profit. Creation of profitable Facebook & Google Ads campaigns under established traffic and ROAS metrics.

2022-2023

Business Development Representative - STAR7

— BDR role for a language & content services provider (Translation, localization, Interpretation, product content, etc.). — Expanding the company's customer base, mainly researching and qualifying leads. — Initiating exploratory cold calls with prospects to see if they'd be an ideal customer. — Scheduling discovery meetings with STAR7 sales executives to address prospects' pains and offer translation solutions.

2012-2020

Sr. Field Proffesional and Account Rep. at Halliburton

Preparation of technical - economic proposals and tenders, also contribute to increase Halliburton market share in the Well Testing Market within the country. Monthly and quarterly revenue forecasts, in addition to meeting sales goals for the growth of the service line within the country. Elaboration of procedures-simulations for running downhole tools in oil and gas wells. Experience with domestic and international DST operations in Alaska (USA) and in Venezuela. Test Tool Maintenance experience acquired in Macae (Brazil - 3 months). Main experience acquired in Test Tools and Memory Gauges, and Telemetry Tools like Dynalink Wireline.

2023 - 2025

Data Analyst

Detailed reporting on the performance of multiple marketing initiatives across Shopify apps using a variety of metrics systems. Analyze opportunities for expansion into other channels or deeper concentration on specific marketing focuses. Experience with marketing measurement techniques including channel attribution, lifetime value, ROAS, churn, and incrementality testing. A proven track record for crafting raw data and analysis into well-written and persuasive content. Advanced proficiency in Python and SQL. Automate different tasks and data ETL using webhooks, APIs, and different cloud solutions such as Google Cloud or BigQuery. Leverage & improve company metrics dashboards, to both input daily marketing data, and analyze data-driven insights.

2025 - Present

Data Analyst

● Collect and integrate data from various sources, including website analytics (GA4), CRM systems, and other relevant platforms. ● Ensure data accuracy, completeness, and consistency. Data Analysis and Insights: ● Conduct in-depth analysis of website traffic, user behavior, and conversion rates identify trends, patterns, and opportunities. ● Analyze customer purchase behavior to understand customer segmentation, preferences, and purchase journeys. ● Calculate and analyze customer lifetime value (LTV) metrics to assess customer profitability and identify high-value customer segment ● Develop key performance indicators (KPIs) and track performance against established goals. ● Create and maintain dashboards and reports.

Education

2005-2009

Mechatronics Engineering

Mechatronics Engineering BSc at universidad Nacional de Colombia.

2020-2021

Project Management

Project Management Specialization Studies - Universidad EAN.

2023

Data Analyst with Python

Completed career track on DataCamp.