Training
Master in Total Quality Management
- Quality Management Systems Auditor – Environmental (IRCA – IEMA). EFQM Evaluator (EFQM and Quality Management Club).
- Project presented in September 2010 (survey methodology, data collection and business intelligence system for the development of indicators for the UNE-EN 13816 standard).
Additional training
Google Cloud Associate Cloud Engineer
MongoDB Administator
Oracle MySQL 8 new features
MySQL Cluster
Cloudera
- 2011: Oracle Business Intelligence and DWH. 78 hours. Getafe TIC.
- 2011: Oracle 11g Database Administration. 170 hours. Getafe TIC.
- 2011: UNIX Systems Administration. 250 hours. MicroForum. Madrid
- Until 2010, Solaris Systems Administration (290 ESF hours), HR Management Techniques by Competencies (220 Asimag hours), Labor Relations Administration (265 Asimag hours), Basic Java (Gesfor Group), various management systems courses (ISO 9000 – 14001 – 18001 – EMAS), Occupational Risk Prevention, OHSAS 18001, organization and IT, among others.
Computing
Business Intelligence – Data Integration
- Oracle Business Intelligence up to version 12c (OBI): Analysis and dashboards, repository creation.
- Oracle B.I. Publisher up to version 12c. Pixel perfect report creation.
- Oracle Database up to version 12c Data Warehousing Fundamentals.
- Oracle Data Integrator up to version 12c.
- MicroStrategy Desktop 11 – MicroStrategy Dossier.
- Pentaho CE, including: installation and maintenance in Linux and Windows environments; user and role configuration; system security configuration; creation of OLAP Mondrian data cubes with Schema
Workbench, MDX queries; report creation with Pentaho Report Designer and publication in repository,
data analysis; ETL procedures from data sources to central warehouse (data warehouse) with PDI or Kettle;
creation of web-accessible dashboards with CDF-DE. - QlikSense. QlikView Desktop (designer and developer).
- Tableau
BBDD
- Oracle 11g, 12c and 19c (SQL, PL/SQL programming,
administration, backup and recovery, SQL tuning). - MongoDB.
- Development of procedures for use in business intelligence
systems or batch processes. - Microsoft SQL Server 2005 (including creation of procedures with T-SQL).
- Microsoft Access (up to version 365).
- MySQL (up to version 8).
- FileMaker (up to version 10). dBase III and IV..
Big Data
- Hadoop.
- Cloudera Data Platform 7.4.4.
- Tools Big Data: Hive, Impala, HDFS, Sqoop, Pig, Spark, etc.
Spreadsheets
- Microsoft Excel
- OpenOffice / LibreOffice Calc.
- Apple iWork Numbers.
Word processing
- Microsoft Word
- OpenOffice / LibreOffice Writer.
- Apple iWork Pages
Presentations
- Microsoft PowerPoint.
- OpenOffice / LibreOffice Impress.
- Apple iWork Keynote.
Process and project design
- Microsoft Visio (hasta versión 2007)
- Microsoft Project (2007)
- OmniGraffle Pro.
Programming and development
- Oracle APEX
- Python.
- Bash script.
- PL/SQL. Transact-SQL.
- PHP.
- Visual Basic para Aplicaciones (desarrollo de bases de datos con Microsoft Access).
- Java.
Virtualization
- VMWare (Windows, Mac). VMWare Server 2.
- VirtualBox (en entornos Windows, Mac OS o Linux).
- Parallels Desktop (Mac OS).
Operating Systems
- Microsoft Windows (hasta versión 11). Microsoft Windows Server.
- Linux (Debian hasta versión 8, Ubuntu / Ubuntu Server hasta versión 18.04, Mandrake – Mandriva, Red Hat, CentOS, Rocky Linux 8, SuSe Linux hasta versión 7, Oracle Linux hasta versión 8). Oracle Solaris 10.
- Mac OS hasta 10.15.
- Crossover (Mac OS, Linux). Wine (Linux).
Experience
Instructor, consultant and freelance developer
- Mainly providing training in the following technologies:
Oracle Database Oracle
APEX MySQL
Oracle PL/SQL MongoDB
Linux: RH, CentOS, Rocky
Oracle Business Intelligence
….. - Energy Applications (currently)
Development of data management and analysis tools, processes and databases. Consulting. - Autocares Beltrán (from 2012 to February 2016).
Implementation of a business intelligence system with Pentaho.
Creation of ETL processes.
Installation, management and maintenance of databases and new tools.
Installation of server infrastructure, networks and virtualization system.
Support in defining management indicators, UNE 13816 Standard and CRTM requirements. - ETASA (until 2015).
Creation of a tool for recording driver activities.
Implementation of reporting and data analysis system with Pentaho.
Instructor
Official Oracle Instructor. Teaching of official Oracle courses: Oracle Database Administration 11g. SQL. PL/SQL. Advanced PL/SQL. SQL Optimization. Oracle Business Intelligence. Publisher. Oracle Data Integrator. OpenOffice 3. Systems Administrator (Linux).
Consultant (Project: Infocaja)
- Implementation of the Pentaho BI Business Intelligence system.
- Creation of connections with SQL databases and update procedures. Transfer of data from Excel and Access (creation of Access application to automate data transfer). Creation of queries and schemas (OLAP Mondrian data cubes). Creation of dashboards (management indicators) and reports in the Pentaho environment.
- Maintenance and updating of the quality department website. Dreamweaver and javascript.
- Administration and maintenance of bash scripts in a Linux environment (Debian).
Director of Quality and Environment. IT Manager
- Maintenance of the quality and environmental management system (ISO 9001:2000, ISO 14001:2004). Internal audits of management systems. Development of processes, procedures, specifications and work instructions. Support for the development of work instructions for other departments.
- Internal development of database applications for the management of vehicle maintenance, warehouse and purchasing services, connections with accounting. Coordination of the development project for the organization’s website. Maintenance of the organization’s computer system.
