Mantra Pharma
Pharmaceutical industry
The objective was to centralize, automate, and secure the data architecture to support strategic decision-making.
Context
Manual processes
Preparing reports and collecting performance indicators required extensive manual intervention, creating inefficiencies and increasing the risk of errors.
Data centralization
Establishing a structured framework to enhance analytical capacity and streamline decision-making processes.
Security and access
Ensuring data security by defining access priorities and protecting sensitive data to maintain confidentiality.
Objectives
1
Create a centralized and secure environment.
2
Automate data ingestion and reporting processes.
3
Standardize data governance rules to ensure uniform analysis and interpretation.
Proposed solutions by Neos Group
Architecture design
Data lake configuration
A data lake was implemented on Azure to centralize and structure data from internal and external sources for more efficient analysis.
Automation of data ingestion
Automated ingestion pipelines were developed to process critical operational data, representing approximately 80% of recurring data. These pipelines reduced manual intervention, ensuring timely access to data while maintaining accuracy.
Data security and governance
Role-Based Access Controls (RBAC)
Access controls were implemented based on user responsibilities, ensuring only authorized individuals could access sensitive data.
Data encryption and security
Sensitive data was encrypted using the highest standards to protect confidentiality and ensure compliance with Mantra Pharma’s data governance policies.
Power BI reporting automation
Dynamic report creation
Automated Power BI reports were developed to allow teams to easily access operational and sales KPIs. This included dashboards that facilitated data interpretation and enabled faster decision-making.
Monthly presentation optimization
Custom dashboards were designed to streamline monthly presentations, enabling teams to analyze inventory, sales, and order trends more efficiently.
Results achieved
Automatization
Reduction of 50% in manual tasks for report preparation, freeing up time for strategic analyses.
Fast decision-making
Centralized access to reliable data empowers teams to make accurate and confident decisions that enhance day-to-day operations.
Enhanced security
Implementation of advanced access controls and security measures to protect sensitive data, ensuring compliance with Health Canada regulations.
“Thanks to the work of Neos Group, we now have a centralized and automated data architecture that supports our operational needs. The security and reliability of our infrastructure allow our teams to make decisions with complete confidence and speed.”
Olivier Paquet, Vice President of Operations
Mantra Pharma
Technologies used
Microsoft Azure
Data Lake, Azure Synapse for data storage and management.
Azure DevOps
For project management, deployment, and continuous integration.
Power BI
For creating dynamic reports and dashboards.
Conclusion
Neos Group transformed Mantra Pharma’s analytical infrastructure into a secure and efficient architecture. By combining automation, security, and performance, we enabled Mantra Pharma to optimize its operations and enhance its strategic decision-making capabilities.