CazVid - Video Resumes That Work
CazVidThis is my profile
ENESPT
Contact via CazVid

Francisco

Technical Leader – Data Warehouse Integrator

Contact

Mexico City, Mexico City, Mexico
Available on CazVid
Contact via CazVid

Competencies

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.

Education

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

Languages

Spanishnative
Englishprofessional working proficiency

Summary

Technical Leader – Data Warehouse Integrator open to new opportunities

Experience

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.

Skills

SQL Server (T-SQL, SSIS, SQL Agent, performance tuning)Yellowbrick (PostgreSQL)SAP HANABigQueryDataplex
Published on CazVid - Nov 14, 2026
See more candidates in Mexico CityEn español
  1. Home
  2. /Hire in Mexico
  3. /Mexico City
  4. /Francisco
Contact Francisco