Projects in the role of an data architect:> Data quality control system for DWH on Hadoop:Solution is implemented as a self-wriitten framework using SAS+PL/pgSQL, has its own metadata model for configuration and storing results, mail module for notifications, metrics and results visualisations in Grafana dashboards.Tech stack: Cloudera Data Platform (Hadoop, Impala, Sqoop), SAS, PostgreSQL, Grafana.> Analytical DWH for BI-reporting on Vertica:Data Warehouse is integrated with few data sources using different integration methods: Kafka, Batch ETL (ODBC, JDBC), REST APIs.All integrations and external data loading as well as internal ETL jobs are implemented using self-written Data Loading / ETL framework on Python supporting incremental loads, SCD implementations and other features as well as meeting all security requirements.Tech stack: Python, Vertica, IBM DataStage, Tableau, ELK, PostgreSQL, MS SQL> Operational Data Store on Oracle:The ODS is not just a replica, it builds and contains a historical layer based on source table changes coming throught CDC instrument Oracle GoldenGate.A PL / SQL framework is used to monitor, configure and perform history generation jobs, manage and create objects in ODS.Historical data is sent to Hadoop for long term storage and analytical usage.Adding a new object or source to the ODS is as automated as possible. No developer is required, most of the tasks are narrowed down to calling the framework API.Tech stack: Oracle GoldenGate, Qlik Replicate, Oracle DB, Hadoop > Anti Money Laundering Solution on Oracle:The solution was developed in accordance with the requirements of the Bank of Russia Directive 4936-U on mandatory financial monitoring and analysis of suspicious transactions and consists of different layers including WEB UI, Data Storage, ETL processes, integration with external systems.Tech stack: Oracle, Oracle Apex, SAS Base> Many other DWH, ETL, and integration solutions

Из крупных проектов:Поддержка и доработка CRM-системыРазработка ERP-системы по ТЗC#, Postgre, Access, 1С