Freelancer profile translated to English.
Back to original languageAbout Elena
Business Intelligence Analyst with 4 years of experience in the data world.
- Proactive
- Problem-solver
- Persistent
- Optimization of performance and data contained in the database.
(PL/SQL Developer - Toad for Oracle - Teradata - SQL Server, SQL language).
- Implementation of ETL processes to convert information sources from origin systems into exploitable data, ensuring data quality and traceability. (In Oracle Data Integrator 11g and 12c).
- Creation of reports and dashboards (in MicroStrategy), as well as presentation (using JavaScript, HTML 5 libraries, and CSS stylesheets).
- Execution of loads and validation of data obtained after a transformation and load process.
- Data migration, integration, and processing using Informatica BDM.
- Creation of a Data Lake, divided into layers (Raw, Distilled, Publication), with the objective of centralizing information (Data Centric) in S3.
Project execution under Agile methodology (JIRA).
Spanish
Native or bilingual
Can work on-site
Madrid (up to 50km)
Experience
- KeyrusBusiness Intelligence AnalystFASHION AND COSMETICSJune 2021 - Today (5 years)Madrid, Spain• Project: Retail.• Roles: Analyst.Optimization of performance and data contained in the database. ETL analysis and development. Validation of data obtained after a transformation and load process. Optimization of database load processes. Execution of test cases to validate software quality.• Technologies: Teradata database, SQL language / Oracle Data Integrator 11g / Linux / SQL ServerProject execution under Agile methodology (JIRA).
- keappsBusiness Intelligence DeveloperBANKING AND INSURANCESeptember 2020 - June 2021 (9 months)Madrid, Spain• Project: Insurance (Health and Life).• Roles: Developer.Optimization of performance and data contained in the database. Maintenance of ETL in Oracle Data Integrator of the DWH where daily processes were executed. Load execution. Data migration, integration, and processing using Informatica BDM. Validation of data obtained after a transformation and load process. Execution of test cases to validate software quality. Creation of a Data Lake, divided into layers (Raw, Distilled, Publication), with the objective of centralizing information (Data Centric) in S3.• Technologies: PL/SQL Developer, SQL language / Amazon RDS / Oracle Data Integrator 11g / Informatica BDM / S3
- EVERISBusiness Intelligence Developer e-HealthCONSULTING AND AUDITSMarch 2018 - September 2020 (2 years and 6 months)Sevilla, Spain• Project: Public Health System.• Roles: Developer.Optimization of performance and data contained in the database. ETL development. Validation of data obtained after a transformation and load process. Optimization of database load processes. Creation of reports and dashboards, as well as presentation. Execution of test cases to validate software quality.• Technologies: Oracle 11g database, SQL language / Oracle Data Integrator 12c / MicroStrategy / JavaScript, HTML 5 and CSS stylesheets / LinuxProject execution under Agile methodology (JIRA).
Recommendations
Be the first to recommend Elena
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Degree in Health Engineering (Biomedical)Escuelta Técnica Superior de Ingeniería Informática2018El Grado en Ingeniería de la Salud es un grado multidisciplinar, combinando conocimientos de ingeniería, informática, electrónica y salud. Capacita a sus estudiantes para la aplicación de la tecnología en el ámbito hospitalario y de la sanidad en general, siendo este un campo en evolución continua con innovaciones constantes. El graduado en Ingeniería de la Salud se convertirá en un profesional de la ingeniería, preparado para concebir, analizar, desarrollar, diseñar, especificar y gestionar la tecnología y el conocimiento aplicado al ámbito de la salud. Obteniendo competencias necesarias para su desarrollo profesional en diversos campos, que abarcan desde los sistemas de gestión de la información hasta el desarrollo de robots biomédicos, pasando por campos tan innovadores y relevantes como la inteligencia artificial aplicada a la salud o la bioingeniería de tejidos entre otros.
- Master in Business Intelligence – Official Microstrategy and Power BI. MBICICE, The Professional School of New Technologies2021Conceptos involucrados en la inteligencia de negocio, gestionar e interpretar la información de un cuadro de mando, diseñar estrategias comerciales en base al análisis de riesgos y obtener conclusiones de los mismos, diseñar seguimientos de estrategia comercial, entender la relación que existe entre la inteligencia de negocio y el Big Data y utilizar de forma profesional tecnologías como: - Data Marts (DM), Data WareHouse (DWH) y ETL - Bases de Datos Relacionales y SQL - Data Definition Language (DDL) y Data Manipulation Language (DML) - MicroStrategy - Power BI - QliKView - Tableau
Certifications
- Oracle Data Integrator 12c Certified Implementation SpecialistOracle2020