Our firm produces a large number of financial reports which are delivered to stakeholders on a daily basis. Many of these reports involve human touchpoints, and we are looking to streamline this process by automating the reporting rendering process. The solution would be a highly performant API-Driven platform that is able to consume JSON data, and produce formatted excel reports based on the users’ template. Users should be able to interact with the data inputs, and intuitively design the templates with all the formatting and sizing they need.
Below are the constraints to observe:
The solution should not use vendor rendering products on the market.
We encourage implementation based on open-source projects. Java based solution is preferable.
The solution should allow concurrently rendering multiple reports. It is up-to participants to evaluate system performance and scalability.
The solution should allow similar reports sharing the same Excel template. A simple UI should be provided to Add/Delete/View templates.
The rendering request should be triggered over HTTP. JSON dataset should be retrieved over HTTP.

Problem Statement 2