Architected custom Node.js middleware bridging Toggl, Absence.io, and internal CRM tool APIs into a centralized Power BI analytics engine for executive leadership.
A German small-medium enterprise (Mittelstand) was operating across fragmented systems (Toggl for time tracking, Absence.io for HR management, internal CRM tool, and manual spreadsheets for revenue forecasting). Executive leadership lacked a unified, real-time view of efficiency, resulting in unbilled hours and inaccurate client project scoping.
Mapped operational workflows and engineered an automated ETL middleware using Node.js and Express deployed on Render. The middleware synchronizes REST API data from Toggl, Absence.io, and internal CRM tool endpoints, normalizes time records against employee working schedules, and feeds a clean data model into 8 custom Power BI dashboards with 23 DAX metrics.
“It took me three years and it took you three weeks.”
Client, German SME (Mittelstand)
Elevated team efficiency from 49% to 65% within the first 30 days of deployment. The client's own estimate put the annualised value at €50,000, from recovered billable hours and clearer reporting.
Ask Bilal’s AI Clone