Skip to main content
Alberto GuzmánAG
Looking for a job

Alberto Guzmán

@albertoguzmn

Data Engineer at FRAGUA Farmacias Guadalajara building Databricks pipelines that cut reporting latency by over 40%.

Mexico
Message

At FRAGUA Farmacias Guadalajara, I developed Databricks ETL/ELT pipelines with PySpark, transforming operational data into structured tables for reporting. I also integrated Databricks and Apache Airflow with legacy systems, reducing data extraction and transformation latency by over 40%.

I built SQL-based checks for branch products, customer orders, and transactions that contributed to a 20% reduction in data-entry errors. I also created Kafka streaming architectures for transactional events and automated recurring sales and promotion analysis for the Promotions and Marketing teams.

Earlier, at Intel Corporation GDC, I administered the HSD-ES ticket system and worked on platform testing and support for EBG and Ashcreek Falls. I also contributed to SANA, an Android application for tracking loaned tools and hardware, and previously supported critical banking applications at TATA Consultancy Services (TCS).

Experience

Work history, roles, and key accomplishments

FG

E-commerce Data & Application Support Specialist

Farmacias Guadalajara

Aug 2022 - Jan 2026 (3 years 5 months)

Extracted and analyzed operational data from Informix databases using SQL and SQuirreL SQL to support e-commerce sales, inventory, subscriptions, and transaction reconciliation. Developed large-scale ETL/ELT pipelines within Databricks using PySpark and Spark core, transforming raw records into structured gold-level tables for advanced analytical reporting.

Education

Degrees, certifications, and relevant coursework

SA

Salesforce

Training, Marketing Cloud Email Specialist

2025 - 2025

Completed Salesforce Marketing Cloud Email Specialist Training in June 2025.

PA

Prompt Engineering for Generative AI

Training, Prompt Engineering for Generative AI

2025 - 2025

Completed Prompt Engineering for Generative AI training in June 2025.

ES

E-Commerce Marketing & Social Media Strategy

Training, E-Commerce Marketing & Social Media Strategy

2025 - 2025

Completed E-Commerce Marketing & Social Media Strategy training in February 2025.

DB

Data Visualization Bootcamp

Bootcamp, Data Visualization

2020 - 2020

Completed a Data Visualization Bootcamp in August 2020.

BE

Bachelor’s Degree in Computer Science Engineering

Bachelor’s Degree, Computer Science Engineering

Bachelor’s degree in Computer Science Engineering.

AF

Agile Project Management Fundamentals

Training, Agile Project Management Fundamentals

2026 - 2026

Completed Agile Project Management Fundamentals training in March 2026.

BB

Business Intelligence with Power BI

Training, Business Intelligence with Power BI

2025 - 2025

Completed Business Intelligence with Power BI training in November 2025.

TS

Tableau Data Science

Training, Tableau Data Science

2025 - 2025

Completed Tableau Data Science training in March 2025.

Interested in hiring Alberto?

You can contact Alberto and 600K+ other talented remote workers on Himalayas.

Message Alberto

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan