Ira van den Broek

Premium

Freiberuflich / Selbstständig, Freelance BI Consultant, I Am On It

Amsterdam, Netherlands

Skills

Oracle
ETL
Datavault
Snowflake
Data Warehouse
Business Intelligence
Data Engineering
Requirements Analysis
Data Modeling
Dimensional Modeling
Informatica PowerCenter
AWS
Datenanalyse
PL/SQL
Oracle SQL Developer
Agile
Agile Development
Scrum (software development)
SQL
Software Development
Entwurf

Timeline

Professional experience for Ira van den Broek

  • Current 8 years and 7 months, since Nov 2013

    Freelance BI Consultant

    I Am On It

    Designing and developing Data Warehouse solutions: ETL, reporting. Information analysis and data modeling.

  • 2 years and 1 month, Feb 2020 - Feb 2022

    Data Analyst

    EDSN

    Designing and developing datawarehouse applications: analysing data sources, data modeling, writing ETL flows, implementing data architecture in Snowflake. Advice for reporting dashboards, designing dimensional datamarts and developing dataflows to load them. Tools and technologies: Snowflake, SQL / Javascript, AWS, Git, data vault modeling, dimensional modeling.

  • 3 months, Jul 2019 - Sep 2019

    Data Engineer

    SIEMENS

    Migrate ETL to Snowflake; data analysis, conversion Talend jobs. Tools and technologies: Talend, Snowflake, GitLab

  • 2 years, Jul 2017 - Jun 2019

    BI Consultant

    Bayer AG, Pharmaceuticals Division

    Developing ETL mappings in Master Data Management system

  • 9 months, May 2016 - Jan 2017

    BI Consultant

    Eneco Energie

    Data analysis for and development of a predictive model. Improving reporting scripts (PlSQL). Implementing SubVersion. Tools and technologies: Oracle 11g and Exadata, Pl/SQL, Tortoise SVN, Agile

  • 11 months, Apr 2015 - Feb 2016

    Application Consultant Senior

    Nuon

    Designing and developing ETL for adding new sources to the Data Warehouse. Data analysis (SAP and Siebel source systems) for improvements to datamarts. Tools and technologies: Oracle 11g, Pl/SQL, Data Vault

  • 9 months, Jul 2014 - Mar 2015

    BI Architect / senior BI Developer

    Cengage Learning

    Designing and developing a metadata driven ETL framework in Pl/SQL and Python. Investigating and implementing data solutions in Cloud computing, Big Data. Tools and technologies: Oracle 11g, Redshift, Amazon Cloud applicaties (Oracle RDS, EC2, S3), Pl/SQL, Python, dimensional modeling, agile work methods.

  • 3 months, Nov 2013 - Jan 2014

    Senior OWB Developer

    ABN Amro Verzekeringen

    Adding data from a new source to an existing data warehouse. Designing dimensional model, developing ETL code. Tools and technologies: Oracle 11g, OWB, Toad, dimensional modeling.

  • 9 months, Jul 2012 - Mar 2013

    Database Developer

    AMC Clinical Research Unit

    Development of web based database applications in Java. Migrating database applications (Tomcat upgrade) and planning and co-ordinating database migration (SQLServer upgrade). Tools and technologies: Java, JavaScript, jQuery, MS SQLServer, MS Report Builder.

  • 3 years, May 2009 - Apr 2012

    Data Manager International Polar Year (IPY)

    NIOZ Royal Netherlands Institute for Sea Research

    Archiving and publishing data from polar scientific research. Investigating and solving issues regarding the data management and metadata. Collaborating in national an international organisations exchanging knowledge about preserving and publishing data. Tools and technologies: Sybase AS, Sybase PowerDesigner, Oracle DB, MySQL, PostgreSQL, PHP, JavaScript / jQuery, GIS applications (PostGIS, OpenLayers), Eclipse, SubVersion in Tortoise.

  • 4 years and 8 months, Sep 2004 - Apr 2009

    Datawarehouse Information Manager, Senior Information Manager

    ING

    Co-development of dimensional model. Design and development of ETL code (Oracle Warehouse Builder and Unix shell scripts). Design and creation of reports in Oracle BI Enterprise Edition and of tailor-made query and reporting applications in PlSQL Tools and technologies: Oracle DB, Oracle Warehouse Builder, Oracle BI Enterprise Edition, Kimball DM, Oracle SQL Developer, Pl/SQL Developer, Toad, Unix AIX, Pl/SQL, HMTL, CSS.

  • 2 years and 9 months, Dec 2001 - Aug 2004

    Application Support Employee

    Postbank N.V.

    Development of and support for intranet applications. Support for Chordiant MD. General Service Desk tasks. Redesign of the intranet of the department, and the design and development of an incident registration tool linked to a "face book" of the department for the helpdesk. Used tools and technologies: Oracle DB, Oracle Portal, Chordiant MD, PL/SQL, ASP, JavaScript, HTML and CSS, ITIL.

  • 1 year and 2 months, Oct 2000 - Nov 2001

    Internet Programmer

    PTS Software B.V.

    Development of websites in HTML, CSS, ASP, JavaScript, VBScript.

  • 1 year and 11 months, Nov 1998 - Sep 2000

    Internet Programmer

    Foundation PZ

    Technical design, development and support for websites and CMS applications in HTML, CSS, ASP and Access, VBScript, JavaScript. Project planning and coordination.

Educational background for Ira van den Broek

  • 3 years and 10 months, Sep 1999 - Jun 2003

    Information technology

    College of Advanced Education Amsterdam

    UML, Database Design, ITIL, DSDM, SQL, Perl, Java, C++

Languages

  • English

    Fluent

  • German

    Intermediate

  • French

    Intermediate

  • Dutch

    First language

Wants

Career Opportunities
Data Warehouse
Business Intelligence

Interests

Japanse language and culture
Aikido
Alternative cinema

Browse over 20 million XING members