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

Alexander Amlani's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Alexander Amlani's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Alexander Amlani's Linkedin Analytics