The objective of the solution:
Administrator goals:
- Remove manual entry of member packaging waste by Valorlux
- Reduce operational risk
- Facilitate the addition, deletion, or encoding of materials, product families, etc.
- Automate member billing (advances, adjustments, rebates...)
- Enable data analysis via Power BI
Objectives for member companies:
- Reduce tedious exchanges between Valorlux and members
- Streamline packaging waste declaration time through simplified and/or detailed reporting
- Allow the addition, deletion, or encoding of materials, product families, etc.
- Visualize billing
Our achievement:
- Analysis of the logic and existing solution
- Complete overhaul of the existing architecture
- Version upgrade on certain components
- Development and implementation of simplified declarations
- Synchronization with Zoho CRM
- Development of the billing section (advances, adjustments, rebates, etc.)
- Synchronize with Zoho Books to automate invoicing from Valbase
- Development and Implementation of Detailed Declarations
- Tests on a staging environment
- PenTest with our partners
- Production and deployment of Valbase
Technologies used:
- Web Portal
- SP MVC 3.1
- DevExpress Bootstrap
- Power BI Report Integration
- Azure Functions
- Data Management
- SQL Server: Storage and Search Engine
- Third-party system integrations
- Mailchimp: Newsletter Management
- Mandrill: Sending Emails
- Zoho Books: Billing
- Zoho CRM: Customer data
- Demasy: Export of billing data from Valbase
- Hosting / Infrastructure
- Hosted on Azure
- CI/CD Pipeline: Automated Deployment to Staging and Production Environments (Azure DevOps) Learn more about the DevOps approach and the CI/CD pipeline