Olivia Cook Email and Phone Number

Promoted to Senior Customer Data Analyst responsible for:Coaching and Supporting new colleaguesDeveloped as Lead Data Curator, as part of the company's first Power BI ProjectConducted statistical analysis, using data visualisation techniques and presented findings back to senior managementCovering management during annual leaveConducting interviewsActing as an SME and support Project Manager using the Agile MethodologyDuring this role I have:Built two Power BI Models (Customer and Product) to transition from reactive to proactive reportingCreated reports in the Power BI service to monitor Key Performance IndicatorsUtilised M to parameterise datasetsCreated C# scripts to produce custom actions, alas increasing efficienciesUsed SQL Server Management Studio to partition fact tablesOptimised Power BI models by the use of Vertipaq Analyser, Tabular Editor & DAX StudioCreated measures using DAXTook advantage of Power Automate functions to refresh Power BI Datasets and DataflowsProduced a Data Dictionary to document Keys, Table Fields, Encoding Types and descriptionsBuilt a SharePoint site to host team informationCreated an induction plan to support new colleaguesDeveloped an analytical lifecycle as a clear robust process to complete analysisDesigned onboarding & offboarding checklists for colleagues and managersManufactured an Accept, Prioritise and Decline process to manage team workloadProvided resources, such as storytelling with data, data visualisation, metrics, Frequently Asked Questions and a feedback form for stakeholders on SharePointCreated learning paths and skills matrix by Microsoft user roles to help aid colleague development

Completed a 2-year graduate scheme which provided a wide-range of learning and development courses, including: Self-AwarenessPresentation SkillsMyers-BriggsChange LeadershipLeadershipPersonal Effectiveness and ResilienceEffective CommunicationPersonal DevelopmentEmotional IntelligenceCoaching for ResultsPersonal InfluenceStrategyI balanced the responsibilities of graduate scheme alongside the day to day tasks as a data analyst which involved:Meeting with stakeholders to help shape business hypothesesUsing SQL to source and manipulate large datasetsAnalysing large datasets and providing key customer insight by exploratory and explanatory analysisPresenting key findings, opportunities and recommendations to stakeholders using storytelling with data techniquesProviding weekly, monthly, quarterly and yearly updates to senior managersCreated & updated dynamic Power BI dashboards with business trendsCompleted basic, intermediate and Advance SQL TrainingParticipated in a Data Visualisation Course conducted by Andy Kirk

As an Accounts Payable Assistant I used Coda and Excel to:Verify vendor accounts by reconciling monthly statements and related transactions for UK and German vendorsMaintained account ledgers by verifying and posting account transactionsProcessed and paid supplier invoices within payment termsConducted weekly payment runs via HSBCReconciled outstanding queries on accountsUpdated and processed internal adjustments

Answered calls in a professional and timely mannerProvided excellent customer serviceProcessed customer orders, refunds and deliveriesLiaised with Trade Counter staff to complete customer brandingsWorked with colleagues across Head Office to provide customer resolutions

Volunteered a Special Constable contributing to community cohesion by:Protecting members of the public and their propertyPreventing, detecting and investigating crimeProviding initial response to incidentsSearching person(s), premises and vehiclesInterviewing suspects, victims and witnessesTaking statementsMaking enquiries into crimes and offencesGathering and using intelligenceMaking arrestsPreserving crime scenes and presenting evidence in court