Courses and schedules
Course offerings, modules, subjects, locations, scheduling, course options and links between people and activities.
Case study · Custom business software
From an original idea to a comprehensive business solution connecting courses, people, examinations, accounting and much more.
I designed the overall concept and architecture and developed almost all of the software myself. Instead of separate utilities, the institute has an integrated solution that can evolve with its requirements.
Original idea and concept
A training institute manages far more than courses. Inquiries, enrolments, instructors, schedules, examinations, invoices, payments and participant information are closely connected.
My idea was to bring these relationships into one custom business system. I developed the functional and technical concepts, so that different areas could work with the same information.
Scope of the solution
The institute uses the following functions as parts of a connected solution, rather than as separate programs.
Course offerings, modules, subjects, locations, scheduling, course options and links between people and activities.
Inquiries, contact records, enrolments, participant files, instructor assignments and billing workflows across the office and web areas.
Exam schedules, results and grading, as well as tasks and processes for issuing diplomas and completion documents.
Sales and purchase invoices, outstanding balances, reminders, bank statement imports, payment matching and accounting data exports.
Tasks, documents, permissions and reports, plus processes, complaints and follow-up measures supporting quality management.
Calls are associated with contact records, while website and print content is maintained centrally and processed through external translation services.
Technical implementation
The system includes a C#/.NET Windows application, background processes for recurring tasks, and a PHP/Laravel website with public content and restricted areas for learners and instructors. The components use a shared SQL Server database.
Bank files, an external accounting system, a telephone system, email and translation services are connected through interfaces. Those third-party services are not rebuilt; my work covers the business logic, architecture, user interfaces and integration.
Connected business processes
A booking links to the participant record and billing. Invoices, outstanding payments and imported bank transactions can be matched and prepared for external accounting.
Courses, modules and examinations share information. Exam results and completion processes lead into the relevant tasks and diploma documents.
An external telephone system interacts with the custom software. Incoming calls can be linked to existing contact records and shown to office staff.
These examples describe implemented functions and their relationships. No measured time or cost savings are claimed.
My personal contribution
I came up with the original idea, analysed the workflows, designed the complete functional concept and software architecture, and personally wrote nearly all the code.
Additional programmers provided limited support at certain stages under my direction. I have remained responsible for the central technical work and long-term evolution of the system.
Whether you need a new management system, specialist application or connected business software, tell me what you want to achieve. We can discuss practical next steps in a no-obligation initial conversation.