CazVid - Video Resumes That Work
CazVidEste es mi perfil
ENESPT
Contactar vía CazVid

Este perfil está escrito en inglés

Francisco

Technical Leader – Data Warehouse Integrator

Contacto

Mexico City, Mexico City, Mexico
Disponible en CazVid
Contactar vía CazVid

Competencias

SQL Server (T-SQL, SSIS, SQL Agent, performance tuning)

Demonstrated experience with SQL Server (T-SQL, SSIS, SQL Agent, performance tuning).

Yellowbrick (PostgreSQL)

Demonstrated experience with Yellowbrick (PostgreSQL).

SAP HANA

Demonstrated experience with SAP HANA.

BigQuery

Demonstrated experience with BigQuery.

Dataplex

Demonstrated experience with Dataplex.

Educación

Master of Business Administration (MBA)
UNITEC
2013 - 2015
Bachelor's Degree, Computer Science
Universidad de Negocios ISEC
2008 - 2012

Idiomas

Spanishnative
Englishprofessional working proficiency

Resumen

Technical Leader – Data Warehouse Integrator open to new opportunities

Experiencia

Technical Leader – Data Warehouse Integrator

Tellso — Client: INFONAVIT
Jan 2016 - Present

Led a small team automating regulatory reporting, including the R04 A-0419 report under the IFRS 9 / Basel III-aligned framework; designed it so the old and new versions run in parallel during the transition.. Develop and tune SQL Server and SAP HANA stored procedures, triggers and functions for large-scale databases.. Design and maintain SSIS packages for ETL and data integration; troubleshoot SQL Agent jobs and package failures.. Implement data security (encryption and data labeling) with GCP, BigQuery and Dataplex.. Document business rules and impact analyses for executive stakeholders; build Power BI dashboards and reports.

Application Developer Lead Consultant (Data Engineer)

Integon / National General Insurance (an Allstate company)
Jan 2025 - Jan 2026

Owned the daily load and data-quality correction of auto policy XML feeds from external MGA partners into SQL Server and the Yellowbrick data warehouse.. Root-caused production load failures (duplicate keys in partner files, fan-out joins, SSIS error-handling gaps) and fixed validation errors with transaction-safe correction scripts.. Delivered pipeline changes through Azure DevOps: fixed an SSIS bug that marked failed batches as loaded, migrated auto-processing control across 3 SSIS packages and 5 stored procedures, and built procedures that enforce endorsement sequence integrity.. Migrated 14 views and 13 extract stored procedures to a new Yellowbrick schema and resolved the scheduler failure caused by missing grants.. Built a Python tool that repairs duplicated endorsement numbers in partner XML files.

Business Intelligence Analyst

Grupo Ro
Jan 2014 - Jan 2016

Developed and maintained SQL Server 2008 R2 stored procedures, triggers, views and jobs; provided database support.. Led the implementation of a new electronic invoice stamping (CFDI) provider.

Habilidades

SQL Server (T-SQL, SSIS, SQL Agent, performance tuning)Yellowbrick (PostgreSQL)SAP HANABigQueryDataplex
Publicado en CazVid - 14 nov 2026
Ver más candidatos en Ciudad de MexicoIn English
  1. Inicio
  2. /Contratar en México
  3. /Ciudad de Mexico
  4. /Francisco
Contactar a Francisco