Enterprise Event & Budget Lifecycle Portal
Medical-education events tracked from money down to evidence of delivery.
- Role
- Solution Designer, Lead Developer
- When
- 2025 – present
- Where
- Connexink (via Xtreme Thoughts)
- Client
- Pharmaceutical company
The problem
The problem
Budget planning, PO association, regional & zone allocation, field execution, doctor invitations and post-event expenses — each stage gated by the allocation above it.
The system, drawn
The system, drawn
How it works · 2 parts
- 01
Architecture
ASP.NET Core 8 MVC over a deliberate Dapper micro-ORM layer (no EF) against SQL Server, with server-side paginated grids and a Razor + Bootstrap admin UI.
- 02
Security & ops
Microsoft Entra SSO (OIDC + PKCE) alongside cookie auth, Azure Blob for documents, Quartz.NET jobs, Serilog audit-grade logging, server-side PDF merge and Excel export.
Stack
- ASP.NET Core 8 MVC
- C#
- Dapper
- SQL Server
- Microsoft Entra ID
- Azure Blob Storage
- Quartz.NET
- Serilog
- jQuery
- Bootstrap 5