Kelly Hughes Email & Phone Number

United Kingdom

- Process mapped and communicated the end-to-end production of an extremely complex inherited Forecasting Model and subsequent analysis.- Recruited and built an analysis team, responsible for 1:1’s, goals, personal development, and on-going coaching.- Built strong relationships across all functions up to exec level, to create a collaborate and cohesive approach to the analysis as a Society.- Delivered analysis and built packs to present to key stakeholders and members at various exec committees on performance against plan.- Built a target forecasting model to track activity against what was required to hit the lending target. Designed an interactive scenario calculator to test the impact of the various levers.

- Built and maintain excel based book keeping system enabling easy preparation of annual accounts- Manage dividend payments for shareholders and ongoing liaison with company accountant- Calculate and complete quarterly VAT return and annual Corporation Tax bills- Built and maintain company website- Ongoing management of bespoke training content across a broad portfolio of clients- Manage cash flow, banking logistics, invoicing and cash collection- Manage pension investment portfolio and ongoing management of business SIPP across a range of funds

Wakefield, United Kingdom

- Experienced business & MI analyst with 20+ years’ working with data across a variety of sectors; global corporations, education, charities, financial services, food manufacturing & supply chain. - Ability to set up & manage data infrastructure & reporting ‘from scratch’ using source data from multiple systems. - Track record of delivering strong ROI & significant incremental income through value adding analysis & solution.- Advanced technical skills in Excel, Access, experienced in SAS, SQL & VB. Trained in Power BI and Tableau.- Strong requirements definition, stakeholder and facilitation skills.

Stapleton

- Senior Business Analyst – creation of a reporting function ‘from scratch’, consolidating multiple sources, automating outputs, creating a user friendly front end in addition to ad hoc analysis and client engagement and recommendations.- Built various Access databases to house large volumes of data from 10+ different sources, used Access Macros & Queries to manipulate & format the data- Created a suite of standardised reports in addition enabling a quick turnaround of ad hoc queries- Provision of ongoing adhoc analysis, reporting and recommendations which successfully drove significant, quantifiable improvements in sales, wastage, weight and cash margin- Using VB designed a log in screen for a multi user report so that various people could only access certain parts of the sheet, with record keeping to monitor who has logged in and when- Built a database to house store level data, to facilitate detailed comparative analysis

Morely, Leeds

- Senior Business Analyst in Marketing analytics team using SAS, SQL, VB, Excel, Access including Macros to drive automation. In addition to provision of standardised reporting; - Designed an excel based central, interactive Reporting Portal for end-users to access all reports via their desktop, a significant time saving for both report users and MI team- Drove productivity improvements by managing offshoring of low complexity analysis, including operational definitions, user guides etc. - Delivered analysis automation to facilitate further efficiency gains, and reduced functional expenditure by ‘in-housing’ and managing a key database, improving access to and therefore enhancing delivery timelines on the data stored within- Drove improvement in team SLA from 60% to 88% (despite 66% volume increase) through creating & driving team KPI’s to measure SLA drivers, tied into Issue log establishing and structured capture of potential improvement drivers- Reduced time taken for some selections to be run from 3wks to 1wk via planning and facilitating end to end value stream mapping session, improved accuracy and timeliness- Line management expertise - goals setting, performance development, appraisal process

Canal Road, Leeds

- Delivered a high standard of both ad hoc & regular reporting for a wide range of internal customers from CEO & Group Directors to functional employees, utilising multiple databases covering 20+ countries, as well as external data from sister companies- Automated & improved further using SQL within Sequel Server 7, which alongside advanced Excel made the reporting easy to generate & extremely user friendly for the internal customer- Designed & globally rolled out a customer profitability model, determining the variable cost profit by segment by country. Allowed a country to segment their customers & view behaviours/interactions to identify opportunities. Extremely successful - Regional Directors were targeted by the CEO to use it to enhance margin- Led the creation & development of a highly effective, Excel based, CRM tool to provide a non-technical audience with an interactive analysis tool to support the growth of their customer base. Provided incredibly detailed information on their customers buying trends & highlighted sales opportunities & potential lapsers. Initial UK focus but rolled out globally- Generated in excess of £500k extra revenue as well as improved the lifecycle of these customers through designing reports using SQL in Sequel Server 7 to identify schedules coming to an end, enabling targeted campaigns plus performance MI- Designed & conducted a 2-day in-house Alterian training course, designed for colleagues globally ranging from Directors to IS support

Leeds, United Kingdom