Trainee Contract & Stipend Management Platform
Workforce Finance & Staffing
Automated trainee stipend calculations and invoicing across per-company commercial structures.
Per-company
Calc
Excel
Input
Auto invoices
Output
Eliminated
Errors
Overview
A specialised platform that automates complex stipend calculations and invoicing for trainees placed across multiple companies, each with its own commercial structure of admin charges, insurance and fees.
The business problem
Stipends and invoices were computed by hand in spreadsheets against per-company commercial rules, which was slow and error-prone.
The solution
I implemented a Flask calculation engine that encodes each company's commercial structure, validated Excel attendance ingestion, and an automated invoicing pipeline — eliminating manual spreadsheet errors.
My responsibilities
- Implemented the per-company stipend calculation engine
- Built a standardised Excel attendance ingestion and validation flow
- Automated invoice generation from validated inputs
- Centralised company, commercial-term and trainee data
Challenges solved
- Encoding unique commercial structures per company
- Validating inconsistent attendance spreadsheets
- Removing manual errors from the legacy process
Key features
Architecture highlights
- Flask calculation engine encoding per-company rules
- Validated Excel ingestion for attendance data
- Automated invoicing pipeline over a relational model
Technologies used
Scalability
New companies and commercial structures are onboarded as configuration, so the platform scales across placements.
Performance
- Batched calculation runs
- Fast, validated Excel parsing
- Indexed lookups for trainee and company data
Security
- Role-based access to financial data
- Validation of every ingested record
- Auditable calculation and invoice runs
Screenshots
Product screenshots available on request (NDA-protected).
Architecture diagram
Detailed system architecture available on request.
Related work
View allAsset Tracking & Management Platform
Asset & Rental Inventory Management
Real-time, up-to-the-second visibility and financial intelligence across a fleet of rental and organizational assets.
Contract Lifecycle Management Platform
Legal Operations & Contract Management
Digitised the entire contract journey — from entity registration to multi-stage legal approval and milestone payments.
Customer Relationship Management Platform
Sales & Customer Intelligence
Centralised customer data, sales tracking and tax-compliant invoicing with customer-trend analytics.