Repository files navigation

SMU LIT Hackathon 2022

We are a team of 6 students from SMU and NTU, studying Law and Computer Science.

• Chen Xin Han | NTU Computer Science
• Ho Shu Hao Eugene | SMU Law
• Martin Liu | SMU Information Systems
• Ong Tsien Jin | NTU Computer Science
• Ramasamy Vignesh | SMU Computer Information Systems
• Toh Jing Hua | NTU Computer Science

Website:https://team-hotel-trivia-go.vercel.app/

Demo:https://youtu.be/ePtYqfwluSI

Devpost:https://devpost.com/software/hotel-trivia-go

Our team’s solution is aimed at improving the efficiency of lawyers’ work processes when drafting the Management’s Discussion and Analysis (“MD&A”) section in the prospectus in Capital Market US-related deals (SMU LIT Hackathon Problem Statement, 2022).

This is done by automating the process of extracting relevant economic data from financial statements and drafting excerpts of the MD&A section for the lawyer. By doing so, lawyers can spend minimal time on formulaic data entry work and instead, devote their time to considering the legal issues that their clients may face. Further, the risk of human error from copy-pasting and manual calculations would also be mitigated, if not fully removed.

Lawyers can use our solution by simply uploading a PDF copy of the relevant financial statements on our designated website, together with keywords provided by the user. Statements for the MD&A section will be generated automatically. Thereafter, the lawyer can make any necessary amendments or additions, such as to the possible reasons for the period-on-period changes, in finalising the MD&A into the prospectus that they were working on. Additionally, given that company financial statements are likely to contain sensitive data, our solution provides for data security by providing an option for lawyers to set a password when uploading financial statements, which would later be required to access the generated excerpts of the MD&A.

Project solution for our team can be foundhere.

Alternatively, the data can also be accessed via aRESTFUL API for this solution to be easily integrated into the existing workflows of legal entities working with other third-party service providers. This endpoint is available onhttp://api.teamhotel.dev/mda/get?session_token=[UUID] viaGET method. The schema is as follows:

{    _id: ObjectId(BSON),    isComplete: BOOL,    isError: BOOL,    sessionToken: STRING, // uuid    usePassword: STRING, // hash    time: STRING, // DD-MM-YYYY, HH:MM:SS AM/PM    mdna: { // Object        nameOfFile1.pdf: [ // array            'arrOfSTRING', // string        ],    },    fileNames: [ // array        'arrOfSTRING', // string    ]}

Note: Sample files can be foundhere

• Next.js hosted onVercel
• Flask backend for PDF analysis hosted onHeroku
• MongoDb hosted onMongoDB Atlas Database

• ReactJS File drag and drop
• Password hashing in JS | bycryptjs
• Handling multipart-form data on Next.js backend | formidable
• Formidable docs
• React v18useEffect() being called twice -- work around
• How To Read PDF Files in Python using PyPDF2
• Use Python to extract accounting data from a PDF on the web