A global media and entertainment leader operating large office campuses worldwide engaged Akraya to transform their security, workplace, and incident data operations. The organization relied on fragmented manual processes to track employee badge swipes, visitor logs, security incidents, and office occupancy – all essential for physical security, workplace planning, and cost optimization.
Challenges Faced
This section outlines the core difficulties and pain points the client was experiencing. It provides context on the hurdles that needed to be overcome before achieving the successful outcome.
Manual Data Pipelines Creating Security & Operational Gaps
Critical security data was refreshed only weekly or monthly via manual CSV downloads and Tableau uploads.
Fragmented Sources & No Single Source of Truth
Data lived in isolated silos: Genetec for badge swipes, Ontic for incident reports, Envoy for visitors, plus Google Sheets for manual entries.
Data Quality & PII Exposure Risks
Incident reports contained sensitive personal information (names, details) with no role-based access controls.
Akraya’s Strategic Solution
We engineered an end-to-end automated data platform to ingest, secure, and visualize critical security and occupancy data in real time -
Akraya replaced manual CSV workflows with automated API-based extraction from Genetec, Ontic, Envoy, and other third-party systems. Using Python based ETL processes, we ingested data hourly into a central data lake, eliminating weekly delays.
We built a governed data lake with strict access controls to protect PII. Sensitive incident data was anonymized or restricted to authorized security teams.
Using historical badge swipe and parking lot data, we created predictive occupancy models that helped the client right-size parking facilities and optimize cafeteria food planning.
Measurable Outcomes
Operational
100% automated ETL across 4+ sources and eliminated all manual CSV downloads & Google sheet uploads.
Scalable data foundation established with reusable ETL framework, ready to ingest additional sources (e.g., Greenbridge) with minimal effort.
Conclusion
Akraya transformed a fragmented, manual security and workplace data operation into an automated, real-time analytics platform. By integrating badge swipes, incidents, and visitor logs via APIs, building a governed data lake, and delivering Tableau dashboards, we enabled faster security response, reduced operational costs, and empowered facilities teams with predictive insights.
