Engineer Data

Experienced Database/Data Engineer with a demonstrated history of success in problem solving in strategic and tactical areas.

I have worked in different types of industries, including manufacturing and entertainment both domestically and abroad using different database platforms, such as SQL Server, Oracle, MySQL, Teradata and Snowflake, programming/scripting languages such as Python, PowerShell, Shell, etc. and ETL pipelines using SSIS, Spark and Scala.

Professional Work History

TICKETMASTER (USA)

Lead Database Engineer 2009 – 2020

Responsible to provide full support to the Data Services (Data Warehouse) team.

Database Engineering

oSupport of several databases in

SQL Server

Oracle

MySQL

Teradata

Snowflake

oFixed replication issues in legacy SQL 2000 Servers.

oMigration of legacy databases form SQL Server 2000 to SQL Server 2005

oMigration of legacy databases from SQL Server 2005 to SQL Server 2012

oMigration from Oracle 11g to Oracle 19c.

oMigration of On-Prem MySQL databases to AWS.

oAssist in data migration from legacy SQL Server databases to Teradata

oAssist in creating SSIS ETL jobs to do initial data loads from SQL Server to Teradata.

oMigrate Teradata from On-Prem to Teradata Cloud.

oMigrate Teradata from Teradata Cloud to AWS.

Data Engineering

oData architecting, staging, and movement.

oExperience using ETL pipelines: Kafka, Spark, Avro.

oAWS Teradata

oAWS Redshift

oSnowflake

oCI/CD Pipelines

Business Intelligence:

oAssisted in the definition of datasets required to provide reports in core business areas.

oSuccessfully deployed ETL jobs for Cognos, Tableau and Domoapp use.

oSuccessfully deployed a dashboard in Tableau to monitor the overall performance of the BI team queries in the system as a tool to identify and solve issues to ensure the team’s SLAs.

SITE SYSTEMS (USA)

PRODUCTION DBA 2000 – 2009

Responsible to provide a full database solution for sweepstakes management.

Build, programmed and support the company database in SQL Server

oCreate the Data Model

oPerformance Tunning

oT-SQL scripting (Stored Procedures and Functions)

oBackups and Restore.

oAssist web developers in using SQL Server in the backend.

Collect, classify and report on web activity (opens, clicks, etc.)

Assist in the automation of email campaigns (recipients list, opt-ins, opt-outs, preferences)

Developed a system to select sweepstakes winners

CONGEE COMMUNIACTIONS (USA). 2000 - 2001

Production DBA

Accountable for providing a full database solution in SQL Server to a card phone startup.

Build, programmed and support the company database in SQL Server

oCreate the Data Model

oPerformance Tunning

oT-SQL scripting (Stored Procedures and Functions)

oBackups and Restore.

Work with Web Developers on the use of the database in the backend.

HCL TECHNOLOGIES (MEXICO CITY AND LOS ANGELES)

Consultant 1998 - 2000

Full assessment on government and private business in preparation for the Y2K transition.

Provide diagnostic on the impacted electronic systems handling automated dates, such as computers, clocks, machinery, etc.

Provide fixes to the systems identified to be affected by the Y2K transition.

COMPANIA INDUSTRIAL LIZTEX, S.A. (GUATEMALA, CA)

Database Administrator 1990 – 1998

Liztex is the biggest fabric factory in Central America, exporting fabric to Mexico, USA and South America.

Responsible for automating manual control processes involving all the fabric fabrication process

Build the first database to

oManage productivity of the factory cotton fields (quality and quantities).

oManage productivity of the yarn spinning facility.

oManage productivity of the loom’s facility.

oManage administrative aspects of the factory, such as accounting, payroll, sales, purchasing, etc.

Monitor database performance.

Ensure database availability.

WESTINGHOUSE ELECTRIC COMPANY (MEXICO CITY)

Telecommunications Developer 1987 – 1990

Accountable to make the information between the manufacturing plant and the corporate offices available using Crosstalk V (communications software).

Developed in-house communications software using IBM personal computers and IBM-4331 mainframe between the corporate offices and the manufacturing plant for spare parts inventory control

Created Westinghouse spare parts database in DB2

EDUCATION

B.S., Electronic Systems Engineer, Instituto Tecnologico y de Estudios Superiores de Monterrey (ITESM)

M.S, Telecommunications, Instituto Tecnologico y de Estudios Superiores de Monterrey (ITESM)

Contact this candidate