Developed during my internship at a chemical company, this Django-based system automates data management and reporting by integrating directly with SAP Business One. The project addresses critical inefficiencies in managing data across product SKUs and Bill of Materials items.
Previously, documentation was labour-intensive and error-prone:
- Manual data retrieval from SAP Business One database
- Complex calculations across multiple departments (sales, lab, production)
- Batch-specific tracking requirements for compound products
- Time-consuming report generation for regulatory compliance
- High risk of human error in data entry and calculations
This system automates the entire workflow by:
- Direct SAP Integration: Real-time data retrieval from SAP Business One via MS SQL Server
- Automated Calculations: Batch-specific allergen calculations for complex formulations
- Multi-Department Support: Separate modules for sales, lab, production, and meta analysis
- Secure Architecture: Environment-based configuration for database credentials
- Scalable Design: Handles large-scale operations with 46+ data columns per SKU
- Backend: Django with SQLAlchemy ORM
- Database: Microsoft SQL Server (SAP Business One)
- Data Access: pymssql for efficient database queries
- Security: python-decouple for credential management
- Modules:
core/- Database utilities and shared functionalitysales/,lab/,production/- Department-specific data managementmeta/- Cross-departmental analysis
The most complex aspect was handling batch-specific allergen data for compound products. When a product contains multiple ingredients, each from different batches with varying properties, the system must accurately aggregate and calculate allergen information. This required:
- Sophisticated database schema design
- Efficient query optimization for large datasets
- Precise calculations maintaining batch traceability
- Real-time synchronization with SAP Business One
- Database integration and query optimization
- Enterprise system integration (SAP)
- Data-intensive application development
- Security best practices for credential management
- Multi-module Django architecture