Fedor Kolle

- 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

- 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