Portfolio - Germán Aboytes

About Me

Dashboards nobody trusts. Data scattered across systems. Numbers that don't add up between reports. That's exactly where I do my best work.

With 3+ years of experience across tech, marketing, and BI operations, plus a Master's degree in Big Data, I fix that by building the infrastructure underneath: Power BI and Tableau models that consolidate Snowflake, BigQuery, CRMs, and ticketing systems into one trustworthy source of truth. I've implemented SLA tracking alerts for service desk operations, giving full 360 visibility to leadership, and automated manual workflows with Python, cutting classification time by 70%.

On the marketing side, I bring the same discipline to measurement, designing GA4 tracking and analytics implementations for brands like Cinépolis, Plata, and Paramount, then using SQL and A/B testing to find what's actually driving results, not just what looks good on a slide, contributing to a 20% lift in campaign performance across accounts.

Key Skills

POWER BI

SQL

TABLEAU

SNOWFLAKE

PYTHON

DBT

AWS

My Projects

Business Insights 360

Domain/Function: Ecommerce

My Experience

DATA CONSULTANT – TECHBRIDGEIT | Client: AUDACY, Inc - CDMX - Mar 2026 – Jun 2026

Migrated 100+ Tableau dashboards from Snowflake to BigQuery, validating calculated fields and parameters across all migrated dashboards to ensure parity before production release.
Recreated 50+ BQ datasources from scratch to replace legacy connections, rebuilding schemas/relationships and rewriting complex SQL logic (joins, aggregations, date functions) to preserve reporting accuracy.

BUSINESS INTELLIGENCE SPECIALIST – B-DRIVE IT (IT Company) - CDMX - Jan 2025 – Jan 2026

Developed Power BI dashboards with automated SLA-risk alerts, improving SLA compliance to 99% and giving leadership full visibility into service desk operations before breaches occurred.
Built a Python script using regex-based classification to auto-detect mismatched ticket categories, reducing manual reclassification time by 70% and improving downstream data reliability.
Unified data from 3 disconnected ITSM systems (previously requiring manual Excel/CSV extraction) into a single star-schema data model, automating dashboard refreshes and reducing report update time by 80%.

DATA ANALYST – WIVBOOST (Marketing Agency) - CDMX - Dec 2023 – Jan 2025

Built interactive Power BI and Looker dashboards to visualize campaign performance and ROI, cutting reporting turnaround time by 8 hours/week and enabling faster, data-driven decisions for stakeholders.
Validated UTM tagging, pixel implementation, and tracking setup via GTM across Meta and TikTok Ads, reducing data discrepancies and attribution errors across 30+ monthly reports, ensuring clean data across platforms.
Analyzed cross-platform campaign performance (ROAS, CPA) using SQL and GA4 for high-profile clients (Cinépolis, Plata, Paramount), delivering insights that improved marketing strategy performance by 20%.
Conducted funnel analysis to identify drop-off points and revenue leakage across the customer journey, informing A/B testing strategies that contributed to a 10% increase in conversion rate for top-tier clients.

QUALITY ANALYST – CITSIA (Food Innovation & Technology Center) – Guadalajara, México - Jan 2022 – Jul 2023

Investigated out-of-spec test results through root-cause analysis, partnering with production teams to implement corrective actions that reduced recurring non-conformances by 25%.