UCO RECYCLING COMPANY
BUSINESS PROBLEM
This Used Cooking Oil (UCO) Recycling Company set an ambitious goal to triple its business in 3 years. To support this growth projection, their IT infrastructure and core business systems required modernization and migration to the cloud. Additionally, they needed actionable insights from their data to make informed decisions about growth potential and optimize their operations.
SCALESOLOGY IN ACTION
Scalesology serves as the data operations partner for this UCO Recycling Company, providing ongoing support and solutions to meet their growing needs. Current projects and activities include:
Data Integration and Centralization:
Centralized data from disparate systems (on-premise and cloud) into a unified data lake house in Snowflake using Python.
Implemented daily updates with email notifications for error reporting.
Ensured data redundancy for CRM, Financial, and HR systems.
Enabled scalable third-party cloud application integrations (e.g., push/pull from Salesforce).
Integrated historical data from new company acquisitions into the data warehouse.
Built interfaces between legacy and new applications to ensure seamless data transmission.
Analytics and Reporting:
Developed Power BI dashboards using SQL and DAX for underlying data models.
Replaced static reports with dynamic dashboards.
Display monthly forecast results.
Created customized apps for different business users.
Generated forecasts using Python and the Prophet library:
Forecasted the amount of used oil for all locations based on specific time periods (e.g., every x weeks).
Forecasted monthly and weekly amounts of used oil collected.
Forecasted monthly sales prices for used cooking oil.
Updated forecasts monthly.
Ongoing Support and Maintenance:
Provided third-party application support for various company systems.
Supported ongoing data operations and data lakehouse connections.
Created new dashboards and reports for business users.
Migrated data from newly acquired companies.
Performed routine maintenance and support for data assets.
RESULT
This UCO Recycling Company can now scale and grow without concerns about impacting production or hindering future expansion. Specific operational improvements include:
Key Impacts:
Data Redundancy: Critical systems are updated daily, ensuring data integrity and reliability.
Improved Reporting: Detailed reports can be generated directly from the data lakehouse without affecting production systems.
Analytical Data Warehouse: Serves as the foundation for current and future modeling and analytic initiatives.
Scalable Data Ingestion: A robust process accommodates both existing and new data sources seamlessly.
Automation: Significantly reduced manual data entry and streamlined monthly report generation tasks.
Executive Dashboards: Daily-updated dashboards provide visibility into critical KPIs, budgets, and route information for executive and business unit management.
SERVICE REFERENCES
Comments