Implementing DWH and Analytical storage.Developing ETL and Data Pipelines.Technologies and languages: SQL, BigQuery, Python, Google Cloud (GCP), ScalaGoogle Composer (Airflow)Tableau as a BI toolBuilding forecast for Structural Time Series by using SARIMA model.Customization Airflow (developing custom ETL tool / Airflow operators)

Design and implementation DWH based on Kimball and Data Vault 2.0 approaches.Implementing Webservices on Talend.Implementing Data Pipelines and ETL for DWH and for Integration system (MDM).Cross teams coordination.Salesforce integrationMicrosoft Technologies: SSIS, MSSSQL 2014/2016, C#Talend technologies: Webservices, ELT templates, etc.

Developing and maintenance Data Lake.Using such tools and technologies as: HIVE, Beeswax, Beeline, Hadoop, Informatica BDE, KornShell, HSQL

BI project for MERCK Designed and implemented physical and logical models (STAR schema / Dimension model, Data Marts, Staging areas). Designed and developed ETL processes in Informatica PWC: Mappings, Work flows, Worklets, Sessions, Parameters, etc. Implemented transformation in PL/SQL stored procedures. Optimization ETL processes. Developed orchestration scripts (Linux shell scripts) for executing ETL Informatica workflows, monitoring and administrating Informatica ETL processes. Build preparation, installation and migration.Technologies & tools: Informatica PWC, PL/SQL, SQL, ASH, AWR, ADDM, Execution Plan, Shell Scripting, Toad, etc.

BI Project for OneCallCare ManagmentDesigning EDW & MDM & self-service BI solutions based on Oracle technologies such Oracle Exadata, Oracle Data Integrator and Oracle BI by using Maximum Availability and High Availability Architectures. Designing and implementing self-service Test Data Management approach.Improving customer satisfaction with ETL/BI performance.Managing a development team.Analyzing business requirements linked with Health Care business. Configuration Oracle Streams and Oracle Change Data Capture (CDC).Investigation solution performance issues and implementation remediation activities. Creating Disaster Recovery and Deployment documentations.Planing and designing Continues Integration based on Team City tool.Troubleshooting in: Oracle Streams, Oracle CDC, Oracle RAC, Oracle Exadata Working with such tools as : TOAD, Oracle SQL developer, AWR, ASH, Oracle Enterprise Manager, ODI, OBIEE, etc.

BI project for Wolters KluwerDesigning and planing remediation activities for BI/DW project based on Oracle technologies & Talend tools.Investigation solution performance issues.Designing a performance measuring tool based on Oracle ASH views.Working with: TOAD, AWR, ASH, Oracle EM.

Architect and design Master Data Management processes using Informatica MDM.Developing Data Pipelines and ETL processes.Technologies and languages: SQL, PL/SQL, Oracle, Informatica Cloud, Informatica MDM

Architecture design and developing DWH based on Kimball approach. Developing real-time Data Pipelines for operational reports.Technologies & languages: SQL, PL/SQL, T-SQL, Oracle, MSSQL, dotNet, C#ETL tool: SSIS, Talend

Design and architecture of DWH and Analytical Storage. Developing Data Pipelines for ETL/ELT, migration and integration purposes.Technologies and languages: Oracle, MSSQL, PL/SQL, SQLETL & BI Tool: SSIS

Developing and maintenance:1. IBS Insurace ERP system2. Data Pipelines of real-time integration and MDM3. Migration data from legacy system to a new one with using ETL/ELT processesTechnologies and programming languages: PL/SQL, .NET, SQL, T-SQL, Oracle, MSSQL

Developing and maintenance Omega Production ERP system.Technologies & programming languages: C++, Oracle, PL/SQL, SQL