New webbased software

Job ID: 37583227

Budget: ₹12,500 – ₹37,500 INR

I am looking for a skilled freelancer to develop a new web-based software that will serve as a graphical reporting tool. The main functionality of the software will be to generate detailed graphical reports for data analysis.

Project Summary:

Core Functionalities:

Data Acquisition:

Fetch data from a web portal using SOAP queries
Connect to multiple external databases (Oracle, MSSQL, MySQL)
Store all retrieved data within a PostgreSQL database
Data Visualization:

Create a web portal to display the stored data
Implement role-based access control (RBAC) for user-specific views and permissions
Technical Stack:

Backend: Python (recommended for SOAP handling and database interactions), Flask (potential web framework)
Database: PostgreSQL
Frontend:
Suggestions: React, Vue.js, Angular (for modern and interactive interfaces), or Django templates (for simpler integration with Flask)
Key Considerations:

SOAP Library: Select a suitable library for SOAP interactions (e.g., Zeep for Python)
Database Connectors: Install appropriate drivers for each external database (e.g., psycopg2 for PostgreSQL, cx_Oracle for Oracle)
User Authentication: Implement a secure authentication mechanism (e.g., Flask-Login)
Authorization: Enforce RBAC using a suitable library or custom logic
Data Visualization Tools: Choose libraries or frameworks that align with frontend choices (e.g., Chart.js, D3.js, or built-in features of React/Vue/Angular)
Additional Considerations:

Error Handling: Implement robust error handling for data retrieval and visualization
Performance Optimization: Consider caching strategies and database optimization techniques
Security: Address potential vulnerabilities in data handling and user access
Testing: Write comprehensive unit and integration tests
Related categories: JavaScript Python Software Architecture MySQL AngularJS