The SAP / Sage 300 Integration
The Objective: A major manufacturing firm required real-time analytics, but their data was locked inside a legacy monolithic ERP environment. Ripping and replacing the system was deemed too high-risk and costly.
The Architecture: Engineered a secure, read-only middleware protocol using Python. This pipeline extracted raw SQL data from the legacy environment without disrupting active operations, transformed the metrics, and fed them directly into a centralized Power BI executive dashboard.
Automated Hardware Telemetry
Bypassed manual data entry on the warehouse floor by building a custom Flask web application. The application queried internal databases in real-time and communicated directly with TSC and Bixolon thermal printers via Python, eliminating human error in labeling.
High-Volume ETL Pipelines
Re-architected fragmented, siloed company data into a unified structure. Developed automated ingestion scripts that extracted thousands of rows daily, cleaned null values programmatically, and mapped them to a centralized Star Schema for executive reporting.