Case Study
Environmental Consulting Firm Transforms Planning & Reporting
National environmental and engineering consultancy | 30+ offices across US | Project-based revenue model
Context
A rapidly growing environmental consulting firm was drowning in spreadsheets. With 30+ offices running different projects simultaneously, their planning and reporting process had become unsustainable. Financial forecasts took 3 weeks to consolidate across offices, by which time the data was already outdated. Project managers submitted their forecasts in different formats, finance spent more time chasing data than analyzing it, and executives lacked visibility into real-time project profitability across their distributed operations.
What We Built
We conducted a 4-week assessment of their planning and reporting processes, interviewing project managers, office leads, and finance team members across multiple locations. The root problem wasn't the spreadsheets themselves—it was the lack of a unified planning framework that could handle their project-based revenue model, multi-office structure, and need for both bottom-up project forecasts and top-down strategic planning.
Rather than immediately jumping to technology selection, we first redesigned their planning process to eliminate unnecessary complexity. We identified which data actually drove decisions (project pipeline, resource utilization, regional performance) versus what was just "nice to have." Then we evaluated EPM platforms specifically against their requirements: project-based planning, multi-entity consolidation, Microsoft 365 integration, and ability to give project managers simple input forms while giving finance sophisticated analysis capabilities.
Impact
We recommended and oversaw the implementation of Vena Solutions, which fit their needs perfectly and came in 30% under budget compared to alternatives that would have required heavy customization. The new system reduced forecast consolidation time from 3 weeks to 6 weeks—an 85% improvement. More importantly, project managers can now update their forecasts in real-time through simple web forms, finance has automated consolidation and variance analysis, and executives get daily visibility into project profitability and resource utilization across all 30+ offices. The firm now reforecasts monthly instead of quarterly, enabling faster response to market changes.
"Before Finaptive, we were spending 3 weeks every quarter collecting data that was outdated before we finished analyzing it. Now we have real-time visibility and our finance team actually has time to provide strategic guidance instead of being data janitors."
— VP, Finance, National environmental consulting firm












