Alfie Lancaster Logo
Alfie Lancaster Logo

Hi, I’m Alfie

Optimising business intelligence through precision data modeling and end-to-end process automation.

View my projects →Download CV ↓
RPASharePoint ArchitecturePower AutomateRelational ModellingETLPythonProcess AutomationAdvanced DAXData StrategyBusiness Logic

Featured Projects

Relational Star Schema data model diagram for Power BI

SharePoint to Power BI Reporting Architecture

Redesigned fragmented Excel reporting into a centralised SharePoint data layer. Built a relational Star Schema and DAX measures to automate "Working-Day" KPIs, providing live operational visibility across the county.

Power BIDAXSharePoint ArchitectureData ModellingETL
Power Automate Desktop logic flow for retry mechanisms

Resilient RPA – High-Volume Data Automation

Engineered a Power Automate Desktop solution to process 22,000+ records. Implemented advanced 3-attempt retry logic and automated Excel audit write-backs to ensure 100% traceability and zero data loss during high-volume migration.

RPAPower AutomateError HandlingProcess MappingExcel Automation
Python Pandas code snippet next to generated document icons

Python Automation – Dynamic Batch Letter Generation

Developed a Python tool to eliminate a 4-hour manual mail-merge process. Uses Pandas to group system exports by Entity and dynamically generate individual letters with embedded client data tables in seconds.

PythonPandasAutomationDocument GenerationBusiness Logic