Alfie Lancaster Logo

Hi, I’m Alfie

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

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