Ira van den Broek

Designing and developing Data Warehouse solutions: data analysis and data modeling, development

Extension of data warehouse, specifically reference data sets for risk models. Analysing functional requirements; writing technical designs; data modelling in PowerDesigner. Tools and technologies: PowerDesigner, Teradata, Git, Jenkins

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.

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

Developing ETL mappings in Master Data Management system

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

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

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.

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.

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.

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.

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.

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.

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

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

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