Lee Barrett

Lee Barrett Email and Phone Number

Control Room Operator (Vodafone Automotive) at Mitie Security @ Mitie Security
northampton, northamptonshire, united kingdom
Lee Barrett's Location
Craigavon, Northern Ireland, United Kingdom, United Kingdom
About Lee Barrett

Lee Barrett has often been described as an 'Excel Wizard' because not only does he seem natural with vlookups and pivot tables, but if a function does not exist, he'll write one.It's not just the numbers; he's very creative because his Workbooks and templates are like pieces of art - something you want to work with.Attention to detail, making things look good - but practical and thinking of ways to solve problems via simplification and automation make him an effective practitioner of Excel.His data analysis background allowed him to gain experience collaborating in teams and with individuals to get results.So what can he do?- Advanced Excel ability (including VBA Macros).- Automate, extract, clean, and transform data.- Design and publish Google Datastudio dashboards.- Simplify complex Excel workbooks.- Design attractive but functional Excel templates.What can Lee do for you?How about a no-obligation chat?

Lee Barrett's Current Company Details
Mitie Security

Mitie Security

View
Control Room Operator (Vodafone Automotive) at Mitie Security
northampton, northamptonshire, united kingdom
Employees:
160
Lee Barrett Work Experience Details
  • Mitie Security
    Control Room Operator (Vodafone Automotive)
    Mitie Security Apr 2023 - Present
    Craigavon, Northern Ireland, United Kingdom
    Managing alerts coming from high value vehicles and communicating them to owners through inbound and outbound calls. Incident reporting, real time monitoring, collaborating with team in a fast paced environment.
  • Lee Barrett Trading Limited
    Managing Director
    Lee Barrett Trading Limited Feb 2019 - Present
    London, United Kingdom
    Data extraction, transformation, visualisation (dashboards).
  • Lee Barrett Trading Limited
    Skills Showcase : Microsoft Excel
    Lee Barrett Trading Limited Jun 2002 - Present
    London, England, United Kingdom
    I am an advanced Microsoft Excel practitioner who recognises the pain people have with data and spreadsheets. Allow me to relieve you of that pain. I can:✅Simplify workbook complexity✅Develop eye-pleasing, interactive templates and dashboard-style excel workbooks, and if Excel is not your preferred Dashboard-medium then I can develop a Google Data Studio dashboard for you instead✅Program/Debug/Enhance VBA scripts (Macros)✅Create Pivot Tables (and automate them)✅Connect Excel to external data sources✅Utilise Power Query - an Excel feature that performs 'Extract', 'Transform', 'Clean' and 'Presentation' functions on your data without future repetition saving you a lot of time✅Utilise or quickly discover/learn any of the built-in functions needed to solve a particular problem - leveraging Excel's power✅Migrate data between systems or between Excel or Google sheets.
  • Promethean Tv
    Data Analyst
    Promethean Tv Mar 2019 - Oct 2019
    • I developed a bespoke reporting system involving the acquisition, cleaning, transformation and loading of data from multiple sources resulting in a clean and unified dataset. Significant time-savings achieved.• Built and published an online Dashboard connecting the bespoke reporting system. This enabled rapid, up-to-date performance updates across several metrics.
  • Bbc Worldwide
    Business Intelligence Executive
    Bbc Worldwide Oct 2007 - Dec 2014
    London, United Kingdom
    I was responsible for servicing the regular and ad-hoc reporting needs of a global sales team. A typical day would involve:- maintaining a fresh and clean dataset- querying the data- designing excel-based reports and templates- producing visuals (tables and charts)- writing commentary- developing custom formulas or VBA scripts- enhancing existing VBA tools- updating powerpoint presentations- performing competitor spend analysis- analysing internal data for insightsAchievements:- Developed a VBA-powered data cleaning & transformation tool- Developed a VBA-powered 'revenue-probe' tool enabling sales team to deep-dive into their metrics - Data freshness improved from one day to 30mins.- Regular reporting rhythm established.- Highly responsive to ad-hoc requirements.- Sales teams have an immediate response to their queries- Greater visibility of our metrics and dimensions
  • Christian Aid
    Database Services Contractor
    Christian Aid Jun 2007 - Oct 2007
    London, United Kingdom
    Assist the Database services manager with the import of 1/4 million order lines, relating to 45,000 charitable supporters into a major CRM Database (Ascent) allowing approach and realisation of the value of these additional supporters.Specific activities : Creating test plans, Data analysis, data cleansing, data manipulation, reporting and creating import quality files.
  • Allianz Global Assistance Uk
    Motor Sales Support And Analayst
    Allianz Global Assistance Uk Aug 2005 - Mar 2007
    Croydon, United Kingdom
    Analysis of operational, financial and technical data relating to automotive assistances we provide on behalf of our prestigious vehicle manufacturers and dealers. Timely and meaningful statistics were routinely compiled and communicated to management level.
  • 21St Century Technology
    Vodafone Account Handler
    21St Century Technology Jul 2004 - Sep 2004
    Croydon, United Kingdom
    This is a call centre role involving the organisation of car kit (in-car mobile phone) installations for Vodafone customers.
  • Vodafone Uk
    Business Agent
    Vodafone Uk Jun 2002 - Jul 2004
    Croydon, United Kingdom
    This is a call-center role involving inbound/outbound calls focusing on business customers. The nature of all calls could be campaign, complaint, price-plan or mobile phone related. Great emphasis was placed on customer care and efficient call-handling.Achievements:- Promotion awarded- Created a VBA-powered database system capable of querying every price-plan and mobile phone available then filter that database based on customer-supplied criteria all through a VBA User Interface (UI).- Developed a VBA-powered note-templating system which allows consistent (and rapid) notes to be added to all accounts.- Faster, efficient selection of price-plans.- Improved personal call metrics i.e. Lower “on hold” and “waiting” statuses and Higher inbound/outbound call volumes.
  • Sainsbury'S
    Store Assistant
    Sainsbury'S Oct 1991 - May 2002
    Croydon, United Kingdom
    10 years of customer services experience

Lee Barrett Skills

Vba Data Access Objects Access Sql Microsoft Excel Microsoft Office Powerpoint Microsoft Word Ms Access Database Tableau Reporting Alteryx Dart For Publishers Dart Sales Manager Social Media Learn New Software Quickly Analysis Databases Data Analysis Business Intelligence Problem Solving Integration Reporting And Analysis Landmark Testing Data Warehousing Systems Analysis Business Requirements Trading Systems Trading Trading Strategies Stock Trading

Lee Barrett Education Details

  • Selhurst Tertiary College
    Selhurst Tertiary College
    Merit
  • Selhurst Tertiary College
    Selhurst Tertiary College
    Merit

Frequently Asked Questions about Lee Barrett

What company does Lee Barrett work for?

Lee Barrett works for Mitie Security

What is Lee Barrett's role at the current company?

Lee Barrett's current role is Control Room Operator (Vodafone Automotive) at Mitie Security.

What schools did Lee Barrett attend?

Lee Barrett attended Selhurst Tertiary College, Selhurst Tertiary College.

What are some of Lee Barrett's interests?

Lee Barrett has interest in Social Services, Computer Programming, Excel Projects, Children, Improving My Financial Literacy, Dashboard, Politics, Web Technologies, Education, Analytics.

What skills is Lee Barrett known for?

Lee Barrett has skills like Vba, Data Access Objects, Access, Sql, Microsoft Excel, Microsoft Office, Powerpoint, Microsoft Word, Ms Access Database, Tableau, Reporting, Alteryx.

Not the Lee Barrett you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.