Andrew Ibsen | Projects

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 MRO-PRO 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.

Key Learnings: Custom solutions tailored to operational needs can unlock significant savings. Blockchain provides immutable records that enhance compliance and trust.

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.