Vanessa Avendao Trejo
Vanessa Avendao Trejo

Senior Data Engineer and Data Analyst

Open to offers · Member since 12 Nov 2026
Location
Tula de Allende, Mexico
Desired salary
Unspecified
Work preference
Remote Only / Full Time
Experience level
Senior

About

Professional summary

I specialize in designing and operating end-to-end ETL and data pipelines, integrating REST APIs, transforming structured and semi-structured data, and delivering scalable cloud data solutions across GCP, Azure, and AWS.

Skills

44 capabilities

Tech stack & tools

Working toolkit

Application Hosting

Application Utilities

Marketing and Sales Tools

Experience

Career history

Senior Consultant / Data Engineer Tata Consulting Services

I work as a Data Engineer on GCP-based projects for Home Depot and MetLife. I design and manage ETL pipelines, ingest data from external systems, integrate REST APIs, process JSON payloads, and load transformed data into Google Cloud environments.

I use MongoDB, advanced SQL, Jenkins, Terraform, Dataform, Dataflow, dbt, Python, BigQuery, and Bigtable to build and operate data flows. I also develop Power BI dashboards, gather requirements with subject-matter experts, and create datasets and APIs that support business KPIs.

For a social medical data initiative, I build scalable PySpark and Databricks pipelines integrating Azure Blob Storage and MySQL data. My work supports clinical and financial analysis, risk stratification, data quality, auditability, cost management, and Power BI reporting.

Senior Consultant K2 Partnering

I worked on PepsiCo data projects focused on suggested-order prediction and customer segmentation. I created and monitored Azure Data Factory flows using Blob Storage and PySpark.

I processed Salesforce survey data, returned segmentation information to Salesforce, and used Jupyter and Databricks for code development. I also created Dash and Power BI dashboards, used DAX, performed data transformation, and optimized PySpark workloads.

Senior Consultant Axity Mexico SA de CV

I supported Walmart's Teradata-to-BigQuery migration, including AD_HOC table migration, GCP table creation, SQL query conversion, and onboarding of advanced users. I developed Python automation for high-volume table migration and Power BI dashboards for BigQuery connection statistics.

I also provided technical support for migrations from Alteryx to Tableau Prep, Airflow, and Dataiku. My responsibilities included connection support, data cleaning, transformation, and publishing outputs to multiple data sources.

Co-founder Infinity Code Solution

I co-founded a technology consulting company providing technical advice, data processing, data modeling, and strategy support for decision-making across different business areas.

I designed data flows, performed functional analysis, managed databases, and deployed analytical models that generated predictions and recommendations. I worked with Power BI, Looker Studio, Python, R, Hadoop, Spark, Azure, AWS, MongoDB, SQL Server, Oracle, Informix, and MySQL.

I also created social impact indicators for non-profit organizations.

IT Manager Asociación Mexicana de Bancos de Alimentos A.C.

I supervised the development of internal and external information systems, including control panels, data analysis, data processing, and data exploitation initiatives.

I managed Oracle, SQL Server, MySQL, and Informix databases, executed advanced SQL transactions and ETL processes, and generated strategic statistical reports for the Board of Directors. I led technical teams, supported technology decisions, and introduced tools and quality standards for process improvement.

Head of Application Development Hutchison Ports TILH

I managed application development projects and the application development department. I oversaw analysis, design, implementation, evaluation, team supervision, and web service publication.

I administered Oracle databases and worked with Oracle 11g, WebLogic, Java, and Scrum practices.

Teaching Assistant Universidad Tecnológica Tula-Tepeji and Universidad Interamericana para el Desarrollo

I supported instruction for Database II, Object-Oriented Analysis and Design, Programming Methodology, Software Engineering, Data Structures, Software Quality, Systems Auditing, and Web Application Development.

I taught and supported work using SQL Server, Oracle 10g, Java, PHP, PL/SQL, RUP, Scrum, XP, ITIL, CMMI, and UML.

Project Administrator Praxis

I assured remote services with CEDS in compliance with CMMI Level 5 standards and procedures. I served as Scrum Master for travel expenses, electronic invoice maintenance, and testing personnel follow-up projects.

I also participated in creating and maintaining a SQL Server 2008 database and worked with Linux, Java, PHP, Alfresco, and FileZilla.

Head of Development Area Fondo de Ahorro Nacional para los Trabajadores al Servicio del Estado

I administered central system modules, implemented an account statement module, tested new developments, and supported operational processes.

I developed web systems and reports using Oracle, Informix 4GL, PL/SQL, Java, NetBeans, and Eclipse. I worked in Unix and Windows environments using the RUP methodology.

Education

Learning history

IEXE TEC Universidad

Master's Degree, Applied Data Science

Master in Applied Data Science, currently in progress.

Universidad Tecnológica de México (UNITEC)

Master's Degree, Business Administration Finance

Master's Degree in Business Administration Finance.

Universidad Tecnológica de México (UNITEC)

Bachelor's Degree, Computer Systems Engineering

Computer Systems Engineering with an IT focus.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent AI Tools Salaries
Menu