Seasoned Data Engineer with 12+ years of experience working in various data engineering roles for companies that rely on a strong technology core, where the collection, management, and analysis of data play a key factor in their business model. Strong proficiency in Data Warehouse Architecture, Data integration / ETL&ELT development, Data back-end development, BI Reporting, Project Management, leadership in Agile SCRUM environments, Process tuning and optimization. Hands-on experience working on big data engineering in remote enviroments for global companies.
Worked as data engineer for various projects with activities ranging from Development, Testing, to Data Architecture, specializing in DWH, OLTP, OLAP, BI and Graph solutions.
Migrated ODS ETL processes from Talend into IBM Datastage for Consors Finanz subsidiary of BNP Paribas. Developed and maintained new data pipelines in both Oracle and Hadoop layers.
Developed a dynamic ETL solution for Bayer AG, using Talend Big Data Studio that defines the OWL 2 RDF ontology of the graph data model (Neo4j) which will help for the GDPR queries.
Acted as data consultant for the Group treasury data warehouse project where data was centralized from all over the group for analysis and reporting.
Oversaw the work of multiple India based teams which summed up to 5 FTE. Ensured that the new business requests were correctly implemented while supporting the BAU processing for the overnight DWH loading.
Designed and developed ETL&ELT processes using PL/SQL. Was in charge of performance tuning business queries, reporting statements, and ETL processes.
Worked on the design, development, documentation, and deployment as well as the “day-to-day” BAU support of the Oracle based Strategic Data Warehouse.
Developed ETL&ELT processes using Oracle ODI 11g Release 1 (11.1.1) spanning across various projects using the Kimball methodology. Developed ODI interfaces, packages, models, load plans, and data feeds to/from DWH.
Designed and developed processing alerts spooled from ODI or Oracle based on business requirements using the ODI SNP tables. Developed entities in SqlServer MDM for different areas of the business.
Worked on the development of high-end, high quality applications on a 60TB Data Warehouse and integrated new business requirements in an environment that has over 1.2 million lines of PL/SQL code.
Designed and developed new business functionality in an Agile environment, also monitoring and maintaining warehouse critical alerts and processes.
Partnered closely with third parties in order to deliver the sprint commitment. Took part in weekly data architecture and design meetings in order to present the approach needed for a new framework or process.
Designed and developed new ETL processes and integrated them in the existing model using OWB 10g. Developed stored procedures using the ORM method, which are called from .Net by the AR module.
Created business reports in an Oracle Applications 11i environment, using Oracle Reports 6i. Developed ETL/ELT processes in OWB and Microsoft SSIS.
Documented and supported legacy stored procedures, custom reports, and db objects. Worked in an Agile environment, using a 2-week sprint setup, and closely interacting with BA’s.
Performed Oracle Database administration for different versions and configured OEM Grid Control for the database.
Designed database architecture and created perl/bash scripts for automating some administrative tasks. Provided periodical On-Call support for incidents within the SLA response and resolve timeframes.
Applied Oracle CPU Updates on a regular basis, in accordance with Oracle's release windows. Used different monitoring and backup tools, including OEM Grid Control, Norad, Legato NetWorker, Tivoli Storage Manager, and Veritas NetBackup.
Bayer AG is a German multinational pharmaceutical and life sciences company and one of the largest pharmaceutical companies in the world. Developed a dynamic ETL solution using Talend Big Data Studio that defines the OWL 2 RDF ontology of the graph data model (Neo4j) which will help with GDPR queries. Developed cypher statements in order to create and establish the supplied ontology and graph structure. Performed dynamic data processing from various systems (RDBMS, NoSQL, Flat files, JSON, XML).
Paddy Power Betfair was formed through a merger of two of the fastest-growing online betting and gaming operators in the world. The project involved migrating 2 legacy DWH (Oracle and MySQL) into a new Amazon Redshift Data Lake. It was developed in ODI 12c as the main ETL tool. Developed new Big Data (Mongo) ETL processes which then need to be integrated into the Apache Kafka message queues. Created and reconciled new CRM milestones from IDP with the 2 legacy platforms.
Consors Finanz is one of the leading providers of consumer loans in Germany and Austria. The company is one of the recognized financing specialists in the retail, e-commerce, and automotive business in particular. The project involved migrating the company’s ODS ETL processes from Talend into IBM Datastage. Developed and maintained new data pipelines in both Oracle and Hadoop layers. Performed BAU activities for the overnight ETL processing in both Talend and Datastage.
