Project Scope: Advanced Online Product Review Platform
Development Platform: Scriptcase Framework | Database: MySQL
This document provides a basic outline of the system, but the platform will be developed in stages. We will only proceed to the next stage once the completed one meets all the client’s objectives.
SYSTEM DEVELOPMENT PROPOSAL:
As requested by the Independent Reference team, we are pleased to present our proposal for the provision of system development services as described below.
The activities will be carried out as follows:
Phase 1 – Data Collection: A detailed assessment of all processes and applications will be conducted. Following this assessment, a schedule of activities will be created in collaboration with the company.
Phase 2 – Development: Based on the data collected in “Phase 1,” the development will commence as described below.
Phase 3 – Testing and Validation: As “Phase 2” progresses, the company’s key users will be able to test and validate the system. This approach allows testing to occur before the full development is completed, making the process more accurate and efficient.
- Integration with a Payment Gateway – STRIPE – for charging clients and managing financial control of Accounts Payable and Receivable, as well as generating Reports related to these activities.
- Multilingual Support: Global Expansion Without Borders.
If the system supports multiple languages, it can operate globally without the need for separate systems. This will enable capturing more reviews from around the world in one central location. Pending Analysis: Possibility of universal payment system
DETAILED ACTIVITIES:
➢ DATABASE MODELING:
A database will be modeled with the creation of new tables to support the development of the project. These tables will be created with the supervision and authorization of the area responsible for the project.
➢ SECURITY:
A security application will be created with login and password fields for system access. Each user will have permissions according to their access profile. The administration of this application will be the responsibility of the system administrator.
➢ PARAMETERIZATION:
Applications will be developed to allow the key user to parameterize certain system requirements without needing to hire additional development for this action.
➢ QUERIES/REPORTS:
A filter and query application will be developed to speed up the search for necessary information.
➢ DASHBOARD:
A dashboard with up to 4 charts will be designed to provide better managerial insight. Administrators will determine which information will be displayed.
➢ NAVIGABILITY:
The entire system will be web-based and can be accessed from any device with a browser.
Project Modules for the MARKETPLACE:
01.1 Material Collection
This refers to the identification and collection of all materials necessary for the project. This may include documents, references, and any resources that will be used in the development process.
01.2 Design / Screen Prototypes
This involves creating the design (templates) and screen prototypes for the system using Scriptcase. It includes the development of layouts, interfaces, and visualization of how users will interact with the system. These screens will be generated through Scriptcase software. If the client requires the screens to align with their visual identity, a separate proposal for this item will be necessary.
01.3 Database Modeling
This refers to the structuring and creation of the database, including the definition of tables, relationships, and the configuration of the database to support the project’s needs. The database used for this project will be MySQL.
- Auxiliary Records (customer groups, products, questions, answers)
This includes the creation and maintenance of auxiliary records in the system, such as customer groups, product categories, and other information that will assist in the system’s operation and management (combobox).
- Users (groups, access control)
This deals with the configuration and management of users, including the creation of user groups and the definition of permissions and access control. - Clients
This module is responsible for registering and managing clients in the system. It includes creating new registrations, updating information, and querying client data. This is fundamental for organizing and personalizing customer service, allowing for better customer relationships. - The Products module handles the registration and management of products in the system. It includes adding new products, defining categories, updating information, and creating custom questions for each product. This is essential to keep the product catalog up-to-date and organized, facilitating reviews and inventory management. It is a central structure and objective of the entire project.
- Interviewees
- This module is dedicated to the registration and management of interviewees for surveys or interviews. It includes adding interviewee information, updating data, and querying interview histories. This is crucial for organizing collected information and facilitating interview scheduling and analysis.
- Interview Scheduling
The Interview Scheduling module manages the scheduling of interviews with interviewees. It allows setting times, defining platforms, and tracking the progress of the interviews. This module is important to ensure that all interviews are conducted as planned, without scheduling conflicts.
09. Reports / Emails
This module handles the generation of reports and sending emails. It includes creating custom reports based on system data, as well as the automated sending of emails to clients or users. It is essential for performance analysis, client communication, and data-driven decision-making.
10. Integrations (Credit Card, Invoices)
The Integrations module connects the system with other platforms and services, such as payments via Credit Card, Stripe and invoice generation. These integrations enable automation and data synchronization between different systems, facilitating financial and operational management.
11. Testing / Implementation / Training
This module covers the system testing process, final implementation, and user training. It involves verifying functionalities, correcting errors, installing the system in the production environment, and training users to efficiently use the system.
For each project delivery, we will conduct a detailed presentation of the developed modules, followed by practical tests to verify the correct functioning of the implemented features. During these tests, considerations and feedback from the involved team will be collected, allowing for adjustments and improvements before proceeding to the next phase. This ensures the system’s quality and alignment with the project’s needs.
CROMOGAMA
- Business Days:
- 2-3 days: Initial Database Modeling (MySQL).
- 4-7 days: Initial Structuring of the Login Screen, Security and Access Routine, and Initial Management Modules.
- 8-12 days: Finalization of Management Modules and Start of Client Modules.
- 13-15 days: Completion of Client Modules and Start of Evaluator Modules.
- 16-20 days: Testing, Validation, and Adjustments.
- 21-26 days: Start of Base Site for Full Solution Functionality.
- 27-35 days: Completion of the Base System Cycle with Site.
- 36-41 days: Aesthetic Enhancements, Corrections, and Adjustments.
- 42-50 days: Start of Modules for Plan Acquisition and Parameters.
- 51-57 days: Integration with Payment Gateway.
- 58-64 days: Financial Modules for Client and Management.
- 65-67 days: Public Access Release (Live) + Presentation, Training, Validation, Final Testing, and Adjustments with the Sponsor and Stakeholders.
PAYMENT TERMS:
Upon approval of this proposal – R$ 12.000,00
After 30 days of the first payment – R$ 10.000,00
* R$ 5,000.00 for delivery without a set date.
Final Payment:
After testing, with the entire structure meeting the desired specifications, an additional payment of U$ 10,000.00 will be required, and the access credentials will be delivered
Total investment: R$ 27.000,00 + U$ 10;000.00
✓ This proposal does not include server/hosting for the system.
The system is scheduled to be hosted on Microsoft Azure, provided by the client.
✓ Important Note: The platform under development provides a robust framework for system security, database protection, and access control. However, it is of utmost importance that the hosting server, provided by the client, also fulfills its security responsibilities, ensuring the protection and integrity of the data.
Images of the basic fields from the main pages
Scheduling system
Sync the video conferencing tools and set preferences for in-person interview.
Pending: analysis of the tool that will generate the transcription.