Michael Kooloos, Data Engineer Developer in Valencia, Spain
Michael Kooloos

Data Engineer Developer in Valencia, Spain

Member since October 30, 2020
Michael is an all-around big data, BI, and DWH analytics engineer with over 20 years of experience. He has a quick understanding of the information needs of the business and is experienced in all phases of a project from analysis and design to development and end-user training and support. He is best in complex environments when technology needs to result in real business value by delivering the right information to the right person at the right time.
Michael is now available for hire

Portfolio

Experience

Location

Valencia, Spain

Availability

Part-time

Preferred Environment

Agile, Python, SQL, Docker, PostgreSQL, Linux

The most amazing...

...real life problem I solved is a module for the prediction and calculation of forecast figures for the maintenance on escalators on a big international airport.

Employment

  • Data Analytics Engineer

    2015 - PRESENT
    Freelance/Self-employed
    • Developed a data warehouse using metadata-driven data vault code automation.
    • Analyzed requirements for a new corporate dashboard, analyzed data, and created a solution design.
    • Developed a data pipeline for monitoring machine logs to detect possible bugs after software upgrades.
    • Analyzed and tuned several performance issues bringing query runtimes back from minutes to milliseconds.
    • Developed a point-in-time detection of non-conformances of machine constants.
    • Led a team of data warehouse developers for the development and implementation of a mortgage data warehouse.
    • Developed a unified product catalog and several pipelines for the synchronization of vendor-specific attributes.
    • Implemented a way of working and created guidelines for conceptional data modeling as part of the data governance strategy.
    Technologies: ETL, PL/SQL, Data Warehousing, Analytics, Data Analysis, Data Pipelines, Performance Analysis, Oracle RDBMS, Dashboard Design, Business Process Analysis, Agile, Scrum, Data Warehouse Design, Data Engineering, Data Vaults, Netezza, Microsoft Power BI
  • Owner, Co-founder, and Solutions Architect

    2013 - 2015
    BiiT Sourcing Solutions
    • Led a team of application developers for the development and implementation of several cloud-based applications.
    • Organized work to meet goals and deadlines while ensuring that the technical solution supported the business objectives.
    • Designed solutions for our clients on numerous projects, using both existing and proven open-source software, components, and frameworks and our own products to deliver custom cloud-based solutions.
    • Enabled digital transformation of organizations through process optimization and real-time information access to deliver the right information to the right person at the right time.
    Technologies: Amazon Web Services (AWS), Analytics, Data Analysis, Data, Drools BRMS, Activiti BPM, Agile, Business Process Modeling, SWOT Analysis, Requirements Analysis, Kanban, Scrum
  • Application Engineer/Architect

    2010 - 2013
    Freelance/Self-employed
    • Implemented proof of technology for IoT beacon processing for indoor positioning to deliver smart shopping presentations.
    • Developed a real-time search and analytics platform based on Apache Solr for metal traders and exchanges.
    • Designed and developed an open-source enterprise information access platform based on Hadoop (distributed file system and processing), Apache Solr (search engine), and Apache Mahout (machine learning/predictive analytics).
    • Built a back-end rule engine for individual training schedule creation.
    • Created web-based applications for registering, visualizing, and analyzing individual athlete and team progress for performance, recovery logs, and test results.
    Technologies: Data Architecture, Data Lakes, Data Analysis, MySQL, PostgreSQL, Data Pipelines, Analytics, Big Data Architecture, Big Data, Activiti BPM, Drools BRMS, MongoDB, Elasticsearch, Apache Solr, Hadoop, R
  • Business Intelligence and Data Warehouse Consultant

    2002 - 2010
    Scamander Solutions
    • Developed a data warehouse for multiple hospitals for patients, medical cases, transfers, diagnoses, and observations.
    • Created a data warehouse for alerts/violations derived from city control.
    • Designed and developed several semantic layers for end-user presentations for both analytical and operational reporting purposes.
    • Built dashboards, custom visualization widgets, and both analytical and operational reports for finance, sales, marketing, HR, healthcare, manufacturing, and supply chain.
    • Developed a set of triggers and PL/SQL packages to predict and calculate forecast figures for the maintenance of escalators on a big international airport.
    • Led a project to implement a data warehouse solution for a big telco provider and the interfacing of product and invoice data to the customer web portal.
    Technologies: Data Architecture, PL/SQL, Databases, Analytics, Data Warehouse Design, Data Warehousing, Business Intelligence (BI), Data, Data Modeling, Oracle PL/SQL, SQL, D3.js, Tableau, Oracle Data Integrator (ODI), Oracle BI, Talend, Oracle RDBMS
  • Oracle Consultant

    1998 - 2002
    Getronics Software Solutions
    • Developed customizations and gave third-line technical support in an Oracle Manufacturing environment.
    • Analyzed, designed, and developed a custom Oracle system for mailing and registration to support a high output of forms.
    • Developed and gave support to a custom Oracle system for order management.
    Technologies: Databases, PL/SQL, Performance Analysis, Oracle PL/SQL, Oracle E-Business Suite (EBS), Oracle RDBMS

Experience

  • Prediction and Calculation of Forecast Figures for The Maintenance on Escalators

    To avoid maintenance during rush hours and prevent accidents, I developed a module for predicting and calculating forecast figures for the maintenance of escalators in a big international airport. The analysis showed that changes in energy consumption of certain parts could indicate technical problems resulting in (future) breakdowns.

  • Performance Analysis and Tuning for Machine Logs

    Performance analysis and tuning of non-conformances detection of machine constants stored in a Netezza data warehouse appliance for semiconductor machine logs.

    I analyzed and tuned several performance issues to store and retrieve the data, bringing query runtimes back from minutes to milliseconds. I redeveloped the data pipeline so it would only store changes in machine constants (constants only change in less than 1% of the cases) instead of always storing all the machine constants and the complete machine log. I further designed and developed a point-in-time detection for the monitoring of non-conformances.

  • Digital Signage - Event and Sensor Data Processing and Data Visualization

    Implementation of proof of technology for IoT beacon processing for indoor positioning to deliver smart shopping presentations to customers.

    I designed a solution using existing and proven open-source software, components, and frameworks, developed a data pipeline to store and process IoT beacon data, and used device detection for indoor positioning and proximity engagement. Furthermore, I used digital signage to deliver smart and interactive advertisements. For hot zone and cold zone detection, I developed heatmap visualizations so store flow could be visualized.

Skills

  • Languages

    SQL, Python, R
  • Tools

    Oracle E-Business Suite (EBS), Apache Solr, Tableau, Microsoft Power BI
  • Paradigms

    Requirements Analysis, Business Intelligence (BI), Scrum, Agile, Kanban, ETL
  • Storage

    Oracle RDBMS, Oracle PL/SQL, Databases, PL/SQL, Netezza, PostgreSQL, Data Pipelines, MySQL, Data Lakes, Elasticsearch, MongoDB
  • Other

    Data Engineering, Data Visualization, Business Process Analysis, Data Warehouse Design, Dashboard Design, Performance Analysis, Oracle BI, Data, Data Warehousing, Analytics, Data Analysis, Data Vaults, Data Modeling, Business Process Modeling, Data Architecture, SWOT Analysis, Conceptual Design, Drools BRMS, Big Data, Big Data Architecture
  • Platforms

    Talend, Docker, Linux, Oracle Data Integrator (ODI), Amazon Web Services (AWS)
  • Frameworks

    Hadoop, Activiti BPM
  • Libraries/APIs

    D3.js

Education

  • Bachelor of Science Degree in Information Technology
    1995 - 1998
    The Hague University of Applied Sciences - The Hague, The Netherlands

Certifications

  • Containers and Microservices
    JUNE 2020 - PRESENT
    IBM Big Data University
  • Applied Data Science with Python
    JUNE 2020 - PRESENT
    IBM Big Data University
  • Spark, Hadoop Data Access and Big Data Analytics
    SEPTEMBER 2017 - PRESENT
    IBM Big Data University
  • Professional Scrum Master (PSM I)
    MARCH 2015 - PRESENT
    Scrum.org
  • Certified Business Intelligence Professional (CBIP)
    MAY 2007 - PRESENT
    TDWI.org
  • Oracle Business Intelligence (OBIEE)
    APRIL 2007 - PRESENT
    Oracle
  • Oracle Designer for Conceptual Design
    OCTOBER 2000 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others