01 · ARTIFACT 002 / CASE STUDY

Back to selected work

PlacementPortal

A structured multi-role campus recruitment management system engineered to coordinate placement drives, student eligibility workflows, company listings, and placement analytics across administrators, recruiters, and candidates.

Role

Full-Stack Engineer

Category

WEB APPLICATION / ENGINEERING

Tech Stack

React · TypeScript · Python · SQL · Node.js · Tailwind CSS

Timeline

SYSTEMS APPLICATION · EDITABLE TIMELINE

PROJECT 002 · APPLICATION OVERVIEWEDITABLE SCREENSHOT
ELIGIBILITY & DRIVE MATRIXSQL VERIFIED
ADMIN
COMPANY
STUDENT
PLACEMENT PORTAL — PRIMARY APPLICATION INTERFACEINTERFACE VIEW

02 · THE CHALLENGE

The problem.

BACKGROUND & CONTEXT

Campus recruitment involves three distinct stakeholders—placement cell administrators, visiting recruiting companies, and applying students—each requiring strict data visibility boundaries and structured stage tracking.

TARGET USERS

University placement coordinators managing hundreds of candidates, company HR representatives posting job drives, and students tracking eligibility and application statuses.

CORE REQUIREMENTS

  • Admin dashboard for verifying student records and scheduling company recruitment drives.
  • Company drive management workflow with eligibility criteria (CGPA, branch, active backlogs).
  • Student application workflow with one-click apply and stage progression tracking.
  • Placement analytics summarizing drive participation and department-level status.

SYSTEM CONSTRAINTS

  • Relational data integrity was critical to prevent ineligible applications or duplicate submissions.
  • Interfaces needed high-density tabular clarity without visual clutter.

03 · THE APPROACH

The approach.

01 / RESEARCH & DISCOVERY

Analyzed the end-to-end lifecycle of a campus recruitment season—from profile verification and job posting to shortlisting, interview rounds, and final offer tracking.

02 / ARCHITECTURE PLANNING

Designed around a relational SQL schema enforcing foreign-key constraints between Students, Companies, PlacementDrives, and Applications, exposed through role-scoped API controllers.

03 / TECHNOLOGY SELECTION

Used SQL for transactional integrity and structured reporting queries, paired with a modular React and TypeScript frontend featuring tabular numerals and clean role switching.

04 / USER EXPERIENCE DECISIONS

Separated the interface into three dedicated workspace views—Admin Control, Company Drive Manager, and Student Portal—so each user sees only actionable controls.

04 · SYSTEM ARCHITECTURE

Under the surface.

Frontend01

Multi-Role Portal Interface

Dedicated dashboards for Admin governance, Company drives, and Student applications.

React · TypeScript · Tailwind CSS

Authentication02

RBAC Policy Engine

Role-Based Access Control enforcing Admin, Company, and Student permissions.

RBAC Middleware · Session Auth

Backend03

Application & Eligibility Service

Validates student academic criteria against drive rules and computes analytics.

Python / Node.js · REST API

Database04

Relational SQL Schema

Normalized tables for student academic profiles, company drives, and round statuses.

SQL · Relational Constraints

05 · KEY FEATURES

Feature showcase.

ADMIN GOVERNANCE · ANALYTICSEDITABLE SCREENSHOT
ELIGIBILITY & DRIVE MATRIXSQL VERIFIED
ADMIN
COMPANY
STUDENT
ADMIN DASHBOARD & DRIVE GOVERNANCEINTERFACE VIEW
FEATURE 01

Admin Dashboard & Drive Governance

Centralized command view allowing coordinators to onboard recruiting companies, configure drive eligibility rules, and monitor real-time application pipelines.

ADMIN GOVERNANCE · ANALYTICS

AUTOMATED ELIGIBILITY · STAGE TRACKINGEDITABLE SCREENSHOT
ELIGIBILITY & DRIVE MATRIXSQL VERIFIED
ADMIN
COMPANY
STUDENT
STUDENT APPLICATION & ELIGIBILITY WORKFLOWINTERFACE VIEW
FEATURE 02

Student Application & Eligibility Workflow

Automated eligibility verification checks student academic metadata against company drive thresholds before enabling one-click application and round tracking.

AUTOMATED ELIGIBILITY · STAGE TRACKING

06 · ENGINEERING CHALLENGES

The hard part.

CHALLENGE 01

Deterministic Eligibility Evaluation Across Complex Rules

PROBLEM

Recruiting drives specify multi-variable eligibility rules (department subsets, minimum grade thresholds, and existing offer policies) that must be evaluated consistently.

ENGINEERING SOLUTION

Encapsulated eligibility logic into a pure, unit-tested evaluation module executed both for UI status indicators and server-side submission guards.

CHALLENGE 02

Role-Scoped Data Aggregation for Placement Analytics

PROBLEM

Administrators required real-time breakdowns of active drives and application stages without exposing sensitive individual candidate records to unauthorized roles.

ENGINEERING SOLUTION

Built parameterized SQL aggregation queries behind admin-only middleware to deliver clean summary datasets to the analytics dashboard.

07 · RESULTS AND LEARNINGS

What came to life.

VERIFIED DELIVERABLES

  • Role-based campus recruitment portal covering Admin, Company, and Student workflows.
  • Normalized SQL database schema with deterministic eligibility validation.
  • Interactive placement analytics view with filterable drive cohorts.

KEY ARCHITECTURAL LEARNINGS

  • Relational modeling and strict server-side authorization are indispensable when multiple user roles interact with shared state machines.
  • High-density administrative tools benefit massively from clean typography and tabular numeric alignment.