01 · ARTIFACT 002 / CASE STUDY
Back to selected workPlacementPortal
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
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.
Multi-Role Portal Interface
Dedicated dashboards for Admin governance, Company drives, and Student applications.
React · TypeScript · Tailwind CSS
RBAC Policy Engine
Role-Based Access Control enforcing Admin, Company, and Student permissions.
RBAC Middleware · Session Auth
Application & Eligibility Service
Validates student academic criteria against drive rules and computes analytics.
Python / Node.js · REST API
Relational SQL Schema
Normalized tables for student academic profiles, company drives, and round statuses.
SQL · Relational Constraints
05 · KEY FEATURES
Feature showcase.
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
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.
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.
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.