Ivan Baltazar Vela

available

Last update: 07.12.2022

BI - ETL - DBA

Graduation: Master Degree

Hourly-/Daily rates: show

Languages: English (Full Professional) | Spanish (Native or Bilingual)

Keywords

Extract Transform Load (ETL) Pentaho Data Integration PostgreSQL Microsoft SQL Servers Oracle Applications Tableau (Software) Adobe InDesign Data Analysis IBM System I Business Analysis + 20 more keywords

Attachments

FORMATO-FelipeIvanBaltazarVela_011222.pdf

Skills

SUMMARY:
Over 8+ years of experience in the field of Information Technology with proficiency in DBs, BI and ETL design/development

My skills include:
Technical

Knowledge about Software Development and Implementation Lifecycle(SDLC)
Experience in Design, development and implementation of large-scale projects using ETL tools (Pentaho PDI) and Business Analytics tools (Tableau, PowerBI, Spotfire, CubeJS)
Good understanding of Tableau concepts included: Prep, Bridge and Server
Good Data analysis skills
Hands-on experience overall ETL process
Experience in creatin ETL transformations and jobs using Pentaho Kettle, Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho Server
Integration with SQL Server, Postgres, JSON, Oracle, MS ACCESS, IBM AS400, CSV files
Proficient in writing - SQL Statements, Scripts, Views and Query Optimization
Deep knowledge of RDBMS (SQL Server, Postgres, Oracle)
Quick understanding of Relational sources Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration
Worked with UNIX and Windows OS
Math and statistic skills

Non-technical

Good communication skills,
Critical thinking - Teamwork
Problem solving abilit

Project history

09/2013 - 01/2016

Sr Consultant

ARS INTEGRACION DE SOLICONES S.A. DE C.V.

Responsibilities and Environment:

* Managing automation projects of business processes and data integration implementing:
* BPM (Business Process Management) with Bonita BPM, Auraportal
* BA (Business Analytics) with Tableau, PBI and TIBCO Spotfire
* DBA skills on Oracle, SQL Server, Postgres

05/2012 - 09/2013

Oracle DBA

Grupo CICE

Responsibilities and Environment:

DBA 9i, APPS DBA and SYSADMIN. Where applied Preventive / corrective maintenance of production
environments, backup strategies, upgrade of versions, application of patches and tuning of the following
versions

* Oracle RAC 11g

* Oracle 11g Single Node
* Oracle 10g Single Node
* Oracle 10g RAC
* Oracle 9i Single Node
* SAN Administrator

And analysis information with Tableau Software to improve Hyperion results

11/2009 - 05/2012

Pre-sales Engineer and TIBCO Spotfire specialist

MEGAPRACTICAL

Responsibilities and Environment:

* PEMEX Sicori: Business Process Automation with Auraportal & Oracle
* Goverment of Toluca: Business Process Automation with Auraportal and BAM with
Spotfire(Spotfire server installation, configuration and dashboards creation with Spotfire
Desktop)
* ACP (Autoridad del Canal de Panama: TIBCO ActiveMatrix BPM installation & TIBCO Spotfire
Server installation over Linux and dashboard deployment

ISSSTE databases migration Informix to SQL Server