Luke Main Email & Phone Number

Newbury, GB

Newbury, England, United Kingdom

• Delivering automated reporting, analysis, dashboards and data development to a wide range of industries using a variety of technologies.
• Led the delivery of a reporting data model, turning raw data into useable data assets.
• Designed and built a suite of corresponding Tableau dashboards enabling business users to autonomously access reliable insights.
• Provided CEO, SLT and wider business with high-level trends of KPIs via auto-distributed daily reports, acting as a central focal point of business performance.
• Established a structure for data governance with all reporting displaying consistent metadata linked to documentation of definitions and business logic for full transparency.
• Increased user engagement by implementing consistent templates, advising on best practice, publishing tutorial videos and setting standards for dashboard design.

Newbury, England, United Kingdom

• Ensured avoidance of potential costly fines by improving reliability of external reporting.
• Saved resource time by creating automated processes with programatical checks and alerting.

Newbury, England, United Kingdom

• Provided a client’s first ever automated reporting at group level, loading data from multiple sources, improving access and speed to data, allowing for a cohesive approach to trading.
• Overhauled KPI definitions to ensure business logic is applied accurately, giving users higher confidence in a single trusted source of information.
• Streamlined a loading framework to minimise effort required to onboard business divisions.
• Minimised data quality issues and non-adherence to processes by creating exception reports.
• Transformed raw TV viewing data into an exploitable dataset by applying sessionisation logic.
• Enabled actionable insights by producing next day reporting of key viewership metrics, removing the need to rely on costly resources from third parties.

Hook, England, United Kingdom

• Built and evolved a collection of applications serving over 100 internal customers highlighting trends in customer base metrics with guided navigation through to detailed profiling tools.
• Created a cohort tracker app to analyse customer behaviour over time and likelihood to churn.
• Investigated the potential monetary value associated with the raw viewing data.

Hook, England, United Kingdom

• Responsible for all sales reporting in the business division
• Improved and automated existing processes with macros in Excel and Access
• Transferred these processes into SQL Server using stored procedures to provide a central data source to ensure all reporting was consistent and easier to respond to new requirements

Bracknell, England, United Kingdom

• Creating weekly and monthly reporting packs to each rental station
• Ad-hoc analysis to identify opportunities to increase revenue or enhance customer service

Dorking, England, United Kingdom

• Software testing of modelling and optimisation tool tailored to the water industry
• Level of Repair Analysis of clients’ asset inventory