Might be available

(Updated 2022-11-30)

Consultor BI y ETL Sr

Mexico City, CDMX, México

Native Spanish, Fluent English

+3 años de experiencia con Pentaho
+7 años de experiencia en Tableau
+5 años de experiencia en PowerBI

Contact

Skills (26)

SQL QUERIES

SQL

Data Migration

SQL Server

Postgres

PROBLEM SOLVING

MS SQL Server

Oracle

DATABASE SYSTEMS

MS Access

BUSINESS PROCESS MANAGEMENT

PROCESS FLOW

DATA MODELS

Business Intelligence

DATABASE

PROCESS AUTOMATION

ORACLE 10G

Microsoft Access

DESIGN/DEVELOPMENT

DATABASE MODELING

Data Analysis

MAINTENANCE

MARKETING ANALYSIS

Informix

SALES ENGINEER

Summary

Over 8+ years of experience in the field of Information Technology with proficiency in DBs, BI and ETL
design/development
His 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 ability

Professional Experience

Freelance

2016-02 - Present

BI, ETL, DBA Responsibilities and Environment: ● Interact with Business Analysts to understand the process flow and the business ● Actively participated in team to gather requirements to develop BI projects ● Actively participated with IT infrastructure team to design physical and logical storage for BI projects ● Created data flow mappings to extract data from source system to loading to target ● Created visualizations of the extracted data ● Developed advanced reporting, analytics, dashboards and other business-intelligence solutions ● Collaborated with teams to integrate new systems ● Improving performance by twisting SQL queries ● Implementation of tools and technologies to improve response time in dashboards and BI desktop tools (Tableau, PowerBI) ● Created cubes using CubeJS ● Connected CubeJS to Tableau and PowerBI ● Worked with Citus on premises ● Database tuning: tables, indexes, queries (Postgres, SQL Server, Oracle) ● Created database objects needed to deploy BI projects

Sr Consultant

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

2013-09 - 2016-01

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

2012-05 - 2013-09

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

2009-11 - 2012-05

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

Academic Background

Certificate

2022-11 - 2013-01

Master's Degree

2022-11 - 2010-01

Certifications