Alejandro Gallego Email & Phone Number

Alicante, Es

The Trafilea team is composed of fast-paced and ambitious doers. We are data-driven thinkers, passionate marketers, and tech innovators.🔰 Responsibilities:• Head of Data Engineering, Data Architecture & Reporting (https://shapermint.com/)• Team OKRs Definition • Team Performance Review• Agile software development (Scrum)• Strategic planning (Quarter, Weekly & Daily planning) • Active participation in hiring process• Analysis, design, Implementation and deployment of Data Analytics solutions.(Data Ingestion, Data Integration, Data Transformation, Data Staging/Storage, Data Profiling & Cleansing Services, Data Warehousing, Model Development, Analytics, & Information Reporting)• Data Analytics for Marketing, Ecommerce Solutions & ERP.• Data warehouse Architecture - Analysis, design and development data warehouses (Star Model, Snowflake).• Hands on analysis, design and development of Extraction,Transformation and Load (ETL) (Backend)• Hands on the Data visualization (Stories, Dashboards, Reports) (Tableau & Redash) (Frontend)⚙️ Technologies and tools:• Tableau (Success Story)• Power BI• AWS• GEN AI (RAG): Implementing cutting-edge AI-driven chat-bot to enhance data & analytics, productivity and decision-making capabilities by providing an AI-powered assistant capable of understanding and processing complex queries through natural language interactions.• Airflow, PDI (Pentaho Data Integration)• S3, Glue, Athena, Redshift, BigQuery, PostgreSQL, Bedrock• SQL (queries, views, functions, stored procedures, triggers)• Python• EKS• Argocd, Github• Terraform• Datadog

-Responsibilities:• Head of BI. 📊 • Analysis, design,Implementation and deployment of Data Analytics solutions.• Analytics for Financial/Human resources/Supplies and purchases/ERP.• Data warehouse Architecture - Analysis, design and development data warehouses (Star Model, Snowflake).• Design and implementation of Extraction,Transformation and Load (ETL).• Data visualization (Data Stories, Dashboards,Reports)-Technologies and tools:• Tableau• Airflow• Redshift,PostgreSQL• SQL (queries, views, functions, stored procedures, triggers)• Python• PDI(Pentaho Data Integration)

Montevideo, Uruguay

-Responsibilities:• BI Technical Lead. 📊• Analysis, design,Implementation and deployment of Data Analytics solutions.• Analytics for Financial/Human resources/Supplies and purchases/ERP.• Data warehouse Architecture - Analysis, design and development data warehouses (Star Model, Snowflake).• Design and implementation of Extraction,Transformation and Load (ETL).• Data visualization (Data Stories, Dashboards,Reports)-Technologies and tools:• Tableau• Airflow• Redshift,PostgreSQL• SQL (queries, views, functions, stored procedures, triggers)• R, Python• PDI(Pentaho Data Integration)

Montevideo

-Responsibilities:• Head of Data Analytics area. • Analysis, design,Implementation and deployment of Data Analytics solutions.• Analytics App development/Financial/Human resources/Supplies and purchases/ERP.• Analysis, design and development data warehouses (Star Model, Snowflake).• Design and implementation of Extraction,Transformation and Load (ETL).• Data visualization (Dashboards, KPI reports, OLAP navegation, Maps).• Optimization of data visualization • Datawarehouse and ETL optimization ( Indexes, Table Partitioning, Incremental load, Query performance).• Administration of linux servers.• Administration of database servers.-Technologies and tools:• Power BI• Pentaho• Alteryx• Reporting services, Analisis services, Integration Services•MySQL,PostgreSQL,Oracle,SQLServer,INFORMIX• SQL (queries, views, functions, stored procedures, triggers).• R, Python, Java• PDI(Pentaho Data Integration)• Saiku• Salesforce

Uruguay

-Responsibilities:• Head of Business Intelligence area.• Analysis, design,Implementation and deployment of Business Intelligence solutions.• SIAG Analytics App development/Financial/Human resources/Supplies and purchases/ERP.• Business Analyst - Odoo ERP.• Analysis, design and development data warehouses (Star Model, Snowflake).• Design and implementation of Extraction,Transformation and Load (ETL).• Data visualization (Dashboards, KPI reports, OLAP navegation, Maps, Drill down, Drill across).• Optimization of data visualization (Aggregate tables,MDX).• Datawarehouse and ETL optimization (Pentaho Blueprint, Indexes, Table Partitioning, Incremental load, Query performance).• Predictive analytics investigation (Weka).• Hadoop (HDFS, MapReduce, Hive)• Pentaho in High Availability.• Administration of linux servers.• Administration of database servers.-Technologies and tools:• Qlikview/Qliksense• Tableau• Power BI• Pentaho CDE-CDF-CCC-CDA.• Pentaho Data Integration.• Pentaho Report Designer.• Pentaho BA Server.• Mondrian OLAP server.• Saiku.• PHP/LARAVEL,JAVA,JAVASCRIPT/HTML/CSS• MySQL, PostgreSQL,Oracle,SQLServer.• SQL (queries, views, functions, stored procedures, triggers).

Cuba

Implementation, design and deployment of Open Source Business Intelligence solutions.Architecture of the BI web application.Architecture of REST services.Define technologies to use in the platform and implement common components.Analysis, design and implementation web services. Proxy pattern implementation for DAMIX. Web Development of business intelligence platform DAMIX.Analysis and design of data warehouses.Design and implementation of Extraction,Transformation and Load (ETL)Implementation of the Balanced Scorecard.Pentaho CDE-CDF-CCC-CDA.Pentaho Data Integration.Pentaho Report Designer.Pentaho BA Server.Mondrian OLAP server.Saiku.PHP/JAVA/JAVASCRIPTMySql/Postgres

Cuba

Implementation, design, and deployment of Open Source Business Intelligence solutions.Principal Analyst of Solution Analysis and design of data warehouses.Design and implementation of Extraction, Transformation and Load (ETL).Implementation of the Balanced Scorecard.Pentaho CDE-CDF-CCC-CDA.Pentaho Data Integration.Pentaho Report Designer.Pentaho BA Server.Mondrian OLAP server.Saiku.PHP/JAVA/JAVASCRIPTMySql/Postgres

Cuba

Software Development Specialist of business intelligence platform DAMIX.Pentaho CDE-CDF-CCC-CDA.Pentaho Data Integration.Pentaho Report Designer.Pentaho BA Server.Mondrian OLAP server.Saiku.PHP/JAVA/JAVASCRIPTMySql/Postgres

Cuba

Software developer and specialist in business intelligence technologies.Mondrian OLAP, Security roles implementation in JAVAPostgreSQL

Cuba

Data Architect of Project: Criminal Record (RAP).Faculty of e-government, University of Computer Science, Havana, Cuba.PostgreSQL