Academic background
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), Administration of Labor Relations (265 Asimag hours), Basic Java (Gesfor Group), various courses on management systems (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. Creation of pixel perfect reports.
- 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; configuration of users and
roles; configuration of system security; creation of OLAP Mondrian data cubes with Schema
Workbench, MDX queries; creation of reports with Pentaho Report Designer and publication in repository,
data analysis; ETL procedures from data sources to a central warehouse (data warehouse) with PDI or Kettle;
creation of web-accessible dashboards with CDF-DE. - QlikSense. QlikView Desktop (designer and developer).
- Tableau
Databases
- 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.
- Big Data tools: 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 for Applications (database development with Microsoft Access).
- Java.
Virtualization
- VMWare (Windows, Mac). VMWare Server 2.
- VirtualBox (in Windows, Mac OS or Linux environments).
- Parallels Desktop (Mac OS).
Operating Systems
- Microsoft Windows (up to version 11). Microsoft Windows Server.
- Linux (Debian up to version 8, Ubuntu / Ubuntu Server up to version 18.04, Mandrake – Mandriva, Red Hat, CentOS, Rocky Linux 8, SuSe Linux up to version 7, Oracle Linux up to version 8). Oracle Solaris 10.
- Mac OS up to 10.15.
- Crossover (Mac OS, Linux). Wine (Linux).
Work experience
Instructor, consultant and freelance developer
- Providing training mainly 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 a 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).
Quality and Environment Director. 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.
