Ciudad Diveco
[Product · Grupo Diveco]
Regional corporate platform. Corporate platform on AWS that centralizes tools, reports, automations and AI capabilities in a single digital experience: 27+ integrated tools, ~250 users, five countries and four business units, with conversational analytics powered by Dormilón Analytics.
Results
- 250 users[Result]27+ tools across 5 countries
- ~150[Result]Power BI licenses replaced
The problem
The organization depended on scattered reports, isolated tools and manual processes to access commercial, financial and operational information. Executive reporting was fragmented across ~15 dashboards and required around 150 Power BI licenses, with slow decisions and duplicated effort across countries.
The solution
I designed and built a corporate platform that centralizes tools, reports, automations and AI in one experience: SAP integrations, RPA automations and data governance, reporting consolidated on the Data Lake, and Dormilón Analytics, an AI assistant for natural-language business queries.
The challenge
Scattered information and slow decisions
- Fragmented reporting
- Around 15 executive dashboards and close to 150 Power BI licenses to access commercial, financial and operational information; each country and business unit kept its own tools and versions of the truth.
- Manual processes and isolated systems
- Queries depended on specialists, Excel and ad hoc SAP integrations. The result: slow decisions, duplicated effort across countries and little traceability.
- No channel for AI
- The organization had a Data Lake, but there was no way for the business to exploit it or query data in natural language.
The approach
Platform as a product
- Ciudad Diveco
- I created and lead Ciudad Diveco, a regional corporate platform on AWS, owning product and architecture: 27+ internal tools integrated into a single digital experience.
- Reporting on the Data Lake
- I consolidated regional reporting by building it directly on the Data Lake, replacing some 15 executive dashboards and removing the need for roughly 150 Power BI licenses.
- Dormilón Analytics
- I designed an AI assistant connected to the Data Lake for natural-language business queries: billing, receivables, targets, PPU, margins, profit and commercial performance.
- Integrations and data governance
- I defined architecture, roadmap, permissions and auditing, with SAP integrations, RPA automations and data governance as part of the group's cloud architecture decisions.
The impact
A single organizational capability
- Real adoption
- Approximately 250 active users across five countries and four business units: executive analytics, finance, sales, HR and operations on the same platform.
- Fewer licenses, one truth
- Replacing dashboards and Power BI licenses reduced costs and centralized a single version of reality for executive decisions.
- Conversational decisions
- New queries are answered through conversational analytics and artificial intelligence, without depending on BI specialists for every business question.
Technologies
AWS Lambda · API Gateway · ECS/Fargate · Bedrock · Data Lake · SAP · RPA · Python · Node.js · LLMs · Serverless