Carlos Alan Venegas Cruz
Development
Toluca, Mexico
Skills
Data Engineering
About
CARLOS ALAN VENEGAS CRUZ's skills align with System Developers and Analysts (Information and Communication Technology). CARLOS also has skills associated with Database Specialists (Information and Communication Technology). CARLOS ALAN VENEGAS CRUZ has 7 years of work experience.
View more
Work Experience
DATA ENGINEER CONSULTANT
January 2022 - December 2023
- -Develope infraestructure in AWS using EMR, Glue and Redshift for big data solutions. -Evaluate business needs and objectives. -Building compelling data visualizations. -Extract, transform and load raw data for different sources.
DATA ENGINEER
Konfío
January 2021 - December 2022
- -Analyze DEV and PROD data in Amazon Redshift over +50 tables using PrestoDB SQL to test changes in ETL jobs in Matillion. -Evaluate business needs and objectives. -Building compelling data visualizations in Tableua platform. -Extract and collect raw data for different marketing sources (facebook ads, google ads, linkedin ads).
SR.BI & CLOUD TECHNICAL ANALYST
Dentsu International
January 2019 - December 2021
- -Developed and maintained +20 stored procedures in PLPGSQL to feed an enterprise Data Warehouse from S3 sources. -Build +30 datasets using SQL queries in visualization tool DOMO where business stakeholders monitor marketing spend and performa nce. -Analyze DEV and PROD data in Amazon Athena over +50 tables using PrestoDB SQL to test changes in ETL jobs. -Design/mapping to include +10 of various data sources into the data architecture of the analysis solution. -Monitoring of data schema through AWS Glue crawlers/tables/jobs to verify trustworthiness and health of ingested data. -Analysis of technical documentation to plan schema and collection of data on Facebook/Google/Twitter and media provider APIs. -Create +10 dashboards in order to generate insight for all LAC region
DATA ANALYST
Dentsu International
January 2018 - December 2019
- Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily read by either human or machine. -Using statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts. -Identify, analyze, and interpret trends or patterns in complex data sets.
DIGITAL ANALYST
Swarm Data & People
January 2017 - December 2018
- -Collecting and analyzing customer, marketing, and web behavioral data. -Creating dashboards, data visualizations, and campaign and website performance reports. -Monitoring and analyzing digital media and marketing trends.
KPI'S MANAGER DATA ENGINEER
Santander México
January 2023 - Present
- -Create ETL Pipelines to extract information about different sources in the bank. -Develop business rules to create KPI's from CRM Digital area. -Build and maintain store procedures. -Create visualization in Tableua. -Collaborate with other teams to map data fields to hypotheses and curate, wrangle, and prepare data for use in advanced analytical models.
Education
INSTITUTO POLITECNICO NACIONAL
January 2011 - January 2015
DataCamp
