Tower Operations & Field-Service Platform
An end-to-end operations and field-service platform I designed and built from the ground up for a security & telecom operator in Ireland, now adopted company-wide to manage an entire CCTV tower division. Screenshots are anonymised to protect client confidentiality.
Internal Operations & Field-Service Platform
Security & Telecom Operator · Ireland
The Challenge
The company had no central record of its CCTV tower fleet — what equipment existed, where each tower was located, the issues found on site or how they were resolved. Operations were tracked informally across spreadsheets and messages.
The Solution
I built a single web platform to manage clients, towers, visits, parts and jobs — with live dashboards, an interactive locations map, a Kanban board, monitoring sync and a full audit log, all behind role-based access.
The Impact
- • Adopted company-wide as the single source of truth
- • 52 towers and 51+ field visits catalogued
- • Real-time view of online/offline tower status
This is a proprietary internal platform. Company and client details are confidential and have been anonymised here. A guided walkthrough can be provided on request during interviews.
Power BI Portfolio
Portfolio of Projects in Power BI - Dashboards from various sectors created with the objective of bringing analysis and information in a simple and practical way for the monitoring of the company's main indicators.
Commercial Dashboard
Dashboard for the sales department developed for Contoso company. The dashboard uses SQL as a data source.
Key Indicators:
- •Sales revenue and YoY comparison (Year Over Year)
- •Quantity sold and YoY comparison
- •Cancelled/Returned sales
- •Number of customers
- •Sales by region
- •Sales analysis by customer category
- •Simulation of scenarios with price adjustments and monthly revenue/profit forecast
Logistics Dashboard
Dashboard focused on the logistics department. The dashboard uses Excel as a data source.
Key Indicators:
- •Current Month vs. Previous Month Freight Comparison
- •Current Month vs. Previous Month Number of Trips Comparison
- •Total Weight (ton) by Brand
- •Daily Costs by Brand
- •Fixed and Variable Costs by Year and Month
- •Total Cost per Kilometer, Year, Month, and Vehicle Type
- •Detailed Deliveries by Brand
- •Final Profit by Year and Month
Customer Service Dashboard
Dashboard for the user support department. The dashboard uses Excel as a data source.
Key Indicators:
- •Total number of support requests per year
- •Average by index
- •Comparison of Responded Calls vs. Open Calls
- •Distribution of received calls by problem and user
- •Average handling time
Human Resources Dashboard
Dashboard for the Human Resources department. The dashboard uses Excel as a data source.
Key Indicators:
- •Overall distribution of the employee roster
- •Yearly comparison of hires vs. separations
- •Turnover percentage
- •Overall distribution of hires by location, department, level, tenure, and age group
- •Overall distribution of separations by location, department, level, tenure, and age group
- •Employee distribution by gender
- •Detailed employee profile
Stock Dashboard
Dashboard for the stock Department. The dashboard uses SQL as a data source.
Key Indicators:
- •Distribution of items by location, product, and category
- •Distribution of total revenue results by month, year, store, and product
- •Detailed analysis by product