Este perfil está escrito em inglês
Technical Leader – Data Warehouse Integrator
Demonstrated experience with SQL Server (T-SQL, SSIS, SQL Agent, performance tuning).
Demonstrated experience with Yellowbrick (PostgreSQL).
Demonstrated experience with SAP HANA.
Demonstrated experience with BigQuery.
Demonstrated experience with Dataplex.
Technical Leader – Data Warehouse Integrator open to new opportunities
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.
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.
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.