Ihor Halas

is working from home. 🏡

Angestellt, Assistant Vice President, Barclays Bank

Prag, Tschechische Republik

Fähigkeiten und Kenntnisse

SQL Server
Ssas
Data Warehouse
T-SQL
Business Intelligence
Bank
Microsoft Power BI
ETL
Database
Architecture
Data Integration
Data Modeling
Data Modelling
SQL Development
Data Cleaning

Werdegang

Berufserfahrung von Ihor Halas

  • Bis heute 1 Jahr, seit Juli 2023

    Assistant Vice President

    Barclays Bank

  • 2 Jahre und 11 Monate, Aug. 2020 - Juni 2023

    MS SQL Developer, Senior Business Analyst

    Barclays Bank

  • 11 Monate, Okt. 2019 - Aug. 2020

    Database and Business Intelligence Consultant

    KMPG

  • 3 Jahre und 8 Monate, März 2016 - Okt. 2019

    Database and Business Intelligence Specialist

    KPMG

    • DataWarehouse, BigData. architecture design, Olap and Pivot tables. Tabular modelling; Power BI. • Data integration; ETL. Staging, Data Cleansing, Data Consolidation. Logging. • Data analyses. Reports development. Writing strong and effective T-SQL queries. • Visual Studio, TFS, SSMS, MS SQL Server Enterprise edition, SSRS, SSAS. • Code development, mapping, tests writing, data and database modeling, development. extention. • Work with metadata. Deployment. • Work with OLTP databases

  • 3 Monate, Dez. 2015 - Feb. 2016

    BI Analyst and Developer

    Provident Financial s.r.o. (IPF)

    • Developed Business Intelligence Solutions under platform MS SQL Server. Used T-SQL.

  • 1 Jahr und 9 Monate, Apr. 2014 - Dez. 2015

    Analyst (BI developer, Architekt, datawearhousing)

    NATLAND Group, SE; (EC Financial Services)

    • Developed Business Intelligence Solutions under platform MS SQL Server. Data Integration • Created DWH architecture, programmed, tested code. Data modeling. • Used T-SQL and wrote test codes at low level (procedures, functions, created indexes e.t.c.). • Used MS tools like, SSRS, SSAS, SSMS. OLAP, Data Mining. • Performed MS SQL Server Data Warehouse development and MS SQL Server administration. • Wrote ETL processes for DWH. Created analytical system. Performed data analysis.

  • 8 Jahre und 5 Monate, Nov. 2004 - März 2013

    Risk Manager

    PUBLIC JOINT-STOCK COMPANY «COMMERCIAL INVESTMENT BANK»

    • Developed Risk Management conception, policies and methodologies of banking risks assessment. • Identified, assessed, monitored such banking risks as: credit risk, liquidity risk, interest rate risk. foreign exchange risk. Calculated, proposed level of limits. Determined concentrations, diversifications. Performed forecasting. etc. • Created, developed and maintained Risk Management software. MS SQL Server. Used T-SQL. Built risk stress scenarios.

  • 1 Jahr und 1 Monat, Nov. 2003 - Nov. 2004

    Engineer-programmer

    Brokbusinessbank

    • Supported and maintained functionality of the operating bank day. • Administered and configured Windows Servers 2003 including Active directory. • Tuned workstations and controlled them. • Arranged permissions and gave the right to access to different sources • Supported and created different types of communication. • Repaired computers. Identified problems and solved them (hardware and installing software, testing).

  • 1 Jahr, Nov. 2002 - Okt. 2003

    IT-Administrator

    JSC KREDOBANK

    • Supported and maintained functionality of the operating bank day. • Administered and configured Windows Servers 2003 including Active directory. • Tuned workstations and controlled them. • Arranged permissions and gave the right to access to different sources • Supported and created different types of communication. • Repaired computers. Identified problems and solved them (hardware and installing software, testing).

Ausbildung von Ihor Halas

  • 2 Jahre und 10 Monate, Sep. 2003 - Juni 2006

    Uzhgorod National Universität

  • 4 Jahre und 10 Monate, Sep. 1996 - Juni 2001

    Uzhgorod National Universität

Sprachen

  • Englisch

    Fließend

  • Deutsch

    Grundlagen

  • Russisch

    Fließend

  • Tschechisch

    Fließend

  • Ungarisch

    Grundlagen

Interessen

Schwimmen
Natur

21 Mio. XING Mitglieder, von A bis Z