Sarah Jane Brooks Email & Phone Number

Leyland, Gb

Leeds, Gb

Introducing data driven decision making into the business while embedding good data and analysis practices.

Guiding EvoDental through new ways of working with their data to provide insight and self serve dashboards. Spotlight plan: Make Our Data Work Harder

Extended maternity leave as a result of being made redundant

Chorley, Lancashire, Gb

• Unravelling and redesigning the existing legacy data warehouse to better understand the logics and pipelines• Documentation of current processes to ensure transparencies on business logic• Reviewed and confirmed all current business logic for data segmentation features along with documentation made publicly available. Also derived a challenge process for the business to follow if any changes were requested to the logic• Introduced team communication channels and workflow boards to allow clear view of team workload and progress• Created analysis to identify an annualised c.£700k EBITDA saving to the business based on process changes and customer reviews around small order charges• Worked with the data engineer to design new process flows for a cloud based Data Warehouse in Microsoft Azure complete with version control, pipelines and simplification of data processing• Devised logic using Python to create a unique customer identifier across multi account data• Reorganised reporting suite to aid access to reports by department and avoid duplication of report building• Setup reporting cadence with the ELT to provide regular insight and feedback for board meetings as well as collaborating with various departments around the business to ensure insight has context and suggested actions• Encouraged simplicity across the whole team. Simplicity on data creation, simplicity on analysis presentation, simplicity on report features. Simplicity allows for whole business access to complex work done by BI to aid adoption and business development• Regular contact with private equity company as the main communicator regarding data and analysis progress• Spearheaded the mission to make data and the team easily available to the business by being the “face of data” in report demos, analysis feedback, logic workshops, daily stand ups with department heads and general open communication for questions

Bournemouth, Dorset, Gb

- Design and build of a cloud based Data Lake eith transformation layer to create Data Warehouse structuring and a visualisation layer implemented to release back to the business.- Ingestion of thrid party data in order to enable detailed views on retention metrics such LTV:CAC and retention profiling.- Managed data science function through the creation of elements such as seller risk modelling and customer satisfaction metrics.- Rebuild of existing php reporting suite into Looker Data Studio in order to move responsibility from Dev to BI.- Implementation of the GA4 data layer and data collection- Devising RFM cuts on the existing database to better understand customer intent

Bournemouth, Dorset, Gb

Channel structuring and reporting frameworks to enable effective management of channels. Making reproducable self-serve reports to enable a single version of the truth.

Fulwood, Preston,, Gb

Heading up the Marketing Analytics function and developing a culture of data-driven analytics within the business while introducing predictive analytics and modelling into the marketing strategy decision making process.- Expansion of a data universe including two-directional flow data with third parties- Attribution Modelling- Propensity Based Lead Scoring (designed and implemented through Azure)- Omni-channel forecasting- Personas / Segmentation- Web Analytics- Campaign Analytics (direct response and attributed)- Introducing the voice of the customer- Market research through customer interaction and drop out points

Bolton, Gb

I worked on interesting projects across all areas of the business including:** Warehouse Efficiency - introduced racking profiling across the shelved warehousing to improve efficiency and productivity** Packaging Suggestion Engine - using dimensions of packaging and products, suggest the best packaging option for the small items to be delivered in** Product Recommendations - introduced a new candidate generation and ranking model to dynamically suggest products based on an original product and converted the current process from a 2.5hr nightly run to a 3 minute hourly run with an instant callable API** Price Elasticity - understanding the current market and seeing a shift in price elasticity to market elasticity** Employer Brand Data Scoring - introduced a scoring system for metrics collated about companies to better understand where AO fit in the regional market** Dynamic Delivery Pricing - investigation and modelling around the potential to alter delivery charges in line with current markets and customer trends** Propensity to Buy - building a model to predict % likelihood of purchase to monitor how far through the customer journey a person isAll of this was done using intelligence such as Random Forest modelling, Cosine Similarity matrixing and Multi-variant Adaptive Regression Splines whilst working in R & Python.

Bolton, Gb

As well as all the current Pricing Manager responsibilities, I took on the Trading Support team. This meant I now also took responsibility for promotions analysis (both tracking results and proposing new ideas), margin bridging, strategic project analysis and margin targeting.I used my technical skills to automate as many processes as possible to allow my team the time to use their analytical skills to influence the business on key margin and contribution increasing decisions.

Bolton, Gb

I took over as Pricing manager with a brand new team into Pricing to develop and become a "universal team". We covered competitor pricing research, minimum margins, AO.com pricing strategy, true cost calculation, contribution monitoring and support for negotiation to our Buying Team.I developed innovating ways of increasing margin and contribution, giving great customer prices, developing an intelligent strategy and constant monitoring of the whole pricing process from top to bottom. Alongside keeping all calculations business secure within IT by creating a business supported SQL model and reporting facility.

Bolton, Gb

Moved to stock department with company/team expansion. Responsible for ordering warehouse stock everyday, managing capacity level by correct ordering and liaison with warehouse managers, technical development of Microsoft Access stock model (changes to calculations, exclusions, seasonality), main aim is to maintain a high stock availability on c.4500 separate products advertised.Completed project to write complete new strategy calculations into a SQL database and develop a Microsoft Access front face for use within the team.

Bolton, Gb

I dealt with all aspects of creating reports on the pricing and stock elements of the business. On a daily basis I used models to optimise the prices of the goods and order the stock while maintaining a useful and available stock hold. I then split my time evenly between pricing and stock doing ad hoc analysis to aid the adaption of the models and development of the business in the marketplace.

London, England, Gb

I created contracts and invoices for all contract and permanent placements made. I then input the invoices onto Sage and maintain spreadsheets to keep a record of what placements have been made and by who for commission and head office purposes. In addition, I maintained the bookkeeping for petty cash and the credit card. This followed on to input the journals on Sage and reconcile against the bank accounts. This also involved using Bankline and FacFlow to upload money into the bank accounts.On a weekly basis I ran payroll for around 60 contractors (100 contractors monthly) by inputting all timesheets and expenses sheets onto the system, processing client invoices and self billed invoices (contractor payslips) then paying the contractors by BACS.

Harrogate, Yorkshire, Gb

My role basically included all aspects of administration regarding cataloguing CVs, invoices and job descriptions.Alongside this, it is my role to manage the email accounts and respond to applications and queries, manage the book-keeping of the company, do any aspect of researching other companies and candidates to aid recruitment.I was also required to do aspects of marketing for the business including direct marketing, SEO, managing and researching the public image of the company and writing adverts and proposals. I was also required to be a P.A. to the recruitment consultants and organise any travel arrangements and meetings they needee to attend.

Given CDs of interviews with foreign students discussing how they felt they were being treated at the university. Needed high confidentiality regarding the content of the interviews, touch typing at almost talking speed, understanding of many foreign accents and strict timekeeping to complete in my own time alongside university work.

Bmus (Hons), Music

Microsoft Professional Certification, Data Science

A Levels, Maths, Music, French & General Studies