Automation via KNIME, Python and SQL: 30 hrs/month saved

KNIME DAG illustration

Problem

client from financial sector had Excel and SQL workflows requiring a significant amount of manual effort and judgement.

Contribution

  • implementation of low-code solution in client’s environment using KNIME workflows
  • wrote Python code where KNIME was unable to handle complexity
  • called external API for additional automation and validation
  • negotiated contract with external API provider on behalf of client

Outcome

  • automation saved 30 person-hours per month for client
  • external API validation provided higher data quality
  • project payback in < 1 year