Logo
Contact

CASE STUDY

Group Analytics Lakehouse — Real Estate & Property Dev. (UAE)

A UAE based real estate group with multiple development, leasing and property management companies wanted a single view of performance across the portfolio. Each subsidiary had its own ERP, CRM and spreadsheets, which meant slow reporting and conflicting numbers. 

How We Built A Single Source Of Truth For A Real Estate Group

The client’s finance and strategy teams were spending weeks every month stitching together reports from different subsidiaries.

Each company used its own mix of ERP, property management tools and spreadsheets. Names for the same metric were different, and “final” numbers kept changing during review meetings.

There was no central place where the group CFO could see cash flow, sales velocity, occupancy and project status across the portfolio. Decisions about new investments or refinancing were often made from partial data.

Algo worked with finance, IT and business owners from each subsidiary to define shared KPIs and build a group level lakehouse. Today, the group runs on a single model of properties, leases, customers and projects, with dashboards that update automatically instead of monthly spreadsheet marathons.

Subsidiaries In Scope: Development, leasing, facilities management, hospitality

Core Domains: Projects and inventory; Leases and occupancy; Collections and cash flow; Budget vs actuals

Primary Stakeholders: Group CFO and finance team; CEO and board; Asset and portfolio managers

Amrny — generative AI action bot (24/7 task execution)

Service

Scope

  • Order processing,
  • Returns triage
  • Customer follow-ups
  • Inventory alerts

Goal

  • Reduce manual workload
  • Speed fulfillment
  • Improve CX while keeping MENA compliance

8+

Subsidiaries

70%

Faster Decisions

30+

Standard KPIs

The Challenge

Consolidate group level performance without forcing every subsidiary into the same operational system.

Each subsidiary used its own ERP, property management system and custom reports. Data structures and naming conventions were different.

“Occupancy”, “pre bookings” and “collections” all meant slightly different things by business unit.

The internal IT team could not build and maintain a full data platform while also supporting day to day operations.

Our approach — simple, measurable, MENA-ready

AlgoCAS designed a focused, low-risk delivery plan

Assess

Map existing order flows, exceptions, and integration points (ERP, WMS, payment gateway).

Iterate

Tune triggers, fallback rules, and multi-language templates for Arabic/English dialects.

Pilot

Deploy Amrny on a subset — e.g., late-hour order confirmations and refund triage — to measure impact.

Built for scale

Roll out to full order lifecycle with observability and FinOps controls.

Revolutionize Your Workflow with Amrny

Amrny transforms your business by automating tasks 24/7 with cutting-edge AI. Say goodbye to delays and hello to efficiency, tailored for MENA’s unique needs. Start experiencing instant task execution today.

Trust Amrny for Unmatched Reliability

With Amrny, expect consistent, secure performance every time. Built on AWS and Informatica, it ensures compliance while cutting costs—perfect for MENA enterprises seeking dependable automation.

Our approach — simple, measurable, MENA-ready

AlgoCAS designed a focused, low-risk delivery plan

L

Assess

We started with short discovery sessions with finance, IT and business leads from each subsidiary. Together we mapped core data sources, current reports and the questions leadership wanted answered. From this we created a shared data model and a prioritized list of group KPIs, with clear definitions everyone could sign off on.
L

Design & Build

Next we designed a lakehouse architecture on AWS. Raw data from ERPs, CRMs and property systems lands in S3, is catalogued with Glue, and secured through Lake Formation. We then built curated layers and subject specific marts for finance, sales and operations, queryable via Athena or Redshift and exposed to dashboards in QuickSight.
L

Prove & Handover

We validated data quality with side by side comparisons against existing reports and month end packs. Once stakeholders were confident, we documented pipelines, access roles and KPI definitions, and trained the client’s analytics and IT teams to extend the platform on their own.

Empower Your Team with Amrny’s AI Power

Amrny equips your team with smart tools to work smarter, not harder. From setup to success, our support unlocks new potential, driving growth across KSA, UAE, and Egypt.nnIt ensures compliance while cutting costs—perfect for MENA enterprises seeking dependable automation.

Implementation Milestones

A focused three week rollout for the first group dashboard, then iterative expansion.

Week 1

Discovery workshops, system inventory and KPI definition. Draft group data model and confirm scope for first release.

Week 2

Build ingestion pipelines into S3, configure Glue and Lake Formation, and create curated datasets for finance and sales.

Week 3

Deliver first group dashboards in QuickSight, run validation against existing reports, and train internal teams on usage and extension.

Ready to unlock your cloud potential?

Talk to our architects. Get a free, no-obligation plan for your next 90 days.

Book a 30-Minute Session
Contact Sales

CASE STUDIES

Real Results, Real Impact

Discover how we’ve transformed MENA businesses with AWS (and Informatica where applicable).

SAMA Compliant Cloud Foundation — Banking & Government (KSA)

Delivered a secure multi-account AWS landing zone aligned to SAMA and NCA with encryption, centralized logging, and least-privilege IAM.

Group Analytics Lakehouse — Real Estate & Property Dev. (UAE)

Built a governed data lakehouse with automated pipelines from ERP, CRM and external sources.

AI Document Intelligence for Claims — Healthcare (KSA)

Automated classification and data extraction from PDFs and scans with human-in-the-loop review.