Software · Bangali Oikya Manch

Bangali Oikya Manch case study: a case management platform

An applicant portal and case management system for Bangali Oikya Manch, a community service organisation. Reported cases a day: about 5 to 6 by hand and 30 to 40 on a typical day with the platform.

Client
Bangali Oikya Manch
Place
Madhyamgram, West Bengal
Categories
Software, Systems
Roles
Applicant, admin, super admin
Built with
PHP, MySQL-compatible database
Access
Private
Engagement
Sponsored by N&D Co., free of charge

Overview

For Bangali Oikya Manch, a community service organisation, N&D Co. built an applicant portal joined to an internal case management system, with one record per case. By the organisation's own figures, which it has confirmed, daily cases went from about 5 to 6 by hand to 30 to 40 on a typical day with the platform.

The platform handles the application forms applicants fill in, from registration to final approval. Applicants register, verify their email with a one-time code, fill in their application form, upload documents and follow their case. Staff assign and review each case, send instructions, approve it in two stages and generate supporting documents from templates. The organisation's team then helps submit the application in front of the applicant.

The busiest day reached 75 or more cases, and the results section below explains how to read each figure. The project came to us through a referral, and we sponsored it: we built the platform, one of our software development projects, free of charge as a contribution to the organisation's community service work, to increase its ability to help applicants. The platform's pages were public at first; Bangali Oikya Manch has since made the whole platform private for internal reasons.

About Bangali Oikya Manch

Bangali Oikya Manch is a nonprofit community service organisation in Madhyamgram, West Bengal. Its YouTube channel describes its aims as standing by people in times of trouble, strengthening community roots and ties, and bringing together people who came from Bangladesh with few resources to support their economic and social development. It shares its work on Facebook and YouTube.

It works with applicants who may need help with complex administrative and documentation processes, and that work involves more than collecting a form. Applicants may need to give structured personal and family information, supporting documents and details specific to their case, and the organisation has to review all of it, arrange appointments, keep track of where each case stands and prepare the paperwork that goes with it.

The platform's home page, which we built with the rest of it, opens with a Bengali banner and the organisation's own logo, and its English menu includes About, Services, Flowchart and Guidelines, with buttons to log in and register. The services page lists four kinds of help: online form submission, appointment management, support from administrators and notifications.

Sources: Bangali Oikya Manch on Facebook, Bangali Oikya Manch on YouTube.

What Bangali Oikya Manch needed

Before the platform, Bangali Oikya Manch managed applicants, documents, appointments and case status mostly by hand. As the number of applicants grew, so did the time it took to find information, track documents, coordinate staff and tell each applicant what came next, and that overhead became the bottleneck.

  • Applicant information was collected and tracked on paper and by hand.
  • Supporting documents had to be collected, sorted and checked by hand.
  • Appointments were arranged separately from the rest of the case.
  • It was hard to see at a glance where an application stood.
  • Staff had to find a record before they could act on it.
  • Following up with applicants meant the same conversations again and again.
  • Every rise in applicant numbers added admin work at several points in the process.

The bottleneck at Bangali Oikya Manch was information moving between applicants, staff, documents, appointments and administrative decisions. In outline, a case in the old model went through a chain of steps: the applicant's details on paper, staff notes, documents, appointment tracking, status tracking and repeated follow-up, and only then completion. One case could need the same personal details, documents, status updates, appointments and instructions handled several times over, which is why we built the platform around a single case record. As we read it, too much staff time went on coordination that software could bring into one place.

What the platform had to do

  • One source of truth for applicant and case information.
  • Structured online forms in place of repeated paper intake.
  • Document collection and review in one place.
  • Clear responsibility, with each case assigned to an administrator.
  • A status lifecycle that staff manage the same way for every case.
  • A self-service portal for applicants.
  • Less repeated follow-up, through notifications and instructions.
  • Appointment information tied to the case.
  • Standard supporting documents generated from the stored application data.
  • Reports, exports and a record of activity.
  • More capacity without simply scaling up the manual process.

What we did

Software Development

An applicant portal and a case management system around one case record

The platform N&D Co. built for Bangali Oikya Manch has two connected sides. On the applicant side, in Bengali and English, people read about the process and the services, then register and log in; inside the portal they fill in their application, upload documents, check their status and instructions and download the documents generated for them. On the internal side, administrators work through queues of assigned cases, and super administrators assign cases, give final approval and manage users; both can open reports and the activity log. The home and information pages count as website design and development work; the rest is custom workflow software.

We approached the project as a workflow problem. An online form would only have handled intake, and after submission each application still needs assignment, review, documents, instructions, status changes, appointments, generated documents and oversight. So the platform treats an application as a case with a lifecycle, and we connected every task to that case instead of building isolated features.

Everything about a case is linked to one record: the applicant's details, documents, status, assigned administrator, instructions and their history, appointment details and generated documents. An instruction from an administrator appears on the applicant's dashboard and goes out by email, and a status change sends a notification in the portal, plus an email where that is set up.

  • Home and information pages: services, login and registration
  • The application process flowchart shown on the home page
  • Applicant portal: application form, documents, status, instructions and downloads
  • Sign-in with an 8-digit one-time code (OTP) sent by email
  • Administrator workspace: assigned queues, review, status changes and instructions
  • Super administrator oversight: assignment, final approval and user management
  • Document management linked to each case
  • Notifications in the portal and by email
  • Appointment records linked to each case
  • Supporting documents generated from Word templates
  • Reports with PDF and CSV export
  • Activity and system logs

Reported results: 30 to 40 cases on a typical day, up from 5 to 6

By its own figures, which it has confirmed for this case study, Bangali Oikya Manch handled about 5 to 6 cases a day with its manual process. With the platform in use, a typical day is about 30 to 40 cases, and the busiest day reached 75 or more. They are the organisation's figures rather than an audit, and the list further down says how to read them.

cases a day with the manual process (reported)
5 to 6
cases on a typical day with the platform (reported)
30 to 40
cases on the busiest reported day, a lower bound
75+
the busiest reported day against the old maximum of 6, a lower bound (our calculation)
12.5×

Cases handled a day, as reported

Cases handled a day, as reported
PeriodValue
Manual process5 to 6
Typical day with the platform30 to 40
Busiest reported day75+
Each column is drawn at the cautious end of its figure: 6, the top of the old range; 30, the bottom of the typical range; and 75, the floor of the reported peak. The labels give the figures as they were reported. Source: Bangali Oikya Manch's figures, confirmed for this case study.

Cases a day as a multiple of the old maximum of 6 (our calculation)

Cases a day as a multiple of the old maximum of 6 (our calculation)
CategoryValue (×)
Old maximum, 6 a day1
30 a day, low end of a typical day5
40 a day, high end of a typical day6.7
75 or more a day, the reported peak12.5× or more
Each reported figure is divided by 6, the top of the old range of 5 to 6. 40 divided by 6 is 6.67, shown as 6.7. The peak was 75 or more, so its multiple is at least 12.5. Source: N&D Co. calculation from Bangali Oikya Manch's figures.

What changed for applicants, staff and management

Applicants have a workspace they come back to, so they no longer have to treat every contact with the organisation as a separate exchange. Staff work from queues and case records instead of piecing a case together from paper, files and messages, and management can see every case, who is responsible for it, how cases split across statuses and what has happened in the system.

As we read it, staff can spend less time rebuilding and coordinating cases and more time supporting applicants.

How should the reported figures be read?

  • The multiples are our calculation: against the old maximum of 6, a typical day is 5 to 6.7 times as many cases and the busiest reported day at least 12.5 times. Dividing by 6 rather than 5 keeps them on the low side.
  • 75+ is a lower bound for the busiest reported day, not a measure of the platform's maximum capacity.
  • Bangali Oikya Manch has confirmed these figures for this case study, along with what counts as one case in them.
  • Staffing or process changes at the organisation are not ruled out, so we do not credit the whole rise to the software.
  • The numbers on the reports screen further down come from test data and have nothing to do with these figures.

What did the platform replace?

The platform replaced paper intake, case records and documents tracked by hand, manual assignment and status tracking, repeated follow-up with applicants, separately arranged appointments and paperwork prepared by hand each time. The table compares the two ways of working area by area; the last column is our reading of what each change does, not a measured result.

The manual process and the platform, area by area
AreaBeforeAfterWhat it changes
Applicant intakePaper and manual entryA structured online formMore consistent data
Case recordsScattered and kept by handOne central case recordLess hunting for records
DocumentsTracked by handManaged digitally and linked to the caseClearer document status
AssignmentCoordinated by handAn assignment workflowClear responsibility
StatusTracked by handA digital status lifecycleFaster day-to-day decisions
Updates to applicantsRepeated follow-upNotifications and instructionsClearer next steps
AppointmentsArranged separately, by handA record linked to the caseLess scattered scheduling
Generated paperworkPrepared by hand each timeGenerated from templatesLess repeated preparation
ReportingOnly what staff could check by handDashboards and exportsA view across the organisation
TraceabilityA paper trail kept by handActivity and workflow historyEasier tracing

How does an application move through the platform?

An application moves through three roles. The applicant registers, verifies their email with a one-time code and submits the form. A super administrator assigns it to an administrator, who approves it, puts it on hold with a query or sends it back. The super administrator then gives final approval and sets a date and time for the applicant to come in with their original documents.

  1. The applicant registers with their name, date of birth, phone number and email address.
  2. They verify the email address with a one-time code (OTP) and log in.
  3. They fill in their personal and family details and upload documents, a photo and a signature.
  4. They submit the application.
  5. A super administrator receives it and assigns it to an administrator.
  6. The administrator reviews the application and its documents, then approves it, puts it on hold with a query, or sends it back to the super administrator for clarification.
  7. Once approved, the form is locked against edits by the applicant and waits with the other approved applications for the super administrator.
  8. The super administrator gives the organisation's final approval and sets a date and time for the applicant to come in.
  9. The supporting documents for the affidavit are generated and printed.
  10. The applicant brings the originals and the affidavit copies at the given date and time.
  11. The organisation's team helps submit the application in front of the applicant.

A send-back goes to the super administrator for clarification, then returns to the administrator's review. Comments from the applicant, the administrator and the super administrator are visible to all three, so a query and its answer stay together on the case.

When an application needs attention

What happens when an application needs attention
SituationWhat happens
A document is missing or wrongThe administrator removes it or asks for a new one, the applicant gets an instruction or notification and uploads a replacement, and the administrator reviews it again.
The details need correctingThe administrator puts the case on hold with a query for documents or information and records an instruction, the applicant sees what to change, updates the form and resubmits, and the review resumes.

These paths are what make the system useful from day to day, and handling them as well as successful submissions was one of the harder parts of the build.

What messages does an applicant get?

Events that send the applicant a message
EventWhat the applicant gets
RegistrationA welcome message about the new account
Sign-in or email checkAn email with a one-time code (a sign-in code is valid for 5 minutes)
Form submittedA confirmation
Status changedA notification in the portal, and an email where that is set up
Instruction addedThe instruction, saved on the case, shown on the dashboard and sent by email
Document removedA notice can tell them the document needs replacing

The aim is less chasing for updates by hand.

How are appointments handled?

Each appointment is stored with the applicant and the case it concerns, as part of the case workflow: the applicant's dashboard shows an appointment tile, and the date and time set at final approval is when the applicant comes in with the originals. The organisation's services page describes the appointment service as meetings with administrators, who are assigned by location, with flexible scheduling, appointment notifications and options to reschedule or cancel; its notifications card adds appointment reminders.

Who uses the platform: applicants, administrators and super administrators

Three roles share the platform, each with its own screens and permissions. Applicants manage their own case, administrators process the cases assigned to them, and super administrators oversee the work across the organisation.

The three roles and what each can do
RoleMain jobWhat they can do
ApplicantProvide and manage their own case informationRegister, verify their email, fill in forms, upload documents, check their status, receive instructions and download generated documents
AdministratorProcess the cases assigned to themReview applications, check documents, change the status, send instructions, manage case documents, work through their queues and open reports and the activity log
Super administratorOversight across the organisationAssign cases, give final approval, manage users and administrators, and use reports, exports and the activity log

An applicant, an administrator and a super administrator should not see or control the same things. Keeping the roles apart gives the platform a base for least-privilege access (the principle that each account gets only the permissions its job needs) and supports clearer accountability at each step. Staff sign in with named accounts, so the actions the log records can be tied to the account that took them, and the most powerful accounts are kept apart from routine staff accounts. The screens follow the same model: each role has its own profile and badge, a case record lists the viewer's permissions (a super administrator can edit any form without being assigned to it), each administrator account carries a district, and the services page lists location-based assignment of administrators for appointments.

Accounts and cases are related but kept separate. An account has its own lifecycle, from creation to deletion, apart from the cases linked to it, and user management is a different screen from case management.

The platform, screen by screen

The screens fall into three groups: the home page and applicant portal, the staff screens for case work, and the oversight screens for super administrators. Every picture comes from a test system filled with test records. Personal details are blurred, and the names left visible belong to test accounts. The home page is the large picture at the top of this page. Where we say what a screen changes for applicants or staff, that is our reading, not a measured result.

The home page and the applicant portal

The home page leads with the process flowchart and buttons to register or log in, and the services page explains the help on offer, so applicants know what the service covers before they enter personal details, which can reduce unnecessary questions. A clear entry page should also mean less confusion before anyone reaches the signed-in part, where each case and its documents sit behind an account.

Logging in takes an email address and an 8-digit code sent to it; there is no password field. Behind the screen, the platform creates and verifies each code, lets it expire and can send a new one. It is a light check on the account, and sign-in stays simple.

Once in, applicants return to the same workspace instead of starting the intake again. Their dashboard shows the application's status, instructions from staff, an appointment tile, notifications and quick actions, and one account can hold several forms, up to a set limit. Approved forms list the documents generated for them, and every document is filed by form and category, so applicants do not have to manage separate email attachments or loose files.

Staff screens: queues, case records and document management

An administrator's dashboard counts their cases by status (assigned, newly assigned, under review, approved, rejected and on hold) and filters the list the same way, with priority actions first, which spares staff from finding paper records and working out what to process next. The all forms view is the platform's master register: every application with its status, assigned administrator and submission time, searchable by status, name, email and date of birth or across all fields, so staff can find a case without searching physical folders. A case record puts the whole form on one screen (personal, family and marriage details, addresses, residence history and a neighbour's details) beside panels for the viewer's permissions, the assignment and the instruction history. That one screen should reduce the cross-checking between paper notes, files and messages.

From the record, staff check the case's documents to see what is there and what needs action, change the status with an instruction for the applicant and download the form as a PDF, and a super administrator can also edit the form data. An instruction is a workflow event with its own history: it changes what the applicant sees and stays on the case. For each approved form, the platform generates three supporting documents from templates, using the data already in the application: a Schedule 1C, a self declaration and an introducer certificate. Each one records who generated it and when, and producing them from templates reduces repeated copying and improves consistency. User lists export to PDF or CSV for use outside the live system.

Oversight: assignment, users, reports and logs

The super administrator's dashboard puts forms that still need an administrator first, then forms that administrators have approved and that wait for final review, with counts across the organisation and shortcuts to all forms, administrators, reports and logs. From there a super administrator can coordinate several administrators and see the whole pipeline. User management lists every account with its role, status and, for administrators, a district, and is where new administrators and super administrators are added. Keeping every account in one place matters once there are many applicant and staff accounts.

Reports break forms down by status, chart monthly submissions over the last 12 months and show how many forms each administrator holds, with PDF and CSV export, so a manager can see where cases pile up and how the work is spread without counting by hand. The activity log records logins, form actions and admin actions, with filters for action, user, entity, date and text and an export button. It shows what changed, when and which account made the change, for accountability and troubleshooting.

What security controls does the platform have?

The platform includes role-based access, OTP authentication, CSRF protection, document validation, controlled document access and activity logging, all built into the application. These application-level controls do not amount to a full security audit or a legal certification.

Security controls in the application
ControlHow it worksWhat it is for
Role-based accessSeparate areas for applicants, administrators and super administrators, with checks on protected pages and actionsLimits actions to the appropriate role
OTP authenticationA one-time code sent by email to sign inAdds an email check to account access
CSRF protectionTokens created and checked on requests that change dataGuards against cross-site request forgery, a common web attack
Session controlsSession handling with a timeoutLimits how long a session stays open
Document validationChecks on file type and sizeReduces the risk of unsafe or unexpected uploads
Controlled document accessDocuments open and download through the application itselfKeeps document access within the platform's rules
Activity loggingA log of logins, form actions and admin actionsA trace of which account did what, and when
Workflow historyStatus and instruction history on each caseShows how a case progressed

Exports need the same care as the live records, since a downloaded PDF or CSV file sits outside the application's access rules.

How information moves through the platform

The data lifecycle, stage by stage
StageWhat happens
CollectThe applicant enters structured information
VerifyThe email address and the application are checked
StoreThe information is saved against the applicant and the application
AttachSupporting documents are linked to the case
AssignAn authorised member of staff takes responsibility for the case
ReviewStaff check the information and the documents
CommunicateInstructions and notifications tell the applicant what is needed
ProcessThe status and appointment details change as the case moves on
GenerateStandard supporting documents can be produced from the stored data
ReportFigures across cases feed management reports
AuditActivity and workflow records keep a trace of what happened

This case study describes the software and the figures reported for it, with screens from a test system. Nothing on this page is a legal certification or a statement that Bangali Oikya Manch complies with every law that applies to it.

How we built the platform: stack, architecture and decisions

The platform is a PHP web application on a MySQL-compatible database, with pages rendered on the server. Applicants, administrators and super administrators each have their own area, and the three share code for the core jobs: the application form, file uploads, notifications and email, instructions and their history, document generation from Word templates and the activity log, alongside appointment records and report pages. Role and permission checks guard the protected pages and actions. We have left file and folder names off this page on purpose, because they would tell an attacker more than they tell a reader.

Technology stack
LayerTechnology or approach
BackendPHP
DatabaseA MySQL-compatible relational database
Sign-inEmail OTP with session-based authentication
Front endServer-rendered pages with HTML, CSS and JavaScript
DocumentsWord documents generated from templates
EmailAn SMTP email service
ReportingServer-generated reports with PDF and CSV export
FilesValidated uploads and controlled document management
HostingDeployed on a server environment for the organisation

The four layers of the platform

The four layers of the platform
LayerWhat it handles
Applicant layerRegistration, OTP verification, profile, forms, documents, notifications, appointments and generated documents
Case management layerAssignment, review, document checks, status changes, instructions and actions on a single case
Oversight layerAll forms, user and administrator management, reports, exports, system logs and a view across the organisation
Data layerStructured records of applications, users, documents, statuses, notifications, appointments and activity

Decisions that shaped it

Engineering decisions and the reasons for them
DecisionReason
Separate rolesApplicants, administrators and super administrators need different permissions and screens
Built around the caseInformation, documents, status and messages have to stay connected
Explicit statusesThe next action depends on where the case is in its lifecycle
Controlled documentsEach category of document needs its own checks and workflow rules
NotificationsImportant events should not depend entirely on someone following up by hand
Activity loggingSeveral people work on the same cases, and a log of the important events makes that work traceable
Reports and exportsManagement needs information beyond individual case screens
Template generationPreparing the same documents again and again is an obvious job to automate
Applicant self-serviceStaff should not have to do every routine step for the applicant

What was hard to build?

  • Turning a document-heavy, real-world process into structured data.
  • Separating applicant, administrator and super administrator permissions.
  • Keeping each document's state in step with the application's status.
  • Handling hold, correction and replacement paths as well as successful submissions.
  • Sending notifications at the events that matter.
  • Making busy administrative screens usable.
  • Reporting across cases without losing the detail of each one.
  • Maintaining an audit trail when several people act on the same case.

The main lesson was that the complexity lives in the connections. Each page on its own was fairly simple; the work was making information, permissions, documents, notifications and status stay consistent with each other at every stage of a case.

In outline, the work ran through discovery, workflow mapping, the data model, the applicant portal, the administrative system, the document workflow, notifications, reporting, security and access control, testing and refinement, and deployment.

Possible next steps, not built today

Improvements the platform could take on later include more advanced workflow analytics and tracking against service level agreements (SLAs), automatic reminders for applicants with pending actions, finer-grained permissions, better use on mobile phones, more document automation, advanced case search and saved filters, workload forecasting and more detailed audit reports.

If your organisation runs a process like this on paper, in spreadsheets or across message threads, our software development service takes the same approach: map the workflow, find where time and information are lost, and build software for that process. Our other work is on the projects page.

What the client said

Bangali Oikya Manch in their own words, from a public Google review.

Google review

"Really impressed how generously they made the full internal data management system. Great time to work with you guys"

Bangali Oikya Manch

Frequently asked questions

What did N&D Co. build for Bangali Oikya Manch?

N&D Co. built a web platform that joins an applicant portal to an internal case management system. Applicants register, sign in with an email code, fill in their application, upload documents and follow their case, while staff assign, review and approve cases, send instructions, generate supporting documents and run reports.

What results were reported for the Bangali Oikya Manch platform?

By Bangali Oikya Manch's own figures, which it has confirmed: about 5 to 6 cases a day by hand, 30 to 40 on a typical day with the platform and 75 or more on the busiest day.

Do applicants need a password to sign in to the Bangali Oikya Manch platform?

No. Applicants enter their email address and get an 8-digit one-time code, valid for 5 minutes; the login screen has no password field.

Is the Bangali Oikya Manch platform public?

No. Its pages were public at first, but Bangali Oikya Manch has since made the whole platform private for internal reasons. It joins an applicant portal to an internal case management system for authorised staff.

Who uses the Bangali Oikya Manch platform?

Three roles use it, each with separate screens and permissions: applicants, administrators and super administrators. Applicants manage their own case, administrators process the cases assigned to them, and super administrators assign cases, give final approval and oversee users, reports and the activity log.

How does an application reach Bangali Oikya Manch's final approval?

An administrator reviews and approves the assigned application, then a super administrator gives final approval and sets a date and time for the applicant to bring their original documents. The administrator can also put it on hold or send it back to the super administrator for clarification. On that date the organisation's team helps the applicant submit it.

What documents does the Bangali Oikya Manch platform generate?

Three supporting documents per approved form, generated from templates with its data: a Schedule 1C, a self declaration and an introducer certificate. We make no claim about their legal standing.

What security controls does the Bangali Oikya Manch platform include?

The platform has role-based access, OTP authentication, CSRF protection, document validation, controlled document access and activity logging. The list is not a security audit or legal certification.

What technology does the Bangali Oikya Manch platform use?

It is a PHP web application on a MySQL-compatible database, with server-rendered pages, email one-time code sign-in, Word documents generated from templates, PDF and CSV exports and an activity log.

Did Bangali Oikya Manch pay for the platform?

No. The project came to N&D Co. through a referral, and we sponsored it: we built the platform free of charge as a contribution to Bangali Oikya Manch's community service work.

Can N&D Co. build a platform like Bangali Oikya Manch's for my organisation?

Yes. If your process runs on paper, in spreadsheets or across message threads, we can take the same approach: map the workflow, find the bottlenecks and build software for that process. The quote is set in writing before work starts.

Want something like this?

Tell us about your business in a few lines and we will reply with questions or a quote. We work from Kolkata with clients across India and abroad.

Get a quote