Position: DWH Architect, DB Architect
Category: Lead
English level: upper
Years of experience: 11

Projects Description
Project Name:  PSVOD, AMC Networks (USA) (LLC «DataMola Ukraina» 2022-2023)
Product goal: Developing DWH solution for loading and analyzing data about Suggestions from Snowflake warehouse
Role: DWH Architect
Technologies: Snowflake DB, Tableau, Python

Project Name:  PSVOD, AMC Networks (USA) (LLC «DataMola Ukraina» 2019-2022)
Product goal: Developing DWH solution for loading and analyzing data about Subscriptions and Viewing
Role: DWH Architect
Technologies: IBM DB2, Microsoft SSIS, Node.JS, AngularJS

Project Name:  MDM, AMC Networks (USA) (LLC «DataMola Ukraina» 2021-2022)
Product goal: Developing the system to load, store and manipulate MDM (master data management) data
Role: DB Architect
Technologies: IBM DB2, Microsoft SSIS, Node.JS, AngularJS, IBM Cloudant (document oriented DB)

Project Name:  Data Quality System, AMC Networks (USA) (LLC «DataMola Ukraina» 2020-2021)
Product goal: Developing the system to load, store and manipulate data about Data Quality
Role: DB Architect
Technologies: IBM DB2, Microsoft SSIS, Node.JS, AngularJS, Apache Kafka

Project Name:  INGO Ukraine (JSC «DATAS Technology» 2017-2019)
Product goal: Developing the system of operating BI reports using data from Teradata warehouse
Role: Solutions Architect
Technologies: Oracle BI EE, Teradata DB, ETL ODI, Oracle DB 11g, Microsoft SQL Server

Project Name:  Deals Solutions (JSC «DATAS Technology» 2018-2019)
Product goal: Implementation the cloud ERP system Oracle NetSuite
Role: Senior Developer
Technologies: Oracle NetSuite (cloud ERP), Oracle DB 11g, JavaScript

Project Name:  International Bank of Azerbaijan (Baku, Azerbaijan) (JSC «DATAS Technology» 2015-2016)
Product goal: Migration system Oracle FLEXCUBE Universal Banking version 10 to version 12. Migration reports from SAP Business Objects to Oracle BI EE
Role: Senior Developer, System Integrator
Technologies: Oracle FLEXCUBE Universal Banking, Oracle DB 11g, Oracle BI EE

Project Name: SBERBANK OF RUSSIA (JSC «DATAS Technology» 2014-2015)
Product goal: Developing the system of operating BI reports using data from Teradata warehouse
Role: Team lead of developers
Technologies: Oracle BI EE, Teradata DB, ETL Informatica
Work experience in IT sphere: more 15 years.
-	design DWH solutions for stored big data into RDBMS and OLAP DB;
-	design and develop ETL solutions for loading data from different sources and systems;
-	design Data Mart areas to use for different information and reporting systems;
-	implementation and software support at enterprise;
-	survey of enterprise, preparation the project documentation and specification;
-	software development (including designing, development, implementation and support stages) based on client-server technology, WEB with DBMS ORACLE, Microsoft SQL Server, Hyperion EssBase;
-	data base structure designing using CASE-tools both for transactional systems, and for OLAP systems;
-	integration of different information systems, information consolidation in order to create common storage for analysis using OLAP (ROLAP, MOLAP) technology;
-	development and installation of security policy, information systems backup and recovery;
-	application systems and databases work optimization;
-	developing and conducting software presentations.

Technologies:	DWH, RDBMS, OLAP, ETL, BI;
DataBase: SnowFlake, Oracle, IBM DB2, Teradata, Microsoft SQL Sever, Hyperion EssBase, Microsoft SQL Server Analysis Services;
ETL Tools: Oracle Data Integrator, Microsoft SQL Server Integration Services, ETL Informatica, Hyperion Data Integration Management, Oracle Warehouse Builder;
BI Tools:	Oracle BI EE, Tableau, Hyperion Financial Reporting;
Development Tools:	SAP PowerDesigner, Git, Bitbucket, Jira, BPwin, Erwin, PLSQL Developer, DBeaver, SQL Navigator, Toad, Oracle Discoverer;
Programming Languages:	PL/SQL, MDX, JavaScript, MaxL, Delphi, Python;
Information system:	NetSuite, Oracle E-Business Suite, Oracle FLEXCUBE Universal Banking, Oracle Hyperion Planning, Hyperion Data Relationship Management;