Rey AguilarBack End Developer
Expert in T-SQL programming, tables creation, indexes definition, keys, constraints, triggers, stored procedures, ETL process. Data manipulation, integrity and consistency. Experience acquired over more than 13 years in financial institutions and consultants holding positions both technical lead and data developer.
Tech stack
T-SQL (14)
SQL (6)
Datastage (5)
Teradata (5)
ETL Implementation & Design (5)
Data Modeling (5)
SQL Developer (5)
PHP (3)
Linux (3)
PostgreSQL (3)
Microsoft SQL Server (3)
Data Migration (3)
SQL Server Integration Services (SSIS) (2)
ETL
SQL Stored Procedures
SQL Functions
Data Processing
Teradata Databases
Experience
Back End DeveloperCOREBI
10/2019 - Currently

• Analyzed, designed and developed ETL process based in IBM platform InfoSphere DataStage for populating fixed and prepaid telephony inventory model into a Teradata data base technology, for Telefónica Client. • Analyze and develop data models for expanding and adding new features in current implemented Teradata data models. • Tested data consistency and integrity.

SQL
Datastage
Teradata
ETL Implementation & Design
T-SQL
Back End DeveloperDXC
07/2018 - 09/2019

• Designed, planned and executed Sybase database migration to Microsoft SQL Server 2012 including data structure adaptation, new procedures, functionalities and existing data. • Designed new data structure based on information gathering and business needs. • Improved stored procedure performance. • Defined tables, indexes and materialized views. • Supported development team with new database developments and requirements. • Elaborated technical database documentation. • Participated in information gathering directly with the client in English language.

SQL
Data Modeling
Data Migration
SQL Developer
T-SQL
Back End DeveloperSOOFT TECHNOLOGY
08/2017 - 07/2018

• Designed and implemented reliable, scalable and high-performance solutions to meet the service levels associated with the MSSQL database. • Ensured cooperation and communication within the devolvement team. • Recommended data architectures solutions. • Enhanced stored procedure performance.

Data Modeling
SQL Developer
T-SQL
Microsoft SQL Server
Back End DeveloperASOCIADOS GERENCIALES
03/2016 - 03/2017

• Leaded a development team, ensuring compliance with development standards and best practices. • Defined T-SQL development standards. • Tuning and performance queries. • Created database modeling for the Banplus Online migration to its new version under SOA architecture. • Managed Microsoft SQL Server for development environments.

Data Modeling
Data Migration
SQL Developer
T-SQL
Microsoft SQL Server
Back End DeveloperSERVICIOS TECNOLOGICO NUBISE
10/2014 - 03/2016

• Designed and developed complexed ETL for a data interface. • Developed basic SSIS package. • Attended to incidents and failures related to the database. • Developed multiples projects and solution in T-SQL.

SQL Server Integration Services (SSIS)
Data Modeling
SQL Developer
T-SQL
Back End DeveloperTELEFONICA SERVICIOS TRANSACCIONALES
11/2013 - 08/2014

• Certificated and planned productions deployments. • Leaded a development team, ensuring compliance with the deliverables for each stage of the assigned projects. • Attended development requirements. • Followed up projects and requirements across all its development cycle.

T-SQL
Microsoft SQL Server
Back End DeveloperBANCARIBE
11/2009 - 11/2013

• Participated in information gathering. • Developed multiple financial projects in T-SQL based in COBIS CORP. • Followed up projects and requirements across all its development cycle. • Supported productions deployments.

T-SQL
Back End DeveloperCOFAE
09/2006 - 07/2009

• Developed COAFE’S intranet web page. • Developed several technical manuals. • Supported productions deployments.

PHP
Linux
PostgreSQL
Education
BIG DATA Y BUSINESS ANALYTICS DIPLOMAUNIVERSIDAD SIGLO 21
08/2019 - Currently
HIGH UNIVERSITY TECHNICIAN IN COMPUTER SCIENCE COLEGIO UNIVERSITARIO DE LOS TEQUES
08/2002 - 08/2006