Overview
iRestify is a Canadian PropTech company that streamlines property maintenance and management by connecting landlords, property managers, and service providers through a tech-enabled platform. When I joined as an intern, leadership had no centralized way to monitor the business — data lived across multiple disconnected systems, and getting a coherent picture of what was happening required manual effort. My role was to change that. Working directly with the product manager, I built the company's business intelligence layer from the ground up.
The Challenge
iRestify ran on several systems simultaneously — service requests, contracts, financials, sales channels — each generating data in isolation. Leadership had no consolidated visibility into operational health, revenue trends, or channel performance. Decisions were being made on incomplete or delayed information. The goal was to build a single hub where all of that data converged, was processed with intelligence, and surfaced as actionable insight for managers and directors — the only audience for this tool.
My Role & Process
Data Architecture & Integration
- Connected Google Data Studio (now Looker Studio) to iRestify's MySQL database, establishing live data pipelines from multiple internal systems into a single reporting layer
- Mapped all available data sources and worked with the product manager to define which metrics were genuinely decision-relevant versus noise
- Structured the data layer so dashboards reflected the current state of the business as systems were used, instead of manually assembled snapshots
Dashboard Design & KPI Framework
- Designed the full dashboard suite from scratch — covering operational health, financial reporting by service type and contract, sales channel performance, and demand forecasting
- Built KPI frameworks tailored to each leadership audience: what a director of operations needs to see is different from what a sales manager tracks
- Incorporated trend analysis and forecasting views so leadership could identify patterns and anticipate issues, not just react to them
- Applied data visualization best practices to make dense, multi-source data readable and actionable at a glance
Results & Impact
The dashboards gave leadership visibility they didn't have before — surfacing which channels were underperforming and why. The project replaced scattered, manual reporting with a consolidated intelligence layer that leadership could rely on daily. This work was done during an internship concurrent with my Big Data Science & Analytics studies at Toronto School of Management, where I was applying in production what I was learning in the classroom.