12/07/2022 updated

**** ******** ****
100 % available

BI - ETL - DBA

Mexico
Mexico
Master Degree
Mexico
Mexico
Master Degree

Profile attachments

CV - Ivan Baltazar Vela

Microsoft WindowsAdobe InDesignData AnalysisIBM System IBusiness AnalysisUnixCommunicationDatabasesCritical ThinkingData IntegrationExtract Transform Load (ETL)Data MigrationData ModelingRelational DatabasesProblem SolvingJSONPostgreSQLMathematicsMicrosoft SQL ServersOracle ApplicationsPentaho Data IntegrationSystems Development Life CycleQuery OptimizationMicrosoft Power BISoftware EngineeringSQL DatabasesStatisticsSalesforce TableauSpoon (Software)Information TechnologyTeam-workingSpotfire
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

Experience

Professional experience5 - 10 years

Languages

EnglishFluentSpanishNative speaker

Project history

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

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

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

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in