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.