Vincent Trujillo

SUMMARY OF QUALIFICATIONS:

Data Warehouse Architect

Data Architect

Senior Teradata DBA

Well rounded and extensive experience in IT with 8 recent years of experience as a Senior DBA

Logical Modeler for many projects and converted the logical models to physical models.

Design and implement backup and recovery strategies for Teradata databases

Performed database tuning, making Teradata macros, triggers, BTEQs, and stored procedures more efficient, as well as end-user queries.

Performance tuning on SQL for optimization of BI Tools, ETL processes and end-user queries.

Coordinate Teradata Hardware and Software upgrades with the vendor engineers.

Data Warehouse/Data Mart Design and Development using ERD, Star Schema, Snow Flake Schema

Developed, tested and implemented ETL through SQL in BTEQ scripts and Teradata Utilities, as well as through ETL tools: INFORMATICA and Ab Initio.

PROFESSIONAL EXPERIENCE:

CHRISTUS HEALTH December 2012 – Present

Data Warehouse Architect

Data Architect

Principal Teradata DBA providing technical leadership in standing up a brand new Teradata Installation

Created entirely new Data Warehouse based on TD-HCLDM

Source to Target Mapping

Database tuning, ETL process tuning, End-user SQL query tuning

Logical Modeling using ERWIN

Physical Modeling using ERWIN

Data Standards

Physical Implementation of all Database Objects including all User-ids, Roles, Databases, Tables, Views, Indexes

Set up Archive and Backups using Appliance Backup Utility (ABU)

Teradata Tools and Utilities, Viewpoint, Teradata Manager, SQL Assistant, Teradata Studio

Modeling of domains for Master Data Management (MDM)

Consulted and worked closely with Management and Stakeholders, BA’s and ETL Team Lead to ensure on time delivery of the Releases of Data Warehouse

Strong knowledge of Teradata Architecture and how it fits in the BI/DW realm

Teradata Corp. March 2012 – November 2012

Solution Architect/Technical Pre-Sales

Support clients during upgrades and configurations.

Solution Architect/Senior Pre-Sales consultant.

Technical sales support.

Travelocity February 2008 – February 2012

Senior Teradata DBA

Senior Teradata DBA for the Data Warehouse Operations Team supporting the Data Warehouse.

Design and implement backup and recovery strategies for Teradata databases with BAR.

Contributor in the logical modeling sessions for many projects and converted the logical models to physical models.

Development and Support of ETL processes with INFORMATICA,Teradata Utilities, BTEQ, and Linux Scripting.

Coordinate Teradata Hardware and Software upgrades with the vendor engineers.

Ownership of resolving data issue bugs, by either delegating to junior team members, or by coding and testing the solutions myself, and following through by implementing into QA and Production (PROD).

Liaison to Hotels group to give special attention to their bugs, issues and questions.

Performed database and process tuning with TASM/Viewpoint tuning, making Teradata macros, triggers, BTEQs, and stored procedures more efficient, as well as end-user queries.

Granted Permissions to users/groups. Create Databases, Accounts, Profiles, and Roles as part of the overall team strategy and standards.

Designed and coded a process to reconcile System of Record bookings to Passport bookings for Air, Hotel, and Package.

Performed and lead Design/Code Reviews and provided feedback where appropriate ensure best practices were followed.

Performed QA and PROD Implementations of Data Warehouse projects ensuring the quality of the processes being implemented.

INFORMATICA Administration which included driving the software upgrade projects as well as Informatica object deployments. Proficient in Repository Manager, Workflow Manager, Workflow Monitor, Administrator Console.

JCPenney July 2007 – Jan 2008

Senior Teradata ETL Developer

Verizon April 2007 - July 2007

Database Marketing List Programmer using Teradata SQL, SAS, and UNIX shell scripts.

Wells Fargo Bank October 2005 - March 2007

Systems Engineer – (Internet Services Group)

Data Mart ETL Design, Development, Testing, and Implementation using Teradata, Ab Initio, Oracle, DB2 on UNIX platform.

HSBC Card Services (Formerly Household International) May 2000 – September 2005

Manager / Contributor – Customer Information Management Team

Consultant Business System – Data Access Group (Middleware)

Consultant Business Systems Data Warehouse Group

CNET (Contract) January 2000 – May 2000

ETL Developer (Informatica Development, Oracle, SQL, PL/SQL, TOAD)

Bank of America (Contract) July 1999 – December 1999

Data Mart Developer (Teradata, DB2, BTEQ, FASTLOAD, MULTILOAD, VSAM, JCL, PLATINUM & DB2 UTILITIES)

The Gap Incorporated (Contract) February 1999 – July 1999

Technical Team Lead (COBOL, CICS, DB2, VSAM, JCL, Writing Technical and Functional Specs, Creating Project Plans, Creating Test Plans, MS Project, Visio)

Bank of America (Contract) August 1998 – December 1998

Marketing List SQL Specialist (Teradata, Ad-Hoc SQL, JCL)

Household International April 1997 – August 1998

Consultant, Data Warehouse

Card Systems Incorporated (Contract) December 1996 – April 1997

Mainframe Developer (COBOL, SQL, JCL, DB2)

Burlington Northern Sante Fe Railroad (Contract) June 1996 – December 1996

Data Warehouse Developer (SQL, Teradata/BTEQ, COBOL, JCL)

JCPenney (Contract) January 1996 – June 1996

Mainframe Developer (COBOL, JCL, CICS)

Dallas Systems Corporation July 1994 – December 1995

Senior Systems Engineer

EDS September 1988 – July 1994

Systems Engineer

EDUCATION: Bachelor of Arts in Spanish, June 1987 Western Michigan University

Contact this candidate