Medicine Data Portal

This repository contains source code of a prototype version of an official project I have worked on. It is a Data Reporting Portal for a large sized pharma company which has multiple partner pharma companies.

URL: The prototype is hosted live on my personal Free Tier AWS instance at: http://mdp.kajadhav.me

Table of Contents

1. System Description and Functions
2. Built With
3. Installation
4. Authors
5. Links

System Description and Functions

For more Screenshots, refer to the Sample Use Case Documentation of this repo or click here

Medicine Data Portal is a data reporting tool designed by me and my team for our client – a large sized pharmaceutical company. Our client has several other pharmaceutical companies as their partners. The data portal helps communicate information and maintain records between our client company and their partners. It maintains records in three business reports used by the companies, namely: Product Development Timeline (PDT), Filing Plans and Sales Report. The Software Backend has two user roles, namely Admin and Partner.

1. Thousands of Partner companiess can simultaneously Create, Retrieve, Update and Delete millions of records in three business reports: PDT, Filing Plans and Sales Report.
2. Partners can Create, Retrieve, Update and Delete their profile information.
3. Admins can Create, Retrieve, Update and Delete Partners, Products and Country list and each Partner's PDT, Filing Plans and Sales Report.
4. Partners can submit their PDT, Filing Plans and Sales Report for approval.
5. Admin can Approve or Reject PDT, Filing Plans and Sales Report.
6. Admins and Partners can talk to each other via real time chat.
7. Admins and Partners get emails about report approvals or rejections and general emails like forgot password, etc.
8. Admins can also see consolidated PDT, Filing Plans and Sales Report of all partners and filter and sort them by different columns.
9. Admins and Partners can download all reports they see to csv files and also copy paste records into the portal from csv files.
10. Admin is also given access to a customized dashboard which shows different summaries regarding all the partners and their reports and provides business insights regarding the sales of each Product by each Partner.
    
    

Built With

Installation

1. Install Git, Docker and docker-compose.
2. Clone the repo and cd into it.
3. Set appropriate AWS EC2 and RDS creds in .env files.
4. Run sudo docker-compose up -d.

Authors

Kaushik Jadhav

• Github:https://github.com/kaushikjadhav01
• Medium:https://medium.com/@kaushikjadhav01
• LinkedIn:https://www.linkedin.com/in/kaushikjadhav01/
• Portfolio:http://kajadhav.me/

Links

• Web site
• Documentation
• Issue tracker
• Source code