Process automation
Manual, repetitive routines converted into automatic, reliable, reprocessable flows.
Six systems that didn’t talk to each other, now on a single base.
I designed and built, from scratch, a data platform under the group’s control that is today the backbone of reporting, financial automation and systems integration at Grupo Carlessi. Everything runs inside the group’s own infrastructure, with protected access — with no dependency on third-party cloud and no software subscription.
Role · Architecture, data engineering, DevOps and development
Scope · End-to-end project
In short, for decision-makers
The problem
Grupo Carlessi — a consortium, a construction company and a retailer — had six systems that didn’t talk to each other, and important management reports were extracted and checked by hand, one by one, straight from the ERP.
What LNData did
We built, from scratch, a platform that brings those six systems together, automates the reports and the financial side (bank slips, bank remittances) and runs entirely inside the group’s own infrastructure, with no cloud subscription.
The result
Reports now arrive ready and reliable, billing happens on its own and the group has a single source of numbers — all under its own control.
Business verticals covered
Consórcio Carlessi
Construtora Carlessi
Comercial Carlessi
6
integrated source systems
+20
automated pipelines in production
~60
tables and views in the data warehouse
3
delivery channels (BI, apps, email)
Architecture
The platform integrates 6 distinct source systems, orchestrates the data pipelines and delivers the results through three channels: BI dashboards, internal applications and automations that send emails, reports and files without human intervention.
Source systems
- Consortium ERP
- Construction ERP
- Commercial database
- Financial systems
- External service APIs
- Internal files
Data platform
Pipeline orchestration
Analytical data warehouse
Containerized · TLS · VPN access
Delivery
- BI dashboards
- Internal applications
- Email · reports and files
Automation and internal controls
Manual processes and internal controls across the group’s areas converted into automatic, integrated and auditable routines.
Internal control optimization
Standardized, traceable controls and checks with an audit trail.
Systems integration
Systems that didn’t talk to each other consolidated into a single database.
Reports and indicators
Management information delivered ready and automatic, with no manual extraction.
Product · Carlessi Toolbox
Modular internal platform with agentic AI
An internal web system that centralizes report generation, data input and control, access management and agentic AI integrations. Designed to be extensible by modules on demand: each feature comes in as a self-contained package, without changing the application’s core.
Modular architecture
Extensible by modules on demand — each feature comes in without changing the application’s core.
Security and governance
Role-based access control, revocable sessions and an audit log of every relevant action.
Asynchronous reports
Excel and PDF generation in the background, with automatic delivery by email.
AI integration (MCP)
AI agents operate the platform respecting exactly the same permissions and audit trail as users.
FastAPICelerySvelteKitPostgreSQLRedisMCPDocker
Impact
Management reports once extracted and checked manually in the ERP now arrive ready, automatic and auditable.
A single analytical source of truth over 6 systems that didn’t talk to each other.
Critical financial automation (bank slip issuance, bank remittances) running without human intervention.
A self-hosted, reproducible platform, fully under the client’s control.
Data platform stack
AirflowClickHouseSupersetStreamlitDockerPython
A similar data challenge?
From integrating legacy systems to financial automation and agentic AI — tell us what you need to solve and we’ll come back with scope, timeline and deliverables.