From Manual Reports and Outdated Forms to a Live AI Platform Processing Over a Million Data Points Daily

ACI Protection manages security operations for a large US-based enterprise organisation — and for years, the data flowing in from their service provider Acadian was being handled entirely by hand.

AI CONTENT CREATION
From Manual Reports and Outdated Forms to a Live AI Platform Processing Over a Million Data Points Daily

ACI Protection operates in an environment where accuracy, speed, and reliability aren't just performance metrics — they're contractual obligations. When you're managing security operations for a large US-based enterprise client, the quality of your reporting and the efficiency of your service workflows directly affect the trust your client places in you. Gaps in either area don't just create internal friction. They create client risk.

Acadian, ACI's data provider, was pushing enormous volumes of operational data ACI's way every single day. The raw intelligence was there. The problem was everything that happened — or failed to happen — after it arrived. The systems ACI was working with were fundamentally mismatched to the demands of modern enterprise security operations:

  • Reporting was entirely manual — and it showed — Every client report had to be compiled by hand. Team members were spending significant hours aggregating data from Acadian and other sources, formatting it, cross-checking it, and producing documents that were already partially out of date by the time they were delivered. For an operation receiving data at the scale ACI was, manual reporting wasn't just inefficient — it was a structural vulnerability.
  • There was no real-time visibility — ACI's enterprise client and internal stakeholders had no live window into operational data. Everything they knew about what was happening on the ground was retrospective — filtered through a report that was hours or days old. In security operations, that lag matters enormously.
  • Data from Acadian was siloed and unstructured — ACI was receiving over a million data points every single day from Acadian's systems. But that data arrived in formats that didn't integrate cleanly with ACI's internal tools, with no unified infrastructure to store, query, or analyse it at scale. The intelligence was there — buried, inaccessible, and going largely unused.
  • Service request forms were outdated and inflexible — The forms ACI relied on for service requests were legacy tools — not web-native, not mobile-friendly, and not adaptable to evolving operational needs. Every time a new process or service type emerged, the forms couldn't keep up. Workarounds accumulated. Data quality suffered.
  • No ability to build or modify forms independently — When ACI needed a new form — for a new service line, a new client requirement, a new internal process — they were dependent on external development support to build it. That created bottlenecks, delays, and a creeping inability to respond to operational changes with any agility.
  • Client reporting expectations were growing faster than capacity — ACI's large enterprise client had increasing expectations around reporting depth, frequency, and accessibility. ACI's manual process was already strained. Scaling it further to meet rising client demands wasn't feasible without a fundamentally different approach.

The gap between what Acadian was providing and what ACI could actually do with that data was costing them time, money, and competitive edge. Something had to be rebuilt from the ground up.


We approached the build in carefully sequenced phases — because replacing the operational backbone of a live security business can't be done all at once without risk. Every phase was designed to deliver immediate value while building toward the full platform vision.

  • Phase 1 — Data Infrastructure & Ingestion Pipeline — The foundation. We mapped every data source ACI was working with, designed the unified database architecture, and built the ingestion pipeline to begin pulling, cleaning, and storing data at scale. This phase established the platform's core — a single, reliable, queryable source of truth for ACI's operational data.
  • Phase 2 — Reporting Engine & Dashboard — With clean data flowing into the platform, we built the reporting layer. The real-time dashboard went live first — giving ACI and Acadian their first-ever window into live operational data. Automated scheduled reporting followed, immediately eliminating the manual compilation process that had been consuming team hours every week.
  • Phase 3 — Web-Native Forms & Form Builder — Legacy forms were replaced with modern web-native versions, integrated directly into the platform. The form builder was then built and handed over with full training — giving ACI's team the ability to create and deploy new forms independently, for any operational use case they encounter going forward.

The impact across ACI's operations was immediate and significant:

  • Manual reporting was eliminated entirely — The hours that operations and account management teams had been spending compiling reports every week were reclaimed. Reporting now happens automatically, accurately, and on time — every time.
  • Acadian gained real-time operational visibility for the first time — Live dashboards replaced retrospective reports. Stakeholders who previously waited days for data now have it in front of them the moment they need it.
  • Data that was previously inaccessible became a genuine operational asset — With over a million daily data points now stored, structured, and queryable, ACI can identify patterns, surface insights, and make decisions that simply weren't possible before.
  • ACI's team is no longer dependent on external development for new forms — The form builder has already been used to create new service request flows, client onboarding forms, and internal data capture tools — all built and deployed internally, in a fraction of the time it previously took to commission external development.
  • The platform scales with the business — As ACI's operations grow and Acadian's reporting requirements evolve, the infrastructure is built to absorb that growth without needing to be rebuilt.
React JsReact Js
PythonPython
PostgreSQLPostgreSQL
AWSAWS
Node.jsNode.js
OpenAIOpenAI

We designed and built ACI Protection an enterprise AI platform purpose-built for the realities of large-scale security operations — one that could ingest, store, and surface over a million data points a day, deliver reporting in real-time or on schedule, and give ACI's team the tools to manage their own forms and workflows without external dependency.

This wasn't a configuration project or an off-the-shelf deployment. It was a ground-up platform build, designed around ACI's specific operational architecture and Acadian's enterprise reporting requirements.

Here's what we delivered:

  • AI-Powered Data Aggregation at Scale — We built a data ingestion layer capable of pulling in and processing over one million data points daily from across ACI's operational systems. Structured and unstructured data, from multiple sources, unified into a single scalable database architecture that grows with the business rather than against it.
  • Real-Time Reporting Dashboard — Acadian and ACI stakeholders now have live visibility into operational data through an intuitive, role-based dashboard. What used to require hours of manual compilation is now available at a glance — current, accurate, and accessible from anywhere.
  • Scheduled Automated Reporting — For clients and internal stakeholders who need regular structured reports, the platform generates and delivers them automatically — on whatever cadence is required, in whatever format is needed. Zero manual effort. Zero delay. Zero risk of human error in the compilation process.
  • Web-Native Service Request Forms — We replaced ACI's outdated legacy forms with modern, web-native replacements — mobile-responsive, cleanly designed, and integrated directly into the platform's data layer so that every form submission flows automatically into the right place.
  • A Full Form Builder — Built for Autonomy — The most empowering piece of the platform. Rather than giving ACI a fixed set of forms they'd eventually outgrow again, we built them a drag-and-drop form builder that lets their team create, modify, and deploy new forms entirely independently. New service line launching? New client onboarding requirement? New internal data capture need? ACI can build the form themselves — in minutes, not weeks — and plug it directly into their operational workflow.
  • Scalable Cloud Infrastructure — The entire platform was built on a cloud-native architecture designed to handle ACI's current data volumes and scale horizontally as those volumes grow — without performance degradation or costly rebuilds down the line.

1M+

data points

100%

elimination of manual report compilation

80%

reduction in time-to-insight

100%

Full form autonomy achieved

Share this Case Study