4BI Solutions

Working as a consultant, led an engagement to diagnose, design and mobilise a new, agile operating model and enhanced data analytics capabilities, delivered through the Azure cloud services platform.

Led extensive value stream mapping to surface data use cases along with digital and business initiatives, with quantified hard benefits, along with a delivery roadmap and associated business case to deliver.

Created high-level data architecture and managed the delivery of client reporting through a data portal, using Power BI embedded.

Managed senior stakeholders to develop an agreed 2-year vision and target operating model including high-level business, technology and data architecture.

Business Transformation Consultant

Gobeyond Partners

Leading project teams and clients to diagnose, design and implement large-scale change across processes, people and technology.

Enabling culture change and operational transformation by coaching operational excellence tools and techniques to front-line managers up to heads of department.

Lean Transformation Consultant and Coach

First Central

Led data management implementation across all business functions, which enabled the delivery of new Power BI reporting and data science use cases.

Designed, developed and implemented a bespoke data management framework based on the DAMA industry standard.

Created a capability map, documenting the strategic design of new data management capabilities and baselined organisational maturity.

Designed and implemented forums, processes, policies, tools and metrics that delivered the data management operating model across the organisation.

Identified and co-ordinated a team of Data Stewards, who developed and applied standards for data modelling, data dictionary usage, and data cataloguing that resulted in the accelerated delivery of value-added data products.

Data Management Lead

HSBC

Led an extensive operating model review of the bank’s retail complaints function.

Identified opportunities to improve complaints processes and operating model resulting in FTE savings, and reduced compensation expenditure.

Designed target operating model and led initial changes across a ~300 FTE business.

Business Transformation Lead

AXA UK

Led a project team in the diagnosis and design of a new target operating model for a motor claims operation.

Used value stream mapping and efficiency analysis to baseline performance and identify opportunities for improvement.

Coached the project team and the business in Lean ways of working, which resulted in a significant reduction of work-in-progress, customer delays and increased levels of operation efficiency.

Lean Transformation Consultant

Unipart Group

Using Six Sigma and Lean within a project management framework to lead change which results in tangible business benefits for Public Sector and Financial Services clients.

In particular providing subject matter expertise and guidance in the excecution of "Voice Of Customer" approaches (Quality Function Deployment) to develop customer driven high level KPIs.

Also, using Value Stream Mapping to understand the current state of highly complex financial service processes, identify opportunities and design future state concepts and principles into client processes.

Lean Consultant

Royal Bank of Scotland

Lead and deliver large scale Lean Sigma projects on complex processes with multiple dependencies, focused on improving Customer Satisfaction and Business Efficiency.

Manage stakeholder relationships and a team of project managers to deliver the wider project objectives.

Process Improvement Manager

Jaguar Land Rover

Led production assembly line team to achieve challenging production targets in Safety, Quality, Delivery and Cost.

Used lean tools and techniques on a day-to-day basis in a world class lean facility, recognised as being amongst the most productive car plants in Europe.

Production Manager

Identified and undertook various Six Sigma projects focused on driving down warranty costs through the analysis of root causes and reduction of manufacturing variability.

Predominantly focused on the Chassis and Trim engineering disciplines, the projects focused on using the DMAIC methodology and managing stakeholders from multiple disciplines to resolve issues and drive down warranty cost.

Six Sigma Black Belt

I am an experienced leader in all aspects of Business Transformation, with a strong ability to engage stakeholders and align the organisation behind a compelling vision and case for change.

My typical engagements are target operating model focused, and over the years have been able to develop an approach that drives change across business, technology and data architectures. Through it, I am able to quickly find opportunities that can amount to tens of millions in benefits through increased operational efficiency, while improving customer experience.

My approach comes with a well-developed framework and a variety of pre-made workshop materials that can accelerate delivery and bring alignment when complexity levels are high.

I use a Lean-Agile approach, with an emphasis on developing business agility, that brings together business, technology and data analytics teams, enabling them to deliver more value, earlier and more often.

Phil Mottram

Future Analytics

Principal Consultant

Harrods

- Joined the project during critical final stages to address challenges and ensure successful delivery within tight timelines.
- Implemented Power BI best practices, separating the semantic layer from reporting, and streamlined deployments using Azure DevOps branching across Dev, QA, and prod environments.
- Developed fiscal week time intelligence at scale using Tabular Editor C# scripts.
- Rebuilt the solution in Microsoft Fabric, leveraging Lakehouse architecture, dbt, and advanced SQL/Python to create a dimensional model consolidating e-commerce order data, including order header, items, tenders, and discounts, into a single fact table for seamless analyst querying and adhering to kimball modelling standards.
- Integrated data from SAPBW4, GA4 and budget data into the model to provide a holistic view of performance metrics.
- Implemented dbt macros for faster development and re-usable code
- Optimized semantic model performance, achieving sub-second query speeds.
- Provided tailored training to analysts and end-users on the solution.
- Authored comprehensive data dictionary and documentation using dbt and Azure DevOps.

Fabric Analytics Engineer | Power BI Consultant

Toptal

- Migrated Legacy SSAS Tabular and  Modelling for Large Real Estate Company
- Delivered end to end Microsoft Fabric Projects for Australia's 2nd largest Fresh Produce company

Data Engineer

Redkite

- Led the power bi delivery of an enterprise eCommerce performance dashboard, including  requirements gathering, stakeholder management, data mart design, and visualization.
- Delivered a complex UI that involved multiple bookmarks and a sleek UI design.
- Implemented Power BI DevOps process to move reports from dev, QA, and Prod. 
- Also implemented C# scripts to standardize DAX creation and tabular model cleanup.

Senior BI Engineer

Walgreens Boots Alliance

•	Working on a large-scale MI Simplification project spanning of 500 Metrics and KPI’s for Boots UK management information  
•	Leading requirements gathering process 
•	Working with Azure Synapse and Azure Analysis Services to develop data models 
•	Using C# scripts in tabular editor to scale 100’s of DAX measures and deployment of data model changes to AAS models
•	Building Power BI Dashboards (DAX, SQL) 
•	Training and coaching Delivery team in Power BI desktop and deployment
•	Migrating Data engineering and delivery team to an Agile framework using Azure Boards to manage project 
o	Leading Backlog grooming, Sprint Planning/Reviews/Retro’s/Daily Stand ups
•	Migrating to using Azure DevOps for Repo management/ implementing code reviews
•	Implementing PowerShell scripts to automate upload of data extracts to our self serve data lynx environment and facilitate ETL scripts.

Data Engineer - Management Information

TruRating

- Working in an agile team (attending, stand ups, backlog grooming, sprint planning etc) 
   - Using JIRA to manage tickets and workload
- Creating end to end Data Pipelines using Azure Data factory (Using Linked services, Loops, calling API's , function apps, migrating data factories through environments using git)
- Using Azure Dev Ops to migrate changes to different environments
- Using python (and jupyter notebooks) to automate tasks involving populating databases etc.
- Using  github for a variety of repositories including SQL Server, function apps, data factory
- Using Power BI to develop dashboards and drive internal reporting metrics

AA Consultancy (London) Ltd

•	Ongoing contract managing a team of off-shore reporting analysts for FTSE 100 company
•	Freelance Power BI projects
•	Projects and training for a wide variety of SME's

Director, Power BI Solutions

General Assembly

The data science immersive is a three month full time bootcamp covering the following modules
Python fundamentals - numpy, pandas
Data Visualisation -  Matplotlib, SeaBorn, Plotly
Data Engineering - Web scraping, API’s, SQL , AWS, Spark, Big Data Tools
Machine Learning - Linear Regression, Classification. Bayesian modeeling, Naive bayes, pymc3, sentiment analysis, unsupervised learning, clustering algorithms, principal component analysis, network data, recommendation systems, neural nets

Data Science Immersive Student

Hexcel Corporation

•	Contract with NYSE 100 listed manufacturing company developing Power BI Models and Dashboards for multiple departments, also acting as the key point of contact for all BI Projects
•	The departments included Financial Planning, Supply Chain and Customer Service
•	Key achievements: Automating General Ledger Reporting into Power BI dashboards using PowerBI/DAX from a legacy spreadsheet and multi dimensional cube solution
•	Migrating 8 SSAS MDM cubes to Power BI Tabular Models
•	Including roll out of excel templates based of Power BI datasets
•	Implementing complex DAX row level security
•	Dynamic row level security
•	Hierarchal row level security
•	Multi table row level security
•	Ad hoc projects were also given as part of the backlog of projects outside my departments also
•	Power Apps development for General Ledger Commenting System which was integrated with the Power BI Dashboard
•	Acting as point of contact for any Power Users who needed Power BI advice and support
•	Migrating Power BI reports to premium work spaces to include incremental loads/refreshes
•	Creating Complex DAX formulas to replicate complex scenarios in advanced excel workbooks

Power BI Developer

Aqovia

Lead Power BI architect for enterprise BI solution
Research and development for machine learning applications for anomaly detection for the telco industry
Research into solution architecture for big data processing for real time analytics and machine learning solution

Enterprise Intelligence Analyst

Alexander is a seasoned bridge between IT teams and business stakeholders, adept at
translating intricate technical concepts into digestible terms. As a certified Microsoft
Fabric engineer, he specializes in solution-oriented approaches, ensuring organizations
navigate digital complexities and harness data analytics to drive transformation.
Committed to delivering unparalleled quality, he consistently places the needs of
business stakeholders at the forefront.

taplio

The Battle

Phil Mottram

Alexander Amlani

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?