Kolle Fedor

Design of Data Warehouses (Layers: Stage, ODS, DDS, PSA, Data Marts; Model: Star, Data Vault)
Development of Data Warehouses in Amazon Redshift, Snowflake, Greenplum for building BI analytics (T-SQL: procedures, views)
Work with Amazon Web Services (Redshift, DynamoDB, EC2, S3, RDS, Glue, SQS, SNS, Lambda)
Write Lambda functions in Python (lib: Pandas, Requests, NumPy, Boto3, SQL Alchemy, API, Flask)
Development of Data Warehouses and Data Lake house in MS Azure Synapse Analytics for building BI analytics (SQL, Spark, Medallion architecture: Bronze, Silver, Gold)
Work with MS Azure (Synapse Analytics, Data Factory, Data Lake Storage, Event Hubs, Databricks, Spark, ML, AD, Power BI)
Design of OLTP Database (schemas)
Development of Database in MS SQL server, PostgreSQL (views, procedures, functions, triggers)
Database programming in T-SQL (DDL, DML, DCL, TCL)
Development of BI reports in SSRS (MS Reporting Services), Power BI (DAX, Power Query), Grafana, SuperSet, Qlik Sense, Tableau, Streamlit Apps (web, python)
Development of ETL and ELT data pipelines for data integration with different sources (DB, API, Files) and external systems in MS Integration Services, Data Factory, Informatica, Airflow
Development of OLAP cubes, calculation dimensions (MS Analysis Services tabular, DAX metrics)
Optimization of the DB and DWH (indexes, distribution keys, Execution plan, SQL Server Profiler, Database Engine Tuning Advisor, Performance monitor, Query Store)
Application development in Python (lib: Pandas, Requests, NumPy, SQLAlchemy, API, Flask, Stream)
Multi-Container applications development on Docker (images, containers, compose)
Database administration (Job, backup, users, Linked server, cluster)
Work with team, version control (Git, GitLab, GitHub, TFS), Tasks (Jira), CI/CD (TeamCity, Flyway), documentation (Word, Excel, Visio, Project, Confluence), Agile methodology (Scrum)

Design of Data Warehouses (Layers: Stage, ODS, DDS, PSA, Data Marts; Model: Star, Data Vault)
Development of Data Warehouses in Amazon Redshift, Snowflake, Greenplum for building BI analytics (T-SQL: procedures, views)
Work with Amazon Web Services (Redshift, DynamoDB, EC2, S3, RDS, Glue, SQS, SNS, Lambda)
Write Lambda functions in Python (lib: Pandas, Requests, NumPy, Boto3, SQL Alchemy, API, Flask)
Development of Data Warehouses and Data Lake house in MS Azure Synapse Analytics for building BI analytics (SQL, Spark, Medallion architecture: Bronze, Silver, Gold)
Work with MS Azure (Synapse Analytics, Data Factory, Data Lake Storage, Event Hubs, Databricks, Spark, ML, AD, Power BI)
Design of OLTP Database (schemas)
Development of Database in MS SQL server, PostgreSQL (views, procedures, functions, triggers)
Database programming in T-SQL (DDL, DML, DCL, TCL)
Development of BI reports in SSRS (MS Reporting Services), Power BI (DAX, Power Query), Grafana, SuperSet, Qlik Sense, Tableau, Streamlit Apps (web, python)
Development of ETL and ELT data pipelines for data integration with different sources (DB, API, Files) and external systems in MS Integration Services, Data Factory, Informatica, Airflow
Development of OLAP cubes, calculation dimensions (MS Analysis Services tabular, DAX metrics)
Optimization of the DB and DWH (indexes, distribution keys, Execution plan, SQL Server Profiler, Database Engine Tuning Advisor, Performance monitor, Query Store)
Application development in Python (lib: Pandas, Requests, NumPy, SQLAlchemy, API, Flask, Stream)
Multi-Container applications development on Docker (images, containers, compose)
Database administration (Job, backup, users, Linked server, cluster)
Work with team, version control (Git, GitLab, GitHub, TFS), Tasks (Jira), CI/CD (TeamCity, Flyway), documentation (Word, Excel, Visio, Project, Confluence), Agile methodology (Scrum)

Design of OLTP Database and OLAP cubes
Development of Database in MS SQL server, PostgreSQL (procedures, functions, triggers, views)
Development of Data Warehouses, ETL and BI reports
Experience in MSBI Suite of products SSIS, SSRS, SSAS (DAX)
Knowledge of database programming using T-SQL (DDL, DML, DCL and TCL)
Experience in migration of data from any database using DTS, SSIS, Bulk insert and Linked server
Performance tuned stored procedures and query optimization
Development of SSRS Reports with sub reports (Matrix/Tabular Reports, Charts and Graphs)
Development of BI reports (PowerBI, DataZen, Grafana)
Development of OLAP cubes in Analysis Services (SSAS tabular, DAX)
Development of Web portal for analytics (C#, ASP.net, Entity Framework, JavaScript)
Experienced with source/version control software's: Git, TFS, Teamcity

Design of OLTP Database and OLAP cubes
Development of Database in MS SQL server, PostgreSQL (procedures, functions, triggers, views)
Development of Data Warehouses, ETL and BI reports
Experience in MSBI Suite of products SSIS, SSRS, SSAS (DAX)
Knowledge of database programming using T-SQL (DDL, DML, DCL and TCL)
Experience in migration of data from any database using DTS, SSIS, Bulk insert and Linked server
Performance tuned stored procedures and query optimization
Development of SSRS Reports with sub reports (Matrix/Tabular Reports, Charts and Graphs)
Development of BI reports (PowerBI, DataZen, Grafana)
Development of OLAP cubes in Analysis Services (SSAS tabular, DAX)
Development of Web portal for analytics (C#, ASP.net, Entity Framework, JavaScript)
Experienced with source/version control software's: Git, TFS, Teamcity

Development of Database MS SQL server and systems reporting (T-SQL, MS SSRS, MS SSIS)
Development of Windows Form Application (C#, Database, Reports)
Development of SCADA for automation systems (Wonderware System Platform, Intouch, InduSoft, Simatic WinCC, Adroit)
Development of programs for Programmable Logic Controller (PLC Trolex, Siemens, Unitronics)
Administration servers: MS windows (Hyper-V, Remote Desktop Services, Active Directory)
Management of the Automation Software Development Department

Development of Database MS SQL server and systems reporting (T-SQL, MS SSRS, MS SSIS)
Development of Windows Form Application (C#, Database, Reports)
Development of SCADA for automation systems (Wonderware System Platform, Intouch, InduSoft, Simatic WinCC, Adroit)
Development of programs for Programmable Logic Controller (PLC Trolex, Siemens, Unitronics)
Administration servers: MS windows (Hyper-V, Remote Desktop Services, Active Directory)
Management of the Automation Software Development Department

Development of Database MS SQL server and systems reporting (T-SQL, MS SQL, SSRS)
Development of SCADA for automation systems of mines (Wonderware System Platform, Intouch)
Development of programs for Programmable Logic Controller (PLC Trolex, C++, asm)
Writing applications for a data analysis and reporting (C#, C++, Delphi, VBA)
Working with databases MS SQL server and networks TCP/IP

Development of Database MS SQL server and systems reporting (T-SQL, MS SQL, SSRS)
Development of SCADA for automation systems of mines (Wonderware System Platform, Intouch)
Development of programs for Programmable Logic Controller (PLC Trolex, C++, asm)
Writing applications for a data analysis and reporting (C#, C++, Delphi, VBA)
Working with databases MS SQL server and networks TCP/IP