Modernizing Data Infrastructure for Operational Independence
BKOAI modernized data operations to reduce reliance on legacy systems, replacing critical workflows with scalable Microsoft Fabric and Databricks solutions integrated with Power BI and Power Apps
Goals
- Transition away from the parent organization’s systems.
- Establish scalable replacements for legacy workflows.
- Implement high-frequency alerts for tank monitoring.
- Accelerate data delivery to downstream applications.
Challenges
- Operations depended heavily on deprecated data sources and parent-organization systems.
- An outdated codebase created operational and business risks.
- Key tank metrics required continuous monitoring.
- Slow data processing delayed information delivery to downstream applications.
Solutions
- Migrated core data inputs to PI tags for use in Seeq.
- Rebuilt reporting processes in Microsoft Fabric.
- Automated scheduled notebook runs for forecasting workflows.
- Used multithreaded API calls to improve data-processing speed.
Results
- Eliminated dependencies on legacy parent-organization systems.
- Reduced application-workflow latency from 120 seconds to 10 seconds.
- Automated essential monitoring and alerts.
- Reduced processing time for key reports by 50%.