Vergo's clients in the building and construction industry struggled with fragmented financial data across legacy ERP systems. This fragmentation made accurate revenue forecasting, Work-In-Progress (WIP) tracking, and real-time decision-making nearly impossible.

Manual data validations created errors in percentage-of-completion accounting. Financial teams lacked tools to model project cost changes or contract adjustments dynamically, leaving executives without reliable cash flow visibility.

To build a financial management and forecasting platform that integrates multi-ERP data into a BigQuery warehouse, deploys ML regression models for revenue predictions, and automates validations via n8n AI agents.

The objective was to streamline construction FP&A workflows, enable percentage-of-completion accounting, and deliver an intuitive Retool interface for executive scenario planning.

Domain-Driven GCP Data Warehouse Architecture: Architected a modular data pipeline using Airbyte to ingest ERP data into Google BigQuery partitioned tables for cost-effective WIP tracking.

Machine Learning Revenue Forecasting Model: Developed a regression-based ML model embedded into Retool to predict monthly revenue accurately while adjusting for project cost changes.

n8n AI Agent Workflow Automation: Deployed intelligent n8n AI agents and Python scripts to automate complex data checks, system alerts, and multi-ERP reconciliation.

Percentage-of-Completion Accounting Engine: Programmed projection modules supporting month-by-month earned revenue calculations with job-specific edit overrides in Retool.

Prorated Goal Tracking System: Designed a goal-setting interface in Retool that auto-fills target metrics using proration logic, simplifying financial forecasting.

Toolshed delivered a scalable forecasting platform tailored for construction FP&A. By combining BigQuery data warehousing, machine learning, n8n AI agents, and a Retool front-end, Vergo empowered its clients to make real-time financial decisions with confidence.

"I had the privilege of working with Abdul and his team developing our product. From the beginning, they demonstrated exceptional skills not only as developers but also as true product thinkers. They took the time to deeply understand our business goals and user needs, translating them into solutions that exceeded our expectations. Their ability to execute with speed and precision while maintaining the highest quality of code was remarkable. Whether it was tackling complex challenges, integrating user feedback, or delivering under tight deadlines, Abdul and his team consistently went above and beyond. Their collaborative approach and attention to detail made the entire process seamless and enjoyable. I highly recommend Abdul and his team!" – Rich, CEO of Vergo