Interactive Project Portfolio
Click on each project title to reveal details about challenges, solutions, technologies, results, and key learnings.
Role: Product Architect & Operations Builder
Timeline: Active development and station-tailoring rollout
Impact: Faster daily planning, clearer workload visibility, and stronger shift-level resource control
Challenge: Line maintenance teams need one practical board that can adapt to different station roster formats while preserving real-time operational awareness.
Solution: Andrew designed a low-code, easy-to-tailor live operations dashboard that ingests daily roster CSV files, interprets roster structure for assignment support, and overlays weather and live feed context for execution decisions.
Capabilities: Daily Roster CSV upload, interpretative assignment logic, editable assignment columns, column-level reset controls, operational heat-map insight, and manager-focused Gantt planning for peak-time visibility.
Enrichment Layers: Multi-source enrichment architecture with fallback behavior (API + cache + manual overrides), aircraft type normalization support (DOC8643), and resilient status handling for live operations.
Use Cases: Daily station planning, certifier/mechanic load balancing, shift handover clarity, peak-time staffing insight, and on-the-go engineer visibility via live dashboard access.
Live Dashboard: Open live app
Project PDF: View case study (with screenshots)
Key Learnings: Practical adoption comes from speed, clarity, and flexibility. A lightweight web app can deliver high operational value without enterprise software overhead.
Role: Global Transformation Lead
Timeline: 6 months
Impact: 30% revenue increase
Challenge: British Airways required a unified digital maintenance solution across its global network to improve efficiency, transparency, and revenue management.
Solution: Andrew led the rollout of an MRO ERP across all stations, designing comprehensive training for over 500 staff, coordinating with IT, engineering, and operations, and implementing a robust change management framework.
Technologies: MRO-PRO, Power BI, SharePoint, Power Automate
Results: 300+ users onboarded, 30% revenue increase, >90% adoption after 6 months.
Key Learnings: Global rollouts require meticulous planning, stakeholder alignment, and continuous feedback loops. Structured training and clear benefit communication drive adoption and sustained usage.
Role: Architect & Developer
Timeline: 9 months
Impact: $150K+ cost savings, reduced AOG risk, improved stock accuracy
Challenge: Inefficient inventory management processes increased Aircraft on Ground (AOG) risk and incurred unnecessary costs.
Solution: Andrew single‑handedly designed and built a custom Power Apps solution integrated with SharePoint and Power Automate. The system provides real‑time inventory visibility, automated replenishment alerts, compliance tracking, and a tamper‑proof audit trail via blockchain integration.
Technologies: Power Apps, SharePoint, Power Automate, Blockchain integration
Results: $150K+ cost savings, 5 airlines and 200+ users, reduced AOG risk.
Case Study PDF: View Stores Keeper case study
Key Learnings: Custom solutions tailored to operational needs can unlock significant savings. Blockchain provides immutable records that enhance compliance and trust.
Role: Founder & Product Architect
Timeline: Ongoing startup initiative
Impact: Faster troubleshooting access and decision support for line maintenance teams
Challenge: Engineers need rapid, context-aware technical guidance during line operations while navigating fragmented manuals, procedures, and fault references.
Solution: Andrew is developing LineOps AI as an operations support assistant focused on troubleshooting workflows and aircraft manual guidance. The concept combines structured maintenance knowledge with practical frontline UX to reduce lookup friction and improve response speed.
Technologies: AI-assisted search, workflow design, digital maintenance knowledge structuring, web/mobile delivery concepts
Results: Startup concept in active development with pitch deck, evolving use cases, and phased rollout planning.
Key Learnings: In high-tempo maintenance environments, value comes from trustworthy answers, clear traceability, and seamless fit into existing operational workflows.
Role: Process Automation Lead
Timeline: 4 months
Impact: 500% reduction in processing time
Challenge: Paper‑based ID processes were slow, error‑prone, and difficult to audit.
Solution: Andrew digitized the BA ID process using Power Automate and SharePoint, creating a paperless workflow with automated approvals, compliance documentation, and transparent tracking.
Technologies: Power Automate, SharePoint
Results: 500% efficiency gain, 1,500+ users on the new system.
Key Learnings: Even simple processes can yield outsized gains when automated thoughtfully. Clear governance and user training are critical for adoption.
Role: Data & Analytics Lead
Timeline: Ongoing
Impact: Real‑time decision support for senior leadership
Challenge: Operational and financial performance data were siloed and difficult to interpret quickly.
Solution: Andrew developed a suite of Power BI dashboards tracking cost per turn, revenue by contract, safety metrics, and predictive analytics. These dashboards provide executives and managers with near‑real‑time insights and trend analysis.
Technologies: Power BI, Excel, Data modeling
Results: Increased transparency, faster decision making, predictive trend identification.
Key Learnings: Data visualization and predictive analytics empower teams to anticipate issues and capitalize on opportunities. Clean data pipelines are essential for trustworthy insights.
Role: Workflow Architect
Timeline: 6 months
Impact: Protected $3.5M annual revenue
Challenge: Manual billing and work‑order processes risked revenue leakage and disputes.
Solution: Andrew designed automated workflows using Power Automate integrated with SAP and other maintenance systems. These workflows standardize billing, automate approvals, and ensure accurate transaction tracking.
Technologies: Power Automate, SAP integration, SharePoint
Results: Safeguarded $3.5M revenue, reduced billing disputes and processing time.
Key Learnings: Automation protects revenue streams and frees up staff for higher‑value work. Integration with existing systems is vital for seamless adoption.
Role: Tooling Compliance Lead
Timeline: Ongoing
Impact: Strengthened compliance, reduced losses, enhanced operational safety
Challenge: Tooling management across a busy line station faced loss, misuse, and compliance risks.
Solution: Andrew implemented a digital tooling control system using Power Apps and SharePoint, introducing automated alerts, loss prevention, and compliance tracking.
Technologies: Power Apps, SharePoint, Workflow automation
Results: Enhanced regulatory compliance and safety, reduced tool losses and associated costs.
Key Learnings: Clear tooling controls are essential for safety and efficiency. Digital records create accountability and enable continuous improvement.
Role: Commercial Optimization Lead
Timeline: Ongoing
Impact: Protected $3.5M annual third‑party revenue
Challenge: Fragmented billing processes and inconsistent work‑order management threatened revenue streams.
Solution: Andrew standardized billing processes and automated work‑order creation, integrating with SAP and Power Automate. He developed financial dashboards to track contract performance and revenue trends.
Technologies: SAP, Power Automate, Power BI
Results: Protected annual revenue through accurate billing, reduced disputes, enabled proactive contract performance management.
Key Learnings: Combining automation with transparent financial reporting safeguards revenue and builds client trust.