B2B Internship Management SaaS

Overview

During my internship at Vanness Plus Consulting Co., Ltd., I contributed to the development of a B2B Software-as-a-Service (SaaS) platform designed to streamline internship programs. The application serves multiple companies, providing a centralized system to manage the entire internship timeline—from the initial application phase through onboarding, performance evaluation, and final offboarding.

Key Features

• Multi-Tenant Architecture: Designed a scalable database structure that securely isolates data across different client companies while supporting various subscription packages.
• End-to-End Lifecycle Management: Developed robust backend infrastructures using Laravel to automate data processing for every stage of the intern journey.
• Role-Based Access & Workflows: Implemented distinct features, permissions, and dashboards tailored for three main user groups: System Admins, HR Managers, and Interns.
• Seamless UI Integration: Collaborated on frontend development, utilizing Tailwind CSS to build responsive and intuitive interfaces that integrated perfectly with existing UI components.

Challenges & Solutions

Challenge: Building a B2B SaaS application requires a complex database architecture. The system needed to handle multi-tenant data securely (ensuring Company A cannot see Company B's data) while allowing System Admins to manage overarching subscription plans globally without performance bottlenecks.

Solution: I took charge of designing the core Entity-Relationship (ER) diagram using MySQL to clearly define tenant boundaries and relational dependencies. By utilizing DBeaver, I managed database operations and actively optimized complex SQL queries. This ensured high-speed data retrieval and solid data isolation, laying a highly scalable foundation for the application's backend.