Ihor Halas

is working from home. 🏡

Angestellt, Assistant Vice President, Barclays Bank
Prag, Czech Republic

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

  • Current 2 years and 11 months, since Jul 2023

    Assistant Vice President

    Barclays Bank

  • 2 years and 11 months, Aug 2020 - Jun 2023

    MS SQL Developer, Senior Business Analyst

    Barclays Bank

  • 11 months, Oct 2019 - Aug 2020

    Database and Business Intelligence Consultant

    KMPG

  • 3 years and 8 months, Mar 2016 - Oct 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 months, Dec 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 year and 9 months, Apr 2014 - Dec 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 years and 5 months, Nov 2004 - Mar 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 year and 1 month, 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 year, Nov 2002 - Oct 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 years and 10 months, Sep 2003 - Jun 2006

    Uzhgorod National Universität

  • 4 years and 10 months, Sep 1996 - Jun 2001

    Uzhgorod National Universität

Sprachen

  • English

    C1 (Fließend)

  • German

    A1-A2 (Grundkenntnisse)

  • Russian

    C1 (Fließend)

  • Czech

    C1 (Fließend)

  • Hungarian

    A1-A2 (Grundkenntnisse)

XING – Das Jobs-Netzwerk

  • Über eine Million Jobs

    Entdecke mit XING genau den Job, der wirklich zu Dir passt.

  • Persönliche Job-Angebote

    Lass Dich finden von Arbeitgebern und über 20.000 Recruiter·innen.

  • 21 Mio. Mitglieder

    Knüpf neue Kontakte und erhalte Impulse für ein besseres Job-Leben.

  • Kostenlos profitieren

    Schon als Basis-Mitglied kannst Du Deine Job-Suche deutlich optimieren.

21 Mio. XING Mitglieder, von A bis Z