README.md

Bulletin by Goldman Sachs

This outlines the codebase of our submission for Goldmans Sachs Engineering Engage 2021 Hackathon

Table of Contents

1. About The Project
   • Customisable Report Rendering
2. Built With
   • Frontend
   • Backend
   • API
3. Our Solution
   • Architecture
   • Performance
4. Acknowledgments

About The Project

Customisable Report Rendering

To design a system that streamlines the report generation process by having a highly customizable, scalable, intuitive and automated report rendering solution.

(back to top)

Built With

Frontend

• Material UI
• React

Backend

• Java Spring Boot

API

• ExcelWriter
• FastAPI
• Pandas
• Python

(back to top)

Our Solution

Setting up a project

File and sheets naming

Drag and drop capabilities for organising tables on a sheet

Selecting columns for each respective table

Output Excel Report

(back to top)

Architecture

(back to top)

Performance

Measured on a t2-medium AWS EC2 instance (4gb RAM, 30gb Memory)

	Small Report (10 Rows x 1 Column)	Medium Report (5 Rows x 5 Columns)	Large Report (10 Rows x 10 Columns)
10 Concurrent Reports	0.85s	38.72s	137s
1000 Concurrent Reports	14.03s	173s	13mins

• Concurrent load scales well with small-sized, single sheet reports
• Considerable load scalability with medium-sized reports

(back to top)

Acknowledgments

• Ian Chia
• Joel Lim
• Jonathan Tan
• Quinn Cheong

(back to top)