Yair Czitrom

Senior Data and BI Consultant at Delegate
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Copenhagen, Capital Region, Denmark, DK
Languages
  • English -
  • Danish -
  • Hebrew -
  • Spanish -
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Armas Paludan

Fik selv det komplicerede til at blive let

Claus Toftkær ☁★☁

I have worked with Yair as manager when he was working in IT operation as system administrator. Yair is very high skilled in what he do and is always fast to learn new skills. He was a key figure in the IT-team. As system adminstrator he had a lot of knowledge and where a part of designing the systems, he always took the business side into consideration when designing a system as well as a great technical pre-sale foundation. I can only give him my very best recommendations.

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Microsoft Certified: Azure Data Engineer Associate
    Microsoft
    Jun, 2021
    - Nov, 2024
  • Implementing an Azure Data Solution
    Microsoft
    May, 2021
    - Nov, 2024
  • Designing and Azure Data Solution
    Microsoft
    Apr, 2021
    - Nov, 2024
  • MCSA: SQL 2016 Business Intelligence Development - Certified 2020
    Microsoft
    May, 2020
    - Nov, 2024
  • Developing SQL Data Models
    Microsoft
    Mar, 2020
    - Nov, 2024
  • Microsoft Certified Solutions Expert: Data Management and Analytics Certification
    Microsoft
    Mar, 2020
    - Nov, 2024
  • Analyzing and Visualizing Data with Microsoft Power BI
    Microsoft
    Jun, 2019
    - Nov, 2024
  • MCSA: BI Reporting
    Microsoft
    Jun, 2019
    - Nov, 2024
  • Analyzing and Visualizing Data with Microsoft Excel
    Microsoft
    Mar, 2019
    - Nov, 2024
  • IBM Tivoli Technical Sales Master
    IBM
    Oct, 2009
    - Nov, 2024
  • IBM Tivoli Top Gun
    IBM
    Jun, 2007
    - Nov, 2024
  • ITIL
    IBM Danmark ApS
    Jan, 2007
    - Nov, 2024
  • MCSE 2003 + M
    Microsoft
    Jan, 2007
    - Nov, 2024

Experience

  • Delegate
    • Denmark
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • Senior Data and BI Consultant
      • Nov 2021 - Present

      * Data architecture * Data solutions. * Data lakehouse * Modern data warehouse * Data analysis * Azure data platform (including Apps, Logic apps, Automate, Power Bi and Synapse) * ETL * SQL * Azure dev ops * Data architecture * Data solutions. * Data lakehouse * Modern data warehouse * Data analysis * Azure data platform (including Apps, Logic apps, Automate, Power Bi and Synapse) * ETL * SQL * Azure dev ops

  • Udviklings- og Forenklingsstyrelsen
    • Denmark
    • Government Administration
    • 700 & Above Employee
    • Chefkonsulent - Data and BI Senior Analyst
      • Oct 2020 - Oct 2021

      • In charge of the data and BI in the Service management department • In charge of the technical infrastructure of the data flow (back end and front end) • Senior BI backend and frontend consultant (including Azure technology, SQL and DB’s, Data factory, AAS, Dev Ops and Power BI) • End to end BI project owner • BI mentor and instructor • In charge of delivering BI projects to the customers including presentations and workshops • In charge of the data and BI in the Service management department • In charge of the technical infrastructure of the data flow (back end and front end) • Senior BI backend and frontend consultant (including Azure technology, SQL and DB’s, Data factory, AAS, Dev Ops and Power BI) • End to end BI project owner • BI mentor and instructor • In charge of delivering BI projects to the customers including presentations and workshops

  • FDM
    • Denmark
    • Motor Vehicle Manufacturing
    • 200 - 300 Employee
    • BI and Business Analyst
      • May 2018 - Sep 2020

      • Building and improving the existing and new BI infrastructure (portal, cubes, tabulars, BI reports) • Supporting the business with operational data and analyzes by delivering dashboards which: o Help understand and manage member portfolio development (approach / departure) o Support streamlining contact center processes o Provide campaign performance insights o Enable product managers in improving their product areas • Combining local and external data to provide actionable, value-creating insights, including income assurance, through new dashboards • Ensuring data quality and uniformity in operational reporting (MS SQL and DWH) • Extending the use of Power BI in self-service, operational BI Show less

  • KMD
    • Denmark
    • IT Services and IT Consulting
    • 700 & Above Employee
    • BI and Business Consultant
      • Apr 2015 - May 2018

      • Delivered BI analysis and business reports and optimization (MS Power Suite and Power BI) • Created and developed the Power BI reports in the KMD WorkZone • Produced internal and customer reports and analysis • Performed project management and planning • Building and configuring custom made Power BI on premises server. • Delivered BI analysis and business reports and optimization (MS Power Suite and Power BI) • Created and developed the Power BI reports in the KMD WorkZone • Produced internal and customer reports and analysis • Performed project management and planning • Building and configuring custom made Power BI on premises server.

  • YHC Consulting
    • Denmark
    • Web & BI Consultant (parallel to MSC. Studies)
      • Jan 2014 - Jul 2015

      • BI reporting • Business development • Website and web shop development including SEO • Marketing and social media • BI reporting • Business development • Website and web shop development including SEO • Marketing and social media

  • SEO-1
    • Co-Founder/IT & Web Solution Consultant
      • May 2011 - Dec 2013

      • IT and web solutions consulting, pre-sales, requirements specification, offers, and delivery • Project management and planning • International training, and customer support • IT and web solutions consulting, pre-sales, requirements specification, offers, and delivery • Project management and planning • International training, and customer support

  • Pedab Sweden AB
    • Sweden
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Tivoli Enablement and Speciality (in continuation of IBM)
      • May 2009 - Jun 2011

      • Delivered demos, POCs/POTs, seminars, and implementations of Tivoli solutions (business automation) • Partner tech and pre-sales consultant across Sweden and Finland including knowledge transfer, joint pitches and customer meetings, POC/POT delivery, and pricing negotiations with IBM • ITIL methodology-based advisor to enterprise customers in business automation and cloud computing • Identified, marketed, and pitched to deliver prospects to partners • Delivered demos, POCs/POTs, seminars, and implementations of Tivoli solutions (business automation) • Partner tech and pre-sales consultant across Sweden and Finland including knowledge transfer, joint pitches and customer meetings, POC/POT delivery, and pricing negotiations with IBM • ITIL methodology-based advisor to enterprise customers in business automation and cloud computing • Identified, marketed, and pitched to deliver prospects to partners

  • IBM
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Tivoli Specialist consultant - Tech sales
      • Jan 2007 - Apr 2009

      Tivoli Specialist consultant and technical sales in Tivoli business automation products. Premier in Denmark and secondary in Scandinavia. • Presented and created solutions/POCs/POTs for customers based on their needs (SMBs and enterprise) • IBM Tivoli product presentations and seminars to customers and partners Tivoli Specialist consultant and technical sales in Tivoli business automation products. Premier in Denmark and secondary in Scandinavia. • Presented and created solutions/POCs/POTs for customers based on their needs (SMBs and enterprise) • IBM Tivoli product presentations and seminars to customers and partners

  • Scandlines
    • Denmark
    • Truck Transportation
    • 400 - 500 Employee
    • System Administrator
      • 2004 - 2007

      System administrator and IT responsible for the ships and maritime systems on land and on board. System administrator and IT responsible for the ships and maritime systems on land and on board.

  • ProffCom AB
    • Outsourcing and Offshoring Consulting
    • 1 - 100 Employee
    • System Administrator
      • 1999 - 2003

      system administrator and IT responsible of the company’s call center in terms of IT and telephone systems system administrator and IT responsible of the company’s call center in terms of IT and telephone systems

Education

  • Copenhagen Business School
    MSc in Business Administration and Information Systems, Business Administration and Information Systems
    2015 - 2016
  • IBM England
    Tivoli Monitoring Technical Sales Professional, Tivoli Monitoring Solutions
    2009 - 2009
  • IBM
    ITIL Cert., ITIL
    2007 - 2007
  • Azlan - Data group
    MSCE +M, MSCE 2003
    2005 - 2006
  • Sela Institution
    SW Programming, C, C++, SQL, VISUAL BASIC programmering
    1998 - 1999
  • Bar-Ilan University
    B.a, Political science and marketing
    1996 - 1998

Community

You need to have a working account to view this content. Click here to join now