Conceirge Donor Portal Management System

1. Project Overview

Conceirge Donor Portal Management is a web-based management application used to centralize information related to donors, orphan/semi-orphan students, donations, payments, committee members, volunteers, staff and organizational activities.

The functional design describes the Conceirge Portal as a Hostel Management and Donor Management application. It was created to support an organization managing orphan, semi-orphan and poor boys, including requirements such as accommodation, food, clothing and educational fee support, while maintaining student, donor, committee, volunteer, staff, donation and payment-history information online.

Source basis: The attached functional design is Version 0.1 and documents the business scope, portal modules and database structures. The Java 11, Spring Boot 2.7, MySQL and Linux VPS implementation details in this page are based on the project information provided with the screenshots.

2. Project Objectives

Student Management

Maintain detailed orphan, semi-orphan and poor-student records and supporting information.

Donor Management

Donation Management

Record monetary payments and grocery/material donations with history and reports.

User Management

Control registration, login, OTP, passwords, roles and access to the portal.

Organization Management

Maintain organization, school, address and supporting master information.

Reporting

Provide payment, donor and date-range search/reporting capabilities.

3. Application Architecture

The application follows a layered Spring-based architecture. The functional design also contains a Spring MVC request-processing diagram showing request handling through the Dispatcher Servlet, handler mapping/adapter, controller, service/business logic, repository/data access and database before returning a response.

Typical Request Flow

Browser→ Controller→ Service→ Repository→ MySQL→ Response

Technology Stack

Technology	Purpose
Java 11	Core backend programming language.
Spring Boot 2.7	Application development, dependency injection, web/API and backend configuration.
Spring MVC	Request handling and controller-based web flow.
JPA/Hibernate	ORM/database persistence layer where applicable.
MySQL	Relational database for persistent application data.
Maven	Build and dependency management.
Linux VPS	Application hosting/deployment environment.

4. Major Modules

The functional design identifies the major Conceirge Portal modules as Student, Donor, Login, Communication, Organization, Committee, Staff, Report and Reference Module.

Student

Student profile, education, health, parent, certificates, achievements and related records.

Donor

Donor profile, payments, grocery donations, feedback and donor searches.

Login / User

Registration, login, OTP, password and role/security management.

Communication

Email and SMS history and communication-related records.

Organization

Organization, school and address information.

Committee

Committee member information and organizational participation.

Volunteer

Volunteer information and support activities.

Staff

Staff information and operational support.

Reports

Donor/payment searches, date-range information and consolidated views.

Reference Module

Reusable/master information used across portal functionality.

5. Student / Orphan Student Management

The Student module is designed to create and maintain detailed records for orphan, semi-orphan and poor students. The documented student information includes personal details, CWC ID, contact details, student type, disability information and organization association.

Student Information

Area	Information Managed
Basic Profile	Student ID, admission number, first name, last name, surname, status and date of birth.
Contact	Mobile number and email ID.
Identification	CWC ID and government certificate information.
Student Type	Orphan, semi-orphan and poor.
Disability	Disability status/details as represented by the application.
Organization	Organization association and audit information.

Supporting Student Modules

Student achievements
Student behaviour
Certificate uploads
Government certificate details
Health details
Height and weight details
Previous qualification details
Student profile images
Qualification and school details
Reference details
Vacation details
Parent/guardian details
Parent address details
Parent birth/death details
Parent divorce details

6. Donor Management

The Donor module is a major functional area of the portal. It manages donor registration, donor profile information, donor searches, special/permanent donor information, feedback and donor-related history.

Donor Details

Field Area	Examples
Identity	Donor ID, first name, last name, surname.
Contact	Email, primary and secondary contact numbers.
Additional Information	Nationality, PAN number and organization.
Address	Present and permanent address references.
Audit	Audit user and modified timestamp.

Donor Functions

Add donor
Search donor
View special donors
View permanent donors
View previous-year unpaid payments
Accept donor payment
Accept grocery items
View grocery history
View payment history
View all payment history
View date-range payment history
Search total donor payments
Search payments with PAN
Search payments without PAN
Search consolidated total donor payments
Search cheque payments
Search fund type

7. Attached Application Screens

Screen 1 – Donor Payment Details: Accept Payment, Accept Grocery Items, Grocery Items History, Payment History, View All Payment History and Date Range Payment History.

Screen 2 – Special Donor Details: View Special Donors, View Permanent Donors and previous-year unpaid payment information.

Donor Search and Payment Reports dashboard

Screen 3 – Donor Search: Donor search, payment totals, PAN-based searches, consolidated payments, cheque payments and fund-type search.

8. Donor Payment Management

The payment module records monetary donations and maintains payment history. The documented payment structure includes donor payment ID, donor ID, amount, mode of payment, cheque number/date, bank name, receipt number, occasion, occasion details, audit information and received-by information.

Payment Workflow

Select Donor→ Enter Amount→ Select Payment Mode→ Enter Details→ Save Payment→ Receipt / History

Date Range Payment History

The attached screen provides a dedicated Date Range Payment History option. This supports retrieval of payment records for a selected period, which can be useful for monthly, quarterly, annual or financial-period reporting.

Payment Search Categories

Search	Purpose
Total Donor Payments	Retrieve donor payment totals.
Payments With PAN	Search payment records associated with PAN information.
Payments Without PAN	Identify payment records without PAN information.
Consolidated Payments	Provide an aggregated view of donor payment information.
Cheque Payments	Search cheque-based transactions.
Fund Type	Search donations according to configured fund type.

9. Grocery Donation Management

The portal supports non-monetary donations through the Accept Grocery Items functionality shown in the attached screen. The system also provides Grocery Items History to review previously recorded grocery donations.

The documented grocery structure contains a grocery ID, donor ID, item quantity, item description and related audit/location information.

Donor ↓ Accept Grocery Items ↓ Enter Item Description ↓ Enter Quantity ↓ Save ↓ Grocery Items History

10. Committee, Volunteer and Staff Management

Committee Management

Committee is identified as a major portal module. It can be used to maintain committee-member information and support organizational administration.

Volunteer Management

Volunteer information is part of the broader organizational scope. Volunteers can support student activities, donation activities, events and other organizational operations.

Staff Management

Staff is also identified as a managed group in the portal. Staff members can support day-to-day student, donor and administrative operations.

11. User Management and Authentication

The User Administration module provides login, registration, password-change and forgot-password functionality. The functional design specifies registered-user login using username, password and OTP, administrator approval for registered users, change-password functionality and forgot-password recovery using registered mobile OTP.

Authentication Flow

Registration→ Admin Approval→ Login→ OTP / Authentication→ Role Validation→ Dashboard

User Administration Data

credential_details
role_details
credential_role_details
credential_security_details

12. Communication Management

Email History

The documented email history structure stores email ID, subject, message, recipient, CC, BCC, sent date and audit information.

SMS History

The documented SMS history structure stores SMS ID, message, mobile number, sent date, transaction ID and audit information.

These structures provide a record of communication generated through the portal.

13. Database Design

The functional design contains separate structures for student, donor, user administration and generic/master data.

Student-related Tables

Table	Purpose
student_details	Core student profile.
student_achievement_details	Student achievements.
student_behaviour_details	Behaviour and attitude information.
student_certificate_upload_details	Student certificates.
student_govt_certificate_details	Government identification details.
student_health_details	Health information.
student_previous_qualification_details	Previous qualifications.
student_profile_images	Student images.
student_qualification_details	School/class/qualification details.
student_reference_details	Reference information.
student_vacation_details	Vacation/guardian information.
student_parent_details	Parent/guardian information.
student_parent_address_details	Parent/student address references.
student_parent_birth_death_details	Parent birth/death information.
student_parent_divorce_details	Parent divorce information.

Donor-related Tables

Table	Purpose
donor_details	Donor master/profile information.
donor_payment_details	Monetary donation/payment records.
donor_feedback_details	Donor feedback and comments.
donor_profile_images	Donor profile images.
donor_groceries_details	Grocery/material donations.
donor_generate_groceries_id	Grocery ID generation.
generate_groceries_details_id	Grocery detail ID generation.

User Administration Tables

credential_details
role_details
credential_role_details
credential_security_details

Generic Tables

address_details
email_history
festival_details
generate_address_id
generate_receipt_number
organization_details
school_details
sms_history
ssvt_config
validate_otp

14. CRUD Operations

CRUD represents Create, Read, Update and Delete operations. In this project, these operations are implemented through the relevant application layers for maintainable business entities.

Operation	Example
Create	Add donor, register student, create payment record.
Read	Search donor, view student, view payment history.
Update	Edit donor/student information and update records.
Delete / Deactivate	Where supported by business rules, remove or deactivate records rather than exposing unrestricted deletion.

15. Linux VPS Deployment

The application is deployed on a Linux VPS server. A typical Spring Boot deployment flow is:

Developer Machine ↓ Maven Build ↓ Spring Boot JAR ↓ Linux VPS ↓ Java 11 Runtime ↓ Spring Boot Application ↓ MySQL Database

Typical Build

mvn clean package

The generated application JAR is then deployed to the Linux VPS and started using the configured Java runtime and server settings.

16. Java Developer Responsibilities

Developed backend functionality using Java 11 and Spring Boot 2.7.
Implemented donor and student management functionality.
Worked on payment and donation-related business flows.
Implemented search and reporting functionality.
Integrated the application with MySQL.
Developed controller, service and repository layers.
Worked with entity/DTO-based data transfer and persistence.
Implemented validation and exception handling.
Worked on user authentication, OTP and role-related functionality.
Worked with donor payment history and date-range reporting.
Worked on grocery donation management.
Supported committee, volunteer and staff-related functionality.
Performed API/application testing using suitable testing tools.
Supported Linux VPS deployment and application troubleshooting.

17. Interview Project Explanation

Project: Conceirge Donor Portal Management

Conceirge Donor Portal Management is a web-based organization management application developed using Java 11, Spring Boot 2.7 and MySQL and deployed on a Linux VPS server. The application is designed to manage donors, donations, orphan/semi-orphan student information, committee members, volunteers, staff and users through a centralized portal.

The Student module manages personal details, parent/guardian information, education, achievements, behaviour, health, certificates, government certificate details and vacation information. The Donor module provides donor registration and search, payment acceptance, grocery donations, payment history, special/permanent donor information and multiple payment-search/reporting options.

The application follows a layered architecture with Controller, Service, Service Implementation, Repository and Entity/DTO components. MySQL is used for persistent storage. User administration provides registration, login, OTP, password management and role/security-related functionality. The application is packaged and deployed on a Linux VPS server.

Short Resume Description

Conceirge Donor Portal Management: Developed and maintained a Spring Boot-based web application for managing donors, donations, orphan/semi-orphan student records, user access, committee, volunteers, staff and financial reports using Java 11, Spring Boot 2.7, MySQL and Linux VPS deployment.

Technology Keywords

18. Source Document Reference

The attached document is ConceirgePortal Functional Design – Version 0.1. It documents the portal history, business purpose, architecture diagrams, modules and detailed database tables/fields. The document states that the portal was implemented to manage students, donors, committee, volunteers, staff, donor reports and payment history online.

This HTML presents the project information in a structured format and incorporates the three supplied application screenshots.