Learn Data Skills
Beta
Stephen Lilley

Stephen Lilley

Head of Strategic Planning & Reporting

University College Birmingham

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Course

Introduction to SQL

Data painter, using visualization to bring insights to life.

My Work

Take a look at my latest work.

course

Understanding Data Science

course

Introduction to SQL

course

Understanding ChatGPT

course

Understanding Data Science

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Tableau Tableau Certified Data Analyst

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding ChatGPT
Introduction to Power BI

My Work Experience

Where I've interned and worked during my career.

University College Birmingham | Sep 2023 - Present

Head of Strategic Planning & Reporting

N/A

National Express LTD | Jun 2021 - Sep 2023

Operations Intelligence Analyst

- To provide operational trends and insights to senior leadership to assist with their key decision making surrounding areas including punctuality, lost mileage, and health & safety. - To utilise the full Tableau suite, including Desktop and Prep, to automate and analyse key reporting, such as weekly operational KPIs, and the identification of collision hotspots. - To identify stakeholder requirements through the exploration of existing systems and processes, whilst recommending improvements where appropriate. - To introduce and develop creative and innovative ways to improve how metrics are assessed and monitored. - To act as a general analytical consultant, providing expert advice and guidance to senior management of the Operations department and areas of the National Express
Show More

Birmingham City University | Aug 2018 - Jun 2021

Market Research Analyst

N/A

Birmingham City University | Jan 2017 - Jul 2018

Business Intelligence Data Analyst

o Research, analyse and present information relating to all aspects of the student life--cycle, from admissions through to attainment. o Co-ordinate the preparation and analysis of University plans, monitoring plans and targets to help ensure they are consistent with and contribute to University strategy. o Developed modelling and forecasting techniques to identify the performance and financial impact of the recruitment cycle, the implementation of which has allowed for timely mitigation where appropriate. o Undertaken research projects to identify key issues for improvement, such as the attainment gap from BME students. o Support the University’s evolving development of high-quality strategic and operational analytics as part of a corporate Business Intelligence solution.

Birmingham City University | Mar 2016 - Dec 2016

Statistics Officer - International

Whilst my role initially started as a Statistics Officer responsible for International matters, the role later evolved to include the Home market as well. For all intents, duties were near identical to those outlined in the Business Intelligence Data Analyst section.

One Stop Stores Ltd | Mar 2015 - Dec 2015

Supply Chain Analyst (10 Month Maternity Cover)

• Initially responsible for the trading of Eggs, Cake and all chilled ambient lines, via effective analysis of store performance and sales trends. • Delivered consistently high sales of the cake category, with performance 4% above budget. • Reduced stock holding on Eggs on average by 25%, whilst maintaining and exceeding targeted levels of availability. • Eventually held responsibility for all chilled promotional & seasonal activity, refining the implementation, maintenance and review of monthly packages. • Improved supplier relationships through the development of clearer, more detailed, promotional forecasting.

BHS | Aug 2014 - Jan 2015

Assistant Merchandiser

Use market and customer information together with historical data and forward trends to assist in the development of the department’s phased plans. Work towards development of financial/profitable framework for cushions and throws range. Analyse weekly trading performance to identify trends against plans making recommendations to Merchandiser Monitor the intake of stock in order to achieve planned stock levels, sales/ terminal stock targets and make proposals for markdown activity. Monitor the availability of stock by ensuring planned launch and replenishment dates are met and sales and stock are potentialised through production planning. Build and maintain effective relationships with suppliers ensuring any issues are communicated to the Merchandiser.

Midcounties Co-operative | Aug 2013 - Aug 2014

Core Availabilty Analyst

estate of stores as a whole, making key recommendations to drive sales and improve wastage within each of these areas. Conduct analysis of sales events, making observations and recommendations to ensure continuous business improvement. Initiated and implemented the creation of seasonal profiles to statistically cluster stores by both sales pattern i.e. tourist and student, and by product sub-category – circa 1.08 million combinations - to more accurately influence product order demanding. Addressed issue of stores’ non-compliance regarding gap scanning and accuracy to range activity, assisting to resolve & empathise with colleagues’ issues, which resulted in a respective 85% & 74% increase over a 6 month period. Provide store support in resolving product queries, liaising with retail administration teams and product buyers.

Sainsburys Supermarkets Ltd | Dec 2010 - Aug 2013

Assistant Merchandiser

Provided an effective and efficient merchandising administrative service and support to the Merchandising team. Responsible for forecasting and updating in-house weekly stock & sales intake (WSSI). Produced reports for the monitoring, review or evaluation of departmental performance for the Merchandiser and Merchandise Planner across key performance indicators and other merchandising measures. Addressed ongoing issue of promotional stock wastage by conceptualising theory into a systematic promotional allocation and maintenance tool.

Sainsbury's | Oct 2012 - Apr 2013

Range Planner (7 Month Maternity Cover)

Created optimal range plans via JDA, adhering to dressing rules and merchandising principles, to deliver both customer choice and financial performance for the ESL department. Responsible for the assignment of products to space within defined macro space parameters. Accountable for the set-up of promotional cycles and large scale events, working with both trading and business planning teams to compose data into comprehensible implementation packs for store colleagues to utilise. To compile and analyse various ranging data, enabling optimal range selection and increased trading intensity.

Kroll | May 2010 - Aug 2010

Background Screening Analyst

Duties: To carry out employee screening for large blue-chip companies within the financial sector. To generate concise and detailed reports within strict deadlines. To verifying details provided by candidates, conduct searches such as credit checks, directorship searches and FSA prohibited persons checks. To investigate gaps in the candidate's activity and investigate any discrepancies or adverse findings that arise. To maintain productive & beneficial relationships with both candidates and external company departments.

Brighton & Hove City Council | Sep 2007 - Oct 2009

Team Administrator

Duties: Provided a customer-focused information and reception service to people who contacted the team - either by phone or in-person. Administered the imprest account, handled petty cash, reconciled income, and dealt with service user's money. Accountable for a stationery budget of £900. Initiated & executed a project to reduce provisions expenditure, helping to cut food spending by approximately 20% in a year. Introduced the in-house procedures used to monitor Craven Vale's daily expense budgets, procedures now utilised in multiple council run care homes.

My Education

Take a look at my formal education

BA (Hons), English Language and Media StudiesUniversity of Brighton | 2007
Luton 6th Form College | 2003

About Me

Stephen Lilley

Stephen hasn't filled in a bio text

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free