Back to Projects

R&D Formulation Database

Internship Project

Soudal NV Internship · 2026

R&D Formulation Database

Soudal NV Internship · 2026

The R&D Formulation Database is an additional MVP application developed during my Soudal internship after completing the main Visit Request Portal project. This web-based system helps the R&D department manage chemical formulations in a structured way, replacing manual or fragmented tracking with a centralized database. Key Features: • 4-step wizard for formulation creation (admin, ingredients, production, tests) • Ingredient composition with automatic weight calculations • Parts calculator for maintaining ingredient ratios • Production instruction management • Dynamic test definitions with flexible field types • Test result registration and tracking • Bulk operations (add tests/results to multiple formulations) • Advanced search with multiple criteria and operators • Permission-based access control (View, Add, Edit, Delete, Tests) • Copy existing formulations for efficiency • Azure deployment with infrastructure as code

Key Learnings:

  • Complex data modeling for scientific/laboratory applications
  • Dynamic form generation with configurable field types
  • Bulk operations and grid-based data entry
  • Advanced search with dynamic LINQ queries
  • Permission-based authorization (granular access control)
  • Multi-step wizard implementation
  • Real-time calculation logic in JavaScript
  • Reusing architectural patterns from previous project

Screenshots

R&D Formulation Database screenshot 1
R&D Formulation Database screenshot 2
R&D Formulation Database screenshot 3
R&D Formulation Database screenshot 4
R&D Formulation Database screenshot 5

Technologies Used:

ASP.NET CoreRazor PagesEF CoreAzure SQLMicrosoft Entra IDTailwind CSSJavaScriptAzure Bicep

My Contribution

I developed this MVP application independently as additional work during the internship. Analysis & Design: • Gathered requirements from R&D department • Created Figma prototypes for formulation workflows • Designed use case diagram and ERD • Planned database structure for flexible formulation data Core Implementation: • Built 4-step wizard for formulation creation • Implemented ingredient composition with auto-calculation logic • Created production instruction management • Developed dynamic test definition system • Built test result registration and tracking • Implemented formulation detail view • Added copy formulation functionality Advanced Features: • Developed advanced search with multiple criteria • Built bulk test assignment feature • Created bulk result entry with grid interface • Implemented permission-based access control • Added user management module • Built test definition management interface Infrastructure: • Prepared Azure deployment configuration • Created Bicep templates for infrastructure • Designed database indexes for search performance • Implemented EF Core migrations